Suppose I have a file containing several million strings (say URIs)
and I need to assign each unique string a numeric ID and store the
string-to-ID and ID-to-string mapping as (time) efficiently as
possible. Is there some clever technique databases use for this kind

I have design database model for Tag structure. Do u think del.icio.us
has same structure ?
I am also including heirarchy of tags, which delicious has not
implemented.

Hello, I was reading Witold Litwin's paper "Linear Hashing: A New Tool
for File and Table Addressing" and it all makes good sense except one
bit:
In section 2.3.3 "Other Split Functions" he describes a technique for

I tried to find the latest draft of the cdt glossary, but wasn't sure
if I found the most recent one, so mAsterdam or anyone -- could you
repost the glossary so we can perhaps add in some terms to help with
some of these discussions?  We could maybe add dimension, entity, flat,

I will use the post which was on comp.database on 25 January 2006,
Design Query, as one example for m:n relationships. Here we
should to design a database to track product subscriptions. The
solutions are simplified so that we can concentrate on m:n relationship

Hi, I haven't googled this subject yet, but I'm hoping for some kicks or
gentle prodding in the right direction as it's an area with which I am
unfamiliar.  Thanks very much in advance for reading.
I'm doing some thinking on a system that involves tracking items in

I don't have much idea of Blogs and Tags. Can anyone suggest some book
and any other resource from where I can find more about blog and Tags.
I want to desgin a database for Tag Structure. Database design that can
store heirarchy of tags developed my users.  Present most popular ...

I had a database analyst interview yesterday on the phone, and the
interviewer brought up the phrase: "I flattened the database".
I did not obfuscate in replying to her thread, but was able to avoid
having to know what she meant by that term.

---------------
Glossary 0.1.0:         "You keep using that word.
                                 I do not think it means what
february   2006                  you think it means"

Here's how to use XML in your database (...NOT!):
http://thedailywtf.com/forums/60879/ShowPost.aspx
--
Bob Hairgrove

Can anyone help me how to use DECODE function instead of CASE statement
in the following query.
select a.ASSOC_NAME region,
                                   count(CASE   WHEN va.ANSWER <>

[Relation]
1. A relation is a subset of the set of ordered
tuples (A1, A2, ... Am) formed by the Cartesian
cross-product of sets S1 x ... x Sm where each

(I'm new to database design so I do hope I'm able to adequately
describe my issue.)
I currently have a table called Institutions. The table groups data
common to all institutions along with a foreign key to the

What are the best and most database books important that I should read
explaining the relationships between databases .

I have a simple question, really.
I'm trying to build a database to handle sales. I've been looking around
at examples, both on the net and example db's such as "Northwind" that
MS puts out as an example, and I see that it's common practice to handle