Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform

A service platform and data scheduling technology, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve problems such as limiting JDBC applications, and achieve the effect of fast speed and flexible configuration

Inactive Publication Date: 2010-12-29
STATE GRID CORP OF CHINA +1
View PDF2 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But it is also the characteristics of its Java language implementation that limit the application of JDBC in scheduling automation systems.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform
  • Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform
  • Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The present invention will be described in detail below in conjunction with the accompanying drawings.

[0022] The inventive method has included the following steps:

[0023] (1) Configure the data source

[0024] Configure data sources separately for various types of commercial relational databases. The configured information includes the network service name of each data source, authentication information for database access, etc. The general data access service is configured with connections to ORACLE, SYBASE, SQLSERVER, MYSQL, and DB2 by default, so there are five configuration files for these types of databases. Multiple source databases of corresponding types can be freely configured in each configuration file. The general database access service connects each data source according to this configuration information, and creates a connection environment with the corresponding database. If a new data source needs to be added, it is only necessary to add the info...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a universal data access method of a cross-platform multi-heterogeneous database in a scheduling data service platform, which comprises the following steps of: configuring data sources: connecting all data sources according to the configuration information, and creating a connecting environment of corresponding databases; defining a uniform database access model: describing all data request results by using a uniform model, realizing uniform modeling on list structures and list records of privates representations in various commercial databases; packaging database access interfaces; and providing a universal data access method for applications by universal database access services, and distributing data access requests of the applications. The invention provides the universal database access method which has the characteristics of high speed, flexible configuration, cross platform, and the like; one set of source codes can be used in a plurality of platforms, and one application can freely and simultaneously access various commercial database; meanwhile, the invention provides guarantee for rapid development of scheduling upper layer service application of data service platforms.

Description

technical field [0001] The invention relates to a general data access method, in particular to a general data access method for cross-platform multi-heterogeneous databases in a scheduling data service platform. Background technique [0002] With the development of my country's dispatching automation, the automation system of the power dispatching center has also increased. In order to promote the coordinated operation of the various application functions of the dispatch center, it is necessary to build a comprehensive application support platform for the dispatch center across security partitions, that is, a dispatch data service platform. As the model center, data center and graphics center of the entire dispatch center, this dispatch data service platform will use commercial data for information storage. In order to shield the differences in the access of upper-layer applications to the underlying database, the scheduling data service platform needs a set of common datab...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 毛鹏白日昶帅玲玲何萍李俊万宇戴斌李晓露
Owner STATE GRID CORP OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products