Re: Simple DBMS in VB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you are _truly_ doing this as an exercise, then part of the exercise might
entail some research. You might begin by looking at the structure of DBase
files (no one owns the structure of the files AFAIK). There is a plethora of
detail on them in the wild. Once you know the structure of the files, there
isn't a great leap from there to create them from scratch in VB (I have done
this) and read and write to them (I have done this too). Also, don't be
surprised if there isn't some VB Source out there to get you some info.

This place is where you come when you are already into your project and are
having technical issues that the veterans here can and will generally help you
solve. Asking to have someone conceptualize the scope and structure of an
undertaking is IMO a pretty big ask.


"Steve" <sredmyer@xxxxxxxxxx> wrote in message
news:1171021378.616892.237590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Feb 8, 9:07 pm, billsahi...@xxxxxxxxx wrote:
On Feb 8, 1:47 pm, "Steve" <sredm...@xxxxxxxxxx> wrote:> Hello all,

Look into ADO disconnected recordsets. They give you the power and
ease of use as a regular recordset, but you can store and retrieve
from a text file.



Purely as a learning experience I am thinking of writing a simple DBMS
in VB. I do not want anything fancy just a simple engine that would
store and retrieve data to a single disk file. The data should be
able to be relational (parent child relationships). The engine should
provide an object oriented interface (no SQL). Simply a DB object
that has child table object which inturn have columns and row etc.

I am just having a bit of difficulty in getting started. Can anyone
point me towards some resources or give me some insight into how to
create a simple DBMS.

Thanks,
Steve- Hide quoted text -

- Show quoted text -

I am aware of the facilities provided by ADO, but as I said in the
original post what I want to do is to create my own custom DBMS.
Again I am not looking to be able to do anything fancy just simple
storage and retrieval of data. The problem I am having is
conceptualizing the mechanisim used to implement relationships. I do
not want to use random access files as these make storing variable
length data difficult. Also I would like for the finished engine to
store all data (including any index info) in a single file.

Thanks



.

Relevant Pages

  • Re: Simple DBMS in VB
    ... Look into ADO disconnected recordsets. ... I do not want anything fancy just a simple engine that would ... store and retrieve data to a single disk file. ...
    (microsoft.public.vb.general.discussion)
  • Re: Dynamic Storage of a Directory Tree
    ... > As an exercise, I'm trying to store my entire directory tree, starting ... > I chose a directory tree because each directory can have an unknown list ...
    (alt.comp.lang.learn.c-cpp)
  • Dynamic Storage of a Directory Tree
    ... As an exercise, I'm trying to store my entire directory tree, starting ... from root, in memory. ... I chose a directory tree because each directory can have an unknown list ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Where is the power steering fluid?
    ... It is located at rear of the engine near the bulkhead. ... No, I'm afraid not, but it's an interesting exercise to guess at it. ...
    (alt.auto.mercedes)
  • Re: Smart Car Collides with School Bus
    ... Wagoneer of the late 70s with a Ferrari Daytona engine. ... exercise in the law of diminishing returns because its aerodynamics ... urban spaces. ...
    (rec.autos.driving)