This book covers everything you need to get productive with the latest version of IBM DB2 and apply it to today's business challenges. It discusses key features introduced in DB2 Versions 10.5, 10.1, and 9.7, including improvements in manageability, integration, security, Big Data support, BLU Acceleration, and cloud computing. This book is for anyone who plans to work with DB2, including DBAs, system administrators, developers, and consultants. It will be a great resource whether you're upgrading from an older version of DB2, migrating from a competitive database, or learning your first database platform.
If you are looking for a practical DB2 book that focuses on application programming, this is the book for you. Written from the programmer's point of view, it will quickly teach you what you need to know to access and process DB2 data in your COBOL programs using embedded SQL. This second edition has been thoroughly updated and expanded to make it even more valuable to the programmer who is slugging it out on the job. You will learn: the critical DB2 concepts that let you understand how DB2 works; the basic DB2 coding features you will use in every program you write; how to use version 4 enhancements like outer joins and explicit syntax for inner joins; how to work with column functions, scalar functions, and subqueries to manipulate data; how to use error handling techniques and ROLLBACK to protect DB2 data; why program efficiency is vital under DB2... and more.
DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for DB2 v9 and v10. Mullins fully covers new DB2 innovations including temporal database support; hashing; universal tablespaces; pureXML; performance, security and governance improvements; new data types, and much more. Using current versions of DB2 for z/OS, readers will learn how to: * Build better databases and applications for CICS, IMS, batch, CAF, and RRSAF * Write proficient, code-optimized DB2 SQL * Implement efficient dynamic and static SQL applications * Use binding and rebinding to optimize applications * Efficiently create, administer, and manage DB2 databases and applications * Design, build, and populate efficient DB2 database structures for online, batch, and data warehousing * Improve the performance of DB2 subsystems, databases, utilities, programs, and SQL stat DB2 Developer's Guide, Sixth Edition builds on the unique approach that has made previous editions so valuable. It combines: * Condensed, easy-to-read coverage of all essential topics: information otherwise scattered through dozens of documents * Detailed discussions of crucial details within each topic * Expert, field-tested implementation advice * Sensible examples
The World Wide Web has become an extremely popular way of publishing and distributing electronic resources. Though the Web is rich with information, collecting and making sense of this data is difficult because it is rather unorganized. Building an Intelligent Web introduces students and professionals to the state-of-the art development of Web Intelligence techniques and teaches how to apply these techniques to develop the next generation of intelligent Web sites. Each chapter contains theoretical bases, which are also illustrated with the help of simple numeric examples, followed by practical implementation. Students will find Building an Intelligent Web to be an active and exciting introduction to advanced Web mining topics. Topics covered include Web Intelligence, Information Retrieval, Semantic Web, Classification and Association Rules, SQL, Database Theory, Applications to e-commerce and Bioinformatics, Clustering, Modeling Web Topology, and much more!
Oracle is an enormous system, with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. "Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation
IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find: A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.
This comprehensive book gives Microsoft SQL developers what they want: a detailed reference with lots of code and real-world examples. And it's just in time for the biggerst database server product to hit the shelves in years--Microsoft SQL Server 7.0. Topics include SQL Server functions, database setup and connectivity, naming conventions; and standards, guidelines, and tips for developing MS SQL Server objects.
IBM's Best-Selling Guide to XPages Development–Now Updated and Expanded for Lotus Notes/Domino 9.0.1 XPages instantly revolutionized Notes/Domino application development, and the newest versions deliver unprecedented performance and flexibility. Now, the popular insider's guide to XPages development has been updated and expanded to reflect all these improvements, through IBM Notes/Domino 9.0.1 and beyond. Three key members of the IBM XPages team have brought together comprehensive knowledge for delivering outstanding solutions. They have added several hundred pages of new content, including four new chapters. Drawing on their unsurpassed experience, they present new tips, samples, and best practices reflecting the platform's growing maturity. Writing for both XPages newcomers and experts, they cover the entire project lifecycle, including problem debugging, performance optimization, and application scalability. This second edition of Mastering XPages fully addresses enhancements to the XPages data sources for Domino views and documents; the latest XPages mobile library; the new Domino Designer Server-Side JavaScript debugger; and improvements to integrated technologies such as Dojo and CKEditor. Nearly every chapter contains at least one downloadable sample application, offering extensive hands-on practice. This guide concludes with complete references to XSP tags, relevant Java/JavaScript classes, and XSP style classes. Coverage includes * Understanding XPages' development paradigm, tooling, runtime framework, and application architecture * Configuring Domino Designer and integrating XPages Extension Library * Constructing application logic and using data binding controls * Reading/writing Notes documents: from use cases to design properties * Using Views, including examples of accessing calendars via REST * Making the most of Notes/Domino 9.0's new DataView control * Coding: from the basics to fully customized behavior * Advanced scripting: AJAX, Dojo, @Functions, managed beans, and more * Extending the Rich Text Editor's functionality * Building and consuming new controls with Extensibility APIs * Taking web applications offline in the Notes client * Building mobile apps: controls, design patterns, and best practices * Debugging Server-Side JavaScript with Domino Designer 9.0 * Creating apps that look and work great–for local and global audiences * Systematically optimizing performance and scalability * Protecting data and users: leveraging Domino and Notes security models
SQL for DB2 ISBN: 978-1-58304-123-9 This focused, comprehensive textbook provides start-to-finish coverage of SQL for DB2. Whether youre a college student studying SQL for DB2 for the first time or a professional developer who needs to learn SQL for DB2, this book covers all the basics necessary for success. The purpose of any database book is to learn how to develop databases effectively and precisely without the need for a lot of complicated jargon. This book delivers on that promise by focusing on the skill set necessary to develop well-designed DB2 databases. SQL for DB2 covers the core requirements of a traditional database course. Topics are presented in an accessible, easy-to-learn manner with numerous examples and tips. End-of-chapter materials include a chapter summary, list of key terms, and hands-on exercises that put the concepts to work. SQL for DB2 builds on the foundation of its widely acclaimed predecessor, SQL/400 Developers Guide, to provide an up-to-date introduction to SQL for DB2 for todays students and professionals. All chapters have been refreshed, with improved organization throughout. Examples have been updated, and new material has been added. This new edition includes: New chapters introducing DB2 and System i Navigator Expanded coverage of single- and multiple-table queries Expanded coverage of updating databases with SQL An expanded discussion of normalization Table of Contents Chapter 1 Introduction to DB2 Chapter 2 Introduction to SQL Chapter 3 Single-Table Queries Chapter 4 Introduction to Data Modeling and Database Design Chapter 5 Logical Data Modeling Chapter 6 Entity Relationship Diagram Chapter 7 Normalization Chapter 8 Physical Database Design Chapter 9 Database Constraints Chapter 10 Multiple Table Queries Chapter 11 Views and Indexes Chapter 12 Updating Tables Chapter 13 Static and Dynamic Embedded Statements Chapter 14 SQL Cursors and Result Sets Chapter 15 The Create SQL Program Command Chapter 16 Using SQL in RPG Programs Chapter 17 Triggers Chapter 18 Additional SQL Topics Chapter 19 Database Security and Grant and Revoke Statements