Written by Sridhar Avantsa, Rolta AdvizeX

Oracle introduced the feature of database sharding in 12.2 and has since been refining it. The purpose of this article is for the reader to understanding database sharding. This includes general concepts of sharding as well as the concepts, architecture, and how to use Oracle Sharding.

Oracle’s Autonomous Database was first released in 2019, initially on 18c and now upgraded to 19c. This paper will go over some of the basic concepts and features of Autonomous Database and walk you through a primer on setting up and deploying an Autonomous Database on the Oracle Cloud.

This article will learn how we can play Jenkins works with Oracle Database and understand Jenkins's internal process/flow and its interpretation with the Oracle Database. This article will perform the complete setup of Oracle Database, including the installations and configuration.

As part of Quest Experience Week 2019, Richard Evans, Database Security Product Management at Oracle, spoke about the top 10 database security features you might not be using.

During Quest Forum Digital Event: Emerging Technology Day, Oracle's own Joe Huang discussed his tips and best practices for implementing great digital assistants for Oracle applications.

Oracle Database 19c is the world's leading relational database, and it gets even better when combined with Oracle SQL Developer.

Everyone knows that SQL Developer is a great tool for creating world-class applications. Not so well known, is that SQL Developer produces some amazing dashboards of the database and application operation.

These dashboards are relevant for both transactional, and data warehouse environments. To view the dashboards, the user account needs to be granted the SELECT_CATALOG_ROLE role.

Oracle upgrades have always been a challenge - all the steps to take, all the preparation work for an upgrade execution, the testing of your applications with the upgraded version. At times, this has been such a challenge the upgrades are postponed or never even happen. Oracle has given us some help with at least the upgrade process itself us the AutoUpgrade Utility.

*Quest Forum Digital Event 2020

Drop Tank manages gas station loyalty technologies and programs for many of America’s best-known fuel brands. Millions of transactions and diverse POS systems bring the complexity of both scale and scope to their cloud-based data warehouse and analytics system. You’ll hear how ADW, OAC, ODI, and Oracle CX cloud work together to provide reporting and analytic insight to marketers and program managers. This real-world case study will highlight what worked well, what didn’t, and what the future promises.

Objectives:

• Share the challenges that Drop Tank faces in integrating diverse data sources into a comprehensive solution in Autonomous Data Warehouse Cloud.
• Discuss the data modeling challenges necessary for reporting complex retail transactions across thousands of individual store locations and diverse audiences for analytics.
• Review the guiding principles and preferences that helped this implementation succeed. Discuss what it’s like to be on the cutting edge of Oracle’s technologies.

Presented by:

Tim Vlamis, Vlamis Software Solutions, Inc.
Timothy Miller, Drop Tank
Doug Schieder, Vlamis Software Solutions, Inc.

As part of Quest Forum Digital Event: Innovation Week, Sandra Cheevers, Senior Director of Oracle Cloud Product Marketing, presented an overview of Oracle’s Cloud Computing strategy. Cheevers discussed Intelligent Applications, Autonomous Database, and the Oracle Cloud Infrastructure as the complete solution for your organization’s needs.

Network encryption is one of the most important security hardening strategies to be adopted in any enterprise infrastructure. It will ensure confidential data transmitted over the wire is encrypted and will prevent malicious attacks in man-in-the-middle form intended for data exfiltration. Network encryption guarantees that data exchanged between the clients (Application) and Database System or indeed between any two endpoints should be securely transmitted and transparently decrypted without fear of prying eyes. Moreover, compliance with mandatory laws like HIPAA dictates or highly recommends to implement tools of encryption of in-transit and/or at-rest data as protection from theft or malicious attacks. Oracle RDBMS Enterprise Edition offers out-of-the-box solutions to encrypt and secure over-the-wire data, and this article will compare two of these options that can be implemented in any Oracle database infrastructure.