Glossary

ACID - an acronym relating to the integrity mode of a database. ACID stands for Atomic, Consistent, Isolated, Durable.

• Atomicity - all parts of a transaction succeed or none of then succeed. Integrity.
• Consistency - Nothing in your transaction will violate the rules of the database. Integrity.
• Isolation - Each transaction operates independently of every other transaction.
• Durability - Once the database says that data is committed there is no opportunity for that to be undone.

Application Express - Oracle Application Express (also called APEX and formerly called HTML DB) is a FREE RAD web development tool. APEX is written using PL/SQL and runs completely inside of a web browser. APEX is an IDE and a runtime environment. You use APEX to write web applications. Users, using their database user ID, log into APEX and run their application from a menu.

With the APEX IDE, you can create forms, reports and charts. All of the normal web widgets are available: radio groups, buttons, drop down lists, date pickers, etc. You can even integrate your own JavaScript code should you need it.

Output from APEX applications can be to the screen or to PDF, Excel spreadsheet, Flash, or even integrated into a web service. You can use a supplied theme for a consistent look and feel or create your own theme for a personalized feel to your application.

Automatic Storage Management - Oracle Automatic Storage Management (ASM) eases storage management by abstracting file systems to where DBAs need them. ASM also allows consolidation of storage so that applications that need storage have it available when they need it.

ASM provides DBAs a consistent management interface across all platforms. It is a file system and volume manager specifically designed for Oracle data files.