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
  • US EPA extends comment period for science transparency rule

    US EPA extends comment period for science transparency rule

    March 7, 2019The US Trump administration has extended the comment period for a controversial proposal to restrict the data that the EPA can use to support future regulations. The public has an additional 60 days -...view
  • 【NCB】The EU will implement the endocrine interferon standard from October this year

    【NCB】The EU will implement the endocrine interferon standard from October this year

    August 2, 2019Recently, the Official Gazette of the European Union published the regulations of the Commission, which set a scientific standard for the determination of the characteristics of endocrine interferon. ...view
  • Analysis of Trade Data Between Countries

    Analysis of Trade Data Between Countries

    May 14, 2019Recently, the "One Belt And One Road" trade cooperation big data report 2018 "was released, which mainly reflects the trade data between countries, the status quo and trend forecast of" One Belt And O...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
  • Brazil Foreign Trade Statistics

    Brazil Foreign Trade Statistics

    May 14, 2019Brazilian trade surplus hit $67 billion in 2017, the highest since Brazil foreign trade statistics began in 1989, data from the ministry of industry, trade and services (multi) showed Tuesday. The tra...view
  • China Imports All Argentine Red Shrimp

    China Imports All Argentine Red Shrimp

    May 14, 2019According to data from the international trade center (ITC), all imports of Argentine red shrimp (HS CODE 030617) totaled 185,440 tons in 2018, up 1.17 percent year-on-year and basically unchanged fro...view
Online service