Develop flexible, cross-platform Web applications using Oracle Application Server 10g and this exclusive Oracle Press guide. Take advantage of the full support for all major Web development languages, APIs, and frameworks and learn to create and test applications quickly, interface with the Oracle database seamlessly, and deploy your applications to the Web securely. Inside you’ll find full details on J2EE integration, Oracle Forms 10g, Oracle Reports 10g, OracleAS Discoverer 10g, OracleAS Portal, and Oracle JDeveloper 10g.

Implement Oracle's Internet-based Manufacturing and Supply Chain Management products using this Oracle authorized resource. This comprehensive guide explains how to implement the planning, engineering, pricing, order fulfillment, and inventory management components of Oracle Manufacturing and Supply Chain-and develop and deliver goods and services faster, cheaper, and more efficiently than your competitors.

This book covers the second "Fundamentals" exam (test 701) an individual needs to pass in order to become an IBM Certified Database Adminstrator. Written by a DB2 UDB Certified author who worked directly with the DB2 UDB Version 8. 1 Certification Exam development team and reviewed by the IBM Data Management Certification Program Manager, this book is guaranteed to provide the reader with all of the information needed to pass the V8. 1 Certification test 701. Exam-like questions and answers are provided at the end of each chapter and information explaining why each answer provided is correct accompanies every answer given. This is a must-have for any DBA taking the second certification exam. An estimated 20,000 people take this certification exam annually in the US.

Never-Before-Published Insiders’ Information for Troubleshooting SQL Server 2005.   This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people who know it most intimately: the people who wrote it, designed it, and support it. SQL Server expert Ken Henderson, author of the best-selling Guru’s Guides to SQL Server, has assembled a “dream team” of SQL Server developers and support engineers to provide in-depth troubleshooting and diagnostic information that has never been documented before: information that would be impossible to get without access to Microsoft’s own source code.   From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You’ll find comprehensive, in-depth chapters on   • Waiting and blocking • Data corruption and recovery • Memory • Procedure cache issues • Query processing • Server crashes and other critical failures • Service Broker • SQLOS and scheduling • tempdb • Clustering   This is the indispensable resource for everyone who must keep SQL Server running smoothly: DBAs, database application developers, API programmers, and Web developers alike.   CD-ROM Contains the revolutionary SQL Server performance diagnostic tool, SQL NexusTM; TraceBusterTM, one of the world’s fastest SQL Server Profiler trace reader/analyzers; DataDemonTM, one of the fastest, most versatile file import utilities available; and sample code and scripts from the book.   Contents About the Authors      ix Preface      xii Acknowledgments      xiv 1   Waiting and Blocking Issues      1 2   Data Corruption and Recovery Issues      47 3    Memory Issues      137 4   Procedure Cache Issues      183 5   Query Processor Issues      225 6   Server Crashes and Other Critical Failures      273 7   Service Broker Issues      331 8   SQLOS and Scheduling Issues      369 9   Tempdb Issues      411 10   Clustering Issues      425 The Aging Champion      441 Index      445.

Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RAC, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications.

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you’ll learn Develop conceptual models of client data using interviews and client documentation. Normalize data models to enhance scalability and the long term use of valuable data. Translate conceptual models into high–performing SQL Server databases. Secure and protect the integrity of data as part of meeting regulatory requirements. Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more. Create effective indexing to speed query performance. Who is this book for? Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. [+]

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs-plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

This book provides an effective approach to the pragmatic use of e-business technology in the context of the most commonly seen solutions in business today. It enables technology professionals, IT managers, database administrators, and database developers to gain an understanding of major solution areas such as Customer Relationship Management (CRM), Business Intelligence (BI), e-commerce, and business to business integration. The authors explain how complex business solutions can be constructed using J2EE, EAI, and business process management technologies on top of a DB2 foundation.

DB2® 9 builds on the world's number one enterprise database to simplify the delivery of information as a service, accelerate development, and dramatically improve operational efficiency, security, and resiliency. Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux®, UNIX®, and Windows® platforms, as well as authoritative preparation for the latest IBM DB2 certification exam. Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked, Internet-centered, and SOA-based applications; migration; and much more. You'll also find an unparalleled collection of expert tips for optimizing performance, availability, and value. Coverage includes:Important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator roleBreakthrough pureXML™ features that make it easier to succeed with service-oriented architectureOperational improvements that enhance DBA efficiency-including self-tuning memory allocation, automated storage management, and storage optimization Table-partitioning features that improve scalability and manageabilityPowerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all dataWhatever your role in working with DB2 or preparing for certification, DB2 9 for Linux, UNIX, and Windows, Sixth Edition is the one book you can't afford to be without. Download Complete DB2 V9 Trial VersionVisit ibm. com/db2/9/download. html to download a complete trial version of DB2, which enables you to try out dozens of the most powerful features of DB2 for yourself: everything from pureXML support to automated administration and optimization. Straight from IBM, the ultimate guide to running DB2 9 and preparing for the latest IBM DB2 certification exam!Covers powerful DB2 9 enhancements ranging from automated management to improved compression Covers the full spectrum of DBA responsibilities, including server management, data placement, XML concepts, activity analysis, high availability, and securityPresents expert tips and best practices from the DB2 customer support organization.

This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.   All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.

This book constitutes the thoroughly refereed joint post-proceedings of four international workshops held in conjunction with the 20th International Conference on Conceptual Modeling. ER 2002, held in Yokohama, Japan in November 2002. The 37 revised full papers presented were carefully selected and improved during two rounds of reviewing and revision. In accordance with the respective workshops, the papers are organized in topical sections on conceptual modeling and human, organizational, and social aspects; data semantics in web information systems; conceptual modeling approaches for e-business; and global data modeling.

With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing techniques to achieve high performance. Ready-to-use tips for saving hardware costs by running applications at peak efficiencies are provided for senior Oracle DBAs and developers, and powerful PL/SQL techniques are outlined.

This book is a must read for anyone deploying BusinessObjects. It covers everything from planning your upgrade to the latest release, to best practices in universe design, and powerful report creation that maximizes business insight. This book covers the most frequently used features for the full BI suite, in one comprehensive book. There's in depth coverage of Designer, security via the Central Management Console, InfoView, Web Intelligence, and Desktop Intelligence. It goes beyond step-by-step instructions to cover how and why in a business context. Transition notes are interspersed for version 5 and 6 customers to understand the biggest changes in XI Release 2. If you drive BI requirements in your company or are a data warehouse program manager, Business Objects administrator, report author or consumer, this book is for you.

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing database–backed applications. It’s easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers arent left out, however. Those who choose to can go deep and leverage the full power and flexibility of Oracles database engine. Getting started with APEX is easy. Learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the “hood” of APEX and expose the full power behind its easy–to–use GUI interface. They show you what you need to know to produce powerful, professionally polished applications, things such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more. [+]

This book is a basic introduction to the relational database. The author explains the nature and design of the realtional model, and gives practical guidelines on entity-relationship modelling, normalization, and complete database design. Numerous examples and case studies enhance the text.

The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.   Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.   Writing queries and updating data: all you need to know about SELECT   Working with joins, functions, and subqueries   Creating database objects: tables, indexes, views, and more   Specifying keys and other integrity constraints   Using indexes to improve efficiency   Enforcing security via passwords and privileges   Building stored procedures and triggers   Developing with embedded SQL and ODBC   Working with transactions, including rollbacks, savepoints, isolation levels, and more   Optimizing performance by reformulating SQL statements   Using object-relational features: subtables, references, sets, and user-defined data types   Reference section: SQL statement definitions and SQL function lists.

SQL Server exam in one of the top 10 Microsoft certification exams. Boxed set contains MCDBA SQL Server 7 Database Design Study Guide, MCDBA SQL Server 7 Administration STudy Guide, and MCDBA SQL Server 7 Test Yourself Practice Exams. Features more than 1,300 NEW exam-based questions, plus detailed answers from the experts.

Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including. NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.   Detailed information on… Installing, upgrading, and administering SQL Server 2005 Database maintenance, backup, and recovery Creating and managing tables, views, stored procedures, triggers, and user-defined functions Database and index design SQL Server query optimization, and performance monitoring and tuning Transactions, transaction management, and distributed transactions SQL Server Management Studio—NEW! SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW! SQL Server Service Broker—NEW! SQL Server and Microsoft. NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW! SQL Server high availability and SQL Server clustering and replication Database Mirroring—NEW! Database Snapshots—NEW! Using XML in SQL Server 2005 SQL Server tools and utilities   CD-ROM includes 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search Code samples, scripts, and sample databases A PDF version of the entire book   Introduction Part I Welcome to Microsoft SQL Server 1 SQL Server 2005 Overview 2 What’s New in SQL Server 2005 Part II SQL Server Tools and Utilities 3 SQL Server Management Studio 4 SQL Server Command-Line Utilities 5 SQL Server Profiler Part III SQL Server Administration 6 SQL Server System and Database Administration 7 Installing SQL Server 2005 8 Upgrading to SQL Server 2005 9 Client Installation and Configuration 10 Security and User Administration 11 Database Backup and Restore 12 Database Mail 13 SQL Server Scheduling and Notification 14 SQL Server High Availability. 15 Replication 16 Database Mirroring 17 SQL Server Clustering Part IV Database Administration 18 Creating and Managing Databases 19 Creating and Managing Tables 20 Creating and Managing Indexes 21 Implementing Data Integrity 22 Creating and Managing Views in SQL Server 23 Creating and Managing Stored Procedures 24 Creating and Managing User-Defined Functions 25 Creating and Managing Triggers 26 Transaction Management and the Transaction Log 27 Database Snapshots 28 Database Maintenance Part V SQL Server Performance and Optimization 29 Indexes and Performance 30 Understanding Query Optimization 31 Query Analysis 32 Locking and Performance 33 Database Design and Performance 34 Monitoring SQL Server Performance Part VI SQL Server Application Development 35 What’s New for Transact-SQL in SQL Server 2005 36 SQL Server and the. NET Framework 37 Using XML in SQL Server 2005 38 SQL Server Web Services Part VII SQL Server Business Intelligence Features 39 SQL Server 2005 Analysis Services 40 SQL Server Integration Services 41 SQL Server 2005 Reporting Services Bonus Chapters on the CD 42 Managing Linked and Remote Servers 43 Configuring, Tuning, and Optimizing SQL Server Options 44 Administering Very Large SQL Server Databases 45 SQL Server Disaster Recovery Planning 46 Transact-SQL Programming Guidelines, Tips, and Tricks 47 SQL Server Notification Services 48 SQL Server Service Broker 49 SQL Server Full-Text Search Index  .