Brainscape's Knowledge GenomeTM

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


See full index

6. Databases > CIS275 - Chapter 1: Introduction to Databases > Flashcards

CIS275 - Chapter 1: Introduction to Databases Flashcards

1
Q

Numeric, textual, visual, or audio information that describes real-world systems.

A

Data

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

The variance in the amount of data produced and collected. Ex: A small business might track an inventory of a few thousand items, but a large commerce website might track billions of items.

A

Scope

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

The manner data may be produced (i.e. numbers, text, image, audio, or video). Ex: A phone’s proximity sensor generates raw numbers, and a satellite captures images.

A

Format

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

The level of availability of a data source and who it is available to. Ex: A retail company may use private customer data to discover purchasing behavior patterns, but a government may be required by law to share certain data sets.

A

Access

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

Historically, data was mostly ____, encoded as continuous variations on various physical media. Ex: Audio was recorded as vibrations impressed on vinyl disks. Images were recorded as chemicals on celluloid tapes.

A

analog

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

Today, data is mostly _____, encoded as zeros and ones on electronic and magnetic media.

The shift from analog to ____ data facilitated the rise of large computer databases.

A

digital

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

A collection of data in a structured format.

A

database

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

Software that reads and writes data in a database.

A

database system (database management system or DBMS)

Database systems ensure data is secure, internally consistent, and available at all times. These functions are challenging for large databases with many users, so database systems are complex.

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

A specialized programming language, designed specifically for database systems.

A

query language

Query languages read and write data efficiently, and differ significantly from general-purpose languages such as Python, Java, and C++.

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

Software that helps business users interact with database systems.

A

database application

Many databases are complex, and most users are not familiar with query languages. Consequently, direct database access is usually not feasible. Instead, programmers write applications to simplify the user experience and ensure data access is efficient and secure.

Database software is organized in layers. Applications interact with a query language on one layer, and a query language interacts with a database system on another layer. Other software layers, such as the operating system, are beyond the scope of this material.

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

A _____ is responsible for securing the database system against unauthorized users. A _____ enforces procedures for user access and database system availability.

A

database administrator

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

A _____ determines the format of each data element and the overall database structure. _____ must balance several priorities, including storage, response time, and support for rules that govern the data. Since these priorities often conflict, _____ is technically challenging.

A

database designer

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

A _____ develops computer programs that utilize a database. _____ write applications that combine database query languages and general-purpose programming languages. Query languages and general-purpose languages have significant differences, so _____ is a specialized challenge.

(same role in all 3 gaps)

A

database programmer

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

A _____ is a consumer of data in a database. _____ request, update, or use stored data to generate reports or information. _____ usually access the database via applications but can also submit queries directly to the database system.

(same role in all 3 gaps)

A

database user

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

Large, complex databases that are shared by many users have special requirements:

A

Performance. When many users and applications simultaneously access large databases, query response time degrades rapidly. Database systems must maintain fast response times by structuring data properly on storage media and processing queries efficiently.

Authorization. Many database users should have limited access to specific tables, columns, or rows of a database. Database systems must authorize individual users to access specific data.

Security. Database systems must ensure authorized users only access permissible data. Database systems must also protect against hackers by encrypting data and restricting access.

Rules. Database systems must ensure data is consistent with structural and business rules. Ex: When multiple copies of data are stored in different locations, copies must be synchronized as data is updated. Ex: When a course number appears in a student registration record, the course must exist in the course catalog.

Recovery. Computers, database systems, and individual transactions occasionally fail. Database systems must recover from failures and restore the database to a consistent state without loss of data.

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

A group of queries that must be either completed or rejected as a whole.

A

A transaction

Execution of some, but not all, queries results in inconsistent or incorrect data. Ex: A debit-credit transaction transfers funds from one bank account to another. The first query removes $100 from one account and the second query deposits $100 in another account. If the first query succeeds but the second fails, $100 is mysteriously lost. The transaction must process either both queries or neither query.

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

When processing transactions, database systems must:

A

Ensure transactions are processed completely or not at all.

Prevent conflicts between concurrent transactions.

Ensure transaction results are never lost.

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

The _____ of a database system describes the internal components and the relationships between components.

A

architecture

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

The _____ interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application. The _____ performs query optimization to ensure the most efficient instructions are executed on the data.

A

query processor

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

The _____ translates the query processor instructions into low-level file-system commands that modify or retrieve data. Database sizes range from megabytes to many terabytes, so the _______ uses indexes to quickly locate data.

A

storage manager

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

The _____ ensures transactions are properly executed. The _____ prevents conflicts between concurrent transactions. The _____ also restores the database to a consistent state in the event of a transaction or system failure.

A

transaction manager

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

The ___ is a file containing a complete record of all queries processed by the database. The transaction manager writes ___ records before applying changes to the database. In the event of a failure, the transaction manager uses ___ records to restore the database.

A

log

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

The _____, also known as a data dictionary, is a directory of tables, columns, indexes, and other database objects. Other components use _____ information to process and execute queries.

A

catalog

27
Q
A
28
Q

A _____ stores data in tables, columns, and rows, similar to a spreadsheet.

A

relational database

All data in a column has the same format. All data in a row represents a single object, such as a person, place, product, or activity.

29
Q

All relational database systems support the SQL query language. SQL stands for _____ and includes statements that read and write data, create and delete tables, and administer the database system.

A

Structured Query Language

30
Q

The growth of the internet in the 1990s generated massive volumes of online data, called _____, often with poorly structured or missing information.

A

big data

31
Q

The newer non-relational systems are called _____, for ‘not only SQL’, and are optimized for big data.

A

NoSQL

32
Q

_____ software is software that anyone can inspect, copy, and modify with no licensing fee.

A

Open source

33
Q

A command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database.

A

query

34
Q

A computer programming language for writing database queries.

A

query language

35
Q

The four common queries are sometimes referred to as CRUD operations, an acronym for:

A

Create, Read, Update, and Delete data.

36
Q

The standard query language of relational database systems.

A

Structured Query Language, or SQL

37
Q

A database command, such as a query that inserts, retrieves, updates, or deletes data:

A

SQL statement

38
Q

SQL statement:

inserts rows into a table.

A

INSERT

39
Q

SQL statement:

retrieves data from a table.

A

SELECT

40
Q

SQL statement:

modifies data in a table.

A

UPDATE

41
Q

SQL statement:

deletes rows from a table.

A

DELETE

42
Q
A
43
Q

The SQL _____ statement creates a new table by specifying the table and column names.

A

CREATE TABLE

Each column is assigned a data type that indicates the format of column values. Data types can be numeric, textual, or complex.

44
Q

SQL CREATE TABLE statement data type:

stores integer values.

A

INT

45
Q

SQL CREATE TABLE statement data type:

stores fractional numeric values.

A

DECIMAL

46
Q

SQL CREATE TABLE statement data type:

stores textual values.

A

VARCHAR

47
Q

SQL CREATE TABLE statement data type:

stores year, month, and day.

A

DATE

48
Q

A specification of database objects such as tables, columns, data types, and indexes. _____ also refers to the process used to develop the specification.

A

Database design

49
Q

For small, simple databases, the database design process can be informal and unstructured. For large, complex databases, the process has three phases:

A
  1. Analysis
  2. Logical design
  3. Physical design
50
Q

The _____ phase specifies database requirements without regard to a specific database system.

A

analysis

Requirements are represented as entities, relationships, and attributes.

Analysis has many alternative names, such as conceptual design, entity-relationship modeling, and requirements definition.

51
Q

An _____ is a person, place, activity, or thing.

A

entity

52
Q

A _____ is a link between entities.

A

relationship

53
Q

An _____ is a descriptive property of an entity.

A

attribute

54
Q

Entities, relationships, and attributes are depicted in _____:

A

ER diagrams

Rectangles represent entities. Entity names appear at the top of rectangles.

Lines between rectangles represent relationships.

Text inside rectangles and below entity names represent attributes.

55
Q
A
56
Q

The _____ phase implements database requirements in a specific database system.

A

logical design

For relational database systems, logical design converts entities, relationships, and attributes into tables, keys, and columns.

57
Q

A ___ is a column used to identify individual rows of a table.

A

key

58
Q

The logical design is depicted in a _____.

A

table diagram

Table diagrams are similar to ER diagrams but more detailed:

Rectangles represent tables. Table names appear at the top of rectangles.

Text within rectangles and below table names represents columns.

Solid bullets (●) indicate key columns.

Empty bullets (○) and arrows indicate columns that refer to keys.

59
Q

The logical design specified in SQL and depicted in a table diagram is called a _____.

A

database schema

60
Q
A
61
Q

The _____ phase adds indexes and specifies how tables are organized on storage media.

A

physical design

Ex: Rows of a table may be sorted on the values of a column and stored in sort order.

62
Q

In relational databases, logical and physical design affect queries differently. Logical design affects the query result. Physical design affects query processing speed but never affects the query result. The principle that physical design never affects query results is called _____.

A

data independence

Data independence allows database designers to tune query performance without changes to application programs. When database designers modify indexes or row order, applications run faster or slower but always generate the same results.

63
Q
A
64
Q

An _____ is a library of procedures or classes that links a host programming language to a database.

A

application programming interface (API)

The host language calls library procedures, which handle details such as connecting to the database, executing queries, and returning results. Ex: JDBC is a library of Java classes that access relational databases.

6. Databases (11 decks)

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