[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| 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 |
97.0. "Multiprocessor database" by SUBURB::MCDONALDA (Expand Three Letter Abbr (TLA)) Mon Mar 21 1988 16:44
A recent statement, from the Computer Weekly trade magazine, suggested
that relational databases were capable of running on multiprocessor
machines, "with near linearity as processors were added..." and that
several companies, having noticed this phemonina, are in a strong
position to exploit this market. I think, for the linearity bit,
that what the guy was trying to say was: the performance increase
realised, when running a database on multiprocessor machines, is
proportional to the number of processors added.
Obviously, there is a point where this no longer holds true, and there
were a host of factors not mentioned (e.g. size of database, number of
users, disc access, etc).
Be that as it may, does the statement hold true for all cases and what
are the circumstances where it does or doesn't?
Curious to know,
Angus
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 97.1 | linearity | COOKIE::JANORDBY | | Thu Mar 31 1988 01:43 | 9 |
| To date, the only major competitor that has successfully shown
linearity for a large number of precessors in a relational environment
is Tandem with their famous Top Gun Benchmark. It is not a
characteristic of relational systems to have linear performance
gains as processors are added. It is possible to write relational
systems and the supporting operating system to accomodate this,
however.
Jamey Nordby
|
| 97.2 | Possible for database engines | WARSAW::JACKSON | Tony Jackson (WARDER::JACKSONT) | Fri Apr 15 1988 15:37 | 31 |
| RE: - < Note 97.1 by COOKIE::JANORDBY >
>To date, the only major competitor that has successfully shown
>linearity for a large number of precessors in a relational environment
>is Tandem with their famous Top Gun Benchmark. It is not a
>characteristic of relational systems to have linear performance
>gains as processors are added.
I didn't see the article, but perhaps it is talking about adding
processors to database engines. In this case it is definitely possible
for linearity to be achieved. This has been proved by Teradata with
DBC/1012 Database Computer. Here's some benchmark figures :-
Debit Credit :- Number of processors TPS
40 41
80 82
128 130
Non-indexed scan of Rows/Second
a 5.5 million row table :- 40 22,000
80 42,000
128 68,000
Several customers of mine now have these machines and they tend
to agree with Terradata's claims. Remember that these systems are
highly specialised, dedicated relational database engines. They
are accessible from VAX/VMS via Ethernet.
I hope this is of some interest.
Tony Jackson.
|