relational database
Linked table system
A relational database organizes data into tables with rows and columns, where relationships between tables are established through shared fields.
This structure allows complex queries across multiple tables: The customer's order history is stored in a relational database.
Most business software relies on relational databases, typically accessed through SQL.
Horizontal furniture surface
- rowLinear arrangement across
- columnVertical structural element
- tupleOrdered finite sequence
- attributeQuality assigned to something
field · record · index · constraint · domain · datatype · null · schema
Transaction property guarantee
- constraintLimiting condition or rule
- transactionExchange of goods/money
- cascadeSuccessive downward flow
- rollbackReturn to prior condition
commit · locking · concurrency · isolation · atomicity · consistency · durability · deadlock
Alphabetical guide to contents
- partitioningDividing into sections
- clusteringForming concentrated groups
- cachingTemporary local storage
- statisticsCollected numerical information
Database manipulation language
- subqueryEmbedded database request
- aggregateCombined sum total
- projectionSomething that extends outward
- predicateSentence's non-subject portion
Adjusting to a standard
- cardinalitySize of a set
- one-to-manySingle source, multiple targets
- many-to-manyPlural associations both directions
- inheritanceProperty received from ancestors
table
Horizontal furniture surface
attribute · field · record · index · constraint · domain · datatype · null · schema · cell
ACID
Transaction property guarantee
- constraintLimiting condition or rule
- transactionExchange of goods/money
- cascadeSuccessive downward flow
rollback · commit · locking · concurrency · isolation · atomicity · consistency · durability · deadlock
index
Alphabetical guide to contents
- partitioningDividing into sections
- clusteringForming concentrated groups
- cachingTemporary local storage
statistics · trigger · sharding · replication
SQL
Database manipulation language
- subqueryEmbedded database request
- aggregateCombined sum total
- projectionSomething that extends outward
normalization
Adjusting to a standard
- cardinalitySize of a set
- one-to-manySingle source, multiple targets
- many-to-manyPlural associations both directions
Oracle
Prophetic shrine or speaker
relational databaseflat file
Single-table data storage
CSV file · text file · plain text · spreadsheet · data lake
relational databaseflat file
Single-table data storage
text file · CSV file · log file · file system
related, relation, relate, relationship, relative, relatives, relations, relatively, relationships