Top "Data-modeling" questions

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

Why many refer to Cassandra as a Column oriented database?

Reading several papers and documents on internet, I found many contradictory information about the Cassandra data model. There are many …

cassandra nosql data-modeling column-oriented wide-column-store
Mysql Datatype for US Zip (Postal Codes)

I am writing a web application, that is US specific, so the format that other countries use for postal codes …

sql mysql database-design data-modeling zipcode
Facebook like notifications tracking (DB Design)

I am just trying to figure out how Facebook's database is structured for tracking notifications. I won't go much into …

mysql database-design data-modeling
Finding the best trade-off point on a curve

Say I had some data, for which I want to fit a parametrized model over it. My goal is to …

algorithm matlab data-modeling model-fitting
Good place to look for example Database Designs - Best practices

I have been given the task to design a database to store a lot of information for our company. Because …

database database-design data-modeling
Is it good database design to have admin users in the same table as front-end users?

I have users who can login on a front-end page, and admins who can login on an admin page. Should …

sql sql-server database database-design data-modeling
Firestore: How to get random documents in a collection

It is crucial for my application to be able to select multiple documents at random from a collection in firebase. …

swift database firebase data-modeling google-cloud-firestore
How to implement has_many :through relationships with Mongoid and mongodb?

Using this modified example from the Rails guides, how does one model a relational "has_many :through" association using mongoid? …

ruby-on-rails activerecord mongodb data-modeling mongoid
What are the principles behind, and benefits of, the "party model"?

The "party model" is a "pattern" for relational database design. At least part of it involves finding commonality between many …

sql database-design orm data-modeling