Knowra Database Database A database is an organized collection of data designed for efficient storage, retrieval, and updating. Its structure and rules support reliable access by people or software.
Database schema : A formal description of a database’s structure, including its data types, relationships, and constraints. The schema specifies how this database’s data is organized and which rules it must satisfy.
SQL : A language for defining, querying, and modifying data in relational database systems. SQL expresses many operations used to retrieve and update this database’s data.
Relational database : A database that organizes data into relations, commonly represented as tables, and supports structured queries. This is a major database model, especially suited to structured data and explicit relationships.
Database management system : Software that defines, creates, queries, updates, and administers databases. A DBMS provides the software environment in which this database is managed.
Data integrity : The accuracy, consistency, and completeness of data throughout its lifecycle. Constraints and transaction rules help preserve the integrity of this database’s contents.
Table (database) : A database structure that arranges related records into rows and fields into columns. Tables are a common way to divide this database’s information into structured collections.
Database transaction : A unit of database work treated as a single logical operation, with defined success or failure behavior. Transactions group related changes so this database does not leave partial updates after failure.
Document-oriented database : A database that stores data as documents, often with flexible or nested structures. Document storage contrasts with rigid table schemas when records vary in shape.
Data warehouse : A system that consolidates data for analysis and reporting, often from multiple sources. A warehouse is a database designed chiefly for analytical queries rather than routine transactions.
Data consistency : The condition in which data obeys defined rules and presents compatible values across operations or copies. Database guarantees determine when updates appear consistently across records and replicas.
Show all 30