Get started

Get started

Bring yourself up to speed with our introductory content.

• operational data store (ODS)

  An operational data store (ODS) is a type of database that's often used as an interim logical area for a data warehouse. Continue Reading

• multidimensional database (MDB)

  A multidimensional database (MDB) is a type of database that is optimized for data warehouse and online analytical processing (OLAP) applications. Continue Reading

• sharding

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

• 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 OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

  This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle cloud, database and application users. Continue Reading

• Definitions to Get Started

  • operational data store (ODS)
  • multidimensional database (MDB)
  • sharding
  • NetSuite

  • stored procedure
  • object-oriented database management system (OODBMS)
  • PL/SQL (procedural language extension to Structured Query Language)
  • distributed database

  View All Definitions

• 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

• How to connect to a pluggable database in Oracle Multitenant

  Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that.Continue Reading

• Creating an Oracle Multitenant container database and PDBs

  Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture.Continue Reading

• NetSuite

  NetSuite is a business technology vendor based in San Mateo, California.Continue Reading

• stored procedure

  A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle.Continue Reading

• Oracle Digital Assistant unifies use of enterprise chatbots

  With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to help increase worker productivity.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

• Oracle Database 19c new features and what users need to know

  Oracle Database 19c is the last update to the 12c Release 2 line of Oracle's database software. This handbook examines its new features and potential reasons to upgrade.Continue Reading

• PL/SQL (procedural language extension to Structured Query Language)

  In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL).Continue Reading

• distributed database

  A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks.Continue Reading

• Oracle NoSQL Database

  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

• PeopleSoft

  PeopleSoft is an e-business software product line owned by Oracle.Continue Reading

• MySQL

  MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language).Continue Reading

• Oracle Autonomous Database

  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

• Oracle cloud services aim to pull users out of IT comfort zone

  Oracle has gone all-in on cloud computing and expanded its line of cloud services in the hopes users will make the jump. But there are issues to weigh first.Continue Reading

• Seven to-do items for managing an Oracle cloud migration

  Migrating Oracle systems to the cloud is a big initiative for any organization. Make sure you put a solid migration plan in place to help ease the transition and keep it on track.Continue Reading

• Oracle sees Autonomous Database changing DBA roles for the good

  The job duties of database administrators will likely change in organizations that use Oracle Autonomous Database Cloud, but in ways that are beneficial, according to Oracle.Continue Reading

• How to use Oracle DBSAT to do a database security assessment

  The Oracle Database Security Assessment Tool is free software that checks the security of databases. Here are the steps involved in using DBSAT to collect data and create reports.Continue Reading

• Oracle Blockchain Cloud Service: What it is and what it does

  Oracle's cloud-based blockchain service supports distributed transaction ledgers to boost data security and validation. Here's a look at the technology and its features.Continue Reading

• Open Database Connectivity (ODBC)

  Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database.Continue Reading

• Oracle

  Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database.Continue Reading

• Oracle extents

  Oracle extents are a set of contiguous blocks allocated in an Oracle database.Continue Reading

• foreign key

  A foreign key is a column or columns of data in one table that connects to the primary key data in the original table.Continue Reading

• Oracle E-Business Suite

  Oracle E-Business Suite is a set of applications for managing business operations, including customer relationship management, enterprise resource planning and supply chain management processes.Continue Reading

• Oracle Database 12c

  The Oracle Database 12c is a high-performance, enterprise-class database.Continue Reading

• Design Hyperion for a natural class and a functional income statement

  Juan Porter explains what you need in Hyperion or Essbase for calculating a natural class and a functional income statement.Continue Reading

• Not much Exadata training necessary for experienced DBAs, says expert

  A database consultant says using Exadata is relatively easy for IT shops already managing Oracle Database. But some new DBA skills may be required.Continue Reading

• Willis develops app to put a personal touch back in voluntary benefits

  Part two of a two-part article: Willis uses PeopleSoft 9.1 to bring back the personal feel to automated insurance selection for voluntary benefits.Continue Reading

• Willis develops app for real-time voluntary benefit selection

  Part one of a two-part article: Willis uses PeopleSoft 9.1 to create real-time automated insurance selection for voluntary benefits.Continue Reading

• Handling database migrations, such as upgrading to Oracle 12c

  IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live.Continue Reading

• Three tips for using Oracle insert syntax to insert multiple rows

  If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members.Continue Reading

• State of Texas implements Oracle Database as a Service

  The eGovernment director for the state of Texas, along with a business partner from Xerox, explain how they implemented Oracle Database as a Service.Continue Reading

• correlated subquery

  A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete.Continue Reading

• Oracle Fusion Applications

  Oracle Fusion Applications is an all-encompassing suite of Oracle applications built for enterprise resource planning (ERP), customer relationship management (CRM), human capital management (HCM) and other business tasks.Continue Reading

• Oracle Hyperion

  Hyperion is the business division of Oracle that's known for corporate performance management (CPM) and business intelligence systems. Continue Reading

• virtual (federated) database

  A virtual database, also called a federated database, is a system in which several databases appear to function as a single entity.Continue Reading

• Oracle upgrades: Tips and trends

  If you’re planning an Oracle upgrade, start here to learn about the latest Oracle upgrade trends. Also, get expert advice from Oracle gurus and learn about the current state of Oracle Fusion Middleware upgrades.Continue Reading

• Oracle applications learning guide

  This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle ...Continue Reading

• MySQL Connector/ODBC (Connector ODBC or MyODBC)

  MySQL Connector/ODBC (sometimes called just Connector ODBC or MyODBC) is a driver for connecting to a MySQL database server through the Open Database Connectivity (ODBC) application program interface (API), which is the standard means of connecting ...Continue Reading

• Oracle database performance tuning guide

  Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common ...Continue Reading

• Solaris

  Solaris is the computer operating system that Sun Microsystems provides for its family of Scalable Processor Architecture-based processors as well as for Intel-based processors.Continue Reading

• concurrent processing

  Concurrent processing is a computing model in which multiple processors execute instructions simultaneously for better performance.Continue Reading

• metadata repository

  A metadata repository is a database of data about data (metadata).Continue Reading

• metainformation

  Metainformation is information about information.Continue Reading

• autonomous transaction

  In Oracle's database products, an autonomous transaction is an independent transaction that is initiated by another transaction.Continue Reading

• field

  A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size.Continue Reading

• record

  In computer data processing, a record is a collection of data items arranged for processing by a program.Continue Reading

• relational online analytical processing (ROLAP)

  Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually ...Continue Reading

• Query by Example (QBE)

  Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents.Continue Reading

• Relational Database Management System (RDBMS) fundamentals tutorial

  New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system.Continue Reading

• delimiter

  In computer programming, a delimiter is a character that identifies the beginning or the end of a character string (a contiguous sequence of characters).Continue Reading

• bioinformatics

  Bioinformatics is the science of developing computer databases and algorithms for the purpose of speeding up and enhancing biological research.Continue Reading

• repository

  In information technology, a repository (pronounced ree-PAHZ-ih-tor-i) is a central place in which an aggregation of data is kept and maintained in an organized way, usually in computer storage.Continue Reading

• SQL guide for Oracle users

  Whether you are a newbie or a seasoned expert looking to tweak query performance, this learning guide to the structured query language (SQL) has something for you. These seven chapters can help you figure out how to get the data you need by looking ...Continue Reading

• Learning Guide: Backup and recovery

  Backup and recovery is arguably the DBA's most important responsibility. This Learning Guide covers everything from the basics of creating a backup and recovery plan to the specifics of using RMAN and other methods of hot and cold backups. Samples ...Continue Reading

• Oracle PL/SQL tutorial

  This PL/SQL tutorial can help both newbies and veterans become better acquainted with the Oracle development language and hone their developer skills.Continue Reading