TW201510720A - A method of data statistics and a device thereof - Google Patents

A method of data statistics and a device thereof Download PDF

Info

Publication number
TW201510720A
TW201510720A TW103125519A TW103125519A TW201510720A TW 201510720 A TW201510720 A TW 201510720A TW 103125519 A TW103125519 A TW 103125519A TW 103125519 A TW103125519 A TW 103125519A TW 201510720 A TW201510720 A TW 201510720A
Authority
TW
Taiwan
Prior art keywords
data
maintenance
user
unit
data table
Prior art date
Application number
TW103125519A
Other languages
Chinese (zh)
Inventor
Jin-Chi Pan
zhi-bo Cai
Original Assignee
Tencent Tech Shenzhen 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 Tencent Tech Shenzhen Co Ltd filed Critical Tencent Tech Shenzhen Co Ltd
Publication of TW201510720A publication Critical patent/TW201510720A/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • Strategic Management (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Game Theory and Decision Science (AREA)
  • Software Systems (AREA)
  • Educational Administration (AREA)
  • Development Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Debugging And Monitoring (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides a method of data statistics and a device thereof. The method includes the following: acquiring use-and-maintenance data and a data sheet of a software product, reminding a user to define texts/part of texts of the data sheet based on the use-and-maintenance data, defining the texts/part of texts of the data sheet based on the defining information inputted by the user, saving the use-and-maintenance data on the defined data sheet, and performing a statistics process on the saved use-and-maintenance data.

Description

數據統計方法和裝置 Data statistics method and device

本發明是有關一種數據處理領域,尤其是有關於一種數據統計方法和裝置。 The present invention relates to the field of data processing, and more particularly to a data statistics method and apparatus.

一個完整的軟體生命週期,運行與維護(運維)階段是必不可少的,也是持續時間最長的一個階段。在軟體產品開發完成並成功推出市場之後,都將進入到產品的運維階段,會有專業團隊關注各產品的各項指標,收集用戶回饋意見,根據指標和意見為產品的下一步調整做準備。 A complete software life cycle, operation and maintenance (operation and maintenance) phase is essential and the longest duration. After the software product development is completed and the market is successfully launched, it will enter the operation and maintenance stage of the product. There will be a professional team paying attention to the indicators of each product, collecting feedback from users, and preparing for the next adjustment of the product based on indicators and opinions. .

產品指標收集有很多渠道和方式,根據指標類型的不同而選擇不同的方式,例如可以透過用戶操作產生數據的上傳,從而獲取用戶使用功能記錄;或透過自動化運行測試,獲取軟體的性能數據等等。這類數據在收集之後,都將統一上傳到數據伺服器,由運維團隊相關人員提取所需的數據,用於對用戶使用場景和習慣進行調查研究,對產品功能做改進或刪減,或者優化軟體性能。 There are many channels and methods for product metrics collection. Different methods can be selected according to different types of indicators. For example, data upload can be generated through user operations to obtain user function records. Or, by running tests automatically, obtaining software performance data, etc. . After the data is collected, it will be uploaded to the data server in a unified manner. Relevant personnel of the operation and maintenance team will extract the required data, and use it to investigate and study the user's usage scenarios and habits, and improve or delete the product functions, or Optimize software performance.

數據伺服器上儲存的都是數字類型的數據,而這類數據並不是特別的直觀,運維團隊需要對這部分數據進行報表、圖形展示,直觀的瞭解到數據的趨勢或分佈,部分敏感數據超過閾值時需要緊急應對,營運人員需要發送日報或週報,將統計數據以郵件的方式知會到相關人員並做歸檔。以上工作不僅操作耗時,而且重複性高,人工操作極易出現疏漏。 以此為基礎,出現了各式各樣的數據統計平台,將用戶上傳的數據以web化方式展示出來,不僅可以實現圖形化的展示,而且可以定制警訊或週報等功能。 The data server stores all types of data, and the data is not particularly intuitive. The operation and maintenance team needs to report and display the data in this part of the data, and intuitively understand the trend or distribution of the data, and some sensitive data. When the threshold is exceeded, an emergency response is required. The operator needs to send a daily or weekly report, and the statistical data is notified to the relevant personnel by the mail and archived. The above work is not only time-consuming, but also highly reproducible, and manual operations are prone to omissions. Based on this, a variety of data statistics platforms have emerged, and the user-uploaded data is displayed in a web-based manner, which not only enables graphical display, but also can customize functions such as warnings or weekly reports.

發明人發現,在習知技術中的數據統計平台雖然有很多,但通用性比較差,幾乎針對每個產品都會有單獨的一個平台,甚至對同一個產品的不同數據指標都有不同的業務來執行,究其原因主要有以下三點。 The inventors have found that although there are many data statistics platforms in the prior art, the versatility is relatively poor, and there is a separate platform for almost every product, and even different services for different data indicators of the same product. Execution, the reasons are mainly the following three points.

首先,不同產品或是同一個產品的不同指標,上傳的數據千差萬別。字段名不同,字段類型不同,甚至連上傳上來的字段個數也不一樣。因此針對某個指標的展示和繪製邏輯,無法套用到另外一個指標上。 First of all, different products or different indicators of the same product, the uploaded data varies widely. The field names are different, the field types are different, and even the number of fields uploaded is different. Therefore, the display and drawing logic for an indicator cannot be applied to another indicator.

再者,不同產品/指標的啟用功能不同,有的需要針對某些字段值設置閾值,有的需要針對某些字段值設置展示趨勢圖或分佈圖。而由於數據字段不一致,這些也無法直接套用。 Furthermore, different product/metrics have different enabling functions, some need to set thresholds for certain field values, and some need to set trending charts or profiles for certain field values. And because the data fields are inconsistent, these can't be applied directly.

最後,每個產品/指標都需要有自動化報表郵件功能,但由於各產品/指標的字段不一致,無法統一報表郵件格式。 Finally, each product/indicator requires an automated report mail function, but because the fields of each product/metric are inconsistent, the report mail format cannot be unified.

基於以上原因,以往每次需要增加新的產品/指標模型時,我們需要對數據統計平台進行維護,增加該模型的展示、警訊、圖標和郵件功能。但隨著產品的增多以及產品功能的完善,營運階段需要關注的統計數據會不斷增加,針對每個單獨的統計數據都在代碼上進行累加,這是非常低效和不現實的。 For the above reasons, in the past, when we need to add a new product/indicator model, we need to maintain the data statistics platform and increase the display, warning, icon and mail functions of the model. However, with the increase of products and the improvement of product functions, the statistical data that needs to be paid attention to during the operation phase will continue to increase, and each individual statistical data is accumulated on the code, which is very inefficient and unrealistic.

有鑑於此,如何改善習知技術中的數據統計平台通用性比較差的問題,係本案所發展之重點。 In view of this, how to improve the versatility of the data statistics platform in the prior art is the focus of the development of this case.

本發明實施例之一目的在於提供一種數據統計方法和裝置,以解決現有技術中現有技術中的數據統計平台通用性比較差的問題。 An object of the present invention is to provide a data statistics method and apparatus to solve the problem of poor versatility of the data statistics platform in the prior art in the prior art.

為了實現上述目的,根據本發明實施例的一個方面,提供了 一種數據統計方法。方法包括:獲取軟體產品的運維數據和數據表;根據用戶輸入的定義信息對數據表的字段進行定義;在定義後的數據表中儲存運維數據;以及基於儲存的運維數據進行數據統計。 In order to achieve the above object, according to an aspect of an embodiment of the present invention, A method of statistical data. The method comprises: obtaining operation and maintenance data and a data table of the software product; defining a field of the data table according to the definition information input by the user; storing the operation and maintenance data in the defined data table; and performing data statistics based on the stored operation and maintenance data .

為了實現上述目的,根據本發明實施例的另一方面,提供了一種數據統計裝置。裝置包括:獲取單元,用於獲取軟體產品的運維數據和數據表;定義單元,用於根據用戶輸入的定義信息對數據表的字段進行定義;儲存單元,用於在定義後的數據表中儲存運維數據;以及統計單元,用於統計儲存的運維數據。 In order to achieve the above object, according to another aspect of an embodiment of the present invention, a data statistical device is provided. The device includes: an obtaining unit, configured to acquire operation and maintenance data and a data table of the software product; a defining unit, configured to define a field of the data table according to the definition information input by the user; and a storage unit, configured in the defined data table The operation and maintenance data is stored; and the statistical unit is used for statistically storing the operation and maintenance data.

透過本發明實施例,由於可以獲取的軟體產品的運維數據對數據表進行定義,並在定義後的數據表中儲存運維數據,因而使得數據表能夠儲存多種不同的運維數據,解決了現有技術中的數據統計平台通用性比較差的問題,進而提高了數據統計平台的通用性。 Through the embodiment of the present invention, the data table is defined by the operation and maintenance data of the software product that can be obtained, and the operation and maintenance data is stored in the defined data table, so that the data table can store a plurality of different operation and maintenance data, and the solution is solved. The problem of poor versatility of the data statistics platform in the prior art further improves the versatility of the data statistics platform.

10‧‧‧獲取單元 10‧‧‧Acquisition unit

101‧‧‧判斷模組 101‧‧‧Judgement module

102‧‧‧獲取模組 102‧‧‧Get Module

103‧‧‧創建模組 103‧‧‧Create module

11‧‧‧數據獲取單元 11‧‧‧Data acquisition unit

12‧‧‧接收單元 12‧‧‧ Receiving unit

20‧‧‧提示單元 20‧‧‧Cue unit

21‧‧‧格式設置單元 21‧‧‧Format unit

22‧‧‧關聯單元 22‧‧‧Association unit

30‧‧‧定義單元 30‧‧‧Definition unit

31‧‧‧第一展示單元 31‧‧‧First display unit

32‧‧‧第二展示單元 32‧‧‧Second display unit

40‧‧‧儲存單元 40‧‧‧ storage unit

42‧‧‧閾值單元 42‧‧‧threshold unit

50‧‧‧統計單元 50‧‧‧Statistics unit

501‧‧‧計算模組 501‧‧‧Computation Module

502‧‧‧統計模組 502‧‧‧Statistical Module

52‧‧‧判斷單元 52‧‧‧judging unit

60‧‧‧匯總單元 60‧‧‧summary unit

62‧‧‧警訊單元 62‧‧‧Alarm unit

S101-S105‧‧‧本發明第一實施例的數據統計方法的流程步驟 S101-S105‧‧‧ flow steps of the data statistical method of the first embodiment of the present invention

S1011-S1013‧‧‧本發明實施例的獲取數據表方法的流程步驟 S1011-S1013‧‧‧ Process steps of the method for obtaining a data table in the embodiment of the present invention

S201-S208‧‧‧本發明第二實施例的數據統計方法的流程步驟 S201-S208‧‧‧ Flowchart of the data statistical method of the second embodiment of the present invention

S301-S308‧‧‧本發明第三實施例的在數據統計方法的流程步驟 S301-S308‧‧ The flow steps of the data statistical method of the third embodiment of the present invention

S401-S408‧‧‧本發明第四實施例的在數據統計方法的流程步驟 S401-S408‧‧ The flow steps of the data statistics method of the fourth embodiment of the present invention

構成本申請的一部分的附圖用來提供對本發明的進一步理解,本發明的示意性實施例及其說明用於解釋本發明,並不構成對本發明的不當限定。在附圖中:圖1是根據本發明第一實施例的數據統計裝置的示意圖;圖2是根據本發明第二實施例的數據統計裝置的示意圖;圖3是根據本發明第三實施例的數據統計裝置的示意圖;圖4是根據本發明第四實施例的數據統計裝置的示意圖;圖5是根據本發明第五實施例的數據統計裝置的示意圖;圖6是根據本發明第六實施例的數據統計裝置的示意圖;圖7是根據本發明第七實施例的數據統計裝置的示意圖;圖8是根據本發明第一實施例的數據統計方法的流程圖; 圖9是根據本發明實施例的獲取數據表方法的流程圖;圖10是根據本發明第二實施例的數據統計方法的流程圖;圖11是根據本發明第三實施例的在數據統計方法的流程圖;以及圖12是根據本發明第四實施例的在數據統計方法的流程圖。 The accompanying drawings, which are incorporated in the claims 1 is a schematic diagram of a data statistical device according to a first embodiment of the present invention; FIG. 2 is a schematic diagram of a data statistical device according to a second embodiment of the present invention; and FIG. 3 is a third embodiment of the present invention. 4 is a schematic diagram of a data statistics apparatus according to a fourth embodiment of the present invention; FIG. 5 is a schematic diagram of a data statistics apparatus according to a fifth embodiment of the present invention; and FIG. 6 is a sixth embodiment of the present invention. FIG. 7 is a schematic diagram of a data statistics apparatus according to a seventh embodiment of the present invention; and FIG. 8 is a flowchart of a data statistics method according to the first embodiment of the present invention; 9 is a flowchart of a method for acquiring a data table according to an embodiment of the present invention; FIG. 10 is a flowchart of a data statistics method according to a second embodiment of the present invention; and FIG. 11 is a data statistical method according to a third embodiment of the present invention. Flowchart; and FIG. 12 is a flow chart of a method of statistical data according to a fourth embodiment of the present invention.

需要說明的是,在不衝突的情況下,本申請中的實施例及實施例中的特徵可以相互組合。下面將參考附圖並結合實施例來詳細說明本發明。 It should be noted that the embodiments in the present application and the features in the embodiments may be combined with each other without conflict. The invention will be described in detail below with reference to the drawings in conjunction with the embodiments.

為了使本技術領域的人員更好地理解本發明方案,下面將結合本發明實施例中的附圖,對本發明實施例中的技術方案進行清楚、完整地描述。基於本發明中的實施例,本領域普通技術人員在沒有做出創造性勞動前提下所獲得的所有其他實施例,都應當屬於本發明保護的範圍。 The technical solutions in the embodiments of the present invention are clearly and completely described in the following with reference to the accompanying drawings in the embodiments of the present invention. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts shall fall within the scope of the present invention.

需要說明的是,本發明的說明書和申請專利範圍及上述附圖中的術語“第一”、“第二”等是用於區別類似的對象,而不必用於描述特定的順序或先後次序。應該理解這樣使用的數據在適當情況下可以互換,以便這裡描述的本發明的實施例,例如能夠以除了在這裡圖示或描述的那些以外的順序實施。此外,術語“包括”和“具有”以及他們的任何變形,意圖在於覆蓋不排他的包含,例如,包含了一系列步驟或單元的過程、方法、系統、產品或設備不必限於清楚地列出的那些步驟或單元,而是可包括沒有清楚地列出的或對於這些過程、方法、產品或設備固有的其它步驟或單元。 It should be noted that the terms "first", "second" and the like in the specification and the claims of the present invention are used to distinguish similar objects, and are not necessarily used to describe a specific order or order. It is to be understood that the data so used may be interchanged as appropriate, such that the embodiments of the invention described herein can be implemented, for example, in a sequence other than those illustrated or described herein. In addition, the terms "comprises" and "comprises" and "the" and "the" are intended to cover a non-exclusive inclusion, for example, a process, method, system, product, or device that comprises a series of steps or units is not necessarily limited to Those steps or units may include other steps or units not explicitly listed or inherent to such processes, methods, products or devices.

本發明實施例提供了一種數據統計裝置。該數據統計裝置用於對軟體產品的運維數據進行統計。 The embodiment of the invention provides a data statistics device. The data statistics device is used to perform statistics on the operation and maintenance data of the software product.

圖1是根據本發明第一實施例的數據統計裝置的示意圖。如圖1所示,裝置可包括獲取單元10、提示單元20、定義單元30、儲存單元40和統計單元50。 1 is a schematic diagram of a data statistical device in accordance with a first embodiment of the present invention. As shown in FIG. 1, the apparatus may include an acquisition unit 10, a prompting unit 20, a definition unit 30, a storage unit 40, and a statistical unit 50.

獲取單元10可用於獲取軟體產品的運維數據和數據表。獲取的軟體產品可以為騰訊QQ、QQ音樂或者其他需要進行指標收集和統計的產品。獲取的運維數據可以為騰訊QQ的登錄時間、登錄失敗次數以及登錄頻率等與軟體性能有關的數據,還可以是QQ音樂的播放種類或者某一種類的播放次數等信息。數據表可以包含任意多個字段,可以包含一個產品的多個指標,也可以是多個產品的多個指標,還可以包含其他能夠對產品進行維護和分析的任意指標。在獲取軟體產品的運維數據和數據表之後,可以透過對運維數據和數據表進行分析,對用戶使用場景和習慣進行調查研究,對產品功能進行改進和刪減,或者優化軟體性能等。 The obtaining unit 10 can be used to obtain operation and maintenance data and a data table of the software product. The acquired software products can be Tencent QQ, QQ music or other products that need to collect and count indicators. The acquired operation and maintenance data may be data related to software performance such as login time, number of login failures, and login frequency of Tencent QQ, and may also be information such as the type of playback of QQ music or the number of times of playback of a certain type. A data table can contain any number of fields, can contain multiple metrics for a product, or multiple metrics for multiple products, and can include any metric that can be maintained and analyzed. After obtaining the operation and maintenance data and data tables of the software products, the operation and maintenance data and data tables can be analyzed to investigate the user's usage scenarios and habits, and the product functions can be improved and deleted, or the software performance can be optimized.

提示單元20可用於提示用戶基於運維數據對數據表的字段進行定義。基於運維數據對數據表的字段進行定義可以是基於運維數據中的任意一個或者任意多個指標對數據表的字段進行定義,提示單元20提示用戶根據產品分析的需要對數據表的字段進行定義。 The prompting unit 20 can be used to prompt the user to define the fields of the data table based on the operation and maintenance data. Defining the field of the data table based on the operation and maintenance data may be based on any one of the operation and maintenance data or any plurality of indicators to define a field of the data table, and the prompting unit 20 prompts the user to perform the field of the data table according to the needs of the product analysis. definition.

定義單元30可用於根據用戶輸入的定義信息對數據表的字段進行定義。對數據表的字段進行定義可以使對數據表的任意一個或者多個字段進行定義,對數據表的字段進行定義可以是將數據表的字段進行命名,比如,將數據表中field_1,field_2,field_3這3個字段分別命名為“數據1”,“數據2”,“數據3”。 The definition unit 30 can be used to define fields of the data table according to definition information input by the user. Defining the fields of the data table may define any one or more fields of the data table. The fields of the data table may be defined by naming the fields of the data table, for example, field_1, field_2, field_3 in the data table. These three fields are named "data 1", "data 2", and "data 3".

儲存單元40可用於在定義後的數據表中儲存運維數據。定義後的數據表中儲存的運維數據可以是儲存任意一個或者多個產品指標對應的數據,定義後的數據表可以是針對任一產品的任意一個或者多個指標進行定制的數據表。該數據表中可以包含需要進行數據分析或統計的字段名稱或者數據。 The storage unit 40 can be used to store the operation and maintenance data in the defined data table. The operation and maintenance data stored in the defined data table may be data corresponding to any one or more product indicators, and the defined data table may be a data table customized for any one or more indicators of any product. The data table can contain field names or data that require data analysis or statistics.

統計單元50可用於統計儲存的運維數據。數據統計可以是對產品指標的全部數據或者部分數據進行篩選和排序,還可以對全部數據或者部分數據進行報表、圖形展示,還可以進行數據二次運算、數據格式 設置、閾值警訊、圖形展示和自動化報告等。對運維數據進行統計可以對上述功能中的任意一個或者多個進行數據統計,可以根據運維數據自身的實際需要進行選擇。 The statistical unit 50 can be used to count the stored operational data. Data statistics can be to filter and sort all or part of the product indicators, and can also report or graphically display all or part of the data, and can also perform data secondary operations and data formats. Settings, threshold alerts, graphical displays, and automated reports. Statistics on operation and maintenance data can be used to perform statistics on any one or more of the above functions, and can be selected according to the actual needs of the operation and maintenance data itself.

數據二次運算:可以是進行簡單的數學運算,計算總和、差額、比例等數據,例如:字段“數據3的比例”,值為“數據3/(數據3+數據1)* 100”,後臺會將field_3和field_1的值取出後,計算field_3/(field_1+field3)* 100的值。 Data secondary operation: It can be a simple mathematical operation, calculate the sum, difference, proportion and other data, for example: the field "proportion of data 3", the value is "data 3 / (data 3 + data 1) * 100", background After the values of field_3 and field_1 are taken out, the value of field_3/(field_1+field3)*100 is calculated.

數據格式設置:可以是對各個字段的數據設置單獨的格式,例如添加前後綴,小數點精確位數等。可以方便的為數值設置單位,或統一數據樣式。例如“數據3的比例”,可以設置保留2位小數,並添加%符號表示其為百分比。 Data format setting: You can set a separate format for the data of each field, such as adding suffixes, precise digits of the decimal point, and so on. It is convenient to set units for values or to harmonize data styles. For example, "Scale of Data 3", you can set to keep 2 decimal places and add % symbol to indicate it is a percentage.

閾值警訊:可以使針對所有字段設置閾值,當任何一條的數據超過或小於閾值時,會向該用戶或配置的負責人進行警訊,提醒相關人員關注敏感數據。接上例,可設置當“數據3的比例”超過50%後觸發警訊,通知負責人檢查數據和數據異常原因。 Threshold Alert: You can set a threshold for all fields. When any one of the data exceeds or is less than the threshold, the user or the configured person in charge will be alerted to alert the relevant personnel to the sensitive data. In the example above, it can be set to trigger a warning when the “ratio of data 3” exceeds 50%, and notify the person in charge to check the data and the cause of the data abnormality.

圖形展示:用戶可選擇將指標中的某個字段或某幾個字段生成圖形,提供直觀的圖形數據展示。例如,可設置“數據3”的折線圖,判斷“數據3”在近一段時間內的走勢情況,查看是否有出現突增或突降;可設置“數據3”和“數據1”的餅狀圖,查看某日或某段時間內“數據3”和“數據1”的各自匯總及比例。 Graphical display: Users can choose to generate a graphic or a few fields in the indicator to provide an intuitive graphical data display. For example, you can set the line graph of “Data 3” to judge the trend of “Data 3” in the near future, and check whether there is a sudden increase or a sudden drop; you can set the pie shape of “Data 3” and “Data 1”. Figure, to view the respective summary and proportion of “Data 3” and “Data 1” on a certain day or a certain period of time.

自動化報告:用戶可定義接收某個指標或多個指標的數據,平台可以將每日各指標數據的表格和圖形展示以郵件形式匯總給用戶,也可以將每個月的數據匯總,計算總和及平均值後發送給用戶,同時平台還可以做郵件的存檔,方便用戶查詢歷史的報告記錄。 Automated reporting: Users can define data for receiving a certain indicator or multiple indicators. The platform can summarize the daily table and graphic display of each indicator data by email to the user, or aggregate the data of each month to calculate the sum and After the average value is sent to the user, the platform can also archive the mail, which is convenient for the user to query the historical report record.

透過上述的一種或多種方法能夠實現對不同產品/指標進行數據統計的功能,能夠滿足數據統計的特性化及良好體驗。 Through the above one or more methods, the function of data statistics for different products/indicators can be realized, and the characteristics and good experience of data statistics can be satisfied.

需要說明的是,在本發明實施例的數據統計裝置中也可以不包括提示單元20,這樣,獲取單元10在獲取軟體產品的運維數據和數據表之後,定義單元30可以直接根據用戶輸入的定義信息對數據表的字段進行定義。 It should be noted that, in the data statistics apparatus of the embodiment of the present invention, the prompting unit 20 may not be included. After the obtaining unit 10 obtains the operation and maintenance data and the data table of the software product, the defining unit 30 may directly input according to the user. The definition information defines the fields of the data table.

以下對本發明的數據統計裝置進行介紹,以下實施例的數據統計裝置可以作為圖1所示實施例的數據統計裝置的實施方式。 The data statistical device of the present invention will be described below. The data statistical device of the following embodiment can be used as an embodiment of the data statistical device of the embodiment shown in FIG.

圖2是根據本發明第二實施例的數據統計裝置的示意圖。如圖所示,該數據統計裝置包括獲取單元10、提示單元20、定義單元30、儲存單元40和統計單元50,其中,獲取單元10可包括:判斷模組101、獲取模組102和創建模組103。其中,圖中的提示單元20、定義單元30、儲存單元40和統計單元50與圖1所示的提示單元20、定義單元30、儲存單元40和統計單元50功能相同,在此不做贅述。 2 is a schematic diagram of a data statistics apparatus in accordance with a second embodiment of the present invention. As shown in the figure, the data statistics device includes an obtaining unit 10, a prompting unit 20, a defining unit 30, a storage unit 40, and a statistical unit 50. The obtaining unit 10 may include: a determining module 101, an obtaining module 102, and a creating module. Group 103. The prompting unit 20, the defining unit 30, the storing unit 40, and the statistic unit 50 in the figure have the same functions as the prompting unit 20, the defining unit 30, the storage unit 40, and the statistic unit 50 shown in FIG. 1, and details are not described herein.

判斷模組101可用於判斷數據伺服器中是否存在數據表。數據表可以是包含任意字段名和任意字段類型的數據表,數據表中存在著任意類型的運維數據。一個數據表中存放一種類型的運維數據。判斷數據伺服器中是否存在數據表可以是判斷數據伺服器中是否存在可供用戶分析數據使用的數據表,例如,能夠分析騰訊QQ登錄失敗次數的數據表。數據伺服器可以用來儲存軟體產品源頭直接上傳的數據,也可以是透過人工或者程式預處理後的定期提交的匯總數據,處理儲存數據,數據伺服器還可以儲存數據表。 The determining module 101 can be used to determine whether a data table exists in the data server. The data table can be a data table containing any field name and any field type, and any type of operation and maintenance data exists in the data table. A type of operation and maintenance data is stored in a data table. Determining whether the data table exists in the data server may be determining whether there is a data table available for the user to analyze the data in the data server, for example, a data table capable of analyzing the number of failures of the Tencent QQ login. The data server can be used to store the data directly uploaded by the source of the software product, or it can be a summary data that is periodically submitted through manual or program preprocessing, and the data server can also store the data table.

獲取模組102可用於在判斷數據伺服器中存在數據表之後,根據用戶的選定獲取數據伺服器中存在的數據表。在判斷確定數據伺服器中存在數據表之後,根據用戶選定的任一類型的運維數據或者數據表來獲取數據伺服器中存在的數據表。獲取的數據表可以是用來統計例如QQ音樂的軟體性能或者QQ音樂軟體的用戶使用習慣,還可以是用來統計其他可以對用戶使用或者產品性能進行衡量的數據。 The obtaining module 102 can be configured to obtain a data table existing in the data server according to the user's selection after determining that the data table exists in the data server. After determining that the data table exists in the data server, the data table existing in the data server is obtained according to any type of operation data or data table selected by the user. The obtained data table may be used to count the software performance of, for example, QQ music or the user usage habit of the QQ music software, and may also be used to count other data that can be used for measuring user performance or product performance.

創建模組103可用於在判斷數據伺服器中不存在數據表之後,接收用戶輸入的數據表請求信息和定義信息,並根據定義信息在數據伺服器創建數據表。在判斷確定數據伺服器中不存在數據表之後,創建模組103接收用戶輸入的數據表請求信息和定義信息,根據定義信息在數據伺服器創建數據表,創建的數據表可以按照用戶需要的格式創建數據表的表名和字段,創建的數據表儲存於數據伺服器上。有軟體數據需要接入時,可以直接將數據放入到該數據表中。 The creating module 103 can be configured to receive the data table request information and the definition information input by the user after determining that the data table does not exist in the data server, and create a data table in the data server according to the definition information. After determining that the data table does not exist in the data server, the creation module 103 receives the data table request information and the definition information input by the user, and creates a data table in the data server according to the definition information, and the created data table can be in a format required by the user. Create the table name and field of the data table, and the created data table is stored on the data server. When there is software data to access, you can directly put the data into the data table.

圖3是根據本發明第三實施例的數據統計裝置的示意圖。如圖所示,裝置包括獲取單元10中的判斷模組101、獲取模組102和創建模組103、提示單元20、定義單元30、儲存單元40、統計單元50以及匯總單元60。其中,提示單元20、定義單元30、儲存單元40與圖1所示的獲取單元10、提示單元20、定義單元30、儲存單元40的功能相同,判斷模組101、獲取模組102和創建模組103與圖2所示的判斷模組101、獲取模組102和創建模組103功能相同,在此均不做贅述。 Figure 3 is a schematic diagram of a data statistics apparatus in accordance with a third embodiment of the present invention. As shown in the figure, the device includes a determination module 101, an acquisition module 102 and a creation module 103, a prompting unit 20, a definition unit 30, a storage unit 40, a statistics unit 50, and a summary unit 60 in the acquisition unit 10. The prompting unit 20, the defining unit 30, and the storing unit 40 have the same functions as the obtaining unit 10, the prompting unit 20, the defining unit 30, and the storage unit 40 shown in FIG. 1, and the determining module 101, the obtaining module 102, and the creating module The group 103 has the same functions as the determination module 101, the acquisition module 102, and the creation module 103 shown in FIG. 2, and details are not described herein.

匯總單元60可用於在獲取數據表之後,將運維數據匯總至數據伺服器中,其中,同一指標對應的運維數據對應的數據儲存模型相同,並且同一指標對應的運維數據儲存在同一個數據表中。將運維數據匯總至數據伺服器中可以是將源頭的運維數據直接匯總至數據伺服器,也可以是將透過人工或程式處理後的運維數據匯總至數據伺服器。其中,同一指標對應的運維數據對應的數據儲存模型相同,例如:QQ聊天的登錄時間對應的運維數據對應的數據儲存模型包括“登錄時間”、“登錄地點”。那麼,所有QQ聊天的登錄時間對應的運維數據對應的數據儲存模型都相同,包括“登錄時間”、“登錄地點”。同一指標對應的運維數據儲存在同一個數據表中,例如,所有QQ的登錄時間對應的運維數據都儲存在同一個數據表中。 The summary unit 60 is configured to summarize the operation and maintenance data into the data server after the data table is obtained, wherein the operation data corresponding to the operation data corresponding to the same indicator is the same, and the operation and maintenance data corresponding to the same indicator is stored in the same In the data sheet. The operation and maintenance data may be summarized into the data server, or the operation and maintenance data of the source may be directly aggregated to the data server, or the operation and maintenance data processed by the manual or the program may be summarized into the data server. The data storage model corresponding to the operation and maintenance data corresponding to the same indicator is the same. For example, the data storage model corresponding to the operation and maintenance data corresponding to the login time of the QQ chat includes “login time” and “login location”. Then, the data storage model corresponding to the operation and maintenance data corresponding to the login time of all QQ chats is the same, including "login time" and "login location". The operation and maintenance data corresponding to the same indicator is stored in the same data table. For example, the operation and maintenance data corresponding to the login time of all QQs are stored in the same data table.

由於同一指標對應的運維數據對應的數據儲存模型相同,因此,基於此模型對同一指標進行的數據展示以及繪製的趨勢圖或者分佈圖 的格式相同,能夠統一報表格式,便於分析和查看。 Since the data storage model corresponding to the operation and maintenance data corresponding to the same indicator is the same, the data display and the trending or distribution map of the same indicator based on the model are displayed. The format is the same, and the report format can be unified for analysis and viewing.

統計單元50用於基於儲存的運維數據進行數據統計包括:接收用戶輸入並確定用戶選擇的數據表,將數據伺服器中儲存的與用戶選擇的數據表對應的運維數據接入用戶數據平台,在數據平台上對接入的運維數據進行數據統計。 The statistics unit 50 is configured to perform data statistics based on the stored operation and maintenance data, including: receiving user input and determining a data table selected by the user, and accessing operation and maintenance data corresponding to the data table selected by the user stored in the data server to the user data platform. Data statistics are performed on the access operation and maintenance data on the data platform.

數據平台是各類產品在發佈營運時,均會有一系列的上傳數據,用於監控產品的安全性、穩定性及用戶使用情況等,數據平台就是將這類數據收集匯總並統一展示的web平台,透過提供多樣的表格和圖形化展示,能直觀的瞭解到各類營運數據的趨勢和分佈,為產品的調整提供數據依據。 The data platform is a series of uploading data for all kinds of products during the release operation, which is used to monitor the security, stability and user usage of the products. The data platform is a web platform that collects and unifies such data collection. By providing a variety of forms and graphical displays, we can intuitively understand the trend and distribution of various operational data, and provide data basis for product adjustment.

統計單元可以接受用戶輸入的數據,根據用戶輸入的數據選擇數據表,將從數據伺服器中選擇的數據表接入用戶數據平台。接入用戶數據平台可以是將數據填充到用戶數據平台,也可以是將用戶數據平台與數據一一對應,還可以是其他可以將數據與用戶數據平台相關聯的方法。數據平台可以對數據的所有或者部分進行展示,可以對數據進行篩選和排序,還可以進行數據二次運算、數據格式設置、閾值警訊、圖形展示和自動化報告等。對運維數據進行數據統計可以是透過數據平台實現上述功能中的任意一個或者多個,可以根據用戶的實際需要進行選擇。需要說明的是,這裡所列舉的數據平台是為了方便理解本發明實施例的技術方案,該數據平台可以根據用戶需要,實現其他例如用於分析用戶使用習慣或者產品性能的功能。 The statistical unit can accept the data input by the user, select the data table according to the data input by the user, and access the data table selected from the data server to the user data platform. The access user data platform may be populating data to the user data platform, or may be a one-to-one correspondence between the user data platform and the data, or may be another method that can associate the data with the user data platform. The data platform can display all or part of the data, filter and sort the data, and perform data secondary operations, data format settings, threshold alerts, graphical displays, and automated reports. The data statistics of the operation and maintenance data may be implemented by using any one or more of the above functions through the data platform, and may be selected according to actual needs of the user. It should be noted that the data platform listed herein is for facilitating understanding of the technical solution of the embodiment of the present invention, and the data platform can implement other functions, such as for analyzing user usage habits or product performance, according to user needs.

圖4是根據本發明第四實施例的數據統計裝置的示意圖。如圖所示,數據統計裝置包括獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50,該統計單元50包括計算模組501和統計模組502。本發明實施例中的獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50與圖1所示獲取單元10、提示單元20、定義單元30、儲存單 元40、統計單元50的功能相同,在此不做贅述。 4 is a schematic diagram of a data statistics apparatus in accordance with a fourth embodiment of the present invention. As shown in the figure, the data statistics device includes an obtaining unit 10, a prompting unit 20, a defining unit 30, a storage unit 40, and a statistical unit 50. The statistical unit 50 includes a computing module 501 and a statistical module 502. The obtaining unit 10, the prompting unit 20, the defining unit 30, the storing unit 40, the statistic unit 50, and the obtaining unit 10, the prompting unit 20, the defining unit 30, and the storage list in the embodiment of the present invention The functions of the element 40 and the statistic unit 50 are the same and will not be described here.

計算模組501用於對儲存的運維數據進行數據二次計算。對儲存的運維數據進行數據二次運算可以是將關聯的字段進行簡單的數學運算,例如計算總和、差額、比例等數據。例如:字段“數據3的比例”,值為“數據3/(數據3+數據1)* 100”,後臺會將field_3和field_1的值取出後,計算field_3/(field_1+field3)* 100的值。 The calculation module 501 is configured to perform secondary data calculation on the stored operation and maintenance data. The data secondary operation on the stored operation and maintenance data may be a simple mathematical operation of the associated fields, such as calculating the sum, the difference, the ratio, and the like. For example: the field "proportion of data 3", the value is "data 3 / (data 3 + data 1) * 100", the background will take the value of field_3 and field_1, calculate the value of field_3 / (field_1 + field3) * 100 .

統計模組502用於對二次計算後的數據進行數據統計。對二次計算後的數據進行數據統計可以是統計二次計算的結果,例如“數據1”至“數據3”的數據總和、差額、比例等,還可以將總和進行數據統計,生成圖表、進行警訊或者郵件報告等。 The statistics module 502 is configured to perform data statistics on the second calculated data. The data statistics of the data after the second calculation may be the result of the statistical secondary calculation, for example, the sum of the data of "data 1" to "data 3", the difference, the ratio, etc., and the statistics of the sum may be performed to generate a chart and perform Alerts or email reports, etc.

圖5是根據本發明第五實施例的數據統計裝置的示意圖。如圖所示,裝置包括獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50,還包括數據獲取單元11、格式設置單元21、第一展示單元31。其中,獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50與圖1所示獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50的功能相同,不做贅述。 Figure 5 is a schematic diagram of a data statistics apparatus in accordance with a fifth embodiment of the present invention. As shown in the figure, the device includes an obtaining unit 10, a prompting unit 20, a defining unit 30, a storage unit 40, and a statistical unit 50, and further includes a data acquiring unit 11, a format setting unit 21, and a first display unit 31. The obtaining unit 10, the prompting unit 20, the defining unit 30, the storing unit 40, and the statistic unit 50 have the same functions as the obtaining unit 10, the prompting unit 20, the defining unit 30, the storage unit 40, and the statistic unit 50 shown in FIG. Make a statement.

數據獲取單元11用於在統計儲存的運維數據之後獲取統計數據。獲取的統計數據可以是對運維數據計算得到的總和、差額、比例等數據。 The data acquisition unit 11 is configured to acquire statistical data after statistically storing the operation and maintenance data. The obtained statistical data may be data such as sum, difference, and proportion calculated on the operation and maintenance data.

格式設置單元21用於接收用戶對統計數據設置的格式。對統計數據進行格式設置,可以是對各個字段的數據設置單獨的格式,例如添加前後綴,小數點精確位數等。可以方便的為數值設置單位,或統一數據展示樣式。例如“數據3的比例”,可以設置保留2位小數,並添加%符號表示其為百分比。 The format setting unit 21 is configured to receive a format set by the user for the statistical data. The statistics are formatted by setting a separate format for the data of each field, such as adding a suffix, a decimal point, and the like. It is convenient to set the unit for the value or to unify the data display style. For example, "Scale of Data 3", you can set to keep 2 decimal places and add % symbol to indicate it is a percentage.

第一展示單元31用於按照設置的格式對統計數據進行數據展示。對統計數據進行數據展示可以是對比例進行保留2位小數,並添加% 符號的展示,還可以是對加和或者差額進行例如保留2位小數的展示。 The first display unit 31 is configured to perform data display on the statistical data according to the set format. Data display for statistical data can be reserved for 2 decimal places and added % The display of the symbol may also be a display of the addition or the difference, for example, retaining 2 decimal places.

圖6是根據本發明第六實施例的數據統計裝置的示意圖。如圖所示,裝置包括獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50,還包括接收單元12、關聯單元22和第二展示單元32。其中,獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50的功能與圖1所示的獲取單元10、提示單元20、定義單元30、儲存單元40、統計單元50功能相同,不做贅述。 Figure 6 is a schematic diagram of a data statistics apparatus in accordance with a sixth embodiment of the present invention. As shown, the apparatus includes an obtaining unit 10, a prompting unit 20, a defining unit 30, a storage unit 40, and a statistical unit 50, and further includes a receiving unit 12, an associating unit 22, and a second displaying unit 32. The functions of the obtaining unit 10, the prompting unit 20, the defining unit 30, the storage unit 40, and the statistic unit 50 are the same as those of the obtaining unit 10, the prompting unit 20, the defining unit 30, the storage unit 40, and the statistic unit 50 shown in FIG. Do not repeat them.

接收單元12用於在統計儲存的運維數據之後,接收用戶設置的需要展示的字段。需要展示的字段可以是運維數據的全部字段,也可以是運維數據的部分字段。接收單元12接收用戶設置好的需要展示的字段。例如,運維數據中包括騰訊QQ的登錄頻率和登錄時間等,用戶設置需要展示的字段為騰訊QQ的登錄頻率,則接收單元12接收的字段為“登錄頻率”。 The receiving unit 12 is configured to receive, after statistically storing the operation and maintenance data, a field set by the user that needs to be displayed. The fields to be displayed may be all fields of the operation and maintenance data, or may be part of the fields of the operation and maintenance data. The receiving unit 12 receives a field set by the user that needs to be displayed. For example, the operation and maintenance data includes the login frequency and login time of the Tencent QQ, and the field that the user needs to display is the login frequency of the Tencent QQ, and the field received by the receiving unit 12 is the “login frequency”.

關聯單元22用於將用戶設置的需要展示的字段和定義後的數據表進行關聯。在接收單元12接收到需要展示的字段後,將需要展示的字段與定義後的數據表進行關聯。例如,需要展示的字段為“登錄頻率”,與定義後的數據表中“數據1”進行關聯,則定義後的數據表中“數據1”中的數據為運維數據中的“登錄頻率”。將需要展示的字段與定義後的數據表進行關聯可以是將需要展示的字段與定義後的數據表的字段一一對應,也可以是將需要展示的字段內容填充到定義後的數據表中,還可以是其他任意可以將需要展示的字段與定義後的數據表進行關聯的方式。 The associating unit 22 is configured to associate a field set by the user that needs to be displayed with the defined data table. After the receiving unit 12 receives the field that needs to be displayed, the field to be displayed is associated with the defined data table. For example, if the field to be displayed is “login frequency” and is associated with “data 1” in the defined data table, the data in “data 1” in the defined data table is the “login frequency” in the operation and maintenance data. . The association between the field to be displayed and the defined data table may be one-to-one correspondence between the field to be displayed and the field of the defined data table, or may be filled in the defined data table by the content of the field to be displayed. It can also be any other way to associate the fields that need to be displayed with the defined data tables.

第二展示單元32用於對關聯的數據表中的運維數據進行數據展示。對關聯的數據表中的運維數據進行數據展示可以是顯示運維數據中與數據表關聯的數據,按照設定的字段以表格方式展示指標數據。 The second display unit 32 is configured to perform data display on the operation and maintenance data in the associated data table. The data display of the operation and maintenance data in the associated data table may be displaying the data associated with the data table in the operation and maintenance data, and displaying the indicator data in a tabular manner according to the set field.

圖7是根據本發明第七實施例的數據統計裝置的示意圖。如圖所示,該裝置包括獲取單元10、提示單元20、定義單元30、儲存單元 40和統計單元50,還包括接收單元12、關聯單元22、第二展示單元32以及閾值單元42、判斷單元52、警訊單元62。其中,獲取單元10、提示單元20、定義單元30、儲存單元40和統計單元50與圖1所示的獲取單元10、提示單元20、定義單元30、儲存單元40和統計單元50功能相同,接收單元12、關聯單元22、第二展示單元32與圖6所示的接收單元12、關聯單元22、第二展示單元32功能相同,在此均不做贅述。 Figure 7 is a schematic diagram of a data statistics apparatus in accordance with a seventh embodiment of the present invention. As shown, the device includes an acquisition unit 10, a prompting unit 20, a defining unit 30, and a storage unit. The statistic unit 50 further includes a receiving unit 12, an associating unit 22, a second display unit 32, and a threshold unit 42, a determining unit 52, and a warning unit 62. The obtaining unit 10, the prompting unit 20, the defining unit 30, the storage unit 40, and the statistic unit 50 have the same functions as the obtaining unit 10, the prompting unit 20, the defining unit 30, the storage unit 40, and the statistic unit 50 shown in FIG. The unit 12, the association unit 22, and the second display unit 32 have the same functions as the receiving unit 12, the associated unit 22, and the second display unit 32 shown in FIG. 6, and are not described herein.

閾值單元42用於在將用戶設置的需要展示的字段和定義後的數據表進行關聯之後,接收用於對關聯的字段設置的閾值。用戶對關聯字段閾值的設置可以是對所有關聯字段進行閾值設置,也可以是對部分關聯字段進行閾值設置。關聯的字段設置的閾值可以是比例為50%,也可以是總和為500,還可以是差額為100。閾值單元42能夠接收對關聯的字段設置的閾值,也就是將接收例如比例為50%這樣的閾值信息。關聯的字段的閾值可以是由人工設定,也可以是根據程式計算和處理後得到的閾值,可以是用於檢查數據異常的閾值。 The threshold unit 42 is configured to receive a threshold for setting the associated field after associating the field set by the user and the defined data table. The user can set the threshold of the associated field to be a threshold setting for all associated fields, or a threshold setting for a partial associated field. The threshold of the associated field setting may be a ratio of 50%, a sum of 500, or a difference of 100. Threshold unit 42 is capable of receiving a threshold set for the associated field, i.e., will receive threshold information such as a ratio of 50%. The threshold of the associated field may be manually set, or may be a threshold obtained after calculation and processing according to the program, and may be a threshold for checking data abnormality.

判斷單元52用於在接收到錄入的運維數據之後,判斷錄入的運維數據的字段的值與閾值是否滿足預設警訊條件。錄入的運維數據的字段的值與閾值是否滿足預設警訊條件可以是在錄入的運維數據的字段的值大於等於閾值的情況下,滿足預設警訊條件,也可以是在錄入的運維數據的字段的值小於閾值的情況下,滿足預設警訊條件。是否滿足預警條件可以根據不同產品的不同指標進行設定,不同指標的閾值可以相互獨立,也可以是指標與指標的閾值相關聯。 The determining unit 52 is configured to determine whether the value of the field of the entered operation and maintenance data and the threshold meet the preset warning condition after receiving the entered operation and maintenance data. Whether the value of the field of the entered operation and maintenance data and the threshold satisfy the preset alarm condition may be that the preset warning condition is met when the value of the field of the entered operation and maintenance data is greater than or equal to the threshold, or may be entered. When the value of the field of the operation and maintenance data is less than the threshold, the preset warning condition is satisfied. Whether the early warning condition is met can be set according to different indicators of different products, and the thresholds of different indicators can be independent of each other, or the indicators can be associated with the threshold of the indicator.

警訊單元62用於在判斷出錄入的運維數據的字段的值與閾值滿足預設警訊條件之後,進行警訊。在運維數據的字段的值與閾值滿足預設警訊條件之後,會向用戶或配置的負責人進行警訊,提醒相關人員關注敏感數據。例如,可設置當“數據3的比例”超過50%後觸發警訊,通知負責人檢查數據和數據異常原因。 The alarm unit 62 is configured to perform a warning after determining that the value of the field of the entered operation and maintenance data and the threshold satisfy the preset warning condition. After the value and threshold of the operation and maintenance data field meet the preset alarm condition, the user or the configured person in charge is alerted to alert the relevant personnel to the sensitive data. For example, it can be set to trigger a warning when the "ratio of data 3" exceeds 50%, and notify the person in charge to check the data and the cause of the data abnormality.

本發明實施例還提供一種數據統計方法,該數據統計方法運行在計算機處理設備上,用於對軟體產品的運維數據進行統計。需要說明的是,本發明實施例的數據統計方法可以透過本發明實施例所提供的數據統計裝置來執行,本發明實施例的數據統計裝置也可以用於執行本發明實施例所提供的數據統計方法。 The embodiment of the invention further provides a data statistics method, which is used on a computer processing device for performing statistics on operation and maintenance data of the software product. It should be noted that the data statistics method in the embodiment of the present invention may be performed by using the data statistics device provided by the embodiment of the present invention. The data statistics device in the embodiment of the present invention may also be used to perform data statistics provided by the embodiments of the present invention. method.

圖8是根據本發明第一實施例的數據統計方法的流程圖。如圖所示,該方法包括如下步驟。 Figure 8 is a flow chart of a data statistics method in accordance with a first embodiment of the present invention. As shown, the method includes the following steps.

步驟S101,獲取軟體產品的運維數據和數據表。獲取的軟體產品可以為騰訊QQ、QQ音樂或者其他需要進行指標收集和統計的產品。獲取的運維數據可以為騰訊QQ的登錄時間、登錄失敗次數以及登錄頻率等與軟體性能有關的數據,還可以是QQ音樂的播放種類或者某一種類的播放次數等信息。數據表可以包含任意多個字段,可以包含一個產品的多個指標,也可以是多個產品的多個指標,還可以包含其他能夠對產品進行維護和分析的任意指標。在獲取軟體產品的運維數據和數據表之後,可以透過對運維數據和數據表進行分析,對用戶使用場景和習慣進行調查研究,對產品功能進行改進和刪減,或者優化軟體性能等。 Step S101: Obtain operation and maintenance data and a data table of the software product. The acquired software products can be Tencent QQ, QQ music or other products that need to collect and count indicators. The acquired operation and maintenance data may be data related to software performance such as login time, number of login failures, and login frequency of Tencent QQ, and may also be information such as the type of playback of QQ music or the number of times of playback of a certain type. A data table can contain any number of fields, can contain multiple metrics for a product, or multiple metrics for multiple products, and can include any metric that can be maintained and analyzed. After obtaining the operation and maintenance data and data tables of the software products, the operation and maintenance data and data tables can be analyzed to investigate the user's usage scenarios and habits, and the product functions can be improved and deleted, or the software performance can be optimized.

步驟S102,提示用戶基於運維數據對數據表的字段進行定義。基於運維數據對數據表的字段進行定義可以是基於運維數據中的任意一個或者任意多個指標對數據表的字段進行定義,提示用戶根據產品分析的需要對數據表的字段進行定義。 Step S102, prompting the user to define a field of the data table based on the operation and maintenance data. The field of the data table may be defined based on the operation and maintenance data. The field of the data table may be defined based on any one of the operation and maintenance data or any plurality of indicators, and the user is prompted to define the field of the data table according to the needs of the product analysis.

步驟S103,根據用戶輸入的定義信息對數據表的字段進行定義。對數據表的字段進行定義可以使對數據表的任意一個或者多個字段進行定義,對數據表的字段進行定義可以是將數據表的字段進行命名,比如,將數據表中field_1,field_2,field_3這3個字段分別命名為“數據1”,“數據2”,“數據3”。 Step S103, defining a field of the data table according to the definition information input by the user. Defining the fields of the data table may define any one or more fields of the data table. The fields of the data table may be defined by naming the fields of the data table, for example, field_1, field_2, field_3 in the data table. These three fields are named "data 1", "data 2", and "data 3".

步驟S104,在定義後的數據表中儲存運維數據。定義後的 數據表中儲存的運維數據可以是儲存任意一個或者多個產品指標對應的數據,定義後的數據表可以是針對任一產品的任意一個或者多個指標進行定制的數據表。該數據表中可以包含需要進行數據分析或統計的字段名稱或者數據。 Step S104, storing operation and maintenance data in the defined data table. Defined The operation and maintenance data stored in the data table may be data corresponding to any one or more product indicators, and the defined data table may be a data table customized for any one or more indicators of any product. The data table can contain field names or data that require data analysis or statistics.

步驟S105,基於儲存的運維數據進行數據統計,亦即統計儲存的運維數據。數據統計可以是對產品指標的全部數據或者部分數據進行篩選和排序,還可以對全部數據或者部分數據進行報表、圖形展示,還可以進行數據二次運算、數據格式設置、閾值警訊、圖形展示和自動化報告等。對運維數據進行統計可以對上述功能中的任意一個或者多個進行數據統計,可以根據運維數據自身的實際需要進行選擇。 Step S105: Perform data statistics based on the stored operation and maintenance data, that is, statistically store the operation and maintenance data. Data statistics can be used to filter and sort all or part of the product indicators. It can also report or graphically display all or part of the data. It can also perform data secondary operations, data format setting, threshold alarms, and graphic display. And automated reporting, etc. Statistics on operation and maintenance data can be used to perform statistics on any one or more of the above functions, and can be selected according to the actual needs of the operation and maintenance data itself.

數據二次運算,可以是進行簡單的數學運算,計算總和、差額、比例等數據,例如:字段“數據3的比例”,值為“數據3/(數據3+數據1)* 100”,後臺會將field_3和field_1的值取出後,計算field_3/(field_1+field3)* 100的值。 Data secondary operation, can be a simple mathematical operation, calculate the sum, difference, proportion and other data, for example: the field "scale of data 3", the value is "data 3 / (data 3 + data 1) * 100", background After the values of field_3 and field_1 are taken out, the value of field_3/(field_1+field3)*100 is calculated.

數據格式設置,可以是對各個字段的數據設置單獨的格式,例如添加前後綴,小數點精確位數等。可以方便的為數值設置單位,或統一數據樣式。例如“數據3的比例”,可以設置保留2位小數,並添加%符號表示其為百分比。 The data format setting can be a separate format for the data of each field, such as adding a suffix, a precise number of decimal places, and the like. It is convenient to set units for values or to harmonize data styles. For example, "Scale of Data 3", you can set to keep 2 decimal places and add % symbol to indicate it is a percentage.

閾值警訊:可以使針對所有字段設置閾值,當任何一條的數據超過或小於閾值時,會向該用戶或配置的負責人進行警訊,提醒相關人員關注敏感數據。接上例,可設置當“數據3的比例”超過50%後觸發警訊,通知負責人檢查數據和數據異常原因。 Threshold Alert: You can set a threshold for all fields. When any one of the data exceeds or is less than the threshold, the user or the configured person in charge will be alerted to alert the relevant personnel to the sensitive data. In the example above, it can be set to trigger a warning when the “ratio of data 3” exceeds 50%, and notify the person in charge to check the data and the cause of the data abnormality.

圖形展示:用戶可選擇將指標中的某個字段或某幾個字段生成圖形,提供直觀的圖形數據展示。例如,可設置“數據3”的折線圖,判斷“數據3”在近一段時間內的走勢情況,查看是否有出現突增或突降;可設置“數據3”和“數據1”的餅狀圖,查看某日或某段時間內“數據3”和“數據1”的 各自匯總及比例。 Graphical display: Users can choose to generate a graphic or a few fields in the indicator to provide an intuitive graphical data display. For example, you can set the line graph of “Data 3” to judge the trend of “Data 3” in the near future, and check whether there is a sudden increase or a sudden drop; you can set the pie shape of “Data 3” and “Data 1”. Figure, view the "data 3" and "data 1" on a certain day or a certain period of time Their respective summaries and proportions.

自動化報告:用戶可定義接收某個指標或多個指標的數據,平台可以將每日各指標數據的表格和圖形展示以郵件形式匯總給用戶,也可以將每個月的數據匯總,計算總和及平均值後發送給用戶,同時平台還可以做郵件的存檔,方便用戶查詢歷史的報告記錄。 Automated reporting: Users can define data for receiving a certain indicator or multiple indicators. The platform can summarize the daily table and graphic display of each indicator data by email to the user, or aggregate the data of each month to calculate the sum and After the average value is sent to the user, the platform can also archive the mail, which is convenient for the user to query the historical report record.

透過上述的一種或多種方法能夠針對不同數據進行不同的統計,能夠滿足數據統計的特性化及良好體驗。 Through the above one or more methods, different statistics can be performed for different data, which can meet the characteristics and good experience of data statistics.

需要說明的是,在本發明實施例的數據統計方法中,也可以不執行步驟S102,這樣,在獲取軟體產品的運維數據和數據表之後,可以直接根據用戶輸入的定義信息對數據表的字段進行定義。 It should be noted that, in the data statistics method of the embodiment of the present invention, step S102 may not be performed. After obtaining the operation and maintenance data and the data table of the software product, the data table may be directly determined according to the definition information input by the user. Fields are defined.

圖9是根據本發明實施例的獲取數據表方法的流程圖。圖8中的數據表可以透過本發明實施例的獲取數據表的方法來獲取,具體地,獲取軟體產品的運維數據,如圖8的步驟S101,在獲取軟體產品的運維數據之後,將運維數據儲存於數據伺服器中的數據表中,然後獲取數據表。如圖所示,獲取數據表方法包括如下步驟S1011至步驟S1013: 9 is a flow chart of a method of acquiring a data table in accordance with an embodiment of the present invention. The data table in FIG. 8 can be obtained by the method for obtaining a data table according to the embodiment of the present invention. Specifically, the operation and maintenance data of the software product is obtained, as shown in step S101 of FIG. 8 , after acquiring the operation and maintenance data of the software product, The operation and maintenance data is stored in a data table in the data server, and then the data table is obtained. As shown in the figure, the method for obtaining a data table includes the following steps S1011 to S1013:

步驟S1011,判斷數據伺服器中是否存在數據表。數據表可以是包含任意字段名和任意字段類型的數據表,數據表中存在著任意類型的運維數據。一個數據表中存放一種類型的運維數據。判斷數據伺服器中是否存在數據表可以是判斷數據伺服器中是否存在可供用戶分析數據使用的數據表,例如,能夠分析騰訊QQ登錄失敗次數的數據表。數據伺服器可以用來儲存軟體產品源頭直接上傳的數據,也可以是透過人工或者程式預處理後的定期提交的匯總數據,處理儲存數據,數據伺服器還可以儲存數據表。 In step S1011, it is determined whether a data table exists in the data server. The data table can be a data table containing any field name and any field type, and any type of operation and maintenance data exists in the data table. A type of operation and maintenance data is stored in a data table. Determining whether the data table exists in the data server may be determining whether there is a data table available for the user to analyze the data in the data server, for example, a data table capable of analyzing the number of failures of the Tencent QQ login. The data server can be used to store the data directly uploaded by the source of the software product, or it can be a summary data that is periodically submitted through manual or program preprocessing, and the data server can also store the data table.

步驟S1012,如果判斷結果為是,根據用戶的選定獲取數據伺服器中存在的數據表。在判斷確定數據伺服器中存在數據表之後,根據用戶選定的任一類型的運維數據或者數據表來獲取數據伺服器中存在的數 據表。獲取的數據表可以是用來統計例如QQ音樂的軟體性能或者QQ音樂軟體的用戶使用習慣,還可以是用來統計其他可以對用戶使用或者產品性能進行衡量的數據。 In step S1012, if the result of the determination is yes, the data table existing in the data server is obtained according to the user's selection. After determining that the data table exists in the data server, the number of the data server is obtained according to any type of operation data or data table selected by the user. According to the table. The obtained data table may be used to count the software performance of, for example, QQ music or the user usage habit of the QQ music software, and may also be used to count other data that can be used for measuring user performance or product performance.

步驟S1013,如果判斷結果為否,接收用戶輸入的數據表請求信息和定義信息,並根據定義信息在數據伺服器創建數據表。在判斷確定數據伺服器中不存在數據表之後,接收用戶輸入的數據表請求信息和定義信息,根據定義信息在數據伺服器創建數據表,創建的數據表可以按照用戶需要的格式創建數據表的表名和字段,創建的數據表儲存於數據伺服器上。有軟體數據需要接入時,可以直接將數據放入到該數據表中。 In step S1013, if the determination result is no, the data table request information and the definition information input by the user are received, and the data table is created in the data server according to the definition information. After determining that the data table does not exist in the data server, the data table request information and the definition information input by the user are received, and the data table is created in the data server according to the definition information, and the created data table can create the data table according to the format required by the user. Table name and field, the created data table is stored on the data server. When there is software data to access, you can directly put the data into the data table.

在獲取數據表之後,本實施例之數據統計方法還可包括:將運維數據匯總至數據伺服器中,其中,同一指標對應的運維數據對應的數據儲存模型相同,並且同一指標對應的運維數據儲存在同一個數據表中,基於儲存的運維數據進行數據統計包括:接收用戶輸入並確定用戶選擇的數據表;將數據伺服器中儲存的與用戶選擇的數據表對應的運維數據接入用戶平台;在數據平台上對接入的運維數據進行數據統計。 After the data table is obtained, the data statistics method of the embodiment may further include: summarizing the operation and maintenance data to the data server, wherein the data storage model corresponding to the operation and maintenance data corresponding to the same indicator is the same, and the operation corresponding to the same indicator The dimension data is stored in the same data table, and the data statistics based on the stored operation and maintenance data include: receiving user input and determining a data table selected by the user; and operating data stored in the data server corresponding to the data table selected by the user. Access the user platform; perform data statistics on the operation and maintenance data of the access on the data platform.

其中,同一指標對應的運維數據對應的數據儲存模型相同,例如:QQ聊天的登錄時間對應的運維數據對應的數據儲存模型包括“登錄時間”、“登錄地點”。那麼,所有QQ聊天的登錄時間對應的運維數據對應的數據儲存模型都相同,包括“登錄時間”、“登錄地點。同一指標對應的運維數據儲存在同一個數據表中,例如,所有QQ的登錄時間對應的運維數據都儲存在同一個數據表中。 The data storage model corresponding to the operation and maintenance data corresponding to the same indicator is the same. For example, the data storage model corresponding to the operation and maintenance data corresponding to the login time of the QQ chat includes “login time” and “login location”. Then, the data storage model corresponding to the operation and maintenance data corresponding to the login time of all the QQ chats is the same, including the “login time” and the “login location. The operation and maintenance data corresponding to the same indicator is stored in the same data table, for example, all QQ. The operation and maintenance data corresponding to the login time are stored in the same data table.

由於同一指標對應的運維數據對應的數據儲存模型相同,因此,基於此模型對同一指標進行的數據展示以及繪製的趨勢圖或者分佈圖的格式同一,能夠統一報表格式,便於分析和查看。 Since the data storage model corresponding to the operation and maintenance data corresponding to the same indicator is the same, the data display of the same indicator based on the model and the format of the drawn trend graph or the distribution map are the same, and the report format can be unified for analysis and viewing.

數據平台是各類產品在發佈營運時,均會有一系列的上傳數據,用於監控產品的安全性、穩定性及用戶使用情況等,數據平台就是將 這類數據收集匯總並統一展示的web平台,透過提供多樣的表格和圖形化展示,能直觀的瞭解到各類營運數據的趨勢和分佈,為產品的調整提供數據依據。 The data platform is a series of upload data when all kinds of products are released for operation, which is used to monitor the security, stability and user usage of the products. The data platform is This kind of data collection and unified display of the web platform, through the provision of various forms and graphical display, can intuitively understand the trend and distribution of various operational data, and provide data basis for product adjustment.

根據本發明實施例,基於儲存的運維數據進行數據統計包括:對於儲存的運維數據進行數據二次計算;以及對二次計算後的數據進行數據統計。 According to the embodiment of the present invention, performing data statistics based on the stored operation and maintenance data includes: performing secondary data calculation on the stored operation and maintenance data; and performing data statistics on the second calculated data.

對儲存的運維數據進行數據二次運算可以是將關聯的字段進行簡單的數學運算,例如計算總和、差額、比例等數據。例如:字段“數據3的比例”,值為“數據3/(數據3+數據1)* 100”,後臺會將field_3和field_1的值取出後,計算field_3/(field_1+field3)* 100的值。 The data secondary operation on the stored operation and maintenance data may be a simple mathematical operation of the associated fields, such as calculating the sum, the difference, the ratio, and the like. For example: the field "proportion of data 3", the value is "data 3 / (data 3 + data 1) * 100", the background will take the value of field_3 and field_1, calculate the value of field_3 / (field_1 + field3) * 100 .

對二次計算後的數據進行數據統計可以是統計二次計算的結果,例如“數據1”至“數據3”的數據總和、差額、比例等,還可以將總和進行數據統計生成圖表、進行警訊或者郵件報告等。 The data statistics of the data after the second calculation may be the result of the statistical secondary calculation, for example, the sum of the data of "data 1" to "data 3", the difference, the ratio, etc., and the statistics of the sum may be generated to generate a chart and perform the police. News or email reports, etc.

圖10是根據本發明第二實施例的數據統計方法的流程圖。此實施例的數據統計方法可以作為圖8所示實施例的一種實施方式,在圖8所示的步驟S105之後,進行數據設置及展示。如圖所示,該數據統計方法包括如下步驟S201至步驟S208。 Figure 10 is a flow chart of a method of data statistics in accordance with a second embodiment of the present invention. The data statistical method of this embodiment can be used as an embodiment of the embodiment shown in FIG. 8. After step S105 shown in FIG. 8, data setting and display are performed. As shown in the figure, the data statistics method includes the following steps S201 to S208.

步驟S201至步驟S205,與圖8所示的步驟S101至步驟S105相同,在此不做贅述。 Steps S201 to S205 are the same as steps S101 to S105 shown in FIG. 8, and are not described herein.

步驟S206,獲取統計數據。獲取的統計數據可以是對運維數據計算得到的總和、差額、比例等數據。 In step S206, statistical data is acquired. The obtained statistical data may be data such as sum, difference, and proportion calculated on the operation and maintenance data.

步驟S207,接收用戶對統計數據設置的格式。對統計數據進行格式設置,可以是對各個字段的數據設置單獨的格式,例如添加前後綴,小數點精確位數等。可以方便的為數值設置單位,或統一數據展示樣式。例如“數據3的比例”,可以設置保留2位小數,並添加%符號表示其為百分比。 Step S207, receiving a format set by the user for the statistical data. The statistics are formatted by setting a separate format for the data of each field, such as adding a suffix, a decimal point, and the like. It is convenient to set the unit for the value or to unify the data display style. For example, "Scale of Data 3", you can set to keep 2 decimal places and add % symbol to indicate it is a percentage.

步驟S208,按照設置的格式對統計數據進行數據展示。對統計數據進行數據展示可以是對比例進行保留2位小數,並添加%符號的展示,還可以是對加和或者差額進行例如保留2位小數的展示。 Step S208, performing data display on the statistical data according to the set format. The data display of the statistical data may be a comparison of retaining 2 decimal places and adding a display of the % symbol, or may be a display of the addition or the difference, for example, retaining 2 decimal places.

圖11是根據本發明第三實施例的在數據統計方法的流程圖。實施例的數據統計方法可以作為圖8所示實施例的一種實施方式,在圖8所示的步驟S105之後,對需要展示字段與定義後的數據表進行關聯及展示,如圖所示,數據統計方法包括如下步驟S301至步驟308。 11 is a flow chart of a method of statistical data in accordance with a third embodiment of the present invention. The data statistics method of the embodiment can be used as an implementation manner of the embodiment shown in FIG. 8. After the step S105 shown in FIG. 8, the data field that needs to be displayed is associated with and displayed, as shown in the figure. The statistical method includes the following steps S301 to 308.

步驟S301至步驟S305,與圖8所示的步驟S101至步驟S105相同,在此不做贅述。 Steps S301 to S305 are the same as steps S101 to S105 shown in FIG. 8, and are not described herein.

步驟S306,接收用戶設置的需要展示的字段。需要展示的字段可以是運維數據的全部字段,也可以是運維數據的部分字段。接收單元12接用戶設置好的需要展示的字段。例如,運維數據中包括騰訊QQ的登錄頻率和登錄時間等,用戶設置需要展示的字段為騰訊QQ的登錄頻率,則接收單元12接收的字段為“登錄頻率”。 Step S306, receiving a field set by the user that needs to be displayed. The fields to be displayed may be all fields of the operation and maintenance data, or may be part of the fields of the operation and maintenance data. The receiving unit 12 is connected to a field set by the user to be displayed. For example, the operation and maintenance data includes the login frequency and login time of the Tencent QQ, and the field that the user needs to display is the login frequency of the Tencent QQ, and the field received by the receiving unit 12 is the “login frequency”.

步驟S307,將用戶設置的需要展示的字段和定義後的數據表進行關聯。在接收到需要展示的字段後,將需要展示的字段與定義後的數據表進行關聯。例如,需要展示的字段為“登錄頻率”,與定義後的數據表中“數據1”進行關聯,則定義後的數據表中“數據1”中的數據為運維數據中的“登錄頻率”。將需要展示的字段與定義後的數據表進行關聯可以是將需要展示的字段與定義後的數據表的字段一一對應,也可以是將需要展示的字段內容填充到定義後的數據表中,還可以是其他任意可以將需要展示的字段與定義後的數據表進行關聯的方式。 Step S307, the field set by the user to be displayed is associated with the defined data table. After receiving the fields that need to be displayed, associate the fields that need to be displayed with the defined data tables. For example, if the field to be displayed is “login frequency” and is associated with “data 1” in the defined data table, the data in “data 1” in the defined data table is the “login frequency” in the operation and maintenance data. . The association between the field to be displayed and the defined data table may be one-to-one correspondence between the field to be displayed and the field of the defined data table, or may be filled in the defined data table by the content of the field to be displayed. It can also be any other way to associate the fields that need to be displayed with the defined data tables.

步驟S308,對關聯的數據表中的運維數據進行數據展示。對關聯的數據表中的運維數據進行數據展示可以是顯示運維數據中與數據表關聯的數據。 Step S308, performing data display on the operation and maintenance data in the associated data table. The data display of the operation and maintenance data in the associated data table may be the data associated with the data table in the operation and maintenance data.

圖12是根據本發明第四實施例的在數據統計方法的流程 圖。實施例的數據統計方法可以作為圖8所示實施例的一種實施方式,根據本發明實施例,在將用戶設置的需要展示的字段和定義後的數據表進行關聯之後,數據統計方法包括步驟S401至步驟S410。 FIG. 12 is a flowchart of a method for statistical data according to a fourth embodiment of the present invention. Figure. The data statistics method of the embodiment may be used as an embodiment of the embodiment shown in FIG. 8. After the field that needs to be displayed by the user is associated with the defined data table, the data statistics method includes step S401. Go to step S410.

步驟S401至步驟S407,與圖8所示的步驟S301至步驟S307相同,在此不做贅述。 Steps S401 to S407 are the same as steps S301 to S307 shown in FIG. 8, and are not described herein.

步驟S408,接收用於對關聯的字段設置的閾值。用戶對關聯字段閾值的設置可以是對所有關聯字段進行閾值設置,也可以是對部分關聯字段進行閾值設置。關聯的字段設置的閾值可以是比例為50%,也可以是總和為500,還可以是差額為100。閾值單元42能夠接收對關聯的字段設置的閾值,也就是將接收例如比例為50%這樣的閾值信息。關聯的字段的閾值可以是由人工設定,也可以是根據程式計算和處理後得到的閾值,可以是用於檢查數據異常的閾值。 Step S408, receiving a threshold for setting the associated field. The user can set the threshold of the associated field to be a threshold setting for all associated fields, or a threshold setting for a partial associated field. The threshold of the associated field setting may be a ratio of 50%, a sum of 500, or a difference of 100. Threshold unit 42 is capable of receiving a threshold set for the associated field, i.e., will receive threshold information such as a ratio of 50%. The threshold of the associated field may be manually set, or may be a threshold obtained after calculation and processing according to the program, and may be a threshold for checking data abnormality.

步驟S409,如果接收到錄入的運維數據,判斷錄入的運維數據的字段的值與閾值是否滿足預設警訊條件。錄入的運維數據的字段的值與閾值是否滿足預設警訊條件可以是在錄入的運維數據的字段的值大於等於閾值的情況下,滿足預設警訊條件,也可以是在錄入的運維數據的字段的值小於閾值的情況下,滿足預設警訊條件。是否滿足預警條件可以根據不同產品的不同指標進行設定,不同指標的閾值可以相互獨立,也可以是指標與指標的閾值相關聯。 In step S409, if the entered operation and maintenance data is received, it is determined whether the value of the field of the entered operation and maintenance data and the threshold meet the preset alarm condition. Whether the value of the field of the entered operation and maintenance data and the threshold satisfy the preset alarm condition may be that the preset warning condition is met when the value of the field of the entered operation and maintenance data is greater than or equal to the threshold, or may be entered. When the value of the field of the operation and maintenance data is less than the threshold, the preset warning condition is satisfied. Whether the early warning condition is met can be set according to different indicators of different products, and the thresholds of different indicators can be independent of each other, or the indicators can be associated with the threshold of the indicator.

步驟S410,如果判斷出錄入的運維數據的字段的值與閾值滿足預設警訊條件,則進行警訊。在運維數據的字段的值與閾值滿足預設警訊條件之後,會向該用戶或配置的負責人進行警訊,提醒相關人員關注敏感數據。例如,可設置當“數據3的比例”超過50%後觸發警訊,通知負責人檢查數據和數據異常原因。 Step S410: If it is determined that the value of the field of the entered operation and maintenance data and the threshold satisfy the preset warning condition, the alarm is performed. After the value of the operation and maintenance data field and the threshold meet the preset alarm condition, the user or the configured person in charge is alerted to the relevant personnel to pay attention to the sensitive data. For example, it can be set to trigger a warning when the "ratio of data 3" exceeds 50%, and notify the person in charge to check the data and the cause of the data abnormality.

本發明實施例還提供了一種計算機儲存介質。計算機儲存介質可存有程式,此程式用於執行上述的數據統計方法中的部分或全部步驟。 The embodiment of the invention further provides a computer storage medium. The computer storage medium may store a program for performing some or all of the steps of the above statistical methods.

需要說明的是,對於前述的各方法實施例,為了簡單描述,故將其表述為一系列的動作組合,但是本領域技術人員應該知悉,本發明並不受所描述的動作順序的限制,因為依據本發明,某些步驟可以採用其他順序或者同時進行。其次,本領域技術人員也應該知悉,說明書中所描述的實施例所涉及的動作和模組並不一定是本發明所必須的。在上述實施例中,對各個實施例的描述都各有側重,某個實施例中沒有詳述的部分,可以參見其他實施例的相關描述。 It should be noted that, for the foregoing method embodiments, for the sake of simple description, it is expressed as a series of action combinations, but those skilled in the art should understand that the present invention is not limited by the described action sequence, because In accordance with the present invention, certain steps may be performed in other sequences or concurrently. Secondly, those skilled in the art should also understand that the actions and modules involved in the embodiments described in the specification are not necessarily required by the present invention. In the above embodiments, the descriptions of the various embodiments are different, and the details that are not detailed in a certain embodiment can be referred to the related descriptions of other embodiments.

在本申請所提供的幾個實施例中,應該理解到,所揭露的裝置,可透過其它的方式實現。例如,以上所描述的裝置實施例僅僅是示意性的,例如單元的劃分,僅僅為一種邏輯功能劃分,實際實現時可以有另外的劃分方式,例如多個單元或組件可以結合或者可以集成到另一個系統,或一些特徵可以忽略,或不執行。另一點,所顯示或討論的相互之間的耦合或直接耦合或通信連接可以是透過一些接口,裝置或單元的間接耦合或通信連接,可以是電性或其它的形式。 In the several embodiments provided by the present application, it should be understood that the disclosed device can be implemented in other manners. For example, the device embodiments described above are merely illustrative. For example, the division of cells is only a logical function division. In actual implementation, there may be another division manner. For example, multiple units or components may be combined or may be integrated into another. A system, or some features can be ignored or not executed. In addition, the coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interface, device or unit, and may be electrical or otherwise.

所述作為分離部件說明的單元可以是或者也可以不是物理上分開的,作為單元顯示的部件可以是或者也可以不是物理單元,即可以位於一個地方,或者也可以分佈到多個網絡單元上。可以根據實際的需要選擇其中的部分或者全部單元來實現本實施例方案的目的。 The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of the embodiment.

另外,在本發明各個實施例中的各功能單元可以集成在一個處理單元中,也可以是各個單元單獨物理存在,也可以兩個或兩個以上單元集成在一個單元中。上述集成的單元既可以採用硬體的形式實現,也可以採用軟體功能單元的形式實現。 In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of a hardware or a software functional unit.

集成的單元如果以軟體功能單元的形式實現並作為獨立的產品銷售或使用時,可以儲存在一個計算機可讀取儲存介質中。基於這樣的理解,本發明的技術方案本質上或者說對現有技術做出貢獻的部分或者該技術方案的全部或部分可以以軟體產品的形式體現出來,該計算機軟體 產品儲存在一個儲存介質中,包括若干指令用以使得一台計算機設備(可為個人計算機、伺服器或者網絡設備等)執行本發明各個實施例所述方法的全部或部分步驟。而前述的儲存介質包括:U盤、唯讀儲存器(ROM,Read-Only Memory)、隨機存取儲存器(RAM,Random Access Memory)、移動硬盤、磁碟或者光盤等各種可以儲存程式代碼的介質。 The integrated unit can be stored in a computer readable storage medium if it is implemented as 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 all or part of the technical solution may be embodied in the form of a software product. The product is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk, or an optical disk, and the like, which can store program codes. medium.

以上所述本發明實施例僅為說明之用,並非用於限制本發明,對於本領域的技術人員來說,本發明可以有各種更改和變化。凡在本發明的精神和原則之內,所作的任何修改、等同替換、改進等,均應包含在本發明的保護範圍之內。 The embodiments of the present invention described above are for illustrative purposes only and are not intended to limit the invention, and various modifications and changes can be made in the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and scope of the present invention are intended to be included within the scope of the present invention.

10‧‧‧獲取單元 10‧‧‧Acquisition unit

20‧‧‧提示單元 20‧‧‧Cue unit

30‧‧‧定義單元 30‧‧‧Definition unit

40‧‧‧儲存單元 40‧‧‧ storage unit

50‧‧‧統計單元 50‧‧‧Statistics unit

Claims (16)

一種數據統計方法,包括:獲取軟體產品的運維數據和數據表;根據用戶輸入的定義信息對所述數據表的字段進行定義;在定義後的所述數據表中儲存所述運維數據;以及基於儲存的所述運維數據進行數據統計。 A data statistics method includes: acquiring operation and maintenance data and a data table of a software product; defining a field of the data table according to definition information input by a user; and storing the operation and maintenance data in the defined data table; And performing data statistics based on the stored operation and maintenance data. 如申請專利範圍第1項所述之數據統計方法,其中,獲取所述數據表包括:判斷數據伺服器中是否存在所述數據表;如果判斷結果為是,根據用戶的選定獲取所述數據伺服器中存在的數據表;以及如果判斷結果為否,接收用戶輸入的數據表請求信息和定義信息,並根據所述定義信息在所述數據伺服器創建所述數據表。 The data statistics method of claim 1, wherein the obtaining the data table comprises: determining whether the data table exists in the data server; if the determination result is yes, acquiring the data servo according to a user selection. a data table existing in the device; and if the determination result is no, receiving data table request information and definition information input by the user, and creating the data table in the data server according to the definition information. 如申請專利範圍第2項所述之數據統計方法,在獲取所述數據表之後,所述方法還包括:將所述運維數據匯總至所述數據伺服器中,其中,同一指標對應的所述運維數據對應的數據儲存模型相同,並且同一指標對應的所述運維數據儲存在同一個數據表中,基於儲存的所述運維數據進行數據統計包括:接收用戶輸入並確定用戶選擇的數據表;將所述數據伺服器中儲存的與用戶選擇的數據表對應的所述運維數據接入用戶數據平台;以及在所述數據平台上對接入的所述運維數據進行數據統計。 The data statistics method of claim 2, after the obtaining the data table, the method further comprises: summarizing the operation and maintenance data into the data server, wherein the same indicator corresponds to The data storage model corresponding to the operation and maintenance data is the same, and the operation and maintenance data corresponding to the same indicator is stored in the same data table, and performing data statistics based on the stored operation and maintenance data includes: receiving user input and determining user selection. a data table; accessing the operation and maintenance data corresponding to the data table selected by the user stored in the data server to the user data platform; and performing statistics on the operation and maintenance data accessed on the data platform . 如申請專利範圍第1項所述之數據統計方法,所述基於儲存的所述 運維數據進行數據統計包括:對於儲存的所述運維數據進行數據二次計算;以及對二次計算後的數據進行數據統計。 The data statistics method of claim 1, wherein the storing based The data statistics of the operation and maintenance data include: performing secondary calculation on the stored operation and maintenance data; and performing data statistics on the second calculated data. 如申請專利範圍第1項所述之數據統計方法,在基於儲存的所述運維數據進行數據統計之後,所述方法還包括:獲取統計數據;接收用戶對所述統計數據設置的格式;以及按照設置的格式對所述統計數據進行數據展示。 The data statistics method of claim 1, after performing data statistics based on the stored operation and maintenance data, the method further includes: acquiring statistical data; receiving a format set by the user for the statistical data; The statistical data is presented in accordance with the format set. 如申請專利範圍第1項所述之數據統計方法,在基於儲存的所述運維數據進行數據統計之後,所述方法還包括:接收用戶設置的需要展示的字段;將用戶設置的需要展示的字段和定義後的所述數據表進行關聯;以及對關聯的所述數據表中的運維數據進行數據展示。 The data statistics method of claim 1, after performing data statistics based on the stored operation and maintenance data, the method further includes: receiving a field set by the user that needs to be displayed; and setting the user to display The field is associated with the defined data table; and the data is displayed on the operation and maintenance data in the associated data table. 如申請專利範圍第6項所述之數據統計方法,在將用戶設置的需要展示的字段和定義後的所述數據表進行關聯之後,所述方法還包括:接收用於對關聯的字段設置的閾值;如果接收到錄入的運維數據,判斷錄入的運維數據的字段的值與所述閾值是否滿足預設警訊條件;如果判斷出錄入的運維數據的字段的值與所述閾值滿足所述預設警訊條件,則進行警訊。 For example, in the data statistics method described in claim 6, after the user-set field to be displayed and the defined data table are associated, the method further includes: receiving the setting for the associated field. a threshold value; if the entered operation and maintenance data is received, determining whether the value of the field of the entered operation and maintenance data and the threshold meet the preset alarm condition; if it is determined that the value of the field of the entered operation and maintenance data and the threshold are satisfied The preset warning condition is followed by a warning. 如申請專利範圍第1項所述之數據統計方法,在根據用戶輸入的定義信息對所述數據表的字段進行定義之前,所述方法還包括: 提示用戶基於所述運維數據對所述數據表的字段進行定義。 The data statistics method of claim 1, wherein before the field of the data table is defined according to the definition information input by the user, the method further includes: The user is prompted to define a field of the data table based on the operation and maintenance data. 一種數據統計裝置,包括:獲取單元,用於獲取軟體產品的運維數據和數據表;定義單元,用於根據用戶輸入的定義信息對所述數據表的字段進行定義;儲存單元,用於在定義後的所述數據表中儲存所述運維數據;以及統計單元,用於統計儲存的所述運維數據。 A data statistics device, comprising: an obtaining unit, configured to acquire operation and maintenance data and a data table of the software product; a defining unit, configured to define a field of the data table according to the definition information input by the user; and a storage unit, configured to The operation data table is stored in the defined data table; and the statistical unit is configured to collect the operation and maintenance data stored. 如申請專利範圍第9項所述之數據統計裝置,所述獲取單元包括:判斷模組,用於判斷數據伺服器中是否存在所述數據表;獲取模組,用於在判斷數據伺服器中存在所述數據表之後,根據用戶的選定獲取所述數據伺服器中存在的數據表;以及創建模組,用於在判斷數據伺服器中不存在所述數據表之後,接收用戶輸入的數據表請求信息和定義信息,並根據所述定義信息在所述數據伺服器創建所述數據表。 The obtaining unit includes: a determining module, configured to determine whether the data table exists in the data server; and an obtaining module, configured in the determining data server, in the data counting device according to claim 9 After the data table exists, the data table existing in the data server is obtained according to the user's selection; and a module is created for receiving the data table input by the user after determining that the data table does not exist in the data server. Requesting information and defining information, and creating the data table at the data server based on the definition information. 如申請專利範圍第10項所述之數據統計裝置,所述裝置還包括:匯總單元,用於在獲取所述數據表之後,將所述運維數據匯總至所述數據伺服器中,其中,同一指標對應的所述運維數據對應的數據儲存模型相同,並且同一指標對應的所述運維數據儲存在同一個數據表中,所述統計單元基於儲存的所述運維數據進行數據統計包括:接收用戶輸入並確定用戶選擇的數據表;將所述數據伺服器中儲存的與用戶選擇的數據表對應的所述運維 數據接入用戶數據平台;以及在所述數據平台上對接入的所述運維數據進行數據統計。 The data statistics device of claim 10, the device further comprising: a summary unit, configured to summarize the operation and maintenance data into the data server after acquiring the data table, wherein The data storage model corresponding to the operation and maintenance data corresponding to the same indicator is the same, and the operation and maintenance data corresponding to the same indicator is stored in the same data table, and the statistical unit performs data statistics based on the stored operation and maintenance data. Receiving a user input and determining a data table selected by the user; storing the operation and maintenance corresponding to the data table selected by the user stored in the data server Data accessing the user data platform; and performing data statistics on the operation and maintenance data accessed on the data platform. 如申請專利範圍第9項所述之數據統計裝置,所述統計單元還包括:計算模組,用於對儲存的所述運維數據進行數據二次計算;以及統計模組,用於對二次計算後的數據進行數據統計。 The statistical unit of claim 9, wherein the statistical unit further comprises: a calculation module, configured to perform secondary calculation on the stored operation and maintenance data; and a statistical module, configured to The data after the calculation is used for data statistics. 如申請專利範圍第9項所述之數據統計裝置,所述裝置還包括:數據獲取單元,用於在基於儲存的所述運維數據進行數據統計之後獲取統計數據;格式設置單元,用於接收用戶對所述統計數據設置的格式;以及第一展示單元,用於按照設置的格式對所述統計數據進行數據展示。 The data statistics device of claim 9, wherein the device further comprises: a data acquisition unit, configured to acquire statistical data after performing data statistics based on the stored operation and maintenance data; and a format setting unit, configured to receive a format set by the user for the statistical data; and a first display unit, configured to perform data display on the statistical data according to the set format. 如申請專利範圍第9項所述之數據統計裝置,所述裝置還包括:接收單元,用於在統計儲存的所述運維數據之後,接收用戶設置的需要展示的字段;關聯單元,用於將用戶設置的需要展示的字段和定義後的所述數據表進行關聯;以及第二展示單元,用於對關聯的所述數據表中的運維數據進行數據展示。 The data statistic device of claim 9, wherein the device further comprises: a receiving unit, configured to: after the statistically storing the operation and maintenance data, receive a field set by the user to be displayed; And the second display unit is configured to perform data display on the operation and maintenance data in the associated data table. 如申請專利範圍第14項所述之數據統計裝置,所述裝置還包括:閾值單元,用於在將用戶設置的需要展示的字段和定義後的所述數據表進行關聯之後,接收用於對關聯的字段設置的閾值;判斷單元,用於在接收到錄入的運維數據之後,判斷錄入的運維數據的字段的值與所述閾值是否滿足預設警訊條件;警訊單元,用於在判斷出錄入的運維數據的字段的值與所述閾值滿足 所述預設警訊條件之後,進行警訊。 The data statistics device of claim 14, wherein the device further comprises: a threshold unit, configured to receive, after associating the field that needs to be displayed set by the user with the defined data table, The threshold of the associated field setting; the determining unit is configured to: after receiving the recorded operation and maintenance data, determine whether the value of the field of the entered operation and maintenance data and the threshold meet the preset warning condition; the alarm unit is used for Determining that the value of the field of the entered operation and maintenance data is satisfied with the threshold After the preset warning condition, a warning is performed. 如申請專利範圍第9項所述之一種數據統計裝置,還包括:提示單元,用於提示用戶基於所述運維數據對所述數據表的字段進行定義。 The data statistics device of claim 9, further comprising: a prompting unit, configured to prompt the user to define a field of the data table based on the operation and maintenance data.
TW103125519A 2013-09-02 2014-07-25 A method of data statistics and a device thereof TW201510720A (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310393372.0A CN104424299B (en) 2013-09-02 2013-09-02 Data statistical approach and device

Publications (1)

Publication Number Publication Date
TW201510720A true TW201510720A (en) 2015-03-16

Family

ID=52585625

Family Applications (1)

Application Number Title Priority Date Filing Date
TW103125519A TW201510720A (en) 2013-09-02 2014-07-25 A method of data statistics and a device thereof

Country Status (3)

Country Link
CN (1) CN104424299B (en)
TW (1) TW201510720A (en)
WO (1) WO2015027954A1 (en)

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105607983B (en) * 2015-11-09 2018-08-10 北京京东尚科信息技术有限公司 Data exception monitoring method and device
CN105653436A (en) * 2015-12-31 2016-06-08 山东中创软件商用中间件股份有限公司 Data displaying method and system
CN106100868B (en) * 2016-05-27 2019-07-09 努比亚技术有限公司 A kind of project operation and maintenance device, system and method
CN106021591A (en) * 2016-06-06 2016-10-12 北京奇虎科技有限公司 Data processing method and system for terminal
CN106533734A (en) * 2016-09-23 2017-03-22 杭州优云软件有限公司 Automation operation method through combination of actual operation and post system
CN110069453A (en) * 2017-09-30 2019-07-30 北京国双科技有限公司 Operation/maintenance data treating method and apparatus
CN111221883B (en) * 2018-11-27 2024-04-26 浙江宇视科技有限公司 Data statistics method and system
CN110399380A (en) * 2019-06-17 2019-11-01 中国平安人寿保险股份有限公司 A kind of data processing method, electronic device and storage medium

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5189608A (en) * 1987-06-01 1993-02-23 Imrs Operations, Inc. Method and apparatus for storing and generating financial information employing user specified input and output formats
CN101075919A (en) * 2006-06-22 2007-11-21 腾讯科技(深圳)有限公司 Method and system for monitoring Internet service
CN101071482A (en) * 2007-06-19 2007-11-14 广州市煤气公司 Underground gas pipe network safety evaluating system
CN100465968C (en) * 2007-08-20 2009-03-04 中兴通讯股份有限公司 Processing system for automated testing log
CN101207851A (en) * 2007-11-20 2008-06-25 北京信达爱瑞通信技术有限公司 Wireless application access system, client end equipment and server
CN101546403A (en) * 2008-03-27 2009-09-30 天津德智科技有限公司 Online service system and method for providing online service
CN102208991A (en) * 2010-03-29 2011-10-05 腾讯科技(深圳)有限公司 Blog processing method, device and system
CN103024348B (en) * 2012-11-06 2016-08-17 前卫视讯(北京)科技发展有限公司 The operation management system of video monitoring

Also Published As

Publication number Publication date
CN104424299A (en) 2015-03-18
WO2015027954A1 (en) 2015-03-05
CN104424299B (en) 2019-06-07

Similar Documents

Publication Publication Date Title
TW201510720A (en) A method of data statistics and a device thereof
JP6592474B2 (en) Providing resource usage information for each application
CN112000747B (en) Data multidimensional analysis method, device and system
CN111078695B (en) Method and device for calculating association relation of metadata in enterprise
WO2020000726A1 (en) Performance test report generating method, electronic device, and readable storage medium
WO2018121335A1 (en) Real-time data processing method and device
US9626700B1 (en) Aggregation of operational data for merchandizing of network accessible services
CN113076416A (en) Information heat evaluation method and device and electronic equipment
CN111414410A (en) Data processing method, device, equipment and storage medium
CN114741396A (en) Data service processing method and device, electronic equipment and storage medium
CN115964272A (en) Transaction data automatic testing method, device, equipment and readable storage medium
JP5017434B2 (en) Information processing apparatus and program
CN109828883B (en) Task data processing method and device, storage medium and electronic device
US10296361B2 (en) Chargeback system and method using chargeback data structures
CN113344513A (en) Project information management method and device, electronic equipment and storage medium
CN111338959B (en) Data processing method and related equipment
CN111191999A (en) Product research and development management method and device, computer equipment and storage medium
JP5016260B2 (en) Environmental information aggregation device, environmental information aggregation method and program
TWI480754B (en) Pivot analysis method with the group of conditions
Baek et al. An energy efficiency grading system for mobile applications based on usage patterns
EP4209933A1 (en) Data processing method and apparatus, and electronic device and storage medium
JP2009009342A (en) Information processing unit and program
CN114756764A (en) Enterprise-based content information stream recommendation method and device, electronic equipment and storage medium
US20190179037A1 (en) System and method for determining quantities of radon in an environment
CN111090559A (en) Data monitoring method and device and server