Discover published sets by community

The process of constructing and using a data warehouse—a central repository of integrated data from one or more disparate sources.

An abstract model that organizes elements of data and standardizes how they relate to one another and to the properties of real-world entities.

Online Analytical Processing, a category of software tools that provide analysis of data stored in a database.

A set of properties that guarantee database transactions are processed reliably (Atomicity, Consistency, Isolation, Durability).

A database optimization technique that allows for faster retrieval of records from a database table.

Online Transaction Processing, a class of systems that facilitate and manage transaction-oriented applications, primarily for data entry and retrieval transaction processing.

The theorem stating that a distributed computer system cannot simultaneously guarantee all three of the following: Consistency, Availability, and Partition tolerance.

The process of structuring a database to reduce data redundancy and improve data integrity.

A set of SQL statements that can be stored in the database and executed on demand to perform a specific task.

A unique identifier for a record in a database table, cannot contain null values.

A procedural code that is automatically executed in response to certain events on a particular table or view in a database.

A non-relational database that allows for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.

Structured Query Language, a language designed for managing and querying data in relational database management systems.

Database Management System, software for creating, managing, and using databases.

A virtual table whose contents are defined by a query, which can come from one or more underlying tables.

An outline of a database's logical structure, which includes the structure of the objects within it.

A structured set of data held in a computer, especially one that is accessible in various ways.

Entity-Relationship Model, a conceptual representation of data that defines the structure and the relationships between data.

A type of data model that structures data into tables, known as relations, which are made up of columns and rows.