Boots – shoes – and leggings
Patent
1994-03-24
1996-12-10
Amsbury, Wayne
Boots, shoes, and leggings
395922, 395757, 3642742, 3642754, 3642833, 364DIG1, 3649722, 3649746, 364DIG2, G06F 1730, G06F 1727
Patent
active
055840248
ABSTRACT:
A database query system includes a query assistant that permits the user to enter only queries that are both syntactically and semantically valid (and that can be processed by an SQL generator to produce semantically valid SQL). Through the use of dialog boxes, a user enters a query in an intermediate English-like language which is easily understood by the user. A query expert system monitors the query as it is being built, and using information about the structure of the database, it prevents the user from building semantically incorrect queries by disallowing choices in the dialog boxes which would create incorrect queries. An SQL generator is also provided which uses a set of transformations and pattern substitutions to convert the intermediate language into a syntactically and semantically correct SQL query.
The intermediate language can represent complex SQL queries while at the same time being easy to understand. The intermediate language is also designed to be easily converted into SQL queries. In addition to the query assistant and the SQL generator, an administrative facility is provided which allows an administrator to add a conceptual layer to the underlying database making it easier for the user to query the database. This conceptual layer may contain alternate names for columns and tables, paths specifying standard and complex joins, definitions for virtual tables and columns, and limitations on user access.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4688195 (1987-08-01), Thompson et al.
patent: 4689737 (1987-08-01), Grant
patent: 4736296 (1988-05-01), Katayama et al.
patent: 4811207 (1989-03-01), Hikita et al.
patent: 4829423 (1989-05-01), Tennant et al.
patent: 4839853 (1989-06-01), Deerwester et al.
patent: 4914590 (1990-03-01), Loatman et al.
patent: 4930071 (1990-05-01), Tou et al.
patent: 4931935 (1990-05-01), Ohira et al.
patent: 4943933 (1990-07-01), Miyamoto et al.
patent: 4974191 (1990-11-01), Amirghodsi et al.
patent: 4994967 (1991-02-01), Asakawa
patent: 5099426 (1992-03-01), Carlgren et al.
patent: 5175814 (1992-12-01), Anick et al.
patent: 5197005 (1993-03-01), Shwartz et al.
patent: 5204947 (1993-04-01), Bernstein et al.
patent: 5237502 (1993-08-01), White et al.
patent: 5255386 (1993-10-01), Prager
patent: 5265014 (1993-11-01), Haddock et al.
patent: 5265065 (1993-11-01), Turtle
patent: 5349526 (1994-09-01), Potts, Sr. et al.
patent: 5386556 (1995-01-01), Hedim et al.
Wu, "A Knowledge-Based Database Assistant With A Menu Based Natural Language User-Interface" 10 Oct. 1993, IEICI: Trans. Inf. & Syst. V. E76-D N. 10 pp. 1276-1287.
Wu et al, "KDA: A Knowledge-Based Database Assistant With Query Guiding Facility" 5 Oct. 1992, pp. 443-453, IEEE Transactions On Knowledge & Data Eng. V. 4 N. 5.
Cha, "Kaleidoscope: A Cooperative Menu Guided Query Inerface (SQL Version)," 1990, IEEE, Artifical Intelligence Applications.
Whitaker and Bonnell "Functional Modelling Of Intelligent Systems Using A Blackboard Model" 1992, pp. 1 to 12, The Journal Of Knowledge Eng. V 5, N. 1.
Winston, P., "Language Understanding," Artificial Intelligence, 9:291-334 (1984).
Rich, E., "Natural Lanugage Interfaces," Computer, pp. 39-47 (Sep. 1984).
Manferdelli, J. L., "Natural Language Interfaces: Benefits, Requirements, State of the Art and Applications," AI East, Oct. 1987.
Schank, R. C., et al, "Inside Computer Understanding: Five Programs Plus Miniatures," 14:354-372, LEA, Publishers, Hillsdale, NJ (1981).
Hendrix, G., "The Lifer Manual: A Guide to Building Practical Natural Language Interfaces" (Technical Note 138); SRI International, Feb. 1977.
Hendrix, G., "Human Engineering for Applied Natural Language Processing" (Technical Note 139); SRI International, SRI Project 740D32 CTC, Feb 1977.
Kao, M., et al, "Providing Quality Responses with Natural Language Interfaces: The Null Value Problem," IEEE 14:7, 959-984, Jul., 1988.
Chapter 6, "Queries," Building Access Z Applications, 1995.
Chapter 8, "Using Query by Example," Using Access 2 for Windows, Sp. Ed.
Chapter 9, "Querying Your Data," Inside Paradox 5 for Windows, 1994.
Cinque, L., et al, "An Expert Visual Query System," J. Vis. Lang. and Comp., 2:101-113 (1991).
Meng, W., et al. "A Theory of Translation From Relational Queries to Hierarchial Queries," IEEE Transactions on Knowledge and Data Engineering, 7:2, 228-245, Apr. 1995.
Jakobson, G., et al, "CALIDA: A System for Integrated Retrieval from Multiple Heterogeneous Databases," Proceedings of the 3rd Int'l Conf. on Data and Knowledge Bases: Improving Usability and Responsiveness, Jun. 28-30, Jerusalem, Israel.
Amsbury Wayne
Choules Jack M.
Software AG
Talbot C. Scott
Woolston Thomas G.
LandOfFree
Interactive database query system and method for prohibiting the does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Interactive database query system and method for prohibiting the, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Interactive database query system and method for prohibiting the will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-432325