database design

Structuring stored information

Database design is the process of structuring how data will be stored, organized, and accessed in a database system.

It involves defining tables, fields, relationships between data elements, and constraints that ensure data integrity.

Good database design minimizes redundancy and supports efficient queries: The database design took weeks to finalize before we could start building the application.

Related

concurrency control · access control · redundancy · decomposition · data integrity · sharding · indexes · data retrieval · rows · columns · joins · fields · lookup table · queries · constraints · architecture · keys · star schema

Opposites
planning vs implementation

database designcoding

Writing software instructions

data entry · application development

structured vs unstructured approaches

database designNoSQL

Schema-free database systems

structure versus chaos

database designdenormalization

Planned database redundancy

Family

design, database, databases, data-driven, databank, data management, data modeling

Familiarity
Top 500,000
Profile
Used worldwide · Timeless · Rated G