Skip to main content

Posts

Hybrid Search in Oracle AI Database 26ai - Why Enterprise AI Needs More Than Vector Search?

Over the years, working with enterprise databases, middleware and production support environments, I have learned one simple thing. Finding the right information during a production issue is not always easy! Sometimes we know exactly what we are looking for. It could be an Oracle error such as ORA-12541, a database name, an incident number or a configuration parameter. But sometimes we only know the problem. For Ex: “The application cannot connect to the database after the DR switch.” We may have solved exactly the same problem before, but the old incident or RCA could describe it using completely different words. This is where I find Hybrid Search in Oracle AI Database 26ai particularly interesting. It combines something we already know very well - text search - with semantic vector search. And for enterprise AI, I think we need both. Vector Search Changed the Way We Search! Traditional search mainly depends on words. If I search for, “Database connection fai...
Post a Comment
Read more
Recent posts

Oracle Technology in Banking – From Core Transactions to AI Driven Banking!

Banking technology has changed significantly. But one thing has not changed - the banking platform must be secure, available, fast and reliable. A customer may see only a mobile banking screen. Behind that simple screen, there can be many systems working together: Mobile App → API → Integration Layer → Core Banking → Oracle Database → Payment Systems → Analytics This is where Oracle has played an important role in the banking industry for many years. Today, Oracle technology in banking is much more than just Oracle Database. It can include, Oracle Database Oracle RAC Oracle Data Guard Oracle GoldenGate Oracle Exadata Oracle Cloud Infrastructure (OCI) Oracle FLEXCUBE Oracle Banking Digital Experience Oracle APEX Oracle Autonomous Database Oracle Analytics and AI technologies Let us look at some practical examples. 1. The Database is Still at the Heart of Banking Think about a simple fund transf...
Post a Comment
Read more

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: ...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more