So it is purely a storage 'trick". There is no magical data modelling technique used that requires or suggests to use a single physical file. I'll take a look at the suggested sqlite page.
Thanks and cheers. > -----Original Message----- > From: Christian Smith [SMTP:[EMAIL PROTECTED] > Sent: Thursday, October 07, 2004 12:21 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Single-file databases: how do they do it? > > On Thu, 7 Oct 2004, Cena, Resty wrote: > > >How do single-file databases handle multi-table databases? Do they simply > >pack separate physical table files into a single file, or have they found > >a way to store in one table all the definition and data values of a > >database? Can someone un-curious-ify me? Thanks. > > > > The SQLite high level architecture can be found at: > http://www.sqlite.org/arch.html > > In SQLite, each table or index is represented by a btree. The btree is > managed using fixed sized pages. As a btree is described by a root page, > you can reference many btrees in the same file using a different root page > for each btree. > > Christian > > -- > /"\ > \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL > X - AGAINST MS ATTACHMENTS > / \ This e-mail contains confidential information that is proprietary to EPCOR and its subsidiary companies in all respects. This information is intended only for the person(s) named in the destination address. Unauthorized distribution, copying or disclosure is strictly prohibited. If you receive this e-mail in error, please delete it immediately.
