Exam 3: Database Systems,data Warehouses,and Data Marts

Describe the loading process used in data warehouses.

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

Which of the following is a key factor that has contributed to the growth and popularity of big data?

A _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

A(n) _____ is a collection of related data that is stored in a central location or multiple locations.

What type of files might a college database have?

Grouping objects along with their attributes and methods into a class is called _____.

In a hierarchical data model,nodes with the same parents are called siblings.

In the past,why was data stored in "flat files"?

A distributed database is not limited by the data's physical location.

_____ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

The integrity rules component of a data model defines the boundaries of a database,constraints,and access methods.

In a(n) _____ data model,the relationships among records form a treelike structure.

The _____ component is responsible for data storage,manipulation,and retrieval.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

What is business analytics?

The database component of an information system can generate sufficient business intelligence by accessing just the internal data of an organization.

In a relational data model,a(n) _____ operation searches data in a table and retrieves records based on certain criteria.

Business analytics uses _____ to support decision-making activities.

The popularity of social networks has contributed to the growth of big data.