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

Retail terminal cost control data warehouse-oriented data organization method

A data warehouse and cost control technology, applied in database management systems, data processing applications, structured data retrieval, etc., can solve the problems of lack of data collection functions, inability to clearly observe the profit and loss of retail terminals, and lack of operational data analysis and other issues to achieve the effect of accurate organization

Active Publication Date: 2021-08-06
广东便捷神科技股份有限公司
View PDF9 Cites 2 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
  • Retail terminal cost control data warehouse-oriented data organization method
  • Retail terminal cost control data warehouse-oriented data organization method
  • Retail terminal cost control data warehouse-oriented data organization method

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 invention provides a retail terminal cost control data warehouse-oriented data organization method, which comprises the following steps: S1, loading data of a database of a retail management system of a retail terminal to a cost accounting processing module by utilizing a selling price accounting method, and carrying out accounting processing on the data by the cost accounting processing module; s2, performing data warehouse-oriented data extraction, data conversion and data loading on the data of the cost accounting processing module; s3, establishing a multi-dimensional data model of commodity selling cost control according to the commodity selling cost control requirement of the retail terminal, the multi-dimensional data model comprising commodity selling data, commodity inventory data, commodity payment success data, commodity payment failure data, commodity cost data, commodity profit data, commodity selling high-low sorting data, commodity increase and decrease suggestion data, commodity loss data and equipment maintenance cycle data. According to the invention, a multi-dimensional data warehouse is efficiently organized, and data decision support is provided for commodity selling 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
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

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

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