Data Management..

Organizations are piled up with data that come various places and that happens almost every day. IT quiet challenging for an organization to manage this vast flood of data and that because the amount of data is increasing rapidly , this data is collected by various employees and to secure,maintain quality of this data is not an easy job.





Inspite of these challenges, the process of managing information across an organization is still carried out "Data Governance" and that is done by using a Master Data management system which stores,process,analyzes master data accurately and timely with less duplication.

The Data Base approach or Database management system is a software like microsoft access which help to avoid Data redundancy , Data isolation and Data inconsistency also Data security , Data integrity and finally Data independence.

DataBase is an organized collection of data.

1- Data Hierarchy the picture here explains how data is organized in DBMS

Data Base Design every database shall contain the following :

A- data model wich is a diagram that represents the entities in the database and their relationships.

B- Entity is a person, place, thing, or event about which information is maintained.

c-Record generally describes an entity.

d-An attribute is a particular characteristic or quality of a particular entity.

E- The primary key is a field that uniquely identifies a record.

F- Secondary keys are other field that have some identifying information but typically do not identify the file with complete accuracy.

Database designers plan the database design in a process called entity-relationship (ER) modeling. ER diagrams consists of entities, attributes and relationships. Like what shows in the picture :

Data Warehouses and Data Marts

Features of a Data warehouses and Data Marts 
Organized by business dimension or subject 
 Multidimensional Historical 
 Use online analytical processing 

Data warehouse is a repository of historical data organized by subject to support decision makers in the organization.  Historical data in data warehouses can be used for identifying trends, forecasting, and making comparisons over time. 
Online analytical processing (OLAP) involves the analysis of accumulated data by end users.
 In contrast to OLAP, online transaction processing (OLTP) typically involves a database, where data from business transactions are processed online as soon as they occur.

Example of DATA WAREHOUSE >

Multidimensional models are used to store and analyze a database , this pictures shows an example of such models :

Knowledge Management

Knowledge (that is contextual, relevant, and actionable).management is a process that helps organizations manipulate important knowledge that is part of the organization’s memory, usually in an unstructured format.

Types of Knowledge

1- Explicit knowledge: objective, rational, technical knowledge that has been documented. Examples: policies, procedural guides, reports, products.

2-Tacit knowledge: cumulative store of subjective or experiential learning.  Examples: experiences, insights, expertise, know-how.

Knowledge management systems refer to the use of information technologies to systematize, enhance, and expedite intrafirm and interfirm knowledge management.

Knowledge Management System Cycle: