16-02-2013, 04:21 PM
Migration of Databases – An XML Approach
ABSTRACT
XML Database Migration is a project of migrating the existing databases into XML
format. Conversion of databases to XML file format, the databases like Ms-Access, Oracle
and MS-SQL, MySQL connects in the network or the oracle in the personal computer can
be connected for the generation of XML code. Let us consider, user runs a firm with three
companies with different database’s respectively. User planned to mingle the entire
database’s of the firm in to a single database.
The user wants to migrate the entire database in to a single database. Migration of
a database to another database is a huge process and a complex one. In such case our
project can be used as we are converting the entire database into a XML file and then it
is to a single database. By doing so, the conversion is been made easier and the native
database also will remain unchanged. Only the authorized person is allowed to access the
databases. The user is been prompted for username and password and then the user can
be allowed to select the type of database. After selection, the user is been prompted for
database name and then corresponding tables present in that database is been displayed
from which the user can select the table which the user wants to convert.
Before conversion, the user can view the table from that the user can check
whether the correct table is been selected. The table is been converted and a message
will be displayed to the user about the conversion. The converted file will be in the XML
format and it is been previewed to the user in the database format after conversion. Here,
the user can check whether all the fields in the table are converted. While converting the
data’s in the tables, the tables present in the database remains unchanged and the fields
from the tables retrieved are subjected for XML conversion.
EXISTING SYSTEM
The Existing system provides access for single database conversions. Databases are
widely used at present in all sorts of resources, these Databases occupy part of memory
in the server and amount should be paid to maintain these Databases. In web, database
is widely used at present. The database occupies some part of memory in the server and
amount should be paid to maintain the database. The amount will depend upon the
database size, and also Access and Oracle database are platform dependent.
XML is platform independent. While using database, lot of problems will be arise
like data corruption, huge memory spaces, and unnecessary expenses for database security.
Now a days most of the websites stores data in backend storage device. The data are
stored in Oracle database or some other backend devices. These databases occupy some
part of memory in the server. The site owner should be paid some amount of money to
maintain that database. The amount should be vary depending upon the database size and
also have a lot of problem to maintain the database. This is unnecessary expenses and
waste of memory spaces. To retrieve the data from the database is very slow when we
are browsing the site. These are the difficult arising to retrieve the database.
PROPOSED SYSTEM
XML Migration is project to convert the existing Database like Oracle and MSAccess
into the XML database. The XML is a text formatted flat file, so this project has
an ability to store any kind of data from the application system. On using the xml as a
backend we reduce the memory occupied in net and there is no need to pay amount
separately for XML database as it is file and consumes less memory. XML has more
advantages over other databases.
The XML has the ability to process on any platform, since it is platform independent
we can use it in any operating system. Apart from this no proxy server or firewall can
restrict xml formatted data’s. Here maintenance is very easy as it is a file and consumes
very less memory.
Previously in database maintenance is a major task and cost paid separately. Many
databases are not supported in different platforms but XML file format supports different
platforms like Linux, Windows etc., As .NET transfers data in the form of XML formatted
data only. As this is a major advantage to us in converting to XML. XML flat file format
is used as an intermediate for the Database conversions.