BTC Database Complete!: 12/09/07
It has taken me just shy of a year but I have completely built my Book Traffic Control database. I now know how many books I have and how many I have gotten by month and year since joining BookCrossing in January 2003.
So far all these years contain months where I have been registering my books. Since I hadn't kept records of when I purchased books prior to joining BookCrossing, I have decided to use the registration date for the "Books In" table. Now that the database tables are built and complete for both "Books In" and "Books Out" I can now keep all my data current as I go. Next year (2008) will be my first with what I'd consider "pure data" in that it won't be confused with me registering masses of books I've owned for years.
I know with being an active BookCrossing and BookObsessed member and book lover, I won't be able to go all of 2008 without acquiring any new books. I also hope to continue doing ARC reviews and that will be another source of new books for me and new data points in my BTC database. Keeping all these factors in mind, my goals for next year are this: acquire only 100 books and release 400 books.
The blue bars show the registration dates or arrival dates for books into our home library. The red bars show the flow of books out each year. As you can see I've released almost 400 books every year. If I keep with my goal of only 100 "new" books, I can make a sizable dent in our book collection and free up some well needed shelf space.
btc | books | database | bookcrossing
Comments (1)
