CN109947809A - A kind of monitoring method and system, storage medium and terminal device of order operation data - Google Patents

A kind of monitoring method and system, storage medium and terminal device of order operation data Download PDF

Info

Publication number
CN109947809A
CN109947809A CN201710980241.0A CN201710980241A CN109947809A CN 109947809 A CN109947809 A CN 109947809A CN 201710980241 A CN201710980241 A CN 201710980241A CN 109947809 A CN109947809 A CN 109947809A
Authority
CN
China
Prior art keywords
order
order operation
time
operation data
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201710980241.0A
Other languages
Chinese (zh)
Inventor
顾鹏飞
李哲民
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Shiyuan Internet Technology Co Ltd
Original Assignee
Shanghai Shiyuan Internet Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shanghai Shiyuan Internet Technology Co Ltd filed Critical Shanghai Shiyuan Internet Technology Co Ltd
Priority to CN201710980241.0A priority Critical patent/CN109947809A/en
Publication of CN109947809A publication Critical patent/CN109947809A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides the monitoring method and system, storage medium and terminal device of a kind of order operation data, comprising the following steps: when order operation occurs, obtains order operation data;Acquired order operation data are converted into time series data, the time series data includes time tag and order operation type;The time series data is stored into timing type database;Based on the time series data in the timing type database, according to when the one or more types of ordered pair order operation be monitored.The time series data that the monitoring method and system, storage medium and terminal device of order operation data of the invention are stored based on timing type database, realize the monitoring analysis of large batch of order operation data, the incidence relation of order operation data and order itself is breached, quick and precisely.

Description

A kind of monitoring method and system, storage medium and terminal device of order operation data
Technical field
The present invention relates to the technical fields of data processing, a kind of monitoring method more particularly to order operation data and are System, storage medium and terminal device.
Background technique
Relevant database is built upon the database on the basis of relational model, by means of mathematical concepts such as algebras of sets and Method handles the data in database.Relationship mould is used in various connections between various entities and entity in the real world Type indicates.Relational model just refers to two-dimensional table model.Thus a relevant database be exactly by bivariate table and its between Connection composition a data organization.The relevant database of current main-stream have Oracle, DB2, PostgreSQL, Microsoft SQL Server, Microsoft Access, MySQL, tide K-DB etc..In general, relational model is by relationship number According to structure, relational operation set, relation integraity constraint three parts composition.
File in file system corresponds essentially to some application program.The data required for different application programs There is part phase at the same time it is also necessary to establish respective file, and be unable to shared data.It can then be shared in Document image analysis identical Data.Therefore, Document image analysis has the physical independence and logical independence of data, data and program separation.Document Type database is different from relevant database, and relevant database is highly structural, and the Document image analysis of Notes is permitted Perhaps many different types of non-structured or arbitrary format fields are created, are not provided to parameter integrality and Distributed Transaction Support, but be also not mutually exclusive with relevant database.Data can be exchanged with each other between them, thus mutually complementary It fills, extend.
In relevant database or Document image analysis, log or state change value are generallyd use to order operation data It is stored, then order and log or state change is subjected to one-to-many association.The operand to single order can be met in this way According to check, analysis demand.But when the operation data of a large amount of orders is monitored or is analyzed, then need to expend the inquiry of magnanimity Time and calculate cost, thus can not quick response group order operation variation;And it is needed not in the operation data of order With dimension inquiry when, need that the inquiry combination of required dimension is become new data storage cell and stored in advance, cause to grasp Make cumbersome, the practicability is poor.
Summary of the invention
In view of the foregoing deficiencies of prior art, the purpose of the present invention is to provide a kind of monitoring of order operation data Method and system, storage medium and terminal device realize high-volume based on the time series data that timing type database is stored Order operation data monitoring analysis, breach the incidence relation of order operation data and order itself, quick and precisely.
In order to achieve the above objects and other related objects, the present invention provides a kind of order operation based on timing type database The monitoring method of data, comprising the following steps: when order operation occurs, obtain order operation data;By acquired order Operation data is converted to time series data, and the time series data includes time tag and order operation type;It will be described Time series data is stored into timing type database;Based on the time series data in the timing type database, according to when The order operation of the one or more types of ordered pair is monitored.
In one embodiment of the invention, the order operation data include O/No., the order amount of money, order article, order Single submission time, order time of payment, order send time, cancellation of order time and order reimbursement time with charge free.
In one embodiment of the invention, the type of the order operation include order submit, order payment, order send with charge free, Cancellation of order and order reimbursement.
It further include the time trend for drawing the order operation of one or more types in one embodiment of the invention Figure.
Accordingly, the present invention provides a kind of monitoring system of order operation data based on timing type database, including obtains Modulus block, conversion module, memory module and monitoring module;
Module is obtained to be used to obtain order operation data when order operation occurs;
Conversion module is used to acquired order operation data being converted to time series data, the time series data Including time tag and order operation type;
Memory module is for storing the time series data into timing type database;
Monitoring module is used for based on the time series data in the timing type database, according to when ordered pair it is one or more The order operation of type is monitored.
In one embodiment of the invention, the order operation data include O/No., the order amount of money, order article, order Single submission time, order time of payment, order send time, cancellation of order time and order reimbursement time with charge free.
In one embodiment of the invention, the type of the order operation include order submit, order payment, order send with charge free, Cancellation of order and order reimbursement.
It in one embodiment of the invention, further include drafting module, for drawing the order operation of one or more types Time trend figure.
Meanwhile the present invention also provides a kind of storage medium, it is stored thereon with computer program, which is executed by processor The monitoring method of the above-mentioned order operation data based on timing type database of Shi Shixian.
Finally, the present invention also provides a kind of terminal device, including communicator, processor and memory;
The communicator is used to obtain order operation data when order operation occurs;
The memory is for storing computer program;
The processor is used to execute the computer program of the memory storage according to the order operation data, with The terminal device is set to execute the monitoring method of the above-mentioned order operation data based on timing type database.
As described above, the monitoring method and system, storage medium and terminal device of order operation data of the invention, have Below
The utility model has the advantages that
(1) time series data stored based on timing type database realizes the prison of large batch of order operation data Control analysis, quick and precisely;
(2) feature, Fast Drawing trend curve, fast reaction group can be polymerize using the efficient timing of timing type database Body order operation variation tendency;
(3) break traditional database summarize the data storages of order operation data, data summarization, data warehouse natural mode Formula substantially increases the monitoring timeliness to a large amount of order operation data;
(4) can a large amount of order operation data be carried out with the playback on time shaft;
(5) it is used with traditional database collocation, to reduce the maintenance of traditional database, use cost.
Detailed description of the invention
Fig. 1 is shown as the monitoring method of the order operation data of the invention based on timing type database in an embodiment Flow chart;
Fig. 2 is shown as the monitoring system of the order operation data of the invention based on timing type database in an embodiment Structural schematic diagram;
Fig. 3 is shown as the structural schematic diagram of terminal device of the invention in an embodiment.
Component label instructions
21 obtain module
22 conversion modules
23 memory modules
24 monitoring modules
31 communicators
32 processors
33 memories
Specific embodiment
Illustrate embodiments of the present invention below by way of specific specific example, those skilled in the art can be by this specification Other advantages and efficacy of the present invention can be easily understood for disclosed content.The present invention can also pass through in addition different specific realities The mode of applying is embodied or practiced, the various details in this specification can also based on different viewpoints and application, without departing from Various modifications or alterations are carried out under spirit of the invention.It should be noted that in the absence of conflict, following embodiment and implementation Feature in example can be combined with each other.
It should be noted that illustrating the basic structure that only the invention is illustrated in a schematic way provided in following embodiment Think, only shown in schema then with related component in the present invention rather than component count, shape and size when according to actual implementation Draw, when actual implementation kenel, quantity and the ratio of each component can arbitrarily change for one kind, and its assembly layout kenel It is likely more complexity.
Timing type database full name is time series databases.Time series databases are mainly used for referring to that the processing band time marks The data of label (changing according to the sequence of time, i.e. the time serializes), the data with time tag are also referred to as time series data.
Currently, time series data is mainly set by all types of real-time monitorings such as power industry, chemical industry, inspection and analysis The standby data for acquiring, generating, the typical feature of these industrial datas is: generation frequency is fast (in each monitoring point one second Can produce a plurality of data), depend critically upon acquisition time (each data is required to correspond to unique time), measuring point multi information Amount is big, and (conventional real-time monitoring system has thousands of monitoring point, and monitoring point all generates data, generate daily several each second The data volume of ten GB).
Timing type database uses special data storage mode, greatly improves the processing capacity of Time Correlation Data, phase For relevant database, memory space halves, and inquiry velocity greatly improves.The superior query performance of time sequence function Far more than relevant database, it is highly suitable for Internet of Things analysis application.
The monitoring method and system, storage medium and terminal device of order operation data of the invention are based on timing type data The time series data that library is stored realizes the monitoring analysis of large batch of order operation data, breaks traditional database and summarize The data storages of order operation data, data summarization, data warehouse natural mode, substantially increase to a large amount of order operation numbers According to monitoring timeliness.
As shown in Figure 1, in an embodiment, the monitoring side of the order operation data of the invention based on timing type database Method the following steps are included:
Step S1, when order operation occurs, order operation data are obtained.
Specifically, it when the order operation for a certain order occurs, then needs to store relevant order operation information Into timing type database.Therefore, it is necessary first to obtain order operation data.
In one embodiment of the invention, the order operation data include O/No., the order amount of money, order article, order Single submission time, order time of payment, order send time, cancellation of order time and order reimbursement time with charge free.
Step S2, acquired order operation data are converted into time series data, the time series data includes Time tag and order operation type.
Specifically, according to the data memory format of the timing type database pre-defined, by acquired order operation Data are converted to the time series data for meeting above-mentioned data memory format.Time series data is characterized in Label, therefore time series data includes at least time tag and order operation type in the present invention.It should be noted that its It may include the information such as O/No., the order amount of money, order article.
In one embodiment of the invention, the type of the order operation include order submit, order payment, order send with charge free, Cancellation of order and order reimbursement.
Step S3, the time series data is stored into timing type database.
Specifically, the corresponding time series data of order operation data is stored into timing type database, to complete The building of timing type database.
Step S4, based on the time series data in the timing type database, according to when the one or more types of ordered pair Order operation be monitored.
When needing the order operation to one or more types to be monitored analysis, using being deposited in timing type database The time series data of storage is monitored analysis according to time order and function, to judge the variation tendency of order operation.
It further include the time trend for drawing the order operation of one or more types in one embodiment of the invention Figure.Specifically, according to the corresponding time series data of each order operation data, one or more classes are drawn according to time order and function The time trend figure of the order operation of type, thus fast reaction group order operation variation tendency.Preferably, the change Changing tendency chart can be one of curve graph, grid figure or a variety of.
As shown in Fig. 2, in an embodiment, the monitoring system of the order operation data of the invention based on timing type database System includes obtaining module 21, conversion module 22, memory module 23 and monitoring module 24.
Module 21 is obtained to be used to obtain order operation data when order operation occurs.
Specifically, it when the order operation for a certain order occurs, then needs to store relevant order operation information Into timing type database.Therefore, it is necessary first to obtain order operation data.
In one embodiment of the invention, the order operation data include O/No., the order amount of money, order article, order Single submission time, order time of payment, order send time, cancellation of order time and order reimbursement time with charge free.
Conversion module 22 is connected with module 21 is obtained, for acquired order operation data to be converted to time series number According to the time series data includes time tag and order operation type.
Specifically, according to the data memory format of the timing type database pre-defined, conversion module 22 will be acquired Order operation data be converted to the time series data for meeting above-mentioned data memory format.Time series data be characterized in Temporal information is label, therefore time series data includes at least time tag and order operation type in the present invention.It needs It is bright, it also may include the information such as O/No., the order amount of money, order article.
In one embodiment of the invention, the type of the order operation include order submit, order payment, order send with charge free, Cancellation of order and order reimbursement.
Memory module 23 is connected with conversion module 22, for storing the time series data to timing type database In.
Specifically, the corresponding time series data of order operation data is stored into timing type database, to complete The building of timing type database.
Monitoring module 24 is connected with memory module 23, for based on the time series data in the timing type database, According to when the one or more types of ordered pair order operation be monitored.
When needing the order operation to one or more types to be monitored analysis, using being deposited in timing type database The time series data of storage is monitored analysis according to time order and function, to judge the variation tendency of order operation.
It in one embodiment of the invention, further include drafting module, for drawing the order operation of one or more types Time trend figure.Specifically, it according to the corresponding time series data of each order operation data, is drawn according to time order and function The time trend figure of the order operation of one or more types, thus fast reaction group order operation variation tendency. Preferably, the trend chart can be one of curve graph, grid figure or a variety of.
It should be noted that it should be understood that the modules of system above division be only a kind of logic function division, It can completely or partially be integrated on a physical entity in actual implementation, it can also be physically separate.And these modules can be with All realized by way of processing element calls with software;It can also all realize in the form of hardware;It can also part mould Block realizes that part of module passes through formal implementation of hardware by way of processing element calls software.For example, x module can be The processing element individually set up also can integrate and realize in some chip of above-mentioned apparatus, in addition it is also possible to program generation The form of code is stored in the memory of above-mentioned apparatus, is called by some processing element of above-mentioned apparatus and is executed the above x mould The function of block.The realization of other modules is similar therewith.Furthermore these modules completely or partially can integrate together, can also be only It is vertical to realize.Processing element described here can be a kind of integrated circuit, the processing capacity with signal.During realization, Each step of the above method or the above modules can be by the integrated logic circuits of the hardware in processor elements or soft The instruction of part form is completed.
For example, the above module can be arranged to implement one or more integrated circuits of above method, such as: One or more specific integrated circuits (Application Specific Integrated Circuit, abbreviation ASIC), or, One or more microprocessors (Digital Singnal Processor, abbreviation DSP), or, one or more scene can compile Journey gate array (Field Programmable Gate Array, abbreviation FPGA) etc..For another example, when some above module passes through place When managing the form realization of element scheduler program code, which can be general processor, such as central processing unit (Central Processing Unit, abbreviation CPU) or it is other can be with the processor of caller code.For another example, these modules It can integrate together, realized in the form of system on chip (System-On-a-Chip, abbreviation SOC).
Storage medium of the invention is stored thereon with computer program, which realizes above-mentioned base when being executed by processor In the monitoring method of the order operation data of timing type database.Preferably, the storage medium include: ROM, RAM, magnetic disk or The various media that can store program code such as person's CD.
As shown in figure 3, terminal device of the invention includes communicator 31, processor 32 and memory in an embodiment 33。
The communicator 31 is used to obtain order operation data when order operation occurs.
The memory 33 is for storing computer program.
Preferably, to include: that ROM, RAM, magnetic or disk etc. are various can store program code with the memory 33 Medium.
The processor 32 is connected with the communicator 31 and the memory 33, for according to the order operation number According to, execute the computer program that the memory 33 stores so that the terminal device execute it is above-mentioned based on timing type data The monitoring method of the order operation data in library.
Preferably, processor 32 can be general processor, including central processing unit (CentralProcessingUnit, Abbreviation CPU), network processing unit (NetworkProcessor, abbreviation NP) etc.;It can also be digital signal processor (DigitalSignalProcessing, abbreviation DSP), specific integrated circuit (ApplicationSpecificIntegratedCircuit, abbreviation ASIC), field programmable gate array (Field- ProgrammableGateArray, abbreviation FPGA) either other programmable logic device, discrete gate or transistor logic device Part, discrete hardware components.
In conclusion the monitoring method and system, storage medium and terminal device of order operation data of the invention are based on The time series data that timing type database is stored realizes the monitoring analysis of large batch of order operation data, quick and precisely; Feature, Fast Drawing trend curve, fast reaction group order behaviour can be polymerize using the efficient timing of timing type database Make variation tendency;Break traditional database summarize the data storages of order operation data, data summarization, data warehouse natural mode Formula substantially increases the monitoring timeliness to a large amount of order operation data;Time shaft can be carried out to a large amount of order operation data On playback;It arranges in pairs or groups and uses with traditional database, to reduce the maintenance of traditional database, use cost.So the present invention It effectively overcomes various shortcoming in the prior art and has high industrial utilization value.
The above-described embodiments merely illustrate the principles and effects of the present invention, and is not intended to limit the present invention.It is any ripe The personage for knowing this technology all without departing from the spirit and scope of the present invention, carries out modifications and changes to above-described embodiment.Cause This, institute is complete without departing from the spirit and technical ideas disclosed in the present invention by those of ordinary skill in the art such as At all equivalent modifications or change, should be covered by the claims of the present invention.

Claims (10)

1. a kind of monitoring method of the order operation data based on timing type database, it is characterised in that: the following steps are included:
When order operation occurs, order operation data are obtained;
Acquired order operation data are converted into time series data, the time series data includes time tag and orders Single operation type;
The time series data is stored into timing type database;
Based on the time series data in the timing type database, according to when the one or more types of ordered pair order operation into Row monitoring.
2. the monitoring method of the order operation data according to claim 1 based on timing type database, it is characterised in that: The order operation data include O/No., the order amount of money, order article, order submission time, order time of payment, order Send time, cancellation of order time and order reimbursement time with charge free.
3. the monitoring method of the order operation data according to claim 1 based on timing type database, it is characterised in that: The type of the order operation includes that order is submitted, order payment, order are sent with charge free, cancellation of order and order reimbursement.
4. the monitoring method of the order operation data according to claim 1 based on timing type database, it is characterised in that: It further include the time trend figure for drawing the order operation of one or more types.
5. a kind of monitoring system of the order operation data based on timing type database, it is characterised in that: including obtaining module, turning Change the mold block, memory module and monitoring module;
Module is obtained to be used to obtain order operation data when order operation occurs;
Conversion module is used to acquired order operation data being converted to time series data, and the time series data includes Time tag and order operation type;
Memory module is for storing the time series data into timing type database;
Monitoring module is used for based on the time series data in the timing type database, according to when the one or more types of ordered pair Order operation be monitored.
6. the monitoring system of the order operation data according to claim 5 based on timing type database, it is characterised in that: The order operation data include O/No., the order amount of money, order article, order submission time, order time of payment, order Send time, cancellation of order time and order reimbursement time with charge free.
7. the monitoring system of the order operation data according to claim 5 based on timing type database, it is characterised in that: The type of the order operation includes that order is submitted, order payment, order are sent with charge free, cancellation of order and order reimbursement.
8. the monitoring system of the order operation data according to claim 5 based on timing type database, it is characterised in that: It further include drafting module, the time trend figure of the order operation for drawing one or more types.
9. a kind of storage medium, is stored thereon with computer program, which is characterized in that realize power when the program is executed by processor Benefit require any one of 1 to 4 described in the order operation data based on timing type database monitoring method.
10. a kind of terminal device, it is characterised in that: including communicator, processor and memory;
The communicator is used to obtain order operation data when order operation occurs;
The memory is for storing computer program;
The processor is used to execute the computer program of the memory storage according to the order operation data, so that institute State the monitoring of the order operation data based on timing type database described in any one of terminal device perform claim requirement 1 to 4 Method.
CN201710980241.0A 2017-10-19 2017-10-19 A kind of monitoring method and system, storage medium and terminal device of order operation data Pending CN109947809A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710980241.0A CN109947809A (en) 2017-10-19 2017-10-19 A kind of monitoring method and system, storage medium and terminal device of order operation data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710980241.0A CN109947809A (en) 2017-10-19 2017-10-19 A kind of monitoring method and system, storage medium and terminal device of order operation data

Publications (1)

Publication Number Publication Date
CN109947809A true CN109947809A (en) 2019-06-28

Family

ID=67003975

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710980241.0A Pending CN109947809A (en) 2017-10-19 2017-10-19 A kind of monitoring method and system, storage medium and terminal device of order operation data

Country Status (1)

Country Link
CN (1) CN109947809A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20150278308A1 (en) * 2014-03-31 2015-10-01 Wal-Mart Stores, Inc. Routing order lookups
CN105321129A (en) * 2015-10-19 2016-02-10 钱林恒兴(北京)科技有限公司 Order processing method and order processing system for food ordering system
CN106294781A (en) * 2016-08-12 2017-01-04 多点生活(中国)网络科技有限公司 A kind of order track method for visualizing and system
CN106503276A (en) * 2017-01-06 2017-03-15 山东浪潮云服务信息科技有限公司 A kind of method and apparatus of the time series databases for real-time monitoring system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20150278308A1 (en) * 2014-03-31 2015-10-01 Wal-Mart Stores, Inc. Routing order lookups
CN105321129A (en) * 2015-10-19 2016-02-10 钱林恒兴(北京)科技有限公司 Order processing method and order processing system for food ordering system
CN106294781A (en) * 2016-08-12 2017-01-04 多点生活(中国)网络科技有限公司 A kind of order track method for visualizing and system
CN106503276A (en) * 2017-01-06 2017-03-15 山东浪潮云服务信息科技有限公司 A kind of method and apparatus of the time series databases for real-time monitoring system

Similar Documents

Publication Publication Date Title
US9946780B2 (en) Interpreting relational database statements using a virtual multidimensional data model
US11537635B2 (en) Hadoop OLAP engine
US10642642B2 (en) Techniques to manage virtual classes for statistical tests
Chong et al. Big data analytics: a literature review
CN103177057B (en) Many accounting methods for internal memory column storage database
KR102134494B1 (en) Profiling data with location information
CN110019397B (en) Method and device for data processing
CN111971666A (en) Dimension context propagation technology for optimizing SQL query plan
CN109690524A (en) Data Serialization in distributed event processing system
JP6434154B2 (en) Identifying join relationships based on transaction access patterns
JP2010524060A (en) Data merging in distributed computing
CN103324765A (en) Multi-core synchronization data query optimization method based on column storage
WO2021036452A1 (en) Real-time data deduplication counting method and device
Lněnička AHP model for the big data analytics platform selection
Gupta et al. Smartbench: A benchmark for data management in smart spaces
US11436656B2 (en) System and method for a real-time egocentric collaborative filter on large datasets
Bakli et al. A spatiotemporal algebra in Hadoop for moving objects
WO2021012861A1 (en) Method and apparatus for evaluating data query time consumption, and computer device and storage medium
CN112949278A (en) Data checking method and device, electronic equipment and readable storage medium
CN113553341A (en) Multidimensional data analysis method, multidimensional data analysis device, multidimensional data analysis equipment and computer readable storage medium
CN109947809A (en) A kind of monitoring method and system, storage medium and terminal device of order operation data
CN108805597B (en) Model construction method and device and data report generation method and device
Lu et al. A survey of mapreduce based parallel processing technologies
CN115114297A (en) Data lightweight storage and search method and device, electronic equipment and storage medium
CN115062028A (en) Method for multi-table join query in OLTP field

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20190628