Stack Overflow
Stack Overflow

Questions tagged [schema-design]

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.

142 questions
1
vote
1 answer

XML Schema Design - source attribute value

I have been asked to document an XML Schema file. I am required to include business and technical descriptions for each of the schema elements. Looking at our guidelines and the W3C XML Schema recommendation, I find myself wondering what exactly the…
Colin McCormick
  • 31
  • 4
1
vote
2 answers

What is meant by modularity in an XML schema?

What is meant by modularity in an XML schema? i.e. given an xsd, what could be done to make it modular?
Rich Ashworth
  • 1,995
  • 4
  • 19
  • 29
1
vote
2 answers

Logging file access with MongoDB

I am designing my first MongoDB (and first NoSQL) database and would like to store information about files in a collection. As part of each file document, I would like to store a log of file accesses (both reads and writes). I was considering…
Ralph
  • 31,584
  • 38
  • 145
  • 282
1
vote
1 answer

Building a many-to-many db schema using only an unpredictable number of foreign keys

Good afternoon (at least around here), I have a many-to-many relationship schema that I'm having trouble building. The main problem is that I'm only working with primary and foreign keys (no varchars or enums to simplify things) and the number of…
user1449855
  • 1,195
  • 2
  • 10
  • 14
0
votes
2 answers

MongoDB data structure with large number internal documents

I am relatively new to MongoDB, and so far am really impressed. I am struggling with the best way to setup my document stores though. I am trying to do some summary analytics using twitter data and I am not sure whether to put the tweets into the…
Lloyd
  • 1,395
  • 6
  • 20
  • 37
0
votes
1 answer

Returning custom fields in MongoDB

I have a mongoDB collection with an array field that represents the lists the user is member of. user { screen_name: string listed_in: ['list1', 'list2', 'list3', ...] //Could be more than 10000 elements (I'm aware of the BSON 16MB…
aartiles
  • 1,439
  • 4
  • 16
  • 31
0
votes
1 answer

Mongo DB collection fields schema best practice

I would like to know how does i have to set up my collections schemas? I mean first i need ,for example, a user object (username,email,password), then i need a field to make users confirm registration so need i to insert all fields when inserting…
itsme
  • 48,972
  • 96
  • 224
  • 345
0
votes
2 answers

Database user table design, for specific scenario

I know this question has been asked and answered many times, and I've spent a decent amount of time reading through the following questions: Database table structure for user settings How to handle a few dozen flags in a database Storing flags in a…
tstyle
  • 748
  • 1
  • 10
  • 23
0
votes
2 answers

Storing flags in a SQL database and working with them in Symfony

I have a set of objects in a DB which can have a number of boolean flags associated with them. The flags will be pre-defined but may flags may be added or removed later. I could store them in a table with FlagID and FlagName. Storing the values of…
Ian Gregory
  • 5,770
  • 1
  • 29
  • 42
0
votes
1 answer

How do I index different sources in Solr?

How do I index text files, web sites and database in the same Solr schema? All 3 sources are a requirement and I'm trying to figure out how to do it. I did some examples and they're working fine as they're separate from each other, now I need them…
Ali
  • 3,568
  • 2
  • 24
  • 31
0
votes
1 answer

Need Cassandra schema

HI Just started to investifate Cassandra and have a bit confusion. Could you suggest schema for following: Schema: email, city, items1[], items2[] Input: cityId, item1, item2 I need: select email where city=cityId and item1 is NOT in items1[]…
Alexey
  • 517
  • 2
  • 10
  • 21
0
votes
5 answers

Design DB structure

I want to create web site with tests. Test contains different questions. It could be textbox, checkbox or radiobutton. I want to store in db questions, answers and users. Here is my thought about tables structure. Users { Id …
Neir0
  • 12,849
  • 28
  • 83
  • 139
0
votes
1 answer

Trying to convert MSWord 2007 document to an XML format

I'm hoping I can forgo the history, but trust me on the following: I have several people who have immediate access to MSWord 2007 We are trying to prep a generic Word document that can be passed from person to person over the course of several…
Justin Carroll
  • 1,362
  • 1
  • 13
  • 37
0
votes
3 answers

How could I have one column store an arbitrary number of "users"

I have a table that stores "Matches" these matches have the following columns: MatchId, TeamA, TeamB, Wager,Winner I want to be able to make TeamA and TeamB return a list of players for each team. The number could be arbitrary for each one, is…
anthonypliu
  • 12,179
  • 28
  • 92
  • 154
0
votes
1 answer

References vs embeds in MongoDB

I'm trying to figure out how to best use MongoDB for a very small and simple use case, but finding the docs somewhat confusing. My document should represent the fact that a user can have many emails. If I follow the documentation the most obvious…
ngw
  • 1,222
  • 1
  • 14
  • 34
1 2 3
…
9 10