Method for realizing retail store system migration and data consistency check

A consistency and data technology, applied in the direction of structured data retrieval, digital data information retrieval, database update, etc., can solve problems such as inability to guarantee data consistency, inability to migrate original system data, etc.

Inactive Publication Date: 2020-06-02
ZHUHAI HENGQIN SHENGDA ZHAOYE TECH INVESTMENT CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem solved by the present invention is to provide a method for realizing system migration and data consistency inspection of retail stores; to solve the problem th

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
  • Method for realizing retail store system migration and data consistency check

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0018] Such as figure 1 As shown, the present invention specifically includes the following steps:

[0019] It is characterized in that when the retail store is changing or migrating the invoicing system, in order not to affect the new system's cashier and store invoicing management, the data of the original system needs to be imported into the new system. First back up the database of the original store system and restore it with a different database name, then write SQL statements that read the necessary data and invoicing data of the original store database, and read various data from the original store system to the new system according to the written SQL statement In the imported intermediate table, the consistency verification of the imported intermediate table data is carried out. After the verification is passed, the data of the intermediate table is decomposed according to the business module table structure of the new system, and formally imported into the table corresp...

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 the field of Internet retail industry, in particular to a method for realizing retail store system migration and data consistency check. The method is characterized in that when the purchase-sale-stock system of the retail store is replaced or migrated, in order not to influence cashier of a new system and store purchase-sale-stock management of the retail store, data of an original system need to be imported into the new system together. Firstly, a database of an original store system is backed up and restored with different database names; SQL statements of necessarydata and purchase-sale-stock data of an original store database are written and read; and various data of the original store system are read into an import intermediate table of the new system according to the written SQL statement, consistency verification is performed on the imported intermediate table data, the data of the intermediate table is decomposed according to a service module table structure of the new system after the verification is passed, and the decomposed data is formally imported into a table corresponding to the new system. The method solves the problems that the originalsystem data cannot be completely migrated and the consistency with the original system data cannot be ensured when the system of the retail store is replaced or migrated, and can be widely applied tothe Internet retail industry.

Description

technical field [0001] The invention relates to the field of Internet retail industry, in particular to a method for realizing system migration of retail stores and data consistency check. Background technique [0002] System migration is also called system switching, that is, after the development of the new system is completed, the old system is switched to the new system. The main tasks of system switching include: integration of data resources, migration of old and new systems, and monitoring of the operation of the new system. Data resource integration includes two steps: data collation and data conversion. Data sorting is to organize the original system data into data that can be recognized by the system conversion program; data conversion is to convert the sorted data into the data format required by the new system according to certain conversion rules. Data integration is the key to the integration of system switching; Migration of old and new systems is to formula...

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/21G06F16/23G06F16/242G06F16/2455
Inventor 丁继锋张来卿庞严冬
Owner ZHUHAI HENGQIN SHENGDA ZHAOYE TECH INVESTMENT CO LTD
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