Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach

Ghang Lee, Jiyong Jeong, Jongsung Won, Chiyon Cho, Seok Joon You, Sungil Ham, Hoonsig Kang

Research output: Contribution to journalArticle

13 Citations (Scopus)

Abstract

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.

Original languageEnglish
Pages (from-to)210-222
Number of pages13
JournalJournal of Computing in Civil Engineering
Volume28
Issue number2
DOIs
Publication statusPublished - 2014 Mar 1

Fingerprint

Servers
Industry
Agglomeration

All Science Journal Classification (ASJC) codes

  • Civil and Structural Engineering
  • Computer Science Applications

Cite this

Lee, Ghang ; Jeong, Jiyong ; Won, Jongsung ; Cho, Chiyon ; You, Seok Joon ; Ham, Sungil ; Kang, Hoonsig. / Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach. In: Journal of Computing in Civil Engineering. 2014 ; Vol. 28, No. 2. pp. 210-222.
@article{4259c91c9a6d4a4fa55997055c7fcd03,
title = "Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach",
abstract = "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.",
author = "Ghang Lee and Jiyong Jeong and Jongsung Won and Chiyon Cho and You, {Seok Joon} and Sungil Ham and Hoonsig Kang",
year = "2014",
month = "3",
day = "1",
doi = "10.1061/(ASCE)CP.1943-5487.0000256",
language = "English",
volume = "28",
pages = "210--222",
journal = "Journal of Computing in Civil Engineering",
issn = "0887-3801",
publisher = "American Society of Civil Engineers (ASCE)",
number = "2",

}

Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach. / Lee, Ghang; Jeong, Jiyong; Won, Jongsung; Cho, Chiyon; You, Seok Joon; Ham, Sungil; Kang, Hoonsig.

In: Journal of Computing in Civil Engineering, Vol. 28, No. 2, 01.03.2014, p. 210-222.

Research output: Contribution to journalArticle

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

VL - 28

SP - 210

EP - 222

JO - Journal of Computing in Civil Engineering

JF - Journal of Computing in Civil Engineering

SN - 0887-3801

IS - 2

ER -