INOUG NEWS

    No Articles

    EVENTS

    None


    ABOUT

    INOUG is a not for profit organization dedicated to helping Oracle professionals throughout Indiana increase their knowledge and experience with Oracle and related technologies.

    The annually elected INOUG Board plans and conducts quarterly User Group Meetings. At these all day events, INOUG welcomes all interested Oracle professionals to attend for the most cost-effective training available.

    In addition to learning more about Oracle technology, the meetings are a great way to become acquainted with other local Oracle professionals and to learn what kinds of Oracle-based systems are being implemented at local companies.


    DISCUSSIONS

    View All


    Scaling to Infinity: Partitioning Data Warehouses on Oracle by Tim Gorman
    Topic: Indiana Oracle Users Group Files
    Owner: Gary Wicke
    Date: 2016-10-30
    Subtopic:

    Star schemas (a.k.a. dimensional data models) are demanded by BI analysts in data marts and data warehouses.  Star transformations are the optimal join method to access star schemas in Oracle.  Bitmap indexes are required by the star transformation process, but bitmap indexes quickly become literally infeasible without partitioning.  Why isn't this documented?  How do all these crucial pieces fit together?  Find out what major features of Oracle Database are enabled by partitioning, as well as how and why.


    Download File   TGorman INOUG DWScale 20161027.pptx

    View All


    SPONSORS

     

    MOS_Logo_RGB.png


    indy_data_partners


    lilly.png


    Independent Oracle Users Group
    330 N. Wabash Ave., Suite 2000, Chicago, IL 60611
    phone: 312-245-1579 | email: ioug@ioug.org

    Copyright © 1993-2017 by the Independent Oracle Users Group
    Terms of Use | Privacy Policy