Книга посвящена теоретическим и практическим вопросам использования хранилищ данных (WareHouse). Проектирование хранилищ данных - один из сложных разделов программной инженерии. На него распространяются все современные методологии проектирования ПО, но их выполнение усложняется молодостью данного направления и очень острой нехваткой соответствующих специалистов. Рассмотрены особенности построения хранилищ на базе СУБД Oracle9i.

Книга будет полезна широкому кругу ИТ-специалистов, а также маркетологов, аналитиков и других специалистов, использующих в своей деятельности хранилища данных.

В книге объясняется, как использовать SQL для работы с базой данных и как автоматизировать сложные задачи с помощью PL/SQL. Вы будете учиться на конкретных примерах: каждая глава содержит практические упражнения, помогающие освоить представленный материал. Изложение ведется по принципу "от простого к сложному". Сначала рассматриваются основы баз данных, включая такие фундаментальные понятия, как "таблица", "строка", "запись", "столбец" и "поле", а затем объясняется, как сохранять, извлекать и модифицировать данные, управлять программой SQL*Plus, создавать SQL-функции и, наконец, писать программы на PL/SQL.
Вы научитесь:
Создавать таблицы, индексы и ограничения базы данных.
Писать SQL-команды для вставки, выборки, обновления и удаления данных.
Выполнять сложные манипуляции с данными.
Писать законченные функции и процедуры PL/SQL.
Объявлять переменные с использованием привязанных типов.
Создавать пакеты PL/SQL.
Использовать триггеры для реализации сложных бизнес-правил и поддержания безопасности.

Книга написана сертифицированным специалистом по Oracle и одобрена корпорацией Oracle. Она даст все сведения, необходимые для начала работы с SQL и PL/SQL.

If 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

Developing data-centric web applications can be a real challenge as it is a multi-disciplinary process. There are many technologies involved in the client side (HTML, CSS, javascript, and so on); the interaction with the database, on the server side; the typeless nature of the web environment; and above all, the need to put it all together. This needs to be done in a manner that will allow the end users to do their job in the simplest and most efficient way, while enriching their user experience. How often have you wished that developing such applications could be uncomplicated and straightforward? This book will show you that it’s possible, and teaches you how to do it, using Oracle Application Express (APEX).

Design Feature-Rich PL/SQL Applications
Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.
-Create, debug, and manage Oracle-driven PL/SQL programs
-Use PL/SQL structures, delimiters, operators, variables, and statements
-Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
-Work with functions, procedures, packages, collections, and triggers
-Define and deploy varray, nested table, and associative array data types
-Handle external routines, object types, large objects, and secure files
-Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
-Call external procedures through Oracle Net Services and PL/SQL wrappers
-Integrate internal and server-side Java class libraries using Oracle JVM
-Develop robust Web applications using PL/SQL Gateway and Web Toolkit

Protect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.
* Set up, configure, and maintain Oracle Recovery Manager (Oracle RMAN)
* Manage physical and virtual media with Oracle Secure Backup
* Work with Oracle RMAN catalogs, packages, and control files
* Use the Amazon Web Services cloud as an offsite storage solution
* Create online, offline, and incremental system backups
* Perform full and partial Oracle RMAN database restores
* Correct user-induced errors with Oracle Flashback
* Product clone and standby databases on local or remote servers
* Use Oracle Real Application Clusters and synch and split technology

XML is an open standard for creating markup languages and exchanging structured documents and data over the Internet. JDeveloper 11g presents an effective, quick, and easy-to-use means of processing XML documents.

Inspired by the author’s previous XML articles for the Oracle community, this expanded hands-on tutorial guides newcomers and intermediate users through JDeveloper 11g and XML document development. It offers up-to-date information on working with the latest version of JDeveloper, and brand new information on JAXB 2.0 support in JDeveloper 11g. Filled with illustrations, explanatory tables, and comprehensive instructions, this book walks the reader through the wide assortment of JDeveloper’s capabilities.

Oracle’s JDeveloper 11g is an Integrated Development Environment that provides a visual and declarative approach to application development. Over the course of 14 chapters, readers will get hands-on with JDeveloper as the comprehensive and self-contained tutorials provide clear instruction on the key XML tasks that JDeveloper can accomplish.

Oracle JRockit is one of the industry’s highest performing Java Virtual Machines. Java developers are always on the lookout for better ways to analyze application behavior and gain performance. As we all know, this is not as easy as it looks. Welcome to JRockit: The Definitive Guide.

This book helps you gain in-depth knowledge of Java from the JVM’s point of view. We will explain how to write code that works well with the JVM to gain performance and scalability. Starting with the inner workings of the JRockit JVM and finishing with a thorough walkthrough of the tools in the JRockit Mission Control suite, this book is for anyone who wants to know more about how the JVM executes your Java application and how to profile for better performance.