I'm hoping some SQL gurus read this and help me optimize my table/
query.  :)
The table is shown below:
CREATE TABLE IF NOT EXISTS PACKAGE_TABLE (

I know that this the most general group on databases, and I did not read
the FAQ (the reason being that I did not find :-) ).
I am not a computer scientist, and I need to implement a simple database.
My problem is from the general area of the "which db to choose" problems --

My project involves evaluation of different RDBMS systems for speed
and performance. I'm currently working on evaluation of RelX Linter
DB. I am using VC++ 2005 on Win XP for this project.
Could anyone tell me

I'm using cygwin, which includes octave (matlab work-alike), postgresql, and
perl.  I also have Excel 2003.  I'll be analyzing data from the I/O log files of
a suite of applications that communicate in a "dataflow" manner, by which I mean
that the data flows unidirectionally, though ...

folks, is there a database for a non-commercial use (i.e. relatively cheap)
which will allow me to store both text and diagrams/tables, preferably in
the same field? I do not want to use the OLE system. I can run on either PC
or Mac

We are in the process of tuning the performance of our stored procs in
SQL 2000 and are looking for a tool that would help us in comparing
the result sets of an old SP and a modified SP. The tool should take
as input the names of the 2 SPs, a set of parameter values and invoke

I have a table called "distributor" having "distributor_id" as a PK
and taking an integer data type as well as "distributor_parent_id"
which also takes an integer data type but can accept null values;
I tried to make this simple function that returns the parent_id by

What type of database system/design is best suited for people/identity
tracking of a population?
Can the design also allow for quick searching of record based on some
personal details such as by name, date of birth or others?

We are in the process of tuning the performance of our stored procs in
SQL 2000 and are looking for a tool that would help us in comparing
the result sets of an old SP and a modified SP. The tool should take
as input the names of the 2 SPs, a set of parameter values and invoke

I am trying to find a design pattern/data model pattern for a database
problem regarding value ranges/tiers. I actually got this to work a
few years ago on my own, but I figured this is likely a scenario that
more folks have run into and a standardized solution may exist.

It was asked on a Google discussion group:  "Why don't Google searches
support Regular Expressions?"
I was trying to imagine what kind of index structure or parallel processing
scheme it might take to support RegEx searches on gazillions of gigabytes of

I'm building a database for an application that I'm writing.  Because
I can't disclose what this program actually does, I'm going to present
a similar example.
The application has an entity named person.  A person has many