Category Archives: Database

“Appleantization” as blueprint for Oracle’s DWA

When I was last year in Boston in Netezza seeing all high performant NPS systems and buying the same day iPhone and MacMini I told to myself: well this is the great day- I have seen the most sophisticated large appliance – (Netezza NPS) and I own also most advanced smallest appliance in the world – Apple iPhone –all this in one day. “We believe the best user experience is when all the pieces in the system are engineered to work together.” Larry Ellison said in recent interview. Apple and Netezza knew this from the beginning – they need to design and control hardware to be able to perform much more faster than traditional concept on general purpose HW. Oracle realized this as well and entered hardware last year with Oracle Exadata based on HP hardware, however reaching only 10 time faster boost in performance. But it looks like Oracle is very serious about the concept of integrated HW and SW Appliance – recent announcement of Oracle acquiring Sun might have probably tremendous impact on the whole DWA (Data Warehouse Appliance) market. Now with Oracle taking Sun with its hardware division, operating system, Oracle has got finally all pieces to build up from ground to up database machine.

Curiously enough Greenplun – yet another player in DWA market is using Sun Fire X4500 for its DWA. That will soon mean Greenplun is “powered by Oracle” J . Also Greenplun was classified by Gartner magic quadrant as “Visionary” for 2008 . With Oracle – Greenplun ‘partnership’ this might possibly bring Greenplun upper to “Leaders” quadrant. Sun itself with MySQL was positioned in niche players in DWA Magic Quadrant. All of that will push Oracle in the leaders quadrant more close to the top player “Terradata”.

what Mr. Ellison said in interview about plans with Sun here:

…"we are definitely not going to exit the hardware
business. While most hardware businesses are low-margin,
companies like Apple and Cisco enjoy very high-margins because
they do a good job of designing their hardware and software to
work together. If a company designs both hardware and software,
it can build much better systems than if they only design the
software. That's why Apple's iPhone is so much better than
Microsoft phones."

 

"..Some of our competitors, Teradata
and Netezza for example, were delivering pre-configured
hardware/software systems, while we were just delivering
software. The combination of hardware and software has
significant performance advantages for data warehousing
applications. We had to respond with our own hardware/software
combination, the Exadata database machine. Oracle's Exadata
database machine runs data warehousing applications much faster
-- at least ten-times faster than Oracle software running on
conventional hardware. All the hardware and software pieces,
database to disk, are included. You just plug it in and go -- no
systems integration required."

Hacking Oracle

Simply annoying. You know that gorgeous message saying “memory couldn’t be wrrrrriten press OK to exit or Cancel to debug…”. I thought that TNSLISTENER of Oracle9 could say something more…My all classical reapairments (like reboot, reinstall) came to nought. Well I tried to press cancel and see disassembler complaining that memory around zero can’t be read. Of Course ! edx was 0

mov ecx,dword ptr [edx+578h]

I put edx=eax (eax seemed to be valid address) and debugger was at least for a while satisfied until he reached another address where I have used similar approach to get rid of non valid addresses…and I was able to login into my databse ! (but the problem was to do it all the time I run sqlplus;( At the end of the day I found it was something with ws32_2.dll actually windowsockets and its LSP. I used tool called WinsockXPFix.exe and restarted my laptop. All is now runing fine… But believe me, I was ready to use IDA dissasembler and permanently modify the orantcp9.dll ;) [a good tool for ‘assembler scripting’;]

Image Storage with Oracle 9i and MicroStation

Summary: Paper describes a technology of storing rasters in Oracle database with usage of Oracle Spatial, Oracle intermedia option and Workspace managers. Rasters are displayed in MicroStation v8

Date: October 2002, Published in : ControlAltDelete III. 2002, Authors: Stanislav Sumbera, Petr Vinduska

Original site location 2002: http://www.sumbera.com/ustation/articles/Rasters/Rasters2.htm

download Java code

pdf version

Introduction

MicroStation plays important role in geoinformation systems (GIS) especially in Automated Mapping/Facility Management (AM/FM). In these areas, raster data such as satellite images, air photos, scanned topographical maps or other types of imagery are becoming increasingly popular. It has been estimated that these data may represents more than 90% of the average GIS data holding by volume. MicroStation V8 comes with Raster Manager as a solution for united raster management of different raster formats. Oracle 9i brings its GIS technologies like Spatial option, interMedia or Database Workspace Manager for effective database storing of geographical-related data. Oracle database is used in number of organizations to manage all kinds of data across the enterprise.

In this article, we will join Oracle GIS technologies with MicroStation v8 to build up a prototype called “Image Storage” for storing rasters in Oracle9i database using Oracle interMedia, Oracle Spatial, Oracle Workspace Manager and finally displaying query results with help of Raster Manager and it’s clipping capabilities. We are going to point out some interesting concepts and techniques in Image Storage.

Nowadays there are only a few solutions for storing rasters in databases, actually most of the interest in raster management lies in using compressed proprietary formats like Mr.SID or ECW. Note ECW is supported in MicroStation v8 as well. Continue reading