DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports
Events Video Library
Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
View Events Video Library
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Integrating PostgreSQL Databases with ANF: Join this workshop to learn how to create a PostgreSQL server using Instaclustr’s managed service

Mobile Database Essentials: Assess data needs, storage requirements, and more when leveraging databases for cloud and edge applications.

Monitoring and Observability for LLMs: Datadog and Google Cloud discuss how to achieve optimal AI model performance.

Automated Testing: The latest on architecture, TDD, and the benefits of AI and low-code tools.

Related

  • In-Memory Database Architecture: Ten Years of Experience Summarized (Part 2)
  • In-Memory Database Architecture: Ten Years of Experience Summarized (Part 1)
  • In-Memory Showdown: Redis vs. Tarantool
  • 3 In-Memory Cache Challenges Solved

Trending

  • API Design
  • The Emergence of Cloud-Native Integration Patterns in Modern Enterprises
  • Top 7 Best Practices DevSecOps Team Must Implement in the CI/CD Process
  • Leveraging FastAPI for Building Secure and High-Performance Banking APIs
  1. DZone
  2. Culture and Methodologies
  3. Agile
  4. Getting Lean: Modernizing an Oracle Stack With Tarantool

Getting Lean: Modernizing an Oracle Stack With Tarantool

While Oracle has certainly mastered RDBMS technologies, in-memory DBs require a totally different engineering mindset and are most robust when designed independently.

Evan Bates user avatar by
Evan Bates
·
Oct. 11, 17 · Opinion
Like (2)
Save
Tweet
Share
2.95K Views

Join the DZone community and get the full member experience.

Join For Free

Image title

How can we make the Oracle stack relevant in this era of massive workloads?

Adding an in-memory database to an Oracle stack manages heavy increases in mobile, streaming, and web data usage.

While Oracle has certainly mastered relational database technologies, in-memory databases require a completely different engineering mindset and are most robust if they are designed independently, specifically for a distributed environment and added to a relational database management system (RDBMS) stack as opposed to retrofitted. It can also be advantageous to avoid vendor lock-in by adding non-Oracle solutions your toolset.

Tarantool is an open-source and enterprise solution sponsored by one of the world’s largest internet companies. It’s a unique in-memory database that can improve and economize an existing Oracle implementation. Speed is comparable to cache databases like Redis or Memcached, but it maintains critical relational properties that others have eschewed — fully ACID transactions and complex queries.  

Accelerating, Downsizing, and Decomposing an Oracle Stack

Tarantool can improve an Oracle stack by replicating and accelerating its data as well as facilitating its downsizing and restructuring.

Using a single core, Tarantool can process one million transactions per second. Conversely, a machine running an RDBMS requires multiple cores to duplicate this feat, generally at least twenty. This massive capability differential means that certain tasks can be offloaded from expensive Oracle enterprise servers to Tarantool machines.

Tarantool easily interfaces with Oracle products because of its ability to run SQL alongside its powerful Lua implementation. Once Tarantool takes over a workload, the Oracle machines that had been handling it can be removed from the stack. A large dating website, for example, shed seven RDBMS servers by adding Tarantool. This saves significant enterprise infrastructure costs.

Microservice transformation can help break apart monolithic structures. Tarantool’s design is a natural fit for microservices because it features its own application server and it can be run in multiple small instances, each potentially with its own data store. Tarantool can implement independent microservices without RDBMS backup — for example, an authentication and authorization service — but can also decompose an RDBMS’s structure by working with a subsection of its data.

How Tarantool Works With Oracle

Tarantool can interface with Oracle using a connector or a replication service. Among other functions, the connector allows actions to be performed on an Oracle server — for example, a Tarantool database can be dumped there.

Replication works asynchronously through log reading. It can be enabled either using GoldenGate or through Tarantool’s partner Continuent. Note that certain existing GoldenGate licenses are adequate for Tarantool.

Tarantool Compared to Oracle’s In-Memory Solutions: Database In-Memory and TimesTen

Tarantool is most accurately compared to TimesTen because Database In-Memory is not a full-fledged in-memory database, but rather a columnar storage of user-selected data in RAM, retrofitted to supplement a row-oriented, disk-based store. Similar to Tarantool, TimesTen can be run as a standalone database or in relation to an RDBMS. TimesTen, however, is primarily intended for OLTP-type operations and not OLAP. Additionally, it cannot be sharded, which inhibits its scalability. Conversely, Tarantool can handle both OLAP and OLTP, and it supports sharding.

Tarantool is capable of making multifaceted improvements to existing Oracle implementations, and one thing is certain: Tarantool was engineered for heavy workloads. In fact, it is currently used in half of the applications of its parent company, enabling services such as email, cloud, messaging, and social media for millions of users. This means that Tarantool has been continuously improved in a “real-world” laboratory since its 2008 initial release.

Do you have more questions about your project? Visit the Tarantool Challenge to connect with actual developers for answers.

Tarantool Relational database Lean (proof assistant)

Opinions expressed by DZone contributors are their own.

Related

  • In-Memory Database Architecture: Ten Years of Experience Summarized (Part 2)
  • In-Memory Database Architecture: Ten Years of Experience Summarized (Part 1)
  • In-Memory Showdown: Redis vs. Tarantool
  • 3 In-Memory Cache Challenges Solved

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends: