Database Management Extra 4 Flashcards

1
Q

An open-source application programming interface (API) that provides fast data analytics services; one of the main Big Data technologies that allows organizations to process massive data stores.

A

MapReduce

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

One of three types of nodes used in the Hadoop Distributed File System (HDFS). The ??? ??? stores all the metadata about the file system.

A

name node

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

An early data model that represented data as a collection of record types in 1:M relationships.

A

Network Model

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

A DBMS based on the extended relational model (ERDM). The ERDM, championed by many relational database researchers, constitutes the relational model’s response to the OODM. This model includes many of the object-oriented model’s best features within an inherently simpler relational database structure.

A

O/R DBMS

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

A logical construct perceived to be a two dimensional structure composed of intersecting rows (entities) and columns (attributes) that represents an entity set in the relational model.

A

Relation

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

A collection of programs that manages a relational database. The RDBMS software translates a user’s logical requests (queries) into commands that physically locate and retrieve the requested data.

A

RDBMS

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

A graphical representation of a relational database’s entities, the attributes within those entities, and the relationships among the entities.

A

Relational Diagram

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

Developed by E. F. Codd of IBM in 1970, the ??? ??? is based on mathematical set theory and represents data as independent relations. Each relation (table) is conceptually represented as a two dimensional structure of intersecting rows and columns. The relations are related to each other through the sharing of common entity characteristics (values in columns).

A

Relational Model

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

A logical grouping of database objects, such as tables, indexes, views, and queries, that are related to each other. Usually, a ??? belongs to a single user or application.

A

Schema

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

In the hierarchical data model, the equivalent of a file system’s record type.

A

Segment (SEGM)

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