Query Method of Multi-Source Data in Distribution Network
Lei Huang, Hanlin Tian, Daixi Yang, Xiaoyi Mao, Li Long · 2023
This paper provides a query method and system for multi-source data, which belongs to the database field, including receiving data access requests from business applications, forwarding the access requests to the data access component, which judges the transfer parameters in the access request; When the judgment result indicates that the data access is a cross-database data request, the data access request is forwarded to the distributed data query engine; Connect to the multiple data sources corresponding to the data access request, obtain the query results corresponding to the data access request from the multiple data sources, and forward the query results to the data access component, so that the data forwarding component can send the query results to the business application. Establish a logical database to isolate the direct connection between business applications and databases, thus improving the security of data access; Provide abstract development services to simplify data management and application development; Support the associated query between tables that physically cross databases, and realize the multi-source data query across databases.