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
  • China's International Trade Data For The First Quarter Of 2017

    China's International Trade Data For The First Quarter Of 2017

    May 14, 2019According to customs statistics, in the first quarter of 2017, China's trade data international import and export totaled 6.2 trillion yuan, a year-on-year increase of 21.8%; of which exports were 3.3...view
  • Pesticide License Must be Applied for Before August 1. 800,000 Agricultural Dealers Face a Major Shuffle

    Pesticide License Must be Applied for Before August 1. 800,000 Agricultural Dealers Face a Major Shuffle

    August 2, 2019Is August 1st an impassable barrier?The new Pesticide Management Regulations stipulate that the state should implement the pesticide business license system, and applying for the pesticide business li...view
  • Global Trade Statistics 2016

    Global Trade Statistics 2016

    May 14, 2019According to the world Trade organization's official 2016 global Trade statistics, it includes the overall volume of Merchandise Trade and Commercial Service Trade in terms of imports and exports in 2...view
  • Argentina Import Data

    Argentina Import Data

    May 14, 2019Mechanical and electrical products are the first category of Argentina's imports from China. Imports from January to march totaled 760 million us dollars, down 26.1%, accounting for 40.8% of Argentina...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
  • 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
Online service