New & Notable
Oracle database design and architecture News
August 09, 2018
Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and management of Oracle databases.
April 26, 2018
A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying it's wise to be selective on what to move.
April 18, 2018
The Collaborate 18 conference will shine a light on Oracle cloud adoption and migration issues, and on the impact that such moves can have on the careers of DBAs and other IT professionals.
March 30, 2018
It wasn't the first in the cloud computing space, but Oracle is all in now. Key to the effort is a new Autonomous Database service, initially available for data warehousing uses.
Oracle database design and architecture Get Started
Bring yourself up to speed with our introductory content
The Oracle NoSQL Database is a nonrelational, horizontally scalable key-value database, with multiple higher-level data abstractions that support data management as binary key-value pairs, JSON objects, and SQL-like tables. Continue Reading
Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences between them. Continue Reading
Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases, which Oracle says can free up database administrators (DBAs) to do higher-level and more strategic work. Continue Reading
Evaluate Oracle database design and architecture Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
For Virtual Artifacts, the decision to go with Oracle's cloud was tipped by Oracle Mobile Cloud and its related bot platform capabilities. That and the self-driving database. Continue Reading
Oracle's Autonomous Database automates basic tasks of database administrators. That may put some DBA jobs at risk, but many will shift to higher-level duties. Continue Reading
Oracle Database 18c is really another version of 12c Release 2 with a different name. It doesn't contain major new features, but it does expand functionality in various areas. Continue Reading
Manage Oracle database design and architecture
Learn to apply best practices and optimize your operations.
This handbook examines Oracle Database performance management trends and offers insight and advice on using performance monitoring and tuning tools in Oracle systems. Continue Reading
Database administrators need to effectively manage Oracle Database performance to ensure an efficient processing workflow. Let this checklist be your guide. Continue Reading
Two Oracle experts discuss the tuning and monitoring capabilities of database performance management tools -- and the ongoing role that DBAs have to play in the process. Continue Reading
Problem Solve Oracle database design and architecture Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Database administrators are usually concerned with backing up their databases. But they should spend more time focusing on database recovery as part of the backup process. Continue Reading
As more companies move to the cloud, it's important for DBAs to know both the good and the bad about managing Oracle cloud database systems before they take the plunge and migrate. Continue Reading
The heat map tool and Automatic Data Optimization features in Oracle 12c should help Oracle database shops improve data storage and compression. Continue Reading