SU 3 Utilising databases

Question 1

Audit software that uses databases to store data

Answer 1

• Caseware

* CCH TeamMate

Question 2

Data warehouse

Answer 2

database populated with current and historical data extracted from the organisation’s various databases.

Question 3

Data Mart

Answer 3

Smaller data warehouse extracted from the main data warehouse and contains specific related data extracted for a specific organisational user group.

Question 4

Data Mining

Answer 4

Software is used to analyse data sets in order to uncover previously unknown trends, patterns and relationships between data.

Question 5

Online analytical processing (OLAP)

Answer 5

enables users to interactively and rapidly analyse large data sets from various viewpoints