Filters








239 Hits in 3.9 sec

Optimization of Hypothetical Queries in an OLAP Environment

A. Balmin, Y. Papakonstantinou, T. Papadimitriou
Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073)  
The substitution module delivers orders-of-magnitude optimizations in cooperation with the rewriter that uses knowledge of arithmetic, relational,¯nancial and other operators.  ...  To tackle these problems we developed the Sesame system, which models an hypothetical scenario as a list of hypothetical modi¯cations on the warehouse views and fact data.  ...  Related Work To the best of our knowledge what-if scenarios in an OLAP environment have not been addressed by the database research community.  ... 
doi:10.1109/icde.2000.839428 dblp:conf/icde/BalminPP00 fatcat:t6ismfkglrbolbdcfb2ljf7xdi

On-Demand Data Broadcasting for Mobile Decision Making

Mohamed A. Sharaf, Panos K. Chrysanthis
2004 Journal on spesial topics in mobile networks and applications  
In this paper, we are addressing the issue of time and energy efficient delivery of summary tables to mobile users with hand-held computers equipped with OLAP (On-Line Analytical Processing) front-end  ...  Such data are typically in the form of summarized information tailored to suit the user's analysis interests.  ...  Performance evaluation testbed We simulated an environment that consists of a single OLAP server and a set of clients.  ... 
doi:10.1023/b:mone.0000042508.12154.51 fatcat:cb6627er25eutf6ro3s2iqncuq

Supporting Dimension Updates in an OLAP Server [chapter]

Alejandro A. Vaisman, Alberto O. Mendelzon, Walter Ruaro, Sergio G. Cymerman
2002 Lecture Notes in Computer Science  
In earlier work, we defined a taxonomy for these dimension updates and a minimal set of operators to perform them. In this paper we present TSOLAP, an OLAP server supporting fully dynamic dimensions.  ...  Finally, we present the results of a real-life case study in the application of TSOLAP to a medium-sized medical center.  ...  Acknowledgements This work was supported by the Natural Sciences and Engineering Research Council of Canada and the Institute for Robotics and Intelligent Systems.  ... 
doi:10.1007/3-540-47961-9_8 fatcat:7hf5yfcxwfbyzkzuzqyzp5tsfq

Supporting dimension updates in an OLAP server

Alejandro A. Vaisman, Alberto O. Mendelzon, Walter Ruaro, Sergio G. Cymerman
2004 Information Systems  
In earlier work, we defined a taxonomy for these dimension updates and a minimal set of operators to perform them. In this paper we present TSOLAP, an OLAP server supporting fully dynamic dimensions.  ...  Finally, we present the results of a real-life case study in the application of TSOLAP to a medium-sized medical center.  ...  Acknowledgements This work was supported by the Natural Sciences and Engineering Research Council of Canada and the Institute for Robotics and Intelligent Systems.  ... 
doi:10.1016/s0306-4379(03)00049-8 fatcat:5dn62hjaujgw7fhber66litchu

Multidimensional models

Antoaneta Ivanova, Boris Rachev
2004 Proceedings of the 5th international conference on Computer systems and technologies - CompSysTech '04  
efficient performance and allows for the data cube expansion in any direction. 4) OO Conceptual Model Data Cube -class definition of data cube.  ...  In short, the paper has described it as a data abstraction that allows one to view aggregated data from a number of perspectives: 1) Conceptually, the cube consists of a base cuboid, surrounded by a collection  ...  A range sum query applies an aggregate operation (e.g., SUM, AVERAGE) to the measure attribute within the range of the query.  ... 
doi:10.1145/1050330.1050444 fatcat:j7uqbz2w4vfxlfeecyrpyahpe4

Opportunistic View Materialization with Deep Reinforcement Learning [article]

Xi Liang, Aaron J. Elmore, Sanjay Krishnan
2019 arXiv   pre-print
We focus on inner-join views and modeling effects in a main-memory, OLAP system.  ...  Carefully selected materialized views can greatly improve the performance of OLAP workloads. We study using deep reinforcement learning to learn adaptive view materialization and eviction policies.  ...  There are also numerous opportunities for reusing computation and intermediate query state in OLAP workloads, and we believe that machine learning will be an important part of future OLAP systems.  ... 
arXiv:1903.01363v1 fatcat:hgpngvm6ubdpvgrtzd6ykpep7q

Data Warehouse Testing: A Step Towards using Business Intelligence in Banking

2019 International journal of recent technology and engineering  
Data warehouse is an important entity that contributes to the decision-making process, which can be seen in the literature available over the years.  ...  In addition to making strategic decisions, data warehouse also assist in helping the banks to improve customer retention, optimize discounting, market segmentation, business performance, customer deposits  ...  Huge amount of data is processed by decision support systems (DSS) queries, thus a simulator was proposed for optimizing the queries in order to increase the performance of the queries [23] . IV.  ... 
doi:10.35940/ijrte.d9891.118419 fatcat:v4fexyfd5ngzbmfjoqbtegfr44

E-Procurement System with Embedded Supplier Selection DSS for an Automobile Manufacturing Industry

P Priya
2012 International Journal of Database Management Systems  
The model base of the DSS incorporates the Online Analytical Processing (OLAP) and Analytic Hierarchy Process (AHP) techniques to shortlist and selects the best suppliers in a web environment.  ...  This paper presents the development of Decision Support System (DSS) to enable the selection of best suppliers in an e-procurement process.  ...  OLAP is an approach to quickly provide the answer to analytical queries that are dimensional in nature.  ... 
doi:10.5121/ijdms.2012.4206 fatcat:jb7ykuusafhzhcd2ge4jnc5ohq

Enriching What-If Scenarios with OLAP Usage Preferences

Mariana Carvalho, Orlando Belo
2016 Proceedings of the 8th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management  
In this paper, we propose an approach for helping to optimize enterprise decision processes using What-If analysis scenarios combined with OLAP usage preferences.  ...  The possibility to simulate hypothetical scenarios without harming the business using What-If analysis tools and to retrieve highly refined information is an interesting way of achieving such advantages  ...  either in relational databases, in OLAP environments, or even in daily tasks, like traffic analysis.  ... 
doi:10.5220/0006040402130220 dblp:conf/ic3k/CarvalhoB16 fatcat:4esyj57dtjhdpmwg554dbfwvg4

An adaptive peer-to-peer network for distributed caching of OLAP results

Panos Kalnis, Wee Siong Ng, Beng Chin Ooi, Dimitris Papadias, Kian-Lee Tan
2002 Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02  
The system is fully distributed and can reconfigure itself on-the-fly in order to decrease the query cost for the observed workload.  ...  A large number of low-end clients, each containing a cache with the most useful results, are connected through an arbitrary P2P network.  ...  Introduction Effective decision-making is vital in a global competitive environment where business intelligence systems are becoming an essential part of virtually every organization.  ... 
doi:10.1145/564692.564695 fatcat:k2ce5gqdk5gyphcrcxvgi4h7he

An adaptive peer-to-peer network for distributed caching of OLAP results

Panos Kalnis, Wee Siong Ng, Beng Chin Ooi, Dimitris Papadias, Kian-Lee Tan
2002 Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02  
The system is fully distributed and can reconfigure itself on-the-fly in order to decrease the query cost for the observed workload.  ...  A large number of low-end clients, each containing a cache with the most useful results, are connected through an arbitrary P2P network.  ...  Introduction Effective decision-making is vital in a global competitive environment where business intelligence systems are becoming an essential part of virtually every organization.  ... 
doi:10.1145/564691.564695 dblp:conf/sigmod/KalnisNOPT02 fatcat:k6hddbpa75htze72jvht3dqm4u

OLAP, relational, and multidimensional database systems

George Colliat
1996 SIGMOD record  
In spite of relational databases popularity in OLTP applications, this an,-dysis shows that the relational model is not ideally suited for OLAP because of the large number of l/O',s necessary to perform  ...  ) • Frequently changing business model (Weekly) As an iUustration we will use the six dimension business model of a hypothetical beverage company.  ... 
doi:10.1145/234889.234901 fatcat:cebfq35cxbdujdv3edt22jknpq

Wildfire

Ronald Barber, Oleg Sidorkin, Adam Storm, Yuanyuan Tian, Pinar Tözun, Matt Huras, Guy Lohman, C. Mohan, Rene Mueller, Fatma Özcan, Hamid Pirahesh, Vijayshankar Raman (+1 others)
2016 Proceedings of the 2016 International Conference on Management of Data - SIGMOD '16  
Transactional and Analytics Processing (HTAP) on the Spark platform by the Wildfire prototype, which can ingest up to ≈6 million inserts per second per node and simultaneously perform complex SQL analytics queries  ...  Here, a simplified mobile application uses Wildfire to recommend advertising to mobile customers based upon their distance from stores and their interest in products sold by these stores, while continuously  ...  Integration with Spark To support distributed OLAP, we integrate the Wildfire engine into the Spark environment, as shown in Figure 1 .  ... 
doi:10.1145/2882903.2899406 dblp:conf/sigmod/BarberHLMMOPRSS16 fatcat:rlujkycjerahlgz6xf4oxuqsh4

Artificial intelligence applications in the intensive care unit

C. William Hanson, Bryan E. Marshall
2001 Critical Care Medicine  
Conclusions: The intensive care environment is particularly suited to the implementation of AI tools because of the wealth of available data and the inherent opportunities for increased efficiency in inpatient  ...  Despite this, patient demographic, clinical, and billing data are increasingly available in an electronic format and therefore susceptible to analysis by intelligent software.  ...  An example of a hypothetical ICU problem that might be susceptible to this approach is the determination of an optimal staffing configuration for a group of patients with different acuity or nursing requirements  ... 
doi:10.1097/00003246-200102000-00038 pmid:11269246 fatcat:tekn57lcyfe2xfqv6mb5n2u2uq

Parallel OLAP query processing in database clusters with data replication

Alexandre A. B. Lima, Camille Furtado, Patrick Valduriez, Marta Mattoso
2009 Distributed and parallel databases  
We consider the problem of improving the performance of OLAP applications in a database cluster (DBC), which is a low cost and effective parallel solution for query processing.  ...  Current DBC solutions for OLAP query processing provide for intra-query parallelism only, at the cost of full replication of the database.  ...  The experiments presented in this paper were carried out using the Grid'5000 experimental testbed. The authors are grateful to the Grid'5000 team.  ... 
doi:10.1007/s10619-009-7037-8 fatcat:yo57te5zzngkpjg3c4zone27wq
« Previous Showing results 1 — 15 out of 239 results