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 am

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

Example Embodiment

[0076] The preferred embodiments of the present invention will be described below with reference to the accompanying drawings, and preferred embodiments described herein are intended to illustrate and explain the present invention, and is not intended to limit the invention.

[0077] Embodiments of the present invention provide a data tissue method for a retail terminal cost control data warehouse, such as figure 1 As shown, the method includes the following steps:

[0078] S1: Mark the data of the retail management system of the existing retail terminal to the cost accounting process module using the price nuclear algorithm, the cost accounting process module, data accounting processing of the data of the database;

[0079] S2: Data extraction, data conversion, and data loading of the data warehouse is performed on the data of the cost accounting process module;

[0080] S3: The multi-dimensional data model for the establishment of a trade-in cost control is established according...

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 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