Patent US5596747A successfully refreshed from Google Patents.
US5596747A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for reorganizing an on-line database system in accordance with an access time increase
Assignee: NEC Corp
•
Filing: 1995-06-01
•
Granted: 1997-01-21
•
Expires: 2015-06-01
Abstract
Abstract A database operation control system includes a database checker, a database saver, a database diagnoser, a logical image creator, a database creator, and a database restorer. The database checker checks an access time taken for retrieval processing, and records an access time increase in an access time record file. The database saver saves data from the database to a save file. The database diagnoser compares the access time increase with a reorganization start increase as a reference value obtained from the access time record file to diagnose whether recognition is necessary, and informs the database saver of the necessity of the execution of reorganization processing of the database, if it is determined that reorganization is required. The logical image creator decomposes data of the save file into logical units to create logical images, and stores them in a logical image file. The database creator creates a restoration file. The database restorer restores data from the restoration file to the database. Reorganization processing is automatically performed in accordance with the access time increase obtained by the database checker.
Inventors
- 👤 Nobue Katabami
- 👤 Tadashi Itoh
- 👤 Yasutomo Takahashi
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 13:23
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/30; G06F11/34; G06F11/3409; G06F11/3419; G06F16/00; G06F2201/00; G06F2201/80; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942
Claims Analysis
Total Claims: 18
Claim 1
Independent Claim
290 words
A database operation control system for reorganization processing of a database, which is performed while an online database system is active, comprising: database check means for sequentially retrieving relational records from said database with an active online application program and logical addresses set to indicate correlation of the relational records, checking an access time taken for the retrieval, calculating an increase in access time from the access time and a previous access time and recording the access time increase in an access time record file; database save means for saving data from said database to a save file; database diagnosis means for obtaining a reorganization start increase from said access time record file as a reference value for determining whether to execute reorganization, comparing the access time increase obtained from said database check means with the reorganization start increase obtained from said access time record file, diagnosing that reorganization is necessary when the access time increase exceeds the reorganization start increase, and informing said database save means that reorganization processing of said database must be executed if the necessity of reorganization is determined; logical image creation means for decomposing data of said save file into logical units, creating logical images as records arranged in the order of logical values, and storing the logical images in a logical image file; database creation means for determining an optimal storage position for data in said logical image file, creating a restoration file and storing said logical images in said logical image file at said optimal storage position in said restoration file; and restoration means for restoring data from said restoration file to said database, such that reorganization processing is performed in accordance with the access time increase obtained by said database check means.
Claim 2
Dependent Claim
290 words
A database operation control system for reorganization processing of a database, which is performed while an online database system is active, comprising: database check means for sequentially retrieving relational records from said database with an active online application program and logical addresses set to indicate correlation of the relational records, checking an access time taken for the retrieval, calculating an increase in access time from the access time and a previous access time and recording the access time increase in an access time record file; database save means for saving data from said database to a save file; database diagnosis means for obtaining a reorganization start increase from said access time record file as a reference value for determining whether to execute reorganization, comparing the access time increase obtained from said database check means with the reorganization start increase obtained from said access time record file, diagnosing that reorganization is necessary when the access time increase exceeds the reorganization start increase, and informing said database save means that reorganization processing of said database must be executed if the necessity of reorganization is determined; logical image creation means for decomposing data of said save file into logical units, creating logical images as records arranged in the order of logical values, and storing the logical images in a logical image file; database creation means for determining an optimal storage position for data in said logical image file, creating a restoration file and storing said logical images in said logical image file at said optimal storage position in said restoration file; and restoration means for restoring data from said restoration file to said database, such that reorganization processing is performed in accordance with the access time increase obtained by said database check means.
Claim 3
Dependent Claim
34 words
The database operation control system as claimed in claim 1, wherein the database check means further records a processing date, an average access time, and a processing count in the access time record file.
Claim 4
Dependent Claim
55 words
The database operation control system as claimed in claim 1, wherein the database check means records a processing start time prior to retrieving the relational records, records an end time at an end of retrieving the relational records, and calculates the access time based on a difference between the start time and the end time.
Claim 5
Dependent Claim
37 words
The database operation control system as claimed in claim 1, wherein a user of said database sets the reference value, which is stored in said access time record file, for later retrieval by said database diagnosis means.
Claim 6
Dependent Claim
27 words
The database operation control system as claimed in claim 4, wherein a database identifier is stored along with the reference value in said access time record file.
Claim 7
Dependent Claim
51 words
The database operation control system as claimed in claim 1, wherein said database check means calculates an average access time on a basis of sequential retrieval times based on logical addresses of the relational records, said average access time being output to said database diagnosis means as said access time increase.
Claim 8
Dependent Claim
41 words
The database operation control system as claimed in claim 6, wherein the reference value corresponds to the average access time calculated by said database check means at a time of initial storage of all of the relational records into said database.
Claim 9
Dependent Claim
32 words
The database operation control system as claimed in claim 7, wherein all of the relational records in said database are retrieved when determining the access time increase with said database check means.
Claim 10
Independent Claim
246 words
A method for the reorganization processing of a database, in a database operation control system, performed while an online database system is active, comprising the steps of: sequentially retrieving relational records from said database with an active online application program and logical addresses set to indicate correlation of the relational records, checking an access time taken for the retrieval, calculating an increase in access time from the access time and a previous access time and recording the access time increase in an access time record file; saving data from said database to a save file; setting a reorganization start increase as a reference value for determining whether to execute reorganization, recording the reference value in said access time record file, comparing the access time increase with the reorganization start increase, diagnosing that reorganization is necessary when the access time increase exceeds the reorganization start increase, and beginning said saving data step if the necessity of reorganization is determined; decomposing data of said save file into logical units, creating logical images as records arranged in order of logical values, and storing the logical images in a logical image file; determining an optimal storage position for data in said logical image file, creating a restoration file, and storing said logical images in said logical image file at said optimal storage position in said restoration file; and restoring data from said restoration file to said database; such that reorganization processing is performed in accordance with the access time increase.
Claim 11
Independent Claim
246 words
A method for the reorganization processing of a database, in a database operation control system, performed while an online database system is active, comprising the steps of: sequentially retrieving relational records from said database with an active online application program and logical addresses set to indicate correlation of the relational records, checking an access time taken for the retrieval, calculating an increase in access time from the access time and a previous access time and recording the access time increase in an access time record file; saving data from said database to a save file; setting a reorganization start increase as a reference value for determining whether to execute reorganization, recording the reference value in said access time record file, comparing the access time increase with the reorganization start increase, diagnosing that reorganization is necessary when the access time increase exceeds the reorganization start increase, and beginning said saving data step if the necessity of reorganization is determined; decomposing data of said save file into logical units, creating logical images as records arranged in order of logical values, and storing the logical images in a logical image file; determining an optimal storage position for data in said logical image file, creating a restoration file, and storing said logical images in said logical image file at said optimal storage position in said restoration file; and restoring data from said restoration file to said database; such that reorganization processing is performed in accordance with the access time increase.
Claim 12
Dependent Claim
31 words
The method as claimed in claim 9, wherein the recording step further comprises recording a processing date, an average access time, and a processing count in the access time record file.
Claim 13
Dependent Claim
52 words
The method as claimed in claim 9, further comprising the step of recording a processing start time prior to retrieving the relational records, recording an end time at an end of retrieving the relational records, and calculating the access time based on a difference between the start time and the end time.
Claim 14
Dependent Claim
22 words
The method as claimed in claim 9, wherein the setting of the reference value is performed by a user of said database.
Claim 15
Dependent Claim
28 words
The method as claimed in claim 12, wherein the user sets a database identifier that is stored along with the reference value in said access time record file.
Claim 16
Dependent Claim
51 words
The method as claimed in claim 9, wherein said access time increase is calculated by determining an average access time on a basis of sequential retrieval times based on logical addresses of the relational records, said average access time being output to said database diagnosis means as said access time increase.
Claim 17
Dependent Claim
33 words
The method as claimed in claim 14, wherein the reference value corresponds to the average access time calculated at a time of initial storage of all of the relational records into said database.
Claim 18
Dependent Claim
24 words
The method as claimed in claim 15, wherein all of the relational records in said database are retrieved when determining the access time increase.
References Cited (Backward Citations)
US4680703A
Cited
US4680705A
Cited
US4807224A
Cited
US5222233A
Cited
US5333311A
Cited
US5408654A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-01-21 | 2000-07-22 | 2001-01-21 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-01-21 | 2004-07-22 | 2005-01-21 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-01-21 | 2008-07-22 | 2009-01-21 | $7700.00 | Window Closed / Lapsed |