Software·43,832 discussions

can u explain me breifly about cubes

Locked

can u explain me breifly about cubes, how they r created and how and why they r used in sql server.

Topic

cube explnshun

In reply to can u explain me breifly about cubes

.
cubes r gud u luk hear eny questns

http://www.databasejournal.com/features/mssql/article.php/1429671

xslent repli, stres junkee

In reply to cube explnshun

u cn lso reed hole bookz on cubz, etc thru books24x7.com (subscripshun site)]

cheeper online buksite: safari.oreilly.com
($20/munth)

thes r sum of the buks:

MDX Solutions With Microsoft SQL Server Analysis Services

by George Spofford
John Wiley & Sons ? 2001 (432 pages)
ISBN:0471400467
This reference guide shows developers and users how to use MDX to access and analyze data for decision support. The authors provide practical examples of MDX in use, and explain both standard usage and more advanced techniques.

Top Section Hits (of 10 in this book)
Chapter 13: Working with Local Cubes
Chapter 1: A First Introduction to MDX (The Very Basics)
Chapter 2: MDX in More Detail (MDX Queries: More Detail)
Relevant Chapters in the Table of Contents

Microsoft SQL Server 2000 Analysis Services Step by Step

by OLAP Train and Reed Jacobson
Microsoft Press ? 2000 (379 pages)
ISBN:0735609047
A complete guide to using SQL?s Server?s powerful analysis feature for analyzing data in a corporate database.

Top Section Hits (of 10 in this book)
Chapter 1: A Data Analysis Foundation (Understanding Analysis Services)
Chapter 2: Analysis Manager from 500 Feet (Overview)
Chapter 3: Dimension and Cube Editors (Overview)
Relevant Chapters in the Table of Contents

Microsoft OLAP Solutions

by Erik Thomsen, George Spofford and Dick Chase
John Wiley & Sons ? 1999 (509 pages)
ISBN:0471332585
A comprehensive, step-by-step guide to using Microsoft SQL Server 7’s OLAP Services to build effective analytical application systems.

Top Section Hits (of 10 in this book)
Chapter 1: LAP Structures and OLAP Services (Cubes and Measures)
Chapter 3: Database Design Basics (Design OLAP Services Dimensions and Cubes)
Chapter 12: Advanced Cube and Database Design (Masking the Application Ranges of Measures in Virtual Cubes)
Relevant Chapters in the Table of Contents

Data Warehousing with Microsoft SQL Server 7.0 Technical Reference

by Jake Sturm
Microsoft Press ? 2000 (446 pages)
ISBN:0735608598
Data warehouses are not just a trend but a necessity in this information age. This book details how to build and manage them with Microsoft SQL Server 7.0.

Top Section Hits (of 10 in this book)
Chapter 3: Online Analytical Processing (OLAP) Systems (Cubes)
Chapter 4: Building Cubes with the Microsoft SQL Server 7.0 OLAP Services Manager (Aggregations)
Chapter 4: Building Cubes with the Microsoft SQL Server 7.0 OLAP Services Manager (Virtual Cubes)
Relevant Chapters in the Table of Contents

Microsoft SQL Server OLAP Developer’s Guide

by William C. Amo
John Wiley & Sons ? 2000 (357 pages)
ISBN:0764546430
A comprehensive, detailed and informative look at the OLAP technology Microsoft includes with SQL Server 7.0.

Top Section Hits (of 10 in this book)
Chapter 11: Exploring Microsoft Excel 2000 and OLAP (Creating OLAP Cubes in Excel 2000)
Preface (Why I Wrote This Book)
Chapter 1: Introduction to Microsoft OLAP Services (A Tour of Multidimensional Structures)
Relevant Chapters in the Table of Contents

Multidimensional Databases: Problems and Solutions

by Maurizio Rafanelli (ed)
Idea Group Publishing ? 2003 (443 pages)
ISBN:1591400538
These 13 studies on multidimensional databases introduce properties and peculiarities of such databases; and reveal the history, current state, and future prospects of the field.

Top Section Hits (of 10 in this book)
Chapter VII: Dynamic Multidimensional Data Cubes (DATA CUBES FOR OTHER AGGREGATE OPERATORS)
Chapter X: Incomplete Information in Multidimensional Databases (INCOMPLETE INFORMATION IN MULTIDIMENSIONAL DATABASES)
Chapter VII: Dynamic Multidimensional Data Cubes (DATA CUBES FOR INVERTIBLE AGGREGATE OPERATORS)
Relevant Chapters in the Table of Contents

OLAP Solutions: Building Multidimensional Information Systems, Second Edition

by Erik Thomsen
John Wiley & Sons ? 2002 (661 pages)
ISBN:0471400300
New advice from the essential guide of principles and best practices for building OLAP models.

Top Section Hits (of 8 in this book)
Chapter 19: Product Language Comparisons (Application Ranges in Joined Cubes)
Chapter 3: Thinking Clearly in N Dimensions (Beyond Three Dimensions)
Chapter 6: Hypercubes or Semantic Spaces (Meaning and Comparability)
Relevant Chapters in the Table of Contents

Accessing and Analyzing Data with Microsoft Excel

by Paul Cornell
Microsoft Press ? 2003 (379 pages)
ISBN:073561895x
Written for advanced users, this guide introduces techniques for sorting, filtering, formatting, and querying data with Microsoft Office XP to create sophisticated data analysis solutions by using Microsoft Excel.

Top Section Hits (of 10 in this book)
Chapter 1: Making Sense of Data (Summary)
Chapter 7: Introducing Online Analytical Processing (Using Microsoft Office to Analyze OLAP Data)
Chapter 8: Analyzing OLAP Data with Microsoft Excel (Creating Offline Cubes)
Relevant Chapters in the Table of Contents

Microsoft SQL Server 2000 Resource Kit

by Microsoft Corporation
Microsoft Press ? 2001 (1157 pages)
ISBN:0735612668
Maximize your administration, design, and application development of a SQL Server 2000 database with the techniques described in this book.

Top Section Hits (of 6 in this book)
Chapter 22: Cubes in the Real World (Designing Cubes)
Chapter 22: Cubes in the Real World
Chapter 22: Cubes in the Real World (Overview)
Relevant Chapters in the Table of Contents

Unlocking OLAP with Microsoft SQL Server and Excel 2000

by Wayne S. Freeze
John Wiley & Sons ? 2000 (473 pages)
ISBN:0764545876
Learn how to build your own data warehouse and perform OLAP using Microsoft SQL Server 7 and Microsoft Office 2000.

Top Section Hits (of 10 in this book)
Chapter 18: The Language of OLAP: Creating Cubes
Chapter 21: Using OLAP Manager to Browse Cubes
Chapter 19: The Language of OLAP: Querying Cubes
Relevant Chapters in the Table of Contents
Books: [1-10] 11-20 21-30 31-… (of 375)

gud lst but 2 menee buks

In reply to xslent repli, stres junkee

Whew, it’s hard to write like that. 😀

That’s a pretty big list. I hadn’t heard of cubes before I read this guy’s post. Admitedly I have been out of the DBA business for about 18 years. I’ve just focused on system administration in that time. I wanted to show what you can accomplish in five minutes on Google. I looked up about five references. When I found this introductory article and read about half of it I figured it would fill the bill. That databasejournal.com web site looks like a good place for DBAs to hang out. They seem to have a lot of good material.

Anyway you certainly made a nice reference list.

lotsa peeple

In reply to gud lst but 2 menee buks

get their company to sign up for subscripshun. I’m paying for it personally. Is worth it to be able to put most of my dead tree versions in storage, gf appreciates this veri much.

Someone in a class said ‘well, I can’t go lounge on a beach with the online version’

If you want to be reading these books on the beach you have bigger problems 🙂

what is nice, you can take ALL your books on trips. They have other collections for biz, finance, etc.

Am taking some proj mgmt courses and they had 41 books on that topic, just 4 IT. More proj mgmt in biz section.

and you can search all the pages and across books; that’s how I got cube list, just searched for word ‘cube’ across all content

[Author]

Replies