Printing system for data handling having a primary server for storing active and passive data and a second server for storing normalized and analytical data

• US 9,250,839 B1
• Filed: 10/31/2014
• Issued: 02/02/2016
• Est. Priority Date: 10/31/2014
• Status: Active Grant

• Current Assignee: KYOCERA Document Solutions, Inc. (Kyocera Corporation)
• Original Assignee: KYOCERA Document Solutions, Inc. (Kyocera Corporation)
• Inventors: Zakharov, Oleg, Shakya, Kiran
• Primary Examiner(s): GARCIA, GABRIEL I
• Application Number:
  US14/529,406
• Time in Patent Office: 459 Days
• Field of Search: 358/1.1, 358/1.9, 358/1.13, 358/1.14, 358/1.15, 358/1.16, 358/402, 709/203, 709/220, 709/223, 705/400, 715/733, 715/760, 715/762
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 3/1273 Print job history, e.g. logging, accounting, tracking

Abstract

Example systems and related methods may relate to handling a plurality of data transmissions from printing devices. Namely, a system may include a primary server and a secondary server. The primary server may include a primary processor and a primary storage device. The secondary server may include a secondary processor and a secondary storage device. The primary processor may be configured to receive and store a plurality of data transmissions from a corresponding plurality of printing devices. The data transmissions may be stored in an active database associated with the primary storage device. Metadata corresponding to the data transmissions may be generated. Some or all of the data transmissions may be archived as secondary data at a secondary server. The secondary data may be pre-processed to form a normalized database. In some embodiments, the metadata and/or the normalized data may be subject to search queries or statistical analysis.

Claims

1. A method comprising:

receiving, at a primary server, a plurality of data transmissions from a corresponding plurality of printing devices, wherein the plurality of data transmissions comprises respective data transmissions, and wherein each respective data transmission is formatted according to an original format and wherein each respective data transmission comprises a respective device identifier;

storing the respective data transmissions in an active database associated with the primary server, wherein storing the respective data transmissions comprises storing the respective data transmissions in the respective original formats;

determining archive-ready data from the stored data transmissions based on a timestamp being beyond a threshold;

storing the archive-ready data as accumulated archive data in a passive archive associated with the primary server;

determining secondary-ready data from the accumulated archive data based on a size of the accumulated archive data;

transferring the secondary-ready data from the primary server to a secondary server;

storing the secondary-ready data as secondary data in a second archive associated with the secondary server; and

pre-processing the secondary data, wherein pre-processing the secondary data comprises;

grouping the secondary data into sections based at least on a respective printing device property of the respective data transmissions of the secondary data; and

forming a normalized database comprising the sections organized based at least on the respective device identifiers of the respective data transmissions of the secondary data.

2. The method of claim 1 wherein transferring the secondary-ready data from the primary server to the secondary server comprises the secondary server accessing the secondary-ready data on the primary server and wherein storing the secondary-ready data as secondary data in the second archive associated with the secondary server comprises the secondary server storing the secondary-ready data as secondary data in the second archive associated with the secondary server.

3. The method of claim 1 wherein transferring the secondary-ready data from the primary server to the secondary server comprises the primary server transferring the secondary-ready data to the secondary server and wherein storing the secondary-ready data as secondary data in the second archive associated with the secondary server comprises the secondary server storing the secondary-ready data as secondary data in the second archive associated with the secondary server.

4. The method of claim 1 wherein receiving the plurality of data transmissions further comprises receiving the respective data transmissions at an average daily rate of at least 1000 respective data transmissions per day.

5. The method of claim 1 wherein determining secondary-ready data comprises the size of the accumulated archive data being above a threshold size.

6. The method of claim 1 further comprising compressing the accumulated archive data.

7. The method of claim 6 further comprising decompressing the secondary data.

8. The method of claim 1 further comprising storing primary metadata based on the respective data transmissions, wherein the primary metadata comprises respective file names and respective file locations of the respective data transmissions within the stored data transmissions.

9. A method comprising:

receiving, at a primary server, a plurality of data transmissions from a corresponding plurality of printing devices, wherein the plurality of data transmissions comprises respective data transmissions, and wherein each respective data transmission is formatted according to an original format and wherein each respective data transmission comprises a respective device identifier;

storing the respective data transmissions in an active database associated with the primary server, wherein storing the respective data transmissions comprises;

storing the respective data transmissions in the respective original formats; and

storing primary metadata based on the stored data transmissions;

receiving, at the primary server, a repair query, wherein the repair query comprises at least one search criteria based on the primary metadata;

determining a query response, wherein the query response comprises respective data transmissions from the stored data transmissions that correspond to the at least one search criteria;

transmitting the query response;

determining archive-ready data from the stored data transmissions based on a timestamp being beyond a threshold;

storing the archive-ready data as accumulated archive data in a passive archive associated with the primary server;

determining secondary-ready data from the accumulated archive data based on a size of the accumulated archive data;

transferring the secondary-ready data from the primary server to a secondary server;

storing the secondary-ready data as secondary data in a second archive associated with the secondary server; and

pre-processing the secondary data, wherein pre-processing the secondary data comprises;

grouping the secondary data into sections based at least on a respective printing device property of the respective data transmissions of the secondary data; and

forming a normalized database comprising the sections organized based at least on the respective device identifiers of the respective data transmissions of the secondary data; and

performing a statistical analysis on the normalized database based on at least one section.

10. The method of claim 9 wherein transferring the secondary-ready data from the primary server to the secondary server comprises the secondary server accessing the secondary-ready data on the primary server and wherein storing the secondary-ready data as secondary data in the second archive associated with the secondary server comprises the secondary server storing the secondary-ready data as secondary data in the second archive associated with the secondary server.

11. The method of claim 9 wherein transferring the secondary-ready data from the primary server to the secondary server comprises the primary server transferring the secondary-ready data to the secondary server and wherein storing the secondary-ready data as secondary data in the second archive associated with the secondary server comprises the secondary server storing the secondary-ready data as secondary data in the second archive associated with the secondary server.

12. The method of claim 9 wherein receiving the plurality of data transmissions further comprises receiving the respective data transmissions at an average daily rate of at least 1000 respective data transmissions per day.

13. The method of claim 9 wherein determining secondary-ready data comprises the size of the accumulated archive data being above a threshold size.

14. The method of claim 9 further comprising compressing the accumulated archive data.

15. The method of claim 14 further comprising decompressing the secondary data.

16. The method of claim 9 wherein the primary metadata comprises respective file names and respective file locations of the respective data transmissions within the stored data transmissions.

17. The method of claim 9 further comprising storing a result of the statistical analysis in an analytical database associated with the secondary server.

18. A system comprising:

a primary server comprising a primary processor and a primary storage device; and

a secondary server comprising a secondary processor and a secondary storage device, wherein the primary processor is configured to;

receive a plurality of data transmissions from a corresponding plurality of printing devices, wherein the plurality of data transmissions comprises respective data transmissions, and wherein each respective data transmissions is formatted according to an original format and wherein each respective data transmissions comprises a respective device identifier;

store the respective data transmissions in an active database associated with the primary storage device, wherein storing the respective data transmissions comprises storing the respective data transmissions in the respective original formats;

store primary metadata based on the stored data transmissions, wherein the primary metadata comprises respective file names and respective file locations of the respective data transmissions within the stored data transmissions;

determine archive-ready data from the stored data transmissions based on a timestamp being beyond a threshold;

store the archive-ready data as accumulated archive data in a passive archive associated with the primary storage device;

determine secondary-ready data from the accumulated archive data based on a size of the accumulated archive data; and

transfer the secondary-ready data from the primary server to a secondary server; and

wherein the secondary processor is configured to;

store the secondary-ready data as secondary data in a second archive associated with a secondary storage device; and

pre-process the secondary data, wherein pre-processing the secondary data comprises;

grouping the secondary data into sections based at least on a respective printing device property of the respective data transmissions of the secondary data; and

forming a normalized database comprising the sections organized based at least on the respective device identifiers of the respective data transmissions of the secondary data.

19. The system of claim 18 wherein the primary server is further configured to:

receive, at the primary server, a repair query, wherein the repair query comprises at least one search criteria based on the primary metadata;

determine a query response, wherein the query response comprises respective data transmissions from the stored data transmissions that correspond to the at least one search criteria; and

transmit the query response.

20. The system of claim 18 wherein the secondary server is further configured to perform a statistical analysis on the normalized database based on at least one section and store a result of the statistical analysis in an analytical database associated with the secondary server.