LEADER 02607nam 22005534a 450 001 9910782025303321 005 20200520144314.0 035 $a(CKB)1000000000522979 035 $a(SSID)ssj0000278493 035 $a(PQKBManifestationID)11219255 035 $a(PQKBTitleCode)TC0000278493 035 $a(PQKBWorkID)10246319 035 $a(PQKB)10607667 035 $a(Au-PeEL)EBL3306658 035 $a(CaPaEBR)ebr10112712 035 $a(OCoLC)560314280 035 $a(CaSebORM)0738424609 035 $a(MiAaPQ)EBC3306658 035 $a(EXLCZ)991000000000522979 100 $a20030820d2002 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 00$aDB2 UDB's high function business intelligence in e-business$b[electronic resource] /$f[Nagraj Alur ... et al.] 205 $a1st ed. 210 $aSan Jose, Calif. $cIBM Corp.$d2002 215 $axxii, 252 p. $cill 225 1 $aIBM redbooks 300 $aBibliographic Level Mode of Issuance: Monograph 311 $a0-7384-2460-9 320 $aIncludes bibliographical references and index. 330 $aThis IBM Redbooks publication deals with exploiting DB2 UDB?s materialized views (also known as ASTs/MQTs), statistics, analytic, and OLAP functions in e-business applications to achieve superior performance and scalability. This book is aimed at a target audience of DB2 UDB application developers, database administrators (DBAs), and independent software vendors (ISVs). We provide an overview of DB2 UDB?s materialized views implementation, as well as guidelines for creating and tuning them for optimal performance. We introduce key statistics, analytic, and OLAP functions, and describe their corresponding implementation in DB2 UDB with usage examples. Finally, we describe typical business level queries that can be answered using DB2 UDB?s statistics, analytic, and OLAP functions. These business queries are categorized by industry, and describe the steps involved in resolving the query, with sample SQL and visualization of results. 410 0$aIBM redbooks. 606 $aElectronic commerce 606 $aBusiness intelligence 606 $aDatabase management 615 0$aElectronic commerce. 615 0$aBusiness intelligence. 615 0$aDatabase management. 701 $aAlur$b Nagraj$01511159 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910782025303321 996 $aDB2 UDB's high function business intelligence in e-business$93806657 997 $aUNINA