Abstract
Data and computations of a CAD system have been wrapped by a mediator system using CORBA’s IIOP Protocol. This allows ad hoc declarative mediator queries to be translated into optimised execution plans sending dynamic IIOP messages to a CAD server. Queries may call computational methods provided only by the CAD system. Dynamic query re-optimisation taking into account what data is currently materialised in the mediator substantially improves the performance compared to static optimisation, despite the added optimisation time. The approach provides both increased flexibility and efficiency compared to the conventional navigational use of CORBA-based CAD interfaces. Furthermore, CAD independences is provided since transparent queries and views can be defined over different CAD systems.
Keywords
- Execution Plan
- Mediator System
- Query Execution Plan
- Advance Information System Engineer
- Query Optimisation Technique
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Avnur, R., Hellerstein, J.M.: Eddies Continuously Adaptive Query Processing. In: SIGMOD Conference, pp. 261–272 (2000)
Dogac, A., Dengi, C., Özsu, M.T.: Distributed Object Computing Platforms. Communications of the ACM 41, 95–103 (1998)
Graefe, G., Ward, K.: Dynamic Query Evaluation Plans. In: Proc. of the 1989 ACM SIGMOD Conference, Portland, OR, May 1989, pp. 358–366 (1989)
Haas, L.M., Freytag, J.C., Lohman, J.M., Pirahesh, H.: Extensible query processing in starburst. In: Proceedings of the 1989 ACM SIGMOD international conference on Management of data, June 1989, pp. 377–388 (1989)
Hellerstein, J.: Optimization Techniques for Queries with Expensive Predicated. Transactions of Databases Systems (TODS) 23, 113–157 (1998)
International Organisation for Standardisation: Product data representation and exchange-Part 1: Overview and fundamental principles. ISO 10303-1 (1994)
Jungfer, K., Leser, U., Rodriguez-Tome, P.: Constructing IDL Views on Relational Data. In: Conf. on Advanced Information Systems Engineering, pp. 255–268 (1999)
Koparanova, M., Risch, T.: Completing CAD Data Queries for Visualization. In: International Database Engineering and Applications Symposium (IDEAS 2002), Edmonton, Alberta, Canada, July 17-19 (2002)
Kabra, N., DeWitt, D.J.: Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans. In: ACM SIGMOD Conf., pp. 106–117 (1998)
Litwin, W., Risch, T.: Main Memory Oriented Optimization of OO Queries using Typed Datalog with Foreign Predicates. IEEE Transactions on Knowledge and Data Engineering 4, 517–528 (1992)
Nyström, M.: Engineering Information Integration and Application Development using Object-Oriented Mediator Databases. Department of Applied Physics and Mechanical Engineering, PhD thesis, Luleå University of Technology, 2003:04 (2003)
Nyström, M.: Multidisciplinary Optimisation with Application to Exhaust System Design. In: 8th AIAA/USAF/NASA/ISSMO Symposium on Multidisciplinary Analysis and Optimization, AIAA- 2000-4749, Long Beach, September 6-8 (2000)
Özsu, M.T., Munoz, A., Szafron, D.: An extensible query optimizer for an objectbase management system. In: Proceedings of the fourth international conference on Information and knowledge management, CIKM 1996, pp. 188–196 (1996)
Risch, T., Josifovski, V.: Distributed data integration by object-oriented mediator servers. Concurrency and computation: Practice and experience 13, 933–953 (2001)
Sheu, R.K., Liang, K.C., Yuan, S.M., Lo, W.T.: A New Architecture for Integration of CORBA and OODB. IEEE Transaction on Knowledge and Data Engineering 11, 748–768 (1999)
Unigraphics Solutions Inc.: I-DEAS User’s Guide v9 (2002)
Unigraphics Solutions Inc.: Open I-DEAS User’s Guide v9 (2002)
U.S. National Bureau of Standards (NIST): Initial Graphics Exchange Specification (IGES) – Version 5.1. NISTIR 4412 (1991)
Wiederhold, G.: Mediators in the Architecture of Future Information Systems. IEEE Computer 25, 38–49 (1992)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Nyström, M., Risch, T. (2004). Optimising Mediator Queries to Distributed Engineering Systems. In: Lee, Y., Li, J., Whang, KY., Lee, D. (eds) Database Systems for Advanced Applications. DASFAA 2004. Lecture Notes in Computer Science, vol 2973. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24571-1_43
Download citation
DOI: https://doi.org/10.1007/978-3-540-24571-1_43
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-21047-4
Online ISBN: 978-3-540-24571-1
eBook Packages: Springer Book Archive