chapter 1 - database systems flashcards 1

1
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A shared, integrated computer structure that houses a collection of related data. A ______ contains two types of data: end-user data (raw facts) and metadata.

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data about data; that is, data about data characteristics and relationships.

A

Metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

The collection of programs that manages the database structure and controls access to the data stored in the database.

A

DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A logically related database that is stored in two or more physically independent sites.

A

distributed database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.

A

cloud database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Decision support system (DSS) tools that use multidimensional data analysis techniques.

A

Online analytical processing (OLAP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A new generation of database management systems that is not based on the traditional relational database model.

A

NoSQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

In a relational database, a condition in which the data in the database complies with all entity and referential integrity constraints.

A

Data integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly