Adaptive query interface for mining crime data
DNIS'07 Proceedings of the 5th international conference on Databases in networked information systems
| Hi-index | 0.00 |
HyperSQL is an interoperability layer that enablesdatabase administrators to rapidly construct browserbasedquery interfaces to remote Sybase databases.Current browsers (i.e., Netscape, Mosaic, InternetExplorer) do not easily interoperate with databaseswithout extensive "CGI" (Common Gateway Interface)programming. HyperSQL can be used to create formsandhypertext-based database interfaces for non computerexperts (e.g., scientists, business users). Such interfacespermit the user to query databases by filling out queryforms selected from menus. No knowledge of SQL isrequired because the interface automatically composesSQL from user input. Database results are automaticallyformatted as graphics and hypertext, including clickablelinks which can issue additional queries for browsingthrough related data, bring up other Web pages, or accessremote search engines.Query interfaces are constructed by inserting a smallset of HyperSQL descriptors and HTML formatting intotext files. No compilation is necessary because commandsare interpreted and carried out by our special gateway,positioned between the remote databases and the Webbrowser. Feedback from developers who have used theinitial release of HyperSQL has been encouraging. Atpresent, query interfaces have been successfullyimplemented for three major NSF-sponsored biologicaldatabases: Microbial Germplasm Database, MycologicalTypes Collection, and Vascular Plants Types Collection.