02640nam 22005654a 450 991045462350332120200520144314.0(CKB)1000000000522979(SSID)ssj0000278493(PQKBManifestationID)11219255(PQKBTitleCode)TC0000278493(PQKBWorkID)10246319(PQKB)10607667(MiAaPQ)EBC3306658(CaSebORM)0738424609(Au-PeEL)EBL3306658(CaPaEBR)ebr10112712(OCoLC)560314280(EXLCZ)99100000000052297920030820d2002 uy 0engurcn|||||||||txtccrDB2 UDB's high function business intelligence in e-business[electronic resource] /[Nagraj Alur ... et al.]1st ed.San Jose, Calif. IBM Corp.2002xxii, 252 p. illIBM redbooksBibliographic Level Mode of Issuance: Monograph0-7384-2460-9 Includes bibliographical references and index.This 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.IBM redbooks.Electronic commerceBusiness intelligenceDatabase managementElectronic books.Electronic commerce.Business intelligence.Database management.Alur Nagraj879861MiAaPQMiAaPQMiAaPQBOOK9910454623503321DB2 UDB's high function business intelligence in e-business2286622UNINA