Author: Marco Gralike
April 8

Anjo Kolk – How the Middle Tier is Slowing Down Your Database

AMIS is proud to announce their AMIS Query (free technical seminar), targeted at Oracle Database Architects and Database Administrators.

How the Middle Tier is Slowing Down Your Database

Multi tier systems are very common today. Most of these systems include a web server, an application server and a database. They also rely heavily on the very recent HTML and Java technologies. In fact, these technologies are relatively new and a whole set of new (and young) developers have been exploring them. This presentation is exploring the mistakes that are made in the middle tier and how they affect the database and what can be done to improve performance dramatically with some simple changes.

Read the postAnjo Kolk – How the Middle Tier is Slowing Down Your Database
April 8

HOWTO: Query via Xpath position function

April 8

HOWTO: Manually create a XMLType table (OR / Schema based)

The Mark Drake Method (first steps to success)

begin
 dbms_xmlschema.registerSchema
(schemaURL => 'http://www.gralike.com/marco/HistorieWW/WWBase.xsd'
,schemaDoc => xdbURIType('/public/HistorieWW/WWBase.xsd').getClob()
,local     => FALSE
,genTypes  => TRUE
,genBean   => FALSE
,genTables => TRUE
);
end;
/
Read the postHOWTO: Manually create a XMLType table (OR / Schema based)