Semantic Interface for Querying Databases

Naphtali David Rishe
High-performance Database Research Center
School of Computer Science
Florida International University
University Park, Miami, FL 33199
 

SEMANTIC  SQL


Semantic Wrapper of Relational Databases
  • An open middleware system providing a semantic view of relational databases
  • From Semantic ODBC/JDBC SQL to ODBC/JDBC SQL
  • Non-invasive enhancement of relational databases allowing empowerment of the willing users to easily pose complex queries to existing databases via familiar tools, e.g. Crystal Reports
  • Shortens application development cycle of willing programmers
  • Reverse Engineering and Documentation Tools

  • powerpoint     white-paper.pdf

    Semantic SQL reduces program sizes:


    Semantic SQL is in standard ODBC/JDBC protocols and therefore is compatible with most third-party tools, while dramatically decreasing the effort of the user working via such tools, whether posing a direct SQL query or designing a query via GUI clicks (the number of GUI clicks is roughly proportional to the size of the SQL query generated by the tools in response to the user's clicks):

    Demonstration

    The demonstration comparatively accesses two equivalent databases and you may want to open their respective schemas (in separate windows) here: semantic and relational. Please also see a documented schema.
    Walk through of the whole demo session  with screen shots.  Or directly jump to any section that you are interested in:
    I: Semantic Wrapper: ODBC/JDBC Middleware between user tools (e.g. MS Access QBE) and Relational  Databases for empowerment of end-user of legacy databases
    II: Reverse Engineering of Legacy Databases: SemanticWrapper Knowledge Base Tool
    III: Query Coordinator (CORBA)
    IV: Semantic DBMS Sem-ODB: Semantic SQL via own GUI and via MS Access QBE

    © Copyright 2003, Naphtali Rishe and FIU-HPDRC
    Technology protected by U.S. Patents









    Contact: