Import Database Transformation Utility
Import File Processor Schema and Data Conversion
Convert Exported Text Files to SQL databases including schemas, views and aliases.
The utility provides an access layer to standard import/export formats, databases, unique and proprietary file formats. It is also forms the access point for data transformation and mediation.
Advanced conversion features launched by an easy
to use interface.
The main page includes a progress bar and adjustable levels of progress details. It is a diagnostic utility and featurse a real-time raw data windows, pause to examine and detailed exceptions handling.
The database information page allows entry of the standard database attributes including server, database, filegroup, user, password, authorization.
Implementation of file owner as well as populated drop downs for each database attribute are still pending.
The Project
The import file processor is part of a much larger C# project. It consists of a basic user interface and update processor.
Most of the work however is performed by a sophisticated file access module. The file access module is general in nature and includes basic I/O and connection functions. It is extended to include utility, schema and transformation features as well.
The application is implemented via a complex application framework. In simple terms the framework consists first of an application and OSS (Operating System Support) MVC threaded infrastructure for distruibuted processing. Second, the framework provides common user interface functionality such as status line areas, update, pause, resume, and cancel.
Details the wider project and it research objectives are covered in a separate area
of this site. It could be summarized as a study pushing the complexity and exploring
the features of the C# .Net platform.
The Why? Rationelle...
This forms the data mediation layer in combination with the File System.
This component transfers over current MacroDM technology from the mulitvalued to C# .Net platform.
A custom data conversion solution was already needed for key existing multivalued applications.
This is part of the OSS functionality along with other components.
File Subsystem
Handles SQL, Ascii, Binary and post-relational database files. Equipped with an auxillary connection. Comprehensive data format and schema transformation.