![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
|
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. |
#2
| |||
| |||
|
|
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. |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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,... |
|
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: 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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |