Data display method, device, electronic device and storage medium

Abstract

The present invention discloses a data display method, device, electronic device and storage medium. The method includes: obtaining a warehouse data table from a target database, analyzing the header fields of the warehouse data table, and obtaining the type of goods recorded in the warehouse data table; determining the attribute characteristics of the goods type, and determining the statistical dimension of the warehouse data table according to the attribute characteristics of the goods type; calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table; obtaining the user's display requirements, and selecting the content in the visualization chart for display according to the display requirements. That is, the embodiment of the present invention, by obtaining the warehouse data table for automatic analysis, and performing function analysis on the warehouse data table according to the corresponding statistical dimensions, can achieve the purpose of accurately analyzing the warehouse data table, and generate a visualization chart, so as to facilitate chart display according to customer needs.

Description

Technical Field

[0001] The embodiments of the present invention relate to computer technology, and in particular to a data display method, device, electronic device and storage medium. Background Art

[0002] With the rapid development and rise of e-commerce enterprises, the warehousing of e-commerce platforms has gradually realized digitalization and informatization. In the process of gradually realizing digitalization and informatization of e-commerce platform warehousing, most manufacturers use warehouse management systems and goods-to-person robot picking systems to improve the efficiency of goods receiving, sending and storing. Since traditional warehouse management systems can only analyze traditional order data and operation data, thereby optimizing the efficiency of goods receiving and sending while reducing operating costs, it is impossible to combine the goods-to-person robot picking system with it to analyze and optimize the overall process of collaboration between people and logistics robots. Summary of the invention

[0003] The present invention provides a data display method, device, electronic device and storage medium to realize automatic display of the content in a warehouse data table, so as to achieve the purpose of accurate data index viewing.

[0004] In a first aspect, an embodiment of the present invention provides a data display method, the method comprising:

[0005] Obtain a warehouse data table from a target database, analyze a header field of the warehouse data table, and obtain the type of goods recorded in the warehouse data table;

[0006] Determining the attribute characteristics of the goods type, and determining the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type;

[0007] Calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table;

[0008] The user's display requirements are obtained, and the content in the visualization chart is selected for display according to the display requirements.

[0009] Furthermore, before obtaining the warehouse data table from the target database, it also includes:

[0010] Obtain warehouse data tables stored in the warehouse management system within a preset time period and determine the header fields of the target database;

[0011] Modify and filter the header fields of the warehouse data table according to the header fields of the target database to obtain data that can be stored in the warehouse data table;

[0012] The warehouse-storable data table is stored in the target database.

[0013] Further, the header fields of the warehouse data table are modified and screened according to the header fields of the target database to obtain the data table that can be stored in the warehouse, including:

[0014] Selecting contents corresponding to header fields with the same semantics from the warehouse data table according to the header fields of the target database;

[0015] The header fields corresponding to the content are changed to be consistent with the header fields of the target database to obtain the data table that can be stored in the warehouse.

[0016] Further, the header field of the warehouse data table is analyzed to obtain the type of goods recorded in the warehouse data table, including:

[0017] Analyze the header field of the warehouse data table and the goods information in the warehouse data table to obtain the time pattern corresponding to the goods information;

[0018] The type of goods recorded in the warehouse data table is determined according to the time rule.

[0019] Further, determining the attribute characteristics of the goods type, and determining the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type, includes:

[0020] Querying a cargo attribute database according to the cargo type to obtain attribute characteristics of the cargo type;

[0021] The statistical dimension of the warehouse data table is determined according to the attribute characteristics and the cargo outbound rate in the warehouse data table.

[0022] Further, calling the analysis function according to the statistical dimension of the warehouse data table includes:

[0023] Determining a period of the statistical dimension;

[0024] The analysis function corresponding to the warehouse data table is determined from an analysis function library according to the period of the statistical dimension.

[0025] Furthermore, the analysis function is used to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table, including:

[0026] Analyze the content in the warehouse data table according to the analysis function to obtain visual chart information of the warehouse data table;

[0027] Writing code in a first language according to the visual chart information to obtain a first macro instruction;

[0028] The visualization chart information is visualized using a display code in a second language according to the first macro instruction to obtain a visualization chart of the warehouse data table.

[0029] Furthermore, after obtaining the display requirements of the user and selecting the content in the visualization chart for display according to the display requirements, the method further includes:

[0030] Determine the number of transport devices in the sorting system according to the cargo index corresponding to the displayed content in the visualization chart;

[0031] The cargo delivery position in the sorting system is determined according to the cargo rotation rate and cargo grade corresponding to the displayed content.

[0032] In a second aspect, an embodiment of the present invention further provides a data display device, the device comprising:

[0033] A field analysis module is used to obtain a warehouse data table from a target database, analyze the header fields of the warehouse data table, and obtain the type of goods recorded in the warehouse data table;

[0034] A dimension determination module, used to determine the attribute characteristics of the goods type, and determine the statistical dimension of the warehouse data table according to the attribute characteristics of the goods type;

[0035] A data analysis module, used to call an analysis function according to the statistical dimension of the warehouse data table, and use the analysis function to analyze the content in the warehouse data table to obtain a visual chart of the warehouse data table;

[0036] The chart display module is used to obtain the user's display requirements and select the content in the visual chart for display according to the display requirements.

[0037] In a third aspect, an embodiment of the present invention further provides an electronic device, characterized in that the electronic device includes:

[0038] one or more processors;

[0039] a storage device for storing one or more programs,

[0040] When the one or more programs are executed by the one or more processors, the one or more processors implement the data display method.

[0041] In a fourth aspect, a computer-readable storage medium stores a computer program, which implements the data display method when executed by a processor.

[0042] In an embodiment of the present invention, by obtaining a warehouse data table from a target database and analyzing the header fields of the warehouse data table, the type of goods recorded in the warehouse data table is obtained; the attribute characteristics of the goods type are determined, and the statistical dimensions of the warehouse data table are determined according to the attribute characteristics of the goods type; the analysis function is called according to the statistical dimensions of the warehouse data table, and the content in the warehouse data table is analyzed by the analysis function to obtain a visualization chart of the warehouse data table; the display requirements of the user are obtained, and the content in the visualization chart is selected for display according to the display requirements. That is, in an embodiment of the present invention, the recorded type of goods is determined by the header fields of the warehouse data table, and the statistical dimensions are determined according to the attribute characteristics of the goods type, and the content in the warehouse data table is analyzed according to the statistical dimensions to obtain a visualization chart, and the content is displayed according to the customer's needs, and the warehouse data table can be automatically analyzed according to the obtained warehouse data table, and the warehouse data table can be analyzed according to the corresponding statistical dimensions, so as to achieve the purpose of accurately analyzing the warehouse data table, and generate a visualization chart, so as to display the chart according to the customer's needs. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 is a flow chart of a data display method provided by an embodiment of the present invention;

[0044] Figure 2 is a schematic diagram of functional data in a warehouse management system provided by an embodiment of the present invention;

[0045] Figure 3 is another flow chart of the data display method provided by an embodiment of the present invention;

[0046] Figure 4 is a structural schematic diagram of a data display device provided by an embodiment of the present invention;

[0047] Figure 5 It is a structural schematic diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0048] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.

[0049] Figure 1The present invention provides a flow chart of a data display method according to an embodiment of the present invention. The method can be performed by a data display device according to an embodiment of the present invention. The device can be implemented in software and / or hardware. In a specific embodiment, the device can be integrated in an electronic device, such as a server. The following embodiments will be described by taking the device integrated in an electronic device as an example. Figure 1 , the method may specifically include the following steps:

[0050] S110, obtaining a warehouse data table from a target database, analyzing a header field of the warehouse data table, and obtaining the type of goods recorded in the warehouse data table;

[0051] For example, the target database can be a database built by a data analysis function, in which various data templates are stored for filtering data in the warehouse data table that cannot form a visual chart, and the data content in the warehouse data table can be determined by using the header fields corresponding to each data template in the target database. The warehouse data table can be a data table related to the warehouse exported from the warehouse management system, and can be a warehouse outbound data table, inventory data table, and inbound data. The header field of the warehouse data table can be a column mark of the warehouse data table or the field name of each column of data, or it can be a text mark such as the header title of the warehouse data table that can represent the meaning of the data content of the warehouse data table. The type of goods recorded in the warehouse data table can be the type of item to which the goods recorded in the warehouse data table belong, such as clothing items, medical items, and daily items.

[0052] In a specific implementation, before obtaining the warehouse data table, a target database can be built according to the data display platform or terminal, and various data templates in the target database can be determined, and then the warehouse data table can be obtained from the warehouse management system. The warehouse data table can be a data table exported from the warehouse management system in real time, or it can be data exported from the warehouse management system within a preset time period. The header fields of the warehouse data table are analyzed to determine the items recorded in the warehouse data table, and the type of goods recorded in the warehouse data table is determined based on the items recorded in the warehouse data table, so as to determine the attribute characteristics of the goods type based on the goods type recorded in the warehouse data table, and then use the attribute characteristics to perform statistical analysis of related dimensions.

[0053] Figure 2 A schematic diagram of functional data in a warehouse management system provided by an embodiment of the present invention, such as Figure 2As shown, the warehouse management system has multiple management functions and data such as basic data, configuration strategy, outbound management, outbound management, in-warehouse management, billing management, operation analysis, KPI and regional distribution. The basic data includes warehouses, carriers, cargo areas, stores, cargo locations and cargo owners; configuration strategies include receiving strategies, allocation strategies, wave strategies, shelving strategies, outbound strategies and replenishment strategies; inbound management includes arrival notification, quality inspection, cargo location recommendation, receiving scanning and shelving; outbound management includes shipping notification, picking, packaging and weighing, inventory allocation, review and shipment; in-warehouse management includes inventory, replenishment, adjustment, transfer and allocation; billing management includes storage fees, express billing, consumables billing, operating fees and employee performance; operation analysis includes inventory visualization, operation failure analysis, abnormal monitoring, inbound and outbound monitoring, decision support, risk warning, and warehouse location storage analysis; KPI includes performance appraisal, case commission, workload statistics; regional distribution site management, logistics management, vehicle management, logistics tracking, regional settings and freight management.

[0054] S120, determining the attribute characteristics of the goods type, and determining the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type;

[0055] For example, the attribute characteristics of the goods type can be the item characteristics corresponding to the regularity of frequent updates of the goods corresponding to the goods type in the warehouse entry and exit. For example, when the goods type is clothing items, the seasonality of clothing items can be used as the item characteristics according to the regularity of clothing updates in different quarters. The statistical dimension of the warehouse data table can be the time length for statistics or analysis of the warehouse data table set according to the temporal update regularity of the attribute characteristics of the goods type, or it can be the time length for automatically designing the warehouse data table for statistics or analysis according to the time length in the warehouse data table exported by the warehouse management system, because different statistical time dimensions will have different prominence on the characteristics of the content in the warehouse data table.

[0056] In the specific implementation, the header fields of the warehouse data table are analyzed to determine the items recorded in the warehouse data table, and the types of goods recorded in the warehouse data table are determined based on the items recorded in the warehouse data table. The attribute characteristics of the goods type are determined based on the temporal update rules of the attribute characteristics of the goods type. The statistical time length of the warehouse data table is automatically set according to the automatically set statistical time length of the warehouse data table, so as to determine the statistical dimension of the warehouse data table, so that the warehouse data table can automatically perform statistics according to the attributes of the content in the warehouse data table, so as to achieve the effect of accurate statistical analysis.

[0057] S130. Calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table;

[0058] For example, the analysis function can be a calculation function for the content or data in the warehouse data table according to different preset statistical dimensions. For example, if the order time of the outbound table exported by the warehouse management system is given in only one day, the statistical dimension is determined to be hourly. The outbound table can be statistically analyzed using count function, sum function and join function, among which the join function can associate the connection between tables and calculate the repetition rate of items between two adjacent statistical dimensions. The visualization chart of the warehouse data table can be a displayable chart of the warehouse data table formed according to the analysis result of the analysis function on the warehouse data table, which is used to vividly display the data change characteristics and laws of the content in the warehouse data table.

[0059] In the specific implementation, according to the time update rule of the attribute characteristics of the cargo type, the time length for the warehouse data table to be counted is automatically set, so as to determine the statistical dimension of the warehouse data table according to the automatically set time length for the warehouse data table to be counted. According to the statistical dimension of the warehouse data table, the analysis function corresponding to the dimension is called, and the content in the warehouse data table is statistically analyzed according to the analysis function corresponding to the dimension to obtain the analysis result of the content in the warehouse data table, and the analysis result of the warehouse data table is formed according to the analysis function The displayable chart of the warehouse data table is used to vividly display the data change characteristics and rules of the content in the warehouse data table, so that users can intuitively and quickly obtain the change characteristics and rules of the data in the warehouse data table, make appropriate adjustments to the outbound and inbound of items, and can adjust the sorting system equipment, the number of personnel and the location of the cargo delivery port.

[0060] S140: Obtain the user's display requirements, and select content in the visualization chart for display according to the display requirements.

[0061] In a specific implementation, the display requirements can be indicators of items in the warehouse data table that the user needs to view, or the display style of the visualization chart that the user views, wherein the indicators of items in the warehouse data table can be the data in the analysis results obtained by analyzing the content in the warehouse data table using an analysis function, and the display style can be the graphic style of the analysis results presented in the terminal or platform, which is used to clearly present the analysis results and highlight the indicator content in the analysis results to achieve a clear effect. The user's display requirements are obtained from the terminal or platform, and the content that meets the user's display requirements is selected from all visualization charts corresponding to the analysis results according to the display requirements for display, and the display content in the visualization chart is obtained, so that the user can adjust the sorting system according to the display content.

[0062] In an embodiment of the present invention, by obtaining a warehouse data table from a target database and analyzing the header fields of the warehouse data table, the type of goods recorded in the warehouse data table is obtained; the attribute characteristics of the goods type are determined, and the statistical dimensions of the warehouse data table are determined according to the attribute characteristics of the goods type; the analysis function is called according to the statistical dimensions of the warehouse data table, and the content in the warehouse data table is analyzed by the analysis function to obtain a visualization chart of the warehouse data table; the display requirements of the user are obtained, and the content in the visualization chart is selected for display according to the display requirements. That is, in an embodiment of the present invention, the recorded type of goods is determined by the header fields of the warehouse data table, and the statistical dimensions are determined according to the attribute characteristics of the goods type, and the content in the warehouse data table is analyzed according to the statistical dimensions to obtain a visualization chart, and the content is displayed according to the customer's needs, and the warehouse data table can be automatically analyzed according to the obtained warehouse data table, and the warehouse data table can be analyzed according to the corresponding statistical dimensions, so as to achieve the purpose of accurately analyzing the warehouse data table, and generate a visualization chart, so as to display the chart according to the customer's needs.

[0063] The data display method provided by the embodiment of the present invention is further described below. Figure 3 As shown, the method may specifically include the following steps:

[0064] S310, obtaining a warehouse data table stored in a warehouse management system within a preset time period, and determining a header field of a target database;

[0065] In a specific implementation, the preset time period may be a warehouse data table within a fixed time period exported from the warehouse management system, and the length of the preset time period may be determined based on the amount of data in the warehouse management system and the storage capacity of the warehouse management system. The warehouse management system may be a computer software system for supervising warehouses, and may manage information, resources, inventory, and distribution operations in accordance with the business rules and operation rules of the operation. The header field of the target database may be the header field of each data template stored in the target database. The warehouse data table stored in the warehouse management system within the preset time period is obtained, and the header field of each data template stored in the target database is determined, so as to determine the data template to which the corresponding header field of the warehouse data table belongs according to the header field of each data template stored in the target database.

[0066] S320, modifying and filtering the header fields of the warehouse data table according to the header fields of the target database to obtain a data table that can be stored in the warehouse, and storing the data table that can be stored in the warehouse in the target database;

[0067] In a specific implementation, the warehouse data table that can be stored can be a data table after the warehouse data table is standardized according to each data template in the target database. The header field of the target database is determined, and the header field of the target database is used as the standard header field to determine whether the warehouse data header field is negative to the standard header field, and the header field of the warehouse data table can be modified and screened according to the header field of the target database to obtain a warehouse data table that can be stored, wherein the inconsistent ones are modified to be consistent, and the unnecessary redundant data is screened, and the warehouse data table is standardized to obtain a warehouse data table that can be stored, and the warehouse data table that can be stored is stored in the target database, so as to facilitate the display of the goods data on the terminal or display platform.

[0068] Furthermore, the header fields of the warehouse data table are modified and filtered according to the header fields of the target database to obtain the data table that can be stored in the warehouse, including:

[0069] Select the content corresponding to the header field with the same semantics from the warehouse data table according to the header field of the target database;

[0070] Change the header fields corresponding to the content to be consistent with the header fields of the target database to obtain a data table that can be stored in the warehouse.

[0071] In a specific implementation, the header fields of each data template in the target database are determined, and the header fields of the target database are compared with the header fields of the warehouse data table. If there are semantically identical parts between the header fields of the target database and the header fields of the warehouse data table, the header fields in the warehouse data table that are semantically identical to the header fields of the target database are determined, or the content corresponding to the header fields in the warehouse data table that are semantically identical to the header fields of the target database is determined, and the header fields are changed to be consistent with the header fields of the target database; and the semantically different parts between the header fields of the target database and the header fields of the warehouse data table are filtered out to obtain a warehouse data table that conforms to each data template in the target database, and the warehouse data table is used as a table that can be stored in the warehouse.

[0072] S330, obtaining a warehouse data table from the target database, analyzing the header fields of the warehouse data table and the goods information in the warehouse data table, obtaining a time pattern corresponding to the goods information, and determining the type of goods recorded in the warehouse data table according to the time pattern;

[0073] In a specific implementation, the cargo information in the warehouse data table may be cargo-related information recorded in the warehouse data table, such as cargo codes, cargo sizes, and cargo in-and-out records. The time pattern corresponding to the cargo information may be the time period characteristics corresponding to the cargo in-and-out messages in the warehouse management system, such as the duration of cargo storage, the time point of cargo storage, the total time of cargo storage and out-of-warehouse, the in-warehouse quantity, out-of-warehouse quantity, and inventory quantity of cargo storage, etc., or the time period of cargo in-and-out. The warehouse data table is obtained from the target database, and the header fields of the warehouse data table and the cargo information in the warehouse data table are analyzed to obtain the time pattern corresponding to the cargo information, and the cargo type is determined according to the period characteristics corresponding to the time pattern, such as: daily necessities have no obvious time characteristics, medical items are highly correlated with medical accidents, and clothing items have obvious seasonality, so as to determine the attribute characteristics of the cargo type according to the cargo type recorded in the warehouse data table, and then use the attribute characteristics to perform statistical analysis of relevant dimensions.

[0074] S340, querying the cargo attribute library according to the cargo type to obtain the attribute characteristics of the cargo type, and determining the statistical dimension of the warehouse data table according to the attribute characteristics and the cargo outbound rate in the warehouse data table;

[0075] In a specific implementation, the cargo attribute library can be data associated with cargo types and attribute characteristics organized according to historical cargo storage conditions. The attribute characteristics of the cargo type can be queried according to the cargo type, so as to determine the statistical dimension of the warehouse data table according to the cargo data characteristics. The cargo outbound rate in the warehouse data table can be the length of cargo storage time in the warehouse data table or the number of cargo outbound within a fixed time, which is used to describe the speed of cargo outbound in the warehouse data table. The cargo attribute library is queried according to the determined cargo type, and the attribute characteristics stored in the cargo attribute library associated with the cargo type are used as the attribute characteristics of the cargo type in the warehouse data table. The statistical dimension of the warehouse data table is determined based on the attribute characteristics and the cargo outbound rate in the warehouse data table, so that the warehouse data table can automatically perform statistics based on the attribute characteristics of the content in the warehouse data table and the cargo outbound rate in the warehouse data table, so as to achieve the effect of accurate statistical analysis.

[0076] S350, calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table;

[0077] Furthermore, the analysis function is called according to the statistical dimensions of the warehouse data table, including:

[0078] Determine the period of the statistical dimension;

[0079] Determine the analysis function corresponding to the warehouse data table from the analysis function library according to the period of the statistical dimension.

[0080] In a specific implementation, the period of the statistical dimension can be the time length of the statistical dimension, such as multiple statistical dimensions such as hourly, daily, quarterly, and annual. According to the statistical dimension of the warehouse data table, the analysis function required for the content in the warehouse data table is retrieved from the analysis function library, and the analysis function corresponding to the statistical dimension of the warehouse data table is used to perform functional analysis on the content in the warehouse data table.

[0081] Furthermore, the analysis function is used to analyze the contents in the warehouse data table to obtain a visual chart of the warehouse data table, including:

[0082] Analyze the contents in the warehouse data table according to the analysis function to obtain visual chart information of the warehouse data table;

[0083] Writing code in a first language according to the visual chart information to obtain a first macro instruction;

[0084] The visualization chart information is visualized using the display code of the second language according to the first macro instruction to obtain a visualization chart of the warehouse data table.

[0085] For example, the visualization chart information can be the information used to form the visualization chart by analyzing the content in the warehouse data table using the analysis function to obtain the analysis results. The first language can be the language of the data relational management system, which is used to clearly express the visualization chart information in the analysis results of the content in the warehouse data table. The first macro instruction can be a control instruction formed according to the first language, which is used to present or run the data records and analysis results in different program software, such as: SQL language. The second language can be an object-oriented open source programming language for realizing the visualization of visualization chart information. The significance of using the second language is that the second language can realize the visualization of more visualization chart information than the first language, such as: Java language.

[0086] In a specific implementation, the content in the warehouse data table is analyzed according to the analysis function to obtain the visual chart information of the warehouse data table; the code is written in the first language according to the visual chart information, the written code is formed into a first macro instruction, and the visual chart information is associated with the warehouse data table by using the first macro instruction, and the visual chart information in the first macro instruction is visualized according to the second code to obtain a visual chart of the warehouse data table. The first language and the second language can be used for flexible coding, which increases the flexibility of the method, and can be used to find that the analysis content that can be added can be added by coding during the user's use.

[0087] S360. Obtain the user's display requirements, and select content in the visualization chart for display according to the display requirements.

[0088] Furthermore, after obtaining the user's display requirements and selecting the content in the visualization chart for display according to the display requirements, it also includes:

[0089] Determine the number of transport equipment in the sorting system based on the cargo indicators corresponding to the displayed content in the visual chart;

[0090] The cargo delivery location in the sorting system is determined based on the cargo rotation rate and cargo grade corresponding to the displayed content.

[0091] For example, the display content in the visualization chart can be a visualization chart displayed on the terminal or platform according to customer needs, and the cargo index can be a digital index calculated by the analysis function in the warehouse data table, which is used to measure the speed and attribute characteristics of the goods in and out of the warehouse in the statistical dimension, such as: shipment frequency, number of orders per day, number of order lines, cargo rotation rate, among which the cargo rotation rate can be the repetition rate of goods between two adjacent statistical dimension units, which is used to determine whether the transportation equipment in the sorting system will move the goods to other cargo outlet locations, and reduce the distance where the transportation equipment searches for partners or moves goods with a high frequency, so as to reduce the transportation equipment, reduce costs, and quickly complete the warehouse in and out of the warehouse. Among them, the cargo grade can be determined according to the cargo shipment frequency, which is used to determine the warehouse cargo shipment location.

[0092] In the specific implementation, the number of transport equipment in the sorting system is determined according to the cargo indicators corresponding to the display content in the visual chart, that is, the highest peak cargo volume and the lowest cargo volume in the warehouse data table are determined according to the display content in the visual chart, and the number of transport equipment in the sorting system that completes the sorting task within the delivery time of the goods is determined according to the preset delivery time of the goods, and the cargo delivery position in the sorting system that matches the rotation rate and the cargo grade in the display content is determined, so that the sorting system can automatically set the number of transport equipment and the cargo delivery position according to the display content in the visual chart.

[0093] In an embodiment of the present invention, a data display method can be implemented through a data platform. First, according to the data display requirements of the data platform, a target database is established, a warehouse data table is obtained from the warehouse management system, and the warehouse data table is modified and screened according to each data template in the target database to obtain a warehouse data table that can be stored, and the data table is stored in the target database. The data platform obtains the warehouse data table in the target database, analyzes the header field of the warehouse data table, and obtains the type of goods recorded in the warehouse data table. Determine the attribute characteristics of the type of goods, and determine the statistical dimensions of the warehouse data table according to the attribute characteristics of the type of goods; call the analysis function according to the statistical dimensions of the warehouse data table, and use the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table; obtain the user's display requirements, and select the content in the visualization chart for display according to the display requirements. The data platform automatically completes the acquisition and analysis of data and the display of the visualization chart, wherein the data platform can obtain the warehouse data table and the user's display requirements, and the operator refreshes the platform to display the display content of the visualization chart.

[0094] In an embodiment of the present invention, by obtaining a warehouse data table from a target database and analyzing the header fields of the warehouse data table, the type of goods recorded in the warehouse data table is obtained; the attribute characteristics of the goods type are determined, and the statistical dimensions of the warehouse data table are determined according to the attribute characteristics of the goods type; the analysis function is called according to the statistical dimensions of the warehouse data table, and the content in the warehouse data table is analyzed by the analysis function to obtain a visualization chart of the warehouse data table; the display requirements of the user are obtained, and the content in the visualization chart is selected for display according to the display requirements. That is, in an embodiment of the present invention, the recorded type of goods is determined by the header fields of the warehouse data table, and the statistical dimensions are determined according to the attribute characteristics of the goods type, and the content in the warehouse data table is analyzed according to the statistical dimensions to obtain a visualization chart, and the content is displayed according to the customer's needs, and the warehouse data table can be automatically analyzed according to the obtained warehouse data table, and the warehouse data table can be analyzed according to the corresponding statistical dimensions, so as to achieve the purpose of accurately analyzing the warehouse data table, and generate a visualization chart, so as to display the chart according to the customer's needs.

[0095] Figure 4 is a schematic diagram of the structure of a data display device provided by an embodiment of the present invention, such as Figure 4 As shown, the data display device includes:

[0096] The field analysis module 410 is used to obtain a warehouse data table from a target database, analyze the header fields of the warehouse data table, and obtain the type of goods recorded in the warehouse data table;

[0097] A dimension determination module 420, configured to determine the attribute characteristics of the goods type, and determine the statistical dimension of the warehouse data table according to the attribute characteristics of the goods type;

[0098] The data analysis module 430 is used to call the analysis function according to the statistical dimension of the warehouse data table, and use the analysis function to analyze the content in the warehouse data table to obtain a visual chart of the warehouse data table;

[0099] The chart display module 440 is used to obtain the display requirements of the user and select the content in the visual chart for display according to the display requirements.

[0100] In one embodiment, before the field analysis module 410 obtains the warehouse data table from the target database, it also includes:

[0101] Obtain warehouse data tables stored in the warehouse management system within a preset time period and determine the header fields of the target database;

[0102] Modify and filter the header fields of the warehouse data table according to the header fields of the target database to obtain data that can be stored in the warehouse data table;

[0103] The warehouse-storable data table is stored in the target database.

[0104] In one embodiment, the field analysis module 410 modifies and filters the header fields of the warehouse data table according to the header fields of the target database to obtain data that can be stored in the warehouse data table, including:

[0105] Selecting contents corresponding to header fields with the same semantics from the warehouse data table according to the header fields of the target database;

[0106] The header fields corresponding to the content are changed to be consistent with the header fields of the target database to obtain the data table that can be stored in the warehouse.

[0107] In one embodiment, the field analysis module 410 analyzes the header field of the warehouse data table to obtain the type of goods recorded in the warehouse data table, including:

[0108] Analyze the header field of the warehouse data table and the goods information in the warehouse data table to obtain the time pattern corresponding to the goods information;

[0109] The type of goods recorded in the warehouse data table is determined according to the time rule.

[0110] In one embodiment, the dimension determination module 420 determines the attribute characteristics of the goods type, and determines the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type, including:

[0111] Querying a cargo attribute database according to the cargo type to obtain attribute characteristics of the cargo type;

[0112] The statistical dimension of the warehouse data table is determined according to the attribute characteristics and the cargo outbound rate in the warehouse data table.

[0113] In one embodiment, the data analysis module 430 calls the analysis function according to the statistical dimension of the warehouse data table, including:

[0114] Determining a period of the statistical dimension;

[0115] The analysis function corresponding to the warehouse data table is determined from an analysis function library according to the period of the statistical dimension.

[0116] In one embodiment, the data analysis module 430 uses the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table, including:

[0117] Analyze the content in the warehouse data table according to the analysis function to obtain visual chart information of the warehouse data table;

[0118] Writing code in a first language according to the visual chart information to obtain a first macro instruction;

[0119] The visualization chart information is visualized using a display code in a second language according to the first macro instruction to obtain a visualization chart of the warehouse data table.

[0120] In one embodiment, after the chart display module 440 obtains the display requirements of the user and selects the content in the visual chart for display according to the display requirements, it further includes:

[0121] Determine the number of transport devices in the sorting system according to the cargo index corresponding to the displayed content in the visualization chart;

[0122] The cargo delivery position in the sorting system is determined according to the cargo rotation rate and cargo grade corresponding to the displayed content.

[0123] In an embodiment of the present invention, by obtaining a warehouse data table from a target database and analyzing the header fields of the warehouse data table, the type of goods recorded in the warehouse data table is obtained; the attribute characteristics of the goods type are determined, and the statistical dimensions of the warehouse data table are determined according to the attribute characteristics of the goods type; the analysis function is called according to the statistical dimensions of the warehouse data table, and the content in the warehouse data table is analyzed by the analysis function to obtain a visualization chart of the warehouse data table; the display requirements of the user are obtained, and the content in the visualization chart is selected for display according to the display requirements. That is, in an embodiment of the present invention, the recorded type of goods is determined by the header fields of the warehouse data table, and the statistical dimensions are determined according to the attribute characteristics of the goods type, and the content in the warehouse data table is analyzed according to the statistical dimensions to obtain a visualization chart, and the content is displayed according to the customer's needs, and the warehouse data table can be automatically analyzed according to the obtained warehouse data table, and the warehouse data table can be analyzed according to the corresponding statistical dimensions, so as to achieve the purpose of accurately analyzing the warehouse data table, and generate a visualization chart, so as to display the chart according to the customer's needs.

[0124] Figure 5 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. Figure 5 A block diagram of an exemplary electronic device 12 suitable for use in implementing embodiments of the present invention is shown. Figure 5 The electronic device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0125] like Figure 5 As shown, the electronic device 12 is in the form of a general purpose computing device. The components of the electronic device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that connects various system components (including the system memory 28 and the processing unit 16).

[0126] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.

[0127] The electronic device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device 12, including volatile and non-volatile media, removable and non-removable media.

[0128] The system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The electronic device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 5 not shown, usually called a "hard drive"). Although Figure 5 Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.

[0129] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in the memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 42 generally perform the functions and / or methods of the embodiments described herein.

[0130] The electronic device 12 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), may communicate with one or more devices that enable a user to interact with the electronic device 12, and / or may communicate with any device that enables the electronic device 12 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed via an input / output (I / O) interface 22. Furthermore, the electronic device 12 may also communicate with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and / or public networks, such as the Internet) via a network adapter 20. As shown, the network adapter 20 communicates with other modules of the electronic device 12 via a bus 18. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0131] The processing unit 16 executes various functional applications and data processing by running the program stored in the system memory 28, for example, implementing the data display method provided in the embodiment of the present invention, which includes:

[0132] Obtain a warehouse data table from a target database, analyze a header field of the warehouse data table, and obtain the type of goods recorded in the warehouse data table;

[0133] Determining the attribute characteristics of the goods type, and determining the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type;

[0134] Calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table;

[0135] The user's display requirements are obtained, and the content in the visualization chart is selected for display according to the display requirements.

[0136] The embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, the data display method is implemented. The method includes:

[0137] Obtain a warehouse data table from a target database, analyze a header field of the warehouse data table, and obtain the type of goods recorded in the warehouse data table;

[0138] Determining the attribute characteristics of the goods type, and determining the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type;

[0139] Calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table;

[0140] The user's display requirements are obtained, and the content in the visualization chart is selected for display according to the display requirements.

[0141] The computer storage medium of the embodiment of the present invention can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to, a system, device or device of electricity, magnetism, light, electromagnetic, infrared, or semiconductor, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, a device or a device or used in combination with it.

[0142] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0143] The program code embodied on the computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0144] Computer program code for performing the operation of the present invention may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as an independent software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0145] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A data display method, It is characterized in that include: Obtain a warehouse data table from a target database, analyze a header field of the warehouse data table, and obtain the type of goods recorded in the warehouse data table; Determine the attribute characteristics of the goods type, and determine the statistical dimension of the warehouse data table according to the attribute characteristics of the goods type, wherein the attribute characteristics of the goods type include the goods update time regularity corresponding to the goods type, and the statistical dimension includes the time dimension for performing statistical analysis on the warehouse data table; Calling an analysis function according to the statistical dimension of the warehouse data table, and using the analysis function to analyze the content in the warehouse data table to obtain a visualization chart of the warehouse data table; Obtaining the display requirements of the user, and selecting the content in the visualization chart for display according to the display requirements; The determining the attribute characteristics of the goods type, and determining the statistical dimensions of the warehouse data table according to the attribute characteristics of the goods type, includes: Querying a cargo attribute database according to the cargo type to obtain attribute characteristics of the cargo type; The statistical dimension of the warehouse data table is determined according to the attribute characteristics and the cargo outbound rate in the warehouse data table.

2. The method according to claim 1, It is characterized in that Before getting the warehouse data table from the target database, it also includes: Obtain warehouse data tables stored in the warehouse management system within a preset time period and determine the header fields of the target database; Modify and filter the header fields of the warehouse data table according to the header fields of the target database to obtain data that can be stored in the warehouse data table; The warehouse-storable data table is stored in the target database.

3. The method according to claim 2, It is characterized in that Modifying and filtering the header fields of the warehouse data table according to the header fields of the target database to obtain a data table that can be stored in the warehouse, including: Selecting contents corresponding to header fields with the same semantics from the warehouse data table according to the header fields of the target database; The header fields corresponding to the content are changed to be consistent with the header fields of the target database to obtain the data table that can be stored in the warehouse.

4. The method according to claim 1, It is characterized in that Analyze the header fields of the warehouse data table to obtain the types of goods recorded in the warehouse data table, including: Analyze the header field of the warehouse data table and the goods information in the warehouse data table to obtain the time pattern corresponding to the goods information; The type of goods recorded in the warehouse data table is determined according to the time rule.

5. The method according to claim 1, It is characterized in that The analysis function is called according to the statistical dimension of the warehouse data table, including: determining a period of the statistical dimension; The analysis function corresponding to the warehouse data table is determined from an analysis function library according to the period of the statistical dimension.

6. The method according to claim 1, It is characterized in that The content in the warehouse data table is analyzed by using the analysis function to obtain a visualization chart of the warehouse data table, including: Analyze the content in the warehouse data table according to the analysis function to obtain visual chart information of the warehouse data table; Writing code in a first language according to the visual chart information to obtain a first macro instruction; The visualization chart information is visualized using a display code in a second language according to the first macro instruction to obtain a visualization chart of the warehouse data table.

7. The method according to claim 1, It is characterized in that After obtaining the display requirements of the user and selecting the content in the visualization chart for display according to the display requirements, the method further includes: Determine the number of transport devices in the sorting system according to the cargo index corresponding to the displayed content in the visualization chart; The cargo delivery position in the sorting system is determined according to the cargo rotation rate and cargo grade corresponding to the displayed content.

8. A data display device, It is characterized in that include: A field analysis module is used to obtain a warehouse data table from a target database, analyze the header fields of the warehouse data table, and obtain the type of goods recorded in the warehouse data table; a dimension determination module, used to determine the attribute characteristics of the goods type, and determine the statistical dimension of the warehouse data table according to the attribute characteristics of the goods type, wherein the attribute characteristics of the goods type include the goods update time regularity corresponding to the goods type, and the statistical dimension includes the time dimension for statistical analysis of the warehouse data table; A data analysis module, used to call an analysis function according to the statistical dimension of the warehouse data table, and use the analysis function to analyze the content in the warehouse data table to obtain a visual chart of the warehouse data table; A chart display module is used to obtain the display requirements of the user and select the content in the visual chart for display according to the display requirements; The dimension determination module is specifically used to query the cargo attribute library according to the cargo type to obtain the attribute characteristics of the cargo type; The statistical dimension of the warehouse data table is determined according to the attribute characteristics and the cargo outbound rate in the warehouse data table.

9. An electronic device, It is characterized in that The electronic device comprises: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the data presentation method as described in any one of claims 1 to 7.

10. A computer-readable storage medium having a computer program stored thereon, It is characterized in that When the program is executed by a processor, the data display method as described in any one of claims 1 to 7 is implemented.

Images