DBMS
Structured information keeper
DBMS stands for database management system—software that creates, organizes, and controls access to databases.
It handles storage, retrieval, and modification of data while managing security, backup, and concurrent access by multiple users.
Common examples include MySQL, Oracle, and PostgreSQL.
The company upgraded their DBMS to handle increased traffic.
Database manipulation language
- tablesFlat-topped furniture pieces
- schemaOrganized representational structure
- normalizationAdjusting to a standard
- joinConnect or enlist
relational · records · fields · rows · columns · constraints · triggers · views
Transaction property guarantee
- commitBind to a course
- rollbackReturn to prior condition
- concurrencyOverlapping execution of tasks
- lockingFixing firmly in position
isolation · atomicity · durability · consistency · deadlock · logging · recovery · checkpoint
Concerning connections between things
- NoSQLSchema-free database systems
- document-orientedStoring data as files
- key-valueData pair structure
- columnarShaped like a pillar
Prophetic shrine or speaker
Combined sum total
Systematic organization for retrieval
- B-treeSelf-balancing tree structure
- catalogOrdered list of items
- partitioningDividing into sections
- replicationAct of duplicating precisely
sharding · clustering · caching · backup · middleware
SQL
Database manipulation language
- tablesFlat-topped furniture pieces
- schemaOrganized representational structure
- normalizationAdjusting to a standard
join · relational · records · fields · rows · columns · constraints · triggers · views · cardinality
ACID
Transaction property guarantee
- commitBind to a course
- rollbackReturn to prior condition
- concurrencyOverlapping execution of tasks
locking · isolation · atomicity · durability · consistency · deadlock · logging · recovery · checkpoint · serialization
relational
Concerning connections between things
- NoSQLSchema-free database systems
- document-orientedStoring data as files
- key-valueData pair structure
columnar · object-oriented · in-memory · time-series · hierarchical
Oracle
Prophetic shrine or speaker
aggregate
Combined sum total
indexing
Systematic organization for retrieval
- B-treeSelf-balancing tree structure
- catalogOrdered list of items
- partitioningDividing into sections
replication · sharding · clustering · caching · backup · middleware