Web-Enabled Database System for ClimbingBoulder.com
This is an example of the true power of the Internet. Web-enabled databases allow flexibility, dynanism, and easy
scalability. For this client, we developed a fully-relational database architecture for the site (in this case, a rock
climbing route database). Then we implemented a web interface to manage(add, update, or delete) the information in the
database in a simple, easy-to-use manner. Finally, we enabled the front-end applications so that users could view the
information in an intuitive manner.
The following graphic shows the beauty and elegance of this solution. Data comes into via a single method. Then, it is
served to many different outputs, all off the single master database. When the data changes, the data available to all out
these outputs is instantly available. This translates to much less time on tedius updating and copying.
This second graphic shows another example of the beautiful automation opportunities with a true database. This is a screen
shot of the front page. The real beauty of these functions is that they basically run themselves; they are interesting
and dynamic to users, but no work for an administrator to upkeep.
- Newest Routes - Every time a route is added into the database, it automatically appears at the top of the
- Database Stats - The numbers are drawn directly from the database, and instantly change if new entries are added or
entries deleted from the database.
- Search the Database - One can type in a text string, query the database, and return any matching records. The
this function is that a person can add a route, and 5 seconds later a person searching may find this route as a
- 3 Star of the Day - Every morning at 1:00 AM, the server queries the database for all the "3 star" (ie
randomly chooses one, and puts the output here.
This client had a large form that allowed individuals to list their property information for sale. After some discussion, we
decided to break it up into different pages, with form elements. Each page has some required fields - if the user leaves
those items blank and clicks submit, they will receive an error page that prompts them to re-enter the information that they
are missing. On page 5, contact information, the Email field is automatically filled out with the value entered in at the
first stage of the process. On the last page, a confirmation page shows all the values entered in over the last 5 pages. On
submission, an additional confirmation email goes to the user, and an email goes to denverspace.com, where they begin processing the order. Additional future developments may be that the information is added to a web-enabled database, allowing the site to work directly from that database, rather than disparate emails.
Random Image Displayer for Climbingboulder.com
A simple, yet nice touch for some situations is a page that loads a different image each time it is viewed. For Climbingboulder.com, we placed this application on the front page. Each time someone visits the home page, one of seventeen possible images is loaded into the front page, along with an accompanying description below the image. The two images below show a portion of the home page and the theme illustrated. What is especially nice about this application is a simple, web-based form to add another photo(for administrators). This makes it very easy to add and/or remove pictures from the selection of images. This will work for two images, or a hundred.
Web-based File Uploading for ClimbingBoulder.com
Many applications do not simply desire transportation of text and html documents. Word documents, images, and spreadsheets are sometimes desired to be transferred between a web site and clients. Normally this is done via FTP (File Transfer Protocol), but a useful web-based method is also available. In the example here, users upload photos of themselves or their friends, and they are entered automatically into a public photo album, where any one can see the pictures.
Information and Data Analysis Consulting for Boles Financial Center
One thing this world is not short of is data. Information and data sets are everywhere, and literally at our fingertips. The real challenge, then, is to be able to transform information into knowledge. For this client we assist in the identification of what knowledge they are looking for, and how to find it. Secondly, we are setting up the infrastructure to easily continue this process and knowledge creation.
More specifically, Boles tracks most of his information in Microsoft Excel spreadsheets. We help to bring a definite structure to their documents, by synthesizing their knowledge of the financial issues and our ability to make Excel output the information in the right format, in the right way. Then, we take it a step further by setting up the processes to allow the client to update, manage, and produce the needed reports every month, without our assistance. The below graphic is a sample of the type of work we have done for the client.
We are not talking about artistic expression and pretty graphics. We follow Edward Tufte's philosophy of effective information design. To read more about his theories, we recommend you see Visual Display of Quantitative Information.
Another example of the work we have done in this area is the below chart. It is for climbingboulder.com, and compares the capabilities of SLCD's of 7 different manufacturers, or 13 different types of protection. Maximum and minimum effective range values are given for each data point. For more detail, see the original.