Storing RDF Data Efficiently with E-R modeling{1}

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