Data Management

Data Management

Traditional file processing

Each business application was designed to use one or more specialized data files containing only specific types of data records.

Problem with Traditional File Processing:

• Data Redundancy
• Lack of Data Integration
• Data Dependence
• Lack of data integrity or standardization.

Data management approach

Consolidates data into databases that can be accessed by different programs. Uses a database management system (DBMS) and it serves as software interface between users and databases.

DBMS-set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users.

A DBMS is a system software package that helps the use of integrated collection of data records and files known as.databases.It allows different user application programs to easily access the same database.

DBMS may use any of a variety of database models, such as the network model and rational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. Instead of having to write computer programs to extract information, user can ask simple questions in a query language. Thus, many DBMS packages provide Fourth-generation programming language (4GLs) and other application development features.

It helps to specify the logical organization for a database and access and use the information within a database. It provides facilities for controlling data access, enforcing data integrity, managing concurrency controlled, and restoring database.

Data warehouse

Data warehouse stores static data that has been extracted from other databases in an organization. Such as central source of data that has been cleaned, transformed, and cataloged. Data is used for data mining, analytical processing, analysis, research, and decision support

Data warehouses may be divided into data marts which are the subsets of data that focus on specific aspects of a company, department or business process.

A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.