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
2
votes
0 answers
Meaning of Column properties in SQuirreL SQL
I am using SQuilrreL SQL to connect to a local MySQL server, and am looking at the specification of the Columns of some table. At the same time I'm looking at the specification of the same table directly in MySQL (MySQL Workbench), and obviously,…
OferBr
- 297
- 2
- 13
2
votes
1 answer
How to make a schema.ini - help needed
Morning,
I am new to this so just need a quick hand on how to create a schema.ini file.
I need to have 2 cols, one for the product sku, which is a string value. And one for the price, which is a decimal value.
I currently have the following in my…
thatuxguy
- 2,418
- 7
- 30
- 51
2
votes
1 answer
MongoDB Schema Design ordering service
I have the following objects Company, User and Order (contains orderlines). User's place orders with 1 or more orderlines and these relate to a Company. The time period for which orders can be placed for this Company is only a week.
What I'm not…
Gaz
- 1,249
- 3
- 19
- 37
2
votes
1 answer
Opinion on my case MongoDB schema design
This is a pretty common question on MongoDB: When to embed and when to reference.
However in my case, this appears to be somehow a dilemma. I have a document that have a reference where I could just embedded it, yet it will cost me the size of the…
user905864
2
votes
3 answers
how do I do 'not-in' operation in mongodb?
I have two collections - shoppers (everyone in shop on a given day) and beach-goers (everyone on beach on a given day). There are entries for each day, and person can be on a beach, or shopping or doing both, or doing neither on any day. I want to…
Shekhar
- 67
- 1
- 7
1
vote
2 answers
Best way to design database tables with interbase?
I am about to start redoing a company database in a proper fashion. Our current database is a mess and has little to no documentation. I was wondering what people recommend to use when designing an Interbase database? Is there some sort of good…
kgrad
- 4,672
- 7
- 36
- 57
1
vote
1 answer
XML element unique id Schema repersentation
My XML looks likes this :
Larsen
Smith
Sam
How to write a xml schema so that employee element is defined such a way that each employee…
Larsen Smith
1
vote
1 answer
Valueless Column Technique in Cassandra - Database Schema
I'm using Cassandra 0.8.2
I am attempting to use the "valueless column" technique to set up my cassandra schema. The idea behind the valueless column is the following: The name of your column becomes the relevant information & the value of the…
Henry
- 926
- 2
- 12
- 27
1
vote
2 answers
MongoDB schema design - reference vs embedding
I am writing a simulation which requires a backing database to store the results. The simulation writes a huge amount of data. For obvious performance reasons, I chose to try out a NoSQL database, specifically MongoDB. However, I'm a bit puzzled…
user315648
- 1,945
- 3
- 22
- 30
1
vote
2 answers
XML Schema: Permit a tag only if another optional tag is provided
I'm trying to define an XML schema that has an optional tag, sort_expression. If that optional tag is provided, then a second optional tag, alternate_sort_expression is allowed, but it is conditional on the existence of the first tag.
For example, I…
Dusty Phillips
- 113
- 1
- 4
1
vote
1 answer
XML Schema validation - intra-field validation
This is the scenario/problem I am trying to solve - Within a sequence of elements in my XSD I have an element- say XYZ which can be nillable if the one of the preceding element - say ABC - has a certain value - say "Alpha". If that preceding…
GilliVilla
- 4,998
- 11
- 55
- 96
1
vote
3 answers
Database design - Multiple 1 to many relationships
What would be the best way to model 1 table with multiple 1 to many relatiionships.
With the above schema if Report contains 1 row, Grant 2 rows and Donation 12. When I join the three together I end up with a Cartesian product and result set of…
Pixelated
- 1,531
- 3
- 15
- 35
1
vote
1 answer
MySQL database performance tuning, schema optimisation
I have a MySQL database with a pretty simple schema. There are parent, child and access tables.
parent stores 51 fields that are all varchar (ranging in length from 16 to 512) except for for 4 longtext fields and the primary key which is a bigint. …
Wodin
- 3,243
- 1
- 26
- 55
1
vote
2 answers
Purpose of defining an attribute globally in XSD
In XSD it is possible to define an attribute right under the schema element, like I have defined someAttr in the XSD below:
Rahul Khimasia
- 473
- 12
- 24
1
vote
1 answer
Database schema design for privacy settings
We have an application in which we have privacy settings custom for field wise. So if we have three fields namely Address,Email,Contact then on each there is privacy setting either public or private . Now of course there are many fields around 10. I…
Sachin Sharma
- 407
- 5
- 20