907 Hits in 6.1 sec

Benchmarking data warehouse systems in the cloud

Rim Moussa
2013 2013 ACS International Conference on Computer Systems and Applications (AICCSA)  
In this paper, first, we present cloud computing and data warehouse systems.  ...  Finally, we present new requirements for implementing a benchmark for data warehouse systems in the cloud.  ...  Fig. 1 illustrates a typical architecture of a data warehouse system.  ... 
doi:10.1109/aiccsa.2013.6616442 dblp:conf/aiccsa/Moussa13 fatcat:y4mcf7xk3zdjzgd473dufhpeau

Data Warehouse and Big Data Integration

Sonia Ordonez Salinas, Alba Consuelo Nieto Lemus
2017 International Journal of Computer Science & Information Technology (IJCSIT)  
Some conclude that Data Warehouse as such will disappear; others present Big Data as the natural Data Warehouse evolution (perhaps without identifying a clear division between the two); and finally, some  ...  Big Data triggered furthered an influx of research and prospective on concepts and processes pertaining previously to the Data Warehouse field.  ...  Because of this, an overview of the architecture in terms of these components is presented below.  ... 
doi:10.5121/ijcsit.2017.9201 fatcat:kglb5zq53jdzfmvx5wld7n2q4m

Design and Implementation of an Enterprise Data Warehouse

Arshad Gulzar
2018 International Journal Of Engineering And Computer Science  
The purpose of this paper is to study components of a theoretical Enterprise Data Warehouse within the context of a higher education environment.  ...  The reason for such an implementation would give users at all levels of the university an integrated, secure and consistent data source from which they could report on and set their business needs more  ...  The final data warehouse is a SQL Server 2008 R2 database, which uses SQL Server Integration Services as the ETL tool and SQL Server Reporting Services as the reporting tool.  ... 
doi:10.18535/ijecs/v7i12.02 fatcat:qkr7tkztwrf6ne4myzrxglr6xe

Exploiting Correlation and Parallelism of Materialized-View Recommendation for Distributed Data Warehouses

Haifeng Jiang, Dengfeng Gao, Wen-Syan Li
2007 2007 IEEE 23rd International Conference on Data Engineering  
We identify the best hybrid warehouse architecture by studying various algorithms to join database and HDFS tables.  ...  We utilize Bloom filters to minimize the data movement, and exploit the massive parallelism in both systems to the fullest extent possible.  ...  In this paper, we identify an architecture for hybrid warehouses by 1-) building a system that provides parallel data movement by exploiting the massive parallelism of both HDFS and EDWs to the fullest  ... 
doi:10.1109/icde.2007.367873 dblp:conf/icde/JiangGL07 fatcat:rv6zntqgfbfwtlztrhkn2tzggy

Multiagent Immediate Incremental View Maintenance for Data Warehouses

G.C.H. Yeung, W.A. Gruver
2005 IEEE transactions on systems, man and cybernetics. Part A. Systems and humans  
Both the data sources and data warehouse were managed using Microsoft SQL Server 2000 implemented on the same multiple-CPU data server.  ...  Such failures are detected when a view agent fails to connect to the warehouse or update the warehouse view, causing an SQL exception.  ... 
doi:10.1109/tsmca.2005.843385 fatcat:s7pe7o3p65bplkotspshj5py6a

An ISO 9001: 2000 Compliant Quality Management System for Data Integration in Data Warehouse Systems

Holger Hinrichs, Thomas Aden
2001 Design and Management of Data Warehouses  
This holds especially for data warehouse systems and similar systems that provide data integrated from heterogeneous sources.  ...  In modern information systems, the topic of data quality becomes more and more important due to increasing analysis demands.  ...  Figure 8 illustrates the different layers of the DQMS architecture. Layer 1 contains the data storage modules (based on Microsoft SQL Server) for business and meta data.  ... 
dblp:conf/dmdw/HinrichsA01 fatcat:mrszcscetjci7bwfaf6yeffpwm

Integrating Data Warehouses with Web Data: A Survey

J.M. Perez, R. Berlanga, M.J. Aramburu, T.B. Pedersen
2008 IEEE Transactions on Knowledge and Data Engineering  
This paper surveys the most relevant research on combining Data Warehouse (DW) and Web data.  ...  Index Terms-Data warehouse repository, XML/XSL/RDF. Ç 940  ...  MDX was first introduced by Microsoft, and nowadays, many OLAP servers and DW client applications support MDX.  ... 
doi:10.1109/tkde.2007.190746 fatcat:drcxlccqqfaifcjuzbzspyzlpu

Information and Communication Technology [chapter]

2007 Warehouse Management  
a better general overview of the data being managed in a group.  ...  Here, groups store the post-processed data from their experiments in SQL databases in order to allow for future re-use.  ... 
doi:10.1007/978-3-540-35220-4_7 fatcat:dluy52mstbeqxkrynauxq2ejem

Multi-Dimensional Database Allocation for Parallel Data Warehouses

Thomas Stöhr, Holger Märtens, Erhard Rahm
2000 Very Large Data Bases Conference  
Data allocation is a key performance factor for parallel database systems (PDBS).  ...  While there are several studies on data allocation for relational PDBS, the specific requirements of data warehouses have not yet been sufficiently addressed.  ...  Some systems such as NCR TERADATA V2R3 [2] and MICROSOFT SQL SERVER 7.0 [10] do not yet support bitmap indices.  ... 
dblp:conf/vldb/StohrMR00 fatcat:t7phux3nencjldbe4rcwbaaoeu

The Datacenter as a Computer: An Introduction to the Design of Warehouse-Scale Machines, Second edition

Luiz André Barroso, Jimmy Clidaras, Urs Hölzle
2013 Synthesis Lectures on Computer Architecture  
ARCHITECTURAL OVERVIEW OF WSCS 8 1. INTRODUCTION .6. ARCHITECTURAL OVERVIEW OF WSCS10 1. INTRODUCTION .6. ARCHITECTURAL OVERVIEW OF WSCS .6. ARCHITECTURAL OVERVIEW OF WSCS 2.  ...  Instead it looks more like a building or warehouse-computer architecture meets traditional (building) architecture.  ... 
doi:10.2200/s00516ed2v01y201306cac024 fatcat:435o455inbcmrakl6l7jp4gope

A scalable, predictable join operator for highly concurrent data warehouses

George Candea, Neoklis Polyzotis, Radek Vingralek
2009 Proceedings of the VLDB Endowment  
Conventional data warehouses employ the query-at-a-time model, which maps each query to a distinct physical plan.  ...  We describe an augmentation of traditional query engines that improves join throughput in large-scale concurrent data warehouses.  ...  The warehouse supports a workload of SQL queries, including periodic updates.  ... 
doi:10.14778/1687627.1687659 fatcat:z7jw6jgun5gcrbxswnex4p36xu

An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse

Edmond Lau, Samuel Madden
2006 Very Large Data Bases Conference  
Any highly available data warehouse will use some form of data replication to tolerate machine failures.  ...  In this paper, we demonstrate that we can leverage this data redundancy to build an integrated approach to recovery and high availability.  ...  Microsoft SQL Server [21] ).  ... 
dblp:conf/vldb/LauM06 fatcat:pngr4wtnprgp7bkzk6ytxejspu

An overview of data warehousing and OLAP technology

Surajit Chaudhuri, Umeshwar Dayal
1997 SIGMOD record  
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  ...  This paper provides an overview of data warehousing and OLAP technologies, with an emphasis on their new requirements.  ...  Microsoft SQL Server supports Cube and Rollup.  ... 
doi:10.1145/248603.248616 fatcat:ssiegmooy5bujdawwxoseke2my

An overview of business intelligence technology

Surajit Chaudhuri, Umeshwar Dayal, Vivek Narasayya
2011 Communications of the ACM  
All major data warehouse vendors today offer OLAP servers (for example, IBM Cognos, 15 Microsoft SQL, 17 and Oracle Hyperion 23 ). In-memory BI engines.  ...  to acquire very large volumes in order to extract as much competitive advantage from it as possible. new massively parallel data architectures and analytic tools go beyond traditional parallel sQL data  ... 
doi:10.1145/1978542.1978562 fatcat:ws4wbvmbdjdlfbuzerkrekvsey

Big Data: The Future of Data Storage

Manpreet Singh, Jatinder Singh Bhatia, Devansh Malhotra
2014 IOSR Journal of Computer Engineering  
The major objective of this paper is to present Big Data Storage techniques and Data Virtualization. The Data virtualization servers have focused on making big data processing easy.  ...  But with scale and performance rising, making big data processing is not enough and easy anymore. As such, the next challenge for data virtualization is parallel to big data processing.  ...  Traditional SQL database servers, such as Microsoft SQL Server and Oracle, are so-called generic database servers.  ... 
doi:10.9790/0661-1654130136 fatcat:s75bsbwkgzcnpgogdfrh3ufo2i
« Previous Showing results 1 — 15 out of 907 results