IP Library Patent Application 13162090
Patent Application
App. No. 13/162,090

METHOD AND SYSTEM FOR A MULTIPLE DATABASE REPOSITORY

Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US None
App. No.
13/162,090
Abstract

Method, system, and programs for creating partitioned or fragmented log files during data logging to better manage file size, more easily facilitate data retrieval and file optimization. In an embodiment, typically large monolithic log files are fragmented or divided into smaller files that can be searched, stored, vacuumed and retrieved more easily.

Claims (41)

1 . A method, for partitioning files on a machine having at least one processor, storage, and a communication platform comprising the steps of:

storing data, received over the communications platform, in a database;

tracking a criteria for the data utilizing at least one processor;

partitioning the database into a plurality of databases based on the criteria; and

maintaining an index of the plurality of databases.

2 . The method of claim 1 wherein the criteria is at least one of the following:

a temporal limit, a size limit, a data source, a data type and a geographic limit.

3 . The method of claim 1 wherein the index contains characteristics of the plurality of databases.

4 . The method of claim 3 , wherein the characteristics include at least one of the following:

a database name, a server name, a start time, an end time, a system path and a status identifier.

5 . The method of claim 1 further comprising:

computing the amount of free space in the plurality of database, and

storing an amount of additional information in the plurality of databases based on the computing.

6 . The method of claim 5 further comprising:

creating an additional one of a plurality of databases if the computed amount of free space is less then the amount of additional information.

7 . The method of claim wherein the database sizes of the plurality of databases is limited so that an individual database can be vacuumed using known techniques.

8 . The method of claim 7 , where the vacuuming of the individual databases can be completed within 2 to 6 hours.

9 . The method of claim 1 wherein the database sizes of the plurality of databases is limited to a size such that an NTFS compression scheme may be applied to plurality of databases

10 . A method for retrieving information from a plurality of databases on a machine having at least one processor, storage, and a communication platform comprising the steps of:

creating a table comprising characteristics of the plurality of databases;

receiving a query on the machine;

processing the query with the processor to determine the location of the information within the plurality of databases based on the characteristics in the table;

retrieving the information from the plurality of databases; and

communicating that information over the communications platform back to the machine.

11 . A machine readable non-transitory and tangible medium having information recorded thereon for partitioning files on a machine having at least one processor, storage, and a communication platform, to causes the machine to perform the following:

storing data, received over the communications platform, in a database;

tracking a criteria for the data utilizing at least one processor;

partitioning the database into a plurality of databases based on the criteria; and

maintaining an index of the plurality of databases.

12 . The medium of claim 11 wherein the criteria is at least one of the following:

a temporal limit, a size limit, a data source, a data type and a geographic limit.

13 . The medium of claim 11 wherein the index contains characteristics of the plurality of databases.

14 . The medium of claim 13 , wherein the characteristics include at least one of the following:

a database name, a server name, a start time, an end time, a system path and a status identifier.

15 . A system for partitioning files comprising:

a first system for implementing a first application;

a data capture system for receiving data from the first system;

a communications link for conveying the data from the first system to a data capture system;

a data partitioning system for partitioning the data into partitioned data files;

a data storage system for storing the partitioned data files, and

a data indexing system for tracking the partitioned files.

Assignments (8)
RELEASE OF SECURITY INTEREST Recorded Oct 28, 2020
From: WELLS FARGO BANK, NATIONAL ASSOCIATION
To: UNISYS CORPORATION
Reel/Frame 054231/0496 →
RELEASE OF SECURITY INTEREST Recorded Nov 9, 2017
From: WELLS FARGO BANK, NATIONAL ASSOCIATION (SUCCESSOR TO GENERAL ELECTRIC CAPITAL CORPORATION)
To: UNISYS CORPORATION
Reel/Frame 044416/0358 →
SECURITY INTEREST Recorded Oct 6, 2017
From: UNISYS CORPORATION
To: JPMORGAN CHASE BANK, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 044144/0081 →
PATENT SECURITY AGREEMENT Recorded Apr 27, 2017
From: UNISYS CORPORATION
To: WELLS FARGO BANK, NATIONAL ASSOCIATION, AS COLLATERAL TRUSTEE
Reel/Frame 042354/0001 →
RELEASE OF SECURITY INTEREST Recorded Mar 26, 2013
From: DEUTSCHE BANK TRUST COMPANY AMERICAS, AS COLLATERAL TRUSTEE
To: UNISYS CORPORATION
Reel/Frame 030082/0545 →
RELEASE OF SECURITY INTEREST Recorded Mar 15, 2013
From: DEUTSCHE BANK TRUST COMPANY
To: UNISYS CORPORATION
Reel/Frame 030004/0619 →
SECURITY AGREEMENT Recorded Aug 2, 2011
From: UNISYS CORPORATION
To: DEUTSCHE BANK NATIONAL TRUST COMPANY
Reel/Frame 026688/0081 →
SECURITY AGREEMENT Recorded Jun 27, 2011
From: UNISYS CORPORATION
To: GENERAL ELECTRIC CAPITAL CORPORATION, AS AGENT
Reel/Frame 026509/0001 →