Oracle
Analysis of software titan Oracle and its efforts in database management, analytics, and middleware. Related subjects include:
- Oracle TimesTen
- (in The Monash Report)Operational and strategic issues for Oracle
- (in Software Memories) Historical notes on Oracle
- Most of what’s written about in this blog
OS-DBMS integration
A Slashdot thread tonight on the possibility of Oracle directly supporting Linux got me thinking – integration of DBMS and OS is much more common than one might at first realize, especially least in high-end data warehousing.
Think about it.
- Mainframe DB2 has OS/DBMS integration.
- Teradata has OS/DBMS integration.
- Oracle, unlike other open system DBMS vendors, has always had a lot of careful integration with (or at least interfacing to) each individual DBMS it supports.
- Microsoft of course integrates DBMS and OS
- The data warehousing appliance vendors integrate DBMS and OS. Stuart Frost of DATallegro made some excellent, detailed comments in this thread laying out that case.
This trend isn’t quite universal, of course. Open systems DB2 and Sybase and Progress and MySQL and so on are quite OS-independent, and of course you could dispute my characterization of Oracle as being “integrated” with the underlying OS. But in performance-critical environments, DBMS are often intensely OS-aware.
And of course this dovetails with a point I noted in another thread – DBMS are (or need to become) increasingly aware of chip architecture details as well.
| Categories: Data warehouse appliances, Microsoft and SQL*Server, Oracle | 1 Comment |
Oracle, graphical data models, and RDF
I wrote recently of Cogito’s high-performance engine for modeling graphs. Oracle has taken a very different approach to the same problem, and last Monday I drove over to Burlington to be briefed on it.
Name an approach to data management, and Oracle has probably
- Hacked together a version on a consulting contract
- Packaged it up for other customers in the same industry
- Set to work on improving and generalizing it
- Integrated it into SQL as a preference over supporting standalone data manipulation languages for it
- Stopped short of being 100% competitive in that functionality
(At least, that’s the general template; truth be told, most of the important cases deviate in some way or other.)
Read more
| Categories: Oracle, RDF and graphs | 2 Comments |
IBM’s definition of native XML
IBM’s recent press release on Viper says:
Viper is expected to be the only database product able to seamlessly manage both conventional relational data and pure XML data without requiring the XML data to be reformatted or placed into a large object within the database.
That, so far as I know, is true, at least among major products.
I’m willing to apply the “native” label to Microsoft’s implementation anyway, because conceptually there’s little or no necessary performance difference between their approach and IBM’s. (Dang. I thought I posted more details on that months ago. I need to remedy the lack soon.)
As for Oracle — well, right now Oracle has a bit of a competitive problem …
| Categories: IBM and DB2, Microsoft and SQL*Server, Oracle, Structured documents | 1 Comment |
Oracle is getting touchy about XML
From Barbara Darrow’s “Unblog”:
“How we store XML on the database is, excuse me, none of your business. The point is you can write an app using XML standards,” said Mark Drake, manager of product management for XML technology for the Redwood Shores, Calif. vendor.
“Whether we shred it, parse it, it doesn’t matter. There is no such thing as a native XML storage model, there is no W3c standard or 11th stone tablet, telling us how,” he noted.
So implementation doesn’t matter? I.e., performance doesn’t matter?
That’s not generally Oracle’s viewpoint in areas where it has a performance or implementation advantage, or even parity …
| Categories: Oracle, Structured documents | 4 Comments |
MySQL disclaims interest in the ERP market
With Oracle acquiring first Innobase and now Sleepycat, MySQL has been under the gun to position itself more sharply. In response, their CEO reportedly disclaimed interest in the ERP market. That surprises me, as it contradicts what I hear from SAP, and have heard from the company in the past.
Frankly, if he even said what he’s quoted as being saying, I doubt he entirely meant it.
Anyhow, lots of MySQL reactions to the latest news may be found right on the Planet MySQL blog.
EDIT: Yeah, he didn’t mean it that way. See my Monash Report post for clarification.
| Categories: MySQL, Open source, Oracle | 1 Comment |
Tom Kyte on constraints
I’ve put up some posts slamming what I regard as an absurdly extremist pro-constraints view held by some relational advocates. But Tom Kyte offers a more nuanced view of constraints that I find extremely reasonable.
The basic idea is this. Oracle has something called “non-validated constraints” — assertions that are true about the data but not enforced by the DBMS. Putting them in the database gives valuable information — metadata — to Oracle, allowing the optimizer to work much more efficiently. And there’s no performance overhead, because the constraints aren’t actually checked at run time.
As Tom correctly points out, this story assumes that you’ve indeed done a solid job of data cleaning. If not, the non-validation of the constraints could allow the system to give a wrong answer.
Computerworld on memory-centric data management
Computerworld recently ran an excellent story on memory-centric data management. The opening sentences show that correspondent Gary Anthes most definitely “gets it”:
Relational database management systems have become all but ubiquitous in enterprise computing since 1970, when they were first devised by E.F. Codd. But as powerful and flexible as those databases are, they’ve proved inadequate for a handful of ultrademanding applications that have to process hundreds or thousands of transactions per second and never go down.
I’m quoted in one of the sidebars, but with the core article being this good I didn’t really add much.
Incidentally, the article talked a lot about Oracle’s recently acquired TimesTen in-memory DBMS product, and also a fair amount about Streambase. This is complementary to my own research, which has focused more on the other leading memory-centric data management vendors.
| Categories: Memory-centric data management, Oracle | Leave a Comment |
SAP, MaxDB, and MySQL, updated
I’ve had a chance to clarify and correct my understanding of the relationship between SAP, MaxDB, and MySQL. The story is this:
- MySQL has the right to sell MaxDB, but apparently isn’t focusing much on that.
- The MySQL and MaxDB code lines are NOT merging, for technical reasons. For example, the older MaxDB does a lot of its own thread management, while MySQL relies on the operating system for that.
- When SAP thinks a DBMS is capable of running SAP’s apps, it adds the DBMS to its product catalog and resells it. Yes, even Oracle. That’s why all my discussions with SAP of MySQL’s enterprise-readiness quickly come back to an exhaustive multi-year certification process.
- My personal best guess as to when MySQL will be in SAP’s product catalog is 1 1/2 – 3 years from now.
And by the way, MaxDB’s share in SAP’s user base is about the same as DB2’s (at least DB2 for open systems). MaxDB is being aggressively supported, and nobody should get any ideas to the contrary!
| Categories: IBM and DB2, MySQL, Open source, Oracle, SAP AG | 6 Comments |
Finally a column on XML storage
After several months of headfakes, I finally did a column on XML storage this month. There turned out to be room for application discussion, but not for much technical nitty-gritty.
The app discussion is pretty consistent with what I’d already posted here, although I wish I’d gone into more detail on the inventory database example. (Stay tuned for followup here!)
I also intend to post soon with some technical detail about how XML storage is actually handled.
I also got some good insight from Marklogic about what customers wanted in their text-centric markets. More on that soon too.
And by the way — I didn’t pick the Oracle-bashing title. I also didn’t pick the Oracle-bashing title for my Network World “Hot Seat” video. But somehow, the Oracle-doubting parts of my views are of special interest to my friends in the media. And it’s not as if the titles say anything I actually disagree with …
| Categories: OLTP, Oracle, Structured documents | 3 Comments |
Solid state (Flash) memory vs. RAM vs. disks
I just wrote a column and a blog post on the potential for diskless PCs based on flash drives. It was a fun exercise, and I think I kept it general enough that my lack of knowledge about hardware technology details didn’t lead me into significant error.
The first vendor response I got was from Bit Micro Networks, who seem to sell such drives for PCs and enterprise storage alike. One of their press releases touts an Oracle implementation. Interesting idea. It’s far from a substitute for full memory-centric data management, but it’s kind of an intermediate way of getting some of the benefits without altering your traditional software setup much at all.
| Categories: Memory-centric data management, Oracle, Solid-state memory | 1 Comment |