英语论文网

to use stage for decision makers for operational and analytical business analysis. It helps to follow a fast decision-making process to meet the needs of functional information system and critical needs of decision makers (Jawadekar, 2005).

Types of Data Warehouse

To assist responding to the users' analytical questions, each of the three types of data management systems is used (Benander, et al., 2000). All of these three systems vary from the operational database. The primary function of the operational database is to support the transactions of daily business operations (Chen & Frolick, 2000). To get a more flexible and faster access to several of the key information of an organization, data warehouse is used (Chen & Frolick, 2000). In the later part of the discussion, we will discuss the different types of data access tools, which may be offered to the users.

Operational Data Store (ODS): Basically, the operational data stores are an updated version of the files containing customer information (Benander, et al., 2000). Generally, data of 12 to 18 months is stored in the operational data stores so as to restrict the trend analysis of the data held there. It is particularly used to respond to the questions on the current operations. In the organization, the users at all levels can use an operational database (Benander, et al., 2000).

To summarize the current operational data at a thorough level, the use of operational data stores (ODS) is made. Normally, only the tabulation of current data is done by the ODS and no historical information is stored by the ODS. It has been seen in many cases that for performing and allowing the data queries, the legacy systems of the institution are not set up efficiently, easily and effectively. With the help of operational data store, the users can inquire about the current data for the purpose of decision-making. The decisions, which are made by making the use of the operational data store, are the day-to-day and tactical decisions. Pipe states that the institutions, which organize an ODS, could develop that data warehouse into an enterprise data warehouse at some later time period (Pipe, 1997).

Data Mart (DM): The database repositories, which are designed for only one subject or functional area, like that of a human resource or finance, are known as the Data Marts. The scope of data mart is larger than the scope of operational data stores in which the information related to many years is stored, but they are not larger than the data warehouses, which have multiple functional areas. Typically, the data mart is used for providing decision support on specific subject area or to some specific department (Benander, et al., 2000). It is possible that in some cases, the data marts are first implemented in the institutions and then only the data will be put together to form an enterprise data warehouse. While in other cases, the reverse will be done. First the enterprise data warehouse will be established and then with the help of this data warehouse, the data mart will be implemented (Benander, et al., 2000). The execution of a data mart decreases the development time and the cost, when compared to a full enterprise data warehouse (Chen & 本论文由英语论文网提供整理，提供论文代写，英语论文代写，代写论文，代写英语论文，代写留学生论文，代写英文论文，留学生论文代写相关核心关键词搜索。