Book Description
In the SOA world, managing distributed services and service infrastructures is critical. Oracle Enterprise Manager – an all-encompassing management product – facilitates increased management capabilities for databases, application servers, and packaged applications. BPEL PM and OSB are two compelling, market leading products that are driving Service-Oriented Architecture (SOA) implementation across enterprises.

There is a lack of clarity around real-world operational use cases that would help operational administrators in their day-to-day tasks. Further, the documentation available online does not provide much information on administering BPEL PM and OSB with Enterprise Manager Grid Control efficiently.

This book will help you set up the framework for managing operational tasks from a central location using Oracle Enterprise Manager Grid Control in a step-by-step functional approach. You will learn to automate various operational tasks that are essential for the smooth running of Oracle SOA products in production, thus increasing the efficiency of your SOA projects.

This book shows how top-drawer management capabilities from Oracle Enterprise Manager Grid Control can be used to effectively manage your Oracle SOA environment. You start by discovering one or more BPEL and OSB components centrally. The book then explains how to monitor BPEL processes and OSB services, and how to get alerts on service availability and performance problems. It covers the management of BPEL and OSB infrastructure components and how to manage their configurations in a central repository. It follows a hands-on approach, showing you how to use an automated approach for deploying BPEL processes and OSB projects.

Continue Reading »

Book Description
The expert guidance you need to get the most out of Access 2010Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you’ll appreciate the thorough attention to database fundamentals and terminology. If you’re familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.

• Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010
• Explores the latest enhancements, such as a new user interface and wider use of XML and Web services; also, how to exchange data with Word, Excel, PowerPoint, and other Office apps
• Covers how to create tables, manipulate datasheets, and work with multiple tables
• Explains the seven database objects and how to use a seven-step design method to build a database tailored to your needs
• Shows you how to build forms, use Visual Basic and the VBA Editor, automate query parameters, create functions and subroutines, use XML to create data access pages, and more
• Includes a CD with all source code from the book and working examples, plus bonus shareware, freeware, trial, demo and evaluation programs that work with or enhance Microsoft Office

You’ll want to keep this soup-to-nuts Access reference close at hand!

Continue Reading »

Book Description
Application developers, take note: databases aren’t just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application.

With SQLite, you’ll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You’ll get a crash course in data modeling, become familiar with SQLite’s dialect of the SQL database language, and much more.

• Learn how to maintain localized storage in a single file that requires no configuration
• Build your own SQLite library or use a precompiled distribution in your application
• Get a primer on SQL, and learn how to use several language functions and extensions
• Work with SQLite using a scripting language or a C-based language such as C# or Objective-C
• Understand the basics of database design, and learn how to transfer what you already know to SQLite
• Take advantage of virtual tables and modules

“Complex SQL concepts explained clearly.” –D. Richard Hipp, creator of SQLite

Continue Reading »

Book Description
A comprehensive guide to programming for Access 2010 and 2007

Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

• Access is the leading database that is used worldwide
• While VBA remains the favored method for Access programming, more options are available for Access 2010, and this book covers them all
• Covers the Access Object model, using VBA with ADO, VBA execution and error handling, creating database objects, creating and enhancing forms and reports, using the Windows Registry, and much more
• Explains how to use VBA with SQL, APIs, and other Office applications, and how to create secure VBA code
• Companion Web site provides updates and links to useful resources

Access 2010 Programmer’s Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Continue Reading »

Book Description
Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.

This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.

• Fully-revised to cover Oracle Database 11g
• Proof-by-example approach: Let the evidence be your guide
• Dives deeply into Oracle Databases’s most powerful features Continue Reading »