What is data cleansing? What software is used for data cleansing? What is a data audit? Why do organizations perform data quality audits? What does this describe: "A structured survey of the accuracy and level of completeness of the data in an information system" What are examples of steps firms may take to make sure they have a high level of data quality? What are examples of managing and controlling data within a company? What is normalization? What is data mining? What is a non-relational database management system?

1. What is data cleansing?

Data cleansing is used to detect and correct inaccurate day in a database; not only corrects data, but enforces consistency among different sets of data that originated in separate information systems.

2. What software is used for data cleansing?

Specialized data cleansing software are used to automatically survey data files.

3. What is a data audit?

A data audit is a method using a survey to determine the accuracy of a data set. Data quality audits can be performed by surveying entire data files or samples from data files.

4. Why do organizations perform data quality audits?

To determine accuracy and level of completeness of data.

5. What does this describe: "A structured survey of the accuracy and level of completeness of the data in an information system"

A data quality audit

6. What are examples of steps firms may take to make sure they have a high level of data quality?

Using enterprise-wide data standards, performing data quality audits, and using databases designed to minimize inconsistent and redundant data.

7. What are examples of managing and controlling data within a company?

Firms may set policies about passwords for accessing data. Large companies may have several departments handling specific tasks involving data assurance for the firm.

8. What is normalization?

Normalization involves the process of creating small, stable, yet flexible data structures from complex groups of data when designing a relational database.

9. What is data mining?

Data mining is the application of statistical techniques to find patterns and relationships among data and to classify and predict future behavior.

10. What is a non-relational database management system?

A non-relational database management system is a system for working with large quantities of structured and unstructured data that would be difficult to analyze with a relational model.