File Service Definition Language
Publication Date: 2011-Oct-31
The IP.com Prior Art Database
Disclosed is a File Service Definition Language (FSDL) which adopts a theory of a source owner definition publication to be interpreted by the consuming application which specifically addresses Data extract, transform and load processes in a non-transactional unidirectional model. The invention introduces a generic, transferable, and easily implemented transformation and mapping descriptive language providing a rapid and interactive implementation, while also allowing for the flexibility required in complex data transfers.
Page 01 of 6
File Service Definition Language
Data extract, Transform and Load (ETL) is a well documented process area for transferring data across dissimilar systems, databases, and applications. Although well understood and flexible, the multitude of approaches and tools introduces a challenge for a single implementation between systems.
Also consider that current computer models utilizing a Service Oriented Architecture (SOA) have advanced application design introducing a highly flexible, readily available and complex object layer in which much of an application's business logic resides. Advantageous for application modeling, SOA advancements have resulted in a standard for web service transactional implementations with the Web Service Definition Language (WSDL); however, the transactional request/response method is inefficient when applied to the transfer of large amount of data where ETL considerations come into play, although the same consuming system objects are the eventual targets.
As a result, large data transfers often result in custom processes outside of the main applications without the same WSDL directives and, therefore, results in the object layer business rules being dangerously by-passed, prone to errors in code replication, or implemented in an inefficient transactional model.
There are several general Business Process definition languages, such as Business Process Execution Language (BPEL), Yet Another Workflow Language (YAWL), and others; however, these are extremely generalized and where useful for process definition and may enable specific one-off ETL implementations, they do not include a common cross-platform standard ETL definition model relating to the data or data interpretation specifically.
The introduction of a File Service Definition Language [FSDL] adopts a similar theory of a source owner definition publication to be interpreted by the consuming application which specifically addresses ETL processes in a non-transactional unidirectional model. The generic, transferable, and easily implemented transformation and mapping descriptive language provides a rapid and interactive implementation while also allowing for the flexibility required in complex data transfers. Further to extraction definition, extensions for common transforms and object loading encompassing a metadata model, allowing repeat processing either across multiple source files of the same definition or multiple target applications with the same object model.
The File Service Definition Language consists of:
• A standard of identification which enables a target application to interpret components of a large file extraction for the purposes of subsequent transformation and load processing
• Extension of extraction definition to allow for additional transformation and load processes to be identified within the same method for consistent interpretation across similar sources and/or destinations
• Such methods as may be implemented by, but not li...