Chapter 4: Managing Knowledge and Data

I have learned many concepts and information from this chapter. I summarized them as follow:

Difficulties in Managing Data are:

1. Amount of data increases exponentially.
2. Data are dispersed and collected by many individuals using various methods and devices.
3. Data come from many sources.
4. Data security, quality and integrity are critical.

Database management system (DBMS) provides all users with access to all the data.

It minimize: Data redundancy, isolation and inconsistency. And maximize: Data security, integrity and independence.

The data model is a diagram that represents the entities in the database and their relationships.

Database designers plan the database design in a process called entity-relationship (ER) modeling.

A database management system is a set of programs that provide users with tools to add, delete, access, and analyze data stored in one location.

Normalization is a method for analyzing and reducing a relational database to its most streamlined form for:Minimum redundancy, Maximum data integrity and Best processing performance.

A data warehouse is a repository of historical data organized by subject to supportdecision makers in the organization.

The data cube has three dimensions: customer, product, and time.

Online analytical processing (OLAP) involves the analysis of accumulated data by end users

(usually in a data warehouse).

Benefits of Data Warehousing are:

1. End users can access data quickly and easily via Web browsers because they are located in one place.
2. End users can conduct extensive analysis with data in ways that may not have been possible before.
3. End users have a united view of organizational data.

A data mart is a small data warehouse, designed for the end-user needs in a strategic business unit (SBU) or a department.

Master data management is a method that organizations use in data governance.

Knowledge management is a process that helps organizations manipulates important knowledge that is part of the organization’s memory, usually in an unstructured format.

Knowledge that is contextual, relevant, and actionable.

Intellectual capital is another term often used for knowledge.

Knowledge management systems refer to the use of information technologies to systematize,enhance, and expedite intra-firm and inter-firm knowledge management.