schema

Possible to validate xml against xsd using code at runtime c#?

I have xml files that I read in at runtime, is is possible to validate the xml against an xsd file at runtime? using c# ...

Feed aggregator using hbase. How to design the schema?

I am working on a project involving monitoring a large number of rss/atom feeds. I want to use hbase for data storage and I have some problems designing the schema. For the first iteration I want to be able to generate an aggregated feed (last 100 posts from all feeds in reverse chronological order). Currently I am using two tables: F...

Understanding SQL REFERENCES

Recently I've asked a question about the best way to go to design a DB schema to support multiple types of users and interactions between them, one of the answers suggested that I use one table for each user type and Distributed Keys. The thing is the only databases I actively work with are MySQL and SQLite and I've always done this kin...

LDAP attribute to encode the language of human users mother tongue?

What would be the canonical attribute in an LDAP schema to encode the mother tongue (first language) of a user? Interop with default/existing administration tools for Windows Active Directory would be a big plus. ...

Automated Oracle Schema Migration Tool

What are some tools (commercial or OSS) that provide a GUI-based mechanism for creating schema upgrade scripts? To be clear, here are the tool responsibilities: Obtain connection to recent schema version (called "source"). Obtain connection to previous schema version (called "target"). Compare all schema objects between source and targ...

XML Schema: Different Element Names (sequence)

I think the solution to my problem is very easy, but i couldn't fint it So, here is: I have an XML which have a list of elements with different names, but in sequence. An example: <DOC> <DOC_OBL_1> <TIP_DOC_OBL>1</TIP_DOC_OBL> </DOC_OBL_1> <DOC_OBL_2> <TIP_DOC_OBL>2</TIP_DOC_OBL> </DOC_OBL_2> <DOC_OBL_3> <TIP_DOC_OBL>3</...

JPA using multiple database schemas

I'm having a bit of trouble with one particular issue using JPA/Spring: How can I dynamically assign a schema to an entity? We have TABLE1 that belongs to schema AD and TABLE2 that is under BD. @Entity @Table(name = "TABLE1", schema="S1D") ... @Entity @Table(name = "TABLE2", schema="S2D") ... The schemas may not be hardcoded in an ...

Multi-Tenant Tag Schema's for Distributed Content Types

There's quite a bit of discussion out there, regarding tag schema's, but I've noticed that most of it focuses on a single content type, such as bookmarks or photos. I'm interested in using tags across multiple features of a multi-tenant business app; one where tags could be related to form fields, documents, photos, configuration sett...

Should I use the default dbo or a custom schema for common tables in multi-tenant database?

I have a database that's going to record data for different customers. Most of the customers have the same data requirements; however, that's not always the case. For the different requirements, I'm going to create extension tables that are going to be specific for their needs. For each customer, I'm going to create a schema and I will t...

Compare 2 database schemas on Mysql

I have 2 schemas in a database about the same application (Different versions) I want to generate a Delta script with the differences It exists some tool that helps me (Open source solution should be perfect) Thank you ...

multi_schema and side effect problems

I am working on a project in which we need to define agencies in other cities. We have the same application but separate database schema for each agency. I used one session factory. For each request we get the person's username and therefore we can recognize which agency they belongs to. We change the PostgreSQL search_path for that....

Database localization

Hi, I have a number of database tables that contain name and description columns which need to be localized. My initial attempt at designing a DB schema that would support this was something like: product ------- id name description local_product ------- id product_id local_name local_description locale_id locale ------ id locale ...

Twitter name length in DB

I'm adding a field to a member table for twitter names for members on a site. From what I can work out the maximum twitter name length is 20 so it seems obvious that I should set the field size to varchar(20) (SQL Server). Is this a good idea? What if Twitter starts allowing multi-byte characters in the user names? Should I make this f...

Does the sequence schema element guarantee order of child elements?

Given this xml schema (fragment): <xs:element name="GetIEnumerableResponse"> <xs:complexType> <xs:sequence> <xs:element minOccurs="0" name="GetIEnumerableResult" nillable="true" xmlns:q4="http://schemas.microsoft.com/2003/10/Serialization/Arrays" type="q4:ArrayOfstring" /> </xs:sequence> </xs:complexType> </xs:element>...

Ruby Railroad diagram generator fails with NoMethodError for [] in Enumerable::Enumerator

Hi everone, I'm trying to generate model diagrams using the railroad gem. I have managed to generate a diagram for a different app, but I'm trying to get my head around some "legacy" code, and keep running into problems. I know very little about ruby or rails, so any help would be appreciated... Basically, I run: $ railroad -v -M ...

XML Schema Key with multiple fields

I have an XML file format that contains a structure of questions: <question id="q101"> <text>Do you like the color red?</text> <answer>yes</answer> <answer>no</answer> </question> <question id="q102"> <text>What is your favorite color?</text> <answer>red</answer> <answer>blue</answer> <answer>white</answer> <answer>yello...

VERY huge SQL Database: How should the schema look like?

I have 2 files that I'd like to import into MS SQL. The first file is 2.2 GB and the second file is 24 GB worth of data. (if you are curious: this is a poker related look up table) Importing them into MS SQL is not a problem. Thanks to SqlBulkCopy I was able to import the first file in just 10 minutes. My problem is, I don't know how th...

Ruby on rails database schema help

Hay guys, I'm a novice to intermediate RoR programmer. However, I'm not too good on setting up relational database's so i need a hand. Basically my app is a book club. A user signs up, the user creates a book club based on a book. Other users joins this club and discusses it (like a forum). I have written a english description of the s...

LinqToXml does not handle nillable elements as expected

According to W3C standards, if you have a nillable element with a nil value, you are supposed to format it like this: <myNillableElement xsi:nil="true" /> But if you use this LinqToXml statement... element.Add( new XElement(ns + "myNillableElement", null); ...the resulting XML is... <myNillableElement /> ...which is invalid....

xpath to xsd definition

I am looking for a way to take a xpath for an instance xml file and use it to find the xsd element. If possible are there any xsl or .net examples? ...