New & Notable
Oracle database design and architecture News
January 13, 2021
Oracle's flagship DB platform is moving beyond its roots with the 21c update, to embrace more languages and models in a bid to create a universal converged database offering.
August 13, 2020
The new Autonomous JSON Database is an attempt by Oracle to specifically support customers who only want document database capabilities and not a full multimodel database.
July 08, 2020
Oracle has added Dedicated Regions to its Cloud at Customer managed service. Now customers can consume all of Oracle's cloud-based services on premises, the company says.
September 16, 2019
Oracle introduced new cloud and on-premises deployment options for its namesake database and automated cloud service as Oracle OpenWorld 2019 got underway.
Oracle database design and architecture Get Started
Bring yourself up to speed with our introductory content
Sharding is a type of database partitioning that separates large databases into smaller, faster, more easily managed parts. Continue Reading
Hashing is the process of transforming any given key or a string of characters into another value. 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 among them. Continue Reading
Evaluate Oracle database design and architecture Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider before using the automated cloud service. Continue Reading
Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but migrating to the cloud has its share of issues. Continue Reading
More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that Oracle users should be aware of. Continue Reading
Manage Oracle database design and architecture
Learn to apply best practices and optimize your operations.
A well-planned consolidation strategy can help overcome Oracle database sprawl. But there are different ways to consolidate your databases, each with pros and cons. Continue Reading
Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading
An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects. 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.
Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Oracle DBAs can use features in Oracle Enterprise Manager under database licenses. But third-party tools may aid efforts to monitor and tune database performance. Continue Reading
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