Database
336 views
Data Modeling
Quick Definition
Creating a model describing data structure and relationships
Full Definition
Creating a model describing data structure, relationships, and constraints.
Examples
ER diagrams, schema design, entity relationships
Related Terms
normalization
schema-design
More Database Terms
Database Connection
Communication channel between application and database server
Transaction
Single unit of work that succeeds or fails completely
Stored Procedure
Precompiled SQL stored in the database for execution
Relational Database
Database storing data in structured tables with relationships
Foreign Key
Field referencing primary key to establish table relationships
Materialized View
Physical stored copy of query results refreshed periodically