Introduction to Database Transactions

date of issue:2019-07-13     Source: Agrow

Database transactions:

Typically, a database trading consists of a file in which each record represents a transaction. Generally, a transaction consists of a unique transaction identification number, and a list of items of transaction (e.g., purchase of goods in the shop). Transaction database may have some additional tables associated with it, contains information about the sales of other, such as the date of the transaction, the customer ID number, the seller's ID number, sales outlets, and so on.

If we want to dig deeper into the data, in the business operation, ask "what goods are suitable to sell together?" This "basket data analysis" enables us to bundle items into groups as a strategy for expanding sales. For example, given the knowledge that printers and computers are often sold together, you can offer customers who buy a selected computer a discount on an expensive printer and hope to sell more expensive printers. Conventional data retrieval systems cannot answer such queries. However, a data mining system for transactional data can do this by identifying items that are frequently sold together. Here we mainly study the statistical methods of data mining for transactional databases.

Differences between database transactions and database analysis:

Database trading are mainly real-time, application-oriented database, response timeliness requirements are very high, only focus on the most recent period of data. Analytical database is mainly used to analyze laws in a large amount of data. Generally, the stored data span is long, the data volume is large, and the real-time requirement is not high. Through the inquiry to analysis rule tendency, it can be used in the product decision-making and so on.
Related News
  • The Role of Customs Import Database

    The Role of Customs Import Database

    March 16, 2020As an important foreign trade resource, customs import database has always been an important way for foreign traders to develop customers.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
  • Chinese Trade Data and Analysis

    Chinese Trade Data and Analysis

    May 14, 2019According to China's trade data and analysis statistics, the total value of China's import and export of goods totaled 27.79 trillion yuan in 2017, ranking the first in the world for many years in a r...view
  • 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
  • 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
  • Indian competition body approves Bayer/Monsanto deal

    Indian competition body approves Bayer/Monsanto deal

    March 7, 2019The Competition Commission of India has conditionally approved Bayer’s proposed acquisition of Monsanto.The Competition Commission of India has conditionally approved Bayer’s proposed acquisition of...view
Online service
+86-18521783769