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
  • Brazil Economy Exports

    Brazil Economy Exports

    May 14, 2019In response to the grim situation of the domestic economic recession, Brazilian President Rousseff announced on the 24th the "National Export Plan" at the Presidential Palace, aiming to boost economic...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
  • China's Overseas Trade Statistics

    China's Overseas Trade Statistics

    May 14, 2019Overseas trade statistics: overseas trade statistics generally refer to the import and export statistics released by the general administration of customs. The sea customs data refer to the statistica...view
  • Global Trade Statistics 2016

    Global Trade Statistics 2016

    March 16, 2020Global trade statistics 2016 points out that in 2016, the global economy shows signs of stabilizing.view
  • 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
  • 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
Online service