LawLibTech

January 25, 2005

dtSearch - Have You Ever Used It?

The name dtSearch certainly sounds familiar, but I can't remember where I've heard it. I don't know anyone who has used it at their firm or library, so that can't be it. Maybe I've seen it mentioned in PC Magazine? Perhaps it runs a database product I've used?

This lack of visibility in the library community is exactly what irritates Ernest Perez. In his Online article, "dtSearch: The Little Search Engine That Could," he points out that "Despite all the success of this database application product in the software general marketplace, it appears to me that the proefssional library community seems to have pretty much ignored it."

If you're wondering what its capabilities are, you definitely need to read this article. It sounds quite powerful, and yet is relatively inexpensive and it runs on Windows and Linux.

Is anyone out there using it as an intranet search engine? For other purposes? If so, let us know! And you probably should let Ernest Perez know, too. It might make him feel better.

(Note to Reader: Online articles typically appear on Looksmart's FindArticles a few months after publication.)

January 25, 2004

Spreadsheet Does Not = Database

Spreadsheets are wonderfully useful things, especially for tasks involving calculations. But even Excel can be pushed to it's limit if it's not the right tool for the job.

That's easy for me to say. I know Microsoft Access much better than I know Excel. But trust me when I tell you that for many library-related tasks, databases are the only way to go. If you'd like to get started using databases take a look at "Spreadsheet Does Not = Database" in the Feb. 3, 2004 issue of PC Magazine.

According to the article, there are several significant advantages to using databases:

• Databases write data to the hard drive immediately, so there is less likelihood of losing data.
• Databases can handle more data
• Databases can easily link tables of related data together.

They left out an important point. Databases make it relatively easy to create flexible, attractive reports that show data and subsets of data in a variety of ways. For example, if you have an invoices database, you can create reports showing all invoices by title, by date, showing 2 fields, showing all fields, sorting by a combination of fields, show only invoices dated last month, the possibilities are endless.

There are many other advantages. For example, using Microsoft Access you can build easy to use data-entry forms and validate the text entered into the database.

Though new features have made spreadsheets even more flexible, for certain applications, a spreadsheet is no substitute for a good database.