The Oracle Database ships with a wonderful technology called Oracle Text. Most people associate Oracle Text with the mere ability to index documents or data, perform text or phrase queries and get the results back. But Oracle Text can do so much more. One of the more interesting features of Oracle Text is the ability to analyze a document and generate a list of themes for the document along with a weight associated with that theme.
Back in 2004, in the era of Oracle HTML DB, Jason Straub on the Application Express development team wrote a demonstration application named Presidential Inaugural Addresses, which used both Oracle HTML DB and Oracle Text. This application actually shipped with Oracle HTML DB for a time. This was a fascinating application, which enabled you to view all of the Inaugural Addresses of the Presidents of the United States, identify the top themes associated with those addresses, and even identify which past presidents delivered addresses that had similar dominant themes.
This demonstration application stopped shipping with Oracle Application Express in 2006. But I thought it might be interesting to dust off this application and improve the UI using Oracle Application Express 5.1. So that's how I spent this past weekend (let the good times roll). Using the existing data structures, I was able to create a new Universal-theme based application which turned out pretty elegant.
Please understand - this application and everything associated with it is not a political statement. Given the relevance of this data at the time of this writing, I simply thought it would be a fascinating way to demonstrate insights into this information, using the Oracle Database, Oracle Application Express, Oracle Text and Oracle JET!
You can run this application HERE.