Database application for mobile media search

Abstract

In modern business computing, data frequently resides on multiple sites within an organization, to be managed by several Database Management Systems (DBMS). The advantages in organizing these remote databases to appear as a single logical are better reliability, expandability, availability and management than a centralized database. The data are logically related, but physically scattered across the computer network to achieve Replication Transparency, Location Transparency or a combination of both. However, the true benefit of Replication Transparency lies in data consistency among the replicated sites.

In this project, the author had deployed ASP.NET Web Site for Full-Text search, driven by the back-end MySQL Server. The author exploits the engine-specific features of MySQL Server, mainly from FEDERATED and MyISAM storage engines, in the database distribution. The linked server feature of the FEDERATED storage engine was maximized in either fully replicating data from local to a remote server or accessing data from the remote server.