The Oracle database comes in three flavors:
General purpose – General use database for mixed transactions
Data warehouse – Database optimized for responding to long-running and “ad hoc” queries
Transaction processing – Transaction-oriented database intended for handling many short transactions and canned queries