Oracle database design and architecture

Oracle database design and architecture News

January 13, 2021 13 Jan'21
Oracle Database 21c brings blockchain and JavaScript

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 13 Aug'20
Oracle Autonomous JSON Database takes on MongoDB, Couchbase

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 08 Jul'20
Oracle Cloud at Customer adds Dedicated Regions

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 16 Sep'19
New cloud and on-premises options for Oracle Autonomous Database

Oracle introduced new cloud and on-premises deployment options for its namesake database and automated cloud service as Oracle OpenWorld 2019 got underway.

Bring yourself up to speed with our introductory content

sharding

Sharding is a type of database partitioning that separates large databases into smaller, faster, more easily managed parts. Continue Reading
hashing

Hashing is the process of transforming any given key or a string of characters into another value. Continue Reading
DBMS keys: Primary, super, foreign and candidate keys with examples

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

Weigh the pros and cons of technologies, products and projects you are considering.

Oracle Autonomous Database shifts IT focus to strategic planning

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 features free DBAs from routine tasks

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
Oracle cloud adoption and hybrid cloud adoption pros and cons

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

Learn to apply best practices and optimize your operations.

Consolidating databases in Oracle systems: Methods and tips

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
How to create Oracle Multitenant database user accounts

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
object-oriented database management system (OODBMS)

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

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

What is the difference between a database engineer, architect and administrator?

Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Why to give third-party Oracle database monitoring tools a try

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
DBAs must master the art of database recovery management

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