Sunday, October 16, 2005

The PC Products Database

This database turned out to be one of my biggest undertakings ever! It started with trying to catalog the various Amiga products in the early days which led to publishing several product indexes for Commodore. Then I started adding some PC related products with the advent of the Amiga Bridgeboard that allowed running PC applications on the Amiga. Eventually I stopped adding Amiga information as the market died and finally concentrated on the PC products.

The original database used a program called Superbase that started on the Commodore C-64, then evolved to the Amiga where is was greatly enhanced and eventually was ported to the PC market. Superbase supported truly relational databases with extensive programmability. I wound up writing my own application that never seemed to stop expanding and growing. I developed a data structure that allowed cataloging all sorts of information about the PC industry and I could perform all sorts of queries with sometimes very interesting results. In the end there were over 250,000 records of data in the database with information on well over 50,000 products and tens of thousands of companies.

One of the programs I wrote in Superbase allowed generating a bulk mail distribution to newly added companies, printing envelopes in bulk mail sort order all set for bundling complete with my bulk mail permit. I hate to think how many envelopes were printed on my old LaserJet II printer! I used to send a letter to every new company when it was added in the database to introduce my newswire service, requesting press releases and information for my database.

My database actually consisted of 6 or 7 interlinked files with the main file containing the basic company information: the company name, mailing address, various phone numbers, plus a website URL and email addresses. There were a number of flag fields that indicated the company's basic products being hardware, software, accessories, peripherals, books/magazines and more. There was also a flag to indicate a shareware publisher. Every company entered in the database had a unique company ID number assigned when they were entered plus a date field to indicate the last time the company's information was updated.

There was also an alternate address file that allowed recording any number of additional addresses, phone numbers, email addresses, website URLs, etc. for a particular company. Each record in this file also had a comment field where the information could be labeled or identified. Each alternate address record in this file was linked back to the main company record in the main file by the company ID number.

A Comments file allowed added general text comments for a particular company and simply had one text field and a company ID field to link the comment back to the company information. This came in handy when there was some little tid-bit of information that just didn't fit in any of the regular data file records.

Now for the meat of the database - the Product records allowed entering the product name and brief description (60 characters maximum) with a link back to the company ID number plus a unique product ID number that was assigned to ever product record. There was another file that contained thousands of product categories with a 50 character text description and a unique product code. Then a Product Index file had two fields to link a given product using it's unique product ID number with a particular product category. This structure allowed associating a particular product with any number of product codes without any limits what-so-every!

The really fantastic part of the product indexing was the product categories that were divided into seven major groups: (0xx) special attributes, (1xx) hardware, (2xx) software, (5xx) publications & information services, (6xx) organizations, (7xx) services plus (8xx) accessories & supplies. I used five groups of numbers to identify each particular product category, for example: where each grouping identified a more detailed subgroup as you moved right in the number. For example, all 130.xxx categories were Hardware Peripheral Devices, 130.60.xxx might be hard-copy output peripherals, 130.60.10.xxx might be printers, might be dot matrix printers and might be 24-pin dot matrix printers. Additional codes could be added at any level as needed to refine the data as needed.

The first group of product codes starting with a zero were reserved for special attributes where I could flag a discontinued or retired prdouct, shareware, freeware or public domain software, special media like CD-ROM or videodisc, age groups to identify educational material for specific groups or adult material, or flag products for specific operating systems like GEOS, PICK, UNIX, etc.

The way the product indexing developed it was extremely easy to expand and add additional information as it was needed. When searching on product codes, you just had to search on the highest product code in the tree and everything else that was categorized with a more refined product category code was also included. This made it really flexible and easy to use!

The database was published on AOL using their Rainman process but was very limited since I could only publish simple text articles with a very basic text index. So there was an article generated for each company in the database with all the information for that company listed in that article. The online search would let you search by company or product name but you couldn't do much with product categories. The date field in each company record allowed me to track what company information needed to be updated on AOL at any point in time so I didn't have to reload the entire database all the time, only the changes. Whenever I had to do a complete reload it would swamp AOL's Rainman process and no one else on the service could do anything until it completed. Needless to say that wasn't done very often!

Eric Englemann of EMS Professional Software in Maryland wrote a dBase interface for my data and published my entire database on CD-ROM for many years that closely resembled my Superbase capabilities. I would generate a copy of the database and ship it on floppy disks (lots of disks!) every month if you can believe it and he would convert everything to dBase and publish it on his next CD-ROM release. At one point we won a Software Star Search award from Computer Reseller News in March of 1992. I think Eric still has some copies of the last PC Products Database that we did 8 or 10 years ago that he still distributes, but he really concentrates on buying and selling old development software now. If interested, you can find his current website at: http://www.emsps.com/

No Starch Press saw the database and had me do a stripped down version that we published in book form in 1996 as the Computer Phonebook. I think we sold a few thousand copies but it never really took off and was only published that one year. The only good thing was that another reference book publisher, Omnigraphics saw the No Starch Press book and flew my wife and I down to Florida to talk with them. They wound up licensing a copy of my entire database to merge into their databases to create reference books for libraries and universities. If anyone is really interested I may still have a few copies of the original Computer Phonebook still around!

Eventually the PC Products Database was put to rest. It was really hard to stop after all those years but I eventually moved on to other things and wound up concentrating on my full time job for the next few years after all the writing and online work came to an end.


Post a Comment

<< Home