top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.

Biblioteca

MARC Lista (tabellare)
Data Warehousing [[electronic resource] ] : OLAP and Data Mining / / S. Nagabhushana
Data Warehousing [[electronic resource] ] : OLAP and Data Mining / / S. Nagabhushana
Autore Nagabhushana S
Pubbl/distr/stampa New Delhi, : New Age International (P) Ltd., Publishers, c2006
Descrizione fisica 1 online resource (351 p.)
Disciplina 658.8/02
Soggetto topico Data warehousing
Data mining
OLAP technology
Soggetto genere / forma Electronic books.
ISBN 1-282-12891-4
9786612128912
81-224-2705-7
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto v. 1. Data warehousing implementation and OLAP: pt. 1. Introduction ; pt. 2. People ; pt. 3. Process ; pt. 4. Technology ; pt. 5. Maintenance, evolution and trends ; pt. 6. On-line analytical processing -- v. 2. Data mining.
Record Nr. UNINA-9910454694503321
Nagabhushana S  
New Delhi, : New Age International (P) Ltd., Publishers, c2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Data Warehousing [[electronic resource] ] : OLAP and Data Mining / / S. Nagabhushana
Data Warehousing [[electronic resource] ] : OLAP and Data Mining / / S. Nagabhushana
Autore Nagabhushana S
Pubbl/distr/stampa New Delhi, : New Age International (P) Ltd., Publishers, c2006
Descrizione fisica 1 online resource (351 p.)
Disciplina 658.8/02
Soggetto topico Data warehousing
Data mining
OLAP technology
ISBN 1-282-12891-4
9786612128912
81-224-2705-7
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto v. 1. Data warehousing implementation and OLAP: pt. 1. Introduction ; pt. 2. People ; pt. 3. Process ; pt. 4. Technology ; pt. 5. Maintenance, evolution and trends ; pt. 6. On-line analytical processing -- v. 2. Data mining.
Record Nr. UNINA-9910777979303321
Nagabhushana S  
New Delhi, : New Age International (P) Ltd., Publishers, c2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Data Warehousing : OLAP and Data Mining / / S. Nagabhushana
Data Warehousing : OLAP and Data Mining / / S. Nagabhushana
Autore Nagabhushana S
Edizione [1st ed.]
Pubbl/distr/stampa New Delhi, : New Age International (P) Ltd., Publishers, c2006
Descrizione fisica 1 online resource (351 p.)
Disciplina 658.8/02
Soggetto topico Data warehousing
Data mining
OLAP technology
ISBN 1-282-12891-4
9786612128912
81-224-2705-7
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto v. 1. Data warehousing implementation and OLAP: pt. 1. Introduction ; pt. 2. People ; pt. 3. Process ; pt. 4. Technology ; pt. 5. Maintenance, evolution and trends ; pt. 6. On-line analytical processing -- v. 2. Data mining.
Record Nr. UNINA-9910806898903321
Nagabhushana S  
New Delhi, : New Age International (P) Ltd., Publishers, c2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 Cube Views [[electronic resource] ] : a primer / / [Corinne Baragoin ... et al.]
DB2 Cube Views [[electronic resource] ] : a primer / / [Corinne Baragoin ... et al.]
Edizione [1st ed.]
Pubbl/distr/stampa [S.l.], : IBM, International Technical Support Organization, c2003
Descrizione fisica xxxvi, 718 p. : ill
Disciplina 005.75/65
Altri autori (Persone) BaragoinCorinne
Collana IBM redbooks
Soggetto topico Relational databases
OLAP technology
Soggetto genere / forma Electronic books.
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910449902803321
[S.l.], : IBM, International Technical Support Organization, c2003
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 Cube Views [[electronic resource] ] : a primer / / [Corinne Baragoin ... et al.]
DB2 Cube Views [[electronic resource] ] : a primer / / [Corinne Baragoin ... et al.]
Edizione [1st ed.]
Pubbl/distr/stampa [S.l.], : IBM, International Technical Support Organization, c2003
Descrizione fisica xxxvi, 718 p. : ill
Disciplina 005.75/65
Altri autori (Persone) BaragoinCorinne
Collana IBM redbooks
Soggetto topico Relational databases
OLAP technology
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910783279403321
[S.l.], : IBM, International Technical Support Organization, c2003
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 Cube Views : a primer / / [Corinne Baragoin ... et al.]
DB2 Cube Views : a primer / / [Corinne Baragoin ... et al.]
Edizione [1st ed.]
Pubbl/distr/stampa [S.l.], : IBM, International Technical Support Organization, c2003
Descrizione fisica xxxvi, 718 p. : ill
Disciplina 005.75/65
Altri autori (Persone) BaragoinCorinne
Collana IBM redbooks
Soggetto topico Relational databases
OLAP technology
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 Understand DB2 Cube Views -- Chapter 1. An OLAP-aware DB2 -- 1.1 Business Intelligence and OLAP introduction -- 1.1.1 Online Analytical Processing -- 1.1.2 Metadata -- 1.2 DB2 UDB V8.1 becomes OLAP-aware -- 1.3 Challenges faced by DBA's in an OLAP environment -- 1.3.1 Manage the flow of metadata -- 1.3.2 Optimize and manage custom summary tables -- 1.3.3 Optimize MOLAP database loading -- 1.3.4 Enhance OLAP queries performance in the relational database -- 1.4 How DB2 can help -- 1.4.1 Efficient multidimensional model: cube model -- 1.4.2 Summary tables optimization: Optimization Advisor -- 1.4.3 Interfaces -- 1.5 Metadata bridges to back-end and front-end tools -- Chapter 2. DB2 Cube Views: scenarios and benefits -- 2.1 What can DB2 Cube Views do for you? -- 2.2 Feeding metadata into DB2 Cube Views -- 2.2.1 Feeding DB2 Cube Views from back-end tools -- 2.2.2 Feeding DB2 Cube Views from front-end tools -- 2.2.3 Feeding DB2 Cube Views from scratch -- 2.3 Feeding front-end tools from DB2 Cube Views -- 2.3.1 Supporting MOLAP tools with DB2 Cube Views -- 2.3.2 Supporting ROLAP tools with DB2 Cube Views -- 2.3.3 Supporting HOLAP tools with DB2 Cube Views -- 2.3.4 Supporting bridgeless ROLAP tools with DB2 Cube Views -- 2.4 Feeding Web services from DB2 Cube Views -- 2.4.1 A scenario -- 2.4.2 Flow and components -- 2.4.3 Benefits -- Part 2 Build and optimize the DB2 Cube Model -- Chapter 3. Building a cube model in DB2 -- 3.1 What are the data schemas that can be modeled? -- 3.1.1 Star schemas -- 3.1.2 Snowflakes -- 3.1.3 Star and snowflakes characteristics -- 3.2 Cube model notion and terminology -- 3.2.1 Measures and facts -- 3.2.2 Attributes -- 3.2.3 Dimensions.
3.2.4 Hierarchies -- 3.2.5 Attribute relationships -- 3.2.6 Joins -- 3.2.7 In a nutshell: cube model and cubes -- 3.3 Building cube models using the OLAP Center -- 3.3.1 Planning for building a cube model -- 3.3.2 Preparing the DB2 relational database for DB2 Cube Views -- 3.3.3 Building the cube model by import -- 3.3.4 Building a cube model with Quick Start wizard -- 3.3.5 Creating a basic complete cube model from scratch -- 3.4 Enhancing a cube model -- 3.4.1 Based on end-user analytics requirements -- 3.4.2 Based on Optimization Advisor and MQT usage -- 3.5 Backup and recovery -- 3.6 Summary -- Chapter 4. Using the cube model for summary tables optimization -- 4.1 Summary tables and optimization requirements -- 4.2 How cube model influences summary tables and query performance -- 4.3 MQTs: a quick overview -- 4.3.1 MQTs in general -- 4.3.2 MQTs in DB2 Cube Views -- 4.4 What you need to know before optimizing -- 4.4.1 Get at least a cube model and one cube defined -- 4.4.2 Define referential integrity or informational constraints -- 4.4.3 Do you know or have an idea of the query type? -- 4.4.4 Understand how Optimization Advisor uses cube model/cube -- 4.5 Using the Optimization Advisor -- 4.5.1 How does the wizard work -- 4.5.2 Check your cube model -- 4.5.3 Run the Optimization Advisor -- 4.5.4 Parameters for the Optimization Advisor -- 4.6 Deploying Optimization Advisor MQTs -- 4.6.1 What SQL statements are being run? -- 4.6.2 Are the statements using the MQTs? -- 4.6.3 How deep in the hierarchies do the MQTs go? -- 4.6.4 Check the DB2 parameters -- 4.6.5 Is the query optimization level correct? -- 4.7 Optimization Advisor and cube model interactions -- 4.7.1 Optimization Advisor recommendations -- 4.7.2 Query to the top of the cube -- 4.7.3 Querying a bit further down the cube -- 4.7.4 Moving towards the middle of the cube.
4.7.5 Visiting the bottom of the cube -- 4.8 Performance considerations -- 4.9 Further steps in MQT maintenance -- 4.9.1 Refresh DEFERRED option -- 4.9.2 Refresh IMMEDIATE option -- 4.9.3 Refresh DEFERRED versus refresh IMMEDIATE -- 4.9.4 INCREMENTAL refresh versus FULL refresh -- 4.9.5 Implementation guidelines -- 4.9.6 Limitations for INCREMENTAL refresh -- 4.10 MQT tuning -- 4.11 Configuration considerations -- 4.11.1 Estimating memory required for MQTs -- 4.11.2 Estimating space required for MQTs -- 4.12 Conclusion -- Part 3 Access dimensional data in DB2 -- Chapter 5. Metadata bridges overview -- 5.1 A quick summary -- Chapter 6. Accessing DB2 dimensional data using Office Connect -- 6.1 Product overview -- 6.2 Architecture and components -- 6.3 Accessing OLAP metadata and data in DB2 -- 6.3.1 Prepare metadata -- 6.3.2 Launch Excel and load Office Connect Add-in -- 6.3.3 Connect to OLAP-aware database (data source) in DB2 -- 6.3.4 Import cube metadata -- 6.3.5 Bind data to Excel worksheet -- 6.4 OLAP style operations in Office Connect -- 6.5 Saving and deleting reports -- 6.6 Refreshing data -- 6.7 Optimizing for better performance -- 6.7.1 Enable SQLDebug trace in Office Connect -- 6.7.2 Use DB2 Explain to check if SQL is routed to the MQT -- 6.7.3 Scenario demonstrating benefit of optimization -- Chapter 7. Accessing dimensional data in DB2 using QMF for Windows -- 7.1 QMF product overview -- 7.2 Evolution of QMF to DB2 Cube Views support -- 7.3 Components involved -- 7.4 Using DB2 Cube Views in QMF for Windows -- 7.4.1 QMF for Windows OLAP Query wizard -- 7.4.2 Multidimensional data modeling -- 7.4.3 Object Explorer -- 7.4.4 Layout Designer -- 7.4.5 Query Results View -- 7.5 OLAP report examples and benefits -- 7.5.1 Who can use OLAP functionality? -- 7.5.2 Before starting -- 7.5.3 Sales analysis scenario -- 7.6 Maintenance.
7.6.1 Invalidation of OLAP queries -- 7.6.2 Performance issues -- 7.7 Conclusion -- Chapter 8. Using Ascential MetaStage and the DB2 Cube Views MetaBroker -- 8.1 Ascential MetaStage product overview -- 8.1.1 Managing metadata with MetaStage -- 8.2 Metadata flow scenarios with MetaStage -- 8.2.1 Importing ERwin dimensional metadata into DB2 Cube Views -- 8.2.2 Leveraging existing enterprise metadata with MetaStage -- 8.2.3 Performing cross-tool impact analysis -- 8.2.4 Performing data lineage and process analysis in MetaStage -- 8.3 Conclusion: benefits -- Chapter 9. Meta Integration of DB2 Cube Views within the enterprise toolset -- 9.1 Meta Integration Technology products overview -- 9.1.1 Meta Integration Works (MIW) -- 9.1.2 Meta Integration Repository (MIR) -- 9.1.3 Meta Integration Model Bridge (MIMB) -- 9.2 Architecture and components involved -- 9.3 Metadata flow scenarios -- 9.4 Metadata mapping and limitations considerations -- 9.4.1 Forward engineering from a relational model to a cube model -- 9.4.2 Reverse engineering of a cube model into a relational model -- 9.5 Implementation steps scenario by scenario -- 9.5.1 Metadata integration of DB2 Cube Views with ERwin v4.x -- 9.5.2 Metadata integration of DB2 Cube Views with ERwin v3.x -- 9.5.3 Metadata integration of DB2 Cube Views with PowerDesigner -- 9.5.4 Metadata integration of DB2 Cube Views with IBM Rational Rose -- 9.5.5 Metadata integration of DB2 Cube Views with CWM and XMI -- 9.5.6 Metadata integration of DB2 Cube Views with DB2 Warehouse Manager -- 9.5.7 Metadata integration of DB2 Cube Views with Informatica -- 9.6 Refresh considerations -- 9.7 Conclusion: benefits -- Chapter 10. Accessing DB2 dimensional data using Integration Server Bridge -- 10.1 DB2 OLAP Server and Integration Server bridge -- 10.1.1 Integration Server -- 10.1.2 Hybrid Analysis.
10.1.3 Integration Server Bridge -- 10.2 Metadata flow scenarios -- 10.2.1 DB2 OLAP Server and DB2 Cube Views not installed -- 10.2.2 DB2 OLAP Server and IS installed, but not DB2 Cube Views -- 10.2.3 DB2 OLAP Server installed, but not IS and DB2 Cube Views -- 10.2.4 DB2 Cube Views installed, but not DB2 OLAP Server -- 10.3 Implementation steps -- 10.3.1 Metadata flow from DB2 Cube Views to Integration Server -- 10.3.2 Metadata flow from Integration Server to DB2 Cube Views -- 10.4 Maintenance -- 10.5 DB2 OLAP Server examples and benefits -- 10.5.1 Data load -- 10.5.2 Hybrid Analysis -- 10.5.3 Drill through reports -- 10.6 Conclusions -- Chapter 11. Accessing DB2 dimensional data using Cognos -- 11.1 The Cognos solution -- 11.1.1 Cognos Business Intelligence -- 11.2 Architecture and components involved -- 11.3 Implementation steps -- 11.4 Implementation considerations -- 11.4.1 Optimizing drill through -- 11.4.2 Optimizing Impromptu reports -- 11.4.3 Implementation considerations: mappings -- 11.4.4 Enhancing the DB2 cube model -- 11.5 Cube model refresh considerations -- 11.6 Scenarios -- 11.6.1 Sales analysis scenario -- 11.6.2 Financial analysis scenario -- 11.6.3 Performance results with MQT -- 11.7 Conclusion: benefits -- Chapter 12. Accessing DB2 dimensional data using BusinessObjects -- 12.1 Business Objects product overview -- 12.1.1 BusinessObjects Enterprise 6 -- 12.2 BusinessObjects Universal Metadata Bridge overview -- 12.2.1 Metadata mapping -- 12.2.2 Complex measure mapping -- 12.2.3 Data type conversion -- 12.3 Implementation steps -- 12.3.1 Export metadata from DB2 OLAP Center -- 12.3.2 Import the metadata in the universe using Application Mode -- 12.3.3 Import the metadata in the universe using API mode -- 12.3.4 Import the metadata in the universe using the batch mode -- 12.3.5 Warning messages -- 12.4 Reports and queries examples.
12.4.1 Query 1.
Record Nr. UNINA-9910811824903321
[S.l.], : IBM, International Technical Support Organization, c2003
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 OLAP Server V8.1 [[electronic resource] ] : using advanced functions / / [Corinne Baragoin ... et. al.]
DB2 OLAP Server V8.1 [[electronic resource] ] : using advanced functions / / [Corinne Baragoin ... et. al.]
Edizione [1st ed.]
Pubbl/distr/stampa [S.l.], : IBM, International Technical Support Organization, 2002
Descrizione fisica xxviii, 510 p. : ill
Disciplina 005.75/85
Altri autori (Persone) BaragoinCorinne
Collana IBM redbooks
Soggetto topico Database management
OLAP technology
Soggetto genere / forma Electronic books.
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910454597403321
[S.l.], : IBM, International Technical Support Organization, 2002
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 OLAP Server V8.1 [[electronic resource] ] : using advanced functions / / [Corinne Baragoin ... et. al.]
DB2 OLAP Server V8.1 [[electronic resource] ] : using advanced functions / / [Corinne Baragoin ... et. al.]
Edizione [1st ed.]
Pubbl/distr/stampa [S.l.], : IBM, International Technical Support Organization, 2002
Descrizione fisica xxviii, 510 p. : ill
Disciplina 005.75/85
Altri autori (Persone) BaragoinCorinne
Collana IBM redbooks
Soggetto topico Database management
OLAP technology
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910782029103321
[S.l.], : IBM, International Technical Support Organization, 2002
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 OLAP Server V8.1 : using advanced functions / / [Corinne Baragoin ... et. al.]
DB2 OLAP Server V8.1 : using advanced functions / / [Corinne Baragoin ... et. al.]
Edizione [1st ed.]
Pubbl/distr/stampa [S.l.], : IBM, International Technical Support Organization, 2002
Descrizione fisica xxviii, 510 p. : ill
Disciplina 005.75/85
Altri autori (Persone) BaragoinCorinne
Collana IBM redbooks
Soggetto topico Database management
OLAP technology
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 Introduction -- Chapter 1. DB2 OLAP Server V8.1 overview -- 1.1 Advanced analytical functions -- 1.1.1 Combining OLAP and relational databases: Hybrid Analysis -- 1.1.2 OLAP Miner -- 1.2 Advanced enterprise functions -- 1.3 Advanced administrative functions -- 1.3.1 Parallel calculation -- 1.3.2 Parallel data load -- 1.3.3 Parallel export -- 1.3.4 Administration Services -- 1.3.5 Security Migration Tool -- 1.3.6 Custom Defined Functions and Custom Defined Macros -- 1.3.7 API enhancements -- 1.3.8 Additional improvements and new functions -- Chapter 2. DB2 OLAP Server components and case studies -- 2.1 DB2 OLAP Server components architecture -- 2.1.1 The basic DB2 OLAP Server installation -- 2.1.2 Expanding OLAP capabilities with Integration Server -- 2.1.3 Expanding with Enterprise Services -- 2.1.4 Expanding with Administration Services -- 2.1.5 Using Security Migration Tool -- 2.1.6 Using Analyzer -- 2.1.7 The big picture -- 2.2 Case studies and our test environment -- 2.2.1 E-banking case study -- 2.2.2 Online Investment case study -- 2.2.3 Our test environment setup -- Part 2 Advanced analytical functions -- Chapter 3. Hybrid Analysis -- 3.1 Hybrid Analysis overview -- 3.1.1 Terminology and definitions -- 3.2 When to use Hybrid Analysis -- 3.3 Hybrid Analysis architecture -- 3.4 Hybrid Analysis challenges -- 3.5 Implementation of Hybrid Analysis -- 3.5.1 Building Hybrid Analysis using Integration Server -- 3.5.2 Hybrid Analysis member transformation -- 3.5.3 Impact of Hybrid Analysis versus multidimensional -- 3.5.4 Hybrid Analysis in Application Manager -- 3.5.5 Hybrid Analysis and Administration Services.
3.6 Tips and tricks for tuning Hybrid OLAP applications -- 3.6.1 Defining HAMEMORYCACHESIZE -- 3.6.2 Defining HAMAXNUMCONNECTION -- 3.6.3 Defining HAMAXNUMSQLQUERY -- 3.6.4 Defining HAMAXQUERYROWS -- 3.6.5 Defining HAMAXQUERYTIME -- 3.6.6 Defining HARETRIEVENUMROW -- 3.6.7 Conclusions: Hybrid Analysis configuration settings -- 3.7 Queries in the Hybrid Analysis environment -- 3.7.1 Member caching for better query performance -- 3.8 Query performance -- 3.9 Hybrid Analysis and Drill-Through Reports -- 3.9.1 Characteristics of Drill-Through Reports -- 3.9.2 Characteristics of Hybrid Analysis -- 3.9.3 Drill-Through Reports versus Hybrid Analysis -- 3.10 Data modeling for Hybrid Analysis -- 3.11 Security configuration for Hybrid Analysis -- 3.11.1 Tracing Hybrid Analysis -- Chapter 4. Mining your OLAP cube with OLAP Miner -- 4.1 OLAP Miner overview -- 4.2 Deviation detection in OLAP Miner -- 4.2.1 OLAP Miner performance -- 4.3 When to use OLAP Miner, and when not to use it -- 4.4 Mining and interpreting E-banking cube results -- 4.4.1 Scenario 1: PC-banking usage by branch -- 4.4.2 Scenario 2: Equity trade and Net-banking in branches -- 4.5 OLAP Miner setup and architecture -- 4.6 Running and monitoring OLAP Miner -- 4.6.1 Getting OLAP Miner to run, and stopping it -- 4.6.2 OLAP Miner client configuration -- 4.7 OLAP Miner results and logs -- Part 3 Advanced functions of Enterprise Services -- Chapter 5. Enterprise Services -- 5.1 Enterprise Services overview -- 5.1.1 Enterprise Services components -- 5.2 Enterprise Services configurations -- 5.2.1 TCP/IP Client Programs -- 5.2.2 HTTP client programs -- 5.2.3 EJB client programs -- 5.2.4 CORBA client programs -- 5.3 Enterprise Services deployment scenarios -- 5.3.1 Scalability overview -- 5.3.2 Clustering -- 5.3.3 Connection pooling -- 5.3.4 Workload balancing.
5.3.5 Server and application failure and failover -- 5.3.6 Enterprise Services: the whole picture -- 5.3.7 Guidelines for implementing a full cluster of OLAP servers -- 5.3.8 Copy DB2 OLAP applications and databases across servers -- 5.3.9 Synchronizing data across DB2 OLAP Servers in a cluster -- 5.3.10 Synchronizing security across all OLAP Servers in a cluster -- 5.4 Implementing Enterprise Services with TCP/IP -- 5.4.1 Installation tips for Enterprise Services: Windows and AIX -- 5.4.2 Setting up the domain storage -- 5.4.3 Starting Enterprise Services -- 5.4.4 Creating a domain -- 5.4.5 Defining users -- 5.4.6 Defining DB2 OLAP Server and Enterprise Services servers -- 5.4.7 Creating clusters -- 5.4.8 Creating connection pools -- 5.4.9 Using the sample programs -- 5.4.10 Additional tasks -- Part 4 Advanced administrative functions -- Chapter 6. Parallel calculation, data load, and export -- 6.1 Performing parallel calculation -- 6.1.1 Understanding parallel calculation -- 6.1.2 Parallel calculation architecture -- 6.1.3 Requirements -- 6.1.4 Enabling parallel calculation -- 6.1.5 Identifying concurrent tasks for parallel calculation -- 6.1.6 Running parallel calculation -- 6.1.7 Parallel calculation performance -- 6.1.8 Monitoring using the log -- 6.1.9 Estimating the size of a database calculation -- 6.2 Performing parallel load -- 6.2.1 Understanding the parallel load -- 6.2.2 Enabling parallel load -- 6.2.3 Running parallel data load -- 6.2.4 Monitoring using the log -- 6.2.5 Parallel load performance: Defining the right parameters -- 6.2.6 Tools to monitor parallel calculation and load -- 6.3 Performing parallel export -- 6.3.1 Running parallel export -- 6.3.2 Monitoring using the log -- 6.3.3 Parallel export performance -- 6.3.4 Exporting files larger than 2 GB -- Chapter 7. Administration Services -- 7.1 Administration Services components.
7.2 New administrative capabilities -- 7.3 Administration Services configurations -- 7.4 Using Administration Services -- 7.4.1 Managing security -- 7.4.2 Managing DB2 OLAP Servers, applications, and databases -- 7.4.3 Managing logs -- 7.4.4 Managing scripts -- 7.4.5 Miscellaneous -- 7.5 Implementing Administration Services -- 7.5.1 Preparing for installation -- 7.5.2 Installing DB2 OLAP Server components -- 7.5.3 Installing Administration Services -- 7.5.4 Starting Administration Services -- 7.5.5 Setting up users -- 7.5.6 Backing up Administration Services users information -- 7.5.7 Creating views -- Chapter 8. Additional enhancements -- 8.1 Direct I/O -- 8.1.1 Understanding the DB2 OLAP Server caches -- 8.1.2 The difference between buffered I/O and direct I/O -- 8.1.3 New features in DB2 OLAP Server version 8.1 -- 8.1.4 Changing the I/O access mode (buffered I/O or direct I/O) -- 8.1.5 The cache memory locking option -- 8.1.6 Defining the DB2 OLAP Server caches when using direct I/O -- 8.2 Security Migration Tool -- 8.2.1 Before running the Security Migration Tool -- 8.2.2 Running the Security Migration Tool -- 8.3 Multiple OLAP agents on the same machine -- 8.3.1 Hints and tips -- 8.3.2 A sample configuration scenario -- 8.4 Custom Defined Functions -- 8.4.1 Software requirements -- 8.4.2 Performance considerations in the Windows environment -- 8.4.3 Creating a CDF -- 8.4.4 Using a CDF in the outline -- 8.4.5 Using a CDF in calculations -- Part 5 Appendixes -- Appendix A. DB2 OLAP Integration Server -- A.1 Integration Server enhancements -- A.2 Migration of earlier OLAP metadata catalogs -- A.2.1 New configuration file for Integration Server -- A.2.2 Multiple data sources in Integration Server -- A.2.3 Drill through -- A.2.4 XML export/import of models and metaoutlines -- A.2.5 Intelligent help and increased usability.
Appendix B. Setting up DB2 OLAP Analyzer Analysis Server V8.1 -- B.1 Analyzer V8.1 overview -- B.1.1 Supported platforms -- B.1.2 Architectural overview -- B.2 WebSphere Application Server setup -- B.3 Setting up and configuring Analyzer Server V8.1 -- B.3.1 Configuring Analyzer -- B.3.2 Uninstalling Analyzer V8.1 -- B.4 Using Analyzer V8.1 -- B.4.1 Analyzer Server console -- B.4.2 Analyzer Administration Tool -- Appendix C. Enterprise Services sample programs -- C.1 Copy application/database using CopyOLAP -- C.2 Sample runsamples.cmd script -- Appendix D. Data modeling basics -- D.1 ER data models -- D.2 Multidimensional data models: star and snowflake -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.
Record Nr. UNINA-9910808500703321
[S.l.], : IBM, International Technical Support Organization, 2002
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DOLAP '05 : proceedings of the Eighth ACM International Workshop on Data Warehousing and OLAP : November 4-5, 2005, Bremen, Germany, co-located with CIKM 2005
DOLAP '05 : proceedings of the Eighth ACM International Workshop on Data Warehousing and OLAP : November 4-5, 2005, Bremen, Germany, co-located with CIKM 2005
Pubbl/distr/stampa [Place of publication not identified], : Association for Computing Machinery, 2005
Descrizione fisica 1 online resource (122 p.;)
Collana ACM Conferences
Soggetto topico Data warehousing
OLAP technology
Engineering & Applied Sciences
Computer Science
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Altri titoli varianti DOLAP '05
Record Nr. UNINA-9910375923103321
[Place of publication not identified], : Association for Computing Machinery, 2005
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui