12.7.1 Configuration of information analysis system operated by Company A
The following is an operation example of the audit trail facility, using as an example a fictional Company A that operates an eCommerce website.
- Motivation for use of audit trail facility
-
Company A operates an eCommerce site that sells products and services over the Internet. Company A uses an HADB database to manage information such as customer details, sales history, and stock levels. To allow the real-time analysis of trends in product demand and customer preferences, this information (data) is imported into the database every 30 minutes. Because the data imported into the database includes personal information, Company A has chosen to use the audit trail facility provided by HADB so that use of the database can be audited.
- Operation of Company A's information analysis system
-
-
Information about customers who log in to the eCommerce website is imported into the database at 30 minute intervals, along with sales and inventory information for the website.
-
Company A uses BI tools to analyze the information.
-
The HADB server processes approximately 2,000 to 2,400 queries per day.
-
The length of any one SQL statement is less than 16 KB.
The following figure shows the configuration of the information analysis system and eCommerce website operated by Company A:
Figure 12‒5: Configuration of information analysis system and eCommerce website operated by Company A ![[Figure]](GRAPHICS/F0000901.GIF)
-
An operation example of the audit trail facility is explained in the following subsections, based on the preceding conditions and system configuration.