Patent US6038558A successfully refreshed from Google Patents.
US6038558A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Extensible database retrieval and viewing architecture
Assignee: SAGENT TECHNOLOGIES Inc
•
Filing: 1997-10-17
•
Granted: 2000-03-14
•
Expires: 2017-10-17
Abstract
Abstract One embodiment of the invention includes an architecture for extending the data requesting and data viewing capabilities of a database system. Data from the database is requested and viewed using a plan. The plan defines the steps to perform to request and view the data. The extensible architecture allows for the relatively easy addition of new steps for use in the database retrieval and viewing system. In one system, each step includes executable code for accessing, manipulating and/or outputting data. Each step conforms to a predefined interface that allows the step to be used in a plan, manipulate data received from another step (if necessary), and output data to another step (if necessary). By generating steps that conform to the predefined interface, developers can extend the functionality of the data retrieval and viewing application. In one embodiment, the interface defines the type of step, the number of inputs and outputs to the steps, the type of record accessing characteristics are best used by the step, and whether the step uses the original records or copies of the records. Importantly, the interface does not need to define the actual data manipulation performed by the step. Therefore, the step's internal operations are independent of the operations performed by the application. This separation allows developers to generate powerful steps without having to modify the application to support the new steps.
Inventors
- 👤 Craig R. Powers
- 👤 Vladimir Gorelik
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 12:35
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/248; G06F16/242; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 21
Claim 1
Independent Claim
104 words
A method of accessing data in a data source using a computer system: receiving a selection of a series of steps to be performed in accessing the data, each step in the series of steps including a type, a definition of the inputs and outputs, a definition of data accessing characteristics for the step, and an indication of whether original data or copies of the data are used in the step; receiving a selection of interconnections among the series of steps to create a plan, the plan defining the execution order of the series of steps; and executing the plan to access the data.
Claim 2
Independent Claim
104 words
A method of accessing data in a data source using a computer system: receiving a selection of a series of steps to be performed in accessing the data, each step in the series of steps including a type, a definition of the inputs and outputs, a definition of data accessing characteristics for the step, and an indication of whether original data or copies of the data are used in the step; receiving a selection of interconnections among the series of steps to create a plan, the plan defining the execution order of the series of steps; and executing the plan to access the data.
Claim 3
Dependent Claim
30 words
The method of claim 1 wherein each step in the series of steps defines at least one of a source of data, a data transform or a sink of data.
Claim 4
Dependent Claim
29 words
The method of claim 2 wherein a step in the series of steps defines a source of data as being a table and column in a database management system.
Claim 5
Dependent Claim
27 words
The method of claim 2 wherein a step in the series of steps defines a data transform for converting from a first currency to a second currency.
Claim 6
Dependent Claim
27 words
The method of claim 2 wherein a step in the series of steps defines a data sink as a table to be displayed in an application window.
Claim 7
Dependent Claim
31 words
The method of claim 1 wherein a step in the series of steps is associated with an executable program code to manipulate data when the step is used in the plan.
Claim 8
Dependent Claim
15 words
The method of claim 6 wherein the executable program code includes a dynamic linked library.
Claim 9
Dependent Claim
30 words
The method of claim 1 wherein each step in the series of steps has a common interface for presenting at least the corresponding type and definition of inputs and outputs.
Claim 10
Dependent Claim
28 words
The method of claim 8 wherein the common interface also defines whether a single pass or multiple passes are used in processing that data for the corresponding step.
Claim 11
Dependent Claim
18 words
The method of claim 8 wherein the common interface conforms to the Microsoft Common Object Model (COM) interface.
Claim 12
Independent Claim
142 words
A system for accessing and presenting data, the system comprising: a database management system for accessing and storing source data; a computer, being coupled in communications with the database management system, having, a repository including a plurality of steps, each step in the plurality of steps including a type, a definition of the corresponding inputs and outputs, a definition of data accessing characteristics for the step, and an indication of whether original data or copies of the data are used in the step, and a store having a plurality of programs corresponding to the plurality of steps, each program in the plurality of programs for manipulating the data; an application, coupled in communication with the repository and the store, for data retrieval and viewing using the repository and the store to retrieve, manipulate and present the data in the database management system.
Claim 13
Independent Claim
142 words
A system for accessing and presenting data, the system comprising: a database management system for accessing and storing source data; a computer, being coupled in communications with the database management system, having, a repository including a plurality of steps, each step in the plurality of steps including a type, a definition of the corresponding inputs and outputs, a definition of data accessing characteristics for the step, and an indication of whether original data or copies of the data are used in the step, and a store having a plurality of programs corresponding to the plurality of steps, each program in the plurality of programs for manipulating the data; an application, coupled in communication with the repository and the store, for data retrieval and viewing using the repository and the store to retrieve, manipulate and present the data in the database management system.
Claim 14
Dependent Claim
49 words
The system of claim 11 wherein each step in the plurality of steps is represented by a step object, wherein each step object provides a common interface, and wherein the application accesses the common interface to determine at least the corresponding type, inputs and outputs, and data accessing characteristics.
Claim 15
Dependent Claim
23 words
The system of claim 12 wherein the type of step is one of an input step, a transform step, or an output step.
Claim 16
Dependent Claim
30 words
The system of claim 12 wherein at least one step in the plurality of steps defines an interface for prompting a user for information to be provided to the application.
Claim 17
Dependent Claim
30 words
The system of claim 11 further comprising an on-line transaction processing system for storing source data, the database management system being coupled in communications with the on-line transaction processing system.
Claim 18
Independent Claim
110 words
A system for accessing data in a data source using a computer system: means for receiving a selection of a series of steps to be performed in accessing the data, each step in the series of steps including a type, a definition of the inputs and outputs, a definition of data accessing characteristics for the step, and an indication of whether original data or copies of the data are used in the step; means for receiving a selection of interconnections among the series of steps to create a plan, the plan defining the execution order of the series of steps; and means for executing the plan to access the data.
Claim 19
Independent Claim
110 words
A system for accessing data in a data source using a computer system: means for receiving a selection of a series of steps to be performed in accessing the data, each step in the series of steps including a type, a definition of the inputs and outputs, a definition of data accessing characteristics for the step, and an indication of whether original data or copies of the data are used in the step; means for receiving a selection of interconnections among the series of steps to create a plan, the plan defining the execution order of the series of steps; and means for executing the plan to access the data.
Claim 20
Dependent Claim
30 words
The system of claim 16 wherein each step in the series of steps defines at least one of a source of data, a data transform or a sink of data.
Claim 21
Dependent Claim
29 words
The system of claim 16 wherein a step in the series of steps defines a source of data as being a table and column in a database management system.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-03-14 | 2003-09-13 | 2004-03-14 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-03-14 | 2007-09-13 | 2008-03-14 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-03-14 | 2011-09-13 | 2012-03-14 | $7700.00 | Window Closed / Lapsed |