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


A Brief History of SQL


A Brief History of SQL

Author
Message
gundapaneni
gundapaneni
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 1
Good one. In recent days I heard about Hirarchial Databases. What about them? Have they released??

madhusudannaidugundapaneni


Madhu
Frank Kalis
Frank Kalis
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32511 Visits: 289
quote:

Good one. In recent days I heard about Hirarchial Databases. What about them? Have they released??


The hiearchical database model is somewhat older than the relational model. I think the most prominent system is IBM's IMS which (still) runs on older mainframe systems. With the evolution of object-relational or object-oriented DBMS this model has some kind of revival.
If you could wait some time, I've finished an article on this topic in german. Needs only to be translated to english. Then fine-tuned and hopefully published.

Frank
http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Antares686
Antares686
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: Moderators
Points: 44630 Visits: 803
quote:

quote:

What do you think of his GRID computing?


I will say, I'll answer this very carefully.
AFAIK GRID computing is like having a single, large virtual computer.
I'm really not sure what to think of this whole 'unifying thing', although the intention is honorable.


The recent articles on it left me thinking it is nothing more than load balancing on a cluster style system with replication between node networks.

The problem I see is that all my encounters with Oracle replication methods means a large possibility for many gaps in data and lags in processing. Our problem management system is on Oralce and the replication has been known to replicate everything but a handdull of records which magicly appear days later.



Frank Kalis
Frank Kalis
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32511 Visits: 289
quote:

The problem I see is that all my encounters with Oracle replication methods means a large possibility for many gaps in data and lags in processing. Our problem management system is on Oralce and the replication has been known to replicate everything but a handdull of records which magicly appear days later.


Do you think Oracle has this one weakness


Frank
http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Antares686
Antares686
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: Moderators
Points: 44630 Visits: 803
quote:

Do you think Oracle has this one weakness



No it has more, thankfully thou there are a lot of third party apps and oracle addons you can pay large sums for to fix these. However looking at what they are planning for next release EM they may be finally stepping up to the plate with quality.



Frank Kalis
Frank Kalis
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32511 Visits: 289
Just wanted to add a link to a resource that most authors refer to as not (fully) available online.

A Relational Model of Data for Large Shared Data Banks by E. F. Codd
http://www.acm.org/classics/nov95/toc.html

I think this is the full text.

For those who are interested.

Frank
http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
MUHAMED NIYAS CHELADATHIL
MUHAMED NIYAS CHELADATHIL
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 1
Wonderful article. I was searching for a article like this for long time.
Great work. Congrats

CM Niyas
Mike Anderson
Mike Anderson
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 1

I felt the content was interesting. It sure would have benefitted from a good proofreading however. One more example of shoddy publication.


jvg
jvg
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 1

I liked the article. It was easy to understand, so I don't think any typos got in the way. Even Frank's signature was intriguing:


"Frank Wenn Englisch zu schwierig ist?"
So I took a look at the site (http://www.insidesql.de). Frank, judging by the first sentence, German doesn't seem to be very different from English:


"Hier finden Sie zahlreiche Artikel, FAQs, Links, Tips und Tricks rund um den Microsoft SQL Server."





valko
valko
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 Visits: 1

nice article but something is missing:

From Wikipedia, the free encyclopedia.

"Sybase SQL Server" was the name of Sybase Corporation's relational database product.

It was originally created for UNIX platforms in 1987. In 1988, SQL Server for OS/2 was codeveloped for the PC by Sybase, Microsoft, and Ashton-Tate. Ashton-Tate divested its interest and Microsoft became the lead partner after porting SQL Server to MS Windows NT.

Microsoft and Sybase sold and supported the product through version 4.21. In 1993 the codevelopment licensing agreement between Microsoft and Sybase ended and the companies parted ways.

In 1995, Sybase released SQL Server 11.0. Thereafter, it decided to better differentiate its product from Microsoft SQL Server by renaming it to Adaptive Server Enterprise in versions 11.5 and beyond.

Further History... Sybase was founded by Bob Epstein, the architect of a product called the Intelligent Database Machine (IDM) from Britton-Lee. This was a computer that only did relational database. It used IDL as its native language (similar but not identical to SQL). The architecture of that product was used as the starting point for Sybase, which began development from 1984(?). Beta testing of Sybase's first product started in 1986.





Go


Permissions

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







































































































































































SQLServerCentral


Search