This page briefly introduces the features of EML (E-model Language) and the E-model system. Details are submitted to journals for review (See below Main Publication).


EML is an E-model data query language extending the SQL-89 standard with enhanced features: (1) unstructured query, (2) semantic query expansion, (3) temporal query, (4) ranked ordering, (5) path query, and (6) natural join.

Eml features.png

EML grammar

The EML grammar is written in Backus–Naur Form using Gold Parsing System. Complete one will be released after publication.

Eml bnf.png

EML interpreter

EML interpreter converts the statement writting in EML into SQL statements. The current E-model system prototype is developed on top of relational database as pure SQL statements. Thus EML interprets EML codes into SQL statements. An interpreter is the next step after parsing and it is developed based on Astudillo C++ Engine.

E-model system

An E-model database system is built atop of relational database. Its full functions are implemented using hundreds of SQL procedures and functions. The idea is when a database system adds the E-model database to existing databases, then a user can query the database in the mixture of structured queries and E-model queries. EML implements such ideas with an extend SQL language to support both structured and unstructured queries with various feature additions.


Main publications

  1. Pilho Kim and Vijay Madisetti, EML: An Extended SQL language for the E-model, in preparation for submission to the ACM Transactions on Multimedia Computing, Communications, and Applications, 2009.
  2. Pilho Kim and Vijay Madisetti, Hybrid graph data model implementation on the relational database system, in preparation for submission to the IEEE Transactions on Knowledge and Data Engineering, 2009.

Related publications

  1. Pilho Kim and Ramesh Jain, Category-based functional information modeling for echronicles, in Proc. IEEE 22nd International Conference on Data Engineering Workshops, Atlanta, USA, pp. 1-8, 2006. IEEE XPlore
  2. Pilho Kim, Ullas Gargi, and Ramesh Jain, “Event-based multimedia chronicling systems,” in Proc. of the 2nd ACM workshop on Capture, Archival and Retrieval of Personal Experiences, Hilton, Singapore, pp. 1-12, 2005. ACM Portal
  3. Pilho Kim and Ramesh Jain, Heterogeneous media events processing systems, ETP '04: Proceedings of the 2004 ACM SIGMM workshop on Effective Telepresence, New York, NY, USA, pp. 52-54, 2004. ACM Portal
  4. Rahul Singh, Zhao Li, Pilho Kim, Derik Pack, and Ramesh Jain, Event-based modeling and processing of digital media, International Workshop on Computer Vision meets Databases, Maison de la Chimie, Paris, France, pp. 19-26, 2004. ACM Portal