Understanding Applications and Databases

An application is a management structure that contains one or more databases and related files. Block storage applications can contain multiple databases; aggregate storage applications can contain one database only. Even for block storage databases, Oracle recommends creating one database per application. An Essbase service can store multiple applications and databases.

The database is a data repository that contains a multidimensional data storage array. A multidimensional database supports multiple views of data so that users can analyze the data and make meaningful business decisions. See Understanding Multidimensional Databases.

Note:

Some information in this chapter applies only to block storage databases and is not relevant to aggregate storage databases. Also see: