ACC200 Ch7 Set 3 REVERSED Flashcards Preview

ACC200 > ACC200 Ch7 Set 3 REVERSED > Flashcards

Flashcards in ACC200 Ch7 Set 3 REVERSED Deck (20):
1

each spreadshhet in an organisation be assigned a unique identifier 

Spreadsheet identifier (SSID)

2

a type of advanced data analytics used to support business decision making. 

Busiess Intelligence Technologies

3

Fig7.16 pg276

Global spreadsheet query

4

Fig7.17 pg277

BI Technologies

5

a dimensional database has one fact table as its center. A relational database does not have one central database table. Instead, it resembles an interlocking chain, linked together without a center. 

Relational database or dimensional database

6

data warehouse

How is data stored using BI technologies 

7

1) fact table

2) dimension table

Two types of database in the dimensional database?

8

Fig7.22 pg280

MS SQL server Relational Database

9

has one fact table & two or more dimension (DIM) tables

Dimensional database

10

Primary key

11

a referential constraint between two tables. A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.

Foreign key

12

Two types of dimensional database structures. Both have one fact table at the centre in a star structure, the dimension database tables are all related onl to the central fact table, creating a star shape. 

In a snowflake structure the dimension tables relate to the fact table like a snowflake. There is one inner circle of dimension tables & additional dimension tables are related to the inner dimension tables. At most, a query traverses only three tables. 

Star & Snowflake

13

includes data transferred from the operational database; can also include data from other sources, including shadow data; may contain duplication & inconsistencies. 

Data warehouse

14

- extracted from the relational database

- reorganised into dimensions

- transferred & loaded into data warehouse tables

To perform BI analytics, the data must be

15

Fig7.23 pg281

Dimensional Database Star Structure

16

The word fact is added to the database fact table name. Dim is added to the dimension database table names. 

Difference between fact and dimension table

17

a step-by-step solution to a problem

Algorithm

18

Fig7.24 pg 282

ETL for Loading DimSalesTerritory Table Using MS SQL Server

19

typically used on relatively unstructured data; can be used to mine text stored in various enterprise documents, including emails, word processing documents & reports. 

Text mining

20

searches the Internet for specific paterns on Web sites

Web mining