Cargando…

Preparing for DB2 near-realtime business intelligence /

In this IBM Redbooks publication we discuss primary processes and various alternatives that prepare you in implementing a DB2 near-realtime business intelligence environment. We discuss architectural alternatives and include overviews of software products that you can use in an implementation. As a...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization
Otros Autores: Ballard, Chuck
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Poughkeepsie, NY : IBM, International Technical Support Organization, ©2004.
Edición:1st ed.
Colección:IBM redbooks.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Descripción
Sumario:In this IBM Redbooks publication we discuss primary processes and various alternatives that prepare you in implementing a DB2 near-realtime business intelligence environment. We discuss architectural alternatives and include overviews of software products that you can use in an implementation. As a primary focus, we tested the capabilities for supporting continuous update of a DB2 data warehouse while running a continuous concurrent query workload against that data warehouse. We tested several implementation scenarios and the variables that impact them. The results of our testing and the issues we encountered are provided. We used an IBM p-Series multiprocessor, along with a number of software products, including WebSphere MQ, DB2 MQ Listener, DB2 UDB, and DB2 Information Integrator - Replication Edition. We discuss ETL processing in a near-realtime environment, with reference to DB2 Warehouse Manager and DataStage from Ascential Software. We used WebSphere Studio Application Developer to generate online query applications, along with Java, SQL, and C-based stored procedures. We discuss DB2 Query Patroller and DB2 Governor. We provide guidelines and recommended best practices, and this book is what you need to get prepared to implement near-realtime business intelligence in your environment.
Descripción Física:1 online resource (xviii, 294 pages) : illustrations
Bibliografía:Includes bibliographical references (pages 287-288) and index.
ISBN:0738498394
9780738498393