Research Technology Of Data Query In Virtual Database

As the expansion and completion of every type of sevice information system,data service accelerated growth,the restraction of the ages and objective important condition,which result in separating every type of data service and have structural diversity.this bring to two sides question:one thing,the business application must be able to deal with heterogeneous ways of data accessing.however,disperse data sources, added changement of data property,such as structure,name,increase cost of developping and maintenance.in addition,compositive,real-time data querying,analysis ability and integrated data access ability which supports different business collaborative operation are imperious for high top-tier business to need.decision maker usually need to get multi-data source information coming from different places,especially integrated information.but this function can't be achieved by today's search engines.so creating uniform data access middleware and achieving real-time data access mechanism are the effective way to resolve the bottle-neck of data integration.This paper makes a study of actual heterogeneous data source in telecom transmission net management system,using for reference of traditonal virtual database's architecture,bring forward three layer(application layer,middle layer,data source layer)architecture information integration platform--VirtualDB.VirtualDB achive schema integration by metadata.Adopting web service create service end,the aim of it is to provide a information integration platform which can access transparency and integrate multiple data source,have data view and API for clients.this paper maily complete schema integration and data query.The paper first discusses different ways of current data integration,analysis all kinds of this ways' merits and faults,combining existing and critical problem of subject,bring to VirtualDB system's architecture design based on virutal database mid ware technology.The following part researchs of schema integration's theory and processing procedure,give a design blue print based on metadata schema integration to reduce the complexity of schema extracted and mapped.using metadata can lighten middle database's data size pressure,can provide global schema for upper layger more flexible.VirtualDB uses GSQLParser control to parse SQL,test prove GSQLParser has powerful and high-performance parsing ability,it integrated used is this system's new bright point. This paper design virtual database based on telecom transmission net management system,solve the problem of heterogeneous data source's format disunion and querying low real time,the research of the paper have some value of application for improving telecom transmission net management system...