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
4
votes
5 answers

Oracle Schema Design: Seperate Schema with I/O Overhead?

We are designing database schema for a new system based on Oracle 11gR1. We have identified a main schema which would have close to 100 tables, these will be accessed from the front end Java application. We have a requirement to audit the values…
Guru
  • 2,331
  • 6
  • 31
  • 48
4
votes
1 answer

What is the correct mongo schema design for a job queue?

I would like to implement a job queue in Mongo. The entire software system is based around Mongo so it seems natural and potentially a good fit. The jobs collection stores each job state as a document. I imagine this to be an uncapped collection…
abargnesi
  • 341
  • 4
  • 13
4
votes
0 answers

Django model inheritance vs composition, and querying multiple models/tables together

I have a Django app that has a number of different models, all with a bunch of common data. Ultimately, I think this question comes down to a decision between inheritance and composition. My current implementation is something like this: class…
3
votes
1 answer

MongoDB Schema Design . can't get what i want

i think i have a problem with my schema design for my music app. i have 3 collections: Artists, Tracks and Albums. and 3 classes: artists, albums and tracks document from artists: [_id] => MongoId Object ( [$id]…
Pinokyo
  • 546
  • 1
  • 7
  • 15
3
votes
3 answers

Mongo DB schema designing problem

I m designing a mongo db schema for a site like stackoverflow. There are questions and users. Users can add questions to their favorite list and they can search for a question within the favorite list. I have 2 collections, as Users and Questions.…
Amila
  • 2,779
  • 1
  • 27
  • 31
3
votes
3 answers

Database design one to many where many is at least one

Somewhat related to my previous question, this is regarding creation patterns to enforce table patterns where 'A' has many 'B' children where 'C' is the table of child 'B's for 'A', but has at least ONE. Currently I have: A (A_ID primary key, B_ID…
meandmycode
  • 17,067
  • 9
  • 48
  • 42
3
votes
2 answers

How to represent one-to-one relationship in App Engine

Say you have a concept of "user" records that you'd like to store in the data store. class User (db.Model): first_name = db.StringProperty() last_name = db.StringProperty() created = db.DateTimeProperty(auto_now_add=True) twitter_oauth_token…
ʞɔıu
  • 47,148
  • 35
  • 106
  • 149
3
votes
5 answers

PostgreSQL schema design

What is your preferred way of designing PostgreSQL schemata? Would you recommend the use of specific graphical design tools or just design the schema on paper and create everything by hand?
akosch
  • 4,326
  • 7
  • 59
  • 80
3
votes
1 answer

schema design for cassandra

I am working on a project of forum that allows a user to follow questions on certain topics from his network. A user's news-feed wall comprises of only those questions that have been posted by his connections and tagged on the followed topics. I am…
Aklin
  • 2,621
  • 2
  • 17
  • 17
3
votes
1 answer

Schema less SQL database table - practical compromise

This question is an attempt to find a practical solution for this question. I need a semi-schema less design for my SQL database. However, I can limit the flexibility to shoehorn it into the entire SQL paradigm. Moving to schema less databases…
Noufal Ibrahim
  • 71,383
  • 13
  • 135
  • 169
3
votes
2 answers

Graph database schema design - Is this suitable for neo4j?

Scenario: a simple address book where a user can create his own contacts and organize them by adding them in groups. A contact may have multiple addresses. I have created the following diagram: ![schema-design][1] I want to query all the contacts…
Moody
  • 851
  • 2
  • 9
  • 23
3
votes
4 answers

HBase performance with large number of dynamically generated column qualifiers (within a column family)

I have a table with 1 column family called 'A'. On runtime, I will insert the (Key-Value) pair to the table. Leave the RowKey away, in my design, Column qualifier is MD5(Key) so, column qualifers are dynamically created, and the cell will contains…
William Truong
  • 237
  • 3
  • 12
3
votes
2 answers

Suggestions on how to organize Core Data visual layout?

Core Data is pretty amazing, and I've really enjoyed using the visual layout Xcode provides for it to organize things and get a quick sample of what data I've placed where. At times I've started to wonder if I'm making the best use of it, however,…
Kaji
  • 2,220
  • 6
  • 30
  • 45
3
votes
1 answer

MongoDB Schema Design (nested array vs separate collection)

I'm writing client management web application. I'm trying to figure out the right way to manage my clients-payments relations. Once a day application is sending request to another API and synchronizing amount of payments for each client which I…
Sergey Tsibel
  • 1,595
  • 1
  • 18
  • 31
3
votes
2 answers

MongoDB query by foreign key

I have two collections: USERS: { id:"aaaaaa" age:19 , sex:"f" } { id:"bbbbbb" age:30 , sex:"m" } REVIEWS: { id:777777 , user_id:"aaaaaa" , text:"some review data" } { id:888888 , user_id:"aaaaaa" , text:"some review data" } { …
Om Solari
  • 207
  • 1
  • 4
  • 13
1 2
3
9 10