Niall McPhillips
♠︎ Oracle ACE Director. PL/SQL devt. ORDS. APEX. Data Models. REST + Web Services. Multimedia. Text. Int'l Organisations. Energy.
Genève, Switzerland
Actions
Niall McPhillips is an Oracle ACE Director and a member of Symposium 42. He has presented over 70 times at international conferences on different subjects including the use of Oracle technologies including APEX, ORDS, PL/SQL, REST, JSON, Oracle Text, SODA, Multimedia as well as on his experiences with the implementation of large APEX projects.
He has been using Oracle since 1989, has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005.
Niall has developed many large, multilingual applications for multinational companies and organisations all over the world. He is a strong believer in PL/SQL and APEX solutions because of their stability, scalability, and rapid development speed.
Links
Badges
Area of Expertise
Topics
Building an AI Vector Search API using 23ai, ORDS, REST webservices, PL/SQL
AI Vector Search is an exciting, powerful new set of AI tools that are already an integral part of Oracle 23ai.
ORDS is Oracle's flagship tool for implementing RESTful web services in PL/SQL.
In this presentation, through live, practical examples, attendees will learn how to build a REST API to incorporate Oracle 23ai's AI Vector Search into their applications.
We'll develop a technology-independent REST API that will be usable from both Oracle and by non-Oracle environments alike.
Topics to be covered include:
- introducing vector search and Oracle 23ai's AI Vector Search
- a brief intro to building ORDS web services in PL/SQL
- defining a vector search API
- developing vector search APIs using ORDS and PL/SQL
- securing the new API using OAuth2
Search and you shall find. A walk through the Oracle 23ai search landscape
This presentation will discuss AI Vector Search and the new AI Vector Hybrid Search, along with a few other more classic search techniques.
With recent 23ai additions — AI Vector Search, Hybrid Vector/Text Search and Ubiquitous Search — alongside the classic Text Search and Simple Search, understanding these search options is essential for choosing the right approach when building PL/SQL, APEX, and other Oracle applications.
This session explores the characteristics of each search technique, highlighting their advantages and disadvantages through real-world examples, live demonstrations, and discussions. Attendees will gain insights into the factors to consider when selecting and implementing the search approach that best meets their needs.
So, you've been asked to write an ORDS REST API ...
Designing and creating APIs with PL/SQL and ORDS
Oracle REST Data Services (ORDS) offers a powerful way to expose Oracle DB functionality over RESTful APIs. During this session, we’ll explore how developers can quickly build secure, high-performance, and scalable APIs using SQL and PL/SQL.
The presentation will include:
- creating ORDS modules, templates and handlers,
- practical patterns for defining REST endpoints,
- use of HTTP methods for CRUD operations,
- JSON design principles and working with JSON payloads,
- using HTTP response codes,
- pagination and filtering,
- adding OAuth2 security, and
- documenting your API with OpenAPI
What's Our Vector, Victor? Navigating AI Vector Searches in Oracle 23ai
In a fast changing environment, Oracle 23ai introduces an exciting new feature with its AI Vector Search capabilities.
We'll start with the essentials — demystifying the concept of AI Vector Search in the Oracle database. What are vectors, and how can they change our approach to search queries?
The presentation progresses to discuss real examples of how to prepare and generate your vectors for embedding in your database. It also covers the new search operators and functions introduced with this feature.
Moving beyond basics, we will delve into practical applications. Learn how to embed your vectors, transforming raw data into a rich, searchable landscape. We’ll explore the new search operators and functions that Oracle 23ai brings to the table through real-world examples.
We'll take a look at vector distances and measurement methods. Through illustrative examples, understand how similarity searches can be performed using AI Vector Search.
Bringing it all together, we will integrate it with PL/SQL and APEX applications. This will be a synthesis of theory and practice, showcasing the incorporation of AI Vector Search into database environments.
Niall McPhillips
♠︎ Oracle ACE Director. PL/SQL devt. ORDS. APEX. Data Models. REST + Web Services. Multimedia. Text. Int'l Organisations. Energy.
Genève, Switzerland
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top