Glossary of databases
18 The topic of this glossary falls under the field of Database Management and Computer Science. Specifically, it focuses on the fundamental concepts related to databases and their management, including relational databases, NoSQL, transactions, and operatio terms
Hello, my name is Guy Etaba, and I am currently studying database management and computer science. This glossary is designed for students, professionals, and anyone who wants to gain a solid understanding of basic database terminology.
- Alias
- pseudonym is a provisional name assigned to a table or column in order to facilitate a query.
- Atomicity
- A transaction must be either fully successful or canceled, with no incomplete steps
- Commit
- Approve changes made by a transaction in the database.
- CRUD
- The essential functions are: creation, reading, updating and deletion of data
- Data type
- Indicates the kind of information a column can include, such as numbers or words
- Database
- A collection of data, stored in an organized manner
- DMS (Database Management System):
- A computer program that allows the creation and management of databases
- Foreign key
- A key used to connect two tables in a database
- NoSQL
- A database type for unstructured data that does not require a relational model
- operation
- it is a transaction that allows to add modify or delete a data
- primary key
- Uniquely identifies each record in a table
- Query
- A statement taken to obtain or modify information in a database
- Relations
- Interconnections between different tables in a database
- Rollback
- Cancel the changes made by a transaction before they are confirmed
- Schema
- The configuration of a database, including tables and their links
- SQL (Structured Query Language)
- is a language used to manipulate with relational databases
- Transaction
- A set of actions that must be executed as a single unit in a database
- Trigger
- An automatic mechanism that performs an action in response to an event in the database