skip to content
Data warehousing with Microsoft SQL Server 7.0 : technical reference Preview this item
ClosePreview this item
Checking...

Data warehousing with Microsoft SQL Server 7.0 : technical reference

Author: Jake Sturm
Publisher: Redmond, Wash. : Microsoft Press, ©2000.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Additional Physical Format: Print version:
Sturm, Jake, 1961-
Data warehousing with Microsoft SQL Server 7.0.
Redmond, Wash. : Microsoft Press, ©2000
(DLC) 99046101
(OCoLC)42578620
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Jake Sturm
OCLC Number: 183263487
Notes: Title from title screen.
Includes link to Microsoft eLearning Solutions web site.
Includes index.
Reproduction Notes: Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2011. MiAaHDL
Description: 1 online resource
Details: Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Contents: 1 Sharing Information Across the Enterprise 1 --
Heart of the Solution: Operational and Analytical Data 2 --
Operational Data 2 --
Analytical Data 2 --
History of Analytical Data: Spreadsheets to Data Warehouses 3 --
Building a SQL Server 7.0 Decision Support System 6 --
Decision Support System Goals 7 --
Planning a Decision Support System 8 --
SQL Server 7.0 Decision Support System Tools 8 --
OLAP Services 8 --
PivotTable Services 9 --
Object Linking and Embedding Database (OLE DB) 9 --
Data Transformation Services (DTS) 9 --
SQL Server 7.0 Multidimensional Database 9 --
Wizards and Designers 10 --
Office 2000 10 --
Microsoft Repository 10 --
2 Planning and Designing Enterprise Analytical Systems 11 --
Milestones 13 --
General Overview of the Cycles 14 --
Envisioning Phase 14 --
Planning Phase 14 --
Developing Phase 14 --
Stabilizing Phase 15 --
Goals and Deliverables 15 --
Three Groups 15 --
MSF Team Roles 17 --
Four Phases in Building an Analytical System 21 --
Envisioning Phase 21 --
Planning Phase 28 --
Developing Phase 34 --
Stabilizing Phase 35 --
3 Online Analytical Processing (OLAP) Systems 37 --
OLAP Essentials 37 --
Normalized vs. Un-Normalized Data Structures 38 --
Normalizing Data 38 --
Entity-Relationship Model 42 --
Normalized Data and OLAP Systems 43 --
Analyzing Data Using Dimensions and Facts 45 --
Informational Tables 48 --
Fact Table 55 --
Cubes 56 --
SQL Server 7.0 OLAP Services 57 --
4 Building Cubes with the Microsoft SQL Server 7.0 OLAP Services Manager 61 --
Aggregations 62 --
Data Explosion 62 --
Rolap, Molap, and Holap 64 --
Partitions 80 --
Partition Wizard 81 --
Drill Down 85 --
Storing Data and Partitions 86 --
Virtual Cubes 88 --
Roles 90 --
Viewing Roles 90 --
Assigning a Role to the Virtual Warehouse and Sales Cube 91 --
OLAP Management Console 93 --
Adding Snap-Ins to the Microsoft Management Console 94 --
Cube Wizard 95 --
Creating the Sales 1998 Cube Using the Cube Wizard 95 --
Information Dimensions 106 --
Creating the Profit Calculated Member 107 --
Creating Calculated Measures 108 --
Creating an Average Calculated Member (Information Dimensions) 109 --
Categorical Dimensions 109 --
Members 110 --
Creating Members for the Customer1998 Dimension 111 --
Creating the Virtual Dimension 111 --
Storing Categorical Dimensions as Virtual or Real Dimensions 112 --
Processing Cubes 113 --
Properties of Dimensions in the Cube Editor 114 --
Cubes 114 --
Dimensions and Levels 115 --
Measures Properties 116 --
Calculated Member Properties 117 --
5 Introducing Multidimensional Extensions 119 --
MDX and OLAP 119 --
MDX and Microsoft SQL Server 7.0 Data Warehousing 119 --
Optimizing the Data Warehouse 120 --
Designing the Data Warehouse 120 --
MDX and SQL Server 7.0 OLAP Services 120 --
MDX Statements 121 --
Five Elements of an MDX Statement 121 --
Numbers 121 --
Strings 122 --
Members 122 --
Tuples 122 --
Sets 122 --
Basic Structure of an MDX Statement 123 --
Specifying the Axes and the Cube 125 --
Sample Application 125 --
Using Dot Operator 129 --
Query Errors 131 --
Nesting Dimensions 134 --
Creating Slicer Dimensions 143 --
MDX WHERE Clause 144 --
Incorrect WHERE Clauses 146 --
Placing Measures into the WHERE Clause 146 --
6 Creating Calculated Members 151 --
Using MDX With Clause 151 --
Query Profit and Percent Profit 151 --
Using Additive Calculated Members 153 --
Calculating Non-Additive Calculated Members 154 --
Formatting Date/Time Values 162 --
Creating Session-Defined Calculated Members 164 --
7 Expressions 165 --
Member Expressions 165 --
CURRENTMENBER 166 --
Null Members and Empty Cells 170 --
Additional Calculated Members with Member Expressions 171 --
Set Expressions 176 --
Session-Defined Sets 176 --
MEMBERS 176 --
CHILDREN 178 --
DESCENDANTS 179 --
ORDERn 181 --
HIERARCHIZE 184 --
TOPCOUNT and BOTTOMCOUNT 185 --
TOPPERCENT and BOTTOMPERCENT 190 --
TOPSUM and BOTTOMSUM 191 --
FILTER 193 --
UNION 197 --
DISTINCT 197 --
INTERSECT 197 --
EXCEPT 197 --
CROSSJOIN 199 --
EXTRACT 200 --
GENERATE 201 --
Numeric Functions 203 --
SUM 203 --
AGGREGATE 204 --
COUNT 205 --
AVERAGE, MEDIAN, MIN, MAX, VARIANCE, STDDEV, AND RANK 205 --
8 ADO Multidimensional 209 --
Introduction to ADO MD 210 --
Creating an Application to Test ADO MD 211 --
ADO MD Catalog Hierarchy 214 --
Catalog Object 214 --
CubeDefs Collection 216 --
CubeDef Object 216 --
CubeDef Properties 217 --
Property Object 218 --
Dimensions Collection 219 --
Dimension Object 219 --
Hierarchies Collection 221 --
Hierarchy Object 221 --
Levels Collection 222 --
Level Object 222 --
Members Collection 224 --
Member Object 224 --
ADO MD Cellset Hierarchy 226 --
Positions Collection 227 --
Position Object 227 --
Cell Object 234 --
Properties for the ADO MD Objects 237 --
Limitations of ADO MD 238 --
9 System Administrator's Role in Design 241 --
Designing a Generic Application 241 --
Creating Scenarios from User Interviews 242 --
Creating a Use Case 242 --
Defining User Groups 244 --
Using Good Naming Conventions 245 --
Creating a Sequence Diagram 245 --
Exploring Four System Components 246 --
Considering Security 247 --
Designing the Data Services Components 247 --
OLAP Data Services Component 247 --
CubeConnection Component 248 --
CubeMetaData Component 250 --
CubeData 253 --
Building Scalable Components 256 --
prjCubeGrid 257 --
10 Data Transformation Services 263 --
Overview of DTS 264 --
DTS Features 264 --
Extraction 265 --
Transformation 265 --
Loading 265 --
DTS Packages 266 --
Connection Objects 267 --
Task Objects 267 --
Step Objects 267 --
Importing and Exporting with DTS 267 --
Exporting Files Using DTS 267 --
Viewing the Package 277 --
Package Designer 278 --
Moving Data into a MOLAP Cube 279 --
Running DTS OLAP Tasks 280 --
Saving Packages 284 --
Scheduling Packages 286 --
Package Versions 287 --
General Properties 288 --
Issues with Updating a Data Warehouse 289 --
11 PivotTable Services 291 --
Overview of PivotTable Services 291 --
PivotTable Services Client Server Cache 293 --
Excel 9 and PivotTable Services 294 --
Client-Side Cubes 294 --
Building the Product Dimension 299 --
Building the Time, Promotion, and Store Dimensions 300 --
Viewing OLAP Cubes with Excel 306 --
Office 2000 Web Components 308 --
12 Optimizing a SQL Server Data Warehouse 313 --
Optimizing the Star Schema 313 --
Query Analyzer 314 --
Profiler 318 --
Cube Schema Optimization 325 --
OLAP Performance Tools 327 --
Usage Analysis Wizard 328 --
Usage-Based Optimization Wizard 330 --
Best Practices for Designing Cubes 332 --
Optimizing Dimensions 332 --
Optimizing Measures 334 --
Optimizing Partitions 334 --
Data Warehouse Advanced Properties 335 --
Hardware 335 --
Data Explosion 336 --
A Multidimensional Extensions 341 --
B Microsoft Repository 345 --
Metadata 345 --
Benefits of the Repository 346 --
C Visual Basic Components 347 --
Building the Visual Basic Components 347 --
Cube Connection Object 347 --
ClsCubeConnection 348 --
CubeData 355 --
CubeMetaData 372 --
Designing and Building a Generic Cube Browser 394 --
PrjCubeGrid 394 --
InitializeCube 397 --
D English Query 419 --
Domains 419 --
Domain Editor 420 --
E Decision Support Objects 423.
Responsibility: Jake Sturm.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Related Subjects:(2)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/183263487> # Data warehousing with Microsoft SQL Server 7.0 : technical reference
    a schema:MediaObject, schema:Book, schema:CreativeWork ;
    library:oclcnum "183263487" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/864040190#Place/redmond_wash> ; # Redmond, Wash.
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/wau> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/864040190#CreativeWork/sql_server> ; # SQL server.
    schema:about <http://id.worldcat.org/fast/1376937> ; # SQL server.
    schema:about <http://id.worldcat.org/fast/888026> ; # Data warehousing
    schema:about <http://dewey.info/class/005.7585/e21/> ;
    schema:bookFormat schema:EBook ;
    schema:copyrightYear "2000" ;
    schema:creator <http://viaf.org/viaf/9181969> ; # Jake Sturm
    schema:datePublished "2000" ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/864040190> ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/42578620> ;
    schema:name "Data warehousing with Microsoft SQL Server 7.0 : technical reference"@en ;
    schema:productID "183263487" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/183263487#PublicationEvent/redmond_wash_microsoft_press_2000> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/864040190#Agent/microsoft_press> ; # Microsoft Press
    schema:url <http://catalog.hathitrust.org/api/volumes/oclc/42578620.html> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/183263487> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/864040190#Agent/microsoft_press> # Microsoft Press
    a bgn:Agent ;
    schema:name "Microsoft Press" ;
    .

<http://experiment.worldcat.org/entity/work/data/864040190#Place/redmond_wash> # Redmond, Wash.
    a schema:Place ;
    schema:name "Redmond, Wash." ;
    .

<http://id.worldcat.org/fast/1376937> # SQL server.
    a schema:CreativeWork ;
    schema:name "SQL server." ;
    .

<http://id.worldcat.org/fast/888026> # Data warehousing
    a schema:Intangible ;
    schema:name "Data warehousing"@en ;
    .

<http://viaf.org/viaf/9181969> # Jake Sturm
    a schema:Person ;
    schema:birthDate "1961" ;
    schema:familyName "Sturm" ;
    schema:givenName "Jake" ;
    schema:name "Jake Sturm" ;
    .

<http://www.worldcat.org/oclc/42578620>
    a schema:CreativeWork ;
    rdfs:label "Data warehousing with Microsoft SQL Server 7.0." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/183263487> ; # Data warehousing with Microsoft SQL Server 7.0 : technical reference
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.