Tag: Database & Technology

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.

Presented at INSYNC 21

Session ID: 101970

In this Hands-on Lab, join us to experience Oracle Machine Learning for Python (OML4Py) on Oracle Autonomous Database. OML4Py supports scalable, in-database data exploration and preparation using native Python syntax, invocation of in-database algorithms for model building and scoring, and embedded execution of user-defined Python functions from Python or REST APIs. OML4Py also includes the AutoML interface for automated algorithms, feature selection, and hyperparameter tuning. In this six-part lab, explore the range of Python-enabled functionality and see how Oracle technology can support your data science projects.

Presented at INSYNC 21

Session ID: 101980

Abstract: Oracle Data Safe now helps secure databases on-premises and in the Oracle cloud. Data Safe helps you identify unnecessary security risks, detect configuration drift, find and monitor your riskiest users, assess the type and amount of sensitive data within your database, and remove risk from non-production databases. In this workshop, you’ll practice the main features in Oracle Data Safe, including Activity Auditing, Security Assessment, User Assessment, Data Discovery, and Data Masking.

Presented at INSYNC 21

Session ID: 100100

Oracle Machine Learning comes free in every Autonomous Database. Oracle Machine Learning Notebooks provide easy to understand, reuse and repurpose ML methodologies that apply OML’s 30+ machine learning algorithms for in-database, parallelized implementations of classification, regression, clustering, anomaly detection, text mining, associations machine learning functions that can be used to tackle a wide variety of data-driven problems and to build “predictive” applications. This session will step through five (5) OML notebooks that can serve as the core of many data science projects:  classification, attribute importance, time-series forecasting, text mining and anomaly detection.