Introduction About Database

date of issue:2019-06-27     Source: Agrow
The country statistical database of China was first established in 2008 and was newly established in 2013. It provides monthly, quarterly and annual census, regional, sectoral and international social and economic statistics. The population data can be retrieved directly or found in the annual data. It provides a variety of file output, including tabulation, drawing, indicators, visual charts and geographic information data.

How to optimize the country statistical database?

One, reducing disk access.

We all know that disk reads are slow, and many times the database access bottleneck is here. The main methods to reduce disk access are reasonable use of index and access data only through indexes. The former is to pay attention to avoid index failure and the latter means reasonable use of upgraded indexes.  Besides, optimize SQL execution plan is also a good method for disk access reducing.

Two, reducing network transmission.

Paging query: different data SQL statement paging is written differently. The form that “select * from table” should be reduced.

Third, reducing CPU overhead.

Use bound variables (avoid hard parsing), rational use sort and reduce comparison operations, reduce computation in CPU.

Fourth, reducing the number of interactions.

Batch commit. It means when updating 10,000 pieces of data, avoid 10,000 operations with the database. Commit only once. Use stored procedures appropriately,processing result records using cursors.

Fifth, increasing resources.

Related News
  • A Brief Introduction of China Customs Trade Data

    A Brief Introduction of China Customs Trade Data

    March 16, 2020Customs trade data is a general designation of bill of lading and customs declaration data.view
  • Brazil Wheat Import 2015

    Brazil Wheat Import 2015

    May 14, 2019The Brazilian Wheat Flour Processors Association issued a report that Brazil imports 2015 wheat are expected to be reduced to 5 million tons, which is 13.5% lower than the previous year's level.In the...view
  • China Customs Trade Data and China Classified Statistics

    China Customs Trade Data and China Classified Statistics

    May 14, 20191.China customs trade dataChina customs trade data, also known as with the enterprise China customs data, or with the enterprise China customs import and export data. China customs data includes detai...view
  • Introduction to International Trade Statistics

    Introduction to International Trade Statistics

    May 14, 2019International trade statistics is a branch of statistics. It is to use statistical methods, take all countries' foreign trade as the main body, and study the changes and laws of international trade in...view
  • World Trade Statistics 2015

    World Trade Statistics 2015

    May 14, 2019In the first few months of 2015, a series of economic data, including quarterly GDP statistics and surveys of business sentiment, pointed to a solid recovery in the European Union, slowing output grow...view
  • World Trade Statistics 2016

    World Trade Statistics 2016

    May 14, 2019On April 12th the world trade organization (WTO) released its report about world trade statistics 2016. The report shows that the decline in global trade in goods narrowed in 2016, and China continue...view
Online service