Slashdot Mirror


IBM Donates Java Database App. to Apache Foundation

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."

80 of 261 comments (clear)

  1. Anybody used it? by btrapp · · Score: 3, Interesting

    Can anyone comment on how it performs?

    1. Re:Anybody used it? by mauryisland · · Score: 5, Informative

      I've been using Cloudscape 4.0 in a web environment for a couple of years now, with no database failures of any sort. Cloudscape has a good selection of utilities (bulk loader, CLI and GUI, etc.) It's picky about ANSI SQL, and it supports most of the SQL that I'm interested in, like nested queries, stored procedures, etc. I'm using it as an imbedded database (just presenting data, not writing anything while in production), so I can't speak to the speed in an OLTP environment, but for my purposes, I'm absolutely delighted with it.

    2. Re:Anybody used it? by Brando_Calrisean · · Score: 2, Funny

      Just like my Honda Civic is no match for a Formula 1 Racecar, right?

      Come on, this was modded 'Informative'?

      --
      Don't call me a cowboy, and don't tell me to slow down!
    3. Re:Anybody used it? by Anonymous Coward · · Score: 5, Informative

      We are a successful enterprise software ASP and used Cloudscape during our first 1.5 years before switching to a more robust database. Cloudscape powered our applications for 40+ customers globally. While it performed well given its small footprint, a huge problem for us was the fact that it does not release unused space -- the only way to do this is to run COMPRESS. With growing transaction volume we began running into random database balooning problems where the size of Cloudscape grew from 100MB up to 30 or 40GB depending on how long it was running. The fix required a COMPRESS command which takes anywhere from 1 to 48 hours depending on the size of the database and the amount of physical memory available.

      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

  2. CloudScape by TheToon · · Score: 3, Interesting

    Good! This is quite a nifty little SQL engine with a lot of features. Will be exciting to follow the progress of Derby, could provide competition for mysql and postgresql.

    --
    //TheToon
    1. Re:CloudScape by Anonymous Coward · · Score: 3, Informative

      Cloudscape (originally created by Informix, and purchased by IBM in 2001) has been valued by IBM at $85M.

      Actually, Cloudscape was originally created by a
      company called Cloudscape & the company was
      bought over by Informix. Then Informix was bought
      over by IBM.

  3. "public domain" is not the same as "open source" by samuel4242 · · Score: 5, Informative

    Geez is the NYT dumb. Putting something in the "public domain" means you relinguish control. It's owned equally by everyone. Choosing an "open source" license means you keep control. If you're careful about how you do it, you can even change the license terms a bit later. MySQL is constantly tweaking their terms because they're the sole copyright owner. Sure, it's available under the GPL, but they can tweak the terms for preferred customers. And they do! That's still their perogative because the code is NOT in the public domain.

  4. Value by Anonymous Coward · · Score: 5, Funny

    "...has been valued by IBM at $85M."

    Now, it's free, so it's worthless.

    1. Re:Value by NETHED · · Score: 3, Insightful

      Not true. I'm sure this can be written off as a tax deduction. Something akin to a donation.

      --
      --sig fault--
    2. Re:Value by Tassach · · Score: 5, Insightful
      It may well be worth $85M, but how much would it cost IBM to maintain it? Besides, it would only be worth that much if they could find a buyer, and it's pretty unlikely that they'd find someone to buy it at that price.

      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.

      --
      Why is it that the proponents of "one nation under God" are so eager to get rid of "liberty and justice for all"?
    3. Re:Value by jrumney · · Score: 2, Insightful

      I know from when I used to work for the R&D arm of a large multinational, that patents donated into the public domain can definitely be written off against tax in the US, so I wouldn't be surprised if copyrights could too, and if donating them to a non-profit that kept them for the public good was treated the same as public domain for tax purposes. I don't see any other reason for IBM to put a value on Cloudscape right before they give it away.

  5. MySql Competition? by Ckwop · · Score: 3, 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

    1. Re:MySql Competition? by jaaron · · Score: 5, Informative

      While I haven't used Cloudscape in a very long time, I imagine this is more competition to other Java open source databases like HSQL, Axion, or McKoi.

      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 to sort out any legal issues and then end up somewhere in the Apache Database project. If anyone has more info, I'm interested to know.

      --
      Who said Freedom was Fair?
    2. Re:MySql Competition? by Anonymous Coward · · Score: 5, Informative

      I think that Slashdot runs MySQL. So saying that MySQL cannot run big webapps is a bit of an underestimation :-)

      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.

    3. Re:MySql Competition? by jusdisgi · · Score: 2, Insightful

      You could have also said Google. But I concur...MySQL is definitely ready for heavy loads.

      --
      Given a choice between free speech and free beer, most people will take the beer.
    4. Re:MySql Competition? by NineNine · · Score: 5, Funny

      MySQL is definitely ready for heavy loads

      You're right. After all, it performs so well for Slashdot...

    5. Re:MySql Competition? by Anonymous Coward · · Score: 2, Funny

      Rather than MSDE, wouldn't it be more of a hit against Microsoft's SQL Server 2005 Express that they released to beta a month or so ago..... ;)

    6. Re:MySql Competition? by Frums · · Score: 3, Informative

      Remember the "NDA Submission" discussion in the incubator recently which ended in a "handle it vase by case"? This is why. Target is the db project, and has been voted to be accepted there, so once it satisfies incubator, wheee =) -BrianM

    7. Re:MySql Competition? by kpharmer · · Score: 4, Informative

      > MySQL is definitely ready for heavy loads

      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.

    8. Re:MySql Competition? by BarryNorton · · Score: 2, Interesting

      If you move from a toy to its real counterpart, though, you expect it to have at least the same capabilities.

      If you play with a toy fire engine and someone tries to persuade you of the benefits of a 'fire engine' without a siren, hose or ladder, you're hopefully in a place to tell them that that's not the tool for the job.

      I appreciate and support OSS, but I hope my students would not pick MySQL over Oracle without a lot of thought (and about more issues than licensing cost and politics)...

  6. Tax Reduction? by Lust · · Score: 3, Insightful

    A win-win scenario for IBM: donate a software application at an inflated price for a big tax break while also looking good to the open-source community. At least that's how I assume it works in the US.

    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.

    1. Re:Tax Reduction? by Grullie · · Score: 4, Informative

      Cloudscape is hardly dead - it shows up prominently in Websphere Application Developer as the default embedded DB for EJB data. It feels a lot like MS Access - simple, quick, and dirty.

    2. Re:Tax Reduction? by jusdisgi · · Score: 2, Informative

      That's precisely the way I read it...they don't see a need for this in their 'for money' software portfolio. Kept proprietary, there isn't really any way it would be profitable; this isn't something they can sell as a product...they might be able to embed it in hardware sales, but they can still do that. So, they just farm it out to the "free geek labor" and forget about it. It still has all the utility for them it did before, now they don't have to pay development costs, and furthermore they can write it off on both their balance sheet and their taxes. And the price they get to write off? Astronomical.

      --
      Given a choice between free speech and free beer, most people will take the beer.
    3. Re:Tax Reduction? by michaelggreer · · Score: 4, Interesting

      I guess I don't see any problem with the fact that they benefit from this decision, nor am I surprised. The most powerful argument for open source is not a political one, but a business one: cheaper, more secure, fewer bugs. Since IBM has moved its business into service, open-sourcing their tools makes good sense. And, they only get "free geek labor" if the tool is actually useful to people, in which case its a win-win.

    4. Re:Tax Reduction? by Anonymous Coward · · Score: 4, Informative

      It's hardly a dead technology. Cloudscape is to be used as the local data store in the next generation of IBMs messaging products (e.g. Workplace which is built on eclipse RCP - see www.lotus.com)

      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?

  7. Foot in the door? by frostman · · Score: 5, Insightful
    I had a look at the IBM product page and found this:


    Supports complex SQL, transactions and JDBC so that your applications can be migrated to DB2 UDB when they need to grow.
    ...which makes me wonder whether this is part of a strategy to get the foundation and community to do the work maintaining something that may not have been profitable but was something their service division could get people using as a baby step towards DB2.

    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.
    --

    This Like That - fun with words!

    1. Re:Foot in the door? by rjstanford · · Score: 5, Interesting

      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.

      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, ...) mistake of assuming that just because they were technically superior that people would just flock to them. That, and you don't get the Informix consultants recommending the product like you do with Oracle - mainly because you don't need 'em around. 95% of the standard "Oracle add-on" products and services were either built in or not needed.

      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.

      --
      You're special forces then? That's great! I just love your olympics!
  8. NYT by 13Echo · · Score: 4, Insightful

    Leave it to NYT to misinform people. The article says that IBM put the code "in the public domain". The license by which the Apache foundation will distribute this is certainly NOT public domain. It later says "Apache will hold the licensing and intellectual property rights to the Cloudscape code."

    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.

    1. Re:NYT by poot_rootbeer · · Score: 4, Insightful

      Leave it to NYT to misinform people. The article says that IBM put the code "in the public domain".

      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.

    2. Re:NYT by 13Echo · · Score: 2, Funny

      Heh. I already did. It then dawned on me after I sent it that I must actually be one of those "opensource zealots" that everyone talks about.

      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). ;)

  9. Re:Database written in Java? by Anonymous Coward · · Score: 2, Funny

    I don't want to be a Java troll or anything

    Well, I hate to be the one to break it to you...

  10. More techincal background by TheToon · · Score: 5, Informative

    The Cloudscape homepage: Cloudscape
    And more details with links to PDF documents: Features and Benefits

    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...

    --
    //TheToon
    1. Re:More techincal background by bwt · · Score: 2, Informative

      I was rather impressed with Cloudscapes features:
      - 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.

  11. Registration Required Link by Patrick+Lewis · · Score: 2, Funny

    Here is the registration required link. Don't even think you can pull that "parnter=rssuserland" crap around here, buddy.

    --
    "If I am such a genius, how come that I am drunk and lost in the desert with a bullet in my ass?" --Otto (Malcom ITM)
  12. Re:"public domain" is not the same as "open source by jusdisgi · · Score: 3, Informative

    Nope...they won't put anything in without you signing the copyright over.

    --
    Given a choice between free speech and free beer, most people will take the beer.
  13. Mckoi by Guillermito · · Score: 3, Interesting

    There are other DBs written in Java , for example Mckoi SQL .

    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?

  14. Performance by DuncanE · · Score: 5, Interesting

    Not really sure how it compares to mySql or postgres, but I loaded a 50+ million row table with a non index timestamp field to Cloudscape and MSSQL. Both took about 3 seconds to return a query returning a unique row (ie a row updated on a specific date and time) on this field on a 2ghz intel machine with 1GB RAM.

    Firebird SQL was about the same. Next Im going to try HSQL.

    I would be interested in anybody elses experiments?

    1. Re:Performance by johnnliu · · 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.

  15. Re:Database written in Java? by the+quick+brown+fox · · Score: 4, Insightful
    I'm pretty sure databases spend a lot more time I/O and network bound than CPU bound. Besides, Java is pretty fast these days.

    On the other hand, it's still a (relative) memory hog.

  16. Re:"public domain" is not the same as "open source by samuel4242 · · Score: 2, Interesting

    Yes, I think this has some value for such a monolythic project as MySQL. Plus, it's clear that such a program would have made life a bit easier for the Linux kernel team after the appearance of SCO. I don't know about most contributors, but I'm more interested in getting a working tool than keeping copyright of some snippet of code. So it doesn't bother me much.

  17. CloudScape is primarily used in websphere by castlec · · Score: 2, Insightful

    Maybe it's just me, but I believe cloudscape is primarily used inside Websphere to ease development of ejbs by making the database local. I can't see it being incredibly useful outside of that... only as development, not as anything deployed. i could be wrong....

    --
    When I tell an object to delete this, am I killing it or telling it to kill me?
    1. Re:CloudScape is primarily used in websphere by Luminari · · Score: 2, Insightful

      Maybe it's just me, but I believe cloudscape is primarily used inside Websphere to ease development of ejbs by making the database local. I can't see it being incredibly useful outside of that... only as development, not as anything deployed. i could be wrong....

      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 the use of a database for a stand-alone application, but don't want to have to install a stand alone database. Imaging creating a CD-Catalog program and telling the user they have to download mysql just to use it. With cloudscape (or any of the other embedded databases) you don't have to do that.

  18. 503 Service Unavailable by stavrosfil · · Score: 4, Funny

    Great!!!

    Maybe slashdot can used it to stop the 503 errors :)

    1. Re:503 Service Unavailable by LnxAddct · · Score: 5, Informative

      Just remove your slashdot cookies and all is well again... go figure.
      Regards,
      Steve

      P.S. Anyone know what the hell is going on over at Slashdot HQ?

  19. Kinda similar to Berkeley DB for Java... by CitizenDan · · Score: 4, Insightful

    Of anything out there I think Cloudscape is most similar to Berkeley DB for Java (an in-process DB). The comment about it being a stepping-stone to DB2 could be made about any JDBC-compliant DBMS...IBM just happens to favor theirs ;-)

    1. Re:Kinda similar to Berkeley DB for Java... by Ragica · · Score: 2, Informative
      Does anyone who voted the parent insightful have even the slightest clue as to what "SQL" means.

      Wake me up when there's an SQL interface to DB.

    2. Re:Kinda similar to Berkeley DB for Java... by MyHair · · Score: 2, Informative

      Wake me up when there's an SQL interface to DB.

      Wake up! mySQL is a SQL interface on top of Berkeley DB.

      However I agree the grandparent post is wrong in comparing BDB to Cloudscape.

  20. "Open Source Name"? by ceeam · · Score: 4, Funny

    Good thing it's Derby and not Firebird.

    Anyway - why bother renaming and what is "Open Source Name"?

    1. Re:"Open Source Name"? by Anonymous Coward · · Score: 4, Interesting

      Renaming is good for differentiating the products. One has a comercial license and the other is free. The first probably provides some kind of support or other benefits not included in the free-licensed one. By renaming it the previous owners avoid problems. For example someone could claim that he was misslead to believe that he was using the "old-licensed" product and can claim damages or support or something similar. Whith totaly different names there is no serious way this can be claimed.

  21. Correction by cdegroot · · Score: 5, Informative

    Cloudscape was originally crated by Cloudscape, Inc. (I contracted for them at one time), which was later acquired by Informix.

    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.

  22. Yawn. by SatanicPuppy · · Score: 2, Interesting

    I can't count the number of times I've needed a silly ass database app to store a tiny amount of needed data on a site that has no other need for databases. These things are useful in their own right, because you don't want to HAVE to set up Oracle or DB2 when all you need is this.

    Nice to see IBM giving to opensource, even if it is only a minor product.

    --
    ad logicam Claiming a proposition is false because it was presented as the conclusion of a fallacious argument.
    1. Re:Yawn. by MORTAR_COMBAT! · · Score: 4, Informative
      Another fast, small Java database is Hypersonic SQL.

      hsqldb is a relational database engine written in Java, with a JDBC driver, supporting a rich subset of ANSI-92 SQL (BNF tree format). It offers a small (less than 160k), fast database engine which offers both in memory and disk based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets) and a number of demonstration examples.


      Another interesting, open source Java database is McKoi SQL Database, a GPL-licensed Java database with all kinds of nifty features.

      Mckoi SQL Database is an SQL (Structured Query Language) Database management system written for the JavaTM platform. Mckoi SQL Database is optimized to run as a client/server database server for multiple clients, however it can also be embedded in an application as a stand-alone database. It is highly multi-threaded and features an extendable object-oriented engine.


      Things are getting interesting for JBoss developers: JBoss ships with HSQL, supports McKoi nicely, and now we get Cloudscape thrown into the mix. Sweet.
      --
      MORTAR COMBAT!
    2. Re:Yawn. by MORTAR_COMBAT! · · Score: 2, Informative

      fyi, you can use MS Access as an ODBC database without actually installing (or owning) Microsoft Access.

      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 create tables, enter data, etc.

      This of course works only on Windows. If you're trying to provide a cross-platform tool with a DB, use something like HSQL (if you are programming in Java), or SQLite, Berkeley DB, etc.

      Using PHP 5 as a development language, you would gain built-in access to SQLite and Berkeley DB anyway, I'm pretty sure Perl has all kinds of database stuff, and TCL definitely can talk to Berkeley DB (most of my toy cross-platform projects that need a DB are TCL/Tk and Berkeley DB).

      --
      MORTAR COMBAT!
    3. Re:Yawn. by afidel · · Score: 2, Informative

      Dear god don't use Access for anything. At the very least use JET, or preferably use the freely downloadable and redistributable MS Data Engine, it's basically SQL Server Lite.

      --
      There are 4 boxes to use in the defense of liberty: soap, ballot, jury, ammo. Use in that order. Starting now.
  23. Now if IBM wants to get really nasty with Sun..... by ShatteredDream · · Score: 2, Insightful

    They should donate their JVM to the Mozilla Foundation. Having a high quality, open source JVM would further undermine Sun's position in the Java market AND it would create a buffer against Microsoft's .NET. However, I don't think it would do much good against those that want to build on Mono.

  24. Re:Database written in Java? by Tassach · · Score: 5, Informative
    Java's reputation for slowness is based on a few factors, none of which is applicable here:
    1. The GUI, partiuarly AWT, is horribly slow. This is unavoidable because there's no good (fast) way to do platform-independent graphics. However, since a database engine has no GUI components, this won't be a factor.
    2. A lot of the perceived slowness of Java comes from the time it takes to load and initialize the JVM. This is a factor when launching a desktop app written in Java. However, since a db engine is a long-running (daemon) process, this is also not applicable in this case.
    3. Early JVMs, particuarly before JIT (just-in-time compilation) took off, were indeed slow. Modern JVMs with JIT, once loaded, run (non-gui) Java code at a speed comperable to compiled C++. This is just 8 year old FUD that needs to die.
    4. A database is almost never CPU bound. The very nature of databases causes them to be I/O bound -- I/O bandwidth (especially disk throughput) is almost always the limiting factor in database performance. Modern CPUs are so vastly over-powered for database work that even if it took twice as many cpu cycles to run the Java code as it would to run comperable C++ code, you'd still only be using a small fraction of the available CPU cycles. Excessive CPU consumption in a database is almost invaribly caused by user error -- poor schema design, missing indexes, poor SQL coding, etc.
    --
    Why is it that the proponents of "one nation under God" are so eager to get rid of "liberty and justice for all"?
  25. Re:Database written in Java? by LnxAddct · · Score: 5, Informative

    You obviously haven't used java within the past 3 years or so.... Its speed on every platform I've developed on is no different then native speed, and in many scenarios its faster because of the many optimizations that java makes to your code and also from years of optimizing their own algorithms. This could be debated well... forever, but anymore if you need something faster then java then you should probably be using assembly. Speed and overall performance has only gotten better with the new 1.5 VM as well (It's now known as 5.0, and its still in beta but very useable).
    Regards,
    Steve

  26. What would be good.... by Phill+Hugo · · Score: 2, Informative

    If someone could develop and release an Open Source / Free Software Java Object Database that can house live java objects and provide searching and modification on these objects. Zope built atop Python provides just this for Python users and is used to good sucess on many web sites (Zope provides through the web editing of Python/Zope objects and has a very nice search interface for finding that object you require). Everything in Zope is a Python object and is stored in a fast, low resource object datbase - this includes all your web site and the methods to run on them. Its great, free and fast and is available from www.zope.org.

    1. Re:What would be good.... by MemoryDragon · · Score: 2, Informative

      Ok giving that I havent used OODBs in years. There used to be a OODB standard, the ODMG standard for java. Believe me the standard was disastrous. Missing standardization left and right, no conrol over the object scope, now handling of mass data on a sane level, the OQL was not really good for real world purposes etc... There were implementations of this standard, but you ended up always with code only geared to one OODB. Most java programs nowadays use OODB-RDB mappers, I assume Zope does the same. There are excellent ones, like Hibernate (which basically solves every problem the ODMG back than didnt) give one of these a try. Sun also comes out with something, done by former ODMG people, JDO, I dont know how this one stacks up to Hibernate, but I assume there arent too many mappers which come close to it or can surpass it. The third one I know is Torque from the Apache Projekt, mediocre at its best. The EJB also do this to a certain degree because part of their layer is direct object database mapping, but in my opinion they are total overkill.

  27. Re:Comparisons? by bheerssen · · Score: 2, Informative

    First off, Cloudscape runs on nearly every system in current use. MS SQL Express requires Windows (2000 or XP). It also requires a fairly beefy sytem for a light database. Check out the system requirements. Note that specialized MS platforms, such as MS Windows 2000 Datacenter Server (of all things) are not supported.

    Finally, that MS crap is still beta software whereas Cloudscape is well tested, enterprise ready code.

    --
    (Score: -1, Stupid)
  28. What about Cirrus ... ? by kabz · · Score: 2, Interesting

    Let's hope Microsoft haven't patented naming database software after clouds !!

    (MS Access' project name was originally Cirrus)

    --
    -- "It's not stalking if you're married!" My Wife.
  29. Apache Corporation? by gtrubetskoy · · Score: 4, 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.

  30. An opensource alternative to Pointbase by Anonymous Coward · · Score: 2, Insightful

    This product does not compete against MySQL. It competes with HSQL, Pointbase, JDataStore, and any other pure Java database solution. It can be used with Java Webstart, to distribute a configuration free local database with your Java applications. I think this can also be used with Java Enabled Phones, and PDA's.

  31. Re:"public domain" is not the same as "open source by jonathanduty · · Score: 2, Interesting

    That seems strange to me since everything at Jakarta is under the "Apache License". I wonder if this is a mis-print or will jakarta really host a project that is not under their license?

  32. Competition, not Tax by SparklesMalone · · Score: 2, Insightful

    Both IBM and the analyst mentioned in the article say this is about competition; undermine MS SQL Server while boosting Websphere. If some small-scale apps are developed in Cloudscape/Java instead of .NET then when/if those apps grow up the natural evolution would be to migrate to DB/2 & Websphere. And maybe it isn't even about making more profit on Websphere but just slowing the penetration of MS into the back office.

  33. Ownership in Question by Bob(TM) · · Score: 2, Funny

    Don't touch it with a 10 foot pole - it is most likely tainted!

    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'.

    --

    The little guy just ain't getting it, is he?
  34. Re:Hsql by lokedhs · · Score: 2, Informative
    We use Hsql, and it is indeed turly a good database. The greatest trength lies it its speed. It's incredibly fast as long as the database is small enough (so that it holds everything in ram).

    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.

  35. Re:From the features page... by cching · · Score: 2, Informative

    Unfortunately (depending on your point of view), SQLite doesn't have java bindings (that I know of). If someone does know of java bindings for SQLite, I'd be interested!

  36. Re:Database written in Java? by maraist · · Score: 4, Interesting

    Add to this some context.
    * 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.

    --
    -Michael
  37. Standards Compliant - Lower TCO by WamBamBoozle · · Score: 2, Interesting

    I ported a CloudScape DDL to Oracle once upon a time. Since CloudScape is so standards compliant it was very easy.

    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.

  38. Re:"public domain" is not the same as "open source by Slime-dogg · · Score: 2, 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 branch maintainers. Other than that, the "official" linux branches don't get modified without their approval.

    The appearance of SCO would have affected Linux regardless of what license they are using. If IBM signed over the copyright to Linus, then SCO would still sue them. If someone decided to sign over copyrighted code written by me to someone else, I'd probably be upset too. Then again, SCO doesn't own any of the code that was placed into Linux, so the point is moot.

    --
    You need to restart your computer. Hold down the Power button for several seconds or press the Restart button.
  39. Access Killer? by Snap+E+Tom · · Score: 4, Insightful

    The main thing I've felt that has been holding Star/Open office back is a need of a database as easy as MS Access.

    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.

  40. Re:Can I do that as well? by aoteoroa · · Score: 2, Informative
    1. Write any code
    2. Put extreme high price on code
    3. Give code away
    4. Profit!!
    Or am I missing something?

    Yup. You're missing the fact that that IBM didn't write the code. Cloudscape wrote the code. Informix bought it, and then IBM bought Informix.

    The $85 million price tag is not an abitrary figure but is the actual cost of the code when it was purchased in 1999.

  41. IBM vs. Sun by _randy_64 · · Score: 3, Insightful

    Notice how IBM is responding to competition by offering something to the community, while Sun's response to competition is to take something away (Novell/SUSE). I know, I know, it's GPL, they can't really take it away, but I think the point is still valid. Sun's response to competition should be to GPL Solaris and/or Java, not try to lock things up. Rather than try to improve themselves, stupid Sun's trying to compete by trying to hurt the competition instead - which will backfire.

    --
    I mod down all the "free iPod"-sig losers.
  42. Just Installed It... by CyNRG · · Score: 2, Interesting

    Downloaded it, installed it, created a database, then table, inserted data into table, all within 15 minutes. Not bad. It looks pretty cool. Of course DB2 is all over it, and I noticed a tool to migrate to DB2 when this isn't big enough.

    It has a transaction log, row level locking, locking isolation levels, deadlock detection, etc. This really is a full featured database like DB2, Oracle, or Sybase. NO it isn't comparable, but it has the basic features. I deal with mutli-terabyte databases every day, and would love to have the time to create and torture Cloudscape on that level. Oh well, never anytime to play.

  43. Re:Database written in Java? by MemoryDragon · · Score: 2, Informative

    Swing starts to become slow as soon as it has to bypass the hardware acceleration functions entirely. Even using volatile images for double buffering in java2d can help immensely once the volatile images can be handled by the graphics adapter. You could see that in windows with the speed increase once you moved from jdk 1.3 to 1.4 it almost was five times faster. Alas the unix version was a little bit behind because using backbuffers and directly using the graphics cards ram is not that trivial in plain X, you have to bypass X or go the OpenGL route. Newere JDKs (1.4.2 rc1 from blackdown and 1.5 from Sun go that route)

  44. Re:$16M to maintain? by Big+Sean+O · · Score: 2, Insightful

    Benefits aren't everything. You cost a lot more to the business.

    There's the cost of rent, utilities for your office, your desk, your phone, your work cell phone, your work blackberry, the fax line, the copier, the copier paper, property taxes, the cost of keeping your parking space free of snow. Some communities charge an employment head tax. Oh, and don't forget hiring a janitor to keep your toilets clean. And some places you need to hire 'overhead' (ie: management) just to keep the yahoos in line.

    When I was in consulting we charged the client roughly 2.7x what we were making per hour. (Of course, that was in the rough-and-tumble heady days of consulting (the early 90s).

    Your standard IBM programmer probably makes $70K, add in another $40K for benefits, and double it for all the costs associated with hiring the person and you're at $220,000, almost the $250,000 the grandparent claimed.

    --
    My father is a blogger.
  45. Not really Informix by PCM2 · · Score: 3, Informative
    I've never used Cloudscape, but coming from its Informix roots I trust this - to a certain extent, of course.
    Fair enough, because after all its Informix roots only go so far. Informix didn't invent this product, it bought it. Strange that nobody has mentioned this before now.

    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.

    --
    Breakfast served all day!
  46. Re:Pretty cool by khuber · · Score: 2, Informative
    (SimpleApp.java) has some of the worst formatting I've ever seen

    It's just formatted with mixed spaces and tabs and your editor is probably converting the tabs to 8 spaces. XEmacs loads it okay if your tabs are set to 4 spaces, then you can select the text in the buffer and do a M-x untabify.

    Otherwise, something like this should work

    perl -ne 's/\t/ /g;print' SimpleApp.java > SimpleAppNew.java

    There are supposed to be four spaces inbetween the / / .

  47. 503 Theories by sbszine · · Score: 2, Informative

    Anyone know what the hell is going on over at Slashdot HQ?

    See this thread 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.

    --

    Vino, gyno, and techno -Bruce Sterling