[Zope-dev] SAP DB -- ZODB ?

2001-03-11 Thread Spicklemire, Jerry

Kapil said:

 looks like it will instantly become the most advanced open source database

 out there. my current rankings of the general os rdbms  in terms of
features 
 postgresql-interbase-mysql  

Keep in mind that (even though) it is an effective "general os rdbms",
PostgreSQL was originally developed as an experimantal platform for 
testing concepts in the Object-Relational database realm. As such, 
it has some unique potential, especially in its ability to define 
and store Objects as _native_data_types_. 

Most of the effort and press related to PostgreSQL in the recent past 
has focused on adding SQL in place PostgreSQL's QEL, and improving 
stability and performance. Now that most of this important work has 
been accomplished, my hope is that some of the truly differentiating 
features can be showcased, e.g. a Zope Storage where an external SQL 
engine can directly interact with objects as native data. 

Imagine a SQL statement that updates every instance of a ZClass with 
new properties, or slipping a super-class in underneath (re-parenting), 
where it had never been before. 

also:

 the feature list of this database is astonishing
 www.sapdb.org

 to name a few
 subtransactions
 outer joins
 sql 92 compliant, possible modes for db2, oracle 7
 very nice prodecural sql language.
 lots of statistics information
 really rich set of standard functions
 scrollable cursors
 
 this is a great candidate for a zodb storage

SAP DB is a fully licensed version of Software AG's (SAG) Adabas D, 
a descendant of SAG's venerable mainframe class system, Adabas C. 
Yes, SQL is fully supported, but SQL is after all a query language, 
not a physical model of the internal structure of an rdbms. 

This is not to say that Adabas, in any form, is any less of a capable 
system. Don't be surprised, however, to find something much closer to 
a network database under the surface, compared to PostgreSQL, which 
is about two generations newer, according to its "birth date" (1988?). 

Interestingly, many folks who have been around for several "database 
revolutions" see the network model as a very good choice for storage 
of "non-tabular" data types, such as objects, etc. On the other hand, 
that may be the result of lack of familiarity with the possibilities 
inherent in a true Object-Relational data model.

Later,
Jerry S.

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



Re: [Zope-dev] SAP DB -- ZODB ?

2001-03-10 Thread ender

On Friday 09 March 2001 07:20, Steve Alexander wrote:
I just heard that the SAP DB has gone Free and Open Source.

sapdb isn't open source yet. it will be in a few months. when it does it 
looks like it will instantly become the most advanced open source database 
out there. my current rankings of the general os rdbms  in terms of features 
postgresql-interbase-mysql  

currently sapdb has only opened the database manager and the client 
interfaces as well as the build environment needed to make these from src.

the feature list of this database is astonishing
www.sapdb.org

to name a few
subtransactions
outer joins
sql 92 compliant, possible modes for db2, oracle 7
very nice prodecural sql language.
lots of statistics information
really rich set of standard functions
scrollable cursors

this is a great candidate for a zodb storage

kapil


  SAP DB is an open, SQL-based, relational database management system that
   provides high availability and performance scaling from small to very
large
   implementations.

  In addition, SAP DB goes beyond relational database technology by
 offering object orientation as well as support for managing unstructured
 data. It supports open standards including SQL, JDBC and ODBC; access from
 Perl and Python; and HTTP-based services with HTML or XML content. SAP DB
 is platform independent, so users can deploy it for a wide array of
 projects.

   Since 1994, the SAP e-Business Solution is available on SAP DB
technology.
Today  SAP DB is being used by nearly 800 customers.

  On October 5, 2000, at Linux World SAP DB was announced to be made
available
as Open Source software using the GNU General Public License for the
database
kernel and the GNU Lesser General Public License for clients and
 programming interfaces.


http://freshmeat.net/projects/sapdb/

I'd never heard of SAP DB before, although I've heard of SAP.

This looks as if it would be good for a ZODB storage.

--
Steve Alexander
Software Engineer
Cat-Box limited


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



Re: [Zope-dev] SAP DB -- ZODB ?

2001-03-10 Thread Steve Alexander

ender wrote:

 On Friday 09 March 2001 07:20, Steve Alexander wrote:
 
 I just heard that the SAP DB has gone Free and Open Source.
 
 
 sapdb isn't open source yet. it will be in a few months. 

It is GPL-ed now, and you can download it now.


  http://freshmeat.net/projects/sapdb/

--
Steve Alexander
Software Engineer
Cat-Box limited


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] SAP DB -- ZODB ?

2001-03-09 Thread Steve Alexander

I just heard that the SAP DB has gone Free and Open Source.



  SAP DB is an open, SQL-based, relational database management system that
   provides high availability and performance scaling from small to very 
large
   implementations.

  In addition, SAP DB goes beyond relational database technology by offering
object orientation as well as support for managing unstructured data. It
supports open standards including SQL, JDBC and ODBC; access from Perl and
Python; and HTTP-based services with HTML or XML content. SAP DB is platform
independent, so users can deploy it for a wide array of projects.

   Since 1994, the SAP e-Business Solution is available on SAP DB 
technology.
Today  SAP DB is being used by nearly 800 customers.

  On October 5, 2000, at Linux World SAP DB was announced to be made 
available
as Open Source software using the GNU General Public License for the 
database
kernel and the GNU Lesser General Public License for clients and programming
interfaces.


http://freshmeat.net/projects/sapdb/

I'd never heard of SAP DB before, although I've heard of SAP.

This looks as if it would be good for a ZODB storage.

--
Steve Alexander
Software Engineer
Cat-Box limited


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



Re: [Zope-dev] SAP DB -- ZODB ?

2001-03-09 Thread Ulrich Eck

Hi steve ..

I have already a tiny version of ZsapdbDA which basically works.
I had contact to the maintainer of the python-module for sapdb.
and he handed out a nearly python DBI 2.0 compatible interface.

there might be some problems with the python-module and linux/python/threads
..
i didn't test this issue very much.
The Zsapdbda is basically working .. there are some issues concernig
Type-Conversion
and Exception-handling has to be refined.

ZsapdbDA is a remake of ZMySQLDA/DCOracle.

I have uploaded this product as an 0.0.1-alpha-preview .. you know what i
mean :)

http://www.zope.org/Members/jack-e/ZsapdbDA

So feel free to use this for further development .. i don't have any time
right now.

hope this helps

cu Ulrich Eck

- Original Message -
From: "Steve Alexander" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 4:20 PM
Subject: [Zope-dev] SAP DB -- ZODB ?


 I just heard that the SAP DB has gone Free and Open Source.

 

   SAP DB is an open, SQL-based, relational database management system that
provides high availability and performance scaling from small to very
 large
implementations.

   In addition, SAP DB goes beyond relational database technology by
offering
 object orientation as well as support for managing unstructured data. It
 supports open standards including SQL, JDBC and ODBC; access from Perl and
 Python; and HTTP-based services with HTML or XML content. SAP DB is
platform
 independent, so users can deploy it for a wide array of projects.

Since 1994, the SAP e-Business Solution is available on SAP DB
 technology.
 Today  SAP DB is being used by nearly 800 customers.

   On October 5, 2000, at Linux World SAP DB was announced to be made
 available
 as Open Source software using the GNU General Public License for the
 database
 kernel and the GNU Lesser General Public License for clients and
programming
 interfaces.
 

 http://freshmeat.net/projects/sapdb/

 I'd never heard of SAP DB before, although I've heard of SAP.

 This looks as if it would be good for a ZODB storage.

 --
 Steve Alexander
 Software Engineer
 Cat-Box limited


 ___
 Zope-Dev maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope-dev
 **  No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope )



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )