Completing CAD data queries for visualization

M.G. Koparanova1, T. Risch1
1Uppsala Database Laboratory, Department of Information Technology, University of Uppsala, Sweden

Tóm tắt

A system has been developed permitting database queries over data extracted from a CAD system where the query result is returned back to the CAD for visualization and analysis. This has several challenges. First, CAD data representations use complex object-oriented schemas and the query language must be object-oriented too. Second, the query system resides outside the CAD system and must therefore use standardized data exchange formats for interoperability with the CAD. ISO STEP standard exchange formats are used for the exchange. Third, a CAD system cannot import an arbitrary object structure but places restrictions on the imported objects to be acceptable. Therefore, the query system must complement the query results in order to produce an acceptable CAD model, called the model completion of the query. These problems have been solved using an extensible object-relational query processor. The system also supports queries combining CAD data with data from other data sources.

Từ khóa

#Data visualization #Object oriented modeling #Data engineering #Object oriented databases #Database languages #Data mining #Design engineering #Visual databases #ISO standards #Design automation

Tài liệu tham khảo

10.1109/2.121508 10.1109/69.729736 schenck, 1994, Information Modeling the Express Way, 10.1093/oso/9780195087147.001.0001 2001, Introducing I-DEAS 10.1109/69.87967 härder, 1999, The intrinsic problems of structural heterogeneity and an approach to their solution, The VLDB Journal, 8, 25, 10.1007/s007780050072 2000, International Organization for Standardization, ISO 10303–14 Industrial automation systems and integration - Product data representation and exchange- Part 14 Description methods The EXPRESS-X Language Reference Manual 1994, International Organization for Standardization, ISO 10303–42 2000 Industrial automation systems and integration - Product data representation and exchange - Part 42 Integrated generic resources Geometric and topological representation 1994, International Organization for Standardization, Industrial Automation Systems and Integration - Product Data Representation and Exchange - Part 1 Overview and Fundamental Principles 1994, International Organization for Standardization, Industrial automation systems and integration — Product data representation and exchange — Part 203 Application protocol Configuration controlled 3D design of mechanical parts and assemblies 1996, International Organization for Standardization, ISO 10303–214 1998 Industrial automation systems and integration - Product data representation and exchange - Part 214 Core Data for Automotive Mechanical Design Processes 1994, International Organization for Standardization, ISO/DIS 10303–21 1999 Industrial automation systems and integration - Product data representation and exchange - Part 21 Clear text encoding of the exchange structure josifovski, 1999, Functional Query Optimization over Object-Oriented Views for Data Integration, Journal of Intelligent Information Systems (JIIS), 12, 10.1023/A:1008752909607 josifovski, 1999, Integrating Heterogeneous Overlapping Databases through Object-Oriented Transformations, Proc of the 25th VLDB conference 10.1002/cpe.607 10.1145/3979.4018 2001, PTC Corporation Pro/ENGINEER buchmann, 1985, An Architecture and Data Model for CAD Databases, proc of the 11th VLDB conference, 105 cormen, 1990, Introduction to Algorithms risch, 2000, AMOS II Concepts carey, 1996, PESTO: An Integrated Query/Browser for Object Databases, Proc of the 22nd VLDB Conference, 203 10.1023/A:1008683107812 10.1007/s007780050045 bouganim, 1999, MIROWeb: Integrating Multiple Data Sources Trough Semistructured Data Types, Proc of the 25th VLDB conference haas, 1997, Optimizing Queries across Diverse Data Sources, Proc of the 23rd VLDB Conference, 276 10.1145/115790.115825 10.1016/S0360-8352(98)00050-3 10.1145/28865.28866 kriegel, 2001, DIVE: Database Integration for Virtual Engineering, Demo session on 17th International Conference on Data Engineering lin, 2002, Adaptive data mediation over XML data. To be published in special issue on “Web Information Systems Applications” of Journal of Applied System Studies (JASS) 10.1023/A:1008641408566 orsborn, 1996, Management of Product Data Using an Extensible Object-Oriented Query Language, Second International Conference on Data and Knowledge Systems for Manufacturing and Engineering 10.1109/ICDE.2001.914818