Quick statistical method based on two-dimensional table of relational database system

A statistical method and database technology, applied in the field of relational databases, can solve the problems affecting the acquisition speed of the total number of real-time statistical data records, the long statistical execution time, and the long scanning time.

Inactive Publication Date: 2021-02-23
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In this context, for two-dimensional tables that store massive amounts of data in relational database systems, use the traditional, conventional, SQL-99 standard-based structural query language (SQL language) COUNT () statistical function to count the total number of records , all the data records in the table will be scanned, and the larger

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Quick statistical method based on two-dimensional table of relational database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0017] See attached figure 1 , a kind of fast statistical method based on two-dimensional table of relational database system of the present invention comprises:

[0018] Step S100, building an initial statistical result table

[0019] In the relational database system, determine the two-dimensional table that needs to count the total number of data records, and use this two-dimensional table as the table to be counted; set a table name and the total number of initial data records for recording the table to be counted in the relational database system, etc. The initial statistical result table, the initial statistical result table is an independent data table structure, and the initial record is formed by inserting the table name of the table to be counted and the total number of initial data records into the data table structure.

[0020] Step S200, updating the initial statistical result table to obtain a real-time statistical result table,

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

No PUM Login to view more

Abstract

The invention discloses a quick statistical method based on a two-dimensional table of a relational database system. The quick statistical method comprises the following steps: constructing an initialstatistical result table; updating the initial statistical result table to obtain a real-time statistical result table; and querying the statistical result table to obtain the total number of real-time data records corresponding to the table name. The method mainly aims at a two-dimensional table for storing mass data in a relational database system, and when the data size of the two-dimensionaltable needing to count the total number of data records is increased or decreased, real-time addition and subtraction calculation of a statistical value of the total number of data records is triggered by defining and inserting a statistical result table of the total number of initial data records in advance; therefore, the result of the total number of the data records of the two-dimensional table to be counted is obtained in real time and stored, the time consumed for counting the total number of the data records of the two-dimensional table is optimized, the counting time is shortened, andthe counting efficiency and accuracy of the total number of the data records are improved.

Description

technical field [0001] The invention relates to the technical field of relational databases, in particular to a fast statistical method based on a two-dimensional table of a relational database system. Background technique [0002] The relational database system is an important technology for storing user information, business information, reports and other data, and is used in various industries such as the Internet, big data, e-commerce, and e-government. The two-dimensional table in the relational database system, as the main carrier of data storage, meets people's various needs for persistent storage and real-time query of relational data. However, with the rapid development of the Internet and the big data industry, the amount of business data recorded in two-dimensional tables in relational database systems has exploded exponentially, and the total amount of data in two-dimensional tables occupies more and more storage space. [0003] In this context, for two-dimensio...

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
no application Login to view more
IPC IPC(8): G06F16/28G06F16/242G06F16/22G06F16/23G06F16/2452
CPCG06F16/284G06F16/2433G06F16/2282G06F16/2452G06F16/2358
Inventor 周文龙唐军
Owner SICHUAN CHANGHONG ELECTRIC CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap