Preparing for DB2 Near-Realtime Business Intelligence. (Record no. 76128)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 06756nam a22004453i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC3306367 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240729124909.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2004 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780738498393 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9780738498393 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC3306367 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL3306367 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (CaPaEBR)ebr10112106 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)80244005 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | HD38.7 -- .P74 2004eb |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Redbooks, IBM. |
| 245 10 - TITLE STATEMENT | |
| Title | Preparing for DB2 Near-Realtime Business Intelligence. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Durham : |
| Name of producer, publisher, distributor, manufacturer | I B M, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2004. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2004. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (318 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Front cover -- Contents -- Notices -- Trademarks -- Preface -- Overview of redbook contents -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction and management summary -- Business intelligence for competitive advantage -- The need for realtime BI -- Highlights and benefits -- Chapter 2. Near-realtime business intelligence -- 2.1 What is near-realtime business intelligence? -- 2.2 Processes for near-realtime BI -- 2.3 The role of business activity monitoring (BAM) -- 2.3.1 Key performance indicators -- 2.3.2 Business activity management -- 2.3.3 Getting started with BAM -- Chapter 3. Architectural considerations -- 3.1 Where are we today? -- 3.2 Data warehousing and the realtime goal -- 3.3 Technical considerations for realtime BI -- 3.3.1 Reducing IT costs -- 3.3.2 Extending the data warehouse -- 3.4 Going realtime, nearly -- 3.5 Functions for realtime data warehousing -- 3.5.1 Capture -- 3.5.2 Deliver -- 3.5.3 Transform -- 3.5.4 Apply -- 3.6 Putting it together -- Chapter 4. Products for near-realtime BI -- 4.1 Data warehousing - Base for BI -- 4.1.1 DB2 - the database of choice -- 4.2 WebSphere MQ for guaranteed data delivery -- 4.2.1 Queue clustering -- 4.2.2 DB2 MQ Listener -- 4.2.3 DB2 MQ functions -- 4.2.4 WebSphere business integration brokers -- 4.3 Information integration -- 4.3.1 DB2 Information Integrator -- 4.3.2 Data replication -- 4.3.3 Data federation -- 4.4 Data transformation -- 4.4.1 DB2 Warehouse Manager -- 4.4.2 Ascential Software -- 4.5 Workload management -- 4.5.1 DB2 Query Patroller for workload management -- 4.5.2 DB2 Governor for resource management -- Chapter 5. Planning the test environment -- 5.1 Application scenario definitions -- 5.2 Transaction definitions -- 5.3 Data models -- 5.3.1 ER model -- 5.3.2 Star model -- 5.4 Populating the data warehouse. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 5.5 Updating the data warehouse -- 5.5.1 Using stored procedures -- 5.5.2 The query workload -- 5.6 Data delivery with WebSphere MQ -- 5.7 Replication for data transfer -- 5.8 DB2 Online Load Utility -- 5.9 Configuration variables -- 5.9.1 Commit count -- 5.9.2 Number of DB2 MQ listeners -- 5.9.3 Lock isolation level -- Chapter 6. The project environment -- 6.1 Software overview -- 6.2 Environment configuration -- 6.2.1 AIX server configuration -- 6.2.2 Client configuration -- 6.3 Testing continuous update -- 6.3.1 Test plan assumptions -- 6.3.2 Testing process -- 6.4 Test scenarios -- 6.4.1 Population options -- 6.4.2 Using queues as data sources -- 6.4.3 Using DB2 tables as data sources -- 6.4.4 Test scenarios -- 6.4.5 Test scripts for queries -- Chapter 7. Primary test scenarios -- 7.1 Scenario 1: DB2 MQ Listener -- 7.1.1 Test definition -- 7.1.2 Test-runs -- 7.1.3 Test-run results -- 7.2 Scenario 2: SQL stored procedures and DB2 tables -- 7.2.1 Test definition -- 7.2.2 Test-runs -- 7.2.3 Test-run results -- 7.3 Scenario 3: DB2 view over an MQ queue -- 7.3.1 Test definition -- 7.3.2 Test-runs -- 7.3.3 Test-run results -- Chapter 8. Secondary test scenarios -- 8.1 Scenario 4: DB2 Online Load Utility -- 8.1.1 Test definition -- 8.1.2 Test-runs -- 8.1.3 Test-run results -- 8.2 Scenario 5: The Merge statement -- 8.2.1 Test definition -- 8.2.2 Test-runs -- 8.2.3 Test-run results -- 8.3 Scenario 6: Data replication -- 8.3.1 Test definition -- 8.3.2 Test-runs -- 8.3.3 Test-run results -- Chapter 9. Conclusions and best practices -- 9.1 Conclusions -- 9.1.1 General -- 9.1.2 Test-based conclusions -- 9.2 Best practices -- 9.2.1 Select business areas -- 9.2.2 Gather requirements -- 9.2.3 Develop an architecture -- 9.2.4 Analyze and modify business processes -- 9.2.5 Develop and implement BAM -- 9.2.6 Evaluate and select products. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 9.2.7 Enable a test realtime implementation -- 9.2.8 Best of our tests -- 9.2.9 Evaluate and modify -- 9.3 Epilog -- Appendix A. Ascential Software supports near-realtime BI -- A.1 Using the Ascential solution -- A.2 The test scenarios -- A.3 The test scenario solutions -- Appendix B. DB2 and realtime BI -- B.1 DB2 framework for BI -- B.2 Realtime analytics -- Appendix C. Scenario tests: Data models -- C.1 ER model -- C.2 Star schema -- Appendix D. WebSphere MQ and DB2 MQ Listener -- D.1 WebSphere MQ on AIX -- D.2 AMI installation -- D.3 Enable MQ functions for the DB2 database -- D.4 Create DB2 view over the MQ queue -- D.5 Create new service point using AMI tools -- D.6 DB2 MQ Listener installation -- D.7 DB2 MQ Listener configuration -- Appendix E. Stored procedures and scripts -- E.1 DB2 parameters -- E.2 General scripts -- E.3 Scenario 1: DB2 MQ Listener -- E.4 Scenario 2: SQL stored procedures and DB2 tables -- E.5 Scenario 3: DB2 View over an MQ queue -- E.6 Scenario 4: DB2 online load utility -- E.7 Scenario 5: The Merge statement -- E.8 Scenario 6: DB2 replication -- Appendix F. Supplemental tests -- F.1 Test set-up -- F.2 Message definition -- F.3 Testing process -- F.4 Test results -- F.5 Conclusions -- Abbreviations and acronyms -- Glossary -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Linux. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Operating systems (Computers). |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Redbooks, IBM |
| Title | Preparing for DB2 Near-Realtime Business Intelligence |
| Place, publisher, and date of publication | Durham : I B M,c2004 |
| International Standard Book Number | 9780738498393 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306367">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306367</a> |
| Public note | Click to View |
No items available.