Application of Data Warehouse in Real Life: State-of- the-art Survey from User Preferences' Perspective
---
paper_title: Dimensional issues in agricultural data warehouse designs

paper_content:

Recently, the government of India embarked on an ambitious project of designing and deploying the Integrated National Agricultural Resources Information System (INARIS) data warehouse for the agricultural sector. The system's purpose is to support macro level planning. This paper presents some of the challenges faced in designing the data warehouse, specifically dimensional and deployment challenges of the warehouse. We also present some early user evaluations of the warehouse. Governmental data warehouse implementations are rare, especially at the national level. Furthermore, the motivations are significantly different from private sectors. Designing the INARIS agricultural data warehouse posed unique and significant challenges because, traditionally, the collection and dissemination of information are localized.
---
paper_title: Building the Data Warehouse

paper_content:

From the Publisher: ::: The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data warehouse, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration and more. This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design.
---
paper_title: Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan

paper_content:

Previous literature suggests that various factors play crucial roles in the adoption of an information system; however, there is little empirical research about the factors affecting adoption of data warehouse technology, particularly in a single information technology intensive industry. In this study, we used a survey to investigate the factors influencing adoption of data warehouse technology in the banking industry in Taiwan. A total of 50 questionnaires were mailed to CIOs in domestic banks. The response rate was 60%. Discriminant analysis was employed to test hypotheses. The results revealed that factors such as support from the top management, size of the bank, effect of champion, internal needs, and competitive pressure would affect the adoption of data warehouse technology. The results and conclusions from this study may be a good reference for global banks in these aforementioned countries to establish and develop operational strategies, which in turn will facilitate the implementation in overseas branches.
---
paper_title: Key organizational factors in data warehouse architecture selection

paper_content:

Even though data warehousing has been in existence for over a decade, companies are still uncertain about a critical decision - which data warehouse architecture to implement? Based on the existing literature, theory, and interviews with experts, a research model was created that identifies the various contextual factors that affect the selection decision. The results from the field survey and multinomial logistic regression suggest that various combinations of organizational factors influence data warehouse architecture selection. The strategic view of the data warehouse prior to implementation emerged as a key determinant. The research suggests an overall model for predicting the data warehouse architecture selection decision.
---
paper_title: A Data Warehouse Architecture for Clinical Data Warehousing

paper_content:

Data warehousing methodologies share a common set of tasks, including business requirements analysis, data design, architectural design, implementation and deployment. Clinical data warehouses are complex and time consuming to review a series of patient records however it is one of the efficient data repository existing to deliver quality patient care. Data integration tasks of medical data store are challenging scenarios when designing clinical data warehouse architecture. The presented data warehouse architectures are practicable solutions to tackle data integration issues and could be adopted by small to large clinical data warehouse applications.
---
paper_title: Dimensional issues in agricultural data warehouse designs

paper_content:

Recently, the government of India embarked on an ambitious project of designing and deploying the Integrated National Agricultural Resources Information System (INARIS) data warehouse for the agricultural sector. The system's purpose is to support macro level planning. This paper presents some of the challenges faced in designing the data warehouse, specifically dimensional and deployment challenges of the warehouse. We also present some early user evaluations of the warehouse. Governmental data warehouse implementations are rare, especially at the national level. Furthermore, the motivations are significantly different from private sectors. Designing the INARIS agricultural data warehouse posed unique and significant challenges because, traditionally, the collection and dissemination of information are localized.
---
paper_title: A comparison of data warehousing methodologies

paper_content:

Using a common set of attributes to determine which methodology to use in a particular data warehousing project.
---
paper_title: An architecture for a business and information system

paper_content:

The transaction-processing environment in which companies maintain their operational databases was the original target for computerization and is now well understood. On the other hand, access to company information on a large scale by an end user for reporting and data analysis is relatively new. Within IBM, the computerization of informational systems is progressing, driven by business needs and by the availability of improved tools for accessing the company data. It is now apparent that an architecture is needed to draw together the various strands of informational system activity within the company. IBM Europe, Middle East, and Africa (E/ME/A) has adopted an architecture called the E/ME/A Business Information System (EBIS) architecture as the strategic direction for informational systems. EBIS proposes an integrated warehouse of company data based firmly in the relational database environment. End-user access to this warehouse is simplified by a consistent set of tools provided by an end-user interface and supported by a business data directory that describes the information available in user terms. This paper describes the background and components of the architecture of EBIS.
---
paper_title: Building the Data Warehouse

paper_content:

From the Publisher: ::: The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data warehouse, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration and more. This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design.
---
paper_title: A conceptual model of data warehousing for medical device manufacturers

paper_content:

Required information for management decisions in an organization can span across many internal functions and external sources, particularly for decisions with strategic ramifications. In recent years, increasing numbers of organizations have employed data warehouses to meet their needs of accurate and timely information. A literature research has been performed to understand data warehousing applications in the healthcare and pharmaceutical industry. With lessons learned from these applications and situation analyses of medical device organizations, a conceptual model of data warehousing for medical device manufactures is proposed. This model proposes an enterprise-wide data warehouse, which will link information generated or obtained from different local systems. This data warehouse is the focal point of an integrated system where data from all sources are stored in predefined formats and will provide information of interest to various users in the organization. Some practical applications of such an integrated data warehouse in areas of product portfolio planning, sales/marketing, and clinical/regulatory are discussed. The future trends of data warehousing applications for medical device manufacturers are also envisioned.
---
paper_title: Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan

paper_content:

Previous literature suggests that various factors play crucial roles in the adoption of an information system; however, there is little empirical research about the factors affecting adoption of data warehouse technology, particularly in a single information technology intensive industry. In this study, we used a survey to investigate the factors influencing adoption of data warehouse technology in the banking industry in Taiwan. A total of 50 questionnaires were mailed to CIOs in domestic banks. The response rate was 60%. Discriminant analysis was employed to test hypotheses. The results revealed that factors such as support from the top management, size of the bank, effect of champion, internal needs, and competitive pressure would affect the adoption of data warehouse technology. The results and conclusions from this study may be a good reference for global banks in these aforementioned countries to establish and develop operational strategies, which in turn will facilitate the implementation in overseas branches.
---
paper_title: TO OUTSOURCE OR NOT TO OUTSOURCE

paper_content:

SUBTITLE: THIRD-PARTY LOGISTICS PROVIDERS CAN OFFER EXPERTISE AND IMPRESSIVE SAVINGS, BUT THERE'S A BIG RISK IN GIVING UP CONTROL OVER SOMETHING AS IMPORTANT AS LOGISTICS OPERATIONS: WHAT'S A SHIPPER TO DO?
---
paper_title: A Comprehensive Analysis of Materialized Views in a Data Warehouse Environment

paper_content:

Data in a warehouse can be perceived as a collection of materialized views that are generated as per the user requirements specified in the queries being generated against the information contained in the warehouse. User requirements and constraints frequently change over time, which may evolve data and view definitions stored in a data warehouse dynamically. The current requirements are modified and some novel and innovative requirements are added in order to deal with the latest business scenarios. In fact, data preserved in a warehouse along with these materialized views must also be updated and maintained so that they can deal with the changes in data sources as well as the requirements stated by the users. Selection and maintenance of these views is one of the vital tasks in a data warehousing environment in order to provide optimal efficiency by reducing the query response time, query processing and maintenance costs as well. Another major issue related to materialized views is that whether these views should be recomputed for every change in the definition or base relations, or they should be adapted incrementally from existing views. In this paper, we have examined several ways o performing changes in materialized views their selection and maintenance in data warehousing environments. We have also provided a comprehensive study on research works of different authors on various parameters and presented the same in a tabular manner.
---
paper_title: Dimensional issues in agricultural data warehouse designs

paper_content:

Recently, the government of India embarked on an ambitious project of designing and deploying the Integrated National Agricultural Resources Information System (INARIS) data warehouse for the agricultural sector. The system's purpose is to support macro level planning. This paper presents some of the challenges faced in designing the data warehouse, specifically dimensional and deployment challenges of the warehouse. We also present some early user evaluations of the warehouse. Governmental data warehouse implementations are rare, especially at the national level. Furthermore, the motivations are significantly different from private sectors. Designing the INARIS agricultural data warehouse posed unique and significant challenges because, traditionally, the collection and dissemination of information are localized.
---
paper_title: Actions for data warehouse success

paper_content:

Problem statement: The Data Warehouse is a database dedicated to the storage of all data used in the decision analysis, it meets the customer requirements, to ensure, in time, that a data warehouse complies with the rules of construction and manages the evolutions necessary of the information system (IS). ::: Results: According to the studies carried out, we see that a system based on a data warehouse governed by the best practices of The Information Technology Infrastructure Library (ITIL) and equipped with a multi-agent system will make it possible our direction to ensure governance tending towards the optimization of the exploitation of the data warehouse.
---
paper_title: Building the Data Warehouse

paper_content:

From the Publisher: ::: The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data warehouse, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration and more. This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design.
---
paper_title: Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan

paper_content:

Previous literature suggests that various factors play crucial roles in the adoption of an information system; however, there is little empirical research about the factors affecting adoption of data warehouse technology, particularly in a single information technology intensive industry. In this study, we used a survey to investigate the factors influencing adoption of data warehouse technology in the banking industry in Taiwan. A total of 50 questionnaires were mailed to CIOs in domestic banks. The response rate was 60%. Discriminant analysis was employed to test hypotheses. The results revealed that factors such as support from the top management, size of the bank, effect of champion, internal needs, and competitive pressure would affect the adoption of data warehouse technology. The results and conclusions from this study may be a good reference for global banks in these aforementioned countries to establish and develop operational strategies, which in turn will facilitate the implementation in overseas branches.
---
paper_title: Key organizational factors in data warehouse architecture selection

paper_content:

Even though data warehousing has been in existence for over a decade, companies are still uncertain about a critical decision - which data warehouse architecture to implement? Based on the existing literature, theory, and interviews with experts, a research model was created that identifies the various contextual factors that affect the selection decision. The results from the field survey and multinomial logistic regression suggest that various combinations of organizational factors influence data warehouse architecture selection. The strategic view of the data warehouse prior to implementation emerged as a key determinant. The research suggests an overall model for predicting the data warehouse architecture selection decision.
---
paper_title: An overview of data warehousing and OLAP technology

paper_content:

Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications. This paper provides an overview of data warehousing and OLAP technologies, with an emphasis on their new requirements. We describe back end tools for extracting, cleaning and loading data into a data warehouse; multidimensional data models typical of OLAP; front end client tools for querying and data analysis; server extensions for efficient query processing; and tools for metadata management and for managing the warehouse. In addition to surveying the state of the art, this paper also identifies some promising research issues, some of which are related to problems that the database research community has worked on for years, but others are only just beginning to be addressed. This overview is based on a tutorial that the authors presented at the VLDB Conference, 1996.
---
paper_title: Data warehousing and analytics infrastructure at facebook

paper_content:

Scalable analysis on large data sets has been core to the functions of a number of teams at Facebook - both engineering and non-engineering. Apart from ad hoc analysis of data and creation of business intelligence dashboards by analysts across the company, a number of Facebook's site features are also based on analyzing large data sets. These features range from simple reporting applications like Insights for the Facebook Advertisers, to more advanced kinds such as friend recommendations. In order to support this diversity of use cases on the ever increasing amount of data, a flexible infrastructure that scales up in a cost effective manner, is critical. We have leveraged, authored and contributed to a number of open source technologies in order to address these requirements at Facebook. These include Scribe, Hadoop and Hive which together form the cornerstones of the log collection, storage and analytics infrastructure at Facebook. In this paper we will present how these systems have come together and enabled us to implement a data warehouse that stores more than 15PB of data (2.5PB after compression) and loads more than 60TB of new data (10TB after compression) every day. We discuss the motivations behind our design choices, the capabilities of this solution, the challenges that we face in day today operations and future capabilities and improvements that we are working on.
---
paper_title: A data warehouse-based decision support system for sewer infrastructure management

paper_content:

Abstract Since the inception of the Governmental Accounting Standards Board statement-34 (GASB 34) in the United States, local and state governing entities need to inspect sewer systems and collect general information about their properties. Application of the collected information in decision-making processes, however, is often problematic due to the lack of consistency and completeness of infrastructure data. In addition, most techniques involved in decision-making processes are relatively complicated and difficult to implement without a certain level of engineering experience and training. Consequently, the sharing and transferring of pertinent information among stakeholders is not smooth and is frequently limited. This study presents a decision support system (DSS) for the management of sewer infrastructure using data warehousing technology. The proposed decision support system automatically assigns appropriate inspection and renewal methods for each pipeline and estimates associated costs, resulting in effective and practical sewer infrastructure management from various perspectives, with corresponding levels of detail.
---
paper_title: Customer relationship management in financial services: towards information-enabled relationship marketing

paper_content:

Relationship marketing is concerned with how organizations manage and improve their relationships with customers for long-term profitability. Customer relationship management (CRM), which is becoming a topic of increasing importance in marketing, is concerned with using information technology (IT) in implementing relationship marketing strategies. This paper reports on a study of the adoption and use of CRM in the financial services sector. In particular, the key elements of CRM are examined in these organizations and executives' perceptions of the main IT components that enable responsive CRM are explored. CRM is classified into five stages of sophistication and a framework for CRM adoption is developed.
---
paper_title: Data Warehouse Requirements Analysis Framework: Business-Object Based Approach

paper_content:

Detailed requirements analysis plays a key role towards the design of successful Data Warehouse (DW) system. The requirements analysis specifications are used as the prime input for the construction of conceptual level multidimensional data model. This paper has proposed a Business Object based requirements analysis framework for DW system which is supported with abstraction mechanism and reuse capability. It also facilitate the stepwise mapping of requirements descriptions into high level design components of graph semantic based conceptual level object oriented multidimensional data model. The proposed framework starts with the identification of the analytical requirements using business process driven approach and finally refine the requirements in further detail to map into the conceptual level DW design model using either Demand- driven of Mixed-driven approach for DW requirements analysis.
---
paper_title: Applications of Data Mining in Higher Education

paper_content:

Data analysis plays an important role for decision support irrespective of type of industry like any manufacturing unit and educations system. There are many domains in which data mining techniques plays an important role. This paper proposes the use of data mining techniques to improve the efficiency of higher education institution. If data mining techniques such as clustering, decision tree and association are applied to higher education processes, it would help to improve students performance, their life cycle management, selection of courses, to measure their retention rate and the grant fund management of an institution. This is an approach to examine the effect of using data mining techniques in higher education.
---
paper_title: Application of data warehouse and Decision Support System in construction management

paper_content:

Abstract How to provide construction managers with information about and insight into the existing data, so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system is a problem during the construction management process. To solve this problem, the integration of a data warehouse and a Decision Support System (DSS) seems to be efficient. ‘Data warehouse’ technology is a new database discipline, which has not yet been applied to construction management. Hence, it is worthwhile to experiment in this particular field in order to gauge the full scope of its capability. First reviewed in this paper are the concepts of the data warehouse, On-Line Analysis Processing (OLAP) and DSS. The method of creating a data warehouse is then shown, changing the data in the data warehouse into a multidimensional data cube and integrating the data warehouse with a DSS. Finally, an application example is given to illustrate the use of the Construction Management Decision Support System (CMDSS) developed in this study. Integration of a data warehouse and a DSS enable the right data to be tracked down and provide the required information in a direct, rapid and meaningful way. Construction managers can view data from various perspectives with significantly reduced query time, thus making decisions faster and more comprehensive. The applications of a data warehousing integrated with a DSS in construction management practice are seen to have considerable potential.
---
paper_title: E Data Turning Data Into Information With Data Warehousing

paper_content:

Thank you for downloading e data turning data into information with data warehousing. As you may know, people have look hundreds times for their favorite books like this e data turning data into information with data warehousing, but end up in infectious downloads. Rather than enjoying a good book with a cup of tea in the afternoon, instead they juggled with some harmful virus inside their laptop.
---
paper_title: Computing in Civil Engineering

paper_content:

This proceedings consist of papers presented at the Third Congress on Computing in Civil Engineering held in Anaheim, California, June 17-19, 1996. The proceedings covers advanced computing theory and technologies, computing applications in civil engineering practice and education, and computing issues, experiences and lessons learned. Within these broad topics, the book contains papers on subjects such as: applications of the Internet, World Wide Web and multimedia in civil engineering practice and education; risk and reliability assessment and management; visualization, modeling and simulation; artificial intelligence and advanced computing; geographic information systems; and interoperability.
---
paper_title: Comprehensive Centralized-Data Warehouse for Managing Malaria Cases

paper_content:

Tanah Bumbu is one of the most endemic areas in Indonesia for patients diagnosed with malaria diseases. Currently, available malaria case data were stored in disparate sources. Hence, it is difficult for the public health department to quickly and easily gather the useful information for determining strategic actions in tackling these cases. The purpose of this research is to build a data warehouse that integrates all malaria cases from disparate sources. This malaria data warehouse is a centralized architecture of galaxy or constellation scheme that consists of three fact tables and 13 dimension tables. SQL Server Integration Services (SSIS) is utilized to build ETL packages that load data from various sources to stages, dimensions, and fact tables in malaria data warehouse. Finally, a timely report can be generated by extracting the salient information located in malaria data warehouse.
---
paper_title: Critical factors influencing the adoption of data warehouse technology: a study of the banking industry in Taiwan

paper_content:

Previous literature suggests that various factors play crucial roles in the adoption of an information system; however, there is little empirical research about the factors affecting adoption of data warehouse technology, particularly in a single information technology intensive industry. In this study, we used a survey to investigate the factors influencing adoption of data warehouse technology in the banking industry in Taiwan. A total of 50 questionnaires were mailed to CIOs in domestic banks. The response rate was 60%. Discriminant analysis was employed to test hypotheses. The results revealed that factors such as support from the top management, size of the bank, effect of champion, internal needs, and competitive pressure would affect the adoption of data warehouse technology. The results and conclusions from this study may be a good reference for global banks in these aforementioned countries to establish and develop operational strategies, which in turn will facilitate the implementation in overseas branches.
---

Title: Application of Data Warehouse in Real Life: State-of-the-art Survey from User Preferences' Perspective

Section 1: INTRODUCTION
Description 1: This section introduces the concept of data warehousing, its evolution, and its importance in decision support for organizations.

Section 2: DATA WAREHOUSE TECHNOLOGY
Description 2: This section discusses the foundational technology and concepts behind data warehousing, including its architecture, attributes, and processes like ETL (Extraction, Transformation, Loading).

Section 3: APPLICATIONS OF DATA WAREHOUSE IN REAL LIFE
Description 3: This section explores various real-life applications of data warehousing across different domains such as business, government, finance, healthcare, and education.

Section 4: CASE STUDIES
Description 4: This section provides detailed case studies from both the business and government perspectives, highlighting the implementation and benefits of data warehousing in specific contexts.

Section 5: COMPARISON OF DIFFERENT CROSS DOMAIN AREAS AFFECTING DATA WAREHOUSE
Description 5: This section presents a comparative analysis of how various cross-domain areas impact data warehousing, illustrated with graphical representations.

Section 6: CONCLUSION
Description 6: This section summarizes the findings of the survey, reflecting on the importance of data warehousing technology, its adoption, and the challenges faced by organizations.