Viscosity
logo-black
  • Data
    • Database Services
      • Performance Assessment
      • Proactive Healthcheck
      • Database Migration & Consolidation
      • Performance Tuning
    • Microsoft Services
      • Microsoft Azure Services
      • Microsoft SQL Server Services
      • Microsoft Gold Azure Partner
    • Oracle Services
      • Oracle Database 19c
      • RAC
      • GoldenGate
      • Data Guard
      • Oracle & SQL Database
    • Viscosity Remote Services
  • Apps
    • App Dev Services
    • Oracle APEX
    • Viscosity AMP
    • Viscosity-ai
    • Shane-ai
  • Cloud
    • Cloud Services
    • Hybrid Cloud
    • Viscosity Edge Cloud
    • Virtualization & Cloud Expertise
    • Microsoft Azure Services
  • Infrastructure
    • Infrastructure Services
    • Exadata
      • Exadata Resale & Services
    • Oracle Database Appliance
      • Oracle Database Appliance Resale & Services
      • ODA Health Checks
    • Zero Data Loss Recovery Appliance
    • VMware to KVM Migration
  • Events
    • Upcoming Events
    • Virtual Training
    • 2025 Past Events
    • 2024 Past Events
    • 2023 Past Events
    • 2022 Past Events
  • About
    • About Us
    • News
    • Blogs
    • Publications
    • Contact
Hit enter to search or ESC to close
ENGAGE WITH US

Revolutionizing Search with Weaviate and Oracle APEX: A Smarter, AI-Driven Approach

By Javier Golon
November 13, 2024

When building applications that need dynamic search functionality, there's always a challenge in moving beyond simple keyword matching. During a recent Lunch and Learn presentation, I explored how integrating Oracle APEX with tools like Weaviate can completely transform the search experience, particularly when you're looking to harness the power of embeddings to enhance accuracy, performance, and multilingual capabilities. 
 

Understanding the Basics of Weaviate Integration 

The integration with Weaviate allows for a more intelligent search by interpreting relationships between search terms and data. Instead of only finding exact keyword matches, Weaviate understands the broader context of search queries.

 

For example, when a user searches for "programmer," Weaviate grasps the meaning of the search and finds similarities in the data within its database. This ensures search results align contextually with the user's intent, offering a richer and more relevant dataset. You can also specify attributes to fine-tune these matches. 

 

 

 

Leveraging Oracle APEX's Smart Filter with Weaviate  

Another advantage of this integration is that you don't need to build custom components to integrate AI search with your APEX pages. You can combine Oracle APEX's smart search component with Weaviate's AI-driven results, allowing you to use the APEX's default filter options alongside general search results pulled from Weaviate.

 

In Weaviate, the query results include a 'certainty' value, which indicates how closely each result matches the search intent. This value plays a significant role in refining search results, as it reflects the level of confidence in the results provided. By adjusting the certainty value, users can fine-tune their search to either return precise matches or broaden the scope for more generalized results. This flexibility allows users to adapt their searches based on their individual needs—whether they seek precise matches or are open to exploring broader options. 

 

 

 

Real-World Benefits of AI-Driven Search 

The practical benefits of Weaviate are clear when you compare its AI-driven search results to a traditional APEX search. A basic search in APEX requires exact keyword matches. For instance, a search for "educational software developer" in APEX would return no results unless an exact match existed. However, with Weaviate, the same query would produce relevant results, even if the exact terms don't appear. 

 

Weaviate's AI understands the meaning behind the search terms and interprets data based on context, enabling users to discover results that might have otherwise been missed. This shift from keyword-based to context-based searching represents a huge improvement in how users find relevant information. 
 

Multilingual Capabilities for Broader Access 

A standout feature of Weaviate is its multilingual search capability. It can interpret search terms in different languages and return results that may be in another language. For example, searching for "programador" (Spanish for programmer) will return programming-related terms, even if the job titles are in English or another language. 

 

This functionality is invaluable for businesses operating in multilingual environments or serving diverse user bases, eliminating language barriers and enhancing accessibility.

 

Security and Deployment Flexibility 

Security is critical, especially when integrating third-party tools with sensitive data systems. With Weaviate, there are multiple deployment options to suit different organizational needs. For those prioritizing data privacy, Weaviate can be deployed locally using Docker images, keeping the data secure within an organization's infrastructure. Alternatively, a cloud-based option is available, allowing businesses to choose a solution that best fits their needs.

 

Conclusion 

Integrating Weaviate with Oracle APEX is a game-changer for improving search functionality. By shifting from exact keyword matches to an AI-powered, context-aware search, users can discover more relevant results. Features like filtering, multilingual support, and flexible deployment options make Weaviate a powerful tool for any organization looking to enhance its search capabilities.

 

By leveraging these advanced AI technologies, businesses can offer their users a smarter, more effective search experience, ensuring that they find opportunities best suited to their skills and interests. 

All posts
About Author
Javier Golon

Javier Golon is a systems engineer with extensive experience in development using Oracle APEX. He currently works as a software developer at Viscosity, where he leads and collaborates on significant projects, standing out for his adaptability, problem-solving skills, innovation in solutions, and creativity in his work. In his free time, he enjoys watching movies of various genres. He is also a sports enthusiast, regularly playing soccer and swimming to stay in shape. His greatest passion is volcano climbing, an activity that allows him to combine his adventurous spirit with the exploration of stunning and challenging natural landscapes.

SUBMIT YOUR COMMENT
logo for footer

Viscosity's core expertise includes:

Data Transformation, Emerging Technology, High Availability & Scalability Solutions, Cloud Migrations, Performance Tuning, Data Integrations, Machine Learning, APEX Development, and Custom Application Development.


Solutions

Resources

Partnerships

Careers

Clients

 

Contact
Email: sales@viscosityna.com

Telephone:
(469) 444-1380

Address:
3016 Communications Pkwy Suite 200, Plano, TX 75093

Copyright 2025. All Rights Reserved by Viscosity North America.