Special Report:
Online Transaction Processing
September 2009
When Oracle announced Exadata Version 2 last week, CEO Larry Ellison boasted that it is “the only database machine that runs OLTP applications.” But what does that mean for your business? Online transaction processing (OLTP) allows day-to-day transactional data is held in the same repository that contains the operational data for your business. Order entry, retail sales, and financial transaction systems are all classic examples of OLTP-intensive systems. By moving transactional data and processes to Exadata Version 2, businesses can see 10-fold increase in response time from10times fewer disks. Read on and learn more about OLTP, Exadata Version 2, and who should be paying the most attention to this new release.
Webcast: Watch Larry Ellison Unveil the Sun Oracle Database Machine
CEO Ellison calls Oracle Exadata Version 2 the “Fastest computer of any kind for OLTP.”
Oracle Tames Exponential Data Growth with Ground-Breaking OLTP Table Compression
Once considered a novelty, terabyte-sized databases have become commonplace in today's enterprise data centers. Besides the cost of purchasing and maintaining storage, this exponential growth in enterprise data—which by most estimates doubles every two to three years—poses a serious challenge to application performance and scalability. In response, Oracle has forged a series of technologies that dramatically reduce the storage footprint by compressing all kinds of data, including relational (table), unstructured (file), and backup data.
Press Release: Oracle Unveils Exadata Version 2, The First Database Machine for OLTP
“Exadata Version 1 was the world’s fastest machine for data warehousing applications,” said Oracle CEO Larry Ellison. “Exadata Version 2 is twice as fast as Exadata V1 for data warehousing, and it’s the only database machine that runs OLTP applications. Exadata V2 runs virtually all database applications much faster and less expensively than any other computer in the world.”
What Is an OLTP System?
Online Transaction Processing (OLTP) systems are one of the most common data processing systems in today's enterprises. Classical examples of OLTP systems are order entry, retail sales, and financial transaction systems. OLTP systems are primarily characterized through a specific data usage that is different from data warehousing environments, yet some of the characteristics, such as having large volumes of data and lifecycle-related data usage and importance, are identical.
Oracle Master Data Management: Executive Overview (pdf)
It is important to note that since MDM supports transactional applications, it must support high volume transaction rates. Therefore, Master Data must reside in data models designed for OLTP environments.