PostgreSQL is the world¿s most advanced open-source database. PostgreSQL is the most comprehensive, in-depth, and easy-to-read guide to this award-winning database. This book starts with a thorough overview of SQL, a description of all PostgreSQL data types, and a complete explanation of PostgreSQL commands. If you are a developer or an administrator, you¿ll love the chapter that explores PostgreSQL performance. The authors explain how PostgreSQL stores data on disk (and in memory) and how to measure and influence the effectiveness of PostgreSQL¿s caching mechanisms. You¿ll also learn how PostgreSQL generates and evaluates execution plans. The authors explain all of the query operators that can appear in the results of an EXPLAIN command, describing the performance implications of each operator as well as the conditions which will cause PostgreSQL to use that operator. PostgreSQL is also a complete guide for the developer. Whether you¿re developing with C, C++, ODBC, Embedded SQL, Java, Tcl/Tk, Perl, Python or PHP, you¿ll find a comprehensive description of the PostgreSQL API for your language of choice. Easy to follow exercises will walk you through the development of working applications that fully demonstrate the features offered by each API. You will also find a chapter that describes the PL/pgSQL server-side procedural language, learning how to build triggers, functions, and stored-procedures. The authors have even included a chapter that walks you through the process of extending the PostgreSQL server with custom-written C functions and new data types. The accompanying web site, www.conjectrix.com, contains downloadable versions of all of the sample code and a wealth of PostgreSQL-related resources. The last section of PostgreSQL was written for the PostgreSQL administrator. You will learn how to install PostgreSQL on Windows, Linux, and Unix systems, from source code or from pre-compiled installers. The authors have described all of the PostgreSQL configuration options (compile-time, startup, and on-the-fly). The chapter on PostgreSQL security describes all of the authentication protocols that you can choose from and describes how to secure your database, both internally and externally. If you have to support a multi-national environment, you will find the chapter on internationalization and localization to be invaluable. You won¿t find a more complete guide to PostgreSQL anywhere. The authors have made PostgreSQL approachable by leading the reader from basic concepts to advanced features. Whether you¿re a database beginner or an advanced user, you will find this book a valuable addition to your library.

Microsoft Access 2002 is a powerful, relational database software package that makes it easy to create and manage complex databases. With Access, users can create a database quickly from scratch or by using an Access database Wizard. Once the database is created, Access provides all the tools needed to enter and manipulate data. With the help of the Absolute Beginner's Guide, readers are able to quickly start a new database by using the Database Wizard, create tables from scratch or by using a Wizard, add and edit database information by using both tables and forms and manipulate data in a number of tables by using queries and reports. The book assumes absolutely no prior knowledge of the topic, and learning is easy because of the book's lighthearted but no-nonsense style. It serves as an excellent resource for users who are completely new to Access 2002 or who are upgrading from a previous version of the software.

Like most PL/SQL programmers, you've found Oracle PL/SQL Programming to be a reference book you can't do without. Packed with examples and recommendations, it's a book that has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. But you can't always carry it with you, and even at your desk there are times when you just need a reminder, a quick answer to a problem you're up against. For times like those, PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes have written a new edition of Oracle PL/SQL Language Pocket Reference. Updated for Oracle9i, this little book is easy to take with you and use anywhere for quick problem solving. The second edition of the Oracle PL/SQL Language Pocket Reference boils down the most vital information from Oracle PL/SQL Programming into a convenient quick reference to PL/SQL basics. This compact book will be indispensable for new and seasoned Oracle database developers alike. It summarizes features available in Oracle9i and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java classes from PL/SQL. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.

The IBM TotalStorage Expert V2R1 is the rebranded name for the IBM Storwatch Expert. It provides all the function in the StorWatch versions you have come to rely on - and then some. The IBM Total Storage Expert is made up of two component features: Enterprise Storage Server (ESS) Expert and Enterprise Tape Library (ETL) Expert. IBM TotalStorage Expert helps storage administrators boost the productivity of storage resources. It gathers and presents information that helps administrators manage the Enterprise Storage Server (ESS) and three Enterprise Tape Library (ETL) solutions: IBM TotalStorage Enterprise Automated Tape Library, IBM TotalStorage Virtual Tape Server, and IBM TotalStorage Peer-to-Peer Virtual Tape Server. The TotalStorage Expert prepares reports and graphical charts from the data it has collected. These reports and charts can be used in managing assets, capacity, and performance for your ESSs and ETLs. This IBM Redbooks publication will help you to install, tailor, and configure the TotalStorage Expert, and will show you how to use TotalStorage Expert.

Steven Holzner's friendly, easy-to-read style has turned this book (formerly known as Inside XML) into the leading reference on XML. Unlike other XML books, this one is packed with hundreds of real-world examples, fully tested and ready to use! Holzner teaches you XML like no other author can, covering every major XML topic today and detailing the ways XML is used now--connecting XML to databases (both locally and on web servers), stying XML for viewing in today's web browsers, reading and parsing XML documents in browsers, writing and using XML schemas, creating graphical XML browsers, working with the Simple Object Access Protocol (SOAP), and a great deal more. Real World XML is designed to be the standard in XML coverage--more complete, and more accessible, than any other. "The author's approach is definitely bottom up, written in a highly personable tone. He makes efficient use of example code, which sets this book apart from many I have read in the past. His examples bring to life the code without overwhelming the reader, and he does not present any examples for which the reader has not been prepared. In addition, no prior knowledge of XML is assumed. As such, this is an excellent book for both beginners and intermediate level web designers and programmers. Experts, too, will find this book of value, due to its emphasis on real world applicability. Overall, this book will benefit all web developers and programmers, with a special emphasis on beginner and intermediate developers."--Donna A. Dulo, MS, MA, Senior Systems Engineer, U.S. Department of Defense "This book will provide a brilliant basis for anyone wishing to keep up to speed with the new XML developments."--Mr. Andrew Madden, Department of Computer Science, University of Wales "I found this book's strengths to be: its exhaustive specification reference for the conscientious developer; access to the official specs, which is key; the wide variety of choices provided for all aspects of XML; several alternatives provided for each editor, browser, parser, stylesheet transform engine, and programming language; and working examples that show the power of the tools used."--Jaime Ryan, Software Developer/Documentation Manager, Blue Titan Software

The first comprehensive guide to building and deploying mobile location-based services Detailed coverage of mobile location servers, client platforms, protocols, and standards Mapping, geocoding, mobile positioning, security, personalization, privacy, and more Foreword by Joe Astroth, Executive Vice President, Autodesk Location Services "I expect this comprehensive book to inspire a new generation of engineers and to help propel a new wave of independent software vendors. I only wish it was available to our staff as we developed some of our earliest services." —Joe Astroth, Executive Vice President, Autodesk Location Services The first start-to-finish guide to developing location-based services. Tomorrow's mobile applications must be smarter than ever, accessing and intelligently using a wide range of location data. In Mobile Location Services, leading mobile application consultant Andrew Jagoe presents the first end-to-end solutions guide to building and deploying location-based services and applications. Jagoe addresses every key development challenge and presents insightful case studies and interviews with key industry leaders. Mobile location servers and the components of an end-to-end location-based solution Spatial analysis: digital mapping, geocoding, routing, map image generation, and point-of-interest searches Mobile positioning: using and augmenting GPS technology Authentication and security in location-based applications Personalization, profiling, and privacy Mobile location clients: platform, protocols, languages, and localization issues Key applications: navigation, emergency assistance, travel services, advertising/marketing, and more Includes detailed appendices on the Geography Markup Language (GML), the Location Interoperability Forum's Mobile Location Protocol, and P3P privacy standards CD-ROM INCLUDED The accompanying CD-ROM contains several useful tools for developing mobile location services, as well as a list of important resources on the Internet.

This IBM Redbooks publication introduces the new Geac commerce platform .connect applications -- the call.connect and vendor.connect applications. These applications extend and enhance the capabilities of Geac System21 into the intranet and Internet. This book targets consultants or customers who work with these .connect applications. It explains how to install, maintain, integrate, and manage these applications on the IBM eServer iSeries server. It also helps you to understand the architecture and middleware used by the applications. Prior to reading this book, you must be familiar with the basic, traditional use of the iSeries or AS/400 and System21. For example, you should know how to enter simple commands and understand such concepts as the library list. Similarly for System21, you should be familiar with the menus and such tasks as defining a System21 user. As necessary throughout the book, detail is provided about the newer, less traditional features of the iSeries such as the integrated files system (IFS), Qshell, Java, and WebSphere.

Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference. Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes: Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options. Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database. Oracle Tools--Commands provided with SQLPlus, SQLLoader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack). Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.

The hands-on, rapid-mastery guide to Oracle PL/SQL Web development. Start building Oracle 9i PL/SQL Web applications—hands on Covers the entire development lifecycle, from design to deployment Provides instruction for PL/SQL Server Pages, the PL/SQL Web Toolkit, and the Oracle 9i Application Server Introduces Web basics—HTML, JavaScript, basic UNIX and FTP, and image handling Reviews PL/SQL and SQL concepts Includes practical tips and troubleshooting help Leverage your SQL and PL/SQL experience to build powerful data-driven Web and e-business applications—starting right now! In this book, a team of Columbia University PL/SQL instructors cover the core pieces of what you need to know, from preliminary configuration to deployment of dynamic, data-driven applications. You'll find practical examples, hands-on exercises, and dozens of practical tips and solutions designed to save you time, effort, and frustration. One step at a time, discover how to: Configure Oracle's Internet Application Server Control Web applications and servers remotely Build Oracle Web applications with PL/SQL Create dynamic, data-driven pages Test, debug, troubleshoot, and deploy your applications Maintain and optimize running Web applications Whether you've been writing simple queries or complex PL/SQL code, this book takes your database development skills onto the Web—and into the future!

Open Source technologies are providing contemporary developers with a range of cost-effective and robust alternatives to commercial software for building dynamic, data-driven Web applications. This practical guide presents a comprehensive survey of LAMP (Linux, Apache, MySQL, Perl, and PHP), and it shows how these solutions can be implemented efficiently and securely while improving reliability and dramatically cutting costs. focuses on the most important core material necessary so that developers can "hit the ground running" and begin building applications right away. This book presents a balanced overview of LAMP technologies and allows the reader to decide which tool may be appropriate for the particular task at hand. After a general overview of Open Source technologies, the book presents an overview of the Web before moving on to cover structural, static, dynamic, and embedded technologies. The coverage here provides a description of the strengths and weaknesses of each Open Source technology and also acts as a reference guide for each application. Open Source Web Development with LAMP Topics covered include: A comprehensive survey of Open Source technologies Static and dynamic data and embedded HTML on the Web Linux and Unix distributions, installations, and commands Apache Web Server, Perl, and MySQL Web site META language (WML) Common gateway interface (CGI) and mod_perl Server Side Includes (SSI), Embperl, and Mason PHP syntax and functions In addition to the discussions in the book, a companion Web site--www.opensourcewebbook.com--contains supplemental information, including tools, source code, helpful links to additional resources, and errata as needed. Complete in coverage and practical in presentation, spotlights the tools and technologies today's developers need to create workable, dynamic, and secure Web sites using Open Source technologies. Open Source Web Development with LAMP 020177061XB11072002

MySQL is the most widely installed open-source database. Approximately 3.5 million MySQL servers are in use and more than 45% of databases used on Linux worldwide are MySQL databases. Its latest version, MySQL 4.1 closes the gap between MySQL and other, more sophisticated databases. Version 4.1 permits the use of MySQL as an embedded database, which means it can be compiled into another application and used in a range of devices. The second edition of Sams Teach Yourself MySQL in 21 Days has been completely rewritten by a new author. The book enables a reader to create powerful databases using MySQL. He willnot only learn how to integrate MySQL into a database-driven Web site, but also how to embed MySQL into other compiled applications.

Critical for converting XML documents, and extremely versatile, the XSLT language nevertheless has complexities that can be daunting. The XSLT Cookbook is a collection of hundreds of solutions to problems that Extensible Stylesheet Language Transformations (XSLT) developers regularly face. The recipes range from simple string-manipulation and mathematical processing to more complex topics like extending XSLT, testing and debugging XSLT stylesheets, and graphics creation with SVG. Recipes can be run directly or tweaked to fit your particular application's needs more precisely. Each recipe walks through a problem and a solution, with explanations of the choices made and techniques used in creating that solution, and many recipes include alternate solutions and explore issues like convenience and performance. Topics covered include: String manipulation Mathematical processing Date and time handling Interactions between calendar systems Selecting content in source documents Efficient tree-manipulation Conversions from XML to plain text Tweaking XML documents with stylesheets Using XSLT to query XML documents Generating HTML with XSLT Creating charts and graphs with SVG and XSLT Generating C and XSLT code using XSLT Processing Visio documents in XSLT Working with XML Topic Maps (XTM) Using XSLT to create SOAP documentation from WSDL Extending XSLT with additional functions Embedding XSLT in other processing Testing and debugging XSLT stylesheets Creating generic XSLT processors which work on many XML vocabularies The XSLT Cookbook provides an ideal companion both for developers still figuring out XSLT's template-based approach who want to learn by example, and for developers who know XSLT and want a collection of quickly reusable recipes. XSLT frequently offers a number of ways to perform a transformation, and the best solution may not always be the most straightforward. The recipes in this Cookbook demonstrate and explain XSLT's template-based logic, a frequent stumbling block for developers new to XSLT. Among the variety of XSLT books now available, none has the explicit solution-oriented approach of this Cookbook.

Sams Teach Yourself PHP, MySQL, and Apache in 24 Hours combines coverage of three popular open-source Web development tools into one easy-to-understand book -- and it comes with one easy-to-use Starter Kit CD-ROM for Windows or Linux. You will learn to install, configure and set up the PHP scripting language, the MySQL database system and the Apache Web server. By the end of the book, you will understand how these technologies work, and -- more importantly -- how they can work together to create a dynamic Web site. After creating a simple website using these tools, you will be able to manage a simple mailing list and create an online address book, shopping cart and storefront. You will also know how to fine tune Apache and MySQL and cover simple Web server security.

If you recently upgraded to FileMaker Pro 6 to take advantage of its new digital image management features or its full XML support, you'll also want to upgrade to FileMaker Pro 6 for Windows and Macintosh: Visual QuickStart Guide. Revised to include all of the new features in FileMaker Pro 6, this update to the popular Visual QuickStart Guide is still the fastest and easiest way to learn FileMaker Pro. Loaded with screenshots and clear, concise explanations of database publishing techniques, FileMaker Pro 6 for Windows and Macintosh: Visual QuickStart Guide takes you from working with records and files to creating and designing databases, printing and networking with FileMaker, and Web publishing with FileMaker in no time. Step-by-step tasks show you how to use new digital image management features to organize and work with massive amounts of digital photos with minimal effort. You'll also learn to take advantage of FileMaker's new XML support to easily share and integrate data with other applications-even those not running FileMaker.

IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and z/OS platforms An official IBM self-study guide for the DB2 UDB V7.1 Family Application Development Exam (#514) Expert DB2 programming tips, techniques, and guidelines from application development experts Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and more CD-ROM contains complete DB2 application development sample exam The definitive, authoritative guide to DB2 OS/390 application development certification Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and much more Includes a full section on object-relational programming and other advanced techniques Sample test questions help you prepare for the IBM DB2 UDB V7.1 Family Application Development Exam (#514) About the CD The CD-ROM included with this book contains a complete DB2 UDB V7.1 Family Application Development Exam (#514) sample exam. IBM DB2 UDB Version 7.1 for OS/390 and z/OS delivers unparalleled performance, scalability, and reliability in today's enterprise business environments. Now, there's a complete, authoritative guide to developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for the IBM DB2 UDB V7.1 Family Application Development Exam (#514). This comprehensive day-to-day guide to DB2 UDB application development is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging application development exam for the OS/390 and z/OS platforms. IBM Gold Consultant Susan Lawson presents hundreds of useful tips, practical techniques, and expert guidelines for every facet of DB2 UDB application development and every stage of the development process for both OS/390 and z/OS platforms Coverage includes: Foundations for effective DB2 development, including an overview of the DB2 UDB product family and DB2 for OS/390 data structures SQL: basic concepts and coding techniques through advanced OLAP features, star schemas, and star joins Stored procedures, including the SQL procedure language and IBM's Stored Procedure Builder Best practices for application testing, debugging, and performance tuning The full range of DB2 development tools, including ODBC/CLI, Java(tm), COBOL, C, C++, REXX, CAF, CICS, and RRSAF Object-relational programming, including user-defined functions, user-defined data types, and triggers In-depth coverage of locking and concurrency Whether you're developing for DB2 UDB V7.1 in an OS/390 or z/OS environment, managing DB2 UDB V7.1 application development, preparing for DB2 UDB V7.1 Family Application Development, or all three, DB2 UDB for OS/390 Version 7.1 Application Certification Guide will be your single most valuable resource. IBM DB2 Series

XML Web services are the next logical step in the evolution of the Internet. Teach yourself how to write and deploy XML Web services for Microsoft® .NET?one step at a time—with this modular, accessible tutorial. It delivers expert, task-based instruction plus a real-world XML service example to help you apply what you already know about Microsoft Visual C#™, Microsoft Visual Basic® .NET, and object-oriented programming so that you can learn XML Web services development at your own pace.

The start-to-finish guide to building enterprise-class VoiceXML applications. Code examples and UML diagrams provided for each VoiceXML element Fully developed VoiceXML applications using Java servlets, JSP, and .NET Detailed coverage of text-to-speech and automatic speech recognition technologies "XML is not a spoken language, but thanks to VoiceXML, it is the language of choice for developing spoken interfaces. If you want to voice-enable your applications and Web sites, this book speaks your language." —Charles F. Goldfarb Definitive VoiceXML bridges the gap between enterprise computing and telephony engineering, demonstrating exactly how to build new enterprise-class voice applications and voice-enable existing applications. It's the first book that delivers the depth and breadth of knowledge needed by both enterprise and telephony developers, thoroughly addressing the unique challenges of building voice systems for business. VoiceXML in depth: its role, goals, and key techniques Effective ways to architect and integrate enterprise voice applications Detailed case studies utilizing VoiceXML, Java servlets, JSP, and .NET Thorough coverage of the W3C VXML 2.0 standard Speech Recognition Grammar Format (SRGF) and Speech Synthesis Markup Language (SSML) Complete VoiceXML language reference Whether you're developing systems for customer service, finance, travel, wireless commerce, or anything else, Definitive VoiceXML gives you the proven techniques you need to maximize performance, reliability, and ROI. Part of The Charles F. Goldfarb Definitive XML Series

"Contextual collaboration" is a new term whirling in the industry today. This phenomenal new type of business asset can be realized by two major mechanisms: the components managing mechanism and the services delivery mechanism. The component managing mechanism deals with calendar, workflow, messaging, e-mail, and so on, while the services delivery mechanism deals with receiving and responding to a request. In terms of IBM product offerings, we have Domino for the component managing mechanism and WebSphere for the services delivery mechanism. We need standards to connect the applications from different business entities: your customers, your suppliers, your business partners, and you. These business entities may run their business applications on different platforms, different application languages, different networks, and so on. To connect these un-identical entities together, we need standards. For that, we have Web Service standards such as SOAP, WSDL, XML, and UDDI. This IBM Redbooks publication provides real application scenarios which illustrate how to transform existing Domino applications into either a Web Service provider or a Web Service requester. This is achieved and served through the integration of Domino and WebSphere Application Server.

IMS DataPropagator (IMS DPROP) is a licensed program that maintains consistency between two copies of the same data, where one copy of the data is stored in an IMS Database Manager (IMS DB) database and the other copy is stored in a DB2 database. IMS DPROP is a key component of IBM's Data Replication Solution and IBM's Business Intelligence Solution. Please note that the additional material referenced in the text is not available from IBM.

The Lotus Discovery Server is a knowledge server. It provides search and expertise location solutions designed to ensure that the relevant knowledge and collective experience of an organization is readily available to help individuals and teams solve everyday business problems. In this IBM Redbooks publication we provide an in-depth discussion of the architecture and capabilities of the newest release of the Discovery Server - Discovery Server 2.0. We discuss the key aspects involved in planning for the deployment of this product, from both organizational and technical viewpoints. We also discuss: the key elements of a solid infrastructure design to ensure scalability and reliability, development and maintenance of an enterprise taxonomy, integration of Discovery Server into your existing environment and applications, use of the Discovery Server API toolkit, and ongoing Discovery Server maintenance. This book is appropriate for technologists and project managers who are involved with Lotus Discovery Server-related projects. Please note that the additional material referenced in the text is not available from IBM.

Praise for Elliotte Rusty Harold’s Processing XML with Java™ “The sophistication and language are very appropriate for Java and XML application developers. You can tell by the way the author writes that he too is a developer. He delves very deeply into the topics and has really taken things apart and investigated how they work. I especially like his coverage of ‘gotchas,’ pitfalls, and limitations of the technologies.” — John Wegis, Web Engineer, Sun Microsystems, Inc. “Elliotte has written an excellent book on XML that covers a lot of ground and introduces current and emerging technologies. He helps the novice programmer understand the concepts and principles of XML and related technologies, while covering the material at a level that’s deep enough for the advanced developer. With a broad coverage of XML technologies, lots of little hints, and information I haven’t seen in any other book on the topic, this work has become a valuable addition to my technical library.” — Robert W. Husted, Member, Technical Staff, Requisite Technology, Inc. “The code examples are well structured and easy to follow. They provide real value for someone writing industrial-strength Java and XML applications. The time saved will repay the cost of this book a hundred times over. “The book also contains more of the pearls of wisdom we’ve come to expect from Elliotte Rusty Harold—the kind of pointers that will save developers weeks, if not months, of time.” — Ron Weber, Independent Software Consultant Written for Java programmers who want to integrate XML into their systems, this practical, comprehensive guide and reference shows how to process XML documents with the Java programming language. It leads experienced Java developers beyond the basics of XML, allowing them to design sophisticated XML applications and parse complicated documents. provides a brief review of XML fundamentals, including XML syntax; DTDs, schemas, and validity; stylesheets; and the XML protocols XML-RPC, SOAP, and RSS. The core of the book comprises in-depth discussions on the key XML APIs Java programmers must use to create and manipulate XML files with Java. These include the Simple API for XML (SAX), the Document Object Model (DOM), and JDOM (a Java native API). In addition, the book covers many useful supplements to these core APIs, including XPath, XSLT, TrAX, and JAXP. Processing XML with Java™ Practical in focus, is filled with over two hundred examples that demonstrate how to accomplish various important tasks related to file formats, data exchange, document transformation, and database integration. You will learn how to read and write XML documents with Java code, convert legacy flat files into XML documents, communicate with network servers that send and receive XML data, and much more. Readers will find detailed coverage of the following: Processing XML with Java™ How to choose the right API for the job Reading documents with SAX SAX filters Validation in several schema languages DOM implementations for Java The DOM Traversal Module Output from DOM Reading and writing XML documents with JDOM Searching XML documents with XPath Combining XSLT transforms with Java code TrAX, the Transformations API for XML JAXP, the Java API for XML Processing In addition, the book includes a convenient quick reference that summarizes the major elements of all the XML APIs discussed. A related Web site, located at http://www.cafeconleche.org/books/xmljava/, contains the entire book in el

Build Oracle PL/SQL applications—now. Fully updated for Oracle 9i No Oracle PL/SQL experience necessary. Real-life labs and "Test Your Thinking" Q&As Start developing applications with Oracle PL/SQL—fast. This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, exercises, projects, and a complete Web-based training site. Completely updated for Oracle 9i, it covers all the fundamentals—and a whole lot more. Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging—plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates. Totally integrated with a FREE, state-of-the-art Oracle 9i learning Web site. Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more: "Test Your Thinking" project solutions and detailed explanations Additional self-review exercises with instant feedback and explanations An exclusive Virtual Study Lounge where you can interact with other students. Just the facts. No endless, boring discussions here. You'll learn hands on through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject. It's an integrated learning system that's proven to work. Dozens of exercises cover the real-world tasks that matter most. Hundreds of self-review questions and answers make sure you understand.

While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut. MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations. The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to: Import data from external sources Export data for use by external programs Access MySQL from your web server Use scripts with MySQL to read queries from a file Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages Construct queries that solve commonly-occurring questions Interact with the server This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch.

JAX: Java APIs for XML Kick Start covers the JAX APIs - fundamental for development of Java-based Web service applications as well as other e-Commerce applications requiring the exchange and manipulation of data. The book includes an overview of Web service fundamentals including SOAP, UDDI, and WSDL, all of which will be built upon in later examples. The book then covers the current set of JAX APIs for data processing, for messaging, for writing data to registries and for calling remote applications. Each API is covered from an architectural and implementation perspective, using real-world examples and case studies throughout to illustrate their usefulness. The author will demonstrate both Web service and traditional JAX applications, giving a complete picture of the uses of JAX. The final chapter looks ahead to new developments and new APIs in progress at Sun.

In this IBM Redbooks publication, we describe the new features and functions in IMS Version 8. We document the tasks necessary to exploit the features, and identify migration, coexistence, and fallback considerations. We also identify specific hardware and software requirements that are needed to exploit certain enhancements. First we provide an overview, where we have grouped the various enhancements and their discussion into the categories availability and recoverability, performance and capacity, systems management, and application enablement. Then we have more detailed chapters for describing the individual enhancements. The base enhancements part of the book describes the base product enhancements that apply to all users migrating to IMS Version 8. The Parallel Sysplex enhancements part of the book describes enhancements in IMS Version 8 that apply to both existing users of IMS Version 6 or IMS Version 7 in a Parallel Sysplex environment and users that are considering sysplex functionality. The Common Service Layer part documents the Common Service Layer (CSL), new in IMS Version 8, which is the next step in IMS Parallel Sysplex evolution. The CSL enables IMS systems to operate in unison in an OS/390 Parallel Sysplex. The CSL components provide the infrastructure for an IMSplex. Please note that the additional material referenced in the text is not available from IBM.