System and Method of Processing Information Stored in Databases
In one embodiment the present invention includes a computer implemented method of processing information stored in a data structure. The method includes continuously generating individual records and storing the individual records in a database as a plurality of records. The method further includes selecting, according to a time period, a set of the plurality of records that qualify according to the time period. The method further includes moving the set to a table in the database, wherein the table excludes the plurality of records that are not in the set. In this manner, the records may be stored in a number of parallel tables, and this process may be managed at the application level instead of at the database level. Using parallel tables instead of a single large table may offer performance improvements, for example regarding deleting (or archiving) data.
1 . A computer implemented method of processing information stored in a data structure, comprising:
continuously generating individual records;
storing the individual records in a database as a plurality of records;
selecting, according to a time period, a set of the plurality of records that qualify according to the time period; and
moving the set to a table in the database, wherein the table excludes the plurality of records that are not in the set.
2 . The method of claim 1 , wherein moving the set to the table comprises moving the set to the table such that a physical location of the individual records in the set accounts for a planned future removal of the table from the database.
3 . The method of claim 1 , further comprising:
indexing the set in the table according to a plurality of accounts that are associated with the plurality of records.
4 . The method of claim 1 , wherein the time period comprises a first time period, wherein the set comprises a first set, and wherein the table comprises a first table, further comprising:
selecting, according to a second time period, a second set of the plurality of records that qualify according to the second time period, wherein the second set differs from the first set according to a difference between the first time period and the second time period; and
moving the second set to a second table in the database, wherein the second table excludes the plurality of records that are not in the second set.
5 . The method of claim 1 , further comprising:
storing the table in the database for a defined duration.
6 . The method of claim 1 , further comprising:
removing the table from the database after a defined duration has passed.
7 . The method of claim 1 , further comprising:
removing the table from the database after a defined duration has passed,
wherein the selecting act, the moving act and the removing act when taken together result in a faster removal of the set from the database as compared to deleting the set.
8 . The method of claim 1 , wherein the computer implemented method is implemented by an application server and a database server, wherein the database server is configured to store the individual records in the database, and wherein the application server is configured to instruct the database server to move the set to the table.
9 . A system for controlling a computer system to process information stored in a data structure, comprising:
an application server computer that is configured to continuously generate individual records; and
a database server computer that is configured to store the individual records in a database as a plurality of records,
wherein the application server is configured to select, according to a time period, a set of the plurality of records that qualify according to the time period, and
wherein the application server is configured to instruct the database server to move the set to a table in the database, wherein the table excludes the plurality of records that are not in the set.
10 . The system of claim 9 , further comprising:
a client computer that is configured to provide the individual records to the application server computer.
11 . A computer implemented method of processing information stored in a data structure, comprising:
controlling, by an application server, a database server to configure a plurality of parallel tables in a database;
storing, by the application server, a plurality of rules;
receiving, by the application server, a transaction; and
controlling, by the application server, the database server to store the transaction in an appropriate parallel table according to the plurality of rules.
12 . The method of claim 11 , further comprising:
performing, by the application server, a business process that accesses one of the plurality of parallel tables.
13 . The method of claim 11 , further comprising:
performing, by the application server, a business process that accesses one of the plurality of parallel tables, wherein the accessing is more efficient than when using a single table.
14 . The method of claim 11 , further comprising:
deleting one of the plurality of parallel tables, wherein the deleting is more efficient than when using a single table.
15 . The method of claim 11 , further comprising:
storing one of the plurality of parallel tables for a defined duration; and
removing the one of the plurality of parallel tables from the database after the defined duration has passed.
16 . The method of claim 11 , wherein the transaction comprises a first transaction, and wherein the appropriate parallel table comprises a first appropriate parallel table, further comprising:
receiving, by the application server, a second transaction; and
controlling, by the application server, the database server to store the second transaction in a second appropriate parallel table according to the plurality of rules, wherein the first appropriate parallel table differs from the second appropriate parallel table.