Tag: Database & Technology

Quest Forum Digital Event 2020

DevOps concepts, practices, and tools have spread widely in the past decade as teams look to improve their ability to deliver working software swiftly and reliably. These concepts and tools are important for people involved in all aspects of software development, delivery, and support to understand.

This session provides an overview of core concepts and mindsets of DevOps, typical DevOps tools and patterns of usage of those tools, and how all of this relates to your database. Key areas of focus will be the use of source code management tools such as GitHub, automated testing, Continuous Integration/Continuous Deployment tools such as Concourse, CI/CD-enabling database tools such as Liquibase, and Infrastructure as Code.

Examples of how a database support team has adopted these practices and tools will be given along with lessons learned along the way including thoughts on how best to get started if you’re just beginning to explore DevOps for your database environment.

Quest Forum Digital Event 2020

Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Sharding is often associated with large, complex databases but that need not be the case. Based on Oracle Partitioning technology, sharding is a component of Oracle's Maximum Availability Architecture and boasts a rapidly growing user base. Its adoption is a result of the many database challenges it solves, including extreme availability, fault isolation, data tenancy, application response and latency, hybrid cloud deployment, migration, and data sovereignty. In this presentation, learn how Oracle's sharding technology works, its limits, implementation planning, use cases, and features and enhancements planned in Oracle 20c.

Quest Forum Digital Event 2020

Right from the first installation and configuration of the Oracle Clusterware, you need a good deal of expertise. This starts with the preparation of the operating system and ends with the various input fields and choice boxes in the graphical user interface that need to be completed. Although installation is certainly no bag of fun it should nevertheless be reproducible, so automating the procedure seems the obvious thing to do. This presentation explains a possible solution that avoids any graphical user interface interaction and whose efficacy has been tried and tested in numerous projects.

*Quest Forum Digital Event 2020

Drop Tank manages gas station loyalty technologies and programs for many of America’s best-known fuel brands. Millions of transactions and diverse POS systems bring the complexity of both scale and scope to their cloud-based data warehouse and analytics system. You’ll hear how ADW, OAC, ODI, and Oracle CX cloud work together to provide reporting and analytic insight to marketers and program managers. This real-world case study will highlight what worked well, what didn’t, and what the future promises.

Objectives:

  • Share the challenges that Drop Tank faces in integrating diverse data sources into a comprehensive solution in Autonomous Data Warehouse Cloud.
  • Discuss the data modeling challenges necessary for reporting complex retail transactions across thousands of individual store locations and diverse audiences for analytics.
  • Review the guiding principles and preferences that helped this implementation succeed. Discuss what it’s like to be on the cutting edge of Oracle’s technologies.

Presented by:

Tim Vlamis, Vlamis Software Solutions, Inc.
Timothy Miller, Drop Tank
Doug Schieder, Vlamis Software Solutions, Inc.

Quest Forum Digital Event 2020

Epsilon deploys real-time marketing solution for many customers, Application Uptime and Performance SLAs are key business measures. Using Oracle MAA technologies, RAC, Data Guard, GoldenGate, and Application Continuity, Epsilon is able to provide customers a platform where planned maintenance operations are completely hidden from application end users. This allows us to be fully compliant.  In fact, by using the Oracle high availability solution, Application Continuity, we even hide unplanned outages from end users.

Quest Forum Digital Event 2020

Oracle Autonomous Database services are built around the Oracle database and come with fully automated with self-driving, self-securing, self-repairing, and offer two options optimized by workloads: Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP). In this session, you will learn the easy provisioning process of these two database cloud services, learn how to navigate the service console for service management, how to access the databases, define the database objects, load the data and run the query and transactions. For Autonomous Data Warehouse (ADW),  you will how to import and export large sets of data to/from ADW database, learn how to use data visualization tool built in the Oracle cloud to run advanced analytics and machine learning applications as well as some troubleshooting experiences and tips using ADW. We will also discuss the options and process to migrate your on-premise databases to these database cloud services.

Quest Forum Digital Event 2020

This presentation explains database security of the Multitenant (MT) option to the Oracle Database.  The techniques discussed cover user scope, privileges, roles, grants, lockdown profiles, application PDBs and application contexts, Database Vault, auditing, Virtual Private Database.  Related administrative topics such as network security and encryption are discussed.

Quest Forum Digital Event 2020

The database administration role as we knew it is dead.  DBAs who have been around for decades have become irrelevant in this data-driven economy.  Developers want autonomous management and executive leaders want to cut costs any way they can.  Join Oracle community experts as we discuss the next evolutionary role of the database administration role and what we must do to adapt and survive in this ever-changing dynamic technology-driven world.  Learn what future skills you need to possess and how you can stay on top of the demand.

Discussions will include how technical enhancements to autonomous databases, cloud innovations, and what you must learn to survive, how AI and machine learning can impact the database scene, and understanding which technologies you need to learn to adapt.

Quest Forum Digital Event 2020

Nobody likes patching but it needs to be done. In this session learn directly from the Oracle Database Upgrade and Grid Infrastructure development teams about patching best practices and the latest enhancements to Oracle's patching infrastructure. Get hints and tips about the best ways to minimize disruption when patching your environment. No matter whether you use Oracle Real Application Clusters with Grid Infrastructure or you use Oracle Java Virtual Machine, this session offers a lot of real-world best practices directly from the experts.

Quest Forum Digital Event 2020

This presentation addresses and tries to provide a reasonable answer to the rather common question: "Why should we still use an Oracle Database?", which more often than not is raised by management. In the presence of more and more "alternative solutions", however, the same question is also raised by non-Oracle database administrators, who are looking to solve a particular problem. This session addresses both audiences.