Differences between business intelligence and transaction systems

Differences between business intelligence and transaction systems

1. Differences in system design

The differences between business intelligence and transaction systems are mainly reflected in system design and data types (see table 1.1 and Table 1.2 ). The transaction system imposes the structure on the business. No matter who carries out a transaction activity, it will follow the same principle.ProgramAnd rules, and once a transaction system is designed, it will not change easily. Business Intelligence can adapt to business because it is a learning system that constantly adapts to the changing needs of business. In business intelligence systems, the more changes, the better. If business intelligence cannot change to solve new problems, it cannot meet business needs. From a technical perspective, the Business Intelligence System Changes data, data models, metadata, reports, and application software. The real challenge of business intelligence is to design and manage a changing system, which is like an endless journey.

2. Differences in Data Types

The difference between a transaction system and business intelligence lies in the different types of data managed by each transaction system. The transaction system tracks recent transactions and retains a very limited history (usually only 60-60 ~ 90 days ). The business intelligence system maintains transactions from multiple transaction systems for many years, as a result, many enterprises have dozens or even hundreds of terabytes data (the hils store in the United States has 70 terabytes data, and the second-largest discount chain store Kima has 90 terabytes data, walmart, the largest discount chain, had 2002 terabytes data by the end of 284, and Unilever alone had 106 terabytes data ). The Business Intelligence System summarizes and computes the business indicators to be tracked. Business Intelligence needs to be independent from the transaction system because they affect each other and both fail, or the speed required for query, analysis, and report cannot be guaranteed, the former affects the normal operation of the latter.