An ‘intelligent’ extraction and aggregation tool for company data bases

摘要

To ease the access to data bases for the casual user, a system called SMARTY has been developed as an intelligent front end to the relational data base management system SQL/DS. A user only needs to specify the data attributes and possibly their value ranges which he wants to be displayed. SMARTY will test the meaningfulness of this request for information and subsequently generate and execute the SQL statements for deriving the information from SQL relations. SMARTY is capable of extracting or aggregating detailed information in a company database. It can be regarded as an expert system on top of a relational DBMS to improve the user interface, or as a query system to a universal relation. SMARTY was written in Prolog. Both Prolog and SQL/DS are running under the IBM operating system VM/SP 3.