content:
Introduction DB2 simple history DB2 Today, the technology DB2 technology is the core discount of many solutions! Stable and extensive partnership concluded reference materials about the author's evaluation
subscription:
DeveloperWorks Newsletter
Jeff Jonesibm Data Management Solutions Department, Silicon Valley Laboratory January 2003
If you have just contacted IBM DB2 and Information Management Software, it doesn't matter, this "DB2 Jane" contains information you need to quickly "sail", including historical perspective, instructions, and many help you get started with reference.
Introduction In 1970, the IBM San Jose Research Room E. F. CODD published a paper that created a new method of computer management information. His papers "A RELATIONAL Model of Data for Large Shared Data Banks" proposes a new architecture for storing, managing, and interacting data. This new relationship model allows the application developers to free from the 桎梏 of the need to understand the details of the data being managed. After 4 years, IBM employees don chamberlin and ray boyce published "Sequel: A Structured English Query Language", which became the basis of SQL language standards. Writing problems with new SQL language becomes more important to disk storage and organizational data. This language can ask and answer new problems with more powerful functions. Build applications is much more rapid than ever. The relational database system yourself undertake more data management tasks so that the application has more freedom to focus on business logic. Since 1970, IBM has developed a complete relational database management system (RDBMS) software series (now known as the Universal Database, UDB)). In addition, IBM also uses DB2 as "engine" to construct other information management software, including data warehouses, data analysis, data mining, media asset management, corporate content management, and information integration. DB2 and IBM Information Management (INFORMATION Management) product combination represents a product combination element, IBM is called middleware - that is, a software that acts as a coupling system and software application "adhesive". DB2 is one of the five software brands of IBM. These five brands are: DB2, WebSphere®, Lotus®, Tivoli® and Rational. This article describes DB2 and IBM information management product portfolios. DB2 brief history From the beginning, a series of research projects that have become a solid technical source of DB2 series:
The System R project enables IBM to implement the first relationship model. Cost-based query optimization has always achieved great achievements and innovation from the SYSTEM R era. The R Star project extends the relationship model to a distributed system environment. The Starburst project focuses on the extension relationship model, making it possible to handle new information forms and new optimization policy types. The GARLIC project emphasizes the data federation, allowing data to manage different systems (more than just DB2 systems). Recently, the XPranTo project has demonstrated the integration of web service information and the use of another powerful query language for managing XML content - XQuery. In 1980, the initial SYSTEM R project has achieved relationship technology: integrated into the SYSTEM / 38 server database. In 1982, SQL / DSTM products were used in mainframe operating systems VM and VSE, which is also based on System R. DB2 (official name is Database 2) in MVSTM in 1983. In 1987, the database manager in OS / 2® Extended Edition is the first relational database on a distributed system. SQL / 400® for new AS / 400® servers appears in 1988. The new DB2 version is used for AIX® (1993), HP-UX and Solaris (1994), Windows® (1995) and Linux (1999). DB2 Today, the DB2 series spans a variety of UNIX®, Linux and Windows platforms and IBM iSeriesTM (OS / 400® operating system) and ZSERIESTM (OS / 390®, Z / OS®, Z / VM and Linux) Server series. DB2 EveryplaceTM supports handheld devices and embedded Linux environments and provides data synchronization with larger systems. Provides common tools for the entire series of application development and database management. Innovation from all series and Informix database series acquired in 2001, meeting the development needs of the entire series. Today's DB2 technology solves the needs of emerging customers in several new fields:
Autonomous computing requires servers, operating systems, and middleware (including DB2) to diagnose and correct problems in the case of unintended interference. Database Self-Administration and Automation for Database Administrators is specially emphasized in the latest version of DB2. Standard-based Web services is an application processing style that is a new DB2 full support. Grid calculations, the idea of mass computing resources as utilities or services (including database services), using DB2 large number of scalability, highly available ways to support large databases and a large number of users in the same time. Standard Web Services is another key component of the grid calculation supported by DB2. "E-Business On Demand" business model needs to build an operating environment on open standards to allow fast and cost-effective innovation and reconfiguration. The infrastructure used to support e-commerce that must be reliable and scalable and safe. DB2 is such an infrastructure. In addition to powerful and innovative technologies, DB2 provides high value for all sizes of customers. DB2 pricing in UNIX, Linux, and Windows systems is recognized by industry analysts as half of its main competitor pricing. DBA automation and self-management enhancements are combined with low-cost, providing excellent value for DB2 customers. The purpose of this article is to generally overview a special technical field that is solved by the functionality in DB2. As started at the beginning, SQL shared most of the data management burdens on the shoulders of the application developer, and the various DB2 technologies described here, making today and tomorrow's application developers and database administrators more focused on solving Business problem. For them, this means that it is increasingly relieved from management information technology details. In-depth study The technology DB2 is designed to provide powerful functions for those who have demand. However, people are increasingly attaching importance to availability and development. Let us study technologies that make DB2 outstanding techniques: confirmed performance and scalability management (simpler) The application development and deployment of your own environment has been confirmed to meet the number of supports simultaneous support. The needs of the operating system, as well as high performance and high scalability, DB2 is developed in a manner specific to each environment.
On OS / 390 and Z / OS, DB2 is developed into enhanced functionality with the operating system and server hardware. This is integrated to provide DB2 "Data Sharing" - shared resource groups using IBM System / 390® and ZSeries Parallel Sysplex® hardware architecture. Some of the world's largest databases are built on DB2 in this environment, as mentioned in the large database period in which Winter Corporation. On the operating system of the OS / 400- IBM iSeries server series (originally AS / 400), DB2 is implemented as part of the operating system itself, supports parallel processing and clusters of single servers and multi-servers. On UNIX, Linux, and Windows platforms, DB2 has a "Shared-Nothing" architecture that allows the public code library to be used in all of these environments. The server in the DB2 has no shared cluster works independently and parallel. Transaction (such as TPC-C) and decision support (such as TPC-H) benchmark test results prove that DB2 having such a portable architecture has huge scalability. High availability and scalability of clusters and support for the latest processors and interconnect technology are DB2 to ensure that customers can smoothly develop. DB2 failover and standby support provide high availability today. DB2 supports support for the latest 64-bit processor (Intel Itanium 2 and AMD Opteron) means that a larger database can be constructed and faster performance. A simpler and faster cluster and connection techniques such as InfiniBand make DB2 easier to scale. Customers and developers for all sizes are successfully developed. Management (more simple) economic conditions and improves the bottom line of the bottom line means that due to the increase in the number and type of managed information, there is no resource for additional administrators, so many DBA workloads are becoming more and more serious. DB2 reduces the pressure of database management through a number of methods:
Its Control Center provides a central location for DBA, making them work through the DB2 system network. A group of consultant tools provide professional resource monitoring, problem diagnosis and corrective actions. The latest examples of this is Configuration Advisor, which quickly get the highest DB2 performance in new installations on UNIX, Linux, and Windows. Another example is Health Center, which is a core piece of many recent DB2 self-management. Its rule-based problem diagnostics and corrective measures have added new DB2 Performance Expert and DB2 Recovery Expert tools (a new class of new IBM database tools, providing unprecedented professional guidance and automatic operation). Starting from DB2, it has continued to develop based on cost optimization and automatic query rewriting technology, and continuously unloads the burden on DB2 performance management of database administrators. The goal of each DB2 new version is that the demand for database management resources is less and less. The focus of IBM's focus on autonomous computing has benefited DB2. Application development and deployment of your choice Environment If you are an application developer, you will have multiple options when developing DB2 as a database server. DB2 team strives to make the application development simple. The IBM WebSphere Studio product team and Microsoft Visual Studio team strive to develop plugins for DB2 applications. Recently announced with Borland's cooperation has reached a protocol: Packing DB2 UDB in Borland Development Tool (Kylix, Delphi, C Builder), and the Borland development tool is also packaged in DB2 UDB. In addition, DB2 UDB comes with a development center for building a server-side component, such as stored procedures, and user-defined functions. DB2 has a deep origin to JavaTM. At the end of 1996, Java support was provided in DB2. From this stored procedure and user-defined functions can be fully supported with Java builds, programming interfaces between Java applications and database systems. Thereafter, DB2 Java support technology continues to develop (including SQLJ for DB2 and static SQL communication), and IBM is also involved in Jolap (a Java-based data analysis standard). Management tools written in Java make it possible to use DB2 to perform web-based database management. Also, DB2 fully supports J2EE this application processing environment. At the same time, DB2 developers work closely with Microsoft's Windows and .NET team to ensure that DB2 has become the strong "resident" of the application environment. IBM promises DB2 support J2EE and .NET. DB2 has a powerful commitment to Windows. The evidence of this fact includes DB2 to support it on the first day of customers, and the membership of DB2 in Microsoft Gold Certified Partner Program for Software Products. To reach the Gold Certified state, you want to verify DB2: Server, Advanced Server, and Datacenter Server in three Windows 2000 Server packages. In addition, DB2 provides a high-speed native interface to the Microsoft OLE DB data source. DB2 is currently tracked to support the use of Windows .NET operating systems.
DB2 technology is a strong commitment to research and development of many solutions means that DB2 is the core of numerous information management products and solutions. The fields include: Business Intelligence Content and Record Management Federal and Information Integration Business Intelligence Business Intelligence (Business) Intelligence, BI) Function is built into the DB2 engine, and the BI application places DB2 at its core. Commercial intelligence tools include these areas: data warehouses, data analysis, and data mining. DB2 Data WareHouse Center provides an interface for defining, building, and maintaining a data warehouse. DB2 Warehouse Manager also provides information Catalog for managing warehouse metadata and tools for reporting and managing complex queries execution operations. Online Analytic Processing (OLAP): ONLINE Analytic Processing, OLAP:
DB2 provides built-in functions for Cube and Rollup (used to study the popular OLAP operations of information in the database). There is also a library that contains statistical analysis functions such as Rolling Sum and Rolling Average and the aggregate function. IBM and Hyperion cooperate to create DB2 OLAP ServerTM, which is a complete OLAP solution built on Hyperion EssBase. The latest version of DB2 OLAP Server is built on DB2 UDB while providing multi-dimensional data storage and relational data storage. Mixed analysis (combined with multi-dimensional storage speed and rendering storage) and automatic deviation detection (data mining) of data in OLAP 3D data, is the latest version of DB2 OLAP Server. IBM also works with various data analysis software vendors that allow them to use DB2 databases. Another and partner ESRI called DB2 SPATIAL EXTENDER-known analysis tools, extended DB2 SQL language to understand certain concepts, such as the distance between the points or defined areas "or" "The relationship between it. Data mining represents the cutting-edge field of business intelligence. Data mining is the process of discovering data patterns that cannot be found in other ways. Cluster information technology based on important attributes and predictable customer behavior of customer behavior is two examples of data mining. As early as 1996, IBM has provided DB2 Intelligent Miner. Its algorithm is prepared and converted to mining data, performing mining operations and visual mining results. In 2001, these functions were implemented in DB2 as a "Scoring Service". The scoring service enables data mining of the small segment data using SQL in real time. Today, DB2 Intelligent Miner Modeling, Visualization and Scoring are optional features of DB2. Some new features of DB2 UDB are designed to benefit customers with DB2 as business intelligence. Multi-Dimensional Cluster is physically stored on the same disk physically stored for a quick retrieval. The instantiated query table provides significant faster performance for complex queries that require a large number of different data source information. Empty data or default data reduces disk storage requirements for data warehouses and other forms of databases. Content and record management information management future includes managing and joint various structured and unstructured information to address business issues. DB2 traditionally focuses on managing structured data - ie rows and columns represented by numbers and letters. Another part of the IBM information management software product portfolio focuses on managing "content", or is an image and other multimedia information, a text processing document, and a non-structured information such as a computer generated report. Content Manager and Enterprise Information Portal have met the customer's demand for content management solutions. They are built on DB2. Content Manager provides support for both content management: Media asset management and corporate content management. Media asset management is a business that stores and manages a large number of large multimedia objects. Clients include art gallery, university music database and television broadcasting agencies. Enterprise Content Management is the second content management, including a large number of smaller objects such as scanning check images. If it is used for banks, there is a business such as banknotes, invoices, and reports. Enterprise Information Portal (EIP) provides programming layers on Content Manager and other structured or unstructured data sources, with the purpose of accessing and searching in all these sources using a common interface. For example, all information about a particular customer can be retrieved without having to consider the data type or document type.
EIP also provides web search, workflow management and information excavation services. Cooperation development with partners Tarian Software, and subsequent mergers and acquisitions to Tarian, generated IBM Records Manager. This product adds electronic record retention capabilities and lifecycle management to IBM content management product portfolios. The core of the Federal and Information Integration IBM Information Management Software is the belief supported by customer needs: information in integrated heterogeneous data environments is important than centralized information in a single large database system, and can get IT investment faster Profit returns. DB2 and related information management software will reflect this belief in integration and federation. DB2 supports a wide range of ways access to remote information. These methods include ODBC and JDBC, SQLJ, and OLE DB. DB2 supports .NET (Microsoft) and J2EE (Java) application environments. Since 1995, IBM provides information on information in non-DB2 databases (such as those from Oracle, Microsoft, and Sybase Database). DB2 applications can use DB2 SQL to query information in DB2 and non-DB2 databases. This combination of different relational databases develops from DB2 DataJoiner to DB2 features called DB2 RELATIONAL Connect. DB2 also provides data replication technology. Support log-based change acquisition and new replication in the entire DB2 series. DB2 DataJoiner's heterogeneous function and DB2 data replication combinations means that non-DB2 databases can also be replicated targets and / or sources. Today, DB2 can manage a variety of types of information. Build DB2 ExtendersTM to manage text, XML, image, audio, video, and spatial information. These extenders are the results of DB2 from pure relationship systems - the results of the relational system. These years, DB2 applications available data sources have been extended, including WebSphere MQ message queues and standard web services. DB2 can manage data in the file system, as if it is stored in the DB2 table, this is achieved by DB2 Data Links Manager. DB2 application uses SQL operation DB2 data inside and outside the table. XML is increasingly used as a method of describing, organizing, and exchange information, making various XML support enhancements in DB2. Today, more than 100 SQL language extensions are implemented in DB2 to support the management of XML data. DB2 XML Extender provided to customers in 1999, providing the foundation of this unit XML data management. The latest enhancements include automatic mode verification of XML documents consisting of data in DB2 and using XSLT for automatic style conversion. DB2 also supports SQLX publishing and XPath expressions, and in early 2002, it demonstrates support for XQuery through a public prototype. DB2 is gradually become a true bilingual database while supporting SQL and XQuery. These various federal and integrated technologies, as well as new software package technology, have become DISCOVERYLINK® - an information management solution for the life science industry. DiscoveryLink enables life science applications to use SQL connections from a completely different source information, which is unique to the industry (eg, chromosome file data, toxic electronic form, clinical trial, and regulating text, as well as test results database). Depending on the data type, data source, and connection mode supported by DB2 and SQL language, it can be proved that DB2 is the only information integration engine that satisfies the requirements.
Combine this performance with the content management functions mentioned earlier, then IBM can help customer integration information (no matter what type, how much or any location) has become very clear. Multi-affordable! As the technical function described above is the price of DB2 to customers. The pricing of DB2 puts a challenge for competitors at all levels. For the sake of simplicity, the pricing of DB2 is largely based on each processor model. In terms of high availability settings, DB2 is priced only in accordance with only one processor's idle alternate server. Comprehensively consider price factors and enhanced self-management functions and rich features, then the total cost (TCO) advantage is very obvious. In the report of several industry analysts, DB2 has been recorded in the TCO advantage of DB2 in its competitors in five years. Stable and extensive partnership partners recognize the technical strength and high value of DB2. Business application partners (including SAP, Siebel, PeopleSoft, I2, and J. D. Edwards) have multiple ways to choose from by standardizing their applications based on DB2. In many cases, they promote their sales performance through applications on DB2. Because IBM is only focused on providing intermediates and does not provide application software, our partners will not be threatened by IBM because they work together with IBM. IBM Information Management Operates a comprehensive partner program to attract and retain tools, applications, and a wide range of business partners. Our partners also include IBM Server Sector and other IBM software brands (WebSphere, Tivoli, Lotus, and Rational). DB2 developers cooperate with the server group team during DB2 development and benchmark testing. WebSphere integrates DB2 to manage information in applications, databases, users, and other resources they control. One versions of WebSphere Commerce Analyzer include DB2 Intelligent Miner technology. DB2 is provided with WebSphere Application Server supports support for standard Web services. Lotus plans to extend NOTES® and DOMINOTM scalability by integrating DB2. DB2 is a system resource that is managed in Tivoli. There are some examples of increasingly enhanced integration in IBM middleware and server product portfolio, which produces faster high-performance e-commerce applications deployment. Conclusion Structured data to unstructured content, from hand-held devices to cluster server configuration, and from transaction workload to data mining, DB2 and IBM information management software product portfolio with customers in e-commerce development and success Constantly support them. IBM information management software can prepare advanced technologies and strategies for customers, such as web services, grid computing, and e-commerce on demand. 2003 is the 20th anniversary of the DB2 FOR MVS method, and the development of DB2 in the database market fully explained: IBM information management investment and strategy conducted by IBM customers around the world has been successful. References You can get a wonderful summary of DB2 for Linux, UNIX, and Windows features from the following Website: You can see this article in our website in our world. Http://ibm.com/software/data/DB2/UDB /FEATURES.HTML The following this book is a bit outdated, but it is still the best DB2 introduction:
Chamberlin, don. A Complete Guide to DB2 Universal Database. Morgan Kaufmann Publishers, August 1998. About the latest news about total cost:
DH brown associates. IBM DB2 Universal Database v8.1 vs. Oracle 9ir2: Total Cost of Ownership. November 2002. Located http://www.ibm.com/software/data/pubs/pdfs/dhbrown.pdf interesting SQL starting history perspective: McJones, Paul, Ed. THE 1995 SQL Reunion: People, Projects, And Politics. SRC Technical Note 1997-018, 1997. Located at http://www.mcjones.org/system_r/sql_reunion_95/sqlr95.html Bibliography of The System R Project, located at http://www.mcjones.org/system_r/bib.html covers Linux, UNIX and Windows All the books in DB2 7.2 are:
Roman B Melnyk and Paul C. Zikopoulos. DB2: The Complete Reference. Mcgraw-Hill Osborne Media, October 2001. Very good mainframe DB2 overview:
An Introduction to DB2 for OS / 390 V7, located in http://publib.boulder.ibm.com/cgi-bin/bookmgr/books/dsnith12/ccontents DB2 Developer Garden - DB2 and Data Management Products Technical Reference Website:
Http://www.ibm.com/software/data/developer Journal:
DB2 Magazine, located at http://www.db2mag.com iDug Solutions Journal, is located at http://www.idug.org/journal/index.cfm Development Technology Base Camp:
http://www.ibm.com/software/data/education.html
About the author Jeff Jones is a senior program manager for the Data Management Solutions - DB2 General Database "Birthplace". He served as a spokesperson for the IBM's data management software product portfolio for customers, press and industry analyst, and also served as the editor of DB2 MAGAZINE. He has experience in IBM, personnel and management work in IBM. Before he serves current position, Jeff is the brand manager of IBM data replication and database system management middleware. He also worked in the DB2 for OS / 390 product team, IBM Research Department (Research Division) and analyzed projects and IBM Storage Systems engineering and logistics applications. Jeff is now working in the IBM Silicon Valley Laboratory of San Jose, California.
