Oracle Spatial Locks Your Data Away

That is the only conclusion I can come to out of this wacky ruling.  A huge warning to everyone, if you put your data in Oracle Spatial, you may never get it back out because it ceases to be data and turns into software.  There is only one song that comes to mind here:

On a side note, clearly you don’t want me to live in your town our county.  I grew up in Orange County and now live in Tempe.  Possibly it is I who causes data to be locked away.

Here comes the anti-database “movement”

I’ve been seeing more and more articles like this one from Computerworld about abandoning SQL databases.

The meet-up in San Francisco last month had a whiff of revolution about it, like a latter-day techie version of the American Patriots planning the Boston Tea Party. The inaugural get-together of the burgeoning NoSQL community crammed 150 attendees into a meeting room at CBS Interactive. Like the Patriots, who rebelled against Britain’s heavy taxes, NoSQLers came to share how they had overthrown the tyranny of slow, expensive relational databases in favor of more efficient and cheaper ways of managing data.

NoSQLers?  Oh boy are we going to be in for it when they hear how critical databases are for the geospatial industry.  To me this “revolution” sounds more like a backlash against the traditional SQL DBA who doesn’t want to change in the face of “Web 2.0″.  Of course it is very easy to move to a new data storage platform when you either have a ton of money or no product yet.  While I do think technology such as Google’s BigTable and Amazon’s SimpleDB as an inevitable course for many web applications, wholesale abandonment of SQL and databases such as Oracle/SQL Server/PostgreSQL is absurd.

No-SQL Patriots dump RDBMS without a care to the implications...

No-SQL "Patriots" dump RDBMS without a care to the implications...

Licensing on the GeoWeb

The GeoWeb is easy, right?

The GeoWeb is easy, right?

OK, love or hate the term GeoWeb, it does reflect the reality of our workflows today.  We are taking our applications off of the desktop and running them on the web, we are combining data silos right inside the browser and we are giving tools to that used to be reserved for technicians on UNIX workstations to users via their mouse.  It is truly a new way of working, but I see it running directly in a wall.

Licensing

Here we are at the tip of the iceberg changing the world (maybe a self-serving statement), but we’ve got a chain around our necks limiting our potential.  Google and Microsoft’s (among others) APIs are sold the same way IBM sold software before there was the world wide web, large companies can cut great deals, smaller users are left paying full price because we don’t matter.  ESRI’s ArcGIS Desktop and Server licensing doesn’t reflect how users are using the applications in the real world (sure, allowing editing on ArcGIS Server Standard instead of Advanced is a step, but it is just one in a long list of problems with the licensing model).  Don’t even get me started on Oracle’s licensing.  Arbitrary levels of licensing that have no real world basis are killing innovation and requiring consumers of the services to look elsewhere or limit what they can do with technology.  I’m not advocating abandoning any of these companies here because there are great business cases to use their software, but their customers are not able to continue business as usual.

Wont someone please think of the users?

Won't someone please think of the users?

Just last Friday, I was talking to a client who was paying for ArcInfo because one hour a month he needed a function that it handled.  The rest of the time ArcView was good enough for him.  This isn’t just limited to ESRI, most software companies sell software this way and users are expect to pick up the cost just to get some functionality that some committee, in a dark room in their software design center, determined that only “power users” would need is crazy.  Sure there are ways to get around most of these limitations using other software, but all these companies are doing is pushing their customers away.

So what do we need here?  Google offers their products as SaaS and so does Microsoft.  Why does this make sense for “Office” applications and not Geospatial software?  Now these efforts of course don’t replace Microsoft Office and that isn’t their mission (well at least Microsoft’s).  But what do they do is allow users to extend their collaboration further than the office conference room.  Geospatial software is well set up to take advantage of services.  Pay for what you use and spend the savings on tools that benefit the end users and not tools that you’d never need.

So I’m not exactly expecting a revolution here in the next year, but unless companies start thinking about the realities of how users are using their software or APIs, we are going to have to look elsewhere or create our own tools.  Given what the licensing costs these days, there is money to get that done.  Personally I’d rather just use an off the shelf solution and pass those savings on to my clients and get back to building great applications for them

The GeoMonkey only wants what is right...

The GeoMonkey only wants what is right

Oracle enters the cloud (MySQL Enterprise too)

Oracle and Amazon today announced that Oracle would be offering some of their products inside Amazon’s EC2 cloud.

The Oracle Database 11gOracle Fusion Middleware, and Oracle Enterprise Manager can now be licensed to run in the cloud on Amazon EC2. Customers can even use their existing software licenses with no additional license fees. 

While I see nothing specifically about Oracle Spatial, I assume is can be licensed as well on the cloud.  The benefit to everyone is outside of licensing costs, the ability to launch the Oracle AMIs on EC2 and be up and running in no time.  That plus the scaleability of EC2 (and thus Oracle) means that you don’t have to worry about hardware limitations with your applications.  RSP Architects uses SQL Server as our database of choice, and while I would have been able to run Oracle in a virtual server, I no longer have to worry about hardware constraints to our development.  Just license (which of course I realize is a problem for some people) and start loading the database.  I’m anxious to see how ArcGIS connects to Oracle Spatial on EC2 and what kind of performance I can expect.

Cloudzilla carries Oracle onshore

Cloudzilla could be unbeatable with Oracle in his hands

Now for those who want to avoid Oracle, MySQL Enterprise as well in the Amazon Cloud.

ESRI on Oracle 10.2.0.4 Patch and ST_GEOMETRY

I’m sure most ESRI customers received the following email from ESRI regarding the Oracle 10.2.0.4 patch and ArcSDE:

If you are a user of the ArcGIS Server 9.2 ST_GEOMETRY data type with Oracle, we would like to make you aware of the following issue:

The recently released Oracle patch version 10.2.0.4 may make unexpected changes to the ST_GEOMETRY schema. ESRI is in contact with Oracle, and we are working together to understand and quickly resolve the problem in this Oracle 10.2.0.4 patch upgrade.

ESRI strongly recommends that all Oracle-based customers not upgrade to the Oracle 10.2.0.4 patch until ESRI has certified this Oracle patch release with ArcGIS Server 9.2.

If you have already upgraded to Oracle 10.2.0.4 and think you may be experiencing this issue, contact ESRI Support.

What is humorous about the whole issue (well at least funny to those not caught up in it) is that Oracle includes the following statement on their readme for 10.2.0.4 patch.

“Patch sets are a mechanism for delivering fully tested and integrated product fixes. Patch sets provide bug fixes only; they do not include new functionality and they do not require certification on the target system.”

Guess that isn’t the case, eh Oracle?


It seems that every time we meet, I have nothing but bad news. I’m sorry about that, I surely am.

ST_Geometry Issues With Oracle 10.2.0.4

Dave Smith has been blogging about the issues with ST_Geometry on Oracle 10g.

Recently two ESRI customers have reported problems to ESRI Technical Support after upgrading to Oracle 10.2.0.4. The Oracle upgrade appears to be deleting some schema elements we require for the spatial type (ST_GEOMETRY). Uninstalling the upgrade to restore the prior version of Oracle does not work. ESRI is in contact with Oracle and we are working together to understand and quickly resolve the problem in this Oracle 10.2.0.4 patch upgrade.

It is a weird issue that came up and a problem on Oracle’s end. What is even more bizzare is that it really hasn’t gotten much play on ESRI’s Support Forums.

There is a thread in the support forums, but it really isn’t that clear to what the problem is and how to fix it (well we know there needs to be a patch, but that isn’t really spelled out on the forums).

I can only speculate that either that there aren’t many Oracle users rushing to upgrade to 10.2.0.4 or there aren’t many Oracle SDE users dealing with ST_Geometry. This is a really weird situation if you ask me if it trickles down from a regional office.


“This isn’t the support you are looking for”

ArcGIS Server and ArcSDE (and even Microsoft SQL Server 2008 Spatial)

OK, so here is what is happening at 9.3 with ArcSDE.

  1. ArcSDE finally rides into the sunset. Even though technically ArcSDE has been replaced at 9.2, it was still a separate product. Now at 9.3 it will become fully integrated into ArcGIS Server. ArcGIS Server Enterprise will be the “traditional” ArcSDE level where ArcGIS Server supports an unlimited number of users via either direct connect or connection to an application server. It offers DBMS support for IBM DB2, IBM Informix, all editions of Microsoft SQL Server, Oracle and PostgreSQL. It has no data or memory limits. The Workgroup level of ArcGIS Server supports a maximum of 10 direct connect users. It includes an embedded DBMS (Microsoft SQL Server Express Spatial). It has a data limit of 4 GB and a memory limit of 1 GB.
  2. ArcGIS will connect to Microsoft SQL Server via direct connect. Out of the box ArcGIS application will be able to connect to Microsoft SQL Server Express Spatial, but if you want unlimited users, you’ll need to purchase ArcGIS Server Enterprise. This is probably less than what folks wanted, but you’ll have to sort that our yourselves.
  3. ArcGIS supports older versions of the Geodatabase. At 9.3, ArcGIS can connect and create geodatabases (personal, file) back to 9.0. This means you won’t need to keep older versions of the geodatabase around to share with others. You also won’t have to upgrade your geodatabases just because ArcGIS went to a new release. If you wish, you can keep your older geodatabases running at whatever release you wish (back to 9.0).
  4. SQL Server 2008 Spatial will be fully supported when Microsoft releases final version of SQL Server 2008. This might mean that SQL Server 2008 support might not show up until SP1 or SP2 for 9.3. It all depends on Microsoft’s release schedule.
  5. PostgreSQL support will be available at 9.3 as has been reported. There will be support for both the PostGIS and ESRI data types.
  6. ArcGIS Engine will allow developing with Microsoft SQL Server 2008 Express so you can scale down your enterprise applications to the workgroup level. You’ll no longer be limited to working with personal for file geodatabases.
  7. ArcGIS Server Enterprise will support 64bit processors. This is only the spatial database application server and not the AGS Basic, Standard and Advanced product.

So does that answer your questions about ESRI spatial database support at 9.3?