Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data statistics device and data statistics method

A data statistics and data technology, applied in the field of database operations, can solve the problems of long table lock time of data source tables, serious business call loss, and low real-time statistics, and achieve real-time statistics, fast execution speed, and high data statistics efficiency. Effect

Inactive Publication Date: 2010-01-06
ZTE CORP
View PDF0 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The embodiment of the present invention provides a data statistics device and method, which are used to solve the problem in the prior art that when the large amount of data is counted inside the database, the data source table locks the table for a long time, which causes serious service call loss and the problem of low real-time statistics

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
  • Data statistics device and data statistics method
  • Data statistics device and data statistics method
  • Data statistics device and data statistics method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] The specific implementation of a data statistics method and device provided by the present invention will be described in detail below in conjunction with the accompanying drawings.

[0033] The data statistics device provided by the embodiment of the present invention is used to realize the statistics of the data of the database when the application system using the database executes the normal business process. Firstly, the structure of the data statistics device provided by the embodiment of the present invention is described in detail describe.

[0034] Such as figure 2 As shown, the data statistics device 2 provided by the embodiment of the present invention includes: an export module 201, an external statistics module 202 and an import module 203; wherein:

[0035] The export module 201 is used to export the content of the data source table 101 in the database 1 and to a predefined external file outside the database 1;

[0036] An external statistics module 202...

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 data statistics device and a data statistics method. The data statistics device comprises an output module, an external statistics module and an input module, wherein the output module is used for outputting the content of a data source table in a database to an external file which is preliminarily defined outside the database; and the external statistics module is used for the data statistics of the external file and obtaining a statistics result; and the input module is used for inputting the statistics result in a statistics table of the database. A data statistics process is mainly performed outside the database and an input process and an output process have little influence on the data source table and the statistics table of the database, thereby solving the problems of severe service call loss and lower statistics real-time property caused by locking the data source table for a longer time during great data statistics in the database.

Description

technical field [0001] The invention relates to the field of database operation, in particular to a data statistics device and method. Background technique [0002] At present, many application systems that use large data volume databases, such as recharge center systems, are time-consuming to count due to the huge amount of data. The existing method is to directly perform statistics inside the database, such as figure 1 As shown, the internal statistics module of the database will count the data in the data source table to generate a statistical table. Due to the huge amount of data, the statistical process may cause the statistical data source table to be locked for too long, which will directly affect the live network. The top-up service function leads to serious call loss in the process of the top-up service in the process of statistical data in the database. In order to reduce the call loss, the existing method tries to make statistics on the data of the database at ni...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30536G06F17/30286G06F16/2462
Inventor 丁钻平
Owner ZTE CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com