Computer method and system for reconciling disparate data...

Computer graphics processing and selective visual display system – Display driving control circuitry – Controlling the condition of display elements

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C345S215000, C345S215000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

06791585

ABSTRACT:

BACKGROUND OF THE INVENTION
1. Field of the Invention
This invention relates to a computer method and system for reconciling disparate data archival mediums.
2. Introduction to the Invention
Data archival mediums comprising inter alia conventional spreadsheets and database tables, are known. Data archival mediums are available for purchase from sundry commercial vendors.
SUMMARY OF THE INVENTION
Our inventive work centers on a problem arising with respect to reconciling disparate data archival mediums, for example, and in particular, how to extract specific fields from a variety of spreadsheet and database output files.
Now, it is known to solve this problem, by writing programs that are individually specific and tailored to each of the disparate spreadsheet and database formats.
We have discerned, in this regard, that this type of solution, although technically available, may not be optimal. First of all, it presupposes expertise particular to each of the disparate data archival mediums. This expertise, however, cannot always be reasonably provided or assumed. Second, it is a labor intensive solution, and therefore not optimally cost efficient.
We have now discovered a novel computer method and system for reconciling disparate data archival mediums, which discoveries enable one to extract specific fields from a variety of spreadsheet and database output files, without writing programs specific or tailored to each spreadsheet and database format. Accordingly, the present invention now enables one to advantageously reconcile disparate data archive mediums, transparently, as it were, thereby obviating the problems suggested with respect to the prior art. The present invention can facilitate the ease of use of data archival mediums, and enable their greater exploitation by a greater number of users, than heretofore.
Accordingly, in a first aspect of the present invention, we disclose a computer method comprising the steps of:
(i) identifying content included in an arbitrary data archival medium;
(ii) exporting the content to a flat file;
(iii) importing the step (ii) flat file content into an auxiliary Graphical User Interface (GUI);
(iv) specifying with respect to the GUI a subset of GUI content for facilitating interrogation of the subset content; and
(v) displaying the resulting subset content in an appropriate display.
Step (i) preferably comprises identifying content that correlates to at least 5% of total content; for example, 30% of total content that is included in the arbitrary data archival medium.
The data archival medium may comprise, for example, a conventional spreadsheet or a conventional database table.
Step (ii) preferably comprises exporting the content to an ASCII file.
Step (ii) may comprise exporting the content to a flat file in which components of the content are delimited by at least one of comma, blank, tab, semicolon, and $ sign.
Step (ii) preferably comprises exporting content that correlates to at least 5% of total step (i) content.
The step (iii) auxiliary GUI may operate as a common interrogating tool for disparate data archival mediums.
Step (iv) preferably contemplates specifying a subset of GUI content by using a mouse.
Step (iv) may comprise specifying a subset of GUI content by selecting a column defined by the GUI, or alternatively by specifying a range of column values.
Finally, the method may advantageously include a step (vi) comprising adding new fields to the step (iv) subset for the purpose of entering new content.
In a second aspect of the present invention, we disclose a computer system comprising:
(i) means for identifying content included in an arbitrary data archival medium;
(ii) CPU means for exporting the content to a flat file;
(iii) CPU means for importing the flat file content into an auxiliary Graphical User Interface (GUI);
(iv) CPU means for specifying with respect to the GUI a subset of GUI content for facilitating interrogation of the subset content; and
(v) means for displaying the resulting subset content in an appropriate display window.
In a third aspect of the present invention, we disclose a programmable storage device comprising method steps for reconciling disparate data archival mediums, the method comprising the steps of:
(i) identifying content included in an arbitrary data archival medium;
(ii) exporting the content to a flat file;
(iii) importing the step (ii) flat file content into an auxiliary Graphical User Interface (GUI);
(iv) specifying with respect to the GUI a subset of GUI content for facilitating interrogation of the subset content; and
(v) displaying the resulting subset content in an appropriate display window.


REFERENCES:
patent: 5191525 (1993-03-01), LeBrun et al.
patent: 5630131 (1997-05-01), Palevich et al.
patent: 5864848 (1999-01-01), Horvitz et al.
patent: 5914713 (1999-06-01), Nario et al.
patent: 6002865 (1999-12-01), Thomsen
patent: 6031625 (2000-02-01), Sherman et al.
patent: 6094684 (2000-07-01), Pallmann
patent: 6134564 (2000-10-01), Listou
patent: 6240422 (2001-05-01), Atkins et al.
patent: 6341287 (2002-01-01), Sziklai et al.
patent: 6343294 (2002-01-01), Hawley
patent: 6381600 (2002-04-01), Lau

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Computer method and system for reconciling disparate data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Computer method and system for reconciling disparate data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer method and system for reconciling disparate data... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3273544

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.