This page briefly introduces the features of EML (E-model Language) and the E-model system.


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 grammar

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


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.
  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
  • Agile Manufacturing
  • Agile Manufacturing Flexible manufacturing (Kidd, 1994): Flexibility is a requirement for the competitive markets of today. Lean manufacturing: It involves doing everything with less. Cut away the excess of wasteful activities, unnecessary inventory, long lead times, and so on. The purpose of leaning manufacturing includes (1) just-in-time manufacturing, concurrent engineering, overhead cost reduction, improved supplier and customer relations, and total quality management (Womack et al., 1990). Agile manufacturing: Agility is dynamic and open-ended.

  • Professional masters applied systems engineering
  • Objectives Develop labs for PMASE ASE 6001 Introduction to Systems Engineering course: Lab 1: Requirements analysis Lab 2: Functional analysis, architecture options and definitions The purpose of this lab is to study the requirements analysis techniques in the system engineering. Requirements specify the functionality that must be included in the final product. It is critical that the requirements be written such that is no misunderstanding between the developer and the stakeholders.

  • Quality function deployment
  • Quality function deployment (QFD) Reference: 1 Objectives To convert the users’ needs (or customers’ demands) for product benefits into substitute quality characteristics at the design stage. To deploy the substitute quality characteristics identified at the design stage to the production activities, thereby establishing the necessary control points and check points prior to production start-up.

  • Requirements use case tools
  • Available software for requirement use case engineering Software list is available at 1 and 2. Software Price Comment Automated requirements measurement tool (ARM) Free Altova UModel Commercial Free evaluation SketchUML Commercial Requirements use case tool (RUT) Free Accompa Commercial Accept 360 Commercial Accompa Commercial Ask credit card info for evaluation ArcWay AG Commercial Needs personal contact for background check.