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
  • A Catalogue Of Canadian Exports to China

    A Catalogue Of Canadian Exports to China

    May 14, 2019In 2017, China's imports from Canada totaled $18.2 billion, accounting for 4 percent of Canada's total exports.3%. The three main categories of imported goods in Canada export products list are:1.Plan...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
  • A Brief Introduction to China's Overseas Trade Statistics

    A Brief Introduction to China's Overseas Trade Statistics

    March 16, 2020Overseas trade statistics refers to the work of collecting, sorting out and analyzing the export and import of commodities in a country by using statistical theory and methods.view
  • Global Trade Volume Data

    Global Trade Volume Data

    May 14, 2019According to the Ministry of Commerce, the WTO has released the world trade statistics report. From the global trade volume data, the world trade in goods and services nearly doubled from 2005 to 2015...view
  • 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]2018 Agriculture Ushered in a

    [NCB]2018 Agriculture Ushered in a

    August 2, 2019Agriculture in 2018 and the next few years will face tremendous changes. As farmers, we must see the trends around us in order to follow the trend.In 2018, our agriculture will face five rises and one...view
Online service