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
  • Argentina Export Data

    Argentina Export Data

    May 14, 2019In the first three months of 2017, Argentina's imports and exports of goods totaled $26.42 billion, up 4.7 percent from the same period last year, according to statistics Argentina. Among them, the Ar...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
  • The Role of Customs Import Database

    The Role of Customs Import Database

    June 15, 2020Customs import database, as an important foreign trade resource, has always been an important way for foreign traders to develop customers.view
  • China's Trade Situation In 2014 International Trade Statistics

    China's Trade Situation In 2014 International Trade Statistics

    May 14, 2019According to customs statistics, in international trade statistics 2014, China's total import and export value of 26.43 trillion yuan, a year-on-year growth of 2.3%, including exports of 14.39 trillio...view
  • China's International Trade Data

    China's International Trade Data

    March 16, 2020International trade data by country is used to observe the total scale of a country's foreign trade.view
  • Brazil's Import and Export Trade Surplus In 2015

    Brazil's Import and Export Trade Surplus In 2015

    May 14, 2019Brazil posted a surplus of $19.681 billion due to the devaluation of its currency, despite a sharp drop in Brazil imports and exports 2015, the ministry of industry and trade announced Thursday. Brazi...view
Online service