Started a new group <a
href="http://groups-beta.google.com/group/dbresearch">here</a> (at
http://groups-beta.google.com/group/dbresearch) for database research
and development, developing new ways of thinking about data, and

Do you lose a lot of overhead by setting varchars to be lengths that
you probably don't need?
J. Olson
http://www.linuxloggers.com

I'm anticipated to complete my Bachelor of Engineering (Computer
Engineering) by the end of the year. After graduation, I will continue
my
study and undertake Masters of Information Technology, which consists

Hi all, I hope that I am posting in the right place. I am looking for
some advice. I have seen a product on the web called www.intranets.com
it is a hosted service, but allows me to very easily create new
databases, tables, and corresponding forms…

I've got a question:
If I wanted to design a system for data-entry from various remote
locations, I'd normally build/use whatever 2- or 3-tiered system came to
mind - PHP, application-servers - whatever.

Folks,
  Would storing raw XML data in a database be a good or bad thing? Why??
Comments much appreciated,
Al.

..
Are there any tools ?
The version controle system in microsoft product is vss.In oracle is
cvs.In db/2 what they use?,informix..?.

I am trying to extract part of a string field on a table. It has a
last name and it ends with a comma like "Smith,". I want to extract
the last name and dump the comma. I have this function, but it is not
working properly and it does not extract the comma from the string.

I need a database system which is suitable for time-series data.
That is nearly all tables in the DB are flat tables with very little
relationships.
I used to use Ms-Jet but the 2Gb size limitation was getting to be  problem.

The following example (www.xdb2.com/Example/Ex113.asp)
represents/queries the following things:
john is a person whose profession is gardener.
mary is a horse whose breed is mustang.

Here's an interesting problem. If this can be solved, Neo can't complain
about redundancy and nulls :)
Given a table of names and ages, where age 0 means unknown age:
SQL> CREATE TABLE age_test

I have to come up a block that prevents ceratin tasks from running
simultaneously, for instance:
- if latest sales data is being loaded, no reports involving recent
sales should run, but it is OK to run any reports against historic

In the group comp.databases.theory we had a short thread on the idea of
creating comp.databases.design.  Currently questions about that seem to be
distributed in both comp.databases and comp.databases.theory.
I have looked into this somewhat and it is fairly easy to propose a group. ...

I have to manage a very large database on a remote server.
Wich is the best dbms? Oracle, Ms SQL or what else (obviously not
access)?
Thanx

I have a table that looks like this (I've simplified it)
case_number payment_id
1000          500
1000          501