英语论文网

Data ware house plays a vital role in the decision-making where as Transactional databases help the people to carry out different activities. For example, a transactional database can easily show the number of available seats on an airline flight; this can help the travel agent to book a fresh reservation and the data warehouse can show the empty seats in a historical pattern.

Another difference can be made on the basis of the goal. Goal of data warehouse is to stock data designed with the help of transactional data subset. On the other hand, the goal of the transactional database is related to the storage of appropriate data linked to the business unit.

A data warehouse is considered as integrated, subject-related, time-variant and nonvolatile. It lays emphasis on the concept like sales instead of the process like issuing of invoices. It consists of all pertinent information based on concept gathered from the system of multiple processing. For the speed of the operation, online transaction database has been designed in the processing business transactions. It also helps to strike a balance between the insertion of record and generation of report (Jawadekar, 2005).

For day to day operations, the transactional database has been defined such as insert, delete and update system or operation. In order to avoid the redundancy, these databases are normalized highly. On the other hand, for Analytical purpose, the Data warehouse databases have been designed. The core components that describe an entity in the design of a relational database are recognized in the normalized table in the form of columns. The Other components of the same entity are shifted to the different table called as lookup tables (components having repeating values). This arrangement plays an important role as it permits the quicker processing of data while minimizing the requirements of storage (Jawadekar, 2005).

Relational Database Management System and Data Warehouse

In order to gain a competitive strength, Management Information System is required in every organization for the intention of handling online functions, mission control applications, and to exercise the functional and management control. In this competitive and technological environment, it is not sufficient to simply computerize the back office operations. It demands a tool to effectively handle both the transactions processing and decision processing requirement. A RDBMS is a software, which fulfills all the requirements of an organization in relation to the transaction processing, decision-making, providing quick solutions, managing the data base and information, etc. (Jawadekar, 2005).

A data warehouse is a distinct part of RDBMS installation. This part contains the copies of data and information from on-line system that makes it easy for the management to take decisions. With the help of the RDBMS, the management can fulfill the requirements of both the transaction process and decision support.

Data Warehouse is a special database containing large sockets of an enterprise data related to Meta data processed to a ready 本论文由英语论文网提供整理，提供论文代写，英语论文代写，代写论文，代写英语论文，代写留学生论文，代写英文论文，留学生论文代写相关核心关键词搜索。