Method for adding metadata to data

Abstract

A method for adding labels to data, for example XML compliant or XBRL compliant labels, includes a) identifying data in an electronically represented file, b) selecting labels that correspond to text strings in the identified data, based on a list associating labels with text strings, and c) adding the selected labels into the electronically represented file to label the text strings and elements in the identified data associated with the text strings. The labels include information about the data and are defined in one or more taxonomies. When the list does not associate a label with the text string, a user can be prompted to select a label corresponding to a text string in the identified data. The association indicated by the user's selection, can then be added to the list associating labels with text strings.

Description

[0001] This is application is a continuation of U.S. application Ser. No. 10 / 086,522 filed in the U.S. Patent and Trademark Office on 4 Mar. 2002, which claims priority under 35 U.S.C. § 119 to U.S. Provisional Application No. 60 / 312,788, filed in the U.S. Patent and Trademark Office on 17 Aug. 2001, both of which are hereby incorporated by reference.BACKGROUND [0002] 1. Field of the Invention [0003] The invention relates generally to the field of data processing. [0004] 2. Background Information [0005] Currently there are thousands upon thousands of software programs installed in millions of computers that cannot transfer meaning from one to the other. For example, large companies with many branches or subsidiaries often find that the accounting or operating software programs used by one division or subsidiary is not compatible with the software used by other divisions or subsidiaries or the central corporate programs. This requires substantial conversions of data and often results...

AI Technical Summary

Benefits of technology

[0016] In accordance with another embodiment of the invention, a method is provided for importing at least a portion of an XBRL compliant data set into a non XBRL compliant target application. The method includes the steps of exporting data from the target program in an export file, a user associating entries in the export file with labels defined in one or more appropriate XBRL taxonomies, and forming an import file for import into the target program by replacing data in the export file at entries associated with specific labels, with data from the data set having corresponding labels. The associations made by the user are stored for later use, so that an import file can be automatically created by replacing data in a file having the same format as the originally exported file, based on the stored associations.

[0019] Exemplary embodiments of the invention include a synonym dictionary that includes synonyms of known labels or terms, or synonymous links between labels and / or terms, to facilitate automatic or user-assisted mapping. The dictionary can include terms that are not part of a taxonomy or schema such as an XML taxonomy, but that are synonymously related to terms in a taxonomy, schema, etc. In an exemplary embodiment of the invention, the synonym dictionary includes foreign languages, so that a label or datum can be mapped from one language into another language. In an exemplary embodiment of the invention, currency values are identified in the data stream, and are converted to corresponding values in different currencies (e.g., from yen to dollars) based on a known or designated exchange rate. In accordance with an embodiment of the invention, the mapping process converts data from one standard to another, for example from U.S. GAAP (Generally Accepted Accounting Principles) to International GAAP. In accordance with an embodiment of the invention, the mapping process includes replacing labels corresponding to identified data, with other labels, for example where minimizing file size is important.

Problems solved by technology

For example, large companies with many branches or subsidiaries often find that the accounting or operating software programs used by one division or subsidiary is not compatible with the software used by other divisions or subsidiaries or the central corporate programs.

This requires substantial conversions of data and often results in a great deal of data reentry along with the attendant costs and data integrity problems that attend data entry.

Because of the great variety of programs, operating systems and software standards currently used by software developers there is a great deal of incompatibility between suppliers and their customers.

This also requires substantial conversions of data and often results in a great deal of data reentry and its implications.

The unstructured and undefined nature of the current computer software environment imposes great burdens and expense on regulatory organizations such as the SEC, FDIC, Federal and State tax authorities, banks, etc. and the companies reporting to them.

Virtually none of the existing software applications can automatically or semi-automatically convert conventional documents or data into outputs tagged with the standardized Information Labels called for by XML or other standards committees.

This harsh reality will long delay the widespread use of these standards because it will take years for companies to migrate to new software products that are designed to output the appropriate Information Labels.

In some cases that may never happen because it is virtually impossible to replace legacy software systems.

For example, retrofitting all the accounting software in current use would be a very complex task that could not be accomplished in any short-term.

Images