1 / 6

مثال هایی از شماهای مختلف پایگاه داده تحلیلی

مثال هایی از شماهای مختلف پایگاه داده تحلیلی. فرشاد آقابزرگی 87131003 هوش تجاری. منابع. Ramakrishnan , Gehrke : “Database Management Systems”, Chapter 25, Section 25.2 S. Chaudhuri , U. Dayal : An Overview of Datawarehousing and OLAP Technology. Star schema. Time. Location. SALES.

svea
Download Presentation

مثال هایی از شماهای مختلف پایگاه داده تحلیلی

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. مثال هایی از شماهای مختلف پایگاه داده تحلیلی فرشاد آقابزرگی 87131003 هوش تجاری

  2. منابع • Ramakrishnan, Gehrke: “Database Management Systems”, Chapter 25, Section 25.2 • S. Chaudhuri, U. Dayal: An Overview of Datawarehousing and OLAP Technology

  3. Star schema Time Location SALES TimeId LocationId STAR SCHEMA Year Description Quarter City Sales Month District Day TimeId 25 tuples < 5*365 tuples LocationId ProductId Product SalesPerId SalesPerson ProductId Quantity SalesPerId Prod_Name UniPrice SPName Product_Type Total Industry 3 125 tuples tuples < 17 109 375 x 10 3000 tuples

  4. Star schema-extention

  5. snowflake Venue Dimension Fact Table Gender Dimension Sport Dimension Olympiad Dimension 3NF Event Class Table Sport Table

  6. A multiple aggregates constellation Sales_District District TimeId DistrictId DistrictId ProductId Dist_Desc Quantity Amount City Sales_City TimeId time CityId CityId City_Desc ProductId DistrictId Quantity Amount product Sales_Shop Shop TimeId ShopId ShopId ProductId Shop_Desc Quantity CityId Amount

More Related