Visualising AI Embeddings in APEX

Image
" To deal with hyper-planes in a 14-dimensional space, visualize a 3-D space and say 'fourteen' to yourself very loudly. Everyone does it."     - Geoffrey Hinton , 2018 Turing Award winner. Within the wonderful world of  Generative AI , one concept that is all the rage is RAG, or  Retrieval Augmented Generation , which is an  AI framework that combines the strengths of traditional information retrieval systems (such as databases) with the capabilities of generative large language models (LLM s) . RAG's goal is to improve the accuracy, relevance, and timeliness of information  generation  - such as  documents, text and images -  by optimizing LLM output.  When creating a RAG system, it’s essential to store information in a format that a LLM can retrieve. This is where  data is converted into embeddings through a process that uses pre-trained m
Post a Comment

jQuery Zooming

Many online stores offer potential buyers the choice to view large version of images of products, but increasingly there is a tendancy to allow 'zooming' in on products to see more detail.  Amazon allows this with many of its products, for instance.

There is a plugin for jQuery which does something similar (ish) which I've add to my store demo.  Click on the product name for one of the products, I suggest the iPad or iPod Nano, to view this in action.  In the overlay window, hover over the image and you will see how this works.  Well this nifty little plugin is called jqZoom, but I also found a non-open source alternative that doesn't use jQuery called Magiczoom, which is used on a number of commercial sites.

You will notice that a few of the images are missing from the demo.  With jqZoom, you need to store small and large versions of each product image, although the large image only gets loaded when you hover over the small image.  Each image is stored as a Blob linked to the product.  As I was loading up the images using the application I kept getting a 'ORA-01691: unable to extend lob segment.....' error, so I need to look into this.

Comments

Martin D'Souza said…
Hi Paul,

Nice work. I tested with FF and it isn't working for your online store.

Martin
12 February 2010 at 18:35
Paul Brookes said…
Hi Martin,

Thanks for your feedback.

Which version of FF are you using, as I'm using 3.5.7 and its working fine? Did you try looking at the iPod and iPad, as many of the other products haven't been setup properly with small and large images?

Thanks,

Paul.
12 February 2010 at 18:48
Roel said…
Hi Paul,

Cool stuff. But the zooming only seems to work for the first item on the page. If I click on of the other items, the picture opens op in the same browser window (replacing the 'store'). Using FF 3.0.

Regards
Roel
17 February 2010 at 08:17
Paul Brookes said…
Hi Roel,

Thanks for the feedback.

Can you tell me the exact version number of FF you are using? I'm having trouble replicating this. To help me find out why, can you tell if there is anything you are doing prior to clicking on the first product header.

I know if a product name is clicked before the page completely loads then the product is displayed as you say, but I'm surprised it does it for the second product you select.

Thanks for your help,

Paul.
17 February 2010 at 08:39
Roel said…
I just open the page and (when everything is loaded) I click on the second item: it shows up in the same browser window (replacing the store). When I navigate back and click on the first item (Axle wheel), then the zooming works fine. If I make a selection and another item is the first one, it only works for that first item.
I am using FF 3.0.16
IE 7 works the same as FF
Chrome works fine

HTH
Roel
17 February 2010 at 10:09
Paul Brookes said…
Hi Roel/Martin,

I changed the way in which jQuery utilises FancyBox, so the upshot is that it should now work on older versions of FF.

I've tested on 3.0.17, but would appreciate it if you could retest.

Thanks,

Paul.
18 February 2010 at 10:45
Roel said…
Hi Paul,

Now it works fine in my version of FF. Even in IE7, the popup works (although the shadow is a bid odd and there is no overlay, so I can still click 'inside' the store).

Good work!
Roel
18 February 2010 at 12:32
Paul Brookes said…
Thanks Roel,

The weird shadow and overlay issues in IE should now be fixed.

Paul.
19 February 2010 at 08:09
Post a Comment

Popular posts from this blog

Visualising AI Embeddings in APEX

Image
" To deal with hyper-planes in a 14-dimensional space, visualize a 3-D space and say 'fourteen' to yourself very loudly. Everyone does it."     - Geoffrey Hinton , 2018 Turing Award winner. Within the wonderful world of  Generative AI , one concept that is all the rage is RAG, or  Retrieval Augmented Generation , which is an  AI framework that combines the strengths of traditional information retrieval systems (such as databases) with the capabilities of generative large language models (LLM s) . RAG's goal is to improve the accuracy, relevance, and timeliness of information  generation  - such as  documents, text and images -  by optimizing LLM output.  When creating a RAG system, it’s essential to store information in a format that a LLM can retrieve. This is where  data is converted into embeddings through a process that uses pre-trained m
Read more

Oracle Select AI and APEX

Image
Yes, yes, I know, it's my first blog post in 10 years.  A s Oracle is doing some really interesting stuff with AI I thought I'd break cover and do a post showing a little something I've been working on. It's probably not escaped your attention that Oracle recently announced the release of Oracle Database 23ai (on OCI/Azure now but not yet on-prem), with a host of new features to allow developers to incorporate generative AI (genAI) into their work which will ultimately help end users be more productive. One AI feature that was released in 2023 prior to this announcement is Select AI , or Autonomous Database Select AI to give it the proper title.   This is a feature of the Autonomous Database that enables data to be queried using natural language, generating (ANSI) SQL from genAI large language models (LLMs) such as  OpenAI,  Cohere and Azure OpenAI.   There's a great  demo put together by the Oracle APEX team demonstrating Select AI working with APEX.  In the demo
Read more

Fun with Bubbles!

Image
I'm on a train up to Liverpool for the UK Oracle User Group Tech 14 conference, and decided it's about time for a post showing something I've been working on.  I don't post often these days, which I blame on work and family commitments, but is probably just down to pure laziness.  Anyhow, I'm feeling in the mood so I'll just get on with it in case the desire to catch some zzz's becomes overwhelming.  Also it takes my mind of the bad coffee served up on the train. So, I've been getting into  D3  a little, which if you don't already know is a JavaScript library for manipulating data to create interactive graphs and charts.  Some of the stuff people are creating using D3 is amazing, including this dynamic bubble chart example.  I thought I would use this example as the basis for creating a bubble chart in Apex, that dynamically updates with some cool transitions, using data from the database rather than the real time API in the example. The demo ca
Read more