Articles Index
Fact Table
What is a fact table in business intelligence? Find out in the About Databases Glossary!
Dimension
What is a dimension in business intelligence? Find out in the About Databases Glossary!
Entity-Relationship Diagram
What is a database? Find out here!
Database Index
What is an index? Find out here!
BASE Model for Databases
The BASE Model of database development enforces three principles: Basic Availability, Soft state and Enhanced consistency. It is used primarily by unstructured databases, such as NoSQL.
NoSQL Databases
NoSQL databases abandon the relational model in favor of the key/value store approach where the database uses a simple hash function to assign each key/value pair to a database server for later retrieval. NoSQL does not provide transactional functionality but it does allow for the efficient storage and retrieval of simple unstructured information.
Foreign Key
What is a foreign key? Find out here!
Referential Integrity
What is Referential Integrity? Find out in our database glossary!
Data Definition Language
Looking for a definition of data definition language (DDL)? Find it here in the About Databases glossary.
One-to-One Relationships
Looking for a definition of one-to-one database relationships? Read our definition in the About Databases glossary!
One-to-Many Relationships
Looking for a definition of one-to-many database relationships? Read our definition in the About Databases glossary!
Many-to-Many Relationships
Looking for a definition of many-to-many database relationships? Read our definition in the About Databases glossary!
Database Relationships
Looking for a definition of a database relationship? Check out the About Databases glossary definition!
Multivalued Dependency
What is a multivalued dependency? Find out here!
Transitive Dependency
What is a transitive dependency? Find out here!
Full Functional Dependency
What is a full functional dependency? Find out here!
Trivial Functional Dependency
What is a trivial functional dependency? Find out here!
Functional Dependency
What is a functional dependency? Find out here!
Resource Governor
Looking for a definition of Resource Governor? Check the About.com Databases Glossary!
SQL Agent
What is SQL Agent? Find out in the About Databases glossary.
SQL Profiler
What is SQL Profiler? Find out in the About Databases glossary.
Database Engine Tuning Advisor
What is Database Engine Tuning Advisor? Find out in the About Databases glossary.
Compound Key
What is a compound key? Find out in the About Databases glossary!
Primary Key Definition
What is a primary key? Find out here!
NOT NULL Constraints
Looking for a definition of NOT NULL constraints? Find it in the About Databases glossary!