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

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 that retail stores cannot completely migrate the original system data when the system is replaced or migrated, and cannot guarantee the consistency with the original system data The problem

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

Embodiment Construction

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

[0019] It is characterized in that: when a retail store is replacing or migrating its purchase, sales and storage system, in order not to affect the cash register of the new system and the management of the store's purchase, sales and storage, it is necessary to import the data of the original system into the new system. First back up the database of the original store system and restore it with a different database name, then write the SQL statement to read the necessary data and purchase, sales and inventory data of the original store database, and read all kinds of 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 data imported into the intermediate table is carried out. After the verification is passed, the data in the intermediate table is decomposed accordin...

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
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com