|
|
|
Old 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
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Friday, May 17, 2013 8:10 AM
Points: 5,955,
Visits: 272
|
|
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/
|
|
|
|