Mapping methods and query for aggregation and association in object-relational database using collection

被引:6
作者
Pardede, E [1 ]
Rahayu, JW [1 ]
Taniar, D [1 ]
机构
[1] La Trobe Univ, Dept Comp Sci & Comp Engn, Bundoora, Vic 3086, Australia
来源
ITCC 2004: INTERNATIONAL CONFERENCE ON INFORMATION TECHNOLOGY: CODING AND COMPUTING, VOL 1, PROCEEDINGS | 2004年
关键词
D O I
10.1109/ITCC.2004.1286513
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Association and aggregation are two relationship types in the Object-Oriented Conceptual Model (OOCM) that frequently involve collection of elements/attributes. However, very often when the relationships are stored in Object Relational Database (ORDB) the collection is flattened like it is implemented by pure relational model. In this paper we propose the mapping methods to preserve the collection semantics in ORDB using collection data type. In aggregation we propose methods for different constraints types, while in association we propose methods for "many" cardinality (I:N, N:N) relationships. In addition, we also show how queries can be performed in the relationships using collection type.
引用
收藏
页码:539 / 543
页数:5
相关论文
共 50 条
[21]   Database independent migration of objects into an, object-relational database [J].
Munir, K ;
Hassan, MW ;
Ali, A ;
McClatchey, R ;
Willers, I .
IWADS: 2ND INTERNATIONAL WORKSHOP ON AUTONOMOUS DECENTRALIZED SYSTEM, PROCEEDINGS, 2002, :132-139
[22]   CASE Tool for Object-Relational Database Designs [J].
de Castro, Thiago Rais ;
Alves de Souza, Solange N. ;
de Souza, Luiz Sergio .
7TH IBERIAN CONFERENCE ON INFORMATION SYSTEMS AND TECHNOLOGIES (CISTI 2012), 2012,
[23]   Design and implementation of an object-relational multimedia database [J].
Hu, MJ ;
Miao, CY ;
San, STH ;
Aik, GJ .
ICICS - PROCEEDINGS OF 1997 INTERNATIONAL CONFERENCE ON INFORMATION, COMMUNICATIONS AND SIGNAL PROCESSING, VOLS 1-3: THEME: TRENDS IN INFORMATION SYSTEMS ENGINEERING AND WIRELESS MULTIMEDIA COMMUNICATIONS, 1997, :573-577
[24]   CASE Tool for Object-Relational Database Designs [J].
de Castro, Thiago Rais ;
Alves de Souza, Solange N. ;
de Souza, Luiz Sergio .
SISTEMAS Y TECNOLOGIAS DE INFORMACION, VOLS 1 AND 2, 2012, :181-+
[25]   An object-relational database system for the interactive multimedia [J].
Hu, MJ ;
Miao, CY .
1997 IEEE INTERNATIONAL CONFERENCE ON INTELLIGENT PROCESSING SYSTEMS, VOLS 1 & 2, 1997, :1571-1575
[26]   Leveraging Machine Learning for Optimal Object-Relational Database Mapping in Software Systems [J].
Azizian, Sasan ;
Rastegari, Elham ;
Bagheri, Hamid .
PROCEEDINGS OF THE 1ST ACM INTERNATIONAL CONFERENCE ON AI-POWERED SOFTWARE, AIWARE 2024, 2024, :94-102
[27]   An object-relational neural network database type [J].
Schikuta, Erich ;
Glantschnig, Paul .
PROCEEDINGS OF THE IASTED INTERNATIONAL CONFERENCE ON ARTIFICIAL INTELLIGENCE AND APPLICATIONS, 2007, :30-+
[28]   Leveraging Machine Learning for Optimal Object-Relational Database Mapping in Software Systems [J].
Azizian, Sasan ;
Rastegari, Elham ;
Bagheri, Hamid .
AIware 2024 - Proceedings of the 1st ACM International Conference on AI-Powered Software, Co-located with: ESEC/FSE 2024, :94-102
[29]   Model Transformation for Object-Relational Database Development [J].
Vara, Juan M. ;
Vela, Belen ;
Ma Cavero, Jose ;
Marcos, Esperanza .
APPLIED COMPUTING 2007, VOL 1 AND 2, 2007, :1012-1019
[30]   Evaluating Query Performance on Object-Relational Spatial Databases [J].
Zhou, Zhonghai ;
Zhou, Bin ;
Li, Wenwen ;
Griglak, Brian ;
Caiseda, Carmen ;
Huang, Qunying .
2009 2ND IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY, VOL 4, 2009, :489-+