Tag: Database & Technology

Presented at INSYNC 21

Session ID: 100160

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking?  In this session, we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer.  You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so.  Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals.

Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

Presented at INSYNC 21

Session ID: 100360

MySQL is the largest open-source database in the world. It's a product that resides under the wings of Oracle Corporation and still it survives with it's big brother Oracle Database as the flagship product in Oracle Corp. This is an open-source product which means that, as opposed to Oracle Database, you can get it for free. We'll discuss features and we'll go into some details what we experience as the strong points and what are the weaknesses. I will guide you through the basic installation of the most recent release MySQL 8.0, we'll go through the basic concepts of the database and we will set up a replica.

Presented at INSYNC 21

Session ID: 101090

Security breaches are becoming more and more common. From both external and internal threats/bad actors. And while organizations spend considerable effort on perimeter security, the database is often overlooked or considered too fragile to touch.

But more effort needs to be directed towards Oracle database security. Both inside the database and out (i.e. operational practices). And regardless of whether on-premises or in the cloud.

This presentation covers common weaknesses and vulnerable areas of the Oracle database due to configuration and management issues that are easy to correct or remediate right away. Going well beyond the obvious like password rotations and having security policies.

Presented at INSYNC 21

Session ID: 101310

IT environments have evolved rapidly, but existing monitoring and management tools have not kept up with the increasing complexity found with multicloud and on-premises IT environments. Oracle Cloud Infrastructure(OCI) provides comprehensive visibility and machine learning-driven actionable insights to ease management across all layers of the stack deployed on any technology, anywhere. Oracle’s integrated solution for DevOps monitoring and IT operations management makes it easier to prevent and solve problems. Learn how to get started and improve IT efficiency, identify code-level performance issues faster, and reduce complexity.

Presented at INSYNC 21

Session ID: 100410

The modern data scientist has a daunting task: Probing petabytes of data, figuring out which Machine Learning (ML) algorithms to apply to filter the grain from the chaff, and producing meaningful intelligence on which to base digitally-driven strategies for their organization. This session demonstrates how even a fledgling citizen data scientist facing few real-life opportunities to discover unseen patterns and relationships within sample data can quickly leverage the powerful ML capabilities already built into the Oracle Database and available for use at no additional cost.

Presented at INSYNC 21

Session ID: 101930

Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.

Presented at INSYNC 21

Session ID: 101110

These days supporting business means always handling varied and shifting priorities. But, if you expect your Oracle databases to handle these changes and perform consistently at high levels, you need to have a maintenance process. The first part of that is an assessment: How are my databases performing, and are there any problems? It sounds simple, but for most modern complex database environments, a proper assessment requires a variety of tools and a lot of experience interpreting the results.

Presented at INSYNC 21

Session ID: 100470

Moving to the cloud is not easy. It requires effort and skills and, in most cases, downtime. How can you minimize all three requirements and move your database with minimal downtime running just one command from the command-line? We will discuss the benefits and challenges of different migration methods and where the Oracle Zero Downtime Migration tool can save time and effort. The discussion will be based on real migration cases and on-hands experience of moving a large database environment to the new home.

Presented at INSYNC 21

Session ID: 101560

Oracle Database 21c has been released and is the latest innovation release of the Oracle Database.  A number of new security features are included with this release and should be adopted when creating new databases or upgrading existing databases. Learn about the new security features and changes in security for this database release. Key new security features are blockchain table, gradual database password rollover, mandatory case-sensitive passwords, and Unified Auditing enhancements.

Presented at INSYNC 21

Session ID: 101990

This workshop starts with a napkin design of data structures we would like to use for a proof-of-concept. Using Quick SQL you will quickly define the data structures and utilize various table and column directives to better define the tables and also create some dummy data. You will then be creating an application based on the new tables. Lastly, you will be updating some of the generated components to improve the initial app.