A data migration method for upgrading a water company's operating charging system

A charging system and data technology, applied in the field of data processing, can solve problems such as the new system not running normally, and achieve the effect of shortening the process of migration implementation, optimizing data query and extraction methods, and reducing the probability of errors

Active Publication Date: 2019-01-29
HUNAN INST OF TECH
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The process of data migration is the process of converting the above data in the source database to the target database. From two-tier structure to three-tier structure, from C/S to B/S, the success of data migration will determine the performance of the entire busines

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
  • A data migration method for upgrading a water company's operating charging system
  • A data migration method for upgrading a water company's operating charging system
  • A data migration method for upgrading a water company's operating charging system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In order to facilitate the understanding of those skilled in the art, the present invention will be further described below in conjunction with specific embodiments and accompanying drawings.

[0026] figure 1 A model diagram of the data migration involved in the present invention is shown. In general, the data migration method used in the present invention for upgrading the business charging system of a water service company includes the following steps:

[0027] Establish data mapping relationship: compare and analyze the data structure of the source database and the target database, and establish the data mapping relationship between the source database and the target database;

[0028] Data migration: extract data from the source database and migrate to the intermediate database through the SQL program corresponding to the source database, and compare the data migrated to the intermediate database according to the data mapping relationship between the source databas...

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 relates to a data migration method for upgrading a service charging system of a water company, which relates to the technical field of data processing, comprising the following steps: establishing a data mapping relationship: comparing and analyzing a data structure of a source database and a target database; establishing a data mapping relationship between the source database and the target database; data migration: extracting data from the source database and migrating to the intermediate database through SQL program corresponding to the source database, and comparing, analyzing and verifying the data migrated to the intermediate database according to the data mapping relationship between the source database and the target database, and correcting the error and abnormal data; through the SQL program corresponding to the target database, the data matching the data mapping relationship between the source database and the target database is extracted from the intermediatedatabase and migrated to the target database. The data in the two-tier C/S structure database can be migrated to the three-tier B/S structure database by the method, so as to realize the smooth switching and upgrading of the new and old systems.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a data migration method used for upgrading a business charging system of a water service company. Background technique [0002] With the gradual deepening of informatization construction in the water industry, the water company has higher requirements for the response speed and functional improvement of the business charging system. For this reason, a new charging system has been developed to meet the business needs in the current situation. [0003] The database of the traditional business charging system is a two-tier C / S structure, and the database of the new business charging system is a three-tier B / S structure. Compared with the two-tier C / S structure, the B / S can be divided into three layers reasonably The function of the structure keeps it relatively independent logically, so that the logical structure of the entire system is clearer and smoother, and it can also ...

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
IPC IPC(8): G06F16/22G06F16/27G06F3/06
CPCG06F3/0647
Inventor 黄樱曾亦黄曾华程方小勇袁鹏
Owner HUNAN INST OF TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap