18,688 Hits in 5.1 sec

Adding a Performance-Oriented Perspective to Data Warehouse Design [chapter]

Pedro Bizarro, Henrique Madeira
2002 Lecture Notes in Computer Science  
Data warehouse design is clearly dominated by the business perspective. Quite often, data warehouse administrators are lead to data models with little room for performance improvement.  ...  In this paper we defend that data warehouse design must take into account both the business and the performance perspective from the beginning, and we propose the extension to typical design methodologies  ...  Data Warehouse Design: A Performance Perspective Data warehouse design has three main sources of input: the business view, data from operational systems (typically OLTP systems), and a set of design rules  ... 
doi:10.1007/3-540-46145-0_23 fatcat:u536v6juqfdjrbbkbxqrnr4itm

An evaluation of process warehousing approaches for business process analysis

Khurram Shahzad, Paul Johannesson
2009 Proceedings of the International Workshop on Enterprises & Organizational Modeling and Simulation - EOMAS '09  
For several years, data warehouse (DW) technology has been used for analysis and decision making. A data warehouse developed for business processes is called a process warehouse.  ...  Furthermore, the framework has been used to evaluate various process warehousing approaches, collected through a comprehensive survey.  ...  The goal oriented methodology is used within a demand-driven and mixed supply driven design framework to produce data warehouse design.  ... 
doi:10.1145/1750405.1750417 fatcat:jgq6gbbiwfenbj5n2oehj7nh2q

Database Vs Data Warehouse

2007 Informatică economică  
The necessity to build a data warehouse arises from the necessity to improve the quality of information in the organization.  ...  The present paper emphasizes some of the criteria that information application developers can use in order to choose between a database solution or a data warehouse one.  ...  Information is subject-oriented, as data warehouses provide a multidimensional view on data, based on an intuitive model, designed to meet the requirements of data analysis and decision makers. 4) Another  ... 
doaj:431f07fe4d394a5c8230e0494dfe2448 fatcat:lh26sltdcngybcriqksujuyge4

DW4SN: A Tool for Dynamic Data Warehouse Building from Social Network

Rania Yangui, Ahlem Nabli, Faiez Gargouri
2017 Research in Computing Science  
This work presents DW4SN (Data Warehouse for Social Network) tool for building data warehouse from social network, where clustering methods are used to define the DW schema and NoSQL systems are used to  ...  We validate our system on a real data set concerning crafts women social network. The main benefits were obtained in terms of scalability and dynamicity.  ...  We build a prototype that can load a company's data warehouse and a FOAF ontology, design new multidimensional concepts in the data warehouse schema and implement the obtained warehouse under document-oriented  ... 
doi:10.13053/rcs-134-1-15 fatcat:aqoxg5paunhtpceenokewlmkjq

Process-Oriented Requirement Analysis Supporting the Data Warehouse Design Process A Use Case Driven Approach [chapter]

Beate List, Josef Schiefer, A. Min Tjoa
2000 Lecture Notes in Computer Science  
We illustrate how use cases enhances communication between domain experts, data warehouse specialists, data warehouse designers and other professionals with different backgrounds.  ...  We develop a predefined set of dimension objects that belong to every classic business process and are able to create various fact objects, representing these perspectives.  ...  He derives the data model by transferring the corporate data model into a data warehouse schema and by adding performance factors.  ... 
doi:10.1007/3-540-44469-6_55 fatcat:7h55rprgmvaq3fv5kcnjg5iuwi

Towards a Corporate Performance Measurement System

Beate List, Karl Machaczek
2004 Proceedings of the 2004 ACM symposium on Applied computing - SAC '04  
This paper illustrates how a data warehouse can be used to facilitate a Corporate Performance Measurement System by the integration of business process performance information into a traditional data warehouse  ...  Basically, business processes are designed to transform organisational strategies into operation and create a result of value to customers.  ...  As a further step towards a Corporate Performance Measurement System, the internal business process perspective ought to be integrated into the corporate data warehouse.  ... 
doi:10.1145/967900.968172 dblp:conf/sac/ListM04 fatcat:bfzwmkgc3jblrjwpcxo3ceodji

Data warehouse process management

Panos Vassiliadis, Christoph Quix, Yannis Vassiliou, Matthias Jarke
2001 Information Systems  
the design, administration and especially evolution of a data warehouse.  ...  Moreover, the metamodel complements the existing architecture and quality models in a coherent fashion, resulting in a full framework for quality-oriented data warehouse management, capable of supporting  ...  While the design and implementation of the warehouse are performed in a rather controlled environment, the administration of the warehouse has to deal with problems that evolve in an ad-hoc fashion.  ... 
doi:10.1016/s0306-4379(01)00018-7 fatcat:on7huo45nbgynnily5mpknzzpq

Evaluating a healthcare data warehouse for cancer diseases [article]

Dr.Osama E.Sheta, Ahmed Nour Eldeen
2013 arXiv   pre-print
The evaluation model based on Bill Inmon's definition of data warehouse is proposed to evaluate the Cancer data warehouse.  ...  This paper presents the evaluation of the architecture of healthcare data warehouse specific to cancer diseases. This data warehouse containing relevant cancer medical information and patient data.  ...  Evaluation of data operations The developed data warehousing techniques are assessed from the 4 data warehouse operational perspectives below: 1) Data extraction performance (Subject- oriented):  ... 
arXiv:1307.3448v1 fatcat:ef4cdhmvw5eivdlgzufrvvvazq

Process Oriented Data Virtualization Design Model for Business Processes Evaluation(PODVDM) Research in Progress

Ayad Hameed Mousa, Norshuhada Shiratuddin, Muhamad Shahbani Abu Bakar
2015 Jurnal Teknologi  
The main aim of this study is to propose a process-oriented data virtualization design model for process evaluation in BPM.  ...  The approach implements process-oriented data warehouse and mining techniques.  ...  To address this issue, a data warehouse (DW) is built for BP analysis and is termed as process warehouse (PW). The performance of PW highly depends on its design [21] [22] [23] [24] [25] [26] .  ... 
doi:10.11113/jt.v72.3926 fatcat:wmm2i2p3mvcz5bmtw5wknhuyo4

Data warehousing for construction equipment management

Hongqin Fan, Hyoungkwan Kim, Osmar R Zaïane
2006 Canadian journal of civil engineering (Print)  
The proposed equipment data warehouse enables equipment managers to visually analyze the equipment fleet data from different perspectives and at various level of details.  ...  This paper presents an equipment data warehouse and a prototype decision support system (DSS).  ...  The writers wish to express their sincere appreciation to Dale Tillapaugh, the equipment manager of the collaborating contractor.  ... 
doi:10.1139/l06-108 fatcat:sc5esqegj5a4rlszhkplxpjosa

Towards a Goal-Driven Approach for Business Process Improvement Using Process-Oriented Data Warehouse [chapter]

Khurram Shahzad, Constantinos Giannoulis
2011 Lecture Notes in Business Information Processing  
An emerging approach for business process analysis is to use business intelligence practices by employing data warehouse and decisionmaking techniques.  ...  Our research addresses this issue by introducing a goal-driven approach for business process improvement using process warehouse.  ...  Therefore, our approach to address the discussed issues is based on a business orientation in the design and utilization of warehouse.  ... 
doi:10.1007/978-3-642-21863-7_10 fatcat:iijsp26twnem7ghpsboaarshi4

The Catch data warehouse: support for community health care decision-making

Donald J. Berndt, Alan R. Hevner, James Studnicki
2003 Decision Support Systems  
The data warehouse allows a core set of reports to be produced at a reasonable cost for community use.  ...  Illustrations of actual data designs and reporting formats from the CATCH data warehouse are used throughout the discussion.  ...  Department of Commerce, which has provided funding through a Technology  ... 
doi:10.1016/s0167-9236(02)00114-8 fatcat:dp7hehsikbgzbd3aj2rek3m3rm

A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses

Amine Azzaoui, Ouzayr Rabhi, Ayyoub Mani
2019 International Journal of Online and Biomedical Engineering (iJOE)  
Which is why, in this paper, we present a model-driven approach (MDA) for the design of data warehouses.  ...  To apply the MDA approach to the Data warehouse construction process, we describe a multidimensional meta-model and specify a set of transformations from a UML meta-model which is mapped to a multidimensional  ...  A data warehouse is a subject-oriented, integrated, non-volatile, and time-variant collection of data in support of management's decisions [16] : • Subject-oriented: The Data Warehouse is organized around  ... 
doi:10.3991/ijoe.v15i12.10720 fatcat:svczcspeonaltj2syfg5dxdbwu

Improved Data Warehousing: Lessons Learnt From The Systems Approach

Roelien Goede
2011 Zenodo  
This paper investigates data warehouse development practices from a systems thinking perspective.  ...  An empirical investigation is done in order to understand the everyday practices of data warehousing professionals from a systems perspective.  ...  These users use the data in a predetermined way. In data warehouses very few standardized reports are written. These users use browsers and ad hoc queries to access the data.  ... 
doi:10.5281/zenodo.1078577 fatcat:ad253xpm45h7xiupvnrdnp3rgm

A Web-Based GIS-T Data Warehouse System for Value-Added Applications

Chi-Chung Tao
2013 International Journal of Innovation Management and Technology  
This paper firstly describes key issues of developing a web-based GIS-T data warehouse system to lay a solid foundation for value-added applications.  ...  To demonstrate system performance, metadata search function is taken as an example. Finally, a framework of the integrated tourism information system is proposed as a value-added application.  ...  . 2) Data maintainer: Tasks of data collection and maintenance are well performed by updating and adding database to ensure the latest status of the data warehouse system. 3) General user: User needs for  ... 
doi:10.7763/ijimt.2013.v4.423 fatcat:tge4ghn57bbklcjwnu2ibkbpku
« Previous Showing results 1 — 15 out of 18,688 results