Tag: Database & Technology

Quest Forum Digital Event 2020

Accelerate business insights through data discovery, advanced analytics, and comprehensive Visualization delivered through Oracle BI. This session focuses on LAUSD deployment of an advanced, custom UI/UX framework on Oracle BI stack to deliver extreme Visualization and a live demonstration on how we adopted a simplified reporting platform for line-of-business users on key metrics, dazzling visualization, and infographics delivered through BI dashboards to help improve the decision-making process across the organization.

Quest Forum Digital Event 2020

AsterionDB has pioneered the ability to seamlessly store and manage both structured and unstructured data in the Oracle Database.  We couple this with the ability to express any business logic required at the data-layer. These capabilities allow us to now build an architecture that can not be hacked. To be clear, hacking your API is not the same as hacking your architecture/platform. Hacking an API can be as simple as stealing a password - that's bad. Hacking an architecture is what happens when all of your files are stolen or locked up w/ ransomware. That's worse! This session will delve into the techniques required to build an impervious architecture that is easily adept at securing structured and unstructured data.

Quest Forum Digital Event 2020

Database Administrators usually collect summary performance, and utilization data for QoS reports. Usually, they present the information in text files with rows and rows of data. The management and users like and understand the visual representation of data better. The tabular format may not make the impact or get the attention you desire. Attend this session to see how easily you can convert those tabular formats to pictures using the free and open-source Google Charts. Google Charts is a pure JavaScript-based charting library to enhance web applications by adding interactive charting capability. This session includes many demos and provides you with templates that you can start using right away by plugging in your favorite SQL.

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.