DataJoiner: a practical approach to multi-database access

Gupta, Praveen Kumar; Lin, Eileen

doi:10.1109/pdis.1994.331706

Cited by 7 publications

(4 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…IBM has long been concerned with providing information virtualization. Products such as DB2 Data-Joiner* 8 and research projects such as Garlic 9 pioneered federated database technology nearly ten years ago. Today, DB2 Information Integrator* 10 is taking further steps towards full virtualization, bringing together federation, replication, transformation, publish, and search technologies into a powerful platform for information integration.…”

Section: Implementing An Information Infrastructure For the Grid: Todaymentioning

confidence: 99%

Towards an information infrastructure for the grid

et al. 2004

View full text Add to dashboard Cite

• Virtualized-allowing a collection of distributed information resources to be shared and managed as if they were a single information store, although they may in fact remain fully distributed. • Autonomic-ensuring that the interconnected information systems can be managed effectively and efficiently through self-management just like the human autonomic nervous system. • Open-utilizing open interfaces and agreed-upon standards to enable highly interoperable systems and processes.

show abstract

Section: Implementing An Information Infrastructure For the Grid: Todaymentioning

confidence: 99%

Towards an information infrastructure for the grid

et al. 2004

View full text Add to dashboard Cite

show abstract

“…[Subramanian and Venkataraman 1998] describe algorithms which analyze the query plan generated by an optimizer to identify similar sub-plans, combine them into transient views and insert filters for compensation. Moreover, [Subramanian and Venkataraman 1998] presenst the implementation of their algorithms within the context of DataJoiner's [Gupta and Lin 1994;Venkataraman and Zhang 1998] query optimizer. They try to optimize a complex decision support query by exploiting common subexpressions within this single query, whereas we try to simultaneously optimize a given set of requests.…”

Section: Related Workmentioning

confidence: 99%

Improving Performance of Heterogeneous Agents

Özcan

Subrahmanian

Dix

2004

Annals of Mathematics and Artificial Intelligence

View full text Add to dashboard Cite

With the increase in agent-based applications, there are now agent systems that support concurrent client accesses. The ability to process large volumes of simultaneous requests is critical in many such applications. In such a setting, the traditional approach of serving these requests one at a time via queues (e.g. FIFO queues, priority queues) is insufficient. Alternative models are essential to improve the performance of such heavily loaded agents. In this paper, we propose a set of cost-based algorithms to optimize and merge multiple requests submitted to an agent. In order to merge a set of requests, one first needs to identify commonalities among such requests. First, we provide an application independent framework within which an agent developer may specify relationships (called invariants) between requests. Second, we provide two algorithms (and various accompanying heuristics) which allow an agent to automatically rewrite requests so as to avoid redundant work-these algorithms take invariants associated with the agent into account. Our algorithms are independent of any specific agent framework. For an implementation, we implemented both these algorithms on top of the IMPACT agent development platform, and on top of a (non-IMPACT) geographic database agent. Based on these implementations, we conducted experiments and show that our algorithms are considerably more efficient than methods that use the A * algorithm.

show abstract

“…1 However, there are large numbers of data sources that are not queried with SQL, and it is precisely this class of non-relational data sources that DB2's Garlic-style query 1Query planning for relational sources does not use the request-reply-compensate protocol, and is not the subject of this paper. See [5].…”

Section: Query Externalizationmentioning

confidence: 99%

“…This paper describes new technology that gives IBM's DB2 Universal Database an extensible capability to access data from diverse non-relational data sources. This Garlic-flavored technology exists alongside, and is complementary to, DB2's existing capability to access data from other relational sources [5]. The paper is structured as follows.…”

Section: Introductionmentioning

confidence: 99%

Garlic

Josifovski

Schwarz

Haas

et al. 2002

Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data

View full text Add to dashboard Cite

In a large modern enterprise, information is almost inevitably distributed among several database management systems. Despite considerable attention from the research community, relatively few commercial systems have attempted to address this issue. This paper describes new technology that enables clients of IBM's DB2 Universal Database to access the data and specialized computational capabilities of a wide range of non-relational data sources. This technology, based on the Garlic prototype developed at the Almaden Research Center, complements and extends DB2's existing ability to federate relational data sources.The paper focuses on three topics. Firstly, we show how the DB2 catalogs are used as an extensible repository for the metadata needed to access remotely-stored information. Secondly, we describe how the Garlic approach to query planning, in which source-specific modules and the federated server cooperate to develop an optimized execution plan, has been realized in DB2. Lastly, we describe how DB2's query execution engine has been extended to support queries and functions that are evaluated remotely.

show abstract

DataJoiner: a practical approach to multi-database access

Cited by 7 publications

References 0 publications

Towards an information infrastructure for the grid

Towards an information infrastructure for the grid

Improving Performance of Heterogeneous Agents

Garlic

Contact Info

Product

Resources

About