Jim Czuprynski

jsc 300x300

Jim Czuprynski

Consultant

Zero Defect Computing, Inc.

Biography

Jim Czuprynski has nearly four decades of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director in 2014 and is a sought-after public speaker on Oracle Database technology features, presenting often at Oracle OpenWorld, IOUG COLLABORATE, ODTUG Kaleidoscope, Oracle CODE events, Oracle Development Community tours, and Oracle User Group conferences around the world. Jim has authored over 100 articles focused on facets of Oracle Database administration to his credit since 2003 at databasejournal.com and IOUG SELECT. He has also co-authored four books on Oracle database technology. Jim’s blog, Generally … It Depends (http://jimczuprynski.wordpress.com), contains his regular observations on all things Oracle and the state of the IT industry. He is currently a Senior Enterprise Data Architect for Viscosity North America.

Papers

Charge Me Up! Using Oracle ML, Analytics, and APEX For Finding Optimal Charge Points

Event: Connect 2022
Stream: Architecture, Cloud Database & Technology

You’re running late for the final 45-minute interview for your new developer position, your brand-new EV’s battery is down to 15%, and if you don’t pick up your five-year-old at daycare on time today, it’ll cost you big time. So where’s the closest charging point? And why the heck did they put it over there? This session will take a look at new realities that Smart Cities and the coming re-electrification movement will bring to our world as we transition to EVs. I’ll show how Oracle technology – including Machine Learning, Analytics, and APEX – can be deployed to determine optimal placement of charging stations based on publicly-available data, as well as provide users the capability to quickly locate the closest and best charge point for their needs at the time.

Going Native: Leveraging the New JSON Native Datatype in Oracle 21c

Event: Connect 2022
Stream: Architecture, Cloud Database & Technology

JSON continues to be the preferred lingua franca for exchanging information between databases and applications, configuring application parameters, and storing often-complex data within a simple yet robust document notation. Oracle Database 21c introduces a new native JSON datatype that enables application developers and DBAs to store, manipulate, refresh, and search elements stored withing JSON documents with flexibility and speed. I’ll demonstrate how to best take advantage of this new native datatype and its functions to build more effective database applications that store JSON documents directly within an Oracle database to provide security, coherence, and clarity so that your teams can concentrate on speedy application development and satisfying your user community’s demands.

JSON, A Splash of SODA, and a SQL Chaser: Real-World Use Cases for Autonomous JSON Database (AJD)

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

The popularity of JSON (JavaScript Object Notation) has quickly become a de facto method for retaining valuable business information for many IT organizations. For the modern Oracle DBA, finding the best methods to retain, maintain, and process JSON documents – especially when that information needs to be combined with non-JSON data – can be a confusing conundrum. This session demonstrates how to tackle real-life business use cases with the newest member of Oracle’s Autonomous Database family – the Autonomous JSON Database (AJD) – and explains how it simplifies JSON document management, provides secure access to their data via SODA, and promotes easy combination of JSON and non-JSON data with SQL. Through presentations and online demonstrations, this session illustrates how to: – Use an Autonomous JSON Database (AJD) to store, retrieve, and process JSON information – Take advantage of Simple Document Oracle Access (SODA) NoSQL APIs to process JSON information … without writing any SQL code – Leverage SQL to access JSON information within an AJD and combine it with other non-JSON formatted information retained within the same AJD

Fast and Furious: Handling Edge Computing Data With Oracle 19c Fast Ingest and Fast Lookup

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

The Internet of Things (IoT) has expanded well beyond the hobbyist realm and into the real world, including energy grids, communication networks, policing and security, and modern manufacturing (aka Industrial IoT). This session demonstrates how Fast Ingest and Fast Lookup – part of the new Memoptimized Rowstore features in Oracle 19c – makes short work of capturing and loading IoT data from “edge” sources so that developers and data analysts can take immediate advantage of that information in nearly real time as they transition to a digitally-driven IT organization. This session will: – Explain how edge computing is transforming global industry and societies – Show how Fast Ingest and Fast Lookup features in Oracle 19c fill the need for extremely high-volume transaction processing – Highlight potential pitfalls of the Memoptimized Rowstore to guard against potential data loss