Re: Database question ?

After takin a swig o' Arrakan spice grog, sergei_m_1_at_yahoo.com (m sergei) belched out:
> I meant how the data is implemented in files and the programming
> structures.

The people that really know about this are internal to the development groups for the respective systems.

For Oracle, DB2, and Sybase, they are pretty inaccessible to the public.

There are several DBMS implementations available in "open source" form that might be useful to look at as the source code therefore _is_ available.

PostgreSQL, Firebird, Berkeley DB (it's not SQL, but it's interesting nonetheless), MySQL, SAP-DB, and Ingres are all available in "open source" form under one license or another. Amongst them you'll find a reasonably diverse set of "storage management" abstractions; none work in exactly the same way.

It would also be well worth your while to look to the literature and source code surrounding journalled filesystems. On Linux, you could avail yourself of source code for IBM's JFS, SGI's XFS, amongst other implementations.

What is quite interesting if you watch the literature is that the implementation strategies for journalled filesystems are remarkably similar to those for database storage management. They are similar problems, and both have been able to learn from each other...

-- 
(reverse (concatenate 'string "gro.gultn" "_at_" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/fs.html
Rules of  the Evil  Overlord #185.  "If I capture  an enemy  known for
escaping via  ingenious and fantastic  little gadgets, I will  order a
full cavity  search and confiscate all personal  items before throwing
him in my dungeon."  <http://www.eviloverlord.com/>