Filters








7,168 Hits in 5.9 sec

Query optimization for OLAP-XML federations

Dennis Pedersen, Karsten Riis, Torben Bach Pedersen
2002 Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP - DOLAP '02  
However, for such OLAP-XML federations to be useful, effective optimization techniques for such systems are needed.  ...  In this paper we present novel techniques for query optimization in federations of OLAP and XML databases.  ...  Thus, logical, rather than physical, integration is desirable, i.e. a federated database system [14] is called for.  ... 
doi:10.1145/583890.583899 dblp:conf/dolap/PedersenRP02 fatcat:k4txlt34pzbzlff6l7amil5sji

Estimating Query Result Sizes for Proxy Caching in Scientific Database Federations

Tanu Malik, Randal Burns, Nitesh Chawla, Alex Szalay
2006 ACM/IEEE SC 2006 Conference (SC'06)  
In a proxy cache for federations of scientific databases it is important to estimate the size of a query before making a caching decision.  ...  nature of database federations.  ...  Experimental Results CAROT is a system developed for BY caches. BY caches are being currently introduced in the mediation middle-ware for the NVO federation of astronomy databases [10] .  ... 
doi:10.1109/sc.2006.27 fatcat:yzq67pfs7za3ndj736tqdljapy

Data management and query---Estimating query result sizes for proxy caching in scientific database federations

Tanu Malik, Randal Burns, Nitesh V. Chawla, Alex Szalay
2006 Proceedings of the 2006 ACM/IEEE conference on Supercomputing - SC '06  
In a proxy cache for federations of scientific databases it is important to estimate the size of a query before making a caching decision.  ...  nature of database federations.  ...  Acknowledgments The authors sincerely thank Jim Gray for his help with the selectivity estimation methods proposed for query optimizers.  ... 
doi:10.1145/1188455.1188562 dblp:conf/sc/MalikBCS06 fatcat:6avilhqbkzh6flkugosxtic57u

A Black-Box Approach to Query Cardinality Estimation

Tanu Malik, Randal C. Burns, Nitesh V. Chawla
2007 Conference on Innovative Data Systems Research  
Our primary case study is the Open SkyQuery federation of Astronomy archives, which uses a scheduling and caching mechanism at the mediator for execution of federated queries at remote sources.  ...  We envision an increasing need for such an approach in applications in which query cardinality is required for resource optimization and decision-making at locations that are remote from the data sources  ...  The authors thank Amitabh Chaudhary for helping us better understand the bottom-up approach and making the descriptions concrete.  ... 
dblp:conf/cidr/MalikBC07 fatcat:fascpj2j3jatjo4jnm4dsa2ija

Data integration through database federation

L. M. Haas, E. T. Lin, M. A. Roth
2002 IBM Systems Journal  
In other words, a federated database system can optimize queries and compensate for SQL function that may be lacking in a data source.  ...  The basics of database federation The term "database federation" refers to an architecture in which middleware, consisting of a relational database management system, provides uniform access to a number  ...  As a researcher and member of the Garlic project at IBM's Almaden Research Center, she contributed key advances in heterogeneous data integration techniques and federated query optimization and led efforts  ... 
doi:10.1147/sj.414.0578 fatcat:vkbmerkifjeqninxxuse57xram

Achieving adaptivity for OLAP-XML federations

Dennis Pedersen, Torben Bach Pedersen
2003 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP - DOLAP '03  
Earlier work has resulted in an extension of the TARGIT system, allowing external XML data to be used as dimensions and measures in OLAP databases.  ...  Motivated by the need for more flexible OLAP systems, this paper presents work on logical integration of external data in OLAP databases, carried out in cooperation between the Danish OLAP client vendor  ...  We have previously presented a federated database system that allows data outside the OLAP database to be used as logical dimensions or measures in a cube [7, 9] .  ... 
doi:10.1145/956065.956066 fatcat:dxq5ip2g4ffr5panakdepjmhzu

Achieving adaptivity for OLAP-XML federations

Dennis Pedersen, Torben Bach Pedersen
2003 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP - DOLAP '03  
Earlier work has resulted in an extension of the TARGIT system, allowing external XML data to be used as dimensions and measures in OLAP databases.  ...  Motivated by the need for more flexible OLAP systems, this paper presents work on logical integration of external data in OLAP databases, carried out in cooperation between the Danish OLAP client vendor  ...  We have previously presented a federated database system that allows data outside the OLAP database to be used as logical dimensions or measures in a cube [7, 9] .  ... 
doi:10.1145/956060.956066 dblp:conf/dolap/PedersenP03 fatcat:53mknuzu4nhjnf7ark3fxdzhhi

DISTRIBUTED MULTI-LEVEL QUERY CACHE: THE IMPACT ON DATA WAREHOUSING

2012 Issues in Information Systems  
Next we present an overview of the database systems DMQC is to be built on and how DMQC differs from existing distributed query cache systems.  ...  To understand DMQC we first give a brief overview of how distributed and federated data warehouses systems work.  ...  FEDERATED DATABASE SYSTEMS A federated database system sends a search query to multiple databases, organizes, and returns the results to the enduser [4] .  ... 
doi:10.48009/2_iis_2012_51-57 fatcat:ed2mb6z65feh3na5lymtl24kga

Automated physical design in database caches

Tanu Malik, Xiaodan Wang, Randal Burns, Debabrata Dash, Anastasia Ailamaki
2008 2008 IEEE 24th International Conference on Data Engineering Workshop  
Performance of proxy caches for database federations that serve a large number of users is crucially dependent on its physical design.  ...  This is remarkably shown at the proxy cache of SkyQuery, an Astronomy federation, which receives a continuously evolving workload.  ...  Bypass caches are proxy caches that reside at the mediator site in the SkyQuery federation ( Figure 1) . A database cache is manifested for each participant in the federation.  ... 
doi:10.1109/icdew.2008.4498281 dblp:conf/icde/MalikWBDA08 fatcat:rx7mdau3ere6rgsjenmxquxvka

Towards an information infrastructure for the grid

S. Bourbonnais, V. M. Gogate, L. M. Haas, R. W. Horman, S. Malaika, I. Narang, V. Raman
2004 IBM Systems Journal  
In this paper we present our vision of an information infrastructure for grid computing, which is based on a service-oriented architecture.  ...  In this paper, we propose an information infrastructure for grid computing that will meet this lofty goal.  ...  It might be a DB2* for z/OS* database, IMS*, an XML table, or an SAP** system. In fact, each of the Data Services shown might be a different system "under the covers.")  ... 
doi:10.1147/sj.434.0665 fatcat:wu63adtytfgmpdbulhnx7u6zwu

Federated query processing on linked data: a qualitative survey and open challenges

Damla Oguz, Belgin Ergenc, Shaoyi Yin, Oguz Dikenelli, Abdelkader Hameurlain
2015 Knowledge engineering review (Print)  
We provide a detailed and clear insight on data source selection, join methods and query optimization methods of existing query federation engines.  ...  In this paper, we initially give an overview of query processing approaches used in this interlinked and distributed environment, and then focus on federated query processing on linked data.  ...  Symmetric join Symmetric hash join (Wilschut & Apers, 1991 ) is a non-blocking hash-based join which supports pipelining in parallel database systems. It maintains a hash table for each relation.  ... 
doi:10.1017/s0269888915000107 fatcat:aksyotsj7zedvkxl6lmc54d7wy

Middle-tier database caching for e-business

Qiong Luo, Sailesh Krishnamurthy, C. Mohan, Hamid Pirahesh, Honguk Woo, Bruce G. Lindsay, Jeffrey F. Naughton
2002 Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02  
On deployment of a DBCache at an application server, arbitrary SQL statements generated from the unchanged application that are intended for a backend database server, can be answered: at the cache, at  ...  Using a general-purpose industrial-strength DBMS for middle-tier database caching is especially attractive to e-Businesses, even though there have been special-purpose solutions (for example, e-Bay uses  ...  We would also like to thank Satya Dash, Joseph Fung, Jim Kleewein, Peter Schwarz, and David Tolleson for answering our questions on the ECDW benchmark, DB2 federated features, and DPropR.  ... 
doi:10.1145/564760.564763 fatcat:bam42pggyrb4jm6jtjg2r72ngi

Edge Network Optimization Based on AI Techniques: A Survey

Mitra Pooyandeh, Insoo Sohn
2021 Electronics  
Moreover, this paper elaborates and discusses the optimization methods for an edge network based on AI techniques.  ...  The network edge is becoming a new solution for reducing latency and saving bandwidth in the Internet of Things (IoT) network.  ...  In [38] , the authors proposed FL algorithms for optimizing the edge network. They aimed to optimize the system-wide cost efficiency of FL using Lyapunov optimization theory.  ... 
doi:10.3390/electronics10222830 fatcat:kddhl7usq5aj5g3mr623lb24hm

Middle-tier database caching for e-business

Qiong Luo, Sailesh Krishnamurthy, C. Mohan, Hamid Pirahesh, Honguk Woo, Bruce G. Lindsay, Jeffrey F. Naughton
2002 Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02  
On deployment of a DBCache at an application server, arbitrary SQL statements generated from the unchanged application that are intended for a backend database server, can be answered: at the cache, at  ...  Using a general-purpose industrial-strength DBMS for middle-tier database caching is especially attractive to e-Businesses, even though there have been special-purpose solutions (for example, e-Bay uses  ...  We would also like to thank Satya Dash, Joseph Fung, Jim Kleewein, Peter Schwarz, and David Tolleson for answering our questions on the ECDW benchmark, DB2 federated features, and DPropR.  ... 
doi:10.1145/564691.564763 dblp:conf/sigmod/LuoKMPWLN02 fatcat:acygvhen45bbtbz7yryfr2npw4

Exploiting Information-centric Networking to Federate Spatial Databases

Andrea Detti, Giulio Rossi, Nicola Blefari Melazzi
2019 IEEE Access  
In this work, we present an architecture that is able to federate spatial databases and evaluate its performance using a real data set coming from OpenStreetMap within a heterogeneous federation formed  ...  by MongoDB and CouchBase spatial database systems.  ...  ACKNOWLEDGMENT The document reflects only the author's view, European Commission and Japanese MIC are not responsible for any use that may be made of the information it contains.  ... 
doi:10.1109/access.2019.2953043 fatcat:qgwe6ifvcjbebb625obekyp3ya
« Previous Showing results 1 — 15 out of 7,168 results