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.

What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

database database-design data-modeling identifying-relationship
What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone

What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone. considerations: + for country code () …

sql-server validation database-design data-modeling phone-number
Recommended SQL database design for tags or tagging

I've heard of a few ways to implement tagging; using a mapping table between TagID and ItemID (makes sense to …

sql database-design tags data-modeling tagging
Tools to generate a database diagram/ER diagram from existing Oracle database?

Looking for tools (windows platform) to genereate ER diagram (or similar) from an existing Oracle database. Any good tools out …

oracle data-modeling reverse-engineering documentation-generation er-diagram
Are soft deletes a good idea?

Are soft deletes a good idea or a bad idea? Instead of actually deleting a record in your database, you …

sql database database-design data-modeling soft-delete
What should I name a table that maps two tables together?

Let's say I have two tables: Table: Color Columns: Id, ColorName, ColorCode Table: Shape Columns: Id, ShapeName, VertexList What should …

sql database database-design naming-conventions data-modeling
What's the best way to model recurring events in a calendar application?

I'm building a group calendar application that needs to support recurring events, but all the solutions I've come up with …

ruby algorithm calendar data-modeling recurrence
Forward Chaining vs Backward Chaining

What is one good for that the other's not in practice? I understand the theory of what they do, but …

artificial-intelligence data-modeling prolog drools datalog
Data Modeling with Kafka? Topics and Partitions

One of the first things I think about when using a new service (such as a non-RDBMS data store or …

apache-kafka apache-zookeeper data-modeling
Modeling Tool for NOSQL Databases

I know that most of the time NOSQL databses are schema-less or at least have a flexible database schema. However, …

database database-design data-modeling nosql