| 000 | 06756nam a22004453i 4500 | ||
|---|---|---|---|
| 001 | EBC3306367 | ||
| 003 | MiAaPQ | ||
| 005 | 20240729124909.0 | ||
| 006 | m o d | | ||
| 007 | cr cnu|||||||| | ||
| 008 | 240724s2004 xx o ||||0 eng d | ||
| 020 |
_a9780738498393 _q(electronic bk.) |
||
| 020 | _z9780738498393 | ||
| 035 | _a(MiAaPQ)EBC3306367 | ||
| 035 | _a(Au-PeEL)EBL3306367 | ||
| 035 | _a(CaPaEBR)ebr10112106 | ||
| 035 | _a(OCoLC)80244005 | ||
| 040 |
_aMiAaPQ _beng _erda _epn _cMiAaPQ _dMiAaPQ |
||
| 050 | 4 | _aHD38.7 -- .P74 2004eb | |
| 100 | 1 | _aRedbooks, IBM. | |
| 245 | 1 | 0 | _aPreparing for DB2 Near-Realtime Business Intelligence. |
| 250 | _a1st ed. | ||
| 264 | 1 |
_aDurham : _bI B M, _c2004. |
|
| 264 | 4 | _c©2004. | |
| 300 | _a1 online resource (318 pages) | ||
| 336 |
_atext _btxt _2rdacontent |
||
| 337 |
_acomputer _bc _2rdamedia |
||
| 338 |
_aonline resource _bcr _2rdacarrier |
||
| 505 | 0 | _aFront 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 | _a5.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 | _a9.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 | _aDescription based on publisher supplied metadata and other sources. | ||
| 590 | _aElectronic 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 | _aLinux. | |
| 650 | 0 | _aOperating systems (Computers). | |
| 655 | 4 | _aElectronic books. | |
| 776 | 0 | 8 |
_iPrint version: _aRedbooks, IBM _tPreparing for DB2 Near-Realtime Business Intelligence _dDurham : I B M,c2004 _z9780738498393 |
| 797 | 2 | _aProQuest (Firm) | |
| 856 | 4 | 0 |
_uhttps://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306367 _zClick to View |
| 999 |
_c76128 _d76128 |
||