DATABASE SYSTEM, METHOD, PROGRAM FOR THE DATABASE SYSTEM, AND A METHOD FOR UPDATING INDEXING TABLES IN A DATABASE SYSTEM
First Claim
1. A database system for searching items stored in a database, said database system comprising;
- a database storing item tables of items appended by timestamps, said items each being categorized by timestamp into said tables, and said item tables being indexed by indexing data;
an indexing table for said indexing data, listing the earliest timestamp of said item table together with said indexing data;
a system manager for searching said item tables using said indexing table; and
a maintenance module for said indexing table, said maintenance module comprising a monitor tool for monitoring said item tables and updating said indexing tables to maintain a correlation between said item tables and said indexing table, wherein said monitor tool invokes from said item table with said indexing data the item with the newest timestamp together with said indexing data and examines said correlation of said indexing table using said invoked timestamp and said indexing data as examination keys.
0 Assignments
0 Petitions
Accused Products
Abstract
A database system, a computer executable method, a computer executable program for the database system, and a method for updating an indexing tables in a database system To provide a database system, a computer executable method, a computer executable program for the database system, and a method for updating an indexing tables in a database system. The database system comprises a database storing item tables of items appended by timestamps. Each of items is further categorized by timestamp into said tables, and said item tables being indexed by indexing data. The database system further comprises an indexing table for said indexing data, listing the earliest timestamp of said item table together with said indexing data and a system manager for searching said item tables using said indexing table and a maintenance module for said indexing table.
-
Citations
6 Claims
-
1. A database system for searching items stored in a database, said database system comprising;
- a database storing item tables of items appended by timestamps, said items each being categorized by timestamp into said tables, and said item tables being indexed by indexing data;
an indexing table for said indexing data, listing the earliest timestamp of said item table together with said indexing data;
a system manager for searching said item tables using said indexing table; and
a maintenance module for said indexing table, said maintenance module comprising a monitor tool for monitoring said item tables and updating said indexing tables to maintain a correlation between said item tables and said indexing table, wherein said monitor tool invokes from said item table with said indexing data the item with the newest timestamp together with said indexing data and examines said correlation of said indexing table using said invoked timestamp and said indexing data as examination keys. - View Dependent Claims (2, 3)
- a database storing item tables of items appended by timestamps, said items each being categorized by timestamp into said tables, and said item tables being indexed by indexing data;
-
4. A computer executable program for a database search method in a database system, said database system comprising a computer including a CPU, a memory, and a storage device, said database being stored in said storage device, said program making said computer execute the steps of:
- storing item tables of items appended by timestamps in a database, said items each being categorized by timestamp into said tables, and said item tables being indexed by indexing data;
storing an indexing table for said indexing data, listing the earliest timestamp of said item table together with said indexing data;
searching said item tables referring said indexing tables, said indexing table being repaired with respect to time evolution by a maintenance module, said maintenance module executing further steps of;
monitoring a correlation between said item tables and said indexing table, invoking from said item table said newest timestamp together with said indexing data, and examining said correlation of said indexing table using said invoked timestamp and said indexing data as examination keys. - View Dependent Claims (5, 6)
- storing item tables of items appended by timestamps in a database, said items each being categorized by timestamp into said tables, and said item tables being indexed by indexing data;
Specification