IS.Qz.wk.7.set.A

A type of intelligence gathering that uses statistical techniques to explore records in a data warehouse, hunting for hidden patterns and relationships that are undetectable in routine reports

• data mining

• big data

• Relational database

• Data cubes

• Virtual federated warehouse

Collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

• data mining

• big data

• Relational database

• Data cubes

• Virtual federated warehouse

Companies often use the same relational DBMS for their data warehouse as they use for their operational database, but loaded onto a separate server and tuned for fast retrieval and reporting.

• data mining

• big data

• Relational database

• Data cubes

• Virtual federated warehouse

This architecture creates multidimensional cubes that accommodate complex, grouped data arranged in hierarchies. Retrieval is very fast because data are already grouped in logical dimensions, such as sales by product, city, region, and country.

• data mining

• big data

• Relational database

• Data cubes

• Virtual federated warehouse

This approach relies on a cooperating collection of existing databases; software extracts and transforms the data in real time rather than taking snapshots at periodic intervals.

• data mining

• big data

• Relational database

• Data cubes

• Virtual federated warehouse

The appliance is a prepackaged data warehouse solution offered by vendors that includes the hardware and software, maintenance, and support.

• Data warehouse appliance

• NoSQL

• In-memory database

• Data warehouse

• Data Steward

Database management systems suited for storing and analyzing big data. NoSQL stands for “not only SQL.”

• Data warehouse appliance

• NoSQL

• In-memory database

• Data warehouse

• Data Steward

Relies on main memory to store the database, rather than secondary storage devices, which vastly increases access speeds.

• Data warehouse appliance

• NoSQL

• In-memory database

• Data warehouse

• Data Steward

A central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning.

• Data warehouse appliance

• NoSQL

• In-memory database

• Data warehouse

• Data Steward

A combination of watchdog and bridge builder, a person who ensures that people adhere to the definitions for the master data in their organizational units.

• Data warehouse appliance

• NoSQL

• In-memory database

• Data warehouse

• Data Steward