![]() The origin of DB2 The System R project at IBM’s Almaden Research Center in 1976 The first DB2 product was released in 1984 IBM continually enhanced the DB2 product in areas Transaction processing Query processing and optimization Parallel processing Active database support Advanced query and warehousing techniques Object-relational support OverviewĭB2 database engine consists of four code base types Linux, Unix, and Windows z/OS VM OS/400 In this chapter, the focus is on the DB2 Universal Database (UDB) engine that supports Linux, Unix, and Windows The latest version of DB2 is version 8.2, which improves the scalability, availability, and general robustness of the DB2 engine Overview (cont.)ĭB2 provides support for many logical and physical database features using SQL The feature includes constraints, triggers, and recursion using SQL constructs Physical database features such as tablespaces, bufferpools, and partitioning are also supported by using SQL statements DB2 Control Center Includes various design- and administration-related tools Provides a tree-view of a server and its database Allows users to define new objects, create ad-hoc SQL queries, and view query results Database-Design ToolsĭB2 supports a rich set of SQL features for database processing XML featuresA rich set of XML functions have been included in DB2 xmlelement xmlattributes xmlforest xmlconcat xmlserialize xmlagg xml2clob Fig. ![]() They also cover several interesting practical aspects in the design of real systems.Ģ8.1 Overview 28.2 Database-Design Tools 28.3 SQL Variations and Extensions 28.4 Storage and Indexing 28.5 Multidimensional Clustering 28.6 Query Processing and Optimization 28.7 Materialized Query Tables 28.8 Autonomic Features in DB2 28.9 Tools and Utilities 28.10 Concurrency Control and Recovery 28.11 System Architecture 28.12 Replication, Distribution, and External Data 28.13 Business Intelligence Features Bibliographical Notes Chapter 28: IBM DB2 Universal Database.They provide a wealth of interesting information about the respective products, and help you see how the various implementation techniques described in earlier parts are used in real systems.These chapters outline unique features of each of these systems, and describe their internal structure.Part 9: Case studies (Chapters 26 through 29). Appendix C: Advanced RelationalDatabase Model.Chapter 25: Advanced Transaction Processing.Chapter 24: Advanced Data Types and New Applications.Chapter 23: Advanced Application Development.Chapter 20: Database-System Architecture.Part 6: Data Mining and Information Retrieval. ![]() Chapter 11: Storage and File Structure.Part 3: Object-based databases and XML.Chapter 8: Application Design and Development.A free evaluation of FME is available at Chapter 6: Database Design and the E-R Model FME Suite also includes developer tools and coordinate conversion support. It consists of three main components: a translation engine, a transformation editor, and a viewer. “This development brings the power of FME interoperability to DB2 Spatial Extender users.” FME Suite, FME Objects, FME SDP Server, and SpatialDirect users can now easily import/export between DB2 Universal Database and a multitude of database systems and formats.įME Suite is an ETL (Extract, Transform, Load) tool for spatial data. As a result, FME customers can manage spatial data faster and easier with their DB2 Universal Database.”įME continues to provide more and more direct connections between spatial databases,” said Dale Lutz, VP Product Development, Safe Software. Customers can generate, analyze, and exploit spatial information about geographic features, such as the locations of office buildings or the size of flood zones, and integrate that information with any business data to add another element of business intelligence to the enterprise.įME’s powerful spatial ETL (Extract-Transform-Load) capabilities and support for virtually all well-known spatial data formats can now be applied in a direct connection to DB2 Universal Database without going through the import and export of intermediate files,” said Paul Rivot, Director of Database servers and Business Intelligence at IBM Data Management Solutions. The result is a direct connection between DB2 Universal Database and over 100 FME-supported GIS, Computer-Aided Design (CAD) and database formats.ĭB2 Universal Database with the DB2 Spatial Extender enables businesses to store, manage, and analyze spatial data (information about geographic features) with traditional business data. Safe Software announced that it has added support for IBM DB2 Universal Database Spatial Extender to its complete product line, including Software’s Feature Manipulation Engine (FME), FME Objects, SpatialDirect, and FME SDP Server.
0 Comments
Leave a Reply. |