RDBMS Design Glossary

A

• ACID in RDBMS Design
• Aggregate function in RDBMS Design
• Attribute in RDBMS Design

B

• B-tree in RDBMS Design
• Backup and recovery in RDBMS Design
• Backup in RDBMS Design

C

• CAP Theorem in RDBMS Design
• Cardinality in RDBMS Design
• Check constraint in RDBMS Design
• Clustered index in RDBMS Design
• Clustered table in RDBMS Design
• Collation in RDBMS Design
• Column family in RDBMS Design
• Column in RDBMS Design
• Column-oriented Database in RDBMS Design
• Composite index in RDBMS Design
• Composite key in RDBMS Design
• Consistency in RDBMS Design
• Constraint in RDBMS Design

D

• data definition language (DDL) in RDBMS Design
• Data dictionary in RDBMS Design
• Data governance in RDBMS Design
• Data integrity in RDBMS Design
• data manipulation language (DML) in RDBMS Design
• Data mart in RDBMS Design
• Data mining in RDBMS Design
• Data model in RDBMS Design
• Data normalization in RDBMS Design
• Data redundancy in RDBMS Design
• Data replication in RDBMS Design
• data types in RDBMS Design
• Data warehouse in RDBMS Design
• Database administrator (DBA) in RDBMS Design
• Database cluster in RDBMS Design
• Database design in RDBMS Design
• Database in RDBMS Design
• Database management system (DBMS) in RDBMS Design
• Database partitioning in RDBMS Design
• Database schema in RDBMS Design
• Database transaction in RDBMS Design
• Datafile in RDBMS Design
• Deadlock in RDBMS Design
• Deadlock prevention in RDBMS Design
• DELETE in RDBMS Design
• Denormalization in RDBMS Design
• derived attribute in RDBMS Design
• descriptive attribute in RDBMS Design
• design pattern in RDBMS Design
• Dimension in RDBMS Design
• discriminator attribute in RDBMS Design
• disjoint specialization in RDBMS Design
• DISTINCT in RDBMS Design
• Distributed database in RDBMS Design
• Document Store in RDBMS Design
• domain in RDBMS Design
• domain, enumerated in RDBMS Design
• DROP CONSTRAINT in RDBMS Design
• DROP TABLE in RDBMS Design

E

• Entity class in RDBMS Design
• Entity in RDBMS Design
• Entity type in RDBMS Design
• entity-relationship (ER) model in RDBMS Design
• Entity-relationship diagram (ERD) in RDBMS Design
• enumerated domain in RDBMS Design
• exclusive specialization in RDBMS Design
• external key in RDBMS Design

F

• FD, partial in RDBMS Design
• FD, transitive in RDBMS Design
• foreign key (FK) in RDBMS Design
• Foreign key constraint in RDBMS Design
• Foreign key in RDBMS Design
• functional dependency (FD) in RDBMS Design
• Functional dependency in RDBMS Design
• Functional dependency preservation in RDBMS Design

G

• generalization in RDBMS Design
• grant in RDBMS Design
• Granularity in RDBMS Design
• Graph Database in RDBMS Design

H

• Hash index in RDBMS Design
• HAVING in RDBMS Design

I

• In-memory database in RDBMS Design
• Index in RDBMS Design
• Inner join in RDBMS Design
• InnoDB in RDBMS Design
• Integrity constraint in RDBMS Design

J

• Join in RDBMS Design

K

• Key in RDBMS Design
• Key-value Store in RDBMS Design

L

• Lock in RDBMS Design
• Logical database design in RDBMS Design
• Logical schema in RDBMS Design

M

• Many-to-many relationship in RDBMS Design
• Master-slave replication in RDBMS Design
• Metadata in RDBMS Design
• Multi-user concurrency in RDBMS Design
• Multi-version concurrency control (MVCC) in RDBMS Design
• MySQL in RDBMS Design

N

• Normal form in RDBMS Design
• NoSQL in RDBMS Design

O

• Object-oriented database in RDBMS Design
• Object-relational database in RDBMS Design
• Oracle Database 12c in RDBMS Design
• Oracle in RDBMS Design
• Outer join in RDBMS Design

P

• Parallel computing in RDBMS Design
• Partitioning in RDBMS Design
• Physical database design in RDBMS Design
• PostgreSQL in RDBMS Design
• Primary key in RDBMS Design

Q

• Query in RDBMS Design
• Query optimization in RDBMS Design

R

• Range partitioning in RDBMS Design
• Read committed isolation level in RDBMS Design
• Recursive query in RDBMS Design
• Referential integrity in RDBMS Design
• Relational algebra in RDBMS Design
• Relational calculus in RDBMS Design
• Relational database in RDBMS Design
• Relational model in RDBMS Design
• Row in RDBMS Design
• Row-level locking in RDBMS Design

S

• Schema in RDBMS Design
• Secondary index in RDBMS Design
• Sharding in RDBMS Design
• SQL in RDBMS Design
• SQL injection in RDBMS Design
• Stored procedure in RDBMS Design
• Structured Query Language (SQL) in RDBMS Design
• Subquery in RDBMS Design
• Sybase in RDBMS Design

T

• Table in RDBMS Design
• Table locking in RDBMS Design
• Table partitioning in RDBMS Design
• Tablespace in RDBMS Design
• Transaction in RDBMS Design
• Transaction log in RDBMS Design
• Trigger in RDBMS Design

U

• Unique constraint in RDBMS Design
• Unique key in RDBMS Design
• User-defined data type in RDBMS Design

V

• View in RDBMS Design
• View materialization in RDBMS Design

W

• Write-ahead logging (WAL) in RDBMS Design

X

• XA transactions in RDBMS Design
• XML database in RDBMS Design

Z

• Zonal partitioning in RDBMS Design