SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

An Introduction to Database Models

An Introduction to Database Models

SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2565 Visits: 1

Frank, nice to see you back. I've also been gone a couple of weeks (not voluntarily - on the road/busy).

Thank you Frank and to all of you for making interesting forum article reading.

I hope I don't ramble to much here, but I do have some thoughts...

I'm by no means a theoretical database expert, or for that matter cared very much about
the theoretical reasons for databases and how the data model is designed. In my opinion,
the database and DBMS exist for the purpose of recalling information in a form and
accuracy required by the querier. Personnally I've tended to gravitate toward DBMSes that
provide me with a rich programming environment "close" to the data, while providing
the performance required by the application(s). We all know that given enough time, we
could write interfaces to make most all the DB models "look" the same to the end user,
and also the programmer. At this time the relational model, the DBMSes that support
it, seem to provide the best (in most) of the database & programming aspects we all
consider important.

I think we mostly like the relational model because it's the closest thing to the type
of data we deal with most of the time: "Business Data". Since this is the kind of data
where the "money" is, it's had the most effort put towards it. This is why we have ever
evolving and better DBMSes as the computer age matures. I think the way todays computers
are built, and the way business conducts itself, has created the databases & DBMS we see

Here comes the Sci-Fi part...

I agree with Frank on the notion that the future holds exciting new database models to
discover. I've always wondered about the merger of motion pictures (and now with DVD,
random access motion pictures), virtual reality (VR) and databases. Remember the "goal" of
the database: "To recall information". I can imagine a VR interface to database data, such
as Lawnmower Man movie kind of portrayed, where the user navigates to the targeted information
using the basic "human with world" interface(s). Whether it's voice recognition or just plain
old thought that formulates the "query", the end result is that the user recieves the
information requested.
Another slant I have, is the human brain itself. What a wonderful database! All kinds of input
sources, recall methods, fuzzy logic, and even "imagination". Imagination = make new data from
sometimes nothing, WOW! I know your saying, or at least I'm thinking... what about data integrity
and accuracy? The brain fails so often in this respect. Well my answer to that is: some data does
NOT have to be completely accurate. Let me give some examples. Any of us that have tables that
contain street addresses, most of the time do not care if the user typed in "123 Main Street" or
"123 Main Str.". Also, in some high volume DBMS COUNT() may produce inaccurate results. So do we
care about accuracy? Sometimes. The brain seems to figure this out for us pretty good. i.e. It
recalls accurately my wife's birthday (most of the time). Also seems to keep my heart beating
while I sleep, and has done this unfailingly, or at least to my satisfaction for many years.
It can also recall some thing with great accuracy such as anything times zero equals zero. We also
"know" things like a red traffic light means stop etc. These are "learned". Other things our brain
just knows on it's own. So I think data integrity and accuracy are not absolutes, more degrees of
suitability to the task at hand. There are many comparisons to be made between how our brain works
and how users want to use computer databases. I also think that accuracy and reliability can be
build into man-made databases that can overcome "flaws" that natural databases may have in them.
There is another "database" that is extreamly facinating... The DNA molecule and it's chromosomes.
Two "databses", combining to make a new, unique structure, and likely containing more data than
any of us ever deal with.
I know this is biological stuff, but the biological world is the only real place to look, outside
of our own human inventions, for things that are "self changing" or "alive".

I think the relational model will be used for business databases for quite sometime. Other
applications such as medical/scientific and entertainment will most likely use proprietary
database models. Only if they achieve "critical mass" (enough $$$$) would any of them become
mainstream. Relational databases will be used (and stretched) for tasks having little to do
with business data, because it is mainstream, and more resources are available to accomodate
the needs quickly. This my be close-minded on my part, but I think until computers operate
in a very different manner than they do today, the database models available to us will be
pretty much a form of what we using today, just much more advanced perhaps as time goes by.

One thing the relational data model does not do well, or not at all, is "analog" pattern matching.
Example Query: Name the people who are in the same photograph with me within the last year,
who are not relatives....etc. You get the picture (pun intended). Future database models might
handle stuff like this, and might even handle business data better than the relational model
does. Who knows? I think this type of database ability goes beyond "Type" support referenced
by Chris, and requires other/different database models.

Just my $.02

Once you understand the BITs, all the pieces come together
Frank Kalis
Frank Kalis
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42991 Visits: 289
Hi Thomas,

surely a little bit late for a reply, but here it goes.
Yes, the human brain is the most powerful database around. Curious how the indexes would look like.
Now as I have read the responses and thought over them for a while I'm glad that I cancelled my idea of writing an article about moving object databases. I think it would only lead to confusion here ...and after all it is not SQL Server related anyway.

Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/


You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum