Information Systems - Databases
database ✔️ An organized collection of data, including schemas, tables, queries, reports, views, and
other objects.
database management system (DBMS) ✔️ A computer software application that interacts with the
user, other applications, and the database itself to capture and analyze data.
general-purpose DBMS ✔️ Designed to allow the definition, creation, querying, update, and
administration of databases.
data warehouse ✔️ A central repository of integrated data from one or more disparate sources used
for reporting and data analysis.
data mining ✔️ The computational process of discovering patterns in large data sets involving methods
at the intersection of artificial intelligence, machine learning, statistics, and database systems.
relational database management system ✔️ A database management system that is based on
representing data in terms of ordered sets of elements (tuples), grouped into relations (tables).
hierarchical database model ✔️ A data model in which the data is organized into a tree-like structure.
network model ✔️ A database model conceived as a flexible way of representing objects and their
relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are
nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.
management strategies ✔️ Include registering and monitoring users, enforcing data security,
monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering
information that has been corrupted by some event such as an unexpected system failure.
centralized database ✔️ A database that is located, stored, and maintained in a single location.
database ✔️ An organized collection of data, including schemas, tables, queries, reports, views, and
other objects.
database management system (DBMS) ✔️ A computer software application that interacts with the
user, other applications, and the database itself to capture and analyze data.
general-purpose DBMS ✔️ Designed to allow the definition, creation, querying, update, and
administration of databases.
data warehouse ✔️ A central repository of integrated data from one or more disparate sources used
for reporting and data analysis.
data mining ✔️ The computational process of discovering patterns in large data sets involving methods
at the intersection of artificial intelligence, machine learning, statistics, and database systems.
relational database management system ✔️ A database management system that is based on
representing data in terms of ordered sets of elements (tuples), grouped into relations (tables).
hierarchical database model ✔️ A data model in which the data is organized into a tree-like structure.
network model ✔️ A database model conceived as a flexible way of representing objects and their
relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are
nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.
management strategies ✔️ Include registering and monitoring users, enforcing data security,
monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering
information that has been corrupted by some event such as an unexpected system failure.
centralized database ✔️ A database that is located, stored, and maintained in a single location.
