Book Contents

Book Index

Next Topic

Home

Stock Exchange Example Database

Stock Exchange schema is a simple star schema that represents summary of trades done during the day by various business such as banks, insurance companies, retail investors, mutual funds etc. It is commonly known as a "tick store." Each table is described in a separate section.

In This Chapter

StockTransaction_Fact

Date_Dimension

Exchange_Dimension

Settlement_Dimension

Split_Dimension

Stock Dimension

Trader_Dimension

stock_query_01

stock_query_02

stock_query_03

stock_query_04

stock_query_05

stock_query_06

stock_query_07