TY - JOUR
T1 - Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach
AU - Lee, Ghang
AU - Jeong, Jiyong
AU - Won, Jongsung
AU - Cho, Chiyon
AU - You, Seok Joon
AU - Ham, Sungil
AU - Kang, Hoonsig
PY - 2014/3/1
Y1 - 2014/3/1
N2 - Most previous industry foundation classes (IFCs) servers were developed based on relational databases (RDBs), and many studies reported performance problems. This study developed the object-relational IFC (OR-IFC) server using the object-relational database (ORDB) approach to improve query performance by simplifying the mapping process of the inheritance structure and the aggregation concepts. In addition to the OR-IFC server, a RDB-based IFC server was also developed using mapping rules on the same database-management system as that on which the OR-IFC server was implemented to compare the performance of the ORDB- and RDB-based systems. The performance of the OR-IFC server and the RDB-based IFC server was evaluated using the Benchmark of Universal or Complex Kwery Ynterfaces benchmark method, and two test-case models with different sizes were used. The benchmark results clearly showed the query-performance improvement of the suggested OR approach. The OR-IFC server far outperformed the RDB-based server in every query related to object-oriented features such as inheritance, collection-type data, and referencing.
AB - Most previous industry foundation classes (IFCs) servers were developed based on relational databases (RDBs), and many studies reported performance problems. This study developed the object-relational IFC (OR-IFC) server using the object-relational database (ORDB) approach to improve query performance by simplifying the mapping process of the inheritance structure and the aggregation concepts. In addition to the OR-IFC server, a RDB-based IFC server was also developed using mapping rules on the same database-management system as that on which the OR-IFC server was implemented to compare the performance of the ORDB- and RDB-based systems. The performance of the OR-IFC server and the RDB-based IFC server was evaluated using the Benchmark of Universal or Complex Kwery Ynterfaces benchmark method, and two test-case models with different sizes were used. The benchmark results clearly showed the query-performance improvement of the suggested OR approach. The OR-IFC server far outperformed the RDB-based server in every query related to object-oriented features such as inheritance, collection-type data, and referencing.
UR - http://www.scopus.com/inward/record.url?scp=84894440378&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=84894440378&partnerID=8YFLogxK
U2 - 10.1061/(ASCE)CP.1943-5487.0000256
DO - 10.1061/(ASCE)CP.1943-5487.0000256
M3 - Article
AN - SCOPUS:84894440378
SN - 0887-3801
VL - 28
SP - 210
EP - 222
JO - Journal of Computing in Civil Engineering
JF - Journal of Computing in Civil Engineering
IS - 2
ER -