| Oracle® Life Sciences Data Hub Release Content Document Release 2.2 Revision C Part Number E22748-03 |
|
|
View PDF |
| Oracle® Life Sciences Data Hub Release Content Document Release 2.2 Revision C Part Number E22748-03 |
|
|
View PDF |
Release Content Document
Release 2.2 Revision C
E22748-03
June 2011
This Release Content Document (RCD) describes the product features that are included in Oracle Life Sciences Data Hub (LSH) Release 2.2.
Section 4, "Oracle Life Sciences Data Hub Release 2.2"
Section 4.1, "Product Overview"
Section 4.4, "Desupported features"
This Release Content Document (RCD) describes product features that are proposed for the specified release of Oracle Life Sciences Data Hub (LSH). It is intended solely to help you assess the business benefits of implementing LSH Release 2.2. This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.
This document is for informational purposes only and is intended solely to assist you in planning for the implementation of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remain at the sole discretion of Oracle.
In this release we have focused on adding several features to enable easier data pooling and read access to LSH data from external tools. Several other features to enhance the ease of use, such as additional capabilities in text data loading, and SAS IDE, have been added.
Release 2.2 includes the following enhancements:
Programs and Tables of Type View
Generic Visualization Adapter
Text Load Set Enhancements
Usability Enhancements
In addition, this release implements a technology stack upgrade. It is now on E-Business Suite 12.1.3.
This feature enables users to pool data from multiple sources in a view and use the data for reporting and analysis in LSH.
A new View Program type has been introduced, which allows the user to create views based on existing Tables in LSH. The view is created as a Table instance of type View and enables pooling data from multiple sources. This eliminates the need to store multiple copies of data in separate database tables and also eliminates the need to refresh data across such tables. View Table instances can be used as a source Table for other LSH Programs. The View Tables support basic view-type transformations and union views.
As with Tables populated by any other Program, View Tables provide full currency traceability across the view to the source Tables. They also support blinding and backchaining.
Prior to this release, any external tools that needed Read access to LSH data were required to have a specific LSH adapter. In LSH Release 2.2, a new Generic Visualization Adapter enables external tools to read LSH data without needing a tool-specific LSH adapter, using a new type of Business Area. External users with appropriate security permissions can access, analyze and report on LSH data using any external visualization tool.
Public APIs are available to initialize access to the Generic Visualization Business Area based on either the association of a database account with an existing LSH user account or direct grants to a database account. The Public APIs also set the user's security and blinding privileges based on LSH security permissions or database grants.
This generic adapter uses LSH Generic Visualization Business Areas to define and create database schemas. Each Generic Visualization Business Area has a corresponding database schema with a schema name that is unique within LSH. The database schema accesses LSH data through the use of views and synonyms.
Release 2.2 supports the following additional capabilities in loading text files:
Creation of Table Descriptors from metadata files.
Processing multiple data files and metadata files from a zipped file.
Using multiple date formats for different Table Descriptors during the execution of a single Load Set .
The following usability enhancements are included:
Table Descriptor Mapping: When a target Table Descriptor in a Load Set, Data Mart, Program or Business Area is updated and new columns are added, the installation process automatically upgrades the mapped Table instance, completes the mapping, and installs the Load Set, Data Mart, Program or Business Area.
SAS Programming: When a SAS Program in 'Development' validation status is executed, LSH detects all outputs and target data sets produced by that Program and automatically creates any needed Planned Outputs and Target Table Descriptors for that Program.
The following components are certified with Release 2.2. See My Oracle Support article 180430.1, Oracle Life Sciences Applications Supported Technology Stacks for the latest information.
| Component | Version | Dependency | Required? |
|---|---|---|---|
| E-Business Suite | 12.1.3 | Install, Runtime | Required |
| Oracle Database | 11.2.0.2 | Install, Runtime | Required |
| Oracle Warehouse Builder | 11.2.0.2 | Runtime | Required |
| Oracle Thesaurus Management System | 4.6.1 | Runtime | Required |
| Oracle Clinical | 4.6 | Runtime | Optional |
| Oracle Reports | 10.1.2.3 | Runtime | Optional |
| Oracle Business Intelligence Enterprise Edition (OBIEE) | 10.1.3.4.1 and 11.1.1.5.0 | Runtime | Optional |
| Oracle Business Intelligence Publisher | 10.1.3.4.1 | Runtime | Optional |
| SAS | 8.2, 9.1.3, 9.2 | Runtime | Optional |
| Informatica PowerCenter | 8.6.1 HF 11, 9.0.1 HF 2 | Runtime | Optional |
The following platform configurations are supported with LSH Release 2.2.
| Tier | Platform |
| Client |
|
| Application Server |
|
| Database Server |
|
12 May 2011: First version.
16 May 2011: Corrections to the Technology Stack Components section.
16 June 2011: Corrections to the Technology Stack Components section.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Life Sciences Data Hub Release Content Document
E22748-03
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
|
 Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
