Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2011-08-23
2011-08-23
Chbouki, Tarek (Department: 2165)
Data processing: database and file management or data structures
Database design
Database and data structure management
C706S045000
Reexamination Certificate
active
08005870
ABSTRACT:
A system and method for syntax abstraction in query language generation in an online analytical processing system, a business intelligence system, a reporting system, or a data mining system. The system generates one or more query language statements that can be run against one or more data sources to return a desired data result set. The system includes a syntax pattern selector module and a statement assembly module. The syntax pattern selector module selects a syntax pattern corresponding to a desired function and a syntax standard. The statement assembly module populates the syntax pattern with an argument data set associated with the desired data set. The result is the generation of one or more query language statements with the correct function, syntax, and data parameters to return the desired data result set from the data sources. A method and medium having processor readable code therein are also described.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw
patent: 4688195 (1987-08-01), Thompson
patent: 4829423 (1989-05-01), Tennant
patent: 4839853 (1989-06-01), Deerwester
patent: 4931935 (1990-06-01), Ohira
patent: 5197005 (1993-03-01), Shwartz
patent: 5276870 (1994-01-01), Shan
patent: 5386556 (1995-01-01), Hedin
patent: 5418943 (1995-05-01), Borgida
patent: 5421008 (1995-05-01), Banning
patent: 5555403 (1996-09-01), Cambot et al.
patent: 5584024 (1996-12-01), Shwartz
patent: 5664173 (1997-09-01), Fast
patent: 5664182 (1997-09-01), Nierenberg
patent: 5692181 (1997-11-01), Anand
patent: 5806059 (1998-09-01), Tsuchida et al.
patent: 5813005 (1998-09-01), Tsuchida et al.
patent: 5864856 (1999-01-01), Young
patent: 5914878 (1999-06-01), Yamamoto
patent: 5918232 (1999-06-01), Pouschine
patent: 6101495 (2000-08-01), Tsuchida et al.
patent: 6154766 (2000-11-01), Yost
patent: 6192359 (2001-02-01), Tsuchida et al.
patent: 6212516 (2001-04-01), Kobayashi et al.
patent: 6247008 (2001-06-01), Cambot
patent: 6269359 (2001-07-01), Sekine
patent: 6279033 (2001-08-01), Selvarajan
patent: 6289352 (2001-09-01), Proctor
patent: 6405207 (2002-06-01), Petculescu et al.
patent: 6442557 (2002-08-01), Buteau et al.
patent: 6473750 (2002-10-01), Petculescu et al.
patent: 6490593 (2002-12-01), Proctor
patent: 6523172 (2003-02-01), Martinez-Guerra et al.
patent: 6556988 (2003-04-01), Tsuchida et al.
patent: 6635089 (2003-10-01), Burkett et al.
patent: 6678674 (2004-01-01), Saeki
patent: 6968553 (2005-11-01), Theeten
patent: 7165064 (2007-01-01), Saeki
patent: 2001/0014888 (2001-08-01), Tsuchida et al.
patent: 2001/0020255 (2001-09-01), Hofmann et al.
patent: 2002/0032740 (2002-03-01), Stern et al.
patent: 2002/0087516 (2002-07-01), Cras et al.
patent: 2004/0039730 (2004-02-01), Saeki
patent: 2005/0166209 (2005-07-01), Merrick et al.
Robert C. Stern, Bruce M. Anderson and Craig W. Thompson, A Menu-Based Natural Language Interface To a Large Database, Texas Instruments Incorporated, P. O. Box 660246, MS 238, Dallas, Texas 75266, NAECON: National Aerospace & Electronics Conference, Dayton Ohio, May 20-24, 1985.
Harry R. Tennant, Kenneth M. Ross, Richard M. Saenz, Craig W. Thompson, and James R. Miller, Computer Science Laboratory, Central Research Laboratories, Texas Instruments Incorporated, Dallas, Texas, 21st Annual Meeting of the Association for Computatiional Linguistics, MIT, Jun. 1983, pp. 151-158.
Harry R. Tennant, Member, IEEE, Roger R. Bate, Member, IEEE, Stephen M. Corey, Lawrence Davis, Paul Kline, LaMott G. Oren, Malipatola Rajinikanth, Richard Saenz, Daniel Stenger, Member, IEEE, and Craig W. Thompson, Software Innovations for the Texas Instruments Explorer Computer, Proceedings of the IEEE, vol. 73, No. 12, Dec. 1985.
Craig W. Thompson, Kenneth M. Ross, Harry R. Tennant and Richard M. Saenz, Building Usable Menu-Based Natural Language Interfaces to Databases, Proceedings of the Ninth International Conference on Very Large Data Bases, Florence, Italy, Oct. 31-Nov. 2, 1983, pp. 43-55.
Craig W. Thompson, John Kolts, and Kenneth W. Ross, A Toolkit for Building “Menu-Based Natural Language” Interfaces, Texas Instruments Incorporated, P. O. Box 226015, MS 238, Dallas, Texas 75265, 1985.
Craig Warren Thompson, M.A., B.A., Using Menu-Based Natural Language Understanding to Avoid Problems Associated with Traditional Natural Language Interfaces to Databases, Dissertation Presented to the Faculty of the Graduate School of The University of Texas at Austin, May 1984.
GIS/LIS'88 Proceedings accessing the world, vol. 2 pp. 741-750.
Blum (1987) =Blum, Diamond, Hammon, Perkins, and Semmel, “An Intelligent Navigational Assistant for a Decision Resource Database,” Proceedings of the Third Annual Expert Systems in Government Conference, pp. 19-25 (1987).
Blum (1988) =Blum, Semmel & Sigillito, “Navigating through Complex Databases: A Case Study,” Application of Artificial Intelligence to Command & Control Systems, pp. 380-396 (1988).
1990 Brio DataPrism Reference Manual, Version 1.0 for Apple Macintosh Computers.
1991 Brio DataPrism Reference Manual Update, Version 1.1 for Apple Macintosh Computers.
1990 Brio DataPrism User's Guide, Version 1.1 Update for Apple Macintosh Computers.
1991 Brio DataPrism Update, Version 1.7 for Apple Macintosh Computers.
1987 Metaphor Query Tutorial.
1988 Workstation Tools Training, Metaphor.
1989 Metaphor Database Administration, Release 9.0.
1989 Metaphor Database Administration DBA Tool.
1990 Metaphor Query Tutorial.
Bipin C. Desai et al., “A portable natural language interface,” AFIPS Conference Proceedings, vol. 56, 1987, National Computer Conference, pp. 53-58.
Arthur J. Benjamin et al., “A visual Tool for Managing Relational Databases,” IEEE Int. Conference on Data Engineering, 1986, pp. 661-668.
X. Wu et al., “KDA: A Knowledge-based Database Assistant,” Proceedings Fifth International Conference on Data Engineering, 1989, pp. 402-409.
G. Jakobson et al., “An Intelligent Database Assistant,” IEEE Expert, 1986, pp. 65-79.
Tadao Ichikawa et al., “ARES: A Relational Database with the Capability of Performing Flexible Interpretation of Queries,” IEEE Transactions on Software Engineering, vol. SE-12, No. 5, May 1986, pp. 624-634.
I. Androutsopoulos et al., “Natural Language Interfaces to Databases—An Introduction,” arXiv:cmp-Ig/9503013, vol. 2, Mar. 16, 1995, pp. 1-50.
Eva M. Mueckstein, “Semantic interpretation of a database query language,” Data & Knowledge Engineering 1, 1985, pp. 123-138.
S. L. Booth et al., “A Robust Natural Language Interface to a Decision Support System,” Conference on Software Tools, 1985, pp. 229-236.
Richard Hull et al., “Semantic Database Modeling: Survey, Applications and Research Issues,” ACM Computing Surveys, vol. 19, No. 3, Sep. 1987, pp. 201-260.
Michael D. Gould et al., “Spatial Decision Support Systems: A Bibliography,” National Center for Geographic Information and Analysis, Technical Paper 919, Jun. 1991, 17 pages.
Bedell Jeffrey A.
Chen Yinong
Li Benjamin Z.
Martin Fabrice
Sahasrabudhe Sadanand
Chbouki Tarek
Hunton & Willliams, LLP
Microstrategy Incorporated
LandOfFree
System and method for syntax abstraction in query language... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for syntax abstraction in query language..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for syntax abstraction in query language... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2784786