Dynamic query model and method

Details Dynamic query model and method Dynamic query model and method

1999-07-30

2003-06-17

Kindred, Alford (Department: 2172)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06581054

ABSTRACT:

TECHNICAL FIELD OF THE INVENTION
This invention relates generally to the field of analytical data processing, and more particularly to a dynamic query model and method for performing customized database queries.
BACKGROUND OF THE INVENTION
Business intelligence systems began largely as decision support systems (DSS) and executive information systems (EIS). Decision support systems (DSS) and executive information systems (EIS) were value added systems that provided additional information from existing on-line transactional processing (OLTP) systems.
As business intelligence systems developed, they integrated decision support system (DSS) functionality with executive information system (EIS) functionality, and added on-line analytical processing (OLAP) tools and management reporting tools. These hybrid business intelligence systems were gradually moved from a main-frame environment to a distributed server/desktop environment to allow greater user access.
More recently, the advent of centralized data warehouses and datamarts have created a dramatic increase in available data waiting to be analyzed, exploited and distributed within an organization. Such data warehouses and datamarts, however, were typically optimized for information delivery rather than transactional processing. As a result, data warehouses and datamarts offered only limited solutions for turning stored data into useful and strategic tactical information. During this same time, business intelligence systems gained prominence by offering sophisticated analysis tools for analyzing large amounts of stored information to support effective planning and decision-making within an organization.
Business intelligence systems and other analytical tools typically provide predefined query models to assist novice users and other information consumers in obtaining information from a database. A problem with such predefined query models, however, is they are generic and do not suit specific user needs. To obtain specifically relevant information, a user must himself or herself write a custom query, which usually requires advanced database knowledge. As a result, although all users are able to obtain some information using predefined query models, most users are not able to obtain information that is specifically relevant to them.
SUMMARY OF THE INVENTION
The present invention provides a dynamic query model and method that substantially eliminates or reduces disadvantages and problems associated with previous systems and methods. In particular, predefined query models are provided to users for customization. This allows users to quickly and easily adapt predefined queries to their particular needs.
In accordance with one embodiment of the present invention, a method for generating database queries includes storing a predefined query model for querying a database. An accessible portion of the predefined query model is displayed to a user upon request. User edits to the accessible portion of the predefined query model are received and used to generate a user-adapted query model. A query is then initiated based on the user-adapted query model.
More specifically, in accordance with a particular embodiment of the present invention, the display is a graphical view of accessible data elements defining the predefined query model. A graphical view of accessible data elements includes accessible tables, columns and tables, and joins between tables. In this and other embodiments, a user-adapted query model may include database tables, database columns, and table joints absent or modified from the predefined query model.
Technical advantages of the present invention include providing an improved business intelligence portal that allows query models to be more intelligently generated and used within an organization. In particular, the business intelligence portal allows default query models to be constructed and altered using a graphical view of data elements. To the extent possible, specified data within a query model is automatically linked. As a result, queries can be easily defined and later altered by users without specialized database knowledge.
Another technical advantage of the present invention includes providing a query model and method that allows users to easily obtain and analyze meaningful information. In particular, the predefined query models are provided to users for adaptation and customization. As a result, novice users and other information consumers can alter queries to suit their particular needs. This facilitates robust data analysis by all users and allows novice users to effectively use available information to improve operations within their organization.
Other technical advantages of the present invention will be readily apparent to one skilled in the art from the following figures, description, and claims.


REFERENCES:
patent: 5359724 (1994-10-01), Earle
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5410693 (1995-04-01), Yu et al.
patent: 5481700 (1996-01-01), Thuraisingham
patent: 5548769 (1996-08-01), Baum et al.
patent: 5588109 (1996-12-01), Dickinson et al.
patent: 5671379 (1997-09-01), Kuse et al.
patent: 5701453 (1997-12-01), Maloney et al.
patent: 5721903 (1998-02-01), Anand et al.
patent: 5734380 (1998-03-01), Adams et al.
patent: 5801701 (1998-09-01), Koppolu et al.
patent: 5812394 (1998-09-01), Lewis et al.
patent: 5831617 (1998-11-01), Bhukhanwala
patent: 5842199 (1998-11-01), Miller et al.
patent: 5852818 (1998-12-01), Guay et al.
patent: 5864857 (1999-01-01), Ohata et al.
patent: 5870756 (1999-02-01), Nakata et al.
patent: 5917483 (1999-06-01), Duncan et al.
patent: 5920316 (1999-07-01), Oran et al.
patent: 5943677 (1999-08-01), Hicks
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6026399 (2000-02-01), Kohavi et al.
patent: 6047280 (2000-04-01), Ashby et al.
patent: 6122628 (2000-09-01), Castelli et al.
patent: 6134541 (2000-10-01), Castelli et al.
patent: 6152601 (2000-11-01), Papierniak
patent: 6160549 (2000-12-01), Touma et al.
patent: 6198487 (2001-03-01), Fortenbery et al.
patent: 6205447 (2001-03-01), Malloy
patent: 0 450 825 (1991-03-01), None
patent: 0 490 465 (1991-07-01), None
patent: WO 92/08199 (1992-05-01), None
patent: WO 99/40510 (1999-08-01), None
Bell, et al. “A Flexible Parallel Database System Using Transputers,”Proceedings of the Annual European Conference on Computer Systems and Software Engineering (COMPEURO), May 4-8, 1992, 7 pages.
PCT International Search Report in International Application No. 00/20691, dated Nov. 26, 2001, 6 pages.
PCT International Search Report in International Application No. 00/20708, dated Dec. 6, 2001, 7 pages.
PCT International Search Report in International Application No. 00/20692, dated Dec. 18, 2001, 7 pages.
PCT International Search Report in International Application No. 00/20693, dated Dec. 27, 2001, 9 pages.
Powers, Jr. et al. “User-Friendly Software System for Analyzing Antennas and Radiowave Propagation Links,”Conference Record of MILCOM '92—Military Communications Conference 1992, Oct. 11-14, 1992, 4 pages.
Schmid, et al. “Comparative Multivariate Visualization Across Conceptually Different Graphic Displays,”Proceedings of the Seventh International Working Conference on Scientific and Statistical Database Management 1994, Sep. 28-30, 1994, 10 pages.
“Scrolling Tab Feature for a Notebook Control,”IBM Technical Disclosure Bulletin, vol. 39, No. 7, Jul. 1996, 2 pages.
“Window Pull-Out,”IBM Technical Disclosure Bulletin, vol. 38, No. 8, Aug. 1995, 1 page.
Lehner et al., “Cross-DB: A Feature-Extended Multidimensional Data Model for Statistical and Scientific Database,” ACM Digital Library, pp. 253-260, Aug. 1996.
Business Objects: home page; “Scaleable Solutions for e-business intelligence”; “BusinessObjects 2000 and the Enterprise”;“Product Line Overview—A World of e-Business Intelligence Solutions”; “BusinessObjects—Query, Reporting, and OLAP for Business Users”; “BusinessObjects Infoview—Your Portal for Collaboration and Distribution of e-Business Intelligence”; “WebIntelligence—Integrated Query, Reporting, and Analysis fo

Affiliated with

Also associated with

Rating

Dynamic query model and method does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamic query model and method, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic query model and method will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3092108