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

A data organization method for retail terminal cost control data warehouse

A data warehouse and cost control technology, applied in database management systems, data processing applications, structured data retrieval, etc., can solve problems such as lack of data collection functions, lack of operational data analysis, inconvenient adjustment of operational plans, etc., to achieve The effect of accurate organization

Active Publication Date: 2022-02-08
广东便捷神科技股份有限公司
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a data organization method for retail terminal cost control data warehouse, which is used to solve the above-mentioned background technology that most retail terminals do not have the function of data collection and lack a large amount of actual operation data to form a data warehouse for data analysis. , it is impossible to clearly observe the profit and loss of retail terminals, and it is inconvenient for managers to adjust the technical problems of operating plans based on micro data analysis

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 organization method for retail terminal cost control data warehouse
  • A data organization method for retail terminal cost control data warehouse
  • A data organization method for retail terminal cost control data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] The preferred embodiments of the present invention will be described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described here are only used to illustrate and explain the present invention, and are not intended to limit the present invention.

[0077] The embodiment of the present invention provides a data organization method for retail terminal machine cost control data warehouse, such as figure 1 As shown, the method includes the following steps:

[0078] S1: Using the selling price accounting method to load the data of the database of the retail management system of the existing retail terminal into the cost accounting processing module, and the cost accounting processing module performs data accounting processing on the data of the database;

[0079] S2: performing data warehouse-oriented data extraction, data conversion and data loading on the data of the cost accounting processing module;

[0080] S...

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 present invention provides a data organization method for a retail terminal cost control data warehouse, including the steps: S1: using the price accounting method to load the data of the database of the retail management system of the retail terminal into the cost accounting processing module, and the cost accounting The processing module performs accounting processing on the data; S2: performs data warehouse-oriented data extraction, data conversion, and data loading on the data of the cost accounting processing module; S3: establishes a multi-dimensional cost control system for commodity sales according to the retail terminal commodity sales cost control requirements Data model, multi-dimensional data model includes: commodity sales data, commodity inventory data, commodity payment success data, commodity payment failure data, commodity cost data, commodity profit data, commodity sales ranking data, commodity increase and decrease suggestion data, commodity loss data and Equipment maintenance cycle data. The invention efficiently organizes a multi-dimensional data warehouse, and provides data decision support for commodity sales cost control and early warning.

Description

technical field [0001] The invention relates to the technical field of automatic vending machines, in particular to a data organization method for a retail terminal machine cost control data warehouse. Background technique [0002] A vending machine is a machine that can automatically pay according to the amount of payment. A vending machine is a common equipment for commercial automation. It is not limited by time and place. It can save manpower and facilitate transactions. It is a new commercial retail form. [0003] Nowadays, most of the retail terminals do not have the function of data collection, and lack a large amount of actual operation data to form a data warehouse. It is impossible to clearly observe the profit and loss of retail terminals, and it is inconvenient for managers to adjust the operation plan. The existing technical solution, the Chinese invention with the notification number CN110335410A, discloses a method, device and computer equipment for replenish...

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 Patents(China)
IPC IPC(8): G06F16/25G06Q30/02G06Q10/04G06Q10/06G06Q10/08
CPCG06F16/254G06Q10/087G06Q30/0206G06Q10/06395G06Q10/08355G06Q10/047
Inventor 徐玲周梓荣陈云尹波龚庆祝
Owner 广东便捷神科技股份有限公司
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