When I try to do an "abstraction based" design of my table, I have two
columns.  However, the value of column 2 is directly related to the
value of column 1.  I have two questions.  The first question is
general, and the second question is specific to MS-Access.

I have a fast P4 Linux server with 2GB mem and yet running a simply SELECT
such as:
select part_number FROM catalog WHERE part_number LIKE 'HH%'
on a catalog table with 14,000 records takes 41.57 seconds.

I need a very simple and lightweight 'database' that has to run in windows
2003, and i need to interface it with my own applications (written in C++).
Ive used SQLite before, but this is both abit overkill on some issues, and
on other issues it really doesnt meet the requirements,

Suppose Adam has children named John(male), Jack(male) and
Mary(female). What schema/query finds John's brothers and sisters based
only on direct relationships to parent and gender. A direct
relationship would be parent/child. An indirect/derived relationship

We currently use Sybase and DB Artisan (8.12) from Embarcadero on a PC
runing Windows
DB Artisan is overkill for my needs, as all I need is:
1 - the ability to run queries, sort the result set on screen, cut &

Hi, I have received the following email from a colleague, and am quite
frankly baffled by the idea.
I am just wondering if anyone has any advice or suggestions about
this????

I have a byte[] array data that i want to insert/update into a table in
mysql.
here is the code:
           Connection conn = ....

We're having a pseudo-debate over the "correct" size to make fields in
our app.  Our framework's persistence layer is mostly RDBMS-agnostic.
Some of us old-timers use varchar(255) [or that newfangled
nvarchar(255)] mostly for historic reasons.

The Dos Program Is Writen In Borland Pascal. Database Files Are *.DAT /
*.IX / *.DIA
Program Name Is "GMS2000"

I'm looking for information. Where do people discuss ETL issues? I see
that an attempt to create a comp.databases.etl group failed by a
lack-lustre vote in 2003, if I understand what I was looking at? I also
see that this group ( comp.databases ) apparently has much lower

I need to dissect or know all detail about how data or entry are saved
in the above file format. It need to know start and end delimiters for
each entries.
Kind Regards

I'm looking for references - preferably online, but books will do as
well - on what was introduced in SQL92, SQL99 and SQL200x respectively.
I'm only interested in DDL and DML stuff. Anyone aware of such
document(s)?

At first blush this seems to be a straightforward inventory table. On
closer examination though, it appears that portfolio holdings (past and
present) are actually a residual of transaction analysis of the
investment account journal. An investor is not just interested in open

What important things should a hierarchy of the world store? I am
thinking of adding planets, continents, countries, US states, most
populus cities, oceans, longest rivers, highest mountains and most
spoken languages for starters. Can someone suggest other items they

The documentation for the Open method can be found at this URL:
http://msdn2.microsoft.com/en-us/library/ms675544.aspx
It says the following about the Options parameter:
"Can be one or more CommandTypeEnum or ExecuteOptionEnum values, which