Stack Overflow
Stack Overflow

Questions tagged [data-modeling]

Data modeling questions refer to the techniques used to gather and analyze data requirements needed to support data operations in programs and systems.

Data modeling consist of gathering requirements and knowledge about the data needed to solve a given problem, and elaborating abstract data structures for the purpose of designing and implementing standardised data formats, databases and data processing systems.

Data-modeling is a specialized kind of modeling solely focused on passive data structures, and independent of the description of the processing of that data.

3039 questions
1
vote
1 answer

Difference between composite entity and attributed relationship

I am going through and solidifying my knowledge of the entity relationship modeling terminology. My question is what is the difference between a composite entity and an attributed relationship? To me they seem like they are one and the same.
BlueChameleon
  • 924
  • 1
  • 10
  • 36
1
vote
1 answer

How to model this parent-child hierarchy in C++?

I want to create a general abstract TimePeriod class. Example subclasses of it would be be Day, Hour and Minute. I also want to create a general TimeData class that associates a TimePeriod object with some data, such as two doubles for the lowest…
7cows
  • 4,974
  • 6
  • 25
  • 30
1
vote
1 answer

Data modeling : gas station managing

I need to create a database to manage a gas station. I'm thinking of a basic product inventory and sales data model, but it need some changes. See http://www.databaseanswers.org/data_models/inventory_and_sales/index.htm. This is how they proceed:…
user1656898
  • 13
  • 3
1
vote
7 answers

Should I break 1 table out to many if it will be hit often?

Right now I have a table for Photos. I expect this table to be hit a lot. Will I improve performance if I break it out into 3 tables if, for exmaple, I have 3 different types of photos? Or will this not improve performance?
donde
  • 351
  • 5
  • 12
1
vote
2 answers

Activity list ala SO

We are building a set of features for our application. One of which is a list of recent user activities ala on SO. I'm having a little problem finding the best way to design the table for these activities. Currently we have an Activities table with…
Micael
  • 6,950
  • 6
  • 25
  • 28
1
vote
1 answer

RESTful URI's, Creating a new noun/uri or add a queryparameter

I have a Person class with a one to many relationship to Employment. A Person in the CRM can have multiple Employments (historic data). My current REST URI for this class looks like this: http://domain/persons GET…
Simon
  • 1,643
  • 7
  • 30
  • 61
1
vote
1 answer

Core Data Request issue

I've a data model and i have an issue for executing a request. Here's my model : I would like to get all the expenses associated to one specific event. Do you think that my model is wrong ? For more explanations this is how i set my data in the…
Pwyll28
  • 117
  • 11
1
vote
5 answers

Max Tables & Design Pattern

I am working on an app right now which has the potential to grow quite large. The whole application runs through a single domain, with customers being given sub-domains, which means that it all, of course, runs through a common code-base. What I am…
Brandon Hansen
  • 816
  • 1
  • 10
  • 17
1
vote
5 answers

Is there any site where to look for a data modeling inspiration?

Here's my problem: I'm about to design and implement quite a big sales module on top of an existing business (web) application. What I need is basically this - a complete e-commerce layer without the public part of it (I don't need a cart, payment…
Milan Novota
  • 15,506
  • 7
  • 54
  • 62
1
vote
2 answers

Modeling A Book With Ruby on Rails Active Record

Im modeling an online book with ruby on rails. The book has chapters, each chapter has pages. Modeling this part is easy. What id like to do is keep track of what pages each user has read and when and whether they liked that page / whether the user…
LMH
  • 949
  • 9
  • 22
1
vote
2 answers

mysql - user item ratings, 1 rating per user, updateable - table structure?

I'd like to give my users the ability to rate each item on the site from 1 to 5. They also must be able to go back and revise their rating for each item as they please. Lastly, the item's page will display the average-to-date of all user ratings…
Drew
  • 6,208
  • 10
  • 45
  • 68
1
vote
0 answers

Model design pattern for google app engine

I am building an app on google app engine which has three different kind of Users(ABC,LMN,XYZ). This is how my model looks like User(db.Model): email = db.EmailProperty() username = db.StringProperty() password = db.StringProperty() …
Sandeep
  • 803
  • 8
  • 25
1
vote
1 answer

Datastructure to store an nested element in JSON

I am modelling classes in Java to store a JSON , for a particular JSON "id":1, "firstName":"sample", "lastName":"person", "Books":{ "bookName":"gone with the wind" "isbn": 12345 } I created a class person with int id , String…
Rahul Kumar
  • 399
  • 3
  • 8
  • 24
1
vote
3 answers

trying to figure out the best database schema

I want to come up with a generic schema (if possible) to use for a number of different events that I am managing. These events can be weddings, birthday parties, etc. So far I have 3 main tables: Contact Table - the usual info like address, phone,…
leora
  • 188,729
  • 360
  • 878
  • 1,366
1
vote
1 answer

What's the best NoSQL DBMS for this use case?

Before I ask my question, a little background about our problem. We are developing a government revenue projection application. At this application, we collect data about previous revenue, apply several econometric and political projection models…
Carlos Melo
  • 3,052
  • 3
  • 37
  • 45
1 2 3
…
99 100