12[1]
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 12[1] as PDF for free.
More details
- Words: 1,017
- Pages: 5
XML ENABLED CROSS DATA MIGRATION About Data Synchronization Database Synchronization possesses a rich set of various features and the components allowing precisely, quickly and, at last, elegantly making comparison, synchronization and migration of all components of heterogeneous databases. Database Synchronizer -it is the unique program tool allowing to work with heterogeneous databases both at a simple user level, and at professional DBA level or software developer level. The product has been tested in work with many various database types: •
ORACLE
•
MS SQL Server
•
MySQL
•
MS Access
and many others
Database Comparison. This is basic, main feature of the program. The comparison objects are table structures, field and their properties, indexes, primary keys and the stored data. The convenient and intuitive user interface allows creating and adjusting comparison strategy of any complexity level. Comparison result is the detailed report, shown on special screen form or saved into XML /HTML file. New product version includes a lot of changes and additions both to interface of comparison strategy adjustments , and in comparison mechanism. For example, numeric or datetime values are being compared by value, unlike previous version which was comparing such values by representation. The new product version works with all data types, including LONG types, BINARY types and UNICODE types. New comparison wizard allows to compare not only separate tables but also table packages adjusted by user. Moreover, in the new version the user can create the package comparison, taking into account different names of the tables and characteristic of the data.
Database Synchronization. Inasmuch as result of databases comparison are the exact reports which allow to clarify quantity and quality of differences in elements of databases, the next logic step - synchronization of the these elements and stored data. The new version the has additional synchronization features: synchronization of fields properties, structures of the tables, primary keys and indexes. Except for synchronization of whole records, the possibility of “thin” or detailed synchronization has appeared. This feature allows to carry out more “intellectual” synchronization of separate fields of the records in which the differences were found. The synchronization of the data works successfully both with ordinary data types, and with binary fields. As this program is able to work practically with any database, the users can easily and precisely synchronize heterogeneous databases.
Data and structure migration: The export of structures and data of the tables from one database in another is one more powerful feature with which this product is equipped. This feature allows to make migration of the tables structure and data from one database for another. The data migration supports all SQL types, including UNICODE types and BINARY types and provides smart porting of the data between heterogeneous databases. While exporting of the data it analyzes format of the exported data and transforms them (by necessity and if it is possible) into format of the target table. Using Export wizard the user can adjust and execute export of tables group. Export wizard provides possibility to adjust export strategy separately for each exported table. At any stage of export operation the user can stop the operation. User, which has a local database MS Access can fast and qualitatively export the tables and data into MySQL. Other example: you need to fill in your tables by the data stored in ordinary TXT files. Database Migration feature can cope with this task successfully. The convenient and clear interface allows to create the complex strategy of migration of the information with a choice of the tables, fields and other objects database. The results of migration are reflected in the detailed HTML report.
EXISTING SYSTEM: Some database clients already provide synchronization; Oracle & Informix are some clients who provide synchronization. The drawbacks with the existing system are that the synchronization can only happen between one types of database their corresponding database server. There type of synchronization will help if and only if the database servers are same. In a distributed system may not be possible. Another drawback is that the cost of installing oracle or information in all the clients of an Enterprise is not an optimal solution. Currently, analysts compare the tables in the databases manually. A skilled analyst would take about 10 to 30 minutes to find a difference between two equal, at first sight, tables. If you have many tables with tens or even hundreds of fields each, this will be a very hard and long work. The whole process involves gathering and maintenance of huge amount of information manually. The proposed systems will ensure to reduce these drawbacks.
LIMITATIONS The following are the limitations of the existing system. •
Maintenance of information is done manually
•
Data collection is not uniform and is stored in different forms
•
Locating the appropriate server and client profile and updating it whenever required becomes cumbersome.
•
Critical processes like insertion or deletion is very difficult and error-prone process as there is no assurance that all the associated data are duly updated.
•
Enforcement of data integrity not possible.
•
Unavailable of prominent security measures for data collection.
PROPOSED SYSTEM:
The proposed system is responsible for reducing the drawbacks and the cost in the existing system . the proposed system reduce the drawbacks by applying the synchronization concept between different database servers. The proposed system will synchronize the tables between different database servers. so the problem of applying synchronization in enterprise application is reduced. The proposed system reduce the cost of installation of oracle or Informix by installation of low cost database servers.
SOFTWARE SPECIFICATION Operating System
: Windows 2000 server Family.
Pages developed using : Java Server Pages and HTML. Tools
: J Boss IDE, J Creator 1.5
Scripts
: JavaScript
Techniques
: Apache Tomcat Web Server, J2SDK 1.4
Web Browser
: Microsoft Internet Explorer.
Data Bases
: Microsoft Access, Oracle 8.0, SQL Server
HARDWARE SPECIFICATION Processor
: Any Processor above 500 Mhz.
Ram
: 128Mb.
Hard Disk
: 10 Gb.
Compact Disk
: 650 Mb.
Floppy Disk
: 1.44 Mb.
Input device
: Standard Keyboard and Mouse.
Output device
: VGA and High Resolution Monitor.
ORACLE
•
MS SQL Server
•
MySQL
•
MS Access
and many others
Database Comparison. This is basic, main feature of the program. The comparison objects are table structures, field and their properties, indexes, primary keys and the stored data. The convenient and intuitive user interface allows creating and adjusting comparison strategy of any complexity level. Comparison result is the detailed report, shown on special screen form or saved into XML /HTML file. New product version includes a lot of changes and additions both to interface of comparison strategy adjustments , and in comparison mechanism. For example, numeric or datetime values are being compared by value, unlike previous version which was comparing such values by representation. The new product version works with all data types, including LONG types, BINARY types and UNICODE types. New comparison wizard allows to compare not only separate tables but also table packages adjusted by user. Moreover, in the new version the user can create the package comparison, taking into account different names of the tables and characteristic of the data.
Database Synchronization. Inasmuch as result of databases comparison are the exact reports which allow to clarify quantity and quality of differences in elements of databases, the next logic step - synchronization of the these elements and stored data. The new version the has additional synchronization features: synchronization of fields properties, structures of the tables, primary keys and indexes. Except for synchronization of whole records, the possibility of “thin” or detailed synchronization has appeared. This feature allows to carry out more “intellectual” synchronization of separate fields of the records in which the differences were found. The synchronization of the data works successfully both with ordinary data types, and with binary fields. As this program is able to work practically with any database, the users can easily and precisely synchronize heterogeneous databases.
Data and structure migration: The export of structures and data of the tables from one database in another is one more powerful feature with which this product is equipped. This feature allows to make migration of the tables structure and data from one database for another. The data migration supports all SQL types, including UNICODE types and BINARY types and provides smart porting of the data between heterogeneous databases. While exporting of the data it analyzes format of the exported data and transforms them (by necessity and if it is possible) into format of the target table. Using Export wizard the user can adjust and execute export of tables group. Export wizard provides possibility to adjust export strategy separately for each exported table. At any stage of export operation the user can stop the operation. User, which has a local database MS Access can fast and qualitatively export the tables and data into MySQL. Other example: you need to fill in your tables by the data stored in ordinary TXT files. Database Migration feature can cope with this task successfully. The convenient and clear interface allows to create the complex strategy of migration of the information with a choice of the tables, fields and other objects database. The results of migration are reflected in the detailed HTML report.
EXISTING SYSTEM: Some database clients already provide synchronization; Oracle & Informix are some clients who provide synchronization. The drawbacks with the existing system are that the synchronization can only happen between one types of database their corresponding database server. There type of synchronization will help if and only if the database servers are same. In a distributed system may not be possible. Another drawback is that the cost of installing oracle or information in all the clients of an Enterprise is not an optimal solution. Currently, analysts compare the tables in the databases manually. A skilled analyst would take about 10 to 30 minutes to find a difference between two equal, at first sight, tables. If you have many tables with tens or even hundreds of fields each, this will be a very hard and long work. The whole process involves gathering and maintenance of huge amount of information manually. The proposed systems will ensure to reduce these drawbacks.
LIMITATIONS The following are the limitations of the existing system. •
Maintenance of information is done manually
•
Data collection is not uniform and is stored in different forms
•
Locating the appropriate server and client profile and updating it whenever required becomes cumbersome.
•
Critical processes like insertion or deletion is very difficult and error-prone process as there is no assurance that all the associated data are duly updated.
•
Enforcement of data integrity not possible.
•
Unavailable of prominent security measures for data collection.
PROPOSED SYSTEM:
The proposed system is responsible for reducing the drawbacks and the cost in the existing system . the proposed system reduce the drawbacks by applying the synchronization concept between different database servers. The proposed system will synchronize the tables between different database servers. so the problem of applying synchronization in enterprise application is reduced. The proposed system reduce the cost of installation of oracle or Informix by installation of low cost database servers.
SOFTWARE SPECIFICATION Operating System
: Windows 2000 server Family.
Pages developed using : Java Server Pages and HTML. Tools
: J Boss IDE, J Creator 1.5
Scripts
: JavaScript
Techniques
: Apache Tomcat Web Server, J2SDK 1.4
Web Browser
: Microsoft Internet Explorer.
Data Bases
: Microsoft Access, Oracle 8.0, SQL Server
HARDWARE SPECIFICATION Processor
: Any Processor above 500 Mhz.
Ram
: 128Mb.
Hard Disk
: 10 Gb.
Compact Disk
: 650 Mb.
Floppy Disk
: 1.44 Mb.
Input device
: Standard Keyboard and Mouse.
Output device
: VGA and High Resolution Monitor.
