All databases used as one.{Comments Off on All databases used as one.}

by George A
My article explains a method of how to allow a user to access information from many databases on the internet using XML as if it were one database.  The purpose is to decrease the workload in obtaining information from the internet. It will also help to increase efficiency and save time. Different database types such as relational databases (RDB), object-oriented databases, and XML databases can all be queried using the method stated in the text. The authors call this method the “virtualization” of many databases into a single one. The authors elaborate by stating that databases on the internet as well as business software databases can all be accessed in the same way and integrated in real time using JDBC/SOAP methods. The author’s developed an, “XML conversion program, XML import/export…” The data from a MySQL server for example is converted using the XML export program code identifying parts such as table names, field names, and constraints. The XML import code is used then to allow a user to access the information as a single virtual database with all the other MySQL, PostgreSQL, or SQLServer2005 servers acting as one to the user. This is just one example for conversion using these types of databases.

I think that this is a very interesting idea. Obviously having someone develop the program to virtualize databases could be very beneficial for a company cost wise. Employees who must gather large amounts of data would not have to go to multiple sources and could have one access point for all the information needed. This would save the company a lot of money that they would not have to pay employees to search and search for the information from different places. The engineers could just add a database to the virtualization program and immediately the employees query the data.

I think that a company could specialize in this type of service – to virtualize database upon database. This would allow a user to enter one query and receive information from all the databases and have an indicator of where the data was from. This could potentially be very useful. Google scholar does this to some degree but is not as effective as it could be in retrieving results.

Wada, Y.; Watanabe, Y.; Syoubu, K.; Sawamoto, J.; Katoh, T.; , “Virtual Database Technology for Distributed Database,” Advanced Information Networking and Applications Workshops (WAINA), 2010 IEEE 24th International Conference on , vol., no., pp.214-219, 20-23 April 2010
doi: 10.1109/WAINA.2010.38