Home     DB      Replicator      CRM      Solutions  

Product Overview
Daffodil DB Open Source
License Policy
One$ DB FAQ
Daffodil DB Enterprise
Pricing Policy
Support Overview
Why Java Database?
Why Daffodil DB?
User Guide
Features
Documentation
Compatible Products
Data Migration
Features Comparison
Performance Comparison
Success Stories
Daffodil DB FAQ
Daffodil DB BLOG
User Forum
Buy
Daffodil DB
Daffodil DB FAQ > General FAQ
 
Daffodil DB General FAQ


  1. What is Daffodil DB?
  2. Is there an evaluation version for Daffodil DB?
  3. What are the System requirements for using Daffodil DB?
  4. How to install and run Daffodil DB?
  5. What is Daffodil DB best suited for?
  6. Which SQL Standards are supported by Daffodil DB?
  7. What editions does Daffodil DB offer?
  8. What is Daffodil DB Embedded Edition?
  9. What are the prominent features and advantages of using the Embedded Edition of Daffodil DB?
  10. What is Daffodil DB Network Edition?
  11. What are the prominent features and advantages of using Network/Server Edition of Daffodil DB?
  12. What are the tools available with Daffodil DB?
  13. What is Daffodil DB Browser?
  14. What is Daffodil DB Shell?
  15. Where can I get to see more Documentation?
  16. What are the limitations of the database (size of columns, number of tables, rows)?
  17. Does Daffodil DB have ODBC support?
  18. Is Data Migration from other databases possible in Daffodil DB?
  19. List all "Application Servers" that are compatible with Daffodil DB ?
  20. List all "Web Servers" that are compatible with Daffodil DB?
 

     
  1.
What is Daffodil DB?
   
Daffodil DB is a feature-rich, easy-to-use, robust, scalable, and embeddable Java RDBMS.
     
  2. Is there an evaluation version for Daffodil DB?
    Yes. The free, fully-functional, 30-day evaluation version of Daffodil DB is available at
http://www.daffodildb.com/download/index.jsp
     
  3. What are the System requirements for using Daffodil DB?
    The system requirements for using Daffodil DB are 32 MB RAM. Daffodil DB can run on any operating system for which the JVM is available. For further information kindly refer to our Hardware, Software, and Memory Requirements section in Getting Started Guide.
     
  4. How to install and run Daffodil DB?
    An auto-executable jar file is part of the Daffodil DB product download and can be accessed by downloading Daffodil DB. For further information kindly see our Getting Started Guide.
     
  5. What is Daffodil DB best suited for?
    Daffodil DB is best suited for Java-based applications that are targeted at the SME market. Daffodil DB can be used to develop (amongst others) Information Management Systems, Web applications, and J2EE applications.
     
  6. Which SQL Standards are supported by Daffodil DB?
    Daffodil DB supports almost all constructs of SQL 99 including triggers, updateable views, table level and column level constraints, UDT, schema, domain, user, role, privilege, batch operation, join, aggregate functions, rich inbuilt function library, sub-queries, intersection and union, all isolation levels, save-point, a rich set of SQL data types, stored procedure, and distributed transactions (XA).
For complete details about Daffodil DB SQL 99 support, please refer to the Daffodil DB SQL Reference Guide.
     
  7. What editions does Daffodil DB offer?
    Daffodil DB is available in two editions: Network Edition and Embedded Edition.
     
  8. What is Daffodil DB Embedded Edition?
    Daffodil DB Embedded Edition is a multiple-connection RDBMS designed specifically for embedding inside Java applications. Embedded in a single-user Java application, the Embedded Edition can be made practically invisible to the user, since it requires no administration and runs on the same Java virtual machine (JVM) as the application.
     
  9. What are the prominent features and advantages of using the Embedded Edition of Daffodil DB?

   
  • Daffodil DB Embedded Edition is suitable for multi-threaded applications requiring an embedded database.
  • Daffodil DB Embedded Edition is designed specifically for embedding it inside Java based applications.
  • It fully supports multiple connections within the same JVM as well as multiple threads performing operations concurrently in each connection.
  • Embedded in a single-user Java application, Daffodil DB Embedded Edition can be practically made invisible to the user, since it requires no administration and runs on the same Java virtual machine (JVM) as does the application.
  10. What is Daffodil DB Network Edition?
    Daffodil DB Network Edition, also known as the Server Edition, provides robust relational data management for networked applications built on Internet standards. Networked applications can use Daffodil DB Network Edition to provide ubiquitous data access from anywhere using standard SQL and JDBC interfaces. Daffodil DB Server can be placed on an Intranet with clients connecting to it via TCP/IP connections. Daffodil DB Server can also be integrated with an Application Server, or a Web Server, to provide database capability over the Internet.
     
  11. What are the prominent features and advantages of using Network/Server Edition of Daffodil DB?

   
  • Daffodil DB Network/Server Edition 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 DB Server can be placed on an Intranet with clients connecting to it via TCP/IP connections.
  • Daffodil DB Server can also be integrated with an Application Server or a Web Server to provide database connectivity over the Internet.
  12. What are the tools available with Daffodil DB?
    The tools available are Daffodil DB Shell and Daffodil DB Browser.
     
  13. What is Daffodil DB Browser?
    Daffodil DB Browser is a sophisticated and interactive GUI-based database management tool. The Browser can be used to carry out all database operations and maintenance tasks, such as creating a database, creating database objects, executing SQL statements, browsing database objects, inserting and updating data, and view query execution plan.
     
  14. What is Daffodil DB Shell?
    Daffodil DB Shell is an interactive SQL scripting tool for executing SQL statements and displaying results. It is a simple utility for running scripts against a Daffodil DB database.
Daffodil DB Shell is a Java application, which can be started from a command window, such as MS-DOS Command Window or the UNIX shell.
     
  15. Where can I get to see more Documentation?
    Full documentation is a part of Daffodil DB product download and can be accessed by downloading Daffodil DB. Online documentation is also available on our website.
     
  16. What are the limitations of the database (size of columns, number of tables, rows)?
    We have successfully tested Daffodil DB with 10000 columns in a table, 5000 tables in a database, and 20 million records in a table.
     
  17. Does Daffodil DB have ODBC support?
    Yes, Daffodil DB Open Database Connectivity (ODBC) Driver is a high-performance 32 Bit ODBC Driver that provides transparent access to remote databases from any ODBC-compliant application. It is based on the Call-Level Interface specifications from X/Open and ISO/IEC for database APIs and also uses Structured Query Language (SQL) as its language for accessing databases. For more info click on the following link: http://www.daffodildb.com/odbc-driver.html
     
  18. Is Data Migration from other databases possible in Daffodil DB?
    Yes, Daffodil DB has a data migration tool that facilitates data migration from your existing database to Daffodil DB.
     
  19. List all "Application Servers" that are compatible with Daffodil DB?
    Daffodil DB is compatible with Pramati, Websphere, Weblogic, Oracle 9ias, J2EE, Sun One, and JBoss. More information can be gathered from our data migration section.
     
  20. List all "Web Servers" that are compatible with Daffodil DB?
    Daffodil DB is compatible with Tomcat, Apache, Pramati, Websphere, Weblogic, IIS (Internet Information System), and PWS (Personal Web Server).

 
 
Web Database | SQL Database | Embedded Database
©2006 Daffodil Software Ltd. Contact Us | Disclaimer | Sitemap