Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions Second Edition

1 comments


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

What you’ll learn

* Develop an evidence-based approach to problem solving
* Manage transactions in highly concurrent environments
* Speed access to data through table and index design
* Manage files and memory structures for performance and reliability
* Scale up through partitioning and parallel processing
* Load and unload data to interface with external systems
* Think for yourself; don’t take Tom’s word for it!

Who this book is for

This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go to book for those wishing to create efficient and scalable applications.

http://www.mediafire.com/?2ya5caqzgfs7cqb

McGraw Hill - Oracle Essbase and Oracle OLAP The Guide

0 comments


Complete Coverage of Oracle Essbase and Oracle OLAP

Written by renowned experts on both Oracle Essbase and Oracle OLAP, this exclusive Oracle Press guide explains the unique features and benefits of these powerful online analytic processing products. Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution provides the details you need to architect the OLAP solution that meets your requirements. Proven techniques for building robust applications and tuning and maintaining your OLAP environment are included in this authoritative resource. Real-world case studies illustrate the material presented.

* Learn OLAP concepts and history
* Understand OLAP as a key component of any business intelligence architecture
* Design and build Oracle OLAP analytic workspaces
* Plan and create Oracle Essbase databases
* Generate reports from Oracle OLAP, Oracle Essbase, Oracle Business Intelligence Enterprise Edition, and other tools
* Accelerate and enhance data warehouses with Oracle OLAP
* Use Oracle Essbase with performance management applications, including Oracle Hyperion Planning, Oracle Hyperion Profitability and Cost Management, Oracle Crystal Ball, and Oracle Smart Space
* Develop custom applications using Java APIs
* Configure, optimize, tune, and maintain Oracle Essbase and Oracle OLAP
http://www.mediafire.com/?zjgwiioednd

McGraw Hill - Applied Oracle Security December 2009

0 comments



Cutting-edge techniques from leading Oracle security experts

This Oracle Press guide demonstrates practical applications of the most compelling methods for developing secure Oracle database and middleware environments. You will find full coverage of the latest and most popular Oracle products, including Oracle Database and Audit Vaults, Oracle Application Express, and secure Business Intelligence applications.
Applied Oracle Security demonstrates how to build and assemble the various Oracle technologies required to create the sophisticated applications demanded in today's IT world. Most technical references only discuss a single product or product suite. As such, there is no roadmap to explain how to get one product, product-family, or suite to work with another. This book fills that void with respect to Oracle Middleware and Database products and the area of security.

From the Back Cover

Written by leading Oracle security experts, this Oracle Press guide shows you how to develop security applications for the Oracle environment. Applied Oracle Security explains how to maximize the security capabilities in Oracle Database, Oracle Database Vault, Oracle Identify Management, Oracle Application Express, and Oracle Business Intelligence Suite. Protect your data and applications by using the proven strategies inside this authoritative resource.

* Use Oracle Transparent Data Encryption to protect sensitive information
* Deploy Oracle Audit Vault to build a coherent enterprise audit strategy
* Fortify your Oracle Databases with best practices from the creators of Oracle Database Vault
* Apply Oracle Database Vault security controls to new and existing applications
* Develop a foundation for identity management architecture using a simple and practical methodology
* Apply Oracle Identity Manager to automate user provisioning processes
* Create next generation user directories with Oracle Internet Directory and Oracle Virtual Directory
* Build secure applications leveraging database security with Oracle Application Express
* Integrate Oracle Business Intelligence Enterprise Edition and identity management solutions to control user access to data and functionality
www.mediafire.com/?uwjxu2zom2e

McGraw Hill - Oracle JDeveloper 11g Handbook

0 comments


Written by the most knowledgeable Oracle JDeveloper author team in the world

This Oracle Press guide shows how to build Web applications using the Fusion Middleware development tool, Oracle JDeveloper. The book discusses the latest technologies and explains how to develop code using multiple techniques.

Oracle JDeveloper 11g Handbook: A Guide to Fusion Web Development covers the Oracle Application Development Framework and JavaServer Faces. Hands-on practice examples walk you through the creation of a complete sample application that employs highly-interactive user interface components and declarative development methods. You will learn the techniques required to implement Fusion-oriented software solutions in JDeveloper.


A Complete Guide to Oracle Fusion Web Development with Oracle JDeveloper 11g

Written by world-renowned Oracle JDeveloper experts, this exclusive Oracle Press resource shows you how to build Java Platform, Enterprise Edition web applications using Oracle JDeveloper 11g, Oracle Application Development Framework (Oracle ADF), and JavaServer Faces. Oracle JDeveloper 11g Handbook walks you through the creation of a complete sample application that employs highly interactive user interface components and declarative development methods. Learn the techniques required to implement Oracle Fusion-oriented solutions using Oracle JDeveloper 11g from this hands-on guide.

* Work in the Oracle JDeveloper 11g Integrated Development Environment
* Create business services with Oracle ADF Business Components
* Develop entity object definitions that represent database objects and encapsulate business logic
* Create components that query database data
* Encapsulate complex data operations
* Build JavaServer Faces applications
* Work with the Oracle ADF Controller and Task Flows
* Enable high interactivity with Oracle ADF Faces Rich Client
* Bind the user interface to the business services layer using Oracle ADF Model
* Learn design principles and best practices for working with Oracle JDeveloper 11g and Oracle ADF
http://www.mediafire.com/?qmfl0mn3wh2

Oracle Database 11g Underground Advice for Database Administrators April 2010

0 comments


Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively.

This survival guide offers previously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases.

The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and proactively prevent disasters by implementing distributed grid computing—scalable and robust—with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components.

This book will also help you in situations where you need to install Oracle Database 11g or migrate to new hardware making it compliant with a Maximum Availability Architecture. By the end of this book you will have learned a lot and gained confidence in your abilities. You will be armed with knowledge as to which tools are best used to accomplish tasks while proactively moving towards an automated environment.

An example-oriented guide to optimize a DBA's performance on 11g databases

What you will learn from this book :

* The mechanics and essentials of the database at the block level and tracking the System Change Number
* Reducing or eliminating downtime for the primary database using DATA GUARD and FLASHBACK in tandem
* Enterprise implementations of RMAN with DATA GUARD, Transportable Tablespaces, and the new Data Recovery Advisor
* Using both GUI tools and command-line utilities
* Migrating to the latest release of 11g using the Step-Ordered Approach
* A solid foundation designed to reduce future maintenance
* Implementing Maximum Availability Architecture with commodity hardware
* Many of the common mistakes and failures of common implementations
* Solving forecasting, performance, and tuning issues with the low cost tools available


Approach


This book is designed to cover the problems that novice DBAs particularly struggle with. This handbook covers a minimal amount of theoretical information before showing you how to overcome common problems through the use of real-life examples. It covers both Oracle 11g R1 and 11g R2 in examples, with material applicable to all versions of Oracle.

Who this book is written for :


This book is for you if you find yourself in charge of an Oracle database. It can be easy to feel overwhelmed. Whether you are a single employee or the DBA manager of several employees, whether you are taking over an existing position or taking up a newly created one – this book is designed to be a sanity check. If you need guidance for migrating to 11g or implementing Oracle's Maximum Availability Architecture, you will find this book very helpful.

http://www.mediafire.com/?otwmmynmmdk

Wrox Professional Oracle Weblogic Server

0 comments


Authoritative guide to Oracle WebLogic Server-from Oracle insidersIf you’re an experienced Java developer who wants to expand your skills, Professional Oracle WebLogic Server is the perfect guide for you. This book is written by a top-notch author team that that includes one of the lead architects from Oracle’s Fusion Middleware Development Architects team.

Follow their best practices, workarounds, and sound techniques and confidently develop even the most mission-critical applications with WebLogic Server.

This book fully covers WebLogic Server 11g, including the new features of both JEE 5 and WebLogic Server, as well as JEE 5 annotations, Spring, JPA, JAX-WS, JMS Store-And-Forward, SAML support, and the WLST administrative scripting tool.

This book is the authoritative guide to :

* Choosing a Web application architecture
* Best practices for development and production environments
* Designing an Java EE application
* Building Enterprise JavaBeans in WebLogic Server
* Building an EJB application
* Packaging and deploying WebLogic web applications
* Developing and deploying web services
* Using WebLogic JMS
* Using WebLogic security
* Administering and deploying applications in WebLogic Server
* Optimizing WebLogic Server performance

From the Back Cover

Best practices for developing WebLogic Server applicationsWritten by a team of Oracle insiders and experts in the development of enterprise-class Java EE applications, this professional-level book provides best practices for developing and deploying WebLogic Server applications. The authors share their real-world experience and knowledge of WebLogic Server and its features to help you understand not only how things can be done, but also how things should be done.

* Includes tips for choosing a Java EE application architecture
* Walks you through various design solutions, architectures, construction techniques, deployment options, and management techniques
* Features a realistic example application that leverages key technologies such as JSP, Spring MVC, EJB 3.0, JPA, and JAX-WS
* Details each aspect of the decisions made during the development and deployment of the sample application
* Contains best practices for configuring, managing, and tuning development and production environments
* Explores techniques for using WebLogic Server JMS and WebLogic security

http://www.mediafire.com/?dnnmyw22cym

Oracle Coherence 3.5 March 2010

0 comments


Scalability, performance, and reliability have to be designed into an application from the very beginning, as there may be substantial cost or implementation consequences if they need to be added down the line. This indispensible book will teach you how to achieve these things using Oracle Coherence, a leading data grid product on the market.

Authored by leading Oracle Coherence authorities, this essential book will teach you how to use Oracle Coherence to build high-performance applications that scale to hundreds of machines and have no single points of failure. You will learn when and how to use Coherence features such as distributed caching, parallel processing, and real-time events within your application, and understand how Coherence fits into the overall application architecture.

Oracle Coherence provides a solid architectural foundation for scalable, high-performance and highly available enterprise applications, through features such as distributed caching, parallel processing, distributed queries and aggregations, real-time events, and the elimination of single points of failure.

However, in order to take full advantage of these features, you need to design your application for Coherence from the beginning. Based on the authors’ extensive knowledge of Oracle Coherence, and how to use it in the real world, this book will provide you with all the information you need in order to leverage various Coherence features properly. It contains a collection of best practice-based solutions and mini-frameworks that will allow you to be more productive from the very beginning.

The early chapters cover basics like installation guidelines and caching topologies, before moving on to the domain model implementation guidelines, distributed queries and aggregations, parallel processing, and real-time events. Towards the end, you learn how to integrate Coherence with different persistence technologies, how to access Coherence from platforms other than Java, and how to test and debug classes and applications that depend on Coherence.

Create Internet-scale applications using Oracle’s high-performance data grid

* Build scalable web sites and Enterprise applications using a market-leading data grid product
* Design and implement your domain objects to work most effectively with Coherence and apply Domain Driven Designs (DDD) to Coherence applications
* Leverage Coherence events and continuous queries to provide real-time updates to client applications
* Successfully integrate various persistence technologies, such as JDBC, Hibernate, or TopLink, with Coherence
* Filled with numerous examples that provide best practice guidance, and a number of classes you can readily reuse within your own applications.

What you will learn from this book :

# Best use distributed caching to reduce the load on the backend database
# Design and implement your domain objects to work most effectively with Coherence
# Apply Domain Driven Design (DDD) principles to Coherence applications
# Query and aggregate data efficiently within the Coherence grid
# Boost application performance by executing tasks in parallel within the grid
# Leverage Coherence events and continuous queries to provide real-time updates to client applications
# Integrate various persistence technologies, such as JDBC and JPA, with Coherence
# Access Coherence from .NET and C++ applications using Coherence*Extend
# Test and debug Coherence-related code

Chapter 1 Introduction to Oracle Coherence -Shows you how to install Coherence and teaches the basics of Coherence API
Chapter 2 Designing Coherence Caches -Covers various caching topologies Coherence supports and when to use each
Chapter 3 Implementing Domain Model -Describes how to apply DDD to Coherence applications and how to implement your domain objects to work optimally with Coherence
Chapter 4 Querying the Data Grid - Provides an overview of Coherence distributed queries and aggregations
Chapter 5 Parallel Processing -Teaches you how to improve application performance by parallelizing task execution within the Coherence cluster
Chapter 6 Data Grid Events - Shows you how to use Coherence events and continuous queries to receive real-time notifications of data changes
Chapter 7 Implementing Persistence Layer -Examines different persistence architectures that can be used with Coherence and shows you how to use Spring JDBC, Hibernate, and TopLink to implement persistence
Chapter 8 Bridging Platform and Network Boundaries -Describes how to connect to a Coherence grid from remote Java, .NET, and C++ applications over TCP/IP
Chapter 9 Bridging Platform and Network Boundaries -Covers the Coherence*Extend protocol, which allows you to access a Coherence cluster from remote clients and from platforms and languages other than Java, such as .NET and C++.
Chapters 10 Accessing Coherence from .NET and Chapter 11 Accessing Coherence from C++ -Teach you how to access Coherence from .NET and C++ clients, respectively.
Chapter 12 The Right Tool for the Job -Provides some parting thoughts and reiterates practices you should apply when building scalable applications. Appendix, Coherent Bank Sample Application, describes how to set up the sample application that accompanies the book in your environment.

Approach
This title covers Coherence features progressively, from simple to more advanced topics, and provides best-practice guidance on when and how to use each.

Numerous examples are provided throughout the book that will help you become familiar with Coherence APIs. You will also be able to reuse many of the sample classes or mini-frameworks encapsulating Coherence best practice and providing missing features directly within your own applications. This should significantly increase your productivity when developing Coherence applications.

Finally, a sample application that you can download from the companion web site will show you how to use Coherence as part of the broader infrastructure stack, including Spring Framework and Hibernate, as well as how to access Coherence from a WPF-based .NET desktop application.

Who this book is written for :
This book is written for architects and developers responsible for the design and development of Internet or Enterprise applications (web-based or otherwise) that need to scale to support a large number of simultaneous users, while at the same time providing fast response times and high availability. The book assumes a solid knowledge of Java, and a familiarity with Domain Driven Design (DDD) is helpful.

www.mediafire.com/?2mgwymmj4t4

Packt - Oracle SQL Developer 2.1

0 comments

As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface.

It’s easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer’s extensible environment to support your ongoing needs

This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports.

By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.

Use the powerful GUI to browse your database objects, run SQL statements and scripts, and create, edit, debug, and test PL/SQL code in a highly productive environment

What you will learn from this book :

* Build complex queries based on a number of tables using visual Query Builder
* Assess the health of your database, data structure of your application, and data in that application with built-in as well as user-defined reports
* Create, compile, and debug PL/SQL code and explore available features to facilitate writing PL/SQL code
* Integrate your SQL Developer with open source version control systems CVS and Subversion, which allow checking out of files from a repository, editing, and checking them back in
* Enter and execute your SQL, PL/SQL, and SQL*Plus statements with the SQL Worksheet interface
* Produce easily replicable scripts that copy and move data from one database instance to another, or from one schema to another
* Create advanced database connections using a variety of connection and authentication types available for Oracle as well as non-Oracle databases
* Create, review, and update database schema designs with SQL Developer Data Modeler
* Augment your environment with features that are specific to your needs by extending your SQL Developer with XML structured user-defined extensions
* Monitor and manage your Application Express applications by integrating with SQL Developer
* Set up an easy and quick migration environment for your database schema by using the migration repository
* Browse and review non-Oracle databases, before using the migration environment to migrate and consolidate databases on the Oracle platform


Approach


Covering SQL Developer fundamentals as well more intermediate and advanced topics, this book uses in-depth explanation and detailed examples to help you get the most out of Oracle SQL Developer. The book has a modular structure, so that you can dip into any chapter that covers your current area of focus and get going.

Who this book is written for


This book is for Oracle developers who want to ease their database development, and enhance their productivity using Oracle SQL Developer. You should have a programming knowledge of SQL and PL/SQL, and a general familiarity with Oracle database concepts.
http://www.mediafire.com/?qckmo4knin0

Oracle PL/SQL Programming 5th edition

0 comments



This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.

This indispensable reference for both novices and experienced Oracle programmers will help you:

* Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
* Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
* Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
* Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
* Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
* Build modular PL/SQL applications using procedures, functions, triggers, and packages
http://www.mediafire.com/?j3ntmt3ttwg

Expert Oracle Practices: Oracle Database Administration from the Oak Table 2010

0 comments


This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.

* Adopt a rational approach to database management; eliminate guesswork
* Add value to your organization as a database professional
* Manage and optimize performance
* Exploit different platform technologies
* Secure your organization's data
* Gain deep understanding of database internals and structures

http://www.mediafire.com/?jfvkbkwwm4v
 
Copyright © Download Free Ebooks