Demonstration of SemanticAccess: Semantic Interface for Querying Databases

Presented at the VLDB 2000 -- Very Large Databases Conference

Naphtali Rishe, Jun Yuan, Rukshan Athauda, Xiaoling Lu, Xiaobin Ma, Alexander Vaschillo,
Artyom Shaposhnikov, Dmitry Vasilevsky, Shu-Ching Chen
High-performance Database Research Center
School of Computer Science
Florida International University
University Park, Miami, FL 33199
 

SEMANTIC  SQL

Semantic Wrapper of Relational Databases
Sem-ODB, a Semantic DBMS
  • 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
    		•
  • Semantic ODBC/JDBC SQL interface
  • Empowerment of the users to easily pose complex queries via familiar tools, e.g. Crystal Reports
  • Shortens application development cycle
  • Intuitive structure of information, conceptual enterprise model support queries
  • Superior efficiency, compactness
  • Unrestricted varying-size data types, e.g. unlimited precision numbers
  • Internet-integrated                                                       powerpoint
    		•

    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 clocks is roughly proportional to the size of the SQL query generated by the tools in response to the user's clicks):

    Demonstration

    1. Introductional viewgraph presentation: powerpoint or html-gif.

    2. Demonstration (the demonstration comparatively accesses two equivalent databases and you may want to open their respective schemas (in separate windows) here: semantic and relational)
    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 2000, Naphtali Rishe and FIU-HPDRC
    Technology protected by U.S. Patents











    rishe@fiu.edu