What is Database Trading?

date of issue:2020-01-28     Source: Agrow
Database trading refers to a real-time, application-oriented database with high timeliness requirements. It only focuses on the latest database, also known as transaction database.

Generally speaking, database trading consists of a file in which each record represents a transaction. Generally, a transaction contains a unique transaction ID and a list of items that make up the transaction (such as goods purchased in the store). Database transactions may have some additional tables associated with it, including other information about sales, such as transaction date, customer ID number, and seller ID Number, sales branch, etc.

If we want to dig deeper into data, in business operation, we can ask "which products are suitable for sale together?" this "shopping basket data analysis" enables us to bundle products into groups as a strategy to expand sales. For example, given the knowledge that printers and computers often sell together, you can provide customers who buy selected computers with a very expensive printer Discount sales, hope to sell more expensive printers. The conventional data retrieval system can't answer the above query. However, by identifying the commodities frequently sold together, the data mining system of transaction data can do it. Here we mainly study the statistical method of data mining in transactional database.

The difference between database trading and analysis database
Transactional databases are mainly real-time, application-oriented databases with high requirements for timeliness of response, only focusing on the latest period of data. It is usually called transactional database. Analytical database is mainly used to analyze laws in a large number of data. Generally, the data stored in the database has a long time span, a large amount of data, and low requirements for real-time. It is used for product decision-making by querying and analyzing the trend of laws.
Related News
  • Customs Import Database Introduction

    Customs Import Database Introduction

    May 14, 2019The China Customs Statistical Yearbook, compiled by the general administration of customs of the People's Republic of China, publishes detailed statistical data on China's foreign trade on an annual b...view
  • Brazil Exports 2015

    Brazil Exports 2015

    May 14, 2019According to statistics released by the ministry of industry and foreign trade of Brazil and compiled by the Arab-Brazilian Chamber of Commerce, in the first half part of Brazil exports 2015, 5.789 bi...view
  • Export Import Report

    Export Import Report

    May 14, 2019The export import report shows that China's import volume has grown rapidly in the past five years, and its average contribution rate to world import growth has exceeded 22%. It is currently the world...view
  • Argentine Customs Data

    Argentine Customs Data

    June 15, 2020Argentina Customs Data, English name Argentina Customs Import and Export Data, or Argentina Customs Data, English abbreviation ARCD.view
  • A Brief Introduction to Customs Trade Data in China

    A Brief Introduction to Customs Trade Data in China

    June 15, 2020Customs trade data is the collective name of bills of lading and customs declaration data.view
  • World Trade Statistics 2014

    World Trade Statistics 2014

    May 14, 2019Strong exchange rate volatility, including about 15% appreciation of the dollar against other currencies since 2014, further complicates the picture.The collapse of global oil prices in 2014 (down 47%...view
Online service