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
2 answers

Java data modelling - Saving relational data to an interoperable format

I'm working on a J2SE desktop application with some POJO classes which represent data and one-to-many/many-to-many relations between them using ArrayLists. I'm not using an ORM, just managing the data using Collections and using Java's…
bcoughlan
  • 25,987
  • 18
  • 90
  • 141
1
vote
3 answers

Scalable Database System, Critique requested

I'm looking to build a scalable database solution for the back end of my website. I've been reading about database design lately, and I seem to have developed an idea on my own that might work. I think this is a novel way of maintaining n databases…
Mike
  • 58,961
  • 76
  • 175
  • 221
1
vote
4 answers

DB integrity: trigger vs. keys/constraints

I and my friend argued with each other about the design of a database. He argues that to ensure the integrity of a complex database is better to use triggers. I believe that for this purpose is better to use keys (primary, unique), and…
Dmitriy
  • 3,305
  • 7
  • 44
  • 55
1
vote
4 answers

Help with setting up a Database

My site is going to have many products available, but they'll be categorised into completely different sites (domains). My question is, am I better off lumping all products into one database and using an ID to distinguish between the sites, or…
alex
  • 479,566
  • 201
  • 878
  • 984
1
vote
3 answers

Find duplicate content using MySQL and PHP

I am facing a problem on developing my web app, here is the description: This webapp (still in alpha) is based on user generated content (usually short articles although their length can become quite large, about one quarter of screen), every user…
Mike
  • 654
  • 7
  • 18
1
vote
3 answers

Should these be 3 SQL tables or one?

This is a new question which arose out of this question Due to answers, the nature of the question changed, so I think posting a new one is ok(?). You can see my original DB design below. I have 3 tables, and now I need a query to get all the…
transient_loop
  • 5,984
  • 15
  • 58
  • 117
1
vote
2 answers

Is encapsulation required for JavaScript objects?

I'm developing a node.js application. Looking for ways to create the datamodel. The data being sent to/from the client is JSON. Since database is MongoDb, the data to/from the db is JSON. I'm new to JS, I could find so many js libraries dedicated to…
sowdri
  • 2,193
  • 5
  • 23
  • 36
1
vote
1 answer

Is It Okay to Replace a Reference ("Type") Entity FK with BOOLEAN Attributes That Represent Complete Set of Possible Values of That FK?

In attempting to optimize the physical data model by removing joins (denormalizing), I elected to take all of the possible values that a user might specify for CommEventPurposeType, implement them as BOOLEAN attributes in CommEventPurpose, and will…
Cornelius Blackguard
  • 13
  • 2
1
vote
1 answer

How to add "Upgrades" entity to product-order database design?

I'm working on a database design for an e-commerce web application. For this question I am simplifying the design and only showing the parts that are relevant to my question. My things of interest (entities) in this scenario are Products, Upgrades,…
nselikoff
  • 467
  • 4
  • 11
1
vote
2 answers

Google App Engine GAE JPA ManyToMany relationship

I am trying to model my objects in a way that would work both with hibernate JPA and GAE JPA. I have a class Item that has a list of properties. I need to find all the items with specific properties. For example: @Entity public class Item { @Id …
danial
  • 4,058
  • 2
  • 32
  • 39
1
vote
0 answers

OO Design and the data model for change log function

: EJB 3, JPA (EcipseLink) and Oracle Database An application has two entities: Group and Person. There is a one-to-many relationship. The requirement is, that every changes of Group and Person must be saved for later to roll or show. The 1st…
H. Zhang
  • 63
  • 4
1
vote
1 answer

mongodb time series data modeling

Newbe question on how to query MongoDB. I want to take multiple objects received throughout each day and aggregate them together into a single day record. The document structure will eventually contain 365 days worth of data (per year, with a new…
pherris
  • 17,195
  • 8
  • 42
  • 58
1
vote
1 answer

Core Data relationship without inverse when one persistent store is read-only?

I am working on an iOS Core Data model that should use two persistent stores, one of them read-only the other read-write. The read-only store will contain Entities, the read-write store will contain Collections, and there will be a one-to-many…
Drux
  • 11,992
  • 13
  • 66
  • 116
1
vote
1 answer

Product ID with different expiration date

Right now I'm creating an application to manage the inventory. We receive products very often and usually they have different expiration date or price. Example: RECEIPT PROVIDER PRODUCT PRODUCT EXPIRATION DATE PRICE QUANTITY 2125 …
Washu
  • 835
  • 1
  • 9
  • 20
1
vote
1 answer

Cassandra data model improvement

I came across this issue, and I just can't figure out what to do, so say i'm keeping these user actions: Likes Comments Shares Uploads And so on, list goes to around 20 actions, now the best strategy i came up with is to create a single CF let's…
Linas
  • 4,380
  • 17
  • 69
  • 117
1 2 3
…
99
100