Tag: IOUG

The most interesting new feature Oracle 18c introduces to Developers are Polymorphic Table Functions and Qualified Expressions. Polymorphic Table Functions finally allow the Developer to define the structure of the returned records at runtime. Qualified Expressions allows defining array- or record constructors that assign all values in a single statement. What looks at first sight…

One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can…

Do you need to add complex validations, dynamic actions and/or implement interactive grid customizations?  The interactive grid API is your friend. This session covers the essential elements of the APEX interactive grid API that most interactive grid developers need to know, or *should* know to build effective, customized interactive grids. We will detail and demonstrate…

Setting up an Oracle Analytics Cloud (OAC) instance can be a little tricky. Learn the ins and outs of this fairly new Oracle offering in this session. Topics covered will be OAC parts and pieces, how to navigate in the Cloud environment, creating the database and OAC instance, building out an application and analysis and…

  Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on…

Learn from Oracle GoldenGate Product Management on the new GoldenGate 18c features, including a deeper dive into the new Microservices Architecture for automing Oracle GoldenGate.  And discuss enhancements related to Active-Active replication including the new Automatic Conflict Detection and Resolution features.

MySQL 8 is now available and is the most recent update to the MySQL database.  It is packed with updates and changes in this presentation we will take at look at those updates and changes.  We will also explore the new features of MySQL 8 as well as well as what has been deprecated and…

New DBA's hear stories from their experienced peers about databases being recovered from certain failure and the heroics involved, but what's the reason for those successes? One of the main tools, used by the savior DBA, is the Recovery Manager: RMAN. We're entrusted with our customer's data and the novice DBA has to know how…

The Oracle Database Security Assessment tool offers the databsase administrtor the ability to check their database environments to understand the risks that exist to their environment.  Knowning where the environment is not following security best practices, where there are open known security risks is the first step is closing those risks and hardening the environment. …

MySQL offers enterprise security benefits that you may not be aware of and some that you may be aware of.  In this presentation we will explore MySQL database security at community edition up to enterprise edition.   The security capability is much more then most would think especially with enterprise edition.  Come explore how you can…