Examples

The Easy, Visual Guide to IBM DB2 V8.2

IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM.

Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.

For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations.

Coverage includes

• Understanding the DB2 product family, DB2 commands, and the DB2 environment

• Configuring client and server connectivity: walkthroughs of four typical scenarios

• Managing DB2 storage: partitions, tablespaces, buffer pools, and more

• Leveraging the power of SQL: queries, inserts, deletes, and updates

• Implementing security: encryption, authentication, and authorization

• Administering and maintaining data, from LOAD and EXPORT to backup/recovery

• Providing high availability with online split mirroring and suspended I/O

• DB2 architecture: process and memory models

• Managing database performance and troubleshooting

ADO (Active Data Objects) is how the millions of Visual Basic programmers hitch onto Microsoft's amazing "Universal Database Access" strategy. But power breeds complexity, and using ADO isn't trivial! This book is based on best-selling author Bill Vaughn's years of experience working with front-line data access developers and the development teams at Microsoft itself. Now, this Microsoft veteran translates his insights and collected wisdom from over a decade at Microsoft into working solutions for the common (and some not so common) data-related problems developers face every day. ADO Examples and Best Practices focuses on addressing data problems at the root - through better designs and better ADO coding practices. These suggestions often yield far better performance - both for the developer (who is able to write better code more quickly), and for the application (it runs faster with fewer resources). William R. Vaughn is currently a Developer Trainer at Microsof! t. He has taught, written, lectured, sold, supported, designed, coded, managed and cried over mainframe and microcomputer systems and software for 28 years. He has been at Microsoft since 1986 and has held positions ranging from writing, teaching and managing trainers at the Microsoft University (MSU) to being Visual Basic Enterprise Product Manager. During his last two years at Microsoft he has been with the Internal Technical Education group teaching Microsoft employees themselves. While there he developed and taught courses on Visual Basic, data architectures, and ActiveX Data Objects (ADO).

The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL.

The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently.

A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.

While most other books merely instruct on basic JSP and servlet development, JSP Examples and Best Practices gives you some of the best practices and design principles, enabling you to build scalable and extensible enterprise Java applications. And JavaServer Pages technology can be used to build complex enterprise applications in a highly re-usable manner.

This book takes basic JSP and applies sound architectural principles and design patterns, to give you the tools to build scalable enterprise applications using JSP. Further, this book covers new features of the JSP 1.2 specification, including the standard filtering mechanism.

Indispensable Patterns and Insights for Putting Mashups to Work in Enterprise Environments

Using new mashup tools and technologies, enterprise developers can impose their own APIs on everything from Web sites and RSS feeds to Excel and PDF files–transforming a world of content into their own customized informationsource. In Mashup Patterns, Michael Ogrinz applies the concept of software development patterns to mashups, systematically revealing the right ways to build enterprise mashups and providing useful insights to help organizations avoid the mistakes that cause mashups to fail.

Drawing on extensive experience building business-critical mashups, Ogrinz offers patterns and realistic guidance for every stage of the mashup development lifecycle and addresses the key issues developers, architects, and managers will face. Each pattern is documented with a practical description, specific use cases, and crucial insights into the stability of mashups built with it. Ogrinz concludes by presenting twelve start-to-finish case studies demonstrating mashup patterns at work in actual enterprise settings.

Coverage includes:

• Understanding the relationships among mashups, portals, SOA, EAI/EII, and SaaS
• Exploring core mashup activities such as data management, surveillance, clipping, transformation, enrichment, publication, and promotion
• Optimizing security, privacy, accessibility, usability, and performance
• Managing mashup development, from planning and governance through integration, testing, and deployment
• Enhancing basic mashups with search, language translation, workflow support, and other improvements
• Performing effective load and regression testing
• Avoiding “anti-patterns” that cause enterprise mashups to fail

Also of interest: The companion book, Mashups: Strategies for the Modern Enterprise by J. Jeffrey Hanson (Addison-Wesley), is an indispensable guide to designing, implementing, and debugging an enterprise mashup, offering sample code to illustrate key concepts.