Analytic Views (new in Oracle 12.2 and discussed at Oracle OpenWorld 2015) change the way you build analytical applications. Analytic Views are created in a similar way to regular relational views, but add a syntax that allow you to add multiple levels of data and calculations that insulate your application from complex SQL necessary to…

Recently we had a customer who wanted to have read only access to all tables in a schema, even tables not created yet. Apparently in Microsoft SQLServer, there is a way to grant a user schema permissions and includes objects not created yet. THis quick-tip presentation will demonstrate how to setup and deploy permissions to…

This session will focus on how Secure-24 leverages Oracle ZFS Storage,  Oracle Intelligent Storage Protocol (OISP), Templates and Oracle 12C RAC to implement a Private Cloud for Oracle 12c RAC applications.   This pairing of Database and Storage hardware through Oracle’s VCA has enabled Secure-24 to take advantage of the unique integration capabilities such as…

This session is targeted at Front-end developers looking to leverage their (Javascript, CSS3, HTML5)  front- end design skills to create Modular Single Page applications with Oracles New Javascript Extension Toolkit (JET) framework. This presentation will include an overview on the JET framework, and discussion around the features and benefits along with a quick comparison on…

Originally introduced for non database data,  Oracle ASM Cluster File System (ACFS) added the support  Oracle database files in Oracle 12c.  Today IT organizations may leverage Oracle ACFS to establish pooling of storage across database, middleware and applications in their private Cloud. Come to this session to explore the Oracle ACFS and how it is…

By introducing the In-Memory column store, Oracle 12c In-Memory Database option is designed to significantly improve query performance for OLAP applications such as Business analytics applications.  Recently released Oracle In-Memory advisor  provides advises on In-Memory  store configuration  and which tables or segments should be loaded into the In-Memory  store and the estimated performance improvements. This…

Oracle Database Appliance is a powerful system and a great platform for consolidating databases. Oracle Enterprise Manager allows you to manage your data as a service. Combine these two technologies and you have an enterprise-class, private database cloud solution at a low entry cost point. This session demonstrates how Oracle Enterprise Manager allows you to…

RMAN as most know it, is one of the most important utilities in a DBAs arsenal. In earlier releases it is fair to say that occasionally it did create havoc and some DBA's were afraid to use it.   Is it too complex? “Backup database” - does not look to complex does it? This session will…

Natural disasters are not something that should be taken lightly when talking about Disaster Recovery (DR), the impact on the business can be catastrophic.  But there are many research studies showing that one of the reasons many companies experience interruptions  or even data loss are caused by human error.   The combination of hardware, software, and…

In this session participant will learn about benefits and value proposition of Hybrid ECM.  For many organization important business documents have been stored in enterprise content management for many years. Documents stored in enterprise content management system have been limited just within organizational four walls which hinder external collaboration as well engagement with customers and…