Get started

Get started

Bring yourself up to speed with our introductory content.

• foreign key

  A foreign key is a column or columns of data in one table that refers to the unique data values -- often the primary key data -- in another table. Continue Reading

• 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

• Definitions to Get Started

  • foreign key
  • 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)

  View All Definitions

• 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

• 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

• 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 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 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

• 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

• 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

• 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

• 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 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

• 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