Re: How to make RDBMS ?

Hello Tony,

try the book:

Transaction Processing

Authors: Jim Gray and Anreas Reuter
ISBN 1-55860-190-2 This is my "bible" to databases.

Regards,
Vassil Popovski

"tony" <tony_at_email.com> wrote in message news:3C1A41B5.2070104_at_email.com...
> Hi there.
> First of all, If my question totally doesn't relate to this newsgroup,
> I'm so sorry... since I couldn't find newsgroups for my question, I
> posted here.
>
> I'm thinking to make RDBMS itself with C or C++ language.
> Before starting, I already got problems...
> SELECT * FROM table1;
> As you guys know, the statement above retrieve all records in the table1.
> It's easy to retrieve from memory, but if the table1 has 1,000,000 rows
> and 10 columns, what RDBMS should do with that huge table ?
> The RDBMS should put all records in the memory ? 1,000,000 rows & 10
> columns r fine, but if the table has 1,000,000,000 & 1,000 columns ?
> This is totally wasting memory space if the RDBMS put the all records in
> to memory.
>
> anybody knows how RDBMS treats those tables(files) ?
>
> Thank you
>
> tony.
>
Received on Mon Dec 17 2001 - 12:57:09 CET