Apparatuses, methods and systems for a global data exchange
The APPARATUSES, METHODS AND SYSTEMS FOR A GLOBAL DATA EXCHANGE (hereinafter “GDE”) implement efficient and scalable monitoring, regulation, and allocation of computational processing, data, labor, and/or the like resources within an enterprise. In some embodiments, the GDE may provide a plurality of universal variables allocable to tables and/or fields across multiple, otherwise disparate database systems, facilitating integrability and exchange of data therebetween. In some implementations, the universal variables may be selectively chosen for broad applicability to a vast swath of enterprise data types and organizations, and may themselves be organized in accordance with a hierarchical schema facilitating business understanding and decision making. The GDE may further facilitate, in various implementations, report generation, data updating, and cohesion between different enterprise functions, systems, and applications through the use of universal variables and economical interface features.
1. A global data exchanging processor-implemented method, comprising:
receiving an association between a program identifier, a file identifier, and a file source address;
receiving a mapping, the mapping specifying a correspondence between a first set of data labels and a plurality of universal variables, wherein the universal variables are linked to at least a second set of data labels, said universal variables utilizing a delimited multi-level format, wherein each level relates to a hierarchical level for data access and access to a at least one of plurality of applications that require different access formats;
retrieving a file corresponding to the file identifier from the file source address;
extracting data from the file, the data being labeled in accordance with the first set of data labels;
labeling the data from the file with the second set of data labels using the mapping and universal variables to generate relabeled data;
storing the relabeled data in association with the program identifier;
receiving a transaction trigger condition associated with at least one external factor, said transaction trigger indicating access to databases and applications having different formatting requirements through at least one universal variable;
monitoring the at least one external factor for occurrence of the transaction trigger condition; and
executing by the processor a data transaction between the first database in the data repository and the at least one other database if the transaction trigger condition occurs.
2. The method of claim 1 , wherein the retrieving a file occurs in accordance with a schedule.
3. The method of claim 2 , wherein the schedule is periodic.
4. The method of claim 1 , wherein the file source address is an FTP address and the retrieving occurs in accordance with FTP standards.
5. The method of claim 1 , further comprising:
reformatting the data from the file.
6. The method of claim 5 , further comprising:
querying reformatting instructions from a database; and
wherein the reformatting is performed in accordance with the reformatting instructions.
7. A global data exchanging apparatus, comprising:
a memory;
a processor disposed in communication with said memory and configured to issue a plurality of processing instructions stored in the memory, wherein the processor issues instructions to:
receive an association between a program identifier, a file identifier, and a file source address;
receive a mapping, the mapping specifying a correspondence between a first set of data labels and a plurality of universal variables, wherein the universal variables are linked to at least a second set of data labels, said universal variables utilizing a delimited multi-level format, wherein each level relates to a hierarchical level for data access and access to a at least one of plurality of applications that require different access formats;
retrieve a file corresponding to the file identifier from the file source address;
extract data from the file, the data being labeled in accordance with the first set of data labels;
label the data from the file with the second set of data labels using the mapping and universal variables to generate relabeled data; and
store the relabeled data in association with the program identifier.
8. The apparatus of claim 7 , wherein retrieving a file occurs in accordance with a schedule.
9. The apparatus of claim 8 , wherein the schedule is periodic.
10. The apparatus of claim 7 , wherein the file source address is an FTP address and the retrieving occurs in accordance with FTP standards.
11. The apparatus of claim 7 , further comprising:
reformat the data from the file.
12. The apparatus of claim 11 , further comprising:
query reformatting instructions from a database; and
wherein reformatting is performed in accordance with the reformatting instructions.
13. A global data exchanging non-transitory processor-accessible computer storage medium, comprising:
a plurality of processing instructions stored in the medium and issuable by a processor to:
receive an association between a program identifier, a file identifier, and a file source address;
receive a mapping, the mapping specifying a correspondence between a first set of data labels and a plurality of universal variables, wherein the universal variables are linked to at least a second set of data labels, said universal variables utilizing a delimited multi-level format, wherein each level relates to a hierarchical level for data access and access to a at least one of plurality of applications that require different access formats;
retrieve a file corresponding to the file identifier from the file source address;
extract data from the file, the data being labeled in accordance with the first set of data labels;
label the data from the file with the second set of data labels using the mapping and universal variables to generate relabeled data; and
store the relabeled data in association with the program identifier.
14. The medium of claim 13 , wherein retrieving a file occurs in accordance with a schedule.
15. The medium of claim 14 , wherein the schedule is periodic.
16. The medium of claim 13 , wherein the file source address is an FTP address and the retrieving occurs in accordance with FTP standards.
17. The medium of claim 13 , further comprising:
reformat the data from the file.
18. The medium of claim 17 , further comprising:
query reformatting instructions from a database; and
wherein reformatting is performed in accordance with the reformatting instructions.