Vote Early, Vote Often: From Napkin to Canvassing Application in a Single Weekend
The frenetic pace of application development in modern IT organizations means it’s not unusual to demand an application be built with minimal requirement gathering – literally, from a napkin-based sketch – to a working first draft of the app within extremely short time frames – even a weekend! – with production deployment to follow just a few days later. We’ll explore a real-life application development scenario – the creation of a mobile application that gives election canvassers a tool to identify, classify, and inform voters in a huge suburban Chicago voting district – using the latest Oracle application development UI, data modeling tools, and database technology. Along the way, we’ll show how Oracle APEX makes short work of building a working application while the Oracle DBA leverages her newest tools – SQL Developer and Data Modeler – to build a secure, reliable, scalable application for her development team.
Autonomous Data Warehouse (ADW): These Are the Droids You’re Looking For
Introduced in Oracle 18c, the Autonomous Data Warehouse (ADW) provides a tightly-controlled, Cloud-based environment for application workloads focused on analytic reporting and data warehousing. This presentation looks at how ADW performs against the TPC-DS decision support benchmark queries and explains the details of how best to take advantage of ADW features, as well as understand precisely what ADW means for the role of Oracle DBA in the near- and long-term.
Autonomous Transaction Processing (ATP): In Heavy Traffic, Why Drive Stick?
Autonomous Transaction Processing (ATP) – the second in the family of Oracle’s Autonomous Databases – offers Oracle DBAs the ability to apply a force multiplier for their OLTP database application workloads. However, it’s important to understand both the benefits and limitations of ATP before migrating any workloads to that environment. This presentation offers a quick but deep dive into how best to take advantage of ATP – including how to load data quickly into the underlying database – and some ideas on how ATP will impact the role of Oracle DBA in the immediate future. (Hint: Think automatic transmission instead of stick-shift.)
Conquer Big Data with Oracle 18c, In-Memory External Tables and Analytic Functions
There’s an onslaught of Big Data coming to our IT shops – zettabytes of it! – but instead of your application developers struggling to learn new languages and techniques to analyze it, why not leverage Oracle Database 18c? This presentation demonstrates how to tackle handling the coming Big Data tidal wave with the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language. We’ll also take a closer look at using some new Analytic Functions in 18c to make short work of complex analyses and how best to leverage 18c’s new Database In-Memory features for External Tables.
An Airline Pilot, A Urologist, and a DBA Walk Into a Bar: Thinking Like a Professional
It’s no joke! The IT industry is undergoing a maelstrom of change – ever-increasing data volumes, horrendous security incursions, the promise / threat of Cloud-based computing, and a gradual loss of its most talented people through age-based attrition. What’s needed more than ever is a revival of professionalism within our ranks, and it’s time for us to rise up as a community to strive towards that goal. Seriously – if you are just doing your IT job and are perfectly satisfied with your status in our industry, please don’t waste time reviewing this presentation.
Handling application performance degradation – especially when an RDBMS as complex as Oracle Database 12cR2 underlies the application – can be a complex, time-consuming, frustrating task. Via actual use cases, stories of painful discoveries, and of course some hard-core metrics, this session will take a look at some of the simplest mistakes even an Oracle DBA can make when probing application performance issues and how to overcome one’s own blind spots when searching for the true root causes of that degradation.
You’re an Oracle DBA whose CIO has at last agreed to embrace the Oracle Public Cloud (OPC) and now you’re ready to begin your journey. But now you face another difficult task: choosing from an almost dizzying array of options as you start your trek to building your first 12cR2 database in the OPC.
This session will give you some much-needed practical advice using an actual example of implementing an application performance evaluation environment using Swingbench’s TPCDS model to compare the original Oracle Database as a Service (DBAAS) – aka the Database Schema Service – versus its latest and greatest incarnation, Exadata Express and even the newest “bare metal” OPC options so that you can choose wisely, begin your OPC trek, and never regret your decision.
Oracle Database 22.214.171.124 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and non-resident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.
Oracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an EXTERNAL table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language.
Almost every modern IT organization has struggled with the best place to locate crucial application code bases -inside the application server layer, or inside the database itself? The good news is that Oracle Database 12c has helped push the argument towards locating the majority of application code within the database through several key feature sets, especially Edition-Based Redefinition (EBR). This session will offer several practical examples of how any Oracle DBA can build a case for and then implement the best practices of the #SmartDB paradigm within their organization while making their application developer colleagues happier than ever.