Brainscape's Knowledge GenomeTM

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


See full index

CMPUT 291 > Lecture 1- Introduction to Database > Flashcards

Lecture 1- Introduction to Database Flashcards

1
Q

What is a database?

A

A database is a very large, integrated collection of data

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

What are the two parts of databases?

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

What is a database management system (DBMS)?

A

DBMS is a software package designed to store and manage databases

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

Describe non-database approach

A
  • One data set per program
  • programmer defined (and implements) storage structures, access methods, etc
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are some problems with a non-database approach?

A
  • With more and more applications we get:
  • Many files with different structures
  • Redundant storage
  • Inconsistent copies
  • Expensive updates
  • Incorrect data
  • Data exchange between applications
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Describe the idea behind a database approach

A
  • Remove details related to data storage and access from applications programs
  • Concentrate those functions in a single system called a database management system
  • Have all applications access data through the DBMS
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Why use a DBMS?

A
  • Reduced redundancy
  • Less risk of inconsistency
  • Reduced application development time
  • Uniform data administration
  • Concurrent access, recovery from crashes
  • But most importantly data independence
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Describe a three level schema

A
  • External schema = what application programs and users see
  • Conceptual schema = description of the logical structure of data
  • Physical schema = file structures and indexes being used
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a schema?

A

A description of the data contents, structures and other aspects

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

What is an objective?

A

Application programs unaffected by changes in storage structure and access strategy

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

What is logical data independence?

A

Protection from changes in logical structure of data

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

What is physical data independence?

A

Protection from changes in physical structure of data

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

What is one of the most important benefits of using DBMS?

A

Data independence

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

Describe DBMS functionality

A
  • Data definition facilities
  • Data manipulation facilities
  • Facilities for integrity constraints
  • Provides concurrency control
  • Supports transactions
  • Provides database recovery
  • Provides query optimization
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are data definition facilities?

A
  • Provides a data definition language (DDL)
  • Stores the definitions in a user accessible catalog (data dictionary)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are data manipulation facilities?

A

Provides a query language for storing, retrieving and updating data

17
Q

What do facilities for integrity constraints do?

A
  • Does the validation check for integrity constraints before updates
  • Different kinds of constraints
18
Q

What are the different types of integrity constraints?

A
  • Primary key constraints (entity integrity)
  • Foreign key constraints (no dangling references)
  • Check constraints
19
Q

What is concurrency control?

A

Multiple users simultaneously access/update a database

20
Q

What are transactions?

A
  • A sequence of user operations to be performed as an atomic action
  • All operations or none are performed
21
Q

Why is database recovery important in DBMS?

A

Whatever happens, never lose data

22
Q

What is query optimization?

A

Find the best possible plan for executing a query

23
Q

Where does DBMS place itself in a computer system?

A
24
Q

Why this course?

A
  • A paradigm shift from computation to information
  • Big data is everywhere
  • Many applications need DBMS functionalities
  • One size doesn’t fit all
  • What are they and why are they useful?
25
Q

How can I use databases?

A
  • Relational model
  • ER model
  • Relational query languages
  • Database design
26
Q

How do databases work?

A
  • Secondary storage
  • Organizing data in files and indexes
  • Physical database design
  • Database tuning

CMPUT 291 (7 decks)

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