[BDB 11gR2 Beta] [#18298] First Questions about DBD 11gR2

[Dave Segleau]

Luis,

Thanks for the quick response.
>
> The first point that is clear now is that we are talking about two 
> different products: Berkeley DB Java Edition and Berkeley DB 11gR2. I 
> was not thinking that way and now it explains some of my questions. If 
> I understand correctly, you created a java wrapper in order to expose 
> the SQLite API for Java applications, but in essence it is  a set of C 
> libraries.
>

I thought that might be part of the confusion. :-)  My apologies that 
this wasn't clear earlier. Both Berkeley DB 11gR2 and SQLite are C 
libraries. The Java API wrappers for both libraries have been around for 
a long time. Neither of them are new to this release.

>     * Specifically, which application development tool are you trying
>       to use to build /this /application?
>
> The application we are working on is a ADF Java Desktop Application. 
> It uses ADF Swing. It can operates is two modes: Connected to a 
> corporate Oracle 11g Database or Disconnected using a local Berkeley 
> Database. In the connected mode we use ADF Business Components to do 
> the object-relational mapping and create Entities, Views, 
> Associations, etc. These components are used by the ADF Swing 
> components in the UI, via data binding model. Our goal is to do the 
> same approach using Berkeley DB 11gR2. The idea is to have the same 
> data model in the two databases, in order to use the same ADF Business 
> Components already created. Depending on the context (connected or 
> disconnected), we just need to change the database connection and the 
> application would just works, no matter the database is Oracle 11g or 
> Berkeley.    Does it makes sense?
>
I'll let the ADF/Swing folks address the ADF-related questions.

With regards to the data model, it "should work", assuming that the data 
model implements a common set of data types and features. The Oracle 
Database and Spatial capabilities are not 100% compatible with the 
SQLite database and Spatial capabilities. I have not yet spent any time 
looking into the differences between the two. I'm not sure if the same 
ADF Business Components can work against both data sources.

>     * Does this new application plan on using capabilities of the
>       SQLite spatial functionality, just simple SQL or something else?
>
> We have a requirement to store geometries extracted from Oracle 
> Spatial (sdo_geometry) into BDB. Is it supported?
>
SQLite has support for spatial data types and functions. See 
http://www.sqlite.org/rtree.html. Since it is built on top of the 
sqlite3() API, it works with Berkeley DB 11gR2 as well. We've done some 
initial testing in-house, and the SQLite spatial tests appear to pass on 
Berkeley DB 11gR2. As I mentioned before, I have not yet looking into 
how the SQLite and Oracle Database spatial packages differ.

> I'll try to build BDB 11gR2 using the source files, following the 
> instructions that you and Sandra gave me.
>
> I'll let you know about the progress.
>

Thanks. We'll be interested to hear how you're doing.

Regards,

Dave

-- 
Oracle <http://www.oracle.com>
David Segleau | Director Product Management - Berkeley DB
Phone: +1 425 945 8533 | Mobile: +1 408 420 7350
Oracle Database Engineering

Green Oracle <http://www.oracle.com/commitment> Oracle is committed to 
developing practices and products that help protect the environment
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100217/1e23d4aa/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracle_sig_logo.gif
Type: image/gif
Size: 658 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100217/1e23d4aa/attachment.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: green-for-email-sig_0.gif
Type: image/gif
Size: 356 bytes
Desc: not available
Url : http://oss.oracle.com/pipermail/bdb-beta-feedback/attachments/20100217/1e23d4aa/attachment-0001.gif