ACC200 Ch7 Set 3 Flashcards Preview

ACC200 > ACC200 Ch7 Set 3 > Flashcards

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

Spreadsheet identifier (SSID)

each spreadshhet in an organisation be assigned a unique identifier 

2

Busiess Intelligence Technologies

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

3

Global spreadsheet query

Fig7.16 pg276

4

BI Technologies

Fig7.17 pg277

5

Relational database or dimensional database

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. 

6

How is data stored using BI technologies 

data warehouse

7

Two types of database in the dimensional database?

1) fact table

2) dimension table

8

MS SQL server Relational Database

Fig7.22 pg280

9

Dimensional database

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

10

Primary key

11

Foreign key

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.

12

Star & Snowflake

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. 

13

Data warehouse

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

14

To perform BI analytics, the data must be

- extracted from the relational database

- reorganised into dimensions

- transferred & loaded into data warehouse tables

15

Dimensional Database Star Structure

Fig7.23 pg281

16

Difference between fact and dimension table

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

17

Algorithm

a step-by-step solution to a problem

18

ETL for Loading DimSalesTerritory Table Using MS SQL Server

Fig7.24 pg 282

19

Text mining

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

20

Web mining

searches the Internet for specific paterns on Web sites