Using XML in Oracle DB for Google Books

I demonstrate how to upload and extract information from an XML document that was exported from a Google Books bookshelf. Some data qaulity issues were detected with this bookshelf export. The final data model is a minor change from the model provided by Google Books: individual contributors are split out into a separate table; and the ISBN is used to identify books (where available).

Handling Three-Value Logic

I have just finished reading Applied Mathematics for Database Professionals By Lex de Haan and Toon Koppelaars. I was struck by the discussion about nulls in Appendix D, especially about the inconsistent handling of NULLs between constraints and predicates in SQL (see p.344)

NORDIC Schema for TopLink Demonstration (4)

Having discovered the limitations of JDeveloper for support of object-oriented database objects in NORDIC Schema for TopLink Demonstration (3), we will clean up the NORDIC schema in both the offline and online databases, before exploring TopLink itself.

NORDIC Schema for TopLink Demonstration (3)

Now to complete the creation of the ANIMAL type started in NORDIC Schema for TopLink Demonstration (2) by using JDeveloper and TopLink.

NORDIC Schema for TopLink Demonstration (2)

Following on from NORDIC Schema for TopLink Demonstration (1), the more complex Animal type is now tackled.

NORDIC Schema for TopLink Demonstration (1)

Overview

This document details the SQL needed to establish the NORDIC schema in an Oracle XE database for the demonstration of the use of TopLink which is included in Oracle JDeveloper 11g (Build 5188). This SQL is based on the NORDIC series of articles on this blog.

Object views are used to replace object tables because TopLink cannot import Object Tables into the Offline database.

Puzzling Query

Came across this little beauty of an SQL statement. It took me a while to work out it was doing, before I realized there was a simpler solution.

Nordic (15)

This series is a commentary of sorts on a PowerPoint™ presentation called Nordic – Object Relational Database Design. We are still at slide #73 of the presentation.

PL/SQL Instrumentation using ILO

Fred has embarassed me by reminding me that I had introduced him to code instrumentation by using the DBMS_APPLICATION_INFO package as he explains PL/SQL Instrumentation using ILO.

As people will have noted from my series on Nordic, I have not been using any code instrumentation at all. To remedy this, I am going to install the ILO package into the Oracle XE database.

Nordic (14)

This series is a commentary of sorts on a PowerPoint™ presentation called Nordic – Object Relational Database Design. We are still at slide #72 of the presentation.