Traditional File Processing Images
Traditional File ProcessingEach business application was designed to use one or more specialized data files containing only specific types of data records. One of the ways to store,manipulate and retrieve large files of data. Traditional file based system is basically a file based system, in which we manually or through computer handle the database such as updating,insertion,deletion adding new files to database etc.
Problems with Traditional File Processing
Data Redundancy,Lack of Data Integration,Data Dependence and Lack of data integrity or standardization.
Data Management Approach
Consolidates data into databases that can be accessed by differently programs. It use a database management system (DBMS). 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, restoring database.
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, restoring database.
Database Management Approach Images
Data WarehousesRepository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis. Data warehouse focuses on data storage.
However, the means to retrieve and analyze data, to extract,transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract,transform and load data into the repository, and tools to manage and retrieve metadata.
However, the means to retrieve and analyze data, to extract,transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract,transform and load data into the repository, and tools to manage and retrieve metadata.
Data Warehouse Images
Kuala Lumpur Time
0 comments:
Post a Comment