Abstract:
At The University of Auckland Library we successfully tried another approach in demystifying the BLOB: slicing it in Oracle by employing existing functions in Voyager.
All we have done is to invoke these functions into our SQL statements and in no time at all we obtain the information we want. We can run these queries in 3 different environments:
Oracle’s own SQL+
Microsoft Access (in Pass-through Queries)
SQL Server 2000
The advantages of using this approach are:
Speed of execution
Data extraction is server side therefore independent of Microsoft Access VB.
Possibility to schedule the query to run at fixed intervals. (in SQL Server)
The simplicity of using what is already in the Voyager database is making this melange of Oracle and SQL server queries not only chic but also efficient.