Multiversion join index for multiversion data warehouse

The Role of Data Warehouse as a Source of Knowledge Acquisition in Decision-Making. An Empirical Study

“…Furthermore, [2], who examined data warehousing at the Housing and Development Board (HDB) in Singapore, found that the main benefits of the DW, which were developed by HDB, are enabling the users to have access to consistent and reliable data in a timely fashion which facilitated forecasting and planning efforts and improved decision-making. In addition, a study by [31] revealed that DW appears to be used more to improve the flow of information in an organization than to change the way the organization does business. The authors found that more and better data is the greatest realized benefit from DW.…”

“…Previous literature on DW, such as [31] and [22], claims that the DW does not create value by itself; the value comes from the use of the data in the DW. [22] claim that improved decision-making results from the better information available in the DW.…”

“…By making the right information available at the right time to the right decisionmakers in the right manner, DWs empower the users with the ability to make the right decisions [40]. [31] also claim that this use can result in numerous benefits, including more and better information, improved user ability to produce information and reduced effort by developers to produce information. [41] also maintain that DWs have tremendous potential to present information.…”

Sales Based Data Extraction for Business Intelligence

“…As a consequence of this, specific departmental views on the data have to be created. [4] These views, which are called data marts, can be further customized in order to comply with the informational needs of single users (e.g., a specific salesperson in a defined region). To get information from these data marts, end users are provided with a set of tools which allow analytical processing.…”

A Survey of Managing the Evolution of Data Warehouses

“…In the MVDW approach we apply a data sharing technique, called BitmapSharing. This technique consists in storing with every record, in a fact and a dimension level table, information about all DW versions this record is shared by (Chmiel & Wrembel, 2007). At the implementation level, the sharing information is stored in the set of bitmaps attached to shared table T. One bitmap in the set represents one DW version.…”