Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    DB Internal Architecture

    I am doing research on the internal structures of data base systems. Where can I find high level, conceptual descriptions of how the data is actually saved? I am relatively new at this. Much of what I have found on the web is very low level and assumes a deep knowledge of the particular mechanics. My questions include:

    How is a relational table stored?

    Does it matter if you want to retrieve information by column or by row?

    Does the type of data in one field affect data in other fields in the same row?

    Any references or direct explanations will be most appreciated.

    Are the structures the same of different in important ways is such systems as DB2, MSSQL, MYSQL, Oracle, Peoplesoft?


  2. #2
    Join Date
    Sep 2002
    The Oracle Concepts Guide shows how Oracle does it. While other DBMSs may have similarities, there is no reason why they should not be significantly different. The relational model is logical, not physical, so it does not prescribe what happens "under the hood".
    Last edited by andrewst; 10-28-04 at 10:12.

  3. #3
    Join Date
    Jul 2003

    A simple one-pager ...

    Here's a brief summary derived from Ingres :-



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts