Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)

Marco Gralike 7

People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will […]

UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server

Marco Gralike

Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file server. The presentation demonstrated as well how you could extent the “standaard” file server (aka your database) functionality with features like, […]

Review: The Method-R Profiler

Marco Gralike

I was lucky enough to get my hands on the Method-R Profiler and had a test drive with it. So first of all what is it? As you might expect a profiler, a profiler for Oracle performance problems. The tool makes use of Oracle’s trace facilities. If you have a […]

2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)

Robbrecht van Amerongen

In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken in de wereld heeft verzameld en die hij ook mede door zijn nauwe samenwerking met het PL/SQL product team van Oracle […]

Call for Papers UKOUG ends on Monday

Marco Gralike

Be aware that the Call for papers for the UKOUG Tech. Conference in December is closing on Monday. ….and yes I know, having Oracle Open World almost opening its doors or The Michigan OakTable Symposium just coming up in the agenda, thinking about stuff in December is a bit strange, […]

Laatste "Plug" – Cuddly Toys Not Included – Een AMIS Query met Doug Burns

Marco Gralike 2

Donderdag as. is de AMIS Query van Doug Burns over SQL Tuning, gebruikmakend van de Oracle Enterprise Manager (Tuning en Diagnostics pack). Misschien verwachten velen een hoog “DBA” gehalte, maar niets is minder waar… Deze presentatie bevat bijna geen enkele slides en is echt een aanrader om bij te wonen. […]

An Evening with Oracle Database Security Expert: Pete Finnigan

Marco Gralike 1

AMIS Technology School is proud to present, in collaboration with Miracle Benelux Masterclasses: An Evening with Oracle Database Security Expert: Pete Finnigan on Tuesday 25th of May, 2010. Miracle Benelux and Pete Finnigan agreed to do an extra special on the AMIS premises the evening just before Pete’s 2 day […]

Oracle Open World XMLDB Sessions and Presentations

Marco Gralike 2

Its time to enlist. It really is. At least regarding the XMLDB related sessions and presentations during Oracle Open World 2009. As far as I have seen today, the hands-on workshop has almost no seats left and more than half already enlisted for my XMLDB New Features and XMLDB Performance related presentation.

Oracle Open World doesn’t have much XMLDB related sessions, until now from the 1800+ sessions, I only counted a dozen or so. If you want to have a peak of the ones I found, have a look at the following Oracle OTN XMLDB Forum thread.

Oracle Open World 2009: XMLDB Presentations and Related Workshops
I enlisted for most, as long as they didn’t interfere with my presentation schedule, if not only that I am very anxious about Mark Drake’s presentations about Google API mashups etc combined with the XMLDB functionality in the database and the, probably extended version of how to build an APEX content management system based on the versioning and filler capabilities of the XMLDB Repository. During OOW 2008, Carl Backstrom, helped and co-presented this APEX/XMLDB joined venture and, alas, this demo app of the XFILES light weight XMLDB CMS, never (at least yet AFAIK) hit the demogrounds or the OTN XMLDB main pages.

read more…

Oracle Enhances XBRL Reporting Capabilities with UBmatrix, Inc.

Marco Gralike

Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others):

“To help publicly held companies facilitate the preparation, publishing and automatic exchange of financial statements in XBRL (eXtensible Business Reporting Language), Oracle will embed UBmatrix, Inc.’s leading XBRL technology into Oracle’s Enterprise Performance Management (EPM) System, Oracle announced today.”

“Oracle and UBmatrix are also working together to provide enterprise class storage and management for XBRL-based information in Oracle® Database 11g. Using Oracle Database’s XML DB feature, organizations can easily and quickly store, access and query their XBRL data.”

A lot of you might ask themselves: “Who are or what is UBMatrix ???” and how does it all fit in…


Enhancing fast queries using "Tapio-Indexes"

Gerwin Hendriksen

During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these situations the execution plans, from such queries can look like:   OPERATION            OPTIONS                 OBJECT# NAME                         ——————– ——————– ———- ———————————– SELECT STATEMENT                                     […]

Bloom Filters, Hierarchical Profiling, Synopses & One pass distinct sampling, jumping the GAPP … – feast for DBAs (considered harmful..)

Lucas Jellema

  It’s Monday night and a select company of DBAs and Database developers have gathered at AMIS HQ in Nieuwegein for the ‘Looking Back at Hotsos 2009’ session. It is one of those sessions that has a lot of energy, laughter and a wealth of serious content. Four very experienced […]

AMIS Query 18 May – Hotsos 2009 Revisited

Marco Gralike

The 8th of March 2009…The Oracle Performance Symposium in Irving, Texas, also known as the Hotsos Symposium was about to start… Four Dutch guys had the luck to attend this year: Jeroen Evers (Fameus), Toon Koppelaars (RuleGen), Gerwin Hendriksen (AMIS) en Marco Gralike (AMIS). We wanted to share some of […]

AMIS Query 18 Mei – Een Terugblik op Hotsos 2009

Marco Gralike 1

Begin maart 2009 werd in Irving, Texas, het internationale Oracle Performance Symposium Hotsos gehouden. Ook dit jaar stond het symposium garant voor inhoudelijke hoogstaande presentaties en discussies over performance. Vier Nederlanders, Jeroen Evers (Fameus), Toon Koppelaars (RuleGen), Gerwin Hendriksen (AMIS) en Marco Gralike (AMIS), hadden het genoegen om ter plekke te […]