Concerned with design of properties and their hierarchy to represent an entity in a specific format. It can be JSON Schema, XML Schema, SQL Schema etc. Usually used to discuss database schemas.
Questions tagged [schema-design]
142 questions
1
vote
1 answer
Is renaming a XSD/WSDL type backward compatible in WS?
I posted another question about same thing with different approach:
extending type.
My problem is basically that I made stupid choice with type naming in XSD and question is what happens if I change a type name in schema? The XML my new client…
char m
- 7,840
- 14
- 68
- 117
1
vote
2 answers
Is modifying existing XSD type by extending it from exact same type backward compatible?
I made earlier XSD+WSDL for a WS that is implemented by a customer. We implement the client. I have type like this in WS Create-operation:
char m
- 7,840
- 14
- 68
- 117
1
vote
2 answers
Cassandra (CQL) schema/tables look the same as RDBMS for my scenario
I have looked at the Twissandra examples. I asked a similar question regarding this a few days back and received some tips I implemented here. However, by looking at the tables (column families) I see barely any difference between this and a…
Moody
- 851
- 2
- 9
- 23
1
vote
1 answer
Inheritance in XML Schema definition (XSD) for Java objects
I need to create an XML schema definition (XSD) that describes Java objects.
I was wondering how to do this when the objects in question inherit from a common base class with a type parameter.
public abstract class Rule { ... }
public abstract…
bguiz
- 27,371
- 47
- 154
- 243
1
vote
1 answer
XML Schema Design: restrict the occurrence of an element according to its position in the document
Hello I came across a problem regarding to restrict the occurrence of an element according to its position in the document. Actually "position" might not be a proper term but I couldn't think of a better way to summarise the problem.
Anyway let me…
Yingdong Zhang
- 62
- 1
- 7
1
vote
1 answer
Monthly Reports in Django - Enforce uniqueness for month?
This is a fairly quick question regarding schema design for a Django project.
Basically, we have a series of monthly reports from different departments that are aggregated into a single report with some pretty charts (we're probably going to use…
victorhooi
- 16,775
- 22
- 90
- 113
1
vote
2 answers
HBase - How to Nest Entities Two(+) Levels Deep in a Table?
I was reviewing this slide show [slide 134] (Ian Varely/salesforce.com at HBase Con 2012) where he states that you can nest entities two levels deep.
Here is an example he gives of nesting an entity one level deep:
Entities: Band, Shows; where Band…
Matthew Moisen
- 16,701
- 27
- 128
- 231
1
vote
1 answer
Relational schema design: "two-to-one" relationship or "backward delete cascade"
Suppose I have the following schema (just an example) where each customer has
exactly two phone numbers with distinct purposes:
create table customer (
id integer primary key,
home_phone_id integer not null,
work_phone_id integer not…
user3385621
- 11
- 3
1
vote
1 answer
SQL server schema change
I have a local copy of a sql server 2008 database. I'd like to know if any tables or views, schemas - not data, are out of sync with the copy on the server. Is there any easy ways to find out?
user2429448
- 541
- 1
- 5
- 14
1
vote
3 answers
The Ruby community values simplicity...what's your argument for simplifying a db schema in a new project?
I'm working on a project with developers who have not worked with Ruby OR Rails before.
They have created a schema that is too complicated, in my opinion. The schema has 117 tables, and obtaining the simplest piece of information would require…
btelles
- 5,390
- 7
- 46
- 78
1
vote
2 answers
JSON Schema: represent constraint to encode object type in string type
In my JSON serialized data I have nested objects:
{
"A" : { "A1": 1,
"A2": 2 },
"B" : { "B1": 3,
"B2": 4 }
}
Due to given constraints I cannot influence, I need to flatten the structure. This means, every object with a depth…
Mahoni
- 7,088
- 17
- 58
- 115
1
vote
1 answer
cant come up with a good mongodb schema
I am solving this problem:
I am building an IMGUR clone, where users can upload images and there is a 'latest uploads' page that shows the last 1000 uploaded images.
users can upload pictures as soon as they sign up, but
until the user verifies…
mkoryak
- 57,086
- 61
- 201
- 257
1
vote
1 answer
Cross-referencing foreign keys in Django 1.4
I have a Django project where I would need two models to have a foreign key to each other. However this is not possible because two Python files would have to import each other which Python doesn't allow. What is the best way to solve this…
Scintillo
- 1,634
- 1
- 15
- 29
1
vote
1 answer
BizTalk Schema development - hexadecimal value 0x19, is an invalid character
I have a Schema element node as below
Employees eligibility for a benefit granted by a banking department agency of security.
while I'm developing the schema for this node, I found the warning as
warning BEC2004: '',…
Software Enginner
- 675
- 2
- 14
- 43
1
vote
2 answers
Where should I put activities timeline in mongodb, embedded in user or separately?
I am building an e-learning app, and showing student activities as a timeline, should I embed them in the user collection, or create a separate collection with an userId.
Constraints:
One to many relationship.
User activities are detailed and…
TiansHUo
- 8,509
- 7
- 45
- 57