| Title: | DEC Rdb against the World |
| Moderator: | HERON::GODFRIND |
| Created: | Fri Jun 12 1987 |
| Last Modified: | Thu Feb 23 1995 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1348 |
| Total number of notes: | 5438 |
I am working with a manufacturing customer that is begining to develop
an integrated information system. Said system will capture data from
multiple operational systems, integrate the data into a single, large
database, and periodically archive the data, preserving it for up to 10
years.
This system will be deployed in multiple sites, both in the US and
abroad. At some of these sites, people are currently using a variety
of dbms's and tools. Oracle already exists in 2/3 of these sites.
The IS manager championing this project would like to see an RDB
solution. Naturally, he is finding resistance from the Oracle users.
He has asked whether Digital can provide references or competitive
information to support the case for Rdb against Oracle in applications
like this.
The integrated database is expected to maintain about three months of
data on line. Data will be produced at the rate of about 40 or 50
megabytes per week. Access need not be very fast. People will extract
prodution data from the main database to load into their desktops, in
somewhat predictable fashion. Long extract times, perhaps measured in
hours will be acceptable at first.
Have you developed similar applications? Is there any competitive Rdb
vs. Oracle information for applications such as these? Any reference
sites, case studies or whatever to bolster the case for an Rdb
solution?
C.M.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1214.1 | Some Oracle info | SIERAS::WALLIS | Barry Wallis | Vote early and vote often | Wed Dec 16 1992 22:55 | 16 |
Rdb is head and shoulders above the previous version of Oracle (V6.0).
Oracle7 comes much closer to supplying many of the features Rdb has had
for many years now (however, Rdb has added global buffering in the
current version and Oracle has had this for some time now). However,
Oracle7 is brand new (hard to tell, but, it may not even be in general
release yet) and many of the new features are not easy to implement.
One of the features that Oracle7 does *not* implement is the ability to
explicitly cluster records together on the same database page. For
example, I can tell Rdb to make sure the master record and its
associated detail records are stored together. Thus, when you read the
master record, you get the detail records in your buffer without doing
another physical I/O. If performance is critical, this can be a big win
in many environemnts including manufacturing. Please be aware that
using this technique takes a thorough understanding of physical
database design.
| |||||
| 1214.2 | Not all features are equal....even though they might be checked off for both companies... | NOVA::FEENAN | Jay Feenan Rdb/xxx Engineering | Wed Dec 16 1992 23:06 | 12 |
RE:Global Buffers... Last week at DECUS I had some time free and attended an Oracle talk. One point that I picked up on which was interesting was that their SGA (global buffer area) could not be partitioned or controled. As the person put it a sequential retrieval would purge the global cache. Rdb's mechanism has a 'throttling device' with the implementation of what we call 'allocation sets'. In this way a user (application) can only control a certain part of the global cache. What would happen is that only this partition of the global buffer pool would be affected by a 'sequential scan' operation. -Jay | |||||
| 1214.3 | A contact | TAV02::ARIE_L | Arie Levy | Thu Dec 17 1992 14:37 | 9 |
"ISKAR" is DEC customer in Israel that uses Rdb to manage their Manuf applications. You can contact the DEC project manager Drussinsky Jeff @ISO for details. Regards, Arie Levy | |||||