Patent EP0501160A2 successfully refreshed from Google Patents.
EP0501160A2
Expired / Lapsed
EP
⏱️ 0.0 years remaining
Intelligent page store for concurrent and consistent access to a database by a transaction processor and a query processor
Assignee: International Business Machines Corp
•
Filing: 1992-01-30
•
Granted: —
•
Expires: 2012-01-30
Abstract
Abstract A method and apparatus, embodied in an Intelligent Page Store (10), for providing concurrent and consistent access to a functionally separate transaction entity and a query entity to a shared database, while maintaining a single physical copy of most of the data. The Intelligent Page Store (10) contains shared disk storage, and an intelligent versioning mechanism allows simultaneous access by the transaction en-tity and the query entity to the shared data. The transaction entity is presented the current data and the query entity is presented a recent and consistent version of the data. A single copy of all but recently updated pages is maintained by the Intelligent Page Store (10). The query and transaction entities operate independently of each other and are separately optimized.
Inventors
- 👤 Daniel Manuel Dias
- 👤 Ambuj Goyal
- 👤 Francis Nicholas Parr
Bibliographic Details
Application Number
—
Jurisdiction
EP
Data Source
google_patents
Last Synchronized
2026-11-03 14:11
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2308; G06F16/2336; G06F16/2343; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 10
Claim 1
Independent Claim
158 words
A database transaction and query processing system, comprising: an intelligent page store for non-volatile storage of a primary version of each page of a database and for creating and maintaining at least one consistent snapshot version of said database for access by queries which do not require access to the most recently updated database pages, said intelligent page store maintaining only one physical copy of any page of said database which is the same in said primary version and said at least one snapshot version of said database; a transaction processor for accessing and updating said primary version pages of said database, said primary version pages being made available to said transaction processor by said intelligent page store; and a query processor independent of said transaction processor for running queries against said at least one consistent snapshot version of said database, said at least one consistent snapshot version of said database being made available to said query processor.
Claim 2
Dependent Claim
20 words
A database system as defined in Claim 1 wherein said transaction processor and said query processor are different physical entities.
Claim 3
Dependent Claim
25 words
A database system as defined in Claim 1 wherein said transaction processor and said query processor are independent processes implemented on the same physical entity.
Claim 4
Dependent Claim
22 words
A database system as defined in Claim 1 wherein said page store maintains more than one consistent snapshot version of said database.
Claim 5
Dependent Claim
54 words
A database system as defined in Claim 1, wherein said transaction processor includes a page buffer providing fast access storage for the most recent version of some of the pages of said database, said intelligent page store not necessarily containing a copy of all of said most recent version pages in said page buffer.
Claim 6
Dependent Claim
45 words
A database system as defined in Claim 5, wherein said intelligent page store creates a consistent snapshot version of said database by flushing said page buffer into said intelligent page store, said primary version of said database after said flushing being a consistent snapshot version.
Claim 7
Dependent Claim
32 words
A database system as defined in Claim 1 having a database log and wherein said intelligent page store derives a consistent snapshot version from said primary version pages and said database log.
Claim 8
Dependent Claim
19 words
A database system as defined in Claim 7 wherein said database log is stored in said intelligent page store.
Claim 9
Dependent Claim
47 words
A database system as defined in Claim 1, wherein said intelligent page store has a first storage space for storing said primary version of each page of said database and a second storage space for storing at least one older version of some pages of said database.
Claim 10
Dependent Claim
327 words
A database transaction and query processing system comprising: a transaction processing entity; a query processing entity; and an intelligent page store having an ordered set of time intervals, the time interval that includes the current time being the current time interval, said intelligent page store providing non-volatile storage for a database comprising a plurality of logical pages, each said logical page being associated with one or more physical pages, one of said physical pages associated with each of said logical pages being the primary physical page and any other physical pages associated with each of said logical pages being designated as auxiliary pages, each auxiliary physical page being associated with a time step, said transaction processing entity and said query processing entity simultaneously making page access requests to said intelligent page store, said transaction processing entity page requests being either read or write requests and said query processing entity page requests being read requests; said intelligent page store further comprising: means for returning to said transaction processing entity the primary physical page corresponding to a logical page requested by said transaction processing entity; means for returning to said query processing entity in response to a specific query either the auxiliary page corresponding to a time interval associated with said specific query or the primary physical page if no auxiliary page exists that corresponds with the time interval associated with said specific query; means for creating a new auxiliary physical page when said transaction processing entity updates the associated logical page if no auxiliary physical page associated with that logical page exists corresponding the current time-step; means for creating a new time interval such that the primary and auxiliary pages associated with said new time interval correspond to a logically consistent set of pages of the database; and means for deleting all of the auxiliary pages associated with any time interval other than the current time interval after all queries associated with that time interval have been completed.
References Cited (Backward Citations)
No citation records indexed.
USPTO Annuity & Maintenance Windows
Maintenance schedule is calculated for granted US utility patents.