| By Java News Desk | Article Rating: |
|
| February 9, 2005 12:00 AM EST | Reads: |
3,057 |
Daffodil 4.0 was made Compiere-compatible because of demands from the Compiere community for an alternate database to Oracle. No other database, Java or native, apart from Oracle is compatible with Compiere.
Features in the latest Daffodil release include support for recursive functions, advanced cursor support for Procedures and Triggers, support for scalar query in select list, support for scalar functions, support for scalar function in group by clause, support for table alias in update/delete statement, updation in view through update query and migration utility among others.
A migration utility has been added to enable the porting of existing Compiere applications in Oracle DB to Daffodil. This add-on can import all existing data from Oracle, ensuring 100% migration to Compiere in Daffodil DB. According to Compiere, users will be able to begin working in Daffodil from exactly where they left off in Oracle.
In addition to performance improvements, users of Daffodil 4.0 can define their own functions for business logic implementation. User defined functions can be used as value expressions in Select, Insert, Update, Delete and in Procedures. Using scalar subquery, queries can be returned in a single column with one single row. In the new version, support for scalar subquery in select list of select query has been introduced.
In comparison to Oracle, Daffodil is much smaller and cost-efficient. Daffodil DB can be embedded within any application and uses minimum system resources while delivering performance that is comparable to Oracle. Unlike Oracle, Daffodil DB is transparent to the end user and does not require a DBA.
Daffodil 4.0 is available in both Embedded and Network Editions, and is suitable for multithreaded applications requiring an embedded database. The Embedded Edition is a multiple connection RDBMS designed specifically for embedding inside Java based applications.
The Network Edition is built on Internet standards and provides robust relational data management for networked applications. Networked applications can use Daffodil DB Server Edition to provide ubiquitous data access from anywhere using standard Structured Query Language (SQL) and Java Database Connectivity (JDBC) interfaces.
Daffodil is compatible with the leading brands of Application Servers, Web Servers, JDO and Object Mapping Tools, including WebSphere, JBoss, Tomcat, Apache, and Oracle 9ias. Daffodil provides free support for Daffodil DB through its Daffodil Developer Forum and offers affordable commercial support under its One$/day support program.
An open source version of Daffodil DB is available, known as One$DB. This database is free for commercial use, but cannot be used with Compiere. Free evaluation versions of Daffodil's commercially offered product are being offered.
Published February 9, 2005 Reads 3,057
Copyright © 2005 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Java News Desk
JDJ News Desk monitors the world of Java to present IT professionals with updates on technology advances, business trends, new products and standards in the Java and i-technology space.
![]() |
Alexia 02/23/05 12:09:57 AM EST | |||
Great one! Maybe I can now think of using Compiere! Good work Dafodill!!!! |
||||
- Kindle 2 vs Nook
- Why IBM’s Server Chief Got Busted
- Is Cloud Computing Like Teenage Sex?
- Industry Experts Discuss the State of Cloud Computing
- Performance Tuning Essentials for Java
- Confessions of a Ulitzer Addict
- Tactical Cloud Computing Panel at 1st Annual GovIT Expo
- It's the Java vs. C++ Shootout Revisited!
- Cloud Computing Can Revitalize Your Career as Software Developer
- IBM Could "Reinvent" Java: Mills
- Oracle & Cloud Computing: Exclusive Q&A with SVP Richard Sarwal
- A Brief History of Cloud Computing
- Kindle 2 vs Nook
- Cloud CEOs, CTOs & SVPs to Speak at 4th International Cloud Computing Expo
- Why IBM’s Server Chief Got Busted
- Is Cloud Computing Like Teenage Sex?
- Industry Experts Discuss the State of Cloud Computing
- Performance Tuning Essentials for Java
- The Difference Between Web Hosting and Cloud Computing
- Cloud Computing Expo: Exclusive Q&A with Yahoo! SVP Cloud Computing
- Ajax in RichFaces 3.3, JSF 2 and RichFaces 4
- Confessions of a Ulitzer Addict
- My Thoughts on Ulitzer
- Tactical Cloud Computing Panel at 1st Annual GovIT Expo
- A Cup of AJAX? Nay, Just Regular Java Please
- Java Developer's Journal Exclusive: 2006 "JDJ Editors' Choice" Awards
- The i-Technology Right Stuff
- JavaServer Faces (JSF) vs Struts
- Rich Internet Applications with Adobe Flex 2 and Java
- Java vs C++ "Shootout" Revisited
- Bean-Managed Persistence Using a Proxy List
- Reporting Made Easy with JasperReports and Hibernate
- Creating a Pet Store Application with JavaServer Faces, Spring, and Hibernate
- What's New in Eclipse?
- Why Do 'Cool Kids' Choose Ruby or PHP to Build Websites Instead of Java?
- i-Technology Predictions for 2007: Where's It All Headed?










































