[go: up one dir, main page]

WO2018161403A1 - Procédé et système de statistiques de données pour formulaires de rapport - Google Patents

Procédé et système de statistiques de données pour formulaires de rapport Download PDF

Info

Publication number
WO2018161403A1
WO2018161403A1 PCT/CN2017/080129 CN2017080129W WO2018161403A1 WO 2018161403 A1 WO2018161403 A1 WO 2018161403A1 CN 2017080129 W CN2017080129 W CN 2017080129W WO 2018161403 A1 WO2018161403 A1 WO 2018161403A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
report
object attribute
sequential
result
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.)
Ceased
Application number
PCT/CN2017/080129
Other languages
English (en)
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.)
Shenzhen Kemai Technology Co Ltd
Original Assignee
Shenzhen Kemai 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 Shenzhen Kemai Technology Co Ltd filed Critical Shenzhen Kemai Technology Co Ltd
Publication of WO2018161403A1 publication Critical patent/WO2018161403A1/fr
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462—Approximate or statistical queries

Definitions

  • the present invention relates to the field of report technology, and in particular, to a data statistics method and system for a report.
  • the statistical method is: first save the first data; compare the second data with the first data, if the two belong to different object attributes, then The second data is saved separately; the third data is compared with the first data, if it is a different object attribute, and then compared with the second data, if it is the same object attribute, the third data and the second data.
  • the data is accumulated and saved, and so on, each data is compared to all of the previously saved data until all the data has been processed.
  • this processing method needs to traverse each data in front of all the data already existing, and the statistical efficiency for a large amount of data will be very low.
  • the object of the present invention is to provide a data statistics method and system for a report, and a statistical algorithm that first sorts and then summarizes can improve the statistical efficiency of the memory data.
  • an embodiment of the present invention provides a data statistics method for a report, where the method includes the following steps:
  • report data information includes an object attribute and data corresponding to the object attribute
  • the embodiment of the present invention provides a first possible implementation manner of the first aspect, wherein the step of calculating data in the sequential data group to obtain a calculation result includes:
  • the data in the sequential data set is subjected to a maximum value calculation to obtain a maximum value result.
  • the embodiment of the present invention provides the second possible implementation manner of the first aspect, wherein the sequence data group includes first data and second data, the pair The step of performing the summation calculation on the data in the sequential data set to obtain the summation result includes repeatedly performing the following processing until all the data of the sequential data group is traversed:
  • the second data is separately protected Save.
  • the embodiment of the present invention provides a third possible implementation manner of the first aspect, wherein the object attribute is a plurality of object attributes in a statistical item of the report.
  • an embodiment of the present invention provides a fourth possible implementation manner of the first aspect, wherein the report data information and the calculation result are saved in a database.
  • the embodiment of the present invention further provides a data statistics system for a report, including:
  • An obtaining unit configured to acquire report data information, where the report data information includes an object attribute and data corresponding to the object attribute;
  • a sorting unit configured to sort the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged
  • the calculating unit is configured to calculate data in the sequential data group to obtain a calculation result.
  • the embodiment of the present invention provides a first possible implementation manner of the second aspect, wherein the calculating unit includes:
  • a summation unit configured to perform a summation calculation on the data in the sequential data group to obtain a summation result
  • An averaging unit configured to perform averaging calculation on data in the sequential data group to obtain an averaging result
  • the most value unit is configured to perform a maximum value calculation on the data in the sequential data group to obtain a maximum value result.
  • the embodiment of the present invention provides the second possible implementation manner of the second aspect, wherein the sequential data group includes first data and second data, And units include:
  • a matching unit configured to save the first data and the second data and the first A data is compared and a comparison result is obtained
  • the accumulating unit is configured to add the first data and the second data to obtain the third data if the comparison result is belonging to the same object attribute;
  • the saving unit is configured to separately save the second data if the comparison result is a different object attribute.
  • the embodiment of the present invention provides a third possible implementation manner of the second aspect, wherein the object attribute is a plurality of object attributes in a statistical item of the report.
  • the embodiment of the present invention provides a fourth possible implementation manner of the second aspect, wherein the report data information and the calculation result are saved in a database.
  • the present invention provides a data statistics method and system for a report, the method comprising: obtaining report data information, the report data information including data corresponding to an object attribute and an object attribute; and sorting data corresponding to the object attribute according to the object attribute to obtain a sequential data group , wherein the data with the same object attributes are closely arranged; the data in the sequential data group is calculated to obtain a calculation result.
  • the statistical efficiency of memory data can be improved by using a statistical algorithm that sorts and then generalizes.
  • FIG. 1 is a flowchart of a data statistics method for a report according to Embodiment 1 of the present invention
  • FIG. 3 is a schematic structural diagram of a data statistics system of a report according to Embodiment 1 of the present invention.
  • FIG. 4 is a schematic structural diagram of a computing unit of a data statistics system of a report according to Embodiment 2 of the present invention.
  • FIG. 5 is a schematic structural diagram of a summation unit of a data statistics system of a report according to Embodiment 2 of the present invention.
  • the statistical method used for the original data in the memory is: first save the first data; compare the second data with the first data, if the two belong to different object attributes, then Save the second data separately; compare the third data with the first data, if it is a different object attribute, compare it with the second data, if it is the same object attribute, then the third data and the second data.
  • the data is accumulated and saved, and so on, each data is compared to all of the saved data in front of it until all the data has been processed.
  • This kind of processing method needs to traverse each data in front of it. All the data that already exists, for a large amount of data, its statistical efficiency will be very low.
  • the data statistics method and system for the report provided by the embodiment of the present invention can improve the statistical efficiency of the memory data by using a statistical algorithm that is first sorted and then summarized.
  • Embodiment 1 is a diagrammatic representation of Embodiment 1:
  • FIG. 1 is a flowchart of a data statistics method for a report according to Embodiment 1 of the present invention.
  • the data statistics method of the report includes:
  • Step S101 Acquire report data information, where the report data information includes data corresponding to the object attribute and the object attribute;
  • the object attributes here represent various object attributes of the statistical items in the report, for example, each object includes multiple products, and the statistical items include document number, organization name, The organization code, product name, date, etc., can be customized by the user and then saved in the database.
  • the statistical item is a document number
  • the object attribute includes the specific document number, including RT00117012350001, RT00117012350001, and so on. In the reporting system, it is usually necessary to count all the data of the same object attribute, that is, all the data under the same object attribute is statistically calculated.
  • each data is stored separately, as shown in Table 1, with A, B, C, C, B, D, E object attributes and data corresponding to each object attribute 1, 2, 3, 4, 5, 6, and 7 are examples, showing the storage form of the data corresponding to the object attribute and the object attribute in the database.
  • Step S102 sorting the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is tightly arranged;
  • step S103 the data in the sequential data group is calculated to obtain a calculation result.
  • step S103 includes:
  • Step S1031 performing a summation calculation on the data in the sequential data group to obtain a summation result
  • Step S1032 performing averaging calculation on the data in the sequential data group to obtain an averaging result
  • step S1033 the data in the sequential data group is calculated to obtain the most value result.
  • step S1031 includes repeatedly performing the following processing until all data of the sequential data group is traversed:
  • the A, B, C, C, B, D, and E object attributes are taken as an example, and the corresponding data is 1, 2, 5, 3, 4, 6, and 7.
  • the above data is sorted by object attributes, and then statistical calculations are performed. Specific steps are as follows:
  • the embodiment does not need to traverse each of the previously existing group entries, thereby eliminating the process of matching calculation and improving the calculation efficiency. Especially when the amount of data is large, the efficiency is improved significantly.
  • the averaging calculation and the calculation of the maximum value of the data in the sequential data group are similar to the above-mentioned summation calculation, that is, averaging or maximizing all the data with the same object attribute, wherein, Find the maximum value including the maximum value and the minimum value. You can compare the adjacent data of the sequential data group. If they belong to the same object attribute, compare the size and finally get the maximum or minimum value of all the data with the same object attribute. I will not repeat them here.
  • the object attribute is a plurality of object attributes in the statistical item of the report.
  • Embodiment 2 is a diagrammatic representation of Embodiment 1:
  • FIG. 3 is a schematic structural diagram of a data statistics system of a report according to Embodiment 1 of the present invention.
  • the data statistics system of the report includes:
  • the obtaining unit 10 is configured to obtain memory data information of the report, where the memory data information includes an object attribute and corresponding data;
  • the sorting unit 20 is configured to sort the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged;
  • the calculating unit 30 is configured to calculate data in the sequential data group to obtain a calculation result.
  • the computing unit 30 includes:
  • a summation unit 31 configured to perform a summation calculation on the data in the sequential data group to obtain a summation result
  • the averaging unit 32 is configured to perform averaging calculation on the data in the sequential data group to obtain an averaging result
  • the most value unit 33 is configured to perform the most value calculation on the data in the sequential data group to obtain the most valued result.
  • the sequential data group includes first data and second data.
  • the summation unit 31 includes:
  • the comparing unit 310 is configured to save the first data, and compare the second data with the first data to obtain a comparison result;
  • the accumulating unit 311 is configured to add the first data and the second data to obtain the third data if the comparison result is belonging to the same object attribute;
  • the saving unit 312 is configured to separately save the second data if the comparison result is belonging to different object attributes.
  • the object attribute is a plurality of object attributes in the statistical item of the report.
  • the data statistics system of the report provided by the embodiment of the present invention has the same technical features as the data statistics method of the report provided by the foregoing embodiment, so that the same technical problem can be solved and the same technical effect can be achieved.
  • the present invention provides a data statistics method and system for a report, the method comprising: obtaining report data information, the report data information including data corresponding to an object attribute and an object attribute; and sorting data corresponding to the object attribute according to the object attribute, obtaining a sequence A data group in which data having the same object attribute is closely arranged; the data in the sequential data group is calculated to obtain a calculation result.
  • the statistical efficiency of memory data can be improved by using a statistical algorithm that sorts and then generalizes.
  • the computer program product provided by the embodiment of the present invention includes a computer readable storage medium storing the program code, and the program code includes instructions for executing the method described in the foregoing method embodiment.
  • the program code includes instructions for executing the method described in the foregoing method embodiment.
  • the specific implementation refer to the method embodiment. , will not repeat them here.
  • the terms “installation”, “connected”, and “connected” are to be understood broadly, and may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined. , or connected integrally; may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements.
  • installation may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined.
  • connected integrally may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements.
  • the specific meaning of the above terms in the present invention can be understood in a specific case by those skilled in the art.
  • the functions may be stored in a computer readable storage medium if implemented in the form of a software functional unit and sold or used as a standalone product. Based on such understanding, the technical solution of the present invention may contribute to the prior art or part of the technical solution. Illustrated in the form of a software product stored in a storage medium, comprising instructions for causing a computer device (which may be a personal computer, server, or network device, etc.) to perform the embodiments of the present invention All or part of the steps of the method.
  • the foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and the like. .

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Fuzzy Systems (AREA)
  • Complex Calculations (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention concerne un procédé et un système de statistiques de données pour des formulaires de rapport et se rapporte au domaine technique des formulaires de rapport. Le procédé comprend les étapes suivantes consistant à : obtenir des informations de données de formulaire de rapport, les informations de données de formulaire de rapport comprenant des propriétés d'objet et des données correspondantes des propriétés d'objet (S101) ; séquencer les données correspondant aux propriétés d'objet selon les propriétés d'objet pour obtenir un ensemble de données séquentielles, les données de la même propriété d'objet étant disposées les unes à côté des autres (S102) ; et calculer les données dans l'ensemble de données séquentielles pour obtenir un résultat de calcul (S103). Selon l'invention, un algorithme statistique de séquençage d'abord puis de généralisation est utilisé pour augmenter l'efficacité statistique des données de mémoire.
PCT/CN2017/080129 2017-03-10 2017-04-11 Procédé et système de statistiques de données pour formulaires de rapport Ceased WO2018161403A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710145193.3 2017-03-10
CN201710145193.3A CN106919712A (zh) 2017-03-10 2017-03-10 报表的数据统计方法和系统

Publications (1)

Publication Number Publication Date
WO2018161403A1 true WO2018161403A1 (fr) 2018-09-13

Family

ID=59461256

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/080129 Ceased WO2018161403A1 (fr) 2017-03-10 2017-04-11 Procédé et système de statistiques de données pour formulaires de rapport

Country Status (2)

Country Link
CN (1) CN106919712A (fr)
WO (1) WO2018161403A1 (fr)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109542947B (zh) * 2018-10-29 2020-12-29 金蝶软件（中国）有限公司 数据统计方法、装置、计算机设备和存储介质
CN110427599A (zh) * 2019-06-06 2019-11-08 北京辰森世纪科技股份有限公司 报表小计的统计方法及装置、存储介质、电子装置
CN114462365A (zh) * 2021-12-27 2022-05-10 奇安信科技集团股份有限公司 报表生成方法、装置、设备、存储介质和程序产品

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101963970A (zh) * 2010-01-12 2011-02-02 浪潮(山东)电子信息有限公司 一种高效率低维护的数据统计方法
CN102360371A (zh) * 2011-09-29 2012-02-22 畅捷通信息技术股份有限公司 数据处理装置和数据处理方法
CN103020150A (zh) * 2011-11-22 2013-04-03 微软公司 多维分组运算符
CN103365909A (zh) * 2012-04-09 2013-10-23 江南大学 一种数据表中依次逐一生成累加值的方法

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101963970A (zh) * 2010-01-12 2011-02-02 浪潮(山东)电子信息有限公司 一种高效率低维护的数据统计方法
CN102360371A (zh) * 2011-09-29 2012-02-22 畅捷通信息技术股份有限公司 数据处理装置和数据处理方法
CN103020150A (zh) * 2011-11-22 2013-04-03 微软公司 多维分组运算符
CN103365909A (zh) * 2012-04-09 2013-10-23 江南大学 一种数据表中依次逐一生成累加值的方法

Also Published As

Publication number Publication date
CN106919712A (zh) 2017-07-04

Similar Documents

Publication Publication Date Title
US10936765B2 (en) Graph centrality calculation method and apparatus, and storage medium
US11416456B2 (en) Method, apparatus, and computer program product for data quality analysis
US10103942B2 (en) Computer processing method and system for network data
EP2811441A1 (fr) Système et procédé de détection de pourriel au moyen de regroupement et de classement de courriers électroniques
CN111625561B (zh) 一种数据查询方法及装置
WO2018036549A1 (fr) Procédé et dispositif d'interrogation de base de données distribuée, et système de gestion
US10810458B2 (en) Incremental automatic update of ranked neighbor lists based on k-th nearest neighbors
CN108415964A (zh) 数据表查询方法、装置、终端设备及存储介质
CN113051308A (zh) 告警信息处理方法、设备、存储介质及装置
CN110300011B (zh) 一种告警根因定位方法、装置和计算机可读存储介质
US11144793B2 (en) Incremental clustering of a data stream via an orthogonal transform based indexing
WO2018161403A1 (fr) Procédé et système de statistiques de données pour formulaires de rapport
CN103902592A (zh) 基于MapReduce实现分析函数的方法及系统
CN111507479A (zh) 特征分箱方法、装置、设备及计算机可读存储介质
CN118643444A (zh) 大数据异常检测方法、装置、设备、存储介质及产品
CN108664492B (zh) 一种向用户推送内容的方法、装置、电子设备和存储介质
CN114090407B (zh) 基于线性回归模型的接口性能预警方法及其相关设备
CN110019152A (zh) 一种大数据清洗方法
CN107562762A (zh) 数据索引构建方法及装置
CN105068879B (zh) 一种查找目标订阅的方法及装置
CN104699747B (zh) 一种基于高维数据过滤器的近似成员查询方法
CN105808611B (zh) 数据挖掘方法和装置
CN108255704B (zh) 一种脚本调用事件的异常响应方法及其终端
CN107248929B (zh) 一种多维关联数据的强关联数据生成方法
WO2019153546A1 (fr) Procédé, appareil et dispositif de génération de données de dimension de dix-mille niveaux, et support de stockage

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17899396

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 17899396

Country of ref document: EP

Kind code of ref document: A1