Storing RDF Data Efficiently with E-R modeling

by Arlyn R
At the 2010 3rd IEEE International Conference, LiLi Xu of the Department of Computer Science at Sungkyunkwan University, proposed a new method of storing Resource Description Framework (RDF) data in “E-R Model based RDF Data Storage in RDB.” Xu’s method applies E-R modeling to distinguish the RDF schema information from RDF data, thus allowing faster and more efficient query processing. The author gives a brief overview of RDF and defines it as “… a simple language that provides a flexible mechanism for describing web resources and relationships among them” (Xu, 2010, p.258). However, RDF/RDFS database model is not widely supported by database management systems (DBMS) making the processing of RDF documents or data inefficient. By comparing the current RDF method which uses SPARQL query against the proposed model using SQL query, Xu’s results showed faster processing times. The efficiency of the SQL query can be attributed to the interval numbering scheme that is derived from the E-R diagram that transforms the RDF schema information and data into relational tables.

I found Lili Xu’s submission relevant to the E-R modeling and entity-relationship diagram section of the chapter “Modeling Data in the Organization.” Chapter two made it much easier to understand Xu’s examples and E-R diagram. The author’s experiment also proves the power of E-R modeling and its effectiveness in databases. The correlation of entity-relationship makes it much more efficient for retrieving information. Although we have not yet covered the conversion of conceptual design, this article gave me a good introduction on relation tables.

After reading several journals and articles, I am excited to learn Entity-Relation data modeling as it seems to be essential in database design. An E-R diagram, such as displayed in Xu’s submission, is not only used for conceptual design but also for transforming existing elements of a database. Having a thorough understanding of the business rules seems indicative of a system’s integrity no matter the data modeling method. However, E-R data modeling method captures the business processes distinctively and makes designing and handling a DBMS simpler.

Xu, L., Lee, S.W., & Kim, S..(2010). E-R Model based RDF Data Storage in RDB. 3rd IEEE International Conference Computer Science and Information Technology, 9-11 July 2010. Retrieved from doi: 10.1109/ICCSIT.2010.5565036. Retrieved: October 7, 2012

One thought on “Storing RDF Data Efficiently with E-R modeling

  • October 12, 2012 at 10:05 pm

    Good article! I definitely agree that the EER models are important to databases. I feel everything I have read about databases just more and more re-enforces this point. It is also important to make sure that the model is created correctly as well. Its the same as creating a house. The better the plans are for the house the better it will come out. Thanks for the share.

Comments are closed.