dbTalk Databases Forums  

Re: Request to identify DBMS that uses .bt and .ov entities (files?)

comp.databases comp.databases


Discuss Re: Request to identify DBMS that uses .bt and .ov entities (files?) in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Hayes
 
Posts: n/a

Default Re: Request to identify DBMS that uses .bt and .ov entities (files?) - 02-09-2010 , 02:53 AM






On Mon, 8 Feb 2010 16:25:21 -0800 (PST), Curious <ggle75 (AT) carpelibris (DOT) com>
wrote:

Quote:
I have an old database file (named *.db) that refers to what could be
a relational structure with entities that have names ending in .bt and
ov. I'm calling them entities because I don't know whether the .db
file unpacks to create a bunch of .bt and .ov files (probably key and
data files?) or if these names belong to data structures that stay in
the .db file.
Paradox data files use the .db ending.


--
Steve Hayes from Tshwane, South Africa
Web: http://hayesfam.bravehost.com/stevesig.htm
Blog: http://methodius.blogspot.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

Reply With Quote
  #2  
Old   
Ben Finney
 
Posts: n/a

Default Re: Request to identify DBMS that uses .bt and .ov entities (files?) - 02-09-2010 , 04:57 AM






Steve Hayes <hayesstw (AT) telkomsa (DOT) net> writes:

Quote:
On Mon, 8 Feb 2010 16:25:21 -0800 (PST), Curious <ggle75 (AT) carpelibris (DOT) com
wrote:

I have an old database file (named *.db) that refers to what could be
a relational structure with entities that have names ending in .bt and
ov. I'm calling them entities because I don't know whether the .db
file unpacks to create a bunch of .bt and .ov files (probably key and
data files?) or if these names belong to data structures that stay in
the .db file.

Paradox data files use the .db ending.
So, traditionally, do many other database systems. Even non-relational
ones like Berkeley DB.

The OP would be well advised to look to clues other than the filename
suffix for what kind of data is stored in there.

--
\ “I am amazed, O Wall, that you have not collapsed and fallen, |
`\ since you must bear the tedious stupidities of so many |
_o__) scrawlers.” —anonymous graffiti, Pompeii, 79 CE |
Ben Finney

Reply With Quote
  #3  
Old   
Curious
 
Posts: n/a

Default Re: Request to identify DBMS that uses .bt and .ov entities (files?) - 02-09-2010 , 11:26 AM



Perhaps the SP (subsequent poster) could elaborate on what else to
look for?

I am guessing that the db file is a container of the files or pseudo-
files that make up the database. I can tell that the directory
structure of this .db file has 26 byte entries, consisting of the file
name (right-padded with nulls) and some other numerical data I haven't
decoded yet. Each entry in the directory structure looks like a file
name ending with either .bt or .ov. More than that on the .db file I
don't know.

What can I do to unpack this .db file and extract its component
pieces? I've tried zip, arc, rar,...

Looking past the directory structure in the .db file I see what looks
like the data file pieces. The text is not encrypted or compressed and
there are lots of non-printing data that are probably the index and
addressing parts of the database.

If you tell me what to look for, I can look for it. If I can identify
the DBMS, I'll be able to read the data. Or, I could write a script to
extract it and put it into sql for further analysis.

Thanks for your help.

On Feb 9, 3:57*am, Ben Finney <bignose+hates-s... (AT) benfinney (DOT) id.au>
wrote:
Quote:
Steve Hayes <hayes... (AT) telkomsa (DOT) net> writes:
On Mon, 8 Feb 2010 16:25:21 -0800 (PST), Curious <ggl... (AT) carpelibris (DOT) com
wrote:

I have an old database file (named *.db) that refers to what could be
a relational structure with entities that have names ending in .bt and
ov. I'm calling them entities because I don't know whether the .db
file unpacks to create a bunch of .bt and .ov files (probably key and
data files?) or if these names belong to data structures that stay in
the .db file.

Paradox data files use the .db ending.

So, traditionally, do many other database systems. Even non-relational
ones like Berkeley DB.

The OP would be well advised to look to clues other than the filename
suffix for what kind of data is stored in there.

--
*\ * * * I am amazed, O Wall, that you have not collapsed and fallen, |
* `\ * * * * * *since you must bear the tedious stupiditiesof so many |
_o__) * * * * * * * * *scrawlers. anonymous graffiti, Pompeii, 79 CE |
Ben Finney

Reply With Quote
  #4  
Old   
Jasen Betts
 
Posts: n/a

Default Re: Request to identify DBMS that uses .bt and .ov entities (files?) - 02-12-2010 , 03:09 AM



On 2010-02-09, Curious <ggle75 (AT) carpelibris (DOT) com> wrote:
Quote:
I am guessing that the db file is a container of the files or pseudo-
files that make up the database. I can tell that the directory
structure of this .db file has 26 byte entries, consisting of the file
name (right-padded with nulls) and some other numerical data I haven't
decoded yet. Each entry in the directory structure looks like a file
name ending with either .bt or .ov. More than that on the .db file I
don't know.

What can I do to unpack this .db file and extract its component
pieces? I've tried zip, arc, rar,...
padded filenames suggests DOS or CP/M

the binary data is probably the file's timestamp and length

have you tried nlib.

Quote:
If you tell me what to look for, I can look for it. If I can identify
the DBMS, I'll be able to read the data. Or, I could write a script to
extract it and put it into sql for further analysis.
have you asked file?

http://en.wikipedia.org/wiki/File_(command)










Quote:
Thanks for your help.

On Feb 9, 3:57*am, Ben Finney <bignose+hates-s... (AT) benfinney (DOT) id.au
wrote:
Steve Hayes <hayes... (AT) telkomsa (DOT) net> writes:
On Mon, 8 Feb 2010 16:25:21 -0800 (PST), Curious <ggl... (AT) carpelibris (DOT) com
wrote:

I have an old database file (named *.db) that refers to what could be
a relational structure with entities that have names ending in .bt and
ov. I'm calling them entities because I don't know whether the .db
file unpacks to create a bunch of .bt and .ov files (probably key and
data files?) or if these names belong to data structures that stay in
the .db file.

Paradox data files use the .db ending.

So, traditionally, do many other database systems. Even non-relational
ones like Berkeley DB.

The OP would be well advised to look to clues other than the filename
suffix for what kind of data is stored in there.

--
*\ * * * “I am amazed, O Wall, that you have not collapsed and fallen, |
* `\ * * * * * *since you must bear the tedious stupidities of so many |
_o__) * * * * * * * * *scrawlers.” —anonymous graffiti, Pompeii, 79 CE |
Ben Finney


--- news://freenews.netfront.net/ - complaints: news (AT) netfront (DOT) net ---

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.