Get started
Bring yourself up to speed with our introductory content.
Get started
Bring yourself up to speed with our introductory content.
What is PL/SQL (Procedural Language/Structured Query Language)?
In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). Continue Reading
What is a distributed database?
A distributed database is a database that consists of two or more files located in different sites on the same or different networks. Continue Reading
What is MySQL?
MySQL is a popular, scalable, user-friendly, open source and free relational database management system (RDBMS) that uses Structured Query Language (SQL) to store, manage, and manipulate data. Continue Reading
-
What is PeopleSoft?
PeopleSoft is an enterprise resource planning (ERP) software suite owned by Oracle Corporation. Continue Reading
What is a stored procedure?
A stored procedure is a set of Structured Query Language (SQL) statements that multiple programs can reuse and share to perform specific tasks. Continue Reading
What is 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
Open Database Connectivity (ODBC)
Open Database Connectivity (ODBC) is an open standard application programming interface (API) that allows application programmers to easily access data stored in a database.Continue Reading
Oracle E-Business Suite
Oracle E-Business Suite is one of Oracle Corporation's major product lines. Oracle E-Business Suite applications run on top of the vendor's flagship Oracle Database software.Continue Reading
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
NetSuite
NetSuite is a business technology vendor based in San Mateo, California.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
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
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