[Info-ingres] Re: Ingres Open-Source / Open-Source Application ?

Recently I came across a company http://www.compiere.com/ which provides Open Source ERP Solutions, CRM solutions and POS Software solutions written in Java and currently working with Oracle 10g with Sybase to follow. They state on their web site that they would like to make their application database independent. Again according to their Web Site the criteria for using a database are:

*Costs (Note: An embedded Oracle License is included in the Compiere Support Contract without additional costs)
*Operator-free: Is the database self-tuning and extending?
*Stability:Can the database run without maintenance/shutdown for years, tolerate program and operating system crashes with automatic recovery?
*Availability: Is it possible to run the database 24/7 (if you have a web store), do cold/hot backups, automatic fail over
*Performance / Scaleable: Performance wizards, function indexes; Use of additional CPUs and Hardware RAID, ability to cluster ("grid") the database.

At a more technical level they state that the database must support :
Compiere Database Requirements
    * Full support of ANSI SQL 99 (CASE, all JOIN types, ..)
    * Support of Views and Views on Views
    * Support of User Defined Functions
      (preferably via SQLJ - Java running in the database)
    * Inline Views (e.g. SELECT ... FROM (SELECT xx FROM yy) ..)
    * JDBC 3.0 Support (especially RowSet)

I believe that Ingres R3 will stack up well against these requirements - from discussions in the news group there maybe a few issues with these requirements SQL/J .....

Would it not be beneficial for the new Ingres company to look at ways to partner / integrate with other Open Source providers that will assist in the growth of Ingres - especially in the Business application area.
------------------------

Regards

Mike Evans


Tel #: 246-431-0193
Fax#: 246-431-0192

.

Relevant Pages

  • Re: acceptable way to program
    ... Objective research by Oracle and IBM have both shown ... Backup isn't a query with any commercial relational database. ... written in Crsytal Reports or Cognos and not have Java front-end. ... weigh heavily against even the knowlegeable DBA insisting that the ...
    (comp.lang.java.programmer)
  • Re: Sample Java code requested
    ... I copied your example and edited it slightly for the Oracle connection side. ... >> I am new to Java and am wondering if anyone can help me with posting ... >> which would perform a connection to the database and also a SELECT ... > public class SQLTest ...
    (comp.lang.java.databases)
  • Re: [Oracle, java function] Problem with java function that uses 3rd party GPL library
    ... This would not work in the Oracle ... environment like a database doesn't make sense and isn't implemented. ... daniel.janczak@wp.pl writes: ... So I've downloaded barbecue - GPL java library ...
    (comp.lang.java.databases)
  • Re: Lisp for enterprise computing?
    ... It's not a community, but an industry to produce very good products. ... Concerning Open Source alternative ... ... memory, use a notably better Database, have more libraries! ... which is available for both Java and C. ...
    (comp.lang.lisp)
  • Re: jdbc connection
    ... I have installed java 2 SDK 1.4 on my windows XP machine. ... I want to connect to oracle database server ... If you want to make an "thick" connection using native Oracle ... You are attempting a SYS connection to the database. ...
    (comp.databases.oracle.misc)