|
| Session ID |
SessionType |
Category |
Topic |
Products |
Session Title |
Speaker1 |
Speaker1 Company |
Speaker2 |
Speaker2 Company |
Abstract |
|---|
|
| T1076 |
Presentation |
Business Intelligence |
Hyperion&Essbase Rpt |
Oracle Hyperion Smart View, Oracle Hyperion Planning |
Real World Integration with Microsoft Office via Hyperion Smart View |
Tracy McMullen |
interRel Consulting |
|
|
Smart View is the new common Hyperion add-in for Microsoft Office. It can be used with Hyperion Planning, Web Analysis, Financial Reporting and more. Most people think of Smart View as usable only in Excel, but in this presentation, learn the value of using the Smart View add-in in all your Microsoft Office products. You can write letters in Word that include Essbase numbers, make presentations in PowerPoint that contain graphs from Web Analysis, or send your Planning numbers to your manager in Microsoft Outlook. Of course, Excel is also there for analysis as well. During this presentation, you'll learn the value of using the Smart View add-in in all your Microsoft Office products.
|
|
| T1085 |
Presentation |
Business Intelligence |
Essbase |
Oracle Essbase |
What's New in Essbase: A Journey from 7x to 11x |
Tracy McMullen |
interRel Consulting |
|
|
This presentation will take you on a journey examining the differences from Essbase 7x to 11x. The adventure begins with an overview of System 9 and the new enhancements between 7x and 9.3.1, including how to utilize these new features. Our voyage then proceeds from System 9 to Essbase 11.1.1 as we introduce you to all of the 11x new features including text in Essbase cubes and varying attributes. Our quest concludes with an introduction of the new Essbase Studio and the promise of more to come. This session takes users full circle from where they currently stand on 7x or System 9 and ends with what to anticipate in 11x.
|
|
| K1004 |
Keynote |
Warehousing |
Analytics |
|
From Data Warehousing to Strategic Data Assets -- Case Studies on the Web: Social Networking, Direct-Response Marketing, and Understanding Customer Behavior |
Usama Fayyad |
Yahoo! |
|
|
The rise of the interactive media represented by the Web, social media, search, and behavioral targeting have created new challenges and opportunities for a new generation of companies. While these new media offer a deeper mechanism for approaching the holy grail in marketing and advertising - understanding the customer's intent - the sheer volumes of the rich structure of available data, from social graph data to time-series from interactions to behavioral and demographic data expand the complexity of the classical data warehousing and Business Intelligence challenges. I will draw on some of the case studies at Yahoo! where we had the extreme challenge of dealing with one of the world's largest data streams: over 25 terabytes of data per day that had to be not only processed and stored, but utilized live to drive advertising targeting and personalization solutions. Along the way of tackling these challenges, Strategic Data Solutions team not only dealt with unique challenges (for example operating the world's largest Oracle database), but figuring out the strategic dimensions of the data so new businesses are enabled and a new way level of fusing data into the day-to-day operations of the business. In addition to presenting examples of such applications as well as challenges, we will relate some case-studies to illustrate the power of understanding and harnessing this data. However, the context will also be used to illustrate the stronger need to shift to a different level of thinking about data: a new strategic dimension that is more critical than we have experienced before in terms of classical BI and Data Mining. These will hopefully illustrate new frontiers and opportunities, including the ability to evolve the business model of the future: the truly data-driven business.
|
|
| W1007 |
Workshop |
Business Intelligence |
Essbase |
Oracle Essbase, Oracle Hyperion Smart View, Oracle Hyperion Visual Explorer |
Hands on with Essbase, Smartview, and Hyperion Visual Explorer |
Tim Vlamis |
Vlamis Software Solutions, Inc. |
Mike Nader |
Oracle |
Hyperion reporting and analysis tools, including Smartview, Hyperion Visual Explorer, and Smartspace give users an easy-to-use interface for manipulating and analyzing multi-dimensional data stored in Essbase cubes. Come gain first-hand knowledge of what is possible with Essbase in this interactive session. |
|
| W1006 |
Workshop |
Warehousing |
OLAP |
Oracle OLAP Option, Oracle Analytic Workspace Manager (AWM) |
Hands on with Oracle OLAP 11g for Smarter and Faster Data Warehouses |
Mark Thompson |
Vlamis Software Solutions, Inc. |
|
|
Can I move my existing "multi-dimensional cubes" to 11g? Can I really improve my warehouse performance using OLAP? What is the benefit of upgrading to OLAP 11g? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you?
In this hands-on session, participants will gain first-hand knowledge of what it's like to build Oracle 11g OLAP cubes and analyze data. There will be a practical look at the new features of OLAP 11g and what the new features mean to the warehouse architect and users. OLAP 11g adds a lot of new features designed to help the DBA and architect build multidimensional warehouses rapidly and integrate the warehouses seamlessly into the relational model. This presentation will help a DBA prepare a database and design schemas for use by SQL and OLAP applications and help an application developer understand what options are possible and how to gain maximum value from a data warehouse. |
|
| T1045 |
Presentation |
Business Intelligence |
Development |
Oracle BI EE, Oracle BI Publisher, Oracle Database, Oracle OLAP Option |
Having Your Business Intelligence the Way You Want It! |
Chris Claterbos |
Vlamis Software Solutions, Inc. |
|
|
Oracle's Business Intelligence (OBI EE+) is a platform from which to build your BI delivery the way you want it. This presentation discusses the various ways to provide data access to all users inside and outside the organization. Using the open service based architecture users can now access the OBI EE data in JDeveloper to produce custom applications and Apple iPhone users can view reports and receive alerts no matter where they are. Demonstrations of these technologies will illustrate how these new features can allow access to the BI data any way you want to see it. |
|
| T1098 |
Presentation |
Business Intelligence |
Spatial |
Oracle Database, Oracle Spatial Option, Oracle Application Server, Oracle Mapviewer, Oracle BI Server |
Case Study: Applying Oracle Spatial to Improve Safety and Efficiency in the Barge Shipping Industry |
Joe Leva |
V1.0 Systems, Inc. |
|
|
An example and demo of using Oracle Spatial to enable real-time tracking of asset and vessel locations and movements. This improves safety and monitoring and the acquisition of vessel and cargo related KPIs. For example, we will cover real-time monitoring of river traffic and creating business measures from spatial source data, such as boat miles and operating efficiencies. |
|
| T1099 |
Presentation |
Business Intelligence |
OBIEE |
Oracle BI EE |
Migrating Your Discoverer EUL to OBIEE 10.1.3.4 |
Joe Leva |
V1.0 Systems, Inc. |
|
|
The effort of migrating reports from one tool to another can rival the time of redesign. We review the effectiveness of the Oracle conversion utility for converting Discoverer metadata to OBIEE rpd file metadata and discuss best practices to reduce the likely effort of future migrations. |
|
| T1102 |
Presentation |
Analytics |
Statistical Functions |
Oracle SQL |
Analytic SQL for Beginners |
Mark Inman |
U.S. Navy |
|
|
This is for people who have not used analytic SQL. We will do some very simple examples. Side benefits of attending are learning about (1) buffer gets with respect to query performance, (2) self-joins, (3) set autotrace details, (4) syntax, (5) ranking, (6) reporting aggregate, (7) windowing aggregate, (8) LAG/LEAD, (9) filling in SPARSE data.
|
|
| T1061 |
Presentation |
Warehousing |
ODS - Operational Data Store |
|
Building an SOA-based Virtual Operational Data Store (ODS) and Enterprise Service Bus (ESB) |
Chris Ostrowski |
TUSC |
|
|
Near real-time data warehousing requires real-time access to operational systems and to a shared repository of dimension data. Users can then use the data warehouse environment for strategic reporting and trending, as well as tactical operational reporting. Some data warehouse implementations attempt to address the need for real-time reporting by introducing an operational data store into the architecture and an operational companion to the data warehouse. The operational data store provides an integrated view of operational data. |
|
| T1101 |
Presentation |
Warehousing |
Unstructured Data (Text) |
Oracle Text Option, Oracle Data Mining Option, Oracle BI EE |
Integrating UnStructured Data Into Your Data Warehouse |
Krish Krishnan |
Sixth Sense Advisers Inc |
|
|
Unstructured data in the form of emails, documents, spreadsheets, etc. are an asset of information that is invaluable to an organization. How do you integrate the unstructured data into your data warehouse? What business benefit does this provide to you and how do you even start a process and a program to achieve this within your organization? This session will provide you the starting point of realizing the business value of integrating unstructured data in your data warehouse. The session will feature the use of cool technologies on the Oracle platform including Oracle BIEE, Oracle Data Mining and Text Mining.
|
|
| T1115 |
Presentation |
Business Intelligence |
OLAP |
Oracle OLAP Option, Microsoft Excel |
Microsoft Excel 2007 Pivot Tables Supported Natively in Oracle 11g |
Amyn Rajan |
Simba Technologies |
George Spofford |
DSS Lab, Inc |
Microsoft Excel is considered by many to be one of the most commonly used BI tools in world. Microsoft Excel Pivot Tables are a practical way to access and analyze data. In Excel 2007, Microsoft introduced even more functionality and enhanced the application's ease of use. Up to Oracle 10, Oracle provided an add-in for Microsoft Excel. However, Excel support in Oracle 11g has been missing.
In this session, Simba Technologies looks at Microsoft Excel Pivot Tables and presents a new solution under development that will allow Oracle 11g users to have native MDX connectivity with Microsoft Excel Pivot Tables. Microsoft has added a lot of new functionality in Excel 2007. Simba will demonstrate how this functionality will be made available for Oracle OLAP 11g, so that users can use Microsoft Excel directly with Oracle OLAP the same way that they do with Microsoft Analysis Services and SAP BW.
|
|
| T1049 |
Presentation |
Analytics |
Statistical Functions |
Oracle Database, Oracle Database 10g, Oracle Database 11g |
Analyzing Analytics |
Scott Rappoport |
SAR Consutling |
|
|
Tom Kyte refers to Analytical functions as the greatest thing to happen to SQL since the word SELECT. However, most Oracle professionals only have a cursory understanding, if that, about these innovative functions. This presentation will not only cover the basic syntax and classes of analytical functions, but also provide the user key points to translate business requirements into the proper analytical function. Case studies and examples will be provided to illustrate key applications (and pitfalls) of these very powerful functions. |
|
| T1042 |
Presentation |
Warehousing |
OLAP |
Oracle Database 11g, Oracle OLAP Option |
The Use of Cube Organized Materialized Views as a Summary Management Technique in Data Warehouses |
Peter Scott |
Rittman Mead Consulting |
|
|
The 11g release 1 of the Oracle database introduces Cube Organized Materialized Views to Oracle OLAP. This new feature permits standard SQL queries (such as those generated by non-OLAP aware reporting tools) to transparently access OLAP cube data through a query rewrite mechanism. This session introduces the feature, its uses and limitations before investigating the benefits (or drawbacks) of using Cube Organized Materialized Views in comparison with conventional summarization techniques such as materialized view summary tables and the SQL cube views available in Oracle 10g OLAP. |
|
| T1092 |
Presentation |
Analytics |
Data Mining |
Oracle Data Mining Option |
Priorities and Practices of Data Miners: Oracle Users' Perspectives |
Karl Rexer |
Rexer Analytics |
|
|
In early 2008 Rexer Analytics conducted a 34-item online survey of data miners in order to assess the algorithms and tools currently being employed, the priorities considered in selecting these tools, the types of data analyzed, and the challenges facing the data mining community. The survey was a partial replication of a survey conducted in 2007 with expanded focus on certain areas of interest. The survey received 348 responses from individuals in 44 countries. Respondents employed by tool vendors (n = 83) were removed prior to most analyses. The data miners were largely an experienced group, with over half engaged in data mining for more than five years and nearly all having an advanced degree.
Decision trees, regression, and cluster analysis are by far the most commonly used algorithms. The use of time series and survival analysis have increased this year as compared to 2007. Data miners most value dependability, the ability to handle very large datasets, and quality output in the selection of their software packages. Dirty data, data access issues, and explaining data mining to others are the top challenges faced by data miners. Data miners are most likely to use descriptive stats, outlier detection, and face validity as means of identifying/addressing dirty data. Data mining is playing an important role in organizations today, with half of data miners indicating that their results are helping to drive strategic decisions and operational processes. However, there are concerns with how data mining is being utilized, with the most prevalent concern being resistance to using data mining in contexts where it would be beneficial, insufficient training of some data miners, and lack of model refreshing.
While SPSS and SAS continue to dominate the data mining software market, Oracle Data Miner (ODM) increased in usage from 13% in 2007 to 18% of data miners in 2008. In the 2008 study, ODM users reported greater use of support vector machines and proprietary algorithms than non-users. When selecting a data mining tool, ODM users placed greater emphasis on the ability to modify algorithms and less emphasis on ease of use than did others. ODM users are more likely than non-users to identify dirty data as a challenge facing data miners, and are more likely to employ outlier detection to address that concern. Lastly, larger proportions of ODM users are involved in applying data mining in government when compared to users of other tools.
|
|
| T1007 |
Presentation |
Business Intelligence |
Business Intelligence |
Oracle Database 11g, Oracle BI EE Plus, Oracle Hyperion Enterprise Performance Management Application, Oracle Warehouse Builder, Oracle Data Integrator |
Oracle BI In a Nutshell |
Matthew Vranicar |
Piocon Technologies, Inc. |
|
|
This session will uncover the Business Intelligence features provided in an array of Oracle technology solutions. It will highlight some of the key BI features in the Oracle 11g Database. It will also present the OBI EE tools and the Hyperion EPM tools, including an overview of the integration points between the two. Oracle's two prominent ETL tools will also be described, comparing and contrasting the differences and similarities between OWB and ODI. |
|
| T1096 |
Presentation |
Warehousing |
Database |
Oracle Database 10g, Oracle Technology Network (OTN) |
Aces in the Hole: Learning Advanced SQL Techniques from the OTN Forum Pros |
Greg Pike |
Piocon Technologies |
|
|
As data warehouses continue to expand in both complexity and volume, accessing data in a timely and efficient manner for reporting, Business Intelligence dashboards, or applications continues to be an enduring issue.
Although seasoned professionals understand the benefits of resolving response-time issues with efficient queries, the volunteer experts and Oracle Ace contributors on OTN's SQL and PL/SQL discussion forums raise the query writing bar to an entirely new level. Oracle professionals at any skill level will find the OTN forums packed with a treasure chest of mind-blowing tips, tricks and techniques. With over 60,000 topics and 325,000 posts, the SQL and PL/SQL forums are the mother lode of education from recognized experts worldwide.
In this session, the powerful techniques of advanced query authoring are explored by reviewing real-world forum threads and the creative solutions posted by the gurus. The resident experts from the OTN forums solve complex problems using a combination of analytic functions, hierarchical queries (CONNECT BY), collections (COLLECT), XML functions/operators (SYS_XMLGEN, and XMLSEQUENCE), Pipelined Functions, the MODEL clause and more. |
|
| T1090 |
Presentation |
Business Intelligence |
OBIEE |
Oracle BI EE Plus, Oracle BI SE |
Ensuring Success with an Initial OBIEE Plus Project |
Matthew Metrik |
Piocon Technologies |
|
|
Oracle Business Intelligence Enterprise Edition Plus (OBIEE Plus) delivers an entirely new and advanced set of dashboard and reporting functionality to Oracle customers. Organizations can utilize OBIEE Plus to very rapidly deliver a set of dashboard pages that display high-level KPI values, as well as integrated additional reporting to support, validate, and expand the information contained in the KPIs. Customers who have used other Business Intelligence tools from Oracle will be impressed with the ease of development, ease of use and ability to modify and extend reports and visualizations without complex coding or modification of any queries.
At the same time, OBIEE Plus is a substantial software investment and its cost must be justified to the business. Management will be looking to understand what benefits and additional functionality are delivered, and business users will be interested in how the tool will improve their daily consumption of data and information.
Because of the issues stated above, identifying and scoping the initial project with OBIEE Plus to showcase the new functionality and development benefits of the tool is vital to ensuring adoption and proliferation of OBIEE in the business user community. You only have one chance to make a first impression!
This presentation will provide real-world examples of successful initial OBIEE Plus projects in organizations and detail why they were successful. Items discussed will be choosing the business/subject area for the project; choosing the data source(s); identifying legacy reporting content as a starting point for OBIEE Plus development, demonstrating the speed of OBIEE Plus development to users, and documenting the "human workflow" of business users in OBIEE Plus.
|
|
| T1067 |
Presentation |
Business Intelligence |
BI Publisher |
Oracle Application Express, Oracle BI Publisher |
Advanced Report Printing with Oracle Application Express and Oracle BI Publisher |
Marc Sewtz |
Oracle USA, Inc. |
|
|
Oracle Application Express used together with Oracle BI Publisher allows business users to print professional-looking reports, including charts and other visual aids. This session will provide an overview of the printing capabilities built into Application Express, discuss the Web Services based integration with BI Publisher and highlight some of the recent printing enhancements. It will include a live demonstration on how to create high-fidelity reports using custom RTF report templates, including charts and images and utilizing the print API for scheduled generation and emailing of reports. |
|
| T1107 |
Presentation |
Applications |
Data Mining |
Oracle ListeningPost, Oracle Data Mining Option, Oracle Blogging, Adobe Flex, Amazon Cloud Computing |
Oracle ListeningPost |
Grant Emeny-Smith |
Oracle USA |
|
|
What's hot and what's not? Applying Oracle Data Mining to the CRM domain. Combine enterprise information flows with social information flows to deliver a real-time "pulse" of what's important to your employees, partners, analysts and customers.
Learn about an innovative deployment technique where the server components are installed in the Amazon Cloud (EC2) and the client components are built using Adobe Flex. Following a short presentation describing the approach taken in developing the solution, each component will be demonstrated and discussed in more detail. |
|
| T1024 |
Presentation |
Applications |
Domain-Specific Warehouse |
Oracle Data Warehouse for Retail |
Save Time and Money with Pre-built Data Warehouse for Industry |
Carla Daniels |
Oracle USA |
|
|
Oracle Data Warehouse for Industry (ODW-I) transforms your data into insightful information so you can make accurate forecasts, predict trends, and see patterns that help you make better, more informed decisions. ODW-I is specific to industries (retail, telco, FSI): It includes industry best practices, with extensive coverage for all operational transactions including the latest trends as well as traditional initiatives. Hear how customers are using ODW-I to save $$ and improve margins. |
|
| T1020 |
Presentation |
Warehousing |
OLAP |
Oracle Database, Oracle OLAP Option |
Using Cube-Organized Materialized Views For Improving the Query Performance of Business Intelligence Applications |
William (Bud) Endress |
Oracle Corporation USA |
|
|
Cube-organized materialized views, new to Oracle 11g, provide a high performance summary management solution to SQL-based business intelligence applications that commonly query aggregate level data. DBAs and data warehouse designers can use cube-organized MVs as an alternative to table-based MVs or summary tables to improve end user query performance and data refresh times and to simplify management of the data warehouse. Summary data in cube-organized MVs is accessed automatically using the automatic query rewrite feature of the database, making cube-organized MVs transparent to BI apps. |
|
| W1002 |
Workshop |
Warehousing |
OWB - Oracle Warehouse Builder |
Oracle Warehouse Builder, Oracle Database |
ETL for Data Warehousing with OWB |
Antonio Romero |
Oracle Corporation |
|
|
OWB is the primary tool for data integration and data warehouse design for Oracle database customers, and offers special features that greatly improve developer productivity when loading data warehouses. This session will introduce the basic architecture of loading a data warehouse, and walk you through actually creating ETL mappings in OWB to move data to an ODS and then into a warehouse. You will also use and learn the value of features like data lineage and impact analysis, enabled by OWB's rich metadata about sources, targets and transformations. |
|
| T1026 |
Presentation |
Warehousing |
OLAP |
Oracle OLAP Option, Oracle Database, Oracle Analytic Workspace Manager (AWM), Oracle Warehouse Builder |
OLAP Performance Tuning - Best practices |
Marty Gubar |
Oracle Corporation |
|
|
Oracle OLAP is the most powerful and scalable OLAP server on the market. Because OLAP is inside the database it inherits all the native scalability, security and performance of the Oracle database. However, because the database is so fast and scalable there is a tendency to ignore certain design principles when building an OLAP data model. If the original design and methodology is sound then tuning is very quick and easy to manage. But there is no silver bullet to make OLAP go faster. The aim of the presentation is to provide a framework for tuning OLAP data models. |
|
| T1028 |
Presentation |
Warehousing |
Cost-Based Optimizer |
Oracle Database 11g |
Oracle Database 11g the Optimizer Uncovered! |
Maria Colgan |
Oracle |
|
|
Since its introduction in Oracle 7, people have been fascinated and intimidated by the Cost-Based Optimizer and the statistics it relies on. It has long been felt that the internals of the Optimizer were shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This presentation takes a detailed look at the optimizer features introduced in Oracle Database 11g and explains how they will make a DBA's life easier and finally remove the mystery that has surrounded the Oracle optimizer. |
|
| T1071 |
Presentation |
Analytics |
Spatial |
Oracle Database 11g, Oracle Spatial Option |
What can "Semantic Technologies" do for Business Applications? |
Bill Beauregard |
Oracle |
|
|
The Semantic Web represents the next step of data management and application integration. The benefits of semantic technologies include the aggregation of heterogeneous data using explicit semantics, simplified annotation and sharing of findings, the expression of rich and well defined models for data aggregation and search, and the application of logic to infer additional insight. This session provides an overview on using the Oracle Database 11g RDF and OWL data management features. It also illustrates how application developers are using semantic technologies in enterprise settings. |
|
| T1029 |
Presentation |
Warehousing |
Partitioning Option |
Oracle Partitioning Option |
An Inside Look at Oracle Partitioning |
Badhri Varanasi |
Oracle |
|
|
Partitioning is one of the key technologies to support large data volumes for data marts, data warehouses, and online transaction processing systems. Oracle Partitioning not only addresses the performance requirements, but also provides key manageability functionality to manage high data volumes. This session briefly discusses the evolution of Oracle Partitioning and provides insight into key functionalities and design decisions. Implementation best practices will be discussed and Oracle Partitioning will be compared to other offerings in the market. |
|
| T1002 |
Presentation |
Business Intelligence |
OLAP |
Oracle Database, Oracle OLAP Option, Oracle Essbase |
Architecting an OLAP Solution From Oracle |
William Endress |
Oracle |
Robin Hazel |
Oracle |
Oracle provides a comprehensive set of OLAP solutions that include capabilities embedded in the Oracle database as well as database-independent technology. This session will provide an overview of Oracle's strategic OLAP technologies: the Oracle database OLAP option and Hyperion Essbase. You will learn where and how these complementary technologies fit in an enterprise BI deployment. The session will address technology, architecture, use cases, and deployment options for OLAP solutions from Oracle. |
|
| W1009 |
Workshop |
Business Intelligence |
BI Publisher |
Oracle BI Publisher |
BI Publisher |
Nikos Psomas |
Oracle |
|
|
This hands-on session provides an overview of Oracle Business Intelligence (BI) Publisher, Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents.
In this tutorial, you will learn how to create reports using BI Publisher based on conventional data sources (such as Oracle Database), including reports with parameters and list of values (LOVs). You will learn how to use Template Builder (a MS Word plug-in) to create RTF templates to generate reports in various layouts and output formats. You will also learn how to create reports that use Oracle BI subject areas and Oracle BI Answers requests as a data source. You will learn how to publish reports to OBIEE Interactive Dashboards, and how to add dashboard-level prompts. Finally, you will learn how to configure BI Publisher scheduler and schedule reports
|
|
| T1116 |
Presentation |
Business Intelligence |
Business Intelligence |
Oracle Applications Express |
Behind the Scenes with the APEX-based BIWA Summit '08 Application |
Mark Hornick |
Oracle |
Tony Jedlinski |
Konoso |
Come for an informal presentation and discussion highlighting the application built to support BIWA Summit '08. The session management website facilitated content review and selection, and followup with speakers, as well as providing statistics on the Summit itself and results from the BIWA Summit Survey. |
|
| T1018 |
Presentation |
Warehousing |
Development |
Oracle Database |
Best Practices For Data Warehousing Using Oracle |
Maria Colgan |
Oracle |
|
|
Have you wondered whether your data warehouse is getting the best performance that it could? Or whether you've made the right decisions to keep your multi-TB system highly available? Then come to this session to learn best practices for deploying a data warehouse on Oracle Database 11g. With clear examples, this session will cover schema design, partitioning strategies, parallel query setup, loading strategies, storage configuration, and more. |
|
| T1008 |
Presentation |
Warehousing |
MDM - Master Data Mgmt |
|
Better Information through Master Data Management: (MDM) as a Foundation for BIWA |
David Butler |
Oracle |
|
|
Master Data Management (MDM) is the central source for accurate, fully cross-referenced, real time master data. It must seamlessly integrate with Data Warehouses (DW) and Business Intelligence (BI) systems. This session will discuss what it means to 'manage' master data and outlines Oracle's MDM solution. The audience will learn the central role MDM plays in information quality, accurate and actionable reporting, and data warehouse operationalization. |
|
| T1052 |
Presentation |
Business Intelligence |
Crystal Ball |
Oracle BI EE, Oracle Crystal Ball |
Beyond BI: Adding Forecasting Analytics to Business Intelligence |
Lucie Trepanier |
Oracle |
|
|
Have you ever wanted to use historical data, readily available from your BI dashboards, to better predict the future? How about solving business problems where you have solid data informing part of your model, but only rough guesses about other key drivers?
This session will show how forecasting and predictive analytics can be added to Business Intelligence to enable accurate and statistically sound business modeling, geared to answering "what if?" questions about the future.
As examples, we will show how a top pharmaceutical company uses predictive analytics for driver-based revenue forecasting, and how a leading global energy company uses probabilistic forecast to manage oil field costs and risks. |
|
| T1072 |
Presentation |
Applications |
Data Mining |
Oracle Spend Analytics, Oracle Data Mining Option, Oracle Data Integration Suite |
Birds of a Feather Flock Together: Transform your Spend Management with Oracle Spend Classification and Spend Analytics |
Chandra Yeleshwarapu |
Oracle |
Keshava Rangarajan |
|
To get a handle on your spending for both direct and indirect materials, you have to capture and analyze the procurement spend. The challenge is that the spend is often not properly classified, resulting in lost opportunities to source from a better supplier or negotiate with your current suppliers. Incorrect spend classification also creates opportunity for maverick spending, incorrect budgeting and controls.
The solution to this problem is a better classification process that uses techniques in data cleansing and classification. |
|
| T1066 |
Presentation |
Business Intelligence |
Applications |
Oracle BI Applications, Oracle BI EE, Oracle Fusion Middleware |
Build vs Buy: The Case For Oracle BI Applications |
Joe Thomas |
Oracle |
|
|
Oracle's prebuilt BI Applications can provide powerful cross-enterprise analytics in one third the time and using one third the resources of a custom built solution. Leveraging the power of OBI EE and Oracle Fusion Middleware, along with the BI best practices of Oracle's 30 years of BI experience, these applications are an excellent complement to any BI initiative and work across all lines of business. An architecture overview and roadmap of the BI Applications will be presented. |
|
| T1057 |
Presentation |
Business Intelligence |
Essbase |
Oracle Essbase, Oracle Essbase Studio, Oracle Hyperion Smart View for Office |
Building and Linking Custom Analytic Applications via Essbase Studio |
Zhongwei Li |
Oracle |
Aneel Shenker |
Oracle |
This presentation will demonstrate the capabilities of Essbase Studio for creating and maintaining custom Analytic Applications. The presentation describes modeling of relational and textual data sources, creation of hierarchies, cube design and deployment. Oracle Essbase's dynamic drill through capabilities allows flexible drill through to relational, URL, and OBIEE targets. This presentation will include live demonstrations of features delivered in the latest 11.1.1 release of Oracle Essbase. |
|
| W1010 |
Workshop |
Business Intelligence |
BIC2G |
Oracle BIC2g |
Business Intelligence Enterprise Edition Challenge To Go Virtual Appliance |
Derrick Cameron |
Oracle |
|
|
This is to announce the imminent release of the new windows based BIC2g:BI demonstration and training virtual appliance. This is the same windows based training and demonstration appliance that internal Oracle sales consultants use to train and present Oracle BI solutions to customers and partners and is used for many of the hands-on sessions at BIWA Summit. This is a fully self contained platform packed with preconfigured Oracle BI solutions, and includes a large repository of training and demonstration content, including training tutorials (OBE, ODI), Oracle BIEE (tech and apps content), BI Analytic Applications (complete with full ETL), Oracle Data Integrator, Oracle Real Time Decisions, Oracle OLAP, and the full Hyperion solution stack (Essbase, Interactive Reporting, Financial Reporting, Web Analysis, etc.). It also includes pre-configured integration between BIEE-Hyperion Workspace-BI Publisher-Delivers, and many other integration demos and proof points. In short, a complete pack'n go BI/DW solution platform. This session will provide a hands on look at this new appliance, with information on how to source your own copy. |
|
| T1111 |
Presentation |
Warehousing |
RAC |
Oracle Real Application Clusters (RAC) |
Can OLTP and OLAP Get Along in the Same Physical Database? |
Daniel Liu |
Oracle |
|
|
There are many hybrid database systems with OLTP and OLAP data on the same physical database. A
big, long-running report could potentially have a huge performance impact the OLTP operation. To resolve this problem, we separate the OLTP data and OLAP data into two physical databases on two
separated servers. However, moving data from one system to another slows down the ETL process, in addition, it adds the overhead of managing multiple databases.
This presentation will demonstrate how to use Oracle Real Application Clusters (RAC) to resolve this dilemma. The session will review in detail how to setup a RAC system for both OLTP and OLAP systems. It will also examine the performance impact on CPU, memory (SGA) and IO. |
|
| T1074 |
Presentation |
Analytics |
Data Mining |
Oracle Data Mining Option, Schedule Builder from George P. Johnson |
Case Study: Recommending Conference Sessions at Oracle OpenWorld with Oracle Data Mining |
Mark Hornick |
Oracle |
|
|
With over 1,700 sessions at Oracle OpenWorld 2008, finding the right sessions to attend could be challenging. To help attendees easily find sessions that match their interests, we developed a recommendation engine to help attendees find sessions most relevant to them based on their profile and relationships extracted from actual Oracle OpenWorld 2007 data.
The list of recommended sessions is generated based on attendees' registration survey responses combined with a new technique called "Projection Mining" that leverages attendance data from Oracle OpenWorld 2007 and session information from Oracle OpenWorld 2008. This recommendation engine is powered by Oracle Data Mining. |
|
| W1003 |
Workshop |
Warehousing |
Data Quality |
Oracle Warehouse Builder |
Data Quality in ETL with OWB |
Antonio Romero |
Oracle |
|
|
OWB's integration of data quality (DQ) into ETL sets it apart from competitors. Other data profiling and DQ solutions use separate tools, require extensive data movement, and add to development tasks rather than reducing them. OWB flips all this on its head: use one tool, move small code to big data, discover data rules through profiling, and use those rules in ETL, data cleansing, and auditing without writing code yourself. In this workshop you will use OWB to see its unique approach to making DQ part of ETL. |
|
| T1054 |
Presentation |
Business Intelligence |
Development |
Oracle Essbase, Oracle JDeveloper |
Developing Essbase Applications via JDEV and ADF |
David Mellor |
Oracle |
|
|
This session will introduce new capabilities for Essbase to utilize the Application Development Framework via an extension for Oracle JDeveloper. JDeveloper is a complete IDE for Service-Oriented Architecture (SOA) and Java. The developer can now use the full power of JDeveloper to develop components such as member selectors, pivot tables as well as building predefined dashboards with a variety of visualizations. The session will provide an interactive demonstration by building a sample application in JDeveloper which highlights the Essbase integration. |
|
| T1059 |
Presentation |
Business Intelligence |
Hyperion&Essbase Rpt |
Oracle Business Intelligence, Oracle Hyperion Enterprise Performance Management Application, Oracle Essbase |
Extending Performance Management & BI from the Browser to the Desktop: Introducing Oracle Hyperion Smart View |
Premjith Balakrishnan |
Oracle |
|
|
Smart View enables business users to access a wide variety of performance management & BI functionality from within Microsoft Office products: Excel, Word & PowerPoint. The range of functionality supported by Smart View can be grouped into the following categories:
-Ad hoc analysis
-Structured forms based interaction
-Importing BI content: Query ready!
-Working with operational data
-Report Designer
-Forecasting and Simulation
-Building analytic front ends using VBA
Smart View plays a strategic role in delivering rich functional capabilities of EPM and BI applications to the Office suite. |
|
| T1012 |
Presentation |
Analytics |
Data Mining |
Oracle Database, Oracle Data Mining Option |
Fraud and Anomaly Detection Using Oracle Data Mining |
Charlie Berger |
Oracle |
|
|
How do you find needles in haystacks? How can you detect rare events, fraud, anomalies, and network intrusions in your corporate databases and operations? Oracle Data Mining's (ODM) Anomaly Detection algorithm trains on what is considered "normal" and then flags any record(s) that, on a multi-dimensional basis, appear to not fit in. Find suspicious expense report submissions, find non-compliant tax submissions, combat fraud in healthcare claims and save huge amounts of money in fraud and abuse. This presentation and demo will show several use cases of ODM's anomaly detection. |
|
| T1069 |
Presentation |
Applications |
Data Mining |
BI Applications, Oracle Pricing Analytics, Oracle Data Mining Option, Oracle BI EE |
Getting to the Right Price: Using BI Apps with Oracle Data Mining and Statistics to Improve Your Company's Margins |
Rachel Scales |
Oracle |
|
|
How do your business users set and manage price in your organization? Are they still doing the bulk of the work in Excel and e-mail? Come hear about how Oracle's Pricing Analytics application and BI tools can help business users improve pricing and increase your company's margins.
We'll explain how we have incorporated domain knowledge of pricing into a combination of OBIEE, Oracle Data Mining models, OLAP, and statistical analysis to help users identify pricing opportunities and outliers, identify pricing segments and determine recommended pricing floors. |
|
| T1110 |
Presentation |
Warehousing |
Warehousing |
HP Oracle Database Machine |
Increase Data Warehouse Performance by 10-100x w/ HP Oracle Database Machine & Exadata Storage |
Louis Nagode |
Oracle |
|
|
With Larry Ellison's OpenWorld 2008 announcement of the HP Oracle Exadata Storage Server and the HP Oracle Database Machine, Oracle is revolutionizing high performance data warehousing. Customers are experiencing performance boosts of 1 to 2 orders of magnitude over their current Oracle data warehouses.
The HP Oracle Exadata Storage Server has smart storage software that offloads data-intensive query processing from Oracle Database 11g Servers and does the query processing closer to the data. It is at the heart of the HP Oracle Database Machine, a complete system, including software, servers, and storage, designed to run high performance multi-terabyte data warehouse.
Since this is just a hardware accellerated version of the normal Oracle Database, it is also the only "appliance" that can support a mixed Data Warehouse and OLTP workload.
This presentation is a technical drill down that follows up on Juan Loaiza's keynote on December 3rd, at 8:00. |
|
| T1032 |
Presentation |
Analytics |
DM&OLAP |
Oracle Database 11g, Oracle OLAP Option, Oracle Data Mining Option, Oracle BI EE, Oracle Application Express |
Intelligent OLAP: Deliver Deeper Insight by Combining Data Mining and OLAP |
Marty Gubar |
Oracle |
|
|
Who are my high value customers? How do you characterize these customers? What is their impact on the bottom line? Are they gaining or losing importance? Oracle Database 11g provides an analytic platform to help you uncover answers to these questions. Oracle Data Mining enables you to identify patterns and insights that may be hidden in your data. Using these discoveries as input into OLAP allows for the development of intelligent cubes, delivering meaningful analytics that lead to smarter decisions. This session will step you through a use case that illustrates these capabilities. |
|
| T1031 |
Presentation |
Business Intelligence |
Development |
Oracle Database 11g, Oracle OLAP Option, Oracle Application Express |
Interactive Executive Insight : Building Intelligent Dashboards with APEX and OLAP |
Marty Gubar |
Oracle |
|
|
Oracle Application Express (APEX) is an intuitive, web-based development environment that is part of Oracle Database 11g. Oracle OLAP - a rich analytic engine also embedded in the database - easily delivers fast answers to analytic queries. APEX and Oracle OLAP used together allow you to develop executive dashboards that enable users to interactively explore data and gain valuable insights. In this session, learn how APEX can leverage OLAP cube views to develop these types of applications. |
|
| W1001 |
Workshop |
Business Intelligence |
OBIEE |
Oracle Discoverer, Oracle BI EE |
Migrating Oracle Discoverer to Oracle Business Intelligence Suite Enterprise Edition Plus |
Derrick Cameron |
Oracle |
Praveen Deshpande |
Oracle |
This session covers migrating from Oracle Discoverer to Oracle Business Intelligence Suite Enterprise Edition Plus. Hear how Oracle Discoverer metadata and worksheet concepts correspond to Oracle Business Intelligence Suite Enterprise Edition Plus concepts and how to create Oracle Business Intelligence Suite Enterprise Edition Plus physical, logical, and presentation layers using information from Oracle Discoverer. Learn best practices and see a demo of Oracle Discoverer's metadata conversion assistant for accelerating metadata migration to the suite.
|
|
| W1008 |
Workshop |
Business Intelligence |
OBIEE |
Oracle BI EE Plus |
OBI EE Hands-on Workshop (also offered on Wednesday) |
Gayl Czaplicki |
Oracle |
Terry Mitchell |
Oracle |
This session provides a high-level demonstration of Oracle's premier business intelligence solution and its value proposition. Using the Oracle INTEL/BIC2G virtual machine environment you will do hands-on exercises where you can quickly create Oracle Answers reports and place the reports in an Oracle Dashboard. You will also learn about the MS Office interface to BI EE. You will take away knowledge of how easily your business workflow processes can be handled by OBI EE.
|
|
| W1008a |
Workshop |
Business Intelligence |
OBIEE |
Oracle BI EE Plus |
OBI EE Hands-on Workshop (REPEAT - also offered on Tuesday) |
Gayl Czaplicki |
Oracle |
|
|
This session provides a high-level demonstration of Oracle's premier business intelligence solution and its value proposition. Using the Oracle INTEL/BIC2G virtual machine environment you will do hands-on exercises where you can quickly create Oracle Answers reports and place the reports in an Oracle Dashboard. You will also learn about the MS Office interface to BI EE. You will take away knowledge of how easily your business workflow processes can be handled by OBI EE. |
|
| T1046 |
Presentation |
Business Intelligence |
BI Publisher |
Oracle BI Publisher |
Oracle BI Publisher Overview: New and Planned Features |
Mike Donohue |
Oracle |
|
|
Oracle Business Intelligence Publisher is Oracle's strategic enterprise reporting solution to author, manage, and deliver all types of highly formatted documents eliminating the need for costly point solutions. Built on open standards, IT staff and developers can create data models against practically any data source and use BI Publisher Web Services or Java APIs to build custom applications leveraging existing data sources and infrastructure. End users can easily design report layouts using familiar desktop tools, reducing the time and cost needed to develop and maintain reports. |
|
| T1015 |
Presentation |
Analytics |
Data Mining |
Oracle Data Mining Option, Oracle Applications, Oracle BI EE, Oracle Statistical Functions, |
Oracle Data Mining Delivers Better BI and Powers Next Generation Predictive Applications |
Charlie Berger |
Oracle |
|
|
With Oracle Data Mining, by bringing the analytics (data mining, text mining, and statistical functions) to the data, Oracle has delivered on a strategy to transform the database to an analytical database. The Oracle Data Mining Option enables companies to discover patterns and relationships, make predictions, answer complex questions, develop better BI dashboards (OBI EE), and power "next generation predictive applications."
To succeed, companies must leverage all their data, extract more information, and gain greater insight. With Oracle Data Mining, you can:
- Build predictive data mining models that target your best customers
- Discover profiles of your best and worst customers using IF..THEN.. rules that describe them
- Identify relationships, find new segments, detect anomalies, and perform market basket analysis
This presentation will provide an overview and demo of Oracle Data Mining, better BI reports using OBI EE, and provide examples of next generation predictive applications now available and a vision for the future of predictive applications.
|
|
| K1003 |
Keynote |
other |
Database Machine |
|
Oracle Database 11g for Data Warehousing and the HP Oracle Database Machine |
Ray Roccaforte |
Oracle |
|
|
Oracle Database 11g is a comprehensive database platform for data warehousing and business intelligence that combines industry-leading scalability and performance, deeply integrated analytics, and embedded integration and data quality--all in a single platform running on a reliable, low-cost grid infrastructure. Learn how Oracle achieves the next level of Data Warehouse performance, scalability, and ease of deployment with the HP Oracle Database Machine. |
|
| T1058 |
Presentation |
Business Intelligence |
Essbase |
Oracle Essbase, Oracle Essbase Studio, Oracle Hyperion Smart View, Oracle Hyperion Visual Explorer for Hyperion Essbase |
Oracle Essbase: The Enterprise Performance Management Application Infrastructure |
Vladimir Rozov |
Oracle |
|
|
This session will focus on the latest Oracle Essbase 11.1.1x release. New powerful features such as Changing Attributes, Typed Measures, Trickle Feeds, Real-Time OLAP and heterogeneous partitions will be introduced. Whether these features are used independently or in combination, rich Performance Management and BI applications previously considered too cumbersome for OLAP technology are now readily possible. This session will include demonstrations of key features discussed. |
|
| K1002 |
Keynote |
Warehousing |
Database Machine |
|
Oracle Exadata - Extreme Data Warehousing Performance |
Juan Loaiza |
Oracle |
|
|
Oracle Exadata is a family of high performance storage software and hardware products that can improve data warehouse query performance by a factor of 10X or more. Oracle Exadata Storage is a combination of smart storage software from Oracle and industry-standard hardware from HP. Overcoming the limitations of conventional storage, Oracle Exadata uses a massively parallel architecture to dramatically increase data bandwidth between the database server and storage. In addition, smart storage software offloads data-intensive query processing from Oracle Database 11g Servers and does the query processing closer to the data. The result - faster, parallel data processing, and better business results.
|
|
| T1030 |
Presentation |
Warehousing |
Warehouse Scalability |
Oracle Database |
Oracle Parallel Execution - How to Survive in a Parallel Universe |
Hamid Djam |
Oracle |
|
|
Parallel execution was first introduced in Oracle more than a decade ago to enable organizations to manage and access tens, if not hundreds, of terabytes of data. And parallel execution continues to be enriched and improved. This session discusses the parallel execution architecture of Oracle Database 11g and shows its superiority over alternative architectures for real-world applications. It also touches on how to control and monitor parallel execution. |
|
| T1043 |
Presentation |
Business Intelligence |
Business Intelligence |
Oracle BI EE, Oracle Essbase, Oracle OLAP Option, Oracle Data Mining Option, Oracle Warehouse Builder, Oracle BI Applications, Oracle SOA Suite |
Oracle's Business Intelligence Strategy |
Tobin Gilman |
Oracle |
|
|
Oracle delivers business intelligence capabilities in the database, middleware, and applications layers. This session is targeted at individuals responsible for BI and data warehousing implementations within their organizations. It will outline Oracle's BI strategy, and identify Oracle's core BI products, including BI applications and tools, OLAP, and integration technologies. It will provide guidance on how to select the right Oracle technology for common BI requirements, as well as outline future directions for the Oracle's BI products that are widely deployed at customer sites today. |
|
| T1055 |
Presentation |
Business Intelligence |
Development |
Oracle JDeveloper 11g, Oracle Application Development Framework (ADF), Oracle ADF Data Visualization Components |
Powerful Data Visualization with Oracle JDeveloper 11g ADF Data Visualization Components |
Shay Shmeltzer |
Oracle |
|
|
Oracle JDeveloper 11g and Oracle's Application Development Framework (ADF) offer a powerful and productive environment for building rich Internet applications. Oracle ADF Data Visualization components (ADF DVT) are a set of rich, interactive JSF components that provide significant capabilities for visualizing and analyzing data. ADF DVT components include Graph, Gauge, Geographic Map, Pivot Table, Gantt Chart, and Hierarchy Viewer. This session provides an introduction to ADF DVT components and discuss different ways of accessing BI and other types of data. |
|
| T1035 |
Presentation |
Applications |
Data Mining |
Oracle HCM Application, Oracle Data Mining Option, Oracle Business Intelligence |
Predictive Analytics for Human Capital Management |
Brian Gaspar |
Oracle |
|
|
Human Capital is the largest asset within most companies. Yet, these critical assets are often mismanaged due to the lack of necessary business intelligence and insights. Today, a new breed of human capital professionals and applications are using predictive analytics to better understand employees, anticipate voluntary employee termination and understand the contributing factors, hire the right employees, counsel employees so they can best perform in their careers. This presentation and demo will use Oracle Data Mining in HCM use cases. |
|
| W1005 |
Workshop |
Analytics |
Data Mining |
Oracle Data Mining Option |
Predictive Analytics with Oracle Data Mining |
Charlie Berger |
Oracle |
|
|
Come learn how to get started mining your Oracle data with Oracle Data Mining. This fast-paced hands-on tutorial will teach attendees how to explore their data, find key variables, build predictive models and apply them. Attendees will use Oracle Data Miner (optional GUI to ODM) and demo datasets. Additionally, examples of the ODM SQL and Java API sample code examples will be shown. |
|
| T1094 |
Presentation |
Business Intelligence |
Security |
Oracle BI EE |
Securing Oracle BI Enterprise Edition |
Bryan Wise |
Oracle |
|
|
This presentation will provide a complete overview of security related topics surrounding the deployment of Oracle BI Enterprise Edition. This will include protecting access to Oracle BI itself as well as protecting the data accessed via Oracle BI. After a general overview, the presentation will focus on two specific areas: Single Sign-On (SSO) and row level security. The SSO section will include SSO options and the externalization of group membership. The row level security section will focus on Oracle BI Business Model Filters and Oracle Virtual Private Database integration. Time will be spent on how to setup these two methods of providing row level security. Additionally, the presentation will compare and contrast the two methods. |
|
| T1010 |
Presentation |
Applications |
Data Mining |
Oracle Data Mining Option, Oracle Database, Oracle CRM, Oracle Sales Prospector |
Sell What Your Customer Is Likely to Buy using CRM OnDemand and Oracle Data Mining |
Charlie Berger |
Oracle |
John Kim |
Oracle |
Last year at Oracle Open World 2007, Larry Ellison announced the new Fusion Edge CRM On-Demand Hosted Application with integrated data mining that automatically mines your customer database. Sales Prospector uses Oracle Data Mining to automatically mine customer, purchase, and demographic data to find which customers have purchased products historically so it can recommend new products to customers. This next-generation CRM application embeds a real-time recommendation engine so you can sell what your customer is most likely to want to buy. |
|
| T1036 |
Presentation |
Warehousing |
OWB - Oracle Warehouse Builder |
Oracle Warehouse Builder, Oracle Database, Oracle BI EE |
The Next OWB: Roadmap Review and New BI/DW-Related Features |
Michelle Bird |
Oracle |
|
|
OWB continues to be the tool that addresses data warehousing, data integration, and data quality requirements for Oracle Database customers. To meet those needs in the future, OWB continues steadily along the development roadmap promised in our past public pronouncements. This presentation will flesh out the current roadmap and demonstrate the next release of OWB. Enhancements in our upcoming release address the particular needs of data warehouse and BI customers, as well as offering connectivity from ODI and improved SOA/Web Services integration. |
|
| T1097 |
Presentation |
Business Intelligence |
Spatial |
Oracle BI EE, Oracle Spatial Option, Oracle Fusion Middleware MapViewer |
The Why of Where: Value of Maps and Spatial Analysis in BI Dashboards |
Jayant Sharma |
Oracle |
|
|
Business Intelligence dashboards provide insight by aggregating and distilling complex data into easy-to-grasp and visually appealing displays. This presentation focuses on the benefits and possibilities of geospatial business intelligence. It highlights the value of BI dashboards incorporating functionality such as:
·Displaying data associated with a geographic dimension on a map.
·Allowing drill down or roll up via the map.
·Combining spatial (proximity, containment, aggregation) queries with BI analytics.
·Relating map content to other elements on the dashboard and vice versa.
The primary focus of this session, however, is the business value of geospatial information to any organization. It describes how geospatial software brings not just location and spatial analysis to BI but provides immense value. To individual users, and to an organization through effective and efficient use of an incredibly valuable asset, geospatial information provides much value in enterprise application and business intelligence systems.
|
|
| T1048 |
Presentation |
Warehousing |
Development |
Oracle Database, Oracle Data Warehousing options, Oracle BI EE Plus |
Unusual Oracle Data Warehouse Deployment Strategies: You Can't Make this Stuff Up |
Robert Stackowiak |
Oracle |
|
|
While there are many Oracle-based data warehouse and business intelligence success stories, there are some who struggle to deploy successfully. This session will cover some of the more "out there" deployment examples observed at real customers (who will go nameless). The session will drive home some of the basic considerations that are sometimes overlooked in defining a data warehouse architecture and deployment strategies. Better alternative strategies will be discussed. |
|
| T1103 |
Presentation |
Analytics |
Spatial |
Oracle Spatial Option, Oracle Fusion Middleware MapViewer, Oracle Applications |
Where is what matters: Advanced Spatial Data Management for Enterprise Applications |
Jayant Sharma |
Oracle |
|
|
Oracle Spatial provides advanced spatial capabilities to support geospatial applications, location-based services, and enterprise spatial information systems. Oracle Spatial extends the core location features included in every Oracle database with Oracle Locator. Oracle Spatial's advanced data manipulation and spatial analysis features include spatial aggregates, area and length calculations, and linear referencing. It also includes a GeoRaster datatype to store and manage image and gridded raster data and metadata, network and topology data models, geocoding and routing engines, APIs for quick and easy deployment of mapping, geocoding,and routing services, and spatial analysis and mining functions. These significant capabilities address business-critical requirements of the public sector, defense, logistics, energy exploration, business geographics, and life sciences domains.
The increased use of geospatial analysis and location functionality in business applications is a result of the recent success of consumer mapping applications-aware infrastructure. Now we are seeing map displays and location queries being added to business-activity monitoring applications, business intelligence, call centers, retail merchandising management, and insurance, to name a few.
The Oracle information management platform is unique in its breadth of support for spatial information management. This presentation provides a brief overview of support for spatial
information management in the Oracle database, middleware, development tools, and enterprise applications. Organizations that leverage this functionality have achieved great results through simple steps such as enabling proximity queries and displaying territories or service coverage areas on a map.
|
|
| T1064 |
Presentation |
Business Intelligence |
OLAP |
Oracle OLAP Option, Oracle BI EE |
Building Reports with OBIEE on Top of Oracle OLAP |
Francisco J Silva |
Micros Systems |
|
|
In this session you will see a real application that joins Oracle's Online Analytical Processing (OLAP) engine and Oracle Business Intelligence Enterprise Edition (OBIEE) to produce a successful Business Intelligence (BI) solution. The application combines the power of OLAP pre-aggregated data with the strengths of OBIEE. The results are outstanding; tables with 10s of million of rows return accurate results in matter of seconds for almost any request issued by the users who can now get a full analytic view of their business. |
|
| T1065 |
Presentation |
Business Intelligence |
OLAP |
Oracle OLAP Option, Oracle BI EE, Oracle Database |
Combining OLTP and OLAP in One System for Business Intelligence (BI) |
Francisco J Silva |
Micros Systems |
|
|
Imagine the world of BI with no Extracting, Loading, and Transferring (ETL) of data processes. Can this be achieved? In this session learn about the technical architecture that can combine Oracle's Online Analytical Processing (OLAP) engine and Oracle Business Intelligence Enterprise Edition (OBIEE) within the same database where the production system runs. We will look at the architectures and limitations of each of these systems and how having the OLAP option embedded in Oracle's powerful database can lead you to a successful, cost effective BI implementation. |
|
| T1106 |
Presentation |
Business Intelligence |
Development |
Oracle Database, Oracle OLAP Option, Oracle JDeveloper, Oracle BI Beans |
Investment Research and Portfolio Management Analytics using Oracle OLAP |
Peeyush Shukla |
Mesirow Advanced Strategies |
Chris Claterbos |
Vlamis Software Solutions, Inc. |
Mesirow Financial, a diversified financial services firm, created a set of integrated tools and dashboards to help their analysts manage and analyze their performance. They had the following challenges:
Performant solution needed to aggregate complex hierarchies quickly
Replace existing quantitative statistical application
Data to be fed from Pervasive database to Oracle
Scalability of solution as the data volumes and users increase
Flexibility and speed of rollout essential for multiple applications with common footprint
10 years of historical data, from multiple data sources
Support for dynamically changing model
This presentation provides a technical overview of the solution and demonstrates some of the unique solutions that were created to solve their problems using Oracle Database, OLAP, JDeveloper and BI Beans, including some complex calculations using the OLAP DML language.
|
|
| T1060 |
Presentation |
Business Intelligence |
Development |
Oracle Database, Oracle Warehouse Builder, Oracle Data Mining Option, Oracle Fusion Middleware, InforSense Platform |
Adding Enterprise Analytic Mashup Capabilities to Your Oracle Data Warehouse |
Nick Goode |
InforSense |
|
|
In the Web 2.0 community, many developers experimenting with mashups are using consumer-centric content from eBay, Amazon, Google, and others. Now corporate developers are adopting this concept of combining Web Service elements from a range of vendor solutions with customized, in-house applications to create enterprise mashups. Building flexible enterprise BI applications as service mashups addresses the end-to-end requirements of the analysis process and provides the mechanism to quickly and easily create and share business intelligence applications within your organization. |
|
| T1114 |
Presentation |
Warehousing |
Business Intelligence |
IBM Power, IBM x86 technology and IBM Storage, Oracle Database, Oracle Real Application Clusters (RAC), Oracle Business Intelligence |
Platinum Sponsor Session: Balance and Scale - Building Your Data Warehouse Right! |
Marty Carangelo |
IBM |
|
|
History has proven that attention to component detail is critical to design and implement a successful BI/DW solution. Learn how Oracle and IBM have worked together to design a reference- architecture based BI/DW solution for IBM's Power and x86 hardware infrastructure. Using performance-validated nodes to support specific data requirements, this solution remains balanced in design as it scales to large data sizes. Preloaded and configured with Oracle and IBM components, this solution is delivered ready to begin doing real work in a short period of time. |
|
| T1104 |
Presentation |
Warehousing |
Data Modeling |
Non-specific |
The Question of DW Design Approaches: Contrasting Inmon and Kimball |
Ian Abramson |
IAS Inc |
|
|
The decision to build a data warehouse is one that every organization will need to make if they wish to remain competitive in today's challenging markets. The choice will also lead to another decision that will need to be made. What data warehousing architectural approach should I take? There are two contrasting styles that are widely accepted today. The first was proposed by Bill Inmon who defined the Corporate Information Factory and the warehouse that is a part of this enterprise vision. The other is Ralph Kimball who is the proponent of Dimensional modeling and a bottom-up approach. This presentation will provide details on each approach and compare each so that the attendee may make a better more informed decision when the need to embark on a data warehouse is required. |
|
| T1056 |
Presentation |
Warehousing |
ETL |
Oracle Database, Oracle Partitioning Option, ETL, Oracle Warehouse Builder, GoldenGate |
From Batch-Oriented to Real-Ttime Data Warehousing Loads |
Mark Van de Wiel |
GoldenGate |
|
|
More and more companies are moving towards real-time data warehouses. What are the reasons behind this trend? What does a typical real-time architecture look like from a data movement and data load perspective? How can you leverage the investment in your existing Extract, Transform and Load (ETL) infrastructure to ease the transition toward a real-time data warehouse? Why is the Oracle Database well-positioned to benefit from the trend towards real-time data warehousing? This session will answer these questions and discuss an example of a real-time data warehouse architecture in detail. |
|
| T1034 |
Presentation |
Warehousing |
Partitioning Option |
Oracle Database EE, Oracle Partitioning Option, Oracle Data Warehousing features |
Scaling to Infinity: Partitioning Data Warehouses on Oracle |
Tim Gorman |
Evergreen Database Technologies, Inc. |
|
|
Partitioning is crucial to data warehouses, but how do you use this functionality effectively? What other advanced DW features of Oracle does partitioning enable, and how, and why? Is there even a "linkage" between data warehousing within Oracle? The answer is very much a resounding "YES". This presentation is the result of over 14 years of experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems capabilities. It will change (or validate) the way you think about building, designing, and loading DW on Oracle. |
|
| T1117 |
Presentation |
Analytics |
Unstructured Data (Text) |
Oracle Database 11g, Oracle Database 10g, Oracle Text Option, Oracle Data Mining Option |
Oracle Text and Text Mining: Let's Add Value to Your Unstructured Data |
Shyam Varan Nath |
Deloittte Consulting |
|
|
This workshop is a hands-on session showing how to handle unstructured data, such as free text, in the organization. The first part of the session focuses on Oracle Text features: how text can be handled by Oracle database, the concept of of the text index, and related topics. In the second part of the session, attendees get to experiment with SQL queries with text options to make searches and to use text operators.
Demonstrations of several Oracle text based applications will show how it all comes together. Time permitting, Oracle Data Mining will be shown with example of building a classifier based on text data (for example, determining if an email message is spam or regular email). |
|
| T1004 |
Presentation |
Warehousing |
Data Compression |
Oracle Database, Oracle Compression, Oracle Data Warehousing features |
Honey, I Shrunk the Data Warehouse! |
Shyam Varan Nath |
Deloitte Consulting LLP |
|
|
In this session, we look at the use of the compression features of Oracle Database that allows us to shrink the data warehouses in size tremendously. First, we review the history of compression, starting with the Oracle 9i when it was first introduced, continuing to 11g features of Advanced Compression such as OLTP table compression. The ability of the Oracle server to read a compressed block without the overhead of having to uncompress it first reduces performance overhead significantly. Additionally, the need to read fewer I/O blocks provides performance benefits. We will look at SecureFiles to reduce the storage needs for unstructured data. To complete the full solution, we need to compress the metadata, the dump files during the export using the Data Pump and compress the backup files as well. We will look into each of these cases. The last piece of the puzzle is the compression of data in motion over the network such as the redo logs.
We will look at some live examples and a case study of quantitative benefits on the compressed data alongside the uncompressed data. We will look at examples of table/partitions, Materialized View and index compression. We will also discuss the impact of compression on the regulatory compliance and how this can help to achieve industry-specific goals of increased retention of data in a tamper proof environment. We will also introduce the Total Recall Feature of 11g.
|
|
| T1022 |
Presentation |
Warehousing |
OWI - Oracle Warehouse Initiative |
Oracle Optimized Warehouse initiative |
Oracle Optimized Warehouse Or Data Warehouse Appliance? Why & Why Not? |
Chandu Patel |
Deloitte Consulting LLP |
|
|
Along with an introduction to the state of data warehousing today, this presentation discusses what the data warehouse appliance technology and Oracle's optimized warehouse initiative are and why these are warranted by today's fast paced businesses. It discusses how a data warehouse appliance attempts to address the business need of fast retrieval of aggregate and analytic data from multi-terabyte databases, and what the potential challenges are. We then examine how Oracle responds with its recently introduced Optimized Warehouse Initiative to meet those challenges. |
|
| T1033 |
Presentation |
Business Intelligence |
OBIEE |
Oracle BI EE, OBIA - Order Management and Fulfillment |
Real World Case Studies Implementing OBI EE in 3 Different Environments |
Richard Solari |
Deloitte Consulting |
Teresa Wong |
Deloitte Consulting |
This session will focus case studies around best practices and methodologies for implementing OBI EE in 3 different environments:
1 OBI EE completely out of the box for a major high-tech company
2. OBI EE out of the box as a platform for an enterprise reporting solution for a major manufacturing company
3. Complete customization of OBI EE for a major high-tech company
This session will discuss the detailed approach taken to implement this complex and vast technology.
|
|
| T1073 |
Presentation |
Business Intelligence |
BI Publisher |
Oracle BI Publisher |
Migrating Oracle Reports to BI Publisher |
Jennifer McNeill |
CipherSoft Inc. |
|
|
Many companies have used Oracle Reports to generate reports within their Enterprise Applications. While Oracle Reports has proven to be a very successful reporting development environment for many years, organizations are now looking for advanced technology to take their reporting capabilities to a new level. This presentation will review the capabilities of BI Publisher and outline the benefits of migration of Oracle Reports to the BI Publisher environment. Participants will receive tips and techniques for best practices to ensure success of their migration project. |
|
| K1001 |
Keynote |
other |
Analytics |
|
Competing on Analytics: Building Competitive Strategies around Data-driven Insights |
Jeanne Harris |
Accenture Institute for High Performance |
|
|
Executives have more information at hand about their business environment than ever before. Oracle customers already store and manager huge amounts of data, but unless they are using it to "out-think" and "out-execute" their rivals, they are failing to exploit a potent competitive tool. Analytics - the extensive use of data, statistical and quantitative analysis, explanatory and predictive modeling, and fact-based decision-making - are moving to center stage as companies seek new strategies to differentiate themselves in the market.
In this presentation, Jeanne G. Harris (co-author with Tom Davenport of the book: Competing on Analytics: The New Science of Winning) explains how the frontier for using data has shifted dramatically as leading companies are learning to do more than just collect and store data in large quantities. She shows how high-performance businesses are now building their competitive strategies around data-driven insights that are, in turn, generating impressive business results.
Jeanne will describe how market leading firms use analytics - including organizations as diverse as the Boston Red Sox, Netflix, Amazon.com, Capital One, Harrah's Entertainment, CEMEX and Procter & Gamble - to trump rivals. Through analytics, these companies identify their most profitable customers, accelerate product innovation, optimize supply chains and pricing, and identify the true drivers of financial performance. Jeanne will also discuss the evolving competitive world of Competing on Analytics and the market opportunities for Oracle and other data-driven and analytical companies. |
|
| K1000 |
Plenary Session |
other |
|
|
BIWA Summit '08 Opening Remarks |
Dan Vlamis |
. |
Shyam Varan Nath |
|
. |
|
| P1001 |
Panel |
other |
Business Intelligence |
Oracle Database, Oracle OLAP Option, Oracle Data Mining Option, Oracle Fusion Middleware, Oracle Applications |
Most Critical Success Factors for Successful BI, Warehousing and Analytics Customer Implementations |
. |
. |
|
|
Why is it that in TDWI's Predictive Analytics Report 2007 while 66% of respondents rate the value of predictive analytics as high or very high, only 21% report to be fully implemented or partially implemented? Why does rhetoric outweigh reality?
Come hear industry experts Jeanne Harris, Usama Fayad, Juan Loaiza, Jacek Myczkowski, VP of Development, Oracle Data Mining Technologies, and Joe Thomas, Sr. Director, Oracle BI Applications speak about the most critical success factors for successful BI, Warehousing and Analytics customer implementations. Is it lack of IT, lack or skills, lack of LOB support, lack of vision or something else? Come listen to the experts and bring your questions. |
|
|
