Data Warehouse Structure Presentation by John ... - DocuShare

Document Sample
Data Warehouse Structure Presentation by John ... - DocuShare Powered By Docstoc
					George Mason University

        Data Warehouse Presentation
                 02/05/04
Data Warehouse Topics
l Terms  & Definitions
l Products in the Data Warehouse
l Using the Data Warehouse
l Upcoming Enhancements
Terms & Definitions
l Physicalvs. Logical
l Data Warehouse – the big picture
l Data Marts – targeted business needs
l Refreshes (ETL)
  – Initial Loads
  – Daily Loads
l Star,   Snowflake, Constellation designs
Products in the Data Warehouse
l   DMFQ database on Maestro1
    –   Finance Data Mart – from Banner
    –   FRS History Data Mart – from ‘96
    –   HR Data Mart – from Banner
    –   HRS History Data Mart (Payroll from ‘89)
    –   HRS History Data Mart (Labor from ‘96)
l   RPRT database on Maestro1
    – Banner Mirror – All Banner tables (4000+)!
l   SISDARS database on Maestro1
    – SIS Mirror
 Products – Finance Data Mart
            Org                                 Acct
          Changes                             Changes
                              Org

 Fund
Changes             Fund               Acct

                             Finance
                              Trans

                    Grants             Prog
                                                 Fund
                                                Changes
                             Vendor
Products
l Finance Data Mart – 1 Star
l HR Data Mart – 4 Stars
  – Budget
  – Payroll Deductions
  – Payroll Earnings
  – Job Funding
l Other   Data Marts – mostly 1 Star
Using the Data Warehouse
l Logon – same as your INB
l Models & Metadata on the Web
    • http://patriotweb.gmu.edu/dw
l Oracle   Discoverer & Other Tools
  – http://chimera.gmu.edu:7779/discwb4/ht
    ml/english/netscape/start_nn.htm
l Let’s   See!
Upcoming Enhancements
l   Vendor and Purchasing data in Finance
l   New fields in HR
l   AR Data Mart (February)
l   Admissions Data Mart (March)
l   Other Student Data Marts
l   Performance, Performance, Performance
l   Create Useful Metadata
l   Evolve the Discoverer Interfaces
l   Continue Training & Info Campaign

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:7/6/2014
language:English
pages:8