Pubudu: Data and Decisions

Posts

Oracle GoldenGate for Real Time Data and AI Pipelines

AI applications need fresh and accurate data to provide useful results. In many organizations, important business data is stored in Oracle databases. Traditional ETL processes normally move this data to other systems in batches. This means AI and analytics platforms may sometimes work with old data. Oracle GoldenGate helps solve this problem by moving database changes in near real time. How Does It Work? Oracle GoldenGate uses Change Data Capture (CDC) to capture changes from Oracle database redo logs. It can capture: INSERT UPDATE DELETE The basic flow is: Oracle Database → GoldenGate → Kafka / Streaming Platform → AI Processing → Vector Database → RAG / LLM For example, imagine an order status changes: UPDATE SALES.ORDERS SET STATUS = 'SHIPPED' WHERE ORDER_ID = 875423; GoldenGate can capture this change and send it to a streaming platform such as Kafka. The event could look like: ...

Lock Free Reservations in Oracle: Eliminating Contention in High Volume Systems

One of the most common performance bottlenecks in enterprise applications is resource reservation. Whether it is booking airline seats, reserving hotel rooms, allocating inventory etc, many applications rely on database row locking to prevent double booking. While this approach works, it becomes a serious scalability challenge during peak demand. The result is, Increased lock waits Application timeouts Poor user experience Reduced transaction throughput The question is: Can we prevent double booking without relying heavily on database locks? The answer is yes. Modern Oracle based applications can implement lock free reservation patterns that significantly reduce contention while maintaining data integrity. The Traditional Approach Most applications perform a reservation using below method. SELECT available_qty FROM inventory WHERE item_id = 100 FOR UPDATE; If sufficient quantity exists, UPDATE inventory SET ava...

How OCI is Redefining the Future of Private Cloud for Modern Enterprises

Over the past few years, I have been closely following the evolution of cloud technologies and how enterprises are adopting them to drive digital transformation. While public cloud has become the default conversation for many organizations, I have often felt that the real enterprise challenge is not simply moving to the cloud, it is finding the right balance between innovation, security, regulatory compliance, and operational control. As someone who has worked extensively with enterprise infrastructure and Oracle technologies, I wanted to share my perspective on why Oracle Cloud Infrastructure (OCI) is taking a different approach to this challenge. This article explores how OCI is redefining the future of private cloud by combining the capabilities of a modern public cloud with the isolation, sovereignty, and operational independence that many organizations increasingly require. Cloud computing has completely changed how organizations operate today. Businesses are moving applicati...

How Oracle EBS is Transforming Modern Industries

Over the years, I had the opportunity to work with Oracle E-Business Suite (Oracle EBS) environments across multiple industries including manufacturing, banking, education, healthcare, and retail. Through these experiences, I have seen how Oracle EBS helps organizations streamline operations, improve efficiency, and manage complex business processes through a centralized platform. In this article, I would like to share a simple overview of how different industries are using Oracle EBS and how it continues to support modern digital transformation initiatives. In today’s fast moving business world, companies need systems that help them work faster, reduce costs, and make better decisions. Managing finance, HR, procurement, inventory, and operations through separate systems is no longer efficient. Businesses now prefer centralized platforms that can connect all departments together. This is where Oracle EBS plays an important role. Oracle EBS is one of the world’s most widely us...

Oracle Deep Data Security: Protecting Data in the Age of AI

“Oracle Deep Data Security” was discussed recently at the Oracle AI World Singapore and it interested me to further study on how data security is evolving in the age of AI. The way data is accessed, processed and protected is changing dramatically with the rapid adoption of AI among the organizations. That’s why I thought it would be useful to explore Oracle Deep Data Security in a simple and practical way. In today’s world, data is everywhere. Businesses store customer data, financial transactions, employee records and much more inside databases. Earlier time, security was mostly handled at the application level. But this approach is no longer strong enough. With AI tools generating queries dynamically and multiple systems interacting with the same database, relying only on application level security creates risks. This is where Oracle introduces a new approach, moving security directly into the database itself. Oracle Deep Data Security is built on the idea that data shou...

Bring AI to Data , A Smarter Way with Oracle!

“Bring AI to Data” is a term I recently heard during the Oracle AI World in Singapore last week and it really caught my attention. It sounded simple but the idea behind it is quite powerful. So I thought it’s worth exploring a bit more! Normally, working with data and AI meant one thing, which is, moving data around. We would extract data from databases, send it to external tools or platforms, build machine learning models and then push the results back into the database. But this approach adds complexity, increases costs and introduces security risks. But now, Oracle is changing that model by bringing AI to where the data already is ! The concept of “Bring AI to Data” is straightforward but powerful. Instead of moving large volumes of data across systems, Oracle allows you to run AI and machine learning directly inside the database. This means that data do not have to leave its secure environment. This results faster processing, reduced data duplication, improved security ...