Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-06-19
2004-02-24
Mizrahi, Diane D. (Department: 2175)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06697808
ABSTRACT:
FIELD OF THE INVENTION
This invention relates to a decision support system that uses a metadata retrieval system to support retrieval of information from one or more data storage devices.
BACKGROUND OF THE INVENTION
Reporting systems such as decision support systems have been developed to efficiently retrieve selected information from data warehouses. One type of decision support system is an on-line analytical processing system (“OLAP”). In general, OLAP systems analyze the data from a number of different perspectives and support complex analyses of large input data sets. OLAP systems generate output upon execution of a report that includes a template to indicate the way to present the output and a filter to specify the conditions of data on which the report is to be processed.
Retrieval of data for such complex analyses as those performed by OLAP systems and other business intelligence or reporting systems can be an extremely complicated and highly time-consuming process. Because the worth of these systems lies in their capability to produce complex results on demand, their value cannot be fully realized if results are slowed due to inefficiencies in the processing platform or if the system is too complex for the user.
SUMMARY OF THE INVENTION
It is therefore desirable to provide a reporting platform from which a user can access information from large databases in as efficient and convenient a manner as possible. In addition, it is desirable to establish a procedure for running a report that allows the report to be quickly and easily regenerated.
Accordingly, an embodiment of the invention provides a method of searching a metadata repository used to store metadata objects relating to data stored in at least one data storage device of a decision support system. The method may include submitting to an object server a search object having search criteria established by a requestor. The method may further include, transferring the search object to a metadata server and searching the metadata repository for objects meeting the search criteria. A search result object, including the objects meeting the search criteria, may then be returned to the requestor.
A method according to embodiments of the invention may further comprise searching the object server for objects meeting the search criteria. The step of searching the object server may be carried out responsive to identification of a predetermined local search attribute in the search object.
In embodiments of a method of searching a metadata repository according to the invention, the requestor of a search may be a user of the decision support system. The requestor may alternatively be a module of the decision support system.
The metadata stored as metadata objects in a metadata repository of an embodiment of the invention may include one or more types of information from various modules, reports, documents, prompts, filters, templates, metrics, custom groups, consolidations, searches, attributes, facts, hierarchies, transformations, partitions, tables, functions, users, database instances, schedules, and other types of data objects.
The step of searching the metadata repository of a method of the invention may include forming at least one SQL query using the search criteria of the search object and executing the at least one SQL query to search the metadata repository.
A method of searching a metadata repository according to an embodiment of the invention may further comprise determining if a result folder has been created for the search object. If no result folder has been created for the search object, the method may comprise creating a result folder. The search result object may then be stored in the result folder. The search result object may also be stored in the metadata repository.
An embodiment of the invention provides a system for retrieving metadata relating to data stored in at least one data storage device of a decision support system having a user engine, an analytical engine, and a query engine. The system may comprise an object server having a server interface portion in communication with at least one of the user engine, the analytical engine, and the query engine. The system may also comprise a metadata repository containing the metadata in the form of metadata objects. The system may further comprise a metadata server in communication with the object server and the metadata repository. The metadata server includes a metadata search engine configured for searching the metadata repository for metadata objects meeting search criteria supplied to the metadata server by the object server.
Other objects and advantages of the invention will be apparent to one of ordinary skill in the art upon reviewing the detailed description of the invention.
REFERENCES:
patent: 4688195 (1987-08-01), Thompson
patent: 4829423 (1989-05-01), Tennant
patent: 5197005 (1993-03-01), Shwartz
patent: 5276870 (1994-01-01), Shan
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: 5890167 (1999-03-01), Bridge
patent: 5914878 (1999-06-01), Yamamoto
patent: 5970493 (1999-10-01), Shoup
patent: 6073129 (2000-06-01), Levine et al.
patent: 6108657 (2000-08-01), Shoup
patent: 6151601 (2000-11-01), Papierniak et al.
patent: 6154766 (2000-11-01), Yost
patent: 6247008 (2001-06-01), Cambot
patent: 6279033 (2001-08-01), Selvarajan
patent: 6374252 (2002-04-01), Althoff et al.
MicroStrategy Announces DSS Agent 5.1, Industry's Leading ROLAP Interface Extends its Reporting Functionality, provides Performance Enhancements & Offers Support for Informatica's PowerMart.
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 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.
Business Objects User's Guide Version 5.1 (electronic copy on enclosed CD).
Getting Started with Business Objects Version 5.1 (electronic copy on enclosed CD).
Business Objects Deployment Guide (electronic copy on enclosed CD).
Broadcast Agent 5.1 (electronic copy on enclosed CD).
Business Objects 5.1 (electronic copy on enclosed CD).
Web Intelligence 2.6 (electronic copy on enclosed CD).
Business Objects Designer's Guide Version 5.1 (electronic copy on enclosed CD).
Business Objects Error Message Guide Version 5.1 (electronic copy on enclosed CD).
Business Objects Generic ODBC Access Guide Version 5.1 (electronic copy on encl
Hurwood William
Li Benjamin Z.
Warikoo Abhimanyu
Hunton & Williams LLP
MicroStrategy Inc.
Mizrahi Diane D.
LandOfFree
Method and system for performing advanced object searching... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for performing advanced object searching..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for performing advanced object searching... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3351611