Technical Status Report - 96Q3 Ian Davis University of Waterloo Progress Report In the period October 1st - December 31 1995 we improved our Hybrid Query Processor (HQP), provided many demonstrations of this software, developed and presented change proposals for SQL/MM based on our experience with this software, assisted CSSC by providing material for the CSSC home page, provided interim releases of our software to Grafnetix, and made our HQP and associated demonstration software available (via the World Wide Web) to all members of CSSC for evaluation and comment. Achievements The HQP and some of our agents were enhanced so that they provide support for views (331, 341) and access to the SQL2 information schema (161, 180, 331, 341). Dynamic run time query optimisation was also added to the HQP and agent execution engines (331). A more complete text pattern matching language was implemented within our pat agent which provided support for the 'comma' operator (331, 341). The ODBC interface was enhanced (341), and work began on providing support for the SQL2 left/right/union and full join (331, 341). Work also began on providing support for the Data Definition Language (DDL) (331). We demonstrated our HQP and our interfaces to it from the World Wide Web to the Honourable John Manley, Minister of Industry and other dignitaries on October 10th, to CASCON'95 between November 6th and 9th, and to a representative from Industry Canada on November 23rd (395, 941). We completed the development of change proposals for SQL/MM which described how structured text could be supported as an Abstract Data Type (ADT) within SQL3 (170). These change proposals were presented to and reviewed by the Canadian Advisory Committee which met in Victoria on November 16-17th, and were approved as a Canadian proposal in Toronto on December 20th (170, 930). They are to be reviewed by the next International SQL/MM Rapporteur Group meeting which meets January 15-19 in London, England (930). We began the process of developing test specifications (710). We purchased and installed an additional 8 GByte of disk space on our development platforms (910). Problem review We encountered no significant problems impacting on our progress during the last quarter. We encountered minor problems with hardware. Most notably we experienced a fire in early October, and the failure of a communication controller in December. The current data sources available for demonstration purposes are somewhat limited. We continue to search for alternative data sources which might effectively demonstrate our HQP capabilities, and in particular its ability to integrate text with other forms of relational information. Coming events plan Weekly meetings of the research group within the University will continue throughout the next period. The next meeting of the HQP WG is scheduled for January 5th, 1995, and will be held at Grafnetix in Montreal. We plan to attend. We will be sending a Canadian delegate to the SQL/MM Rapporteur Group meeting in London, England January 15-19th. We will be hosting a working meeting of the SQL/MM Canadian Advisory Committee at University of Waterloo April 23-24th. Project Status 6 110 Model Requirements [A] 94May01 94Sep30 100% 7 110 Model Requirements [B] 94Oct01 95Jan30 100% 18 120 DDL Design [A] 94Jan01 94Dec30 100% 19 120 DDL Design [B] 95Feb01 95Feb30 100% 20 120 DDL Design [C] 95Mar01 94Mar30 100% 22 131 DDL Interface Validator [A] 94Oct01 95Jan30 100% 23 131 DDL Interface Validator [B] 95Feb01 95Mar30 100% 33 140 DDL Specification [A] 95Jul01 95Dec30 10% 34 140 DDL Specification [B] 96Dec01 96Jun30 0% 42 150 DML Design [A] 94Jan01 94Jun30 100% 43 150 DML Design [B] 94Jul01 94Sep30 100% 44 150 DML Design finalized 94Oct01 95Jan30 100% 46 161 DML Interface Validator [A] 95Jan01 95Jun30 100% 47 161 DML Interface Validator [B] 95Jul01 96Jan31 100% 48 161 DML Interface Validator [C] 96Feb01 96Jun30 0% 49 161 DML Interface Validator [D] 96Jul01 96Dec30 0% 59 170 DML Specification 95Jul01 95Dec30 100% 60 170 DML Specification 96Jan01 96Jun30 100% 66 180 API Design [A] 94Oct01 94Dec30 100% 67 180 API Design [B] 95Jan01 95Sep30 100% 68 180 API Design [C] 95Oct01 95Dec30 10% 74 190 API Specification [A] 96Jan01 96Jun30 0% 75 190 API Specification [B] 96Jul01 96Dec30 0% 125 310 HQP Requirements [A] 94Oct01 95Jan01 100% 126 310 HQP Requirements [B] 95Jan01 95Mar30 100% 132 320 HQP Design [A] 94Jan01 94Dec30 100% 133 320 HQP Design [B] 95Jan01 95Mar30 100% 135 331 HQP Prototype [A] 94Jan01 94Jun30 100% 136 331 HQP Prototype [B] 94Jan01 95Jun30 100% 137 331 HQP Prototype [C] 95Jul01 96Jan31 95% 138 331 HQP Prototype [D] 96Feb01 96Jun30 0% 146 341 HQP/Agent Integration 94Sep01 95Jun30 80% 146 341 Agent/Oracle Integration 95Apr01 95Sep30 70% 341 Agent/DB2 Integration 95Apr01 95Sep30 70% 147 341 Agent/Fulcrum Integration 95Oct01 96Jun30 70% 148 341 Agent/Pat Integration 95Oct01 96Jun30 80% 350 CGI interface to HQP 80% 520 Web Site Gateway to HQP 80% 900 Project Coordination 93Apr01 97Mar31 60% Ian Davis. December 31, 1995