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

Static Region Id's and Ajax Fun

More Online Store demo shenanigans for you. A bit dry this one I'm afraid.

A couple of days back I decided to export/import my Online Store demo, and whilst viewing the new imported version of the application found it to be completely kaput.  It didn't take long to realise that I had made the mistake of hard coding region id's in some of the Javascript.  Well, I thought this will be easy to fix as I can just utilise Static id's instead in my regions and in place of #REGION_ID# in templates.  So far, so good, but then I realised that the Ajax refreshing of the Products and Shopping Basket regions is done using calls to html_PPR_Report_Page and $a_report, and both these require the internal numeric region id as a parameter.  As far as I know neither recognises the Static id (please correct me if I am wrong).  Doh!

I get around this by creating hidden items (i.e. P1_PRODUCT_REGION_ID) based on a SQL query that uses the Static id to get the 'real' internal numeric ID. The following SQL does the job:

SELECT region_id
FROM   apex_application_page_regions
WHERE  static_id      = 'PRODUCTS_REP_REG'
AND    page_id        = v('APP_PAGE_ID')
AND    application_id = v('APP_ID');


All well and good I thought, but then I found another issue.  In the main Products region if the search is refined so that no rows are returned then instead of displaying the 'When No Data Found Message' wording from Report Attributes section it displayed the whole page embedded within the region.  Double Doh!

Again, it appears I had hard coded the internal region id into the 'When No Data Found Message' section, something like:



 
- No Products Found -

This had worked nicely in the orginal app from which the export came, as in lieu of a 'No Data Found' template, I simply copied the div and table tags that would appear if rows were returned in the Products region. But now it was useless. Therefore, I employed the following instead to fix the problem:




- No Products Found -

This simply embeds the value of the P1_PRODUCT_REGION_ID (the internal id of the product region) into the HTML. Voila. It works a treat, and no hard coding of id's in sight.

So, not a lot of visible progress on the store this week. Although, I have managed to make the site look similar and work the same way in IE, FF and Chrome.

Hopefully next week I can start to look at improving the look of the store. I also want to change the templates to be Div based as per the new APEX 4.0 theme.

Comments

Patrick Wolf said…
Hi Paul,

a quick tip. Always use bind variables in your SQL statement instead of the V function. Because that can have cause performance problems. Have a look at http://www.inside-oracle-apex.com/drop-in-replacement-for-v-and-nv-function/ for details.

Regards
Patrick
22 February 2010 at 08:16
Paul Brookes said…
Thanks Patrick,

Good point!

Now updated to use bind variables instead.

Cheers,

Paul.
22 February 2010 at 08:59
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