Hi

I've been a Notes consultant the last 10 years and I agree ...Notes is a
wonderful system.

But because IBM did not care or did not know what to do with
Notes/Dominoit for several years it lost a lot of momentum to other
technologies.

Therefore as a Notes consultant is important to look around and use other
technologies and platforms too, like Tomcat, Firebird, Hibernate....

I'm looking forward to "diving into" Firebird and making it my main RDBMS
plattform :-)

regards
Jesper B. Kiær

Jezzper Consulting
Website : http://www.jezzper.dk




"Bernard Devlin" <knowledgeworks@...>
18-05-2004 19:21
Please respond to
firebird-support@yahoogroups.com


To
firebird-support@yahoogroups.com
cc

Subject
[firebird-support] Re: Design question






Lotus Notes is an extraordinarily powerful and useful system - but its
database model is not relational, more like the pre-relational,
hierarchical database. What a Notes database and a relational
database are best-suited for is quite different. Notes 'tables' (i.e.
documents) are in themselves unstructured and flexible, unlike RDBMS
tables (and fixed structures are not always the best thing).

In Notes you need to use multiple databases because the view indexes
become relatively inefficient as they become moderately large. It is
unlikely you will need to worry about partitioning data that you store
in Firebird until you are orders of magnitude past the scale of what
you would consider feasible in Lotus Notes (having said that, the
Notes developer forums have dbs that were 16GB in size, IIRC).

Notes is no toy - it is a persistent datastore that is founded upon
replication (rather than bolting replication on as an afterthought).
And Notes security reaches down to field level (as does replication).
And unlike Firebird, Notes is also an application development
environment, with multiple language interfaces.

For me, Lotus Notes and Firebird are two of my essential technologies.

Regards, Bernard

> >more in a generelle sense...like when is a
> >certain amount af tables considered "too many" design wise?
> >
> >I plan to use Firebird a lot in the future, so would really like to

do it

> >"the right way"
> >
> >I come from a Lotus Notes/Domino world where it is normal to split

data

> >into different databases
> >
> >Not being able to do cross database joins, I guess forces one to use a
> >single database pr. application ?

Yahoo! Groups Links








[Non-text portions of this message have been removed]