Compare the characteristics of an operational database and a Essay

Compare the characteristics of an operational database and a dimensional database - Essay Example The data normalization for the operational database is required at a very high level to avoid the data redundancy. This type of databases is also referred to the â€Å"On-Line Transaction Processing† OLPT. This type of database is updated after every transaction and also represents the snapshot of a very current business situation. In an operation database, records are changed, updated, added and replaced. Relational model is used to compose operational systems with update and insert operations. Current databases are multidimensional, and technology is applied to distributed data. Large, complex, and high performance data is only facilitated by the dimensional database. For example, a sale manager wants to view the sale of a product for the particular region over a period. This is the dimensional view of data as higher dimensionality requires the high volume of data. The â€Å"On-Line analytical processing† known as OLAP enables the managers, analysts and professional to gain insight in view of information. An OLAP server supports the structures of the dimensional database. For dimensional databases, the multidimensional model is used to model the system. A company has multidimensional database of products, sales, finance, and employees. (IBM