System and method for efficient date retrieval and processing

Details System and method for efficient date retrieval and processing System and method for efficient date retrieval and processing

2001-06-19

2008-09-30

Al-Hashemi, Sana (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07430562

ABSTRACT:
A system and method for efficient data retrieval and processing in an online analytical processing system, a reporting system, a business intelligence system, or a data mining system. The system provides for retrieval and processing of a data result set from a plurality of data sources. The system includes a query structure assembly module, a syntax assembly module, and a process optimization module. The query structure assembly module defines a query structure based upon query assembly rules and a desired data set (such as the set of data for a particular OLAP report). The syntax assembly module defines one or more query language statements based upon the defined query structure. The process optimization module evaluates processing options based upon a database schema associated with the data sources. One or more query language statements may be assembled by the system and run against the data sources to return the desired data result set. 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: 5197005 (1993-03-01), Shwartz
patent: 5261093 (1993-11-01), Asmuth
patent: 5276870 (1994-01-01), Shan
patent: 5349684 (1994-09-01), Edem
patent: 5418943 (1995-05-01), Borgida
patent: 5421008 (1995-05-01), Banning
patent: 5555403 (1996-09-01), Cambot
patent: 5584024 (1996-12-01), Shwartz
patent: 5664182 (1997-09-01), Nirenberg
patent: 5692181 (1997-11-01), Anand
patent: 5864856 (1999-01-01), Young
patent: 5914878 (1999-06-01), Yamamoto
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5935218 (1999-08-01), Beyda
patent: 5940818 (1999-08-01), Malloy et al.
patent: 5983228 (1999-11-01), Kobayashi
patent: 6154766 (2000-11-01), Yost
patent: 6247008 (2001-06-01), Cambot
patent: 6275818 (2001-08-01), Subramanian et al.
patent: 6279033 (2001-08-01), Selvarajan
patent: 6442557 (2002-08-01), Buteau et al.
patent: 6473750 (2002-10-01), Petculescu et al.
patent: 6546381 (2003-04-01), Subramanian et al.
patent: 6574623 (2003-06-01), Leung et al.
Gupta, Himanshu et al., “Index Selection for OLAP,” IEEE 1063-6382, pp. 208-219.
Ho, Ching-Tien et al., “Partial-Sum Queries in OLAP Data Cubes Using Covering Codes,” ACM 0-89791-910-6, pp. 228-237.
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 Computational 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 Languages 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.
Business Objects User's Guide Version 5.1.
Getting Started with Business Objects Version 5.1.
Business Objects Deployment Guide.
Broadcast Agent 5.1.
Business Objects 5.1.
Web Intelligence 2.6.
Business Objects Designer's Guide Version 5.1.
Business Objects Error Message Guide Version 5.1.
Business Objects Generic ODBC Access Guide Version 5.1.
Business Objects Info View User's Guide.
Business Objects Installation and Upgrade Guide.
Business Objects MS Access Database Guide Version 5.1.
Business Objects MS SQL Server Database Guide Version 5.1.
Business Objections Supervisor's Guide Version 5.1.
GIS/LIS'88 Proceedings accessing the world, vol. 2 pp. 741-750.
Quick Start MicroStrategy Agent Version 6.0.
User Guide MicroStrategy Agent Version 6.0.
User Guide MicroStrategy Architect Version 6.0.
User Guide MicroStrategy Objects Version 6.0.
Excel Add-In MicroStrategy Objects Version 6.0.
User Guide MicroStrategy Intelligence Server Version 6.0.
User Guide MicroStrategy Administrator Version 6.0.
Administrator Guide MicroStrategy Administrator Version 6.5.

Affiliated with

Also associated with

Rating

System and method for efficient date retrieval and processing 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 efficient date retrieval and processing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for efficient date retrieval and processing will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3978280