Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

An Introduction to Database Models Expand / Collapse
Author
Message
Posted Tuesday, February 17, 2004 12:11 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 29, 2005 2:31 PM
Points: 393, 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
today.

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
Post #100812
Posted Saturday, February 28, 2004 2:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:36 AM
Points: 5,956, Visits: 286
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/
Post #103181
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse