Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Data Management Systems Design > Basic Concepts > Flashcards

Basic Concepts Flashcards

1
Q

define database

A

A collection of related data.

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

data

A

known facts that can be recorded and have an implicit meaning.

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

mini-world

A

Some part of the real world about which data is stored in a database. For example, student grades and transcripts at a university.

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

data-base management system (DBMS)

A

A collection of programs to facilitate the creation and maintenance of a computerized database

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

database system

A

The DBMS software together with the data itself. Sometimes, the applications are also included

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

A DBMS is a general purpose software system that facilitates the process of ____, ____, and ____ DBs for various applications.

A

defining, constructing, and manipulating

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

_____ a DB involves specifying the data types, structures and constraints for the data to be stores in the DB.

A

Defining

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

____ a DB is the process of storing the data itself on some storage medium that is controlled by the DBMS.

A

Constructing

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

Manipulating a DB involves functions such as ____ the DB to retrieve specific data, ___ the DB to reflect changes in the mini-world, and _____ from the data.

A

querying; updating; generating reports

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

describe the self-contained nature of database system.

A

Self-contained nature of database system: A DBMS catalog stores the description of the database. (The description is called meta-data) This allows the DBMS software to work with different databases.

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

The characteristic that allows program-data independence is called _______.

A

data abstraction Insulation between programs and data: Called program-data independence. Allows changing data storage structures and operations without having to change the DBMS access programs.

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

data model

A

A set of concepts to describe the structure of a database. A data model is a type of data abstraction that is used to provide the users with a conceptual representation of data that does not include many of the details of how data is stored.

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

Why is multiple views a good characteristic of the database approach?

A

Support of multiple views of the data: Each user may see a different view of the database, which describes only the data of interest to that user.

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

concurrency control w.r.t. DBMS

A

The DBMS must include concurrency control software to ensure that multiple users trying to update the same data do so in a controlled manner so that the result of the update is correct.

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

List four groups of people who might interact with a database

A

database administrators database designers end users system analysts and application programmers

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

When not to use a DBMS

A
  • If the database and applications are simple, well defined, and not expected to change.
  • If there are stringent real time requirements that may not be met because of DBMS overhead.
  • If access to data by multiple users is not required. Sometimes no DBMS may suffice:
  • If the database system is not able to handle the complexity of data because of modeling limitations.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The ____ of a database refers to the data types, relationships, and constraints that the database should obey.

A

structure

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

A data model can also contain _______ that specify database retrievals and updates by referring to the concepts of the data model.

A

user-defined operations

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

Name 3 Categories of data models

A

conceptual, physical, and implementation

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

conceptual data models

A

high-level, semantic data models; provide concepts that are close to the way many users perceive data. Also called entity-based or object-based data models.

21
Q

physical data models

A

low-level, internal data models; provide concepts that describe details how how data is stored in the computer.

22
Q

implementation

A

record-oriented data models; Provide concepts that fall between conceptual and physical data models, balancing user views with some computer storage details.

23
Q

database schema

A

The description of a database. Includes descriptions of the database structure and the constraints that should hold on the database.

24
Q

schema diagram

A

A diagrammatic display of some aspect of a database system.

25
Q

database instance

A

The actual data stored in a database at a particular moment in time. Also called database state (or occurence).

26
Q

The database schema changes very ______. The database state changes __________.

A

infrequently; every time the database is updated

27
Q

Schema is also called

A

intension

28
Q

State, or instance, is sometimes called

A

extension

29
Q

What are the three levels of the three level architecture?

A

internal schema, conceptual schema, external schema

30
Q

What characteristics of the database approach is the three level architecture proposed to support?

A

program-data independence and multiple views of the data.

31
Q

Internal schema

A

the internal level to describe data storage structures and access paths. Typically uses a physical data model.

32
Q

Conceptual schema

A

at the conceptual level to descrive the structure and constrains for the whole database. Uses a conceptual or an implementation data model.

33
Q

External schemas

A

at the external level to descrive the various user views. Usually uses the same data model as the conceptual level.

34
Q

_____ among schema levels are also needed.

A

Mappings. Programs refer to an external schema, and are mapped by the DBMS to the interal schema for execution.

35
Q

logical data independence vs. physical data indepence

A

logical data independence is the capacity to change the conceptual schema without having to change the external schemas and their application programs.

physical data independence is the capacity to change the inernal schema without having to change the coneptual schema.

36
Q

When a schema at a lower level is changed, only the mappings between this schema and higher-level schemas need to be changed in a DBMS that fully supports data independece. The higher level schemas themselves are _____.

A

unchanged; Hence, the application programs need not be changed since they refer to the external shemas

37
Q

data definition language

A

Used by the DBA and database designers to specify the conceptual schema of a database.

38
Q

In many DBMSs, the DDL is also used to define _____ and _____ schemas(views)

A

internal and external

39
Q

In some DBMSs, separate ________ and _________ are used to define internal and external schemas respectively.

A

storage definition language (SDL) and view definition language (VDL)

40
Q

data manipulation language (DML)

A

Used to specify database retrievals and updates.

41
Q

In current DBMS a _________ is used that includes constructs for conceptual schema definiton, view definition, and schema, and data manipulation.

A

comprehensive integrated language

42
Q

DML commands (data sublanguage) can be embedded in a general-purpose programmign language (host language), such as COBOL, PL/1 or PASCAL.

Alternatively, stand alone DML commands can be applied directly (query language).

A DML that can be used on its own to specify complex DB operations in a conside manner is called ___________.

A

high-level DML (as oppose to a low-level DML)

43
Q

A ________ DML can specify and retrieve many records in a single DML statement (_______ DML). A low-level DML retrieves and process each time one record from a set of records (_______ DML)

A

high-level; set-at-a-time; record-at-a-time

44
Q

A query in a high-level DML often specifies which data to retrieve (________) rather than how to retrieve it (________)

A

declarative; procedural language

45
Q

The ____________ is used to store schema decriptions and other information such as design decisions, application program descriptions, user information, usage standards, etc.

A

data dictionary / repository

46
Q

object data mdoel

A

The Object data model defines a database in terms of objects, their properties, and their operations. Objects belong to classes; classes are organzied into hierarchies; the operations of each class are specified in terms of predefined procedures called methods.

47
Q

network data model

A

The Network data model represents data as record types and 1:N relationships (called set types).

It has an associated record-at-a-time language that must be embedded in a host programming language.

48
Q

hierarchical data model

A

The Hierarchical data model represents data as hierarchical tree structures (parent-child relationship types)

There is no standard language. Most hierarchical DBMS use a record-at-a-time language.

Data Management Systems Design (9 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions