Exam 3: Database, Data Warehouse, and Data Mining

_____________________ is a process used to analyze an organization's non-structured data that comes from word processing documents, social media, text messages, audio, faxes, memos, call center or claims notes, and so on.

Databases are optimized for extremely fast processing of ___________ -or ad hoc user requests for specific data.

An ad-hoc request for specific data or information from a database or warehouse is called an) ___________.

____________________________ consist of hardware and software that manage and archive electronic documents and also convert paper documents into edocuments and then index and store them according to company policy.

Specialized software used to analyze large data sets to find patterns, correlation, trends, or other meaningful relationships are called data mining tools.

_______________________ tools and techniques process data and do statistical analysis for insight and discovery-that is, to discover meaningful relationships in the data, keep informed of real time, gain insight, detect trends, and identify opportunities and risks.

__________________________ is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer, product, or other core data entity that is shared across systems.

An advantage of Document Management Systems DMS) is that they help organizations cut labor costs by automating business processes.

A centralized database stores all related files in one physical location.

Which of the following was not listed in your text as a benefit experienced by organizations that use a Document Management System DMS)?

Many database management systems use the ______________________ for programming queries.

Traditional databases are not well suited for managing _____________ such as customer comments and tweets.

Many database management systems use the Syntax Query Language SQL) for programming queries.

Data warehouses integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.

Which of the following is not one of the costs of "dirty" or poor quality data cited in your text?

An advantage of Document Management Systems DMS) is that they reduce the time and effort required to locate information the business needs to support decision making

_____________________ tools and techniques process data and do statistical analysis for insight and discovery-that is, to discover meaningful relationships in the data, keep informed of real time, gain insight, detect trends, and identify opportunities and risks.

Companies have always faced the challenge of managing physical documents. However, the most significant current challenge involves the volume of documents that must be reviewed to determine if they should be retained or destroyed.

According to a recent 2012) study of 176 organizations worldwide by Aberdeen, the volume of physical documents is expected to ______________________.

Data in databases are said to be volatile because of rounding errors or software apps that lack the appropriate precision when making calculations.