Tag: Database & Technology

Leverage Oracle Analytics Cloud and Autonomous Data Warehouse Within HR

Dhvani Sheth, Solution Engineer at Oracle, showed how Oracle Analytics Cloud and Oracle Autonomous Data Warehouse can provide useful data analysis and visualization to HR departments. Hiring the right people requires a lot of time, money, and effort. However, hiring the wrong people can be just as costly, if not more so. Without using data analytics to make data-driven decisions, HR departments may be prone to hire based on a cognitive bias that they aren’t aware of. Instead of using traditional techniques, HR can use data analytics and visualization to find patterns within large volumes of data to make insightful hiring decisions for the company.

Departmental Reporting with Oracle Autonomous Data Warehouse

David Huffman, Solution Engineer at Oracle, explained to users how Oracle Autonomous Data Warehouse and Oracle Analytics Cloud can provide organizations and analysts with insights into accurate, comprehensive data.

Using Oracle Analytics with the Autonomous Data Warehouse

For the airline industry, flight delays are a serious problem. This problem ultimately cripples customer satisfaction and retention, wreaks havoc on schedules, and reduces revenue. What if airlines could move past expensive, time-consuming, legacy IT approaches? This could help them harness their data to better analyze, understand, and mitigate flight delays. Oracle Autonomous Data Warehouse can help them do exactly that.

Strategies for Integrating Oracle Databases with Open Source PostgreSQL
Premium

There may be times when it makes sense to consider an open source-based DBMS like Postgres along side your Oracle databases. The session will cover how to migrate from Oracle to Postgres, quickly and without risk, by taking advantage of automated tools to analyze and convert definitions, tables, views, stored procedures and indexes.

Introducing Oracle Database 19c
Premium

Introducing the latest Database from Oracle: Oracle Database 19c.  Oracle Database 19c is currently slated to be a "Long Term Support Release" meaning there is good reason for many customers to consider upgrading to Database 19c as older database versions including 11x and 12x will be moving into desupported mode.  This session will cover what's…

Analyzing AWR Reports for performance tuning and troubleshooting
Premium

Have you ever been overwhelmed looking at an AWR report and not sure where to start?  I will show you the different types of AWR reports,  information that is contained within each section and how you can use it to tune and troubleshoot your database.  I will provide examples of how I've used the reports…

YOUR machine and MY database - a performing relationship!? (2019 edition)
Premium

The 2019 edition of “YOUR machine and MY database - a performing relationship!?” is intended to be an information for Oracle DBAs, DB developers and system administrators who want to learn more about how today's databases, modern operating systems, hypervisors and current hardware works together. Databases affect machines, machines affect databases. Optimizing one is pointless…

Oracle Core: Database I/O
Premium

We know different IO types that are used by the database. The DB need them, to fullfill its tasks. This lecture shows how and where they are different, and explains the advantanges and disadvantages of each. We will talk about access to tablespaces, online/archived redo logs and different file types connected to the instance. I'll include…

Oracle18c and Centrally Managed Users (CMU) - Active Directory User Management Made Simple
Premium

An exciting new feature of Oracle Database 18c is "Centrally Managed Users" (CMU). This, for the first time, allows for simple and complete user management integration with Active Directory (AD). No additional licenses required! Previously, Oracle Enterprise User Security (EUS) was needed as an intermediate component bridging the Oracle Database to Active Directory. And while…

Oracle Database In-Memory - Real-Time Analytics
Premium

Oracle Database In-Memory introduces a new in-memory columnar format that is compatible with all existing applications. This session will explore how Database In-Memory enables "Real-Time Analytics" by allowing analytic style queries to be run directly on source data. It will also explore the key performance enhancing features of Database In-Memory including in-memory scans, predicate push down, hash joins with bloom filters, vector group by aggregation, and new high-performance features like In-Memory Expressions and Join Groups.