Data statistics method, device and system based on combined major key
A data statistics and primary key technology, applied in the computer field, can solve the problems of no pre-categorization of data, large amount of data, slow viewing of statistical results, etc., to improve statistical speed and efficiency, improve statistical efficiency, and improve query efficiency and speed Effect
Inactive Publication Date: 2016-05-04
TCL CORPORATION
View PDF4 Cites 14 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The present invention provides a data statistics method, device and system based on a joint primary key, aiming to solve the problem that the traditional data statistics method generates a large amount of data, and the data is not pre-categorized, resulting in slow viewing of statistical results
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0017] In order to make the purpose, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described The embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts belong to the protection scope of the present invention.
[0018] see figure 1 , figure 1 It is a schematic diagram of the implementation flow of the data statistics method based on the joint primary key provided in the first embodiment of the present invention. The method mainly includes the following steps:
[0019] S101. Establish a joint primary key in the database that includes multiple fields...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a data statistics method, device and system based on a combined major key. The method comprises the following steps: establishing a combined major key which contains a plurality of fields in a database, causing the plurality of fields to independently corresponding to a plurality of business characteristics of business data to be stored, obtaining business data reported by a terminal, and storing the business data into the database; and when a detection result shows that a statistics task is triggered, reading the business data from the database, carrying out classification statistics on the plurality of business characteristics, and writing a classification statistics result into a position corresponding to the combined major key in the database. The stored business data is subjected to pre-statistics on the basis of the combined major key, data statistics efficiency is improved, and speed for checking a statistics analysis result is improved.
Description
technical field [0001] The invention belongs to the technical field of computers, and in particular relates to a data statistics method, device and system based on joint primary keys. Background technique [0002] At present, in information push systems such as pictures, videos, and advertisements, such as in smart TVs, the cloud can obtain the channel that the user is watching, and then push corresponding advertisements, pictures, and other information according to the user's preferences. However, with more and more access terminals and long-term accumulation, massive data records will be generated, and millions of new data will be added every day. However, it is impossible for managers or information mining analysts to extract and analyze these millions of pieces of information every day, so before managers analyze the information, we need to statistically classify the messages. [0003] The traditional message statistics method is simply to make statistics based on a sin...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More IPC IPC(8): G06F17/30
CPCG06F16/283
Inventor 候德亮
Owner TCL CORPORATION