Last week I put out a series of screencast style demos that
sought to demonstrate the core elements of our soon to be released
Javascript Toolkit called OAT (OpenLink Ajax Toolkit) and its
Ajax Database Connectivity layer.
The screencasts covered the following functionality realms:
-
SQL Query By Example (basic)
-
SQL Query By Example (advanced - pivot table construction)
-
Web Form Design (basic database driven map based mashup)
-
Web Form Design (advanced database driven map based
mashup)
To bring additional clarity to the screencasts demos and OAT in
general, I have saved a number of documents that are the by
products of activities in the screenvcasts:
-
Live XML Document produced using SQL Query By Example (basic)
(you can use drag and drop columns across the grid to reorder and
sort presentation)
-
Live XML Document produced using QBE and Pivot Functionality
(you can drag and drop the aggregate columns and rows to create
your own views etc..)
-
Basic database driven map based mashup (works with FireFox,
Webkit, Camino; click on pins to see national flag)
-
Advanced database driven map based mashup (works with FireFox,
Webkit, Camino; records, 36, 87, and 257 will unveil pivots via
lookup pin)
Notes:
- “Advanced”, as used above, simply means that I am embedding
images (employee photos and national flags) and a database driven
pivot into the map pins that serve as details lookups in classic
SQL master/details type scenarios.
- The “Ajax Call In Progress..” dialog is there to show live
interaction with a remote database (in this case Virtuoso but this could be any
ODBC, JDBC, OLEDB, ADO.NET, or XMLA accessible data source)
- The data access magic source (if you want to call it that) is
XMLA - a standard that has been in place for years but completely
misunderstood and as a result under utilized
You can see a full collection of saved documents at the
following locations:
About this entry:
Author: Kingsley Uyi Idehen
Published: 06/01/2006 22:48 GMT-0500
Modified: 06/22/2006 08:56 GMT-0500
Tags: ajax , web2.0 , web20 , xml , jdbc , sql , odbc , howto , screencast , javascript , dynamic_languages , oat , openlink , virtuoso , .net , ado_dot_net , ado , programming , ado.net , uda , xmla
Categories: Demos , Virtual Database , Data Access , SQL , Semantic Web , Content Syndication , XML , Database Technology
Comment Status: 0
Comments
Permalink:
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/988