US6684207B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for online analytical processing
Assignee: Oracle International Corp
•
Filing: 2001-08-01
•
Granted: 2004-01-27
•
Expires: 2021-08-01
Abstract
Abstract A system and method for analyzing data is described, in which an application programming interface (API) is provided to permit an online analytical processing (OLAP) application to manipulate data and queries in model close to the business model the OLAP application was designed to support. A data server is provided to translated between the object-oriented representation and the native database query format. In one embodiment, a multidimensional virtual cursor is implementation to further simplify the logic of the OLAP application.
Inventors
- 👤 David Greenfield
- 👤 Geof Fred Lyon
- 👤 Ron Vogl
- 👤 Scott Feinstein
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 00:40
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; G06F16/24; G06F16/242; G06F16/2433; G06F16/2438; G06F16/245; G06F16/2452; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933
Claims Analysis
Total Claims: 4
Claim 1
Independent Claim
79 words
A system for analyzing data, comprising: a data warehouse configured for storing and retrieving data in response to textual queries; a platform configured for executing an analytical processing application; and a data server configured for receiving calls from the analytical processing application to construct a query object, translating the query object into a textual query for submission to the data warehouse, and providing at least some of the data retrieved from the data warehouse in response the textual query.
Claim 2
Independent Claim
79 words
A system for analyzing data, comprising: a data warehouse configured for storing and retrieving data in response to textual queries; a platform configured for executing an analytical processing application; and a data server configured for receiving calls from the analytical processing application to construct a query object, translating the query object into a textual query for submission to the data warehouse, and providing at least some of the data retrieved from the data warehouse in response the textual query.
Claim 3
Dependent Claim
45 words
The system of claim 1 , wherein the data server is further configured for receiving a specification of an extent of a multidimensional cursor from the analytical processing application and providing only the data that fits in the multidimensional cursor to the analytical processing application.
Claim 4
Dependent Claim
44 words
The system of claim 1 , wherein the data server is further configured for receiving a refinement of the query object from the analytical processing application and initiating a subtransaction to handle processing a query that corresponds to the refinement of the query obejct.
References Cited (Backward Citations)
US6094655A
Cited
US6363393B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-01-26 | 2007-07-28 | 2008-01-27 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-01-26 | 2011-07-28 | 2012-01-27 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-01-26 | 2015-07-28 | 2016-01-27 | $7700.00 | Window Closed / Lapsed |