IBM Donates Java Database App. to Apache Foundation 261
the_pooh_experience writes "IBM has announced that it will open up Cloudscape by giving it to the Apache Software Foundation. Cloudscape, a small footprint Java database, is primarily used for small scale websites and point-of-sale systems. Its new, opensource name will be 'Derby.' Cloudscape (originally created by Informix, and purchased by IBM in 2001) has been valued by IBM at $85M."
Anybody used it? (Score:3, Interesting)
Re:Anybody used it? (Score:5, Informative)
Re:Anybody used it? (Score:5, Informative)
Switching to Oracle and SQL Server eliminated this problem entirely. In addition, performance has been increased literally ten-fold just from the switch (no changes were made to our code or schema when this performance increase was measured).
While I would recommend Cloudscape for smaller, non-critical applications, it is not ready for real-world enterprise apps. I look forward to the improvements the open source community might bring -- from a cost perspective I'd certainly like to see us switch back someday.
Regards,
Matt
Re:Anybody used it? (Score:2)
Yawn. (Score:3, Interesting)
Nice to see IBM giving to opensource, even if it is only a minor product.
Re:Yawn. (Score:2)
Re:Yawn. (Score:5, Informative)
Another interesting, open source Java database is McKoi SQL Database [mckoi.com], a GPL-licensed Java database with all kinds of nifty features.
Things are getting interesting for JBoss [jboss.org] developers: JBoss ships with HSQL, supports McKoi nicely, and now we get Cloudscape thrown into the mix. Sweet.
Re:Yawn. (Score:3, Informative)
1. Control Panel->Administrative Tools->Data Sources (ODBC)
2. Create a User- or System- level data source.
1. Add
2. Select "Microsoft Access Driver" and click Finish
3. Provide a name and use the 'Create' button to create an MDB file.
3. Connect to the ODBC database using your program of choise (Java, VB, TCL, whatever knows how to talk ODBC -- Java includes a JDBC/ODBC implementation) and creat
Re:Yawn. (Score:3, Informative)
Re:Anybody used it? (Score:2, Funny)
Come on, this was modded 'Informative'?
CloudScape (Score:3, Interesting)
Re:CloudScape (Score:3, Informative)
Actually, Cloudscape was originally created by a
company called Cloudscape & the company was
bought over by Informix. Then Informix was bought
over by IBM.
"public domain" is not the same as "open source" (Score:5, Informative)
Re:"public domain" is not the same as "open source (Score:2)
Re:"public domain" is not the same as "open source (Score:2, Interesting)
Re:"public domain" is not the same as "open source (Score:2)
Re:"public domain" is not the same as "open source (Score:4, Informative)
Re:"public domain" is not the same as "open source (Score:2, Interesting)
Re:"public domain" is not the same as "open source (Score:3, Informative)
This type of program doesn't apply at all to the Linux kernel. The GPL is strange, in that instead of signing control of a copyright to a singular entity, you keep it... but what you wrote is "free." Free as in, you can't dictate to other people what to do with your copyrighted code, with exception of enforcement of the GPL. You've agreed to allow everyone to modify it, copy it, sell it, barf on it, etc.
The Kernel does have a group of controlling entities, most obviously Linus. Then comes all of the b
Value (Score:5, Funny)
Now, it's free, so it's worthless.
Re:Value (Score:4, Insightful)
Re:Value (Score:3, Insightful)
Re:Value (Score:5, Insightful)
An $85M "asset" isn't worth much if you have to spend $16M a year maintaining and supporting it. Also, remember that IBM has several other database products this would be competing against. The fact that they released it as Open Source is a very good thing for everyone, considering that they could have just abandoned the code and kept it locked away. This way they get good publicity, reduce their maintenance costs, and get a nice tax break.
Another point that IBM really isn't in the business of selling either software or hardware anymore -- they sell SOLUTIONS. Nowadays, most of Big Blue's revenue comes from sending consultants out to tell customers what hardware and software they need to run their business, and then putting all the pieces together for them so the whole thing works. While they'd prefer to sell you IBM hardware and IBM software, they're pretty agnostic in that regard. Having their own pet OSS database allows them to offer an IBM-backed solution for lower-end projects which don't have the money for a DB2 license.
$16M to maintain? (Score:2)
MySql Competition? (Score:4, Interesting)
Is this designed to compete directly with MySql or is it like an open source version of Microsofts MSDE. Suitable for a small web app but not for hosting something like slashdot or Amazon? It's cool to see IBM once again support the OSS community.
Simon
Re:MySql Competition? (Score:5, Informative)
Most of these databases are used by "embedding" them into an application (something not uncommon in Java programming), not as a standalone database server like Oracle or Postgres. Of course, like I said, it's been a long time since I looked at Cloudscape so it could have changed to be more of a standlone server.
I'm also surprised I haven't heard more about this in Apache, but I imagine it will first go through the Apache Incubator [apache.org] to sort out any legal issues and then end up somewhere in the Apache Database [apache.org] project. If anyone has more info, I'm interested to know.
Re:MySql Competition? (Score:4, Informative)
Re:MySql Competition? (Score:5, Informative)
Anyway, personally, I see it more as a competitor to hsqldb, which is also an embedded java DBMS. Or sqlite, although the latter is written in C++. It has the potential to become popular as a DBMS embedded in applications, but I don't think it is usable as a real stand-alone DBMS, such as MySQL.
Re:MySql Competition? (Score:3, Insightful)
Re:MySql Competition? (Score:5, Funny)
You're right. After all, it performs so well for Slashdot...
Re:MySql Competition? (Score:5, Informative)
heavy transactional read loads for non-critical apps perhaps.
- Not heavy DSS/OLAP read loads though (where indexes don't work well and you want partitioning to bypass 95% of your rows). See Oracle, Informix & DB2 to see how this is done and the results it achieves.
- Haven't seen a proper benchmark but antecdotal evidence points to problems that MySQL has scaling to meet much write traffic. Postgresql, Firebird, etc on the inexpensive/free side appear to be better choices for this kinds of applications.
- Aren't online backups unavailable except through separately-licensed (and expensive) products?
- Then you've got the entire managability issue - on larger projects in which you desperately want the kind of functionality that MySQL AB has claimed that 95% of database applications don't need and which they've failed to support well: like database-enforced data quality constraints (referential, uniqueness, and check constraint declaratives). Add to that the lack of flexibility that comes from various missing features like views & stored procedures. Add to that the problems porting their non-standard SQL. Lastly, add to all of the above their massive list of exception-handling problems - in which errors silently fail.
Nah, MySQL is a nice little database. But unless 'heavy loads' means non-critical, read-only, index-oriented loads - I think that there are about a dozen better options available.
Oh yeah, and no - cloudscape isn't a competitor for mysql in general. They each bring different strengths to the table.
Re:MySql Competition? (Score:2)
(Holy crap, I'm aggreeing with an AC)
That's about what I was thinking, it looks like it's more oriented towards embedded databases, rather than client-server ones. Maybe the OP has heard of Microsoft's Jet database engine used with VB or FoxPro? A very nice combo for storing a small data set in a regular fashion. SQLite is very handy also, in the open-source world. Actually, isn't SQLite in the public domain? Good stuff.
I think it may be possible to use MySQL for a heavier embedded database... henc
Re:MySql Competition? (Score:2, Funny)
Tax Reduction? (Score:3, Insightful)
Compared to the alternative of supporting or shelving a dead application, can you blame them? Perhaps at least this will serve as a good model for other companies that still consider dead software as a corporate asset.
Re:Tax Reduction? (Score:4, Informative)
Re:Tax Reduction? (Score:3, Informative)
Re:Tax Reduction? (Score:5, Interesting)
Re: (Score:2)
Re:Can I do that as well? (Score:2)
Competition, not Tax (Score:3, Insightful)
Re:Tax Reduction? (Score:4, Informative)
Lotus say that the Notes client will 'converge' with the Workplace client in the version 8 release timeframe so that'll put an eclipse runtime and cloudscape DB on most every corporate Notes desktop in the next 2-3 years.
What you're seeing is IBM seeding the developer marketplace with technology (Eclipse, Cloudscape) in order to reap dividends in the form of an established base of technologists familiar with the underpinnings of their commercial products.
You getting the picture?
Re:IBM Services (Score:2)
Foot in the door? (Score:5, Insightful)
In any case it's cool they donated it. Being a database developer myself, I'm extremely wary of the "you don't need a DBA" claim, but regardless of the hype it looks like an interesting product that will fit in well with the Apache lineup.
Re:Foot in the door? (Score:5, Interesting)
I've never used Cloudscape, but coming from its Informix roots I trust this - to a certain extent, of course. If you never used Informix, it absolutely rocked in terms of stability and ease of maintenance. We had one Informix DBA for every 100 or so installed machines (with many installed instances per machine) for product support at my last company. It never got the press that Oracle did: they made the classic (beta, Xerox, TI,
So since this was their most "simple" database, I have some pretty good feelings about it. One thing that would be interesting is that this will open up the code to their SQL optimizer. That's one area where Informix always truly rocked compared to pretty much everyone else outside of a lab situation. I don't know how much of it got into Cloudscape, of course.
Not really Informix (Score:4, Informative)
Cloudscape has a relatively small market share among SQL databases, but it is popular in certain niches. It came bundled with Sun's reference implementation of J2EE at one time, too; I don't know if that's still the case.
NYT (Score:5, Insightful)
I wish people would stop mixing these things with public domain. Apache's license, GPL, etc., are forms of copyright, and are NOT public domain.
Re:NYT (Score:5, Insightful)
While many at Slashdot have caught this mistake, relatively few at the New York Times are likely to.
Instead of/in addition to posting about the error here, why not send off a note to the Times to let them know about the important flaw in their coverage of this story?
If there is one observation that can be made about the surging popularity of blogs in the past few years, it's that Media is able to function better when it gets feedback from its readers.
Re:NYT (Score:3, Funny)
I guess that I never thought I'd take software licensing so seriously.
Don't worry. The response was informative and well-mannered (for coming from an opensource zealot).
More techincal background (Score:5, Informative)
The Cloudscape homepage: Cloudscape [ibm.com]
And more details with links to PDF documents: Features and Benefits [ibm.com]
I would guess that mysql would be faster for simple stuff, but Cloudscape could give it a run for it's money with support for more complex SQL.
Wouldn't know how it compares agains postgresql...
Re:More techincal background (Score:3, Informative)
- store serializable java objects in table fields
- java stored procedures, functions, triggers
- hash joins in addition to nested loops
- subqueries and views
- transactions, four isolation levels
- row and table level locking (default = row)
- deadlock detection
- custom aggregators
- blob and clob data types
- cost based query plan optimizer
- multicolumn B-tree indexes
- query and lock built-in performance monitoring
To me, this feature set seems superior to MySQL.
Registration Required Link (Score:2, Funny)
Mckoi (Score:3, Interesting)
There are other DBs written in Java , for example Mckoi SQL [mckoi.com].
Mckoi SQL is quite usable, supports a great deal of the SQL 92 standard, and the performance is not bad (of course, talking about the range of database sizes for which it makes sense using an embedded sql engine
Does anyone have experience with Couldscape. How does it compare with Mckoi?
Re:Mckoi (Score:2)
Well, first of all, Cloudscape has a prettier-sounding name than Mckoi, which will appeal to pointy-haired bosses everywhere...
Comparisons? (Score:2)
Re:Comparisons? (Score:3, Informative)
Finally, that MS crap is still beta software whereas Cloudscape is well tested, enterprise ready code.
Performance (Score:5, Interesting)
Firebird SQL was about the same. Next Im going to try HSQL.
I would be interested in anybody elses experiments?
Re:Performance (Score:3, Insightful)
I don't think that's a very good test.
In real life, you either add an index, or you don't query a non-index unique field on a 50+ million table.
I'd think some sort of inner query is a better test for this.
Re:Performance (Score:2)
Seems like a simplistic attempt to compare raw i/o as it's just comparing simple table scans.
Not a bad approach for a simple comparison at this level.
CloudScape is primarily used in websphere (Score:2, Insightful)
Re:CloudScape is primarily used in websphere (Score:2, Insightful)
Embedded databases are very useful for applications that are intended for a small number of users or a small database (just look at Microsoft's Jet Engine as an example, that is used all over the place). There are many instances where you want t
Re:CloudScape is primarily used in websphere (Score:2)
One use could be a local backup DB for a remote client application. When your net connection goes down, just perform all the changes locally and then synch up with the remote DB when your connection comes back up.
503 Service Unavailable (Score:4, Funny)
Maybe slashdot can used it to stop the 503 errors
Re:503 Service Unavailable (Score:5, Informative)
Regards,
Steve
P.S. Anyone know what the hell is going on over at Slashdot HQ?
503 Theories (Score:3, Informative)
See this thread [slashdot.org] for wild speculation. Short version: there was a change to Slashcode that included making all of Slashdot available as a single RSS feed (rather than one feed per section as used to be the case), and on the hour RSS aggregators hit this single feed and somehow cause a 503 for logged in users.
Wild speculation, remember. Any actual solid info appreciated.
Kinda similar to Berkeley DB for Java... (Score:4, Insightful)
Re:Kinda similar to Berkeley DB for Java... (Score:2, Informative)
Wake me up when there's an SQL interface to DB.
Re:Kinda similar to Berkeley DB for Java... (Score:3, Informative)
Wake up! mySQL is a SQL interface on top of Berkeley DB [mysql.com].
However I agree the grandparent post is wrong in comparing BDB to Cloudscape.
"Open Source Name"? (Score:5, Funny)
Anyway - why bother renaming and what is "Open Source Name"?
Re:"Open Source Name"? (Score:4, Interesting)
Re:"Open Source Name"? (Score:2)
Your Open Source Name is Pinto.
Why Pinto?
Why not!?!!
Correction (Score:5, Informative)
At the time, it was a fairly complete and well-performing database with some nifty multi-database synchronization features, so even though I'm not involved in Java programming anymore this can turn out to be a quite interesting addition to Joe. A. Opensourcecoder's toolkit.
Now if IBM wants to get really nasty with Sun..... (Score:3, Insightful)
Re:Now if IBM wants to get really nasty with Sun.. (Score:2)
IBM signed a contract with Sun and is sharing code with Sun (For example, the licence states that Sun gets to use VM enhancements from other vendors..hence them getting the VM sharing that Apple made)
My bet is that Sun would drag them into court by their balls and win.
Since IBM did pledge support to open source Java and if they owned their own VM, what would be stopping them?
Right..
What would be good.... (Score:3, Informative)
Re:What would be good.... (Score:2, Informative)
Re:What would be good.... (Score:2)
What about Cirrus ... ? (Score:2, Interesting)
(MS Access' project name was originally Cirrus)
Apache Corporation? (Score:5, Informative)
Funny how the word Apache in the article is linked to the stock ticker for APA. (Or may be not so funny) For the record - The Apache Software Foundation is a registered non-for-profit 501 c3 corporation incorporated in Delaware, and as such it does not have stock but rather can hand out membership to make one a stakeholder.
An opensource alternative to Pointbase (Score:2, Insightful)
Opens Souce business model (Score:2)
Re:Open Source business model (Score:2)
Seriously though, does anyone know how IBM arrived at that figure? My gut feeling is that some middle manager just pulled it out of his ass, but I'd like to hear how exactly it was just
Ownership in Question (Score:2, Funny)
Any moment now, I'm sure we'll hear how SCO (through an ownership rationalization chain that will make Rube Goldberg pack his bags and head to the nether regions of shame) actually owns this (without having actually coded a bloody thing) and that IBM has no rights to give away anything it developed.
Save yourself the grief, expense, and the ensuing barrage of Slashdot rants about SCO! Just say 'NO'.
Naming? (Score:2)
Re:Naming? (Score:2)
Look for another product under that name in about 4-5 years.
Chip H.
Two other news sources without registration. (Score:2)
= 9J =
Adabas anyone? (Score:2)
Standards Compliant - Lower TCO (Score:2, Interesting)
Those who administer J2EE applications resist new databases. Having an embedded one like this is a selling point since it leads to lower maintenance costs. Maybe.
Small Footprint -- Really? (Score:2)
And just how does .5M lines of Java code translate to "small"?
Or is this a new usage of the word "small" of which I was not previously familiar?
Access Killer? (Score:4, Insightful)
I know it's a different language, but work with me for a second.
Yes, Access sucks as a DB, but it's good for three things. First, it's a quick and dirty way to store data. Secretaries and analysts use it, dump their data in a little file, put it on a floppy, bring it home, work on stuff at home, and bring it back on a floppy the next day. That is the ultimate selling point of file based databases. Even with Open Office's database tools, I have to know something about being a DBA - starting mysqld, db security, etc. Second, our DBAs love it because it's a graphical frontend to ODBC datbases. It gives semi-cluefull non-techs a way to see data. Finally, you can actually drop it onto a webserver and drive databases with it. Biases aside, it did gather them a following in the late 90's when everybody was a "developer" doing websites.
Any sort of MSOffice competitors have taken a while to solve these three needs elegantly. Looking at the IBM site, it looks like Cloudscape, with the embeded and network connectivity features, can be a foundation for something that can fill all three needs.
IBM vs. Sun (Score:3, Insightful)
Re:Database written in Java? (Score:2, Funny)
Well, I hate to be the one to break it to you...
Re:Database written in Java? (Score:5, Insightful)
On the other hand, it's still a (relative) memory hog.
Re:Database written in Java? (Score:5, Informative)
Re:Database written in Java? (Score:5, Interesting)
* Most web applications are not written in C++/C
* More and more client-applications are being written in Java/.Net due to maintainability
* There is an impedance mismatch between OO systems and RDBMS systems
** Bridging this gap often involves very non-performant abstractions:
*** wrapping bean-objects around rows
*** storing intermediate copies of beans for caching
*** making copies of beans for transactional purposes.
*** redundantly applying data-constraint rules
Essentially re-inventing the RDBMS wheel.
Thus, if you're already going to write the application in Java, then there is a tremendous advantage to avoiding the performance bottlenecks of the impedance mismatch.
Think of what a c/c++ database does in the best case.. It compiles a SQL script, loads internal relationships to columns/rows.. Accesses the in-memory indexes, and then formats/serializes the in-memory rows for output.
Java has to deserialize the text-stream, instantiate numerous objects; possibly unicodifying the data. Then whatever abstraction layers may be applied to the raw object-array result-set have to be applied.
If the data was locally available, then it could be stored in such a way that, for read-only access, it might be possible to avoid copying, and merely have it return a wrapper for the raw data. Zero latency, and practically zero additional extra work. While this is effectively the same as cached data, here we only store the data once on disk and once in memory.
"hsqldb" is an example that pretty much does the above. You still get a SQL interface if you desire though. Only catch is that hsqldb isn't as feature-rich as many RDBMS systems yet. I'm sure the IBM java-database is merely a feature-rich sister of hsqldb.
And don't forget that many java API's still use raw c-code to do intensive or tight-data-structure work.
Re:Database written in Java? (Score:2)
Even with AWT/Swing, graphics is so sensitive to bandwidth of the graphics chip that tru
Re:Database written in Java? (Score:2)
OpenGL is an API, but the hardware OpenGL drivers are just as much implementations as is Mesa (NVIDIAs Linux/X driver for instance). Mesa can also be hardware accelerated, IIRC. I think it has a DRI interface.
-- just like the AWT.
Nope, AWT (like SWT) uses native peers. You're thinking of Swing/JFC, where everything is
Re:Database written in Java? (Score:5, Informative)
Regards,
Steve
Re:503 : DELETE YOUR COOKIE (Score:2)
As for the 503s - Glad to see that I was not the only one getting them. Like you, I initially saw them in Firefox only. Then, when I switched to IE, it, too, started exhibiting the same problem. For a while I thought work was blocking me from reaching
Re:Hsql (Score:3, Informative)
The biggest problem we have had with it is that the only transaction level it supports in READ_UNCOMITTED, and that it doesn't support multiple parallel queries.
Re:From the features page... (Score:2, Informative)