BI 330 Exam 2

Analytical databases are referred to as application-oriented

False

Operational queries are typically issued:

By more users than analytical queries

Which of the following is NOT a data administration task?

Creating a conceptual database model

Four categories of SQL

Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Transaction Control Language (TCL)

Registry (MDM)

Dispersed master data connected via a central master data registry.

Database Administration

Encompasses the activities that are necessary for the proper functioning of a deployed database system, such as: Monitoring and maintaining the database system Securing the database against unauthorized access Providing database backup and recovery Ensuring database integrity Optimizing database performance Developing and implementing database polices and standards.

Data Control Language (DCL)

Used for data access control

Master Data Management (MDM)

Creating and maintaining a collection of quality master data tables. Ensuring that the use of master data is embedded across the operational information systems in the organization. A data governance initiative. Master data: authenticated quality version of the key data that provides a common point of reference for the organization's information systems. MDM architectures: Centralized approach Registry Hybrid approach

"Increasing the speed of a single query is always a priority, even if it requires slowing down the majority of other queries."

False

Operational databases are referred to as subject-oriented

False

Data Governance

Formally regulating how, when, and by whom the organizational data and metadata are created, stored, updated (inserted, modified, deleted), and archived.

Enterprise Resource Planning (ERP)

Integrated information system. Enable data sharing by multiple functional areas of the organization. Typically facilitate processes uniform across industries, reflect the best industry practices of the particular business process, cannot fulfill all of the information system needs, and deployment can be lengthy. Enterprise resources planning (ERP) system: premade, integrated, corporate information system.

Big Data

Massive volumes of diverse and rapidly growing data that are not formally modeled, mostly unstructured, semi-structured, lightly structured, and heterogeneous. Big data techniques increase the ability to analyze the data that an organization owns or to which it has access.

Data Steward

Responsible for the proper use of the data in databases. Activities: The creation and enforcement of policies or standards for appropriate data entry, update, and use. The creation and implementation of data quality control activities. The creation, implementation and maintenance of business metadata (such as business rules and descriptions of tables and columns). Other activities ensuring compliance with data governance policies.

Data Custodian

Responsible for the technical aspects of data management and use, such as protection, transport, and storage of data.

Centralized approach (MDM)

Single central copy of the master data is used by operational information systems.

Operational queries typically process

Smaller amounts of data than analytical queries

SQL

Structured query language. Used for: Creating databases Adding, modifying and deleting database structures Inserting, deleting, and modifying records in databases Querying databases (data retrieval). It can be used (with minor dialectical variations) with the majority of relational DBMS software tools.

"Analytical databases are created for the analysis of one or more specific business subject areas, such as sales, returns, cost, or profit."

True

"Operational data typically represents the current state of affairs in the real world, while analytical data can represent both the current situation and snapshots from the past."

True

A data warehouse is created within an organization as a separate data store whose primary purpose is data

True

The performance of operational day-to-day tasks involving data use can be severely diminished if such tasks have to compete for computing resources with analytical queries.

True

Data time-horizon is:

Typically shorter in operational systems than in analytical systems.

Transaction Control Language (TCL)

Used for managing database transactions

Data Definition Language (DDL)

Used to create and modify the structure of the database. Examples: CREATE, ALTER, DROP

Data Manipulation Language (DML)

Used to insert, modify, delete and retrieve data. Examples: INSERT INTO, UPDATE, DELETE, SELECT

Example SQL Code

CREATE TABLE vendor (vendorid CHAR(2) NOT NULL, vendorname VARCHAR(25) NOT NULL, PRIMARY KEY (vendorid));

Hybrid approach (MDM)

Central master data copy. Individual operational systems may contain their own copies of the master data as well.

Operational queries are typically issued:

More often than analytical queries

A typical organization maintains and utilized a number of operational data sources.

True