#Tips & Tricks

Post a job Follow
12 Followers · 326 Posts

Pieces of experience in InterSystems Technology which solve some particular problem in elegant or unusual way.

Post a job Follow
New
Article Luis Angel Pérez Ramos · Mar 20 7m read

SQL query optimization in IRIS

Hello to all the esteemed members of the InterSystems developer community in Spanish!

Although I often consult the developer community and have occasionally left a question here, this will be my first article, and what better occasion to do so than by participating in the 3rd technical article contest.

The topic I will cover in this article is the different tools that InterSystems IRIS provides us to optimize both the databases and the queries we run, as well as the new types of storage and data.

#InterSystems IRIS #Columnar Storage #Contest #Indexing #SQL #Tips & Tricks
0
0 73
Article Alyssa Ross · Mar 9 6m read

Vector Search with Embedded Python in InterSystems IRIS

One objective of vectorization is to render unstructured text more machine-usable. Vector embeddings accomplish this by encoding the semantics of text as high-dimensional numeric vectors, which can be employed by advanced search algorithms (normally an approximate nearest neighbor algorithm like Hierarchical Navigable Small World). This not only improves our ability to interact with unstructured text programmatically but makes it searchable by context and by meaning beyond what is captured literally by keyword.

In this article I will walk through a simple vector search implementation that Kwabena Ayim-Aboagye and I fleshed out using embedded python in InterSystems IRIS for Health. I'll also dive a bit into how to use embedded python and dynamic SQL generally, and how to take advantage of vector search features offered natively through IRIS.

#InterSystems IRIS #Embedded Python #Tips & Tricks #Tutorial #Unstructured Data #Vector Search
0
0 192