7.2 Introduction to Databases

A structured set of data held in a computer, usually in a way that is accessible by multiple concurrent users.

• Database

• Data Modeling

• Operational Data

• Analytical Data

A way to help programmers and other related parties make sense of database information.

• Database

• Data Modeling

• Database Management System (DBMS)

• Operational Data

Data that is produced by an organization's everyday operations. It's gathered in real time to provide a snapshot of what's happening in the present.

• Operational Data

• Analytical Data

• Database Management System (DBMS)

• Table

Historical data that is used to help people make decisions in the present. It's various categories include market data, transactional data, sensor data, natural language, and machine data.

• Analytical Data

• Database Management System (DBMS)

• Table

• Query

Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access.

• Operational Data

• Data Modeling

• Database Management System (DBMS)

• Table

A data structure in a relational database that is comprised of fields (columns) and records (rows).

• Table

• Query

• Form

• Report

A method of asking questions about the data stored in a database.

• Table

• Query

• Form

• Report

A graphical interface that allows users to query a database by filling in information on the form.

• Table

• Query

• Form

• Report

An easy-to-read listing of the results of a query.

• Analytical Data

• Query

• Form

• Report