Script started on Mon Apr  9 16:08:02 2001
%make

gcc main.c mydb.o mydb2.o mydb_io.o mydb_index.o  mydb_index_io.o -o mydb
%mydb


Create the Top Album DB

Print the DB
87345 Snoop Dogg The Dogg Pound       1995 02 
20096 Bon Jovi   Slippery When Wet    1992 06 
45328 Black Flag Family Man           1986 05 
38547 Sepultura  Roots                1992 01 
64230 Mouthpiece What Was Said        1994 09 
09342 Bob Dylan  Blood on the Tracks  1972 03 
43349 Metallica  Ride The Lightning   1991 04 
93425 Floorpunch Fast Times at ...    1999 07 
87324 Mystikal   Ghetto Fabulous      1998 08 
12543 Ween       The Pod              1992 10 
82243 The Swarm  Old Blue Eyes        2000 12 

Record Scan: 3 : 1992
20096 Bon Jovi   Slippery When Wet    1992 06 
38547 Sepultura  Roots                1992 01 
12543 Ween       The Pod              1992 10 

Key Scan: 12543
12543 Ween       The Pod              1992 10 

Inserting a record...
00987&Unbroken&Life, Love, Regret&1992&06

Inserting a record...
34521&KRS-ONE&What's Next?&1995&11

Inserting a record...
34521&Madball&Hold it Down&1999&13
An Error Occured while Inserting/Modifying a record. Key already exists.

Deleting record: 20096

Modify Record: 45328 : 2 : The First...

Print the Now Modified DB
87345 Snoop Dogg The Dogg Pound       1995 02 
45328 Black Flag The First Four Years 1986 05 
38547 Sepultura  Roots                1992 01 
64230 Mouthpiece What Was Said        1994 09 
09342 Bob Dylan  Blood on the Tracks  1972 03 
43349 Metallica  Ride The Lightning   1991 04 
93425 Floorpunch Fast Times at ...    1999 07 
87324 Mystikal   Ghetto Fabulous      1998 08 
12543 Ween       The Pod              1992 10 
82243 The Swarm  Old Blue Eyes        2000 12 
00987 Unbroken   Life, Love, Regret   1992 06 
34521 KRS-ONE    What's Next?         1995 11 

Create the Top Album Index on Position

Print the Top Album Index Statistics
Information about index.Album.pos
Attribute indexed on: 4
Value Fields per Node: 4
Pointer Fields per Node: 5
Size of Nodes in bytes: 31
The Graphical Tree Display

Internal Value: 07 Index Pointer: 2 back pointer: -1
Internal Value: 04 Index Pointer: 0 back pointer: 7
Leaf Value: 01 Record Pointer: 3 back pointer: 2
Leaf Value: 02 Record Pointer: 0 back pointer: 2
Leaf Value: 03 Record Pointer: 5 back pointer: 2

Internal Value: >= Index Pointer: 1 back pointer: 7
Leaf Value: 04 Record Pointer: 6 back pointer: 2
Leaf Value: 05 Record Pointer: 2 back pointer: 2
Leaf Value: 06 Record Pointer: 11 back pointer: 2


Internal Value: >= Index Pointer: 6 back pointer: -1
Internal Value: 09 Index Pointer: 3 back pointer: 7
Leaf Value: 07 Record Pointer: 7 back pointer: 6
Leaf Value: 08 Record Pointer: 8 back pointer: 6

Internal Value: 11 Index Pointer: 4 back pointer: 7
Leaf Value: 09 Record Pointer: 4 back pointer: 6
Leaf Value: 10 Record Pointer: 9 back pointer: 6

Internal Value: >= Index Pointer: 5 back pointer: 7
Leaf Value: 11 Record Pointer: 12 back pointer: 6
Leaf Value: 12 Record Pointer: 10 back pointer: 6


Height of Tree: 3
Amount of Leaf Nodes: 5
Amount of Values: 12

Create the Top Album Index on ID

Print the Top Album Index Statistics
Information about index.Album.ID
Attribute indexed on: 0
Value Fields per Node: 0
Pointer Fields per Node: 1
Size of Nodes in bytes: 49
The Graphical Tree Display

Internal Value: 38547 Index Pointer: 0 back pointer: -1
Leaf Value: 00987 Record Pointer: 11 back pointer: 2
Leaf Value: 09342 Record Pointer: 5 back pointer: 2
Leaf Value: 12543 Record Pointer: 9 back pointer: 2
Leaf Value: 34521 Record Pointer: 12 back pointer: 2

Internal Value: 64230 Index Pointer: 3 back pointer: -1
Leaf Value: 38547 Record Pointer: 3 back pointer: 2
Leaf Value: 43349 Record Pointer: 6 back pointer: 2
Leaf Value: 45328 Record Pointer: 2 back pointer: 2

Internal Value: 87345 Index Pointer: 1 back pointer: -1
Leaf Value: 64230 Record Pointer: 4 back pointer: 2
Leaf Value: 82243 Record Pointer: 10 back pointer: 2
Leaf Value: 87324 Record Pointer: 8 back pointer: 2

Internal Value: >= Index Pointer: 4 back pointer: -1
Leaf Value: 87345 Record Pointer: 0 back pointer: 2
Leaf Value: 93425 Record Pointer: 7 back pointer: 2

Height of Tree: 2
Amount of Leaf Nodes: 4
Amount of Values: 12

Inserting a record...
01234&Bane&It All Comes Down&1990&14

Inserting a record into the Position index...
01234&Bane&It All Comes Down&1990&14

Inserting a record into the ID index...
01234&Bane&It All Comes Down&1990&14

Index scanning the ID index...
key: 00987
key: 01234
key: 09342
key: 12543
key: 34521
key: 38547
key: 43349
key: 45328
key: 64230
key: 82243
key: 87324
key: 87345
key: 93425

Index scanning and Accessing the Position index...
Key: 01 Record: 38547 Sepultura  Roots                1992 01 
Key: 02 Record: 87345 Snoop Dogg The Dogg Pound       1995 02 
Key: 03 Record: 09342 Bob Dylan  Blood on the Tracks  1972 03 
Key: 04 Record: 43349 Metallica  Ride The Lightning   1991 04 
Key: 05 Record: 45328 Black Flag The First Four Years 1986 05 
Key: 06 Record: 00987 Unbroken   Life, Love, Regret   1992 06 
Key: 07 Record: 93425 Floorpunch Fast Times at ...    1999 07 
Key: 08 Record: 87324 Mystikal   Ghetto Fabulous      1998 08 
Key: 09 Record: 64230 Mouthpiece What Was Said        1994 09 
Key: 10 Record: 12543 Ween       The Pod              1992 10 
Key: 11 Record: 34521 KRS-ONE    What's Next?         1995 11 
Key: 12 Record: 82243 The Swarm  Old Blue Eyes        2000 12 
Key: 14 Record: 01234 Bane       It All Comes Down    1990 14 

Equality Search the Position index for value 10
12543 Ween       The Pod              1992 10 

Range Search the Position index from values 4 to 10
43349 Metallica  Ride The Lightning   1991 04 
45328 Black Flag The First Four Years 1986 05 
00987 Unbroken   Life, Love, Regret   1992 06 
93425 Floorpunch Fast Times at ...    1999 07 
87324 Mystikal   Ghetto Fabulous      1998 08 
64230 Mouthpiece What Was Said        1994 09 
12543 Ween       The Pod              1992 10 

Create the Top Album Index on ID nodesize=2

Print the Top Album Index Statistics nodesize=2
Information about index.Album.ID.2
Attribute indexed on: 0
Value Fields per Node: 0
Pointer Fields per Node: 1
Size of Nodes in bytes: 31
The Graphical Tree Display

Internal Value: 34521 Index Pointer: 2 back pointer: -1
Internal Value: 09342 Index Pointer: 0 back pointer: 6
Leaf Value: 00987 Record Pointer: 11 back pointer: 2
Leaf Value: 01234 Record Pointer: 1 back pointer: 2

Internal Value: >= Index Pointer: 8 back pointer: 6
Leaf Value: 09342 Record Pointer: 5 back pointer: 2
Leaf Value: 12543 Record Pointer: 9 back pointer: 2


Internal Value: 45328 Index Pointer: 10 back pointer: -1
Internal Value: 38547 Index Pointer: 9 back pointer: 6
Leaf Value: 34521 Record Pointer: 12 back pointer: 10

Internal Value: >= Index Pointer: 4 back pointer: 6
Leaf Value: 38547 Record Pointer: 3 back pointer: 10
Leaf Value: 43349 Record Pointer: 6 back pointer: 10


Internal Value: >= Index Pointer: 5 back pointer: -1
Internal Value: 82243 Index Pointer: 1 back pointer: 6
Leaf Value: 45328 Record Pointer: 2 back pointer: 5
Leaf Value: 64230 Record Pointer: 4 back pointer: 5

Internal Value: 87345 Index Pointer: 7 back pointer: 6
Leaf Value: 82243 Record Pointer: 10 back pointer: 5
Leaf Value: 87324 Record Pointer: 8 back pointer: 5

Internal Value: >= Index Pointer: 3 back pointer: 6
Leaf Value: 87345 Record Pointer: 0 back pointer: 5
Leaf Value: 93425 Record Pointer: 7 back pointer: 5


Height of Tree: 3
Amount of Leaf Nodes: 7
Amount of Values: 13

Create the Top Album Index on pos nodesize=4

Print the Top Album Index Statistics nodesize=4
Information about index.Album.pos.4
Attribute indexed on: 0
Value Fields per Node: 0
Pointer Fields per Node: 1
Size of Nodes in bytes: 49
The Graphical Tree Display

Internal Value: 12543 Index Pointer: 0 back pointer: -1
Leaf Value: 00987 Record Pointer: 11 back pointer: 2
Leaf Value: 01234 Record Pointer: 1 back pointer: 2
Leaf Value: 09342 Record Pointer: 5 back pointer: 2

Internal Value: 43349 Index Pointer: 4 back pointer: -1
Leaf Value: 12543 Record Pointer: 9 back pointer: 2
Leaf Value: 34521 Record Pointer: 12 back pointer: 2
Leaf Value: 38547 Record Pointer: 3 back pointer: 2

Internal Value: 87324 Index Pointer: 1 back pointer: -1
Leaf Value: 43349 Record Pointer: 6 back pointer: 2
Leaf Value: 45328 Record Pointer: 2 back pointer: 2
Leaf Value: 64230 Record Pointer: 4 back pointer: 2
Leaf Value: 82243 Record Pointer: 10 back pointer: 2

Internal Value: >= Index Pointer: 3 back pointer: -1
Leaf Value: 87324 Record Pointer: 8 back pointer: 2
Leaf Value: 87345 Record Pointer: 0 back pointer: 2
Leaf Value: 93425 Record Pointer: 7 back pointer: 2

Height of Tree: 2
Amount of Leaf Nodes: 4
Amount of Values: 13

Thanks for checking out the Top Album Database.
%exit

exit

script done on Mon Apr  9 16:08:10 2001
