"A database is an organized collection of data (also known as a data store) stored and accessed electronically through the use of a database management system."
The use of software to organize, store, manage and retrieve data efficiently and effectively.
Data modeling: A process of designing the database structure, entities, attributes and relationships between them.
SQL (Structured Query Language): A language used to interact with databases, to perform different operations like creating, modifying or deleting data within the database.
Database indexing: A way to optimize the performance of database queries by organizing data for efficient retrieval.
Normalization: A process of organizing database tables and minimizing redundancy in data by breaking down data into smaller tables.
ACID properties: Properties that ensure transactions are reliable, consistent, and maintainable in database systems.
Distributed database management system: A system that enables data to be stored on multiple computers over a network and provides centralized control.
Data warehousing: A process in which data is collected from different sources and stored in a central repository for easy access and analysis.
Data mining: The process of analyzing data from different sources in order to extract patterns and insights for making decisions.
Big data management: A way to manage extremely large and complex datasets that cannot be handled by traditional database systems.
Parallel and distributed processing: A technique used to improve the performance of database systems by dividing processing tasks between multiple processors or computers.
Object-oriented database management system: A system that stores data as objects, rather than in traditional database format, and enables more flexible data manipulation.
NoSQL (not only SQL) databases: Databases that do not adhere to the traditional relational database model, and are used to store and manage unstructured or semi-structured data.
Cloud-based database management: A way to store, manage and access databases using a cloud computing service, which provides more flexibility and scalability.
Graph databases: A type of NoSQL database that stores data and relationships between them as nodes and edges, and is commonly used in social media and recommendation systems.
Data visualization: The process of presenting data in a visual format, like graphs or charts, for easy understanding and analysis.
Relational Database Management Systems (RDBMS): The most common type of database management system; organizes data into tables with predefined relationships.
Object-Oriented Database Management Systems (OODBMS): Stores data as objects, allowing for more complex relationships and inheritance.
NoSQL Database Management Systems: Non-relational databases that are designed to handle large amounts of unstructured data.
Graph Database Management Systems: Uses graph structures with nodes and edges to represent complex relationships between data.
Key-Value Database Management Systems: Stores data as key-value pairs, commonly used for caching and quick data retrieval.
In-Memory Database Management Systems: Stores all data in memory for faster access and retrieval.
Document-Oriented Database Management Systems: Stores data as JSON-like documents, allowing for flexible schemas.
Time-Series Database Management Systems: Optimized for handling time-series data, such as stock prices or weather data.
Column-Family Database Management Systems: Optimized for handling large, sparse data sets with identical schema.
NewSQL Database Management Systems: Combines the scalability of NoSQL databases with the ACID compliance of traditional SQL databases.
"Small databases can be stored on a file system."
"Large databases are hosted on computer clusters or cloud storage."
"The design of databases spans formal techniques and practical considerations, including data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues."
"A database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data."
"The DBMS software additionally encompasses the core facilities provided to administer the database."
"The sum total of the database, the DBMS, and the associated applications can be referred to as a database system."
"Computer scientists may classify database management systems according to the database models that they support."
"Relational databases became dominant in the 1980s."
"These model data as rows and columns in a series of tables."
"The vast majority use SQL for writing and querying data."
"In the 2000s, non-relational databases became popular, collectively referred to as NoSQL."
"Non-relational databases use different query languages."
"Data is accessed electronically through the use of a database management system."
"Practical considerations in database design include data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues."
"The DBMS software interacts with end users, applications, and the database itself."
"The purpose of a database management system is to capture and analyze the data."
"One advantage of using a computer cluster or cloud storage for large databases is the ability to host them."
"Relational databases store data as rows and columns in a series of tables."
"Non-relational databases became popular due to their use of different query languages."