03176nam 2200601Ia 450 991044979350332120200520144314.0(CKB)1000000000243625(SSID)ssj0000285154(PQKBManifestationID)11226445(PQKBTitleCode)TC0000285154(PQKBWorkID)10278233(PQKB)10461262(MiAaPQ)EBC3306739(CaSebORM)0738429309(Au-PeEL)EBL3306739(CaPaEBR)ebr10112835(OCoLC)137342234(EXLCZ)99100000000024362520031014d2003 uy 0engurcn|||||||||txtccrUp and running with DB2 UDB ESE partitioning for performance in an e-business intelligence world[electronic resource] /[Corinne Baragoin ... et al.]1st ed.San Jose, CA IBM Corp., International Technical Support Organization2003xxiv, 378 p. illIBM redbooks"February 2003.""SG24-6917-00."0-7384-2930-9 Includes bibliographical references and index.Data warehouses in the 1990's were for the privileged few business analysts. Business Intelligence is now being democratized by being shared with the rank and file employee demanding higher levels of RDBMS scalability and ease of use, being delivered through Web portals. To support this emerging e-Business Intelligence world, the challenges that face the enterprises for their centralized data warehouse RDBMS technology are scalability, performance, availability and smart manageability. This IBM Redbooks publication focuses on the innovative technical functionalities of DB2 UDB ESE V8.1 and discusses: - Guidelines on building the large database and determining the number of partitions - Bulk load using the new multipartition load - Performance enhancements using MultiDimensional Clustering and Materialized Query Tables. - Availability through the new online utilities - Self Managing And Resource Tuning features - Migration scenarios This book positions the new functionalities, so you can understand and evaluate their applicability in your own enterprise data warehouse environment, and get started prioritizing and implementing them. Please note that the additional material referenced in the text is not available from IBM.IBM redbooks.Database managementData warehousingElectronic commerceElectronic books.Database management.Data warehousing.Electronic commerce.005.74/068Baragoin Corinne885076International Business Machines Corporation.International Technical Support Center.MiAaPQMiAaPQMiAaPQBOOK9910449793503321Up and running with DB2 UDB ESE partitioning for performance in an e-business intelligence world2255168UNINA