Instead of a dead end, Linq presents opportunities for sql experts. My comment orginally appeared in the www.sqlblog.com post: 'Continuing Industry Consolidation and Other Trends.' 1/16/08 by Kevin Kline http://tinyurl.com/5opxlz I think the Sun acquisition of MySql was a checkmate move. It was Oracle that attempted to slow down MySql with their acquisition of the InnoDB transaction engine. Now they have been paid back in spades. Now it's Sun vs. MS in a new competition for the minds and hearts of developers. The broad view is LINQ/net and Sql Server vs. java and MySql. This is not about databases per se but a new war based on the object/entity model inspired by LINQ. I don't see IBM and Oracle in this war. They will have to be content to battle amongst themselves in the old database wars. (I'll come back to LINQ:) As for 'Checking out the Competition' of course I too applaud Linchi. But honestly we're first 'now' recognizing the advantages of eyes wide open?:) This attitude should be a given for a professional. Perhaps better late than never, perhaps an airing of cheerleading vs.reality checking:) For most ansi features that MS has pre-annouced all one has to do to study them is read about them in Oracle or DB2 documentation (ie. OVER). And as Linchi pointed out it often goes the opposite direction for other types of features. This attitude contributes to the great divides that are common in the industry. And now we come to the 'dead-end routes' like LINQ. I take the opposite view you do. There's a compelling case to be made (I've commented on this matter on this site) that if there is a deadweight MS sees sql as it. LINQ is not just a piece of new technology, it's not just a local variable, it's a global one. LINQ is both an affirmation of the runtime environment for 'all' application development using an object model and a rejection of the sql interface. MS can live with the physical file structure (the idea of relational data, rows and columns) but they don't want to live with the sql interface for application development. MS explains this global move in terms of solving the historic impedance mismatch between two completely different environments. And they have picked their winner and at the same time the loser. The rows and columns abstraction now ends at physical storage. The object abstraction and LINQ will take up everything else. Sql server is now something quite different than it used to be. Almost all developmental changes in server will be based on servicing objects and quite probably at the expense of features associated with a furtherance of the relational model. Look at all the work on partitioned views in S2008. This lies at the heart of how LINQ will translate entity updates. LINQ is still in its enfancy. I would expect it to appear to many just like sql did when it was intially introduced in the early eighties. It will take time to get the matured version. What is truely ironic is I see no real argument in the sql community that LINQ represents a great opportunity for sql developers. MS is inventing a declarative language in the spirit of sql. Don't people see an opportunity to jump in and at least influence the design of the language? Or get involved in the LINQ translation/optimizations to sql. Over time as MS integrates LINQ deeper into server (returning entities) I can assure you the current translations will change:) Sql was most certainly not an implementation of the relational model. So sql folks shouldn't get hung up over this. The relational model would require the same strong typed runtime as net but MS is certainly not going there. But they are going to a place that sql skills can be used. And now Sun is going to go along with them. It's actually a small world if your eyes are open:)
Dataphor SQL RAC (Relational Application Companion)
A site of hope for those looking for a true relational database system
- a one-one requirement constraint with dataphor (1)
- anatomy of sql server part I - what is a stored procedure (1)
- anatomy of sql server part II - the unit test as part of the database (1)
- anatomy of sql server part III - what does deferred name resolution really mean (1)
- censoring sql posts (1)
- creating an opposite constraint in dataphor (1)
- dataphor (2)
- Dataphor (7)
- dataphor # 13 a table as a parameter (1)
- dataphor - download and start working with it (1)
- dataphor - fixed sized word segments (1)
- dataphor # 10 sql mythology (1)
- dataphor # 11 string differences (1)
- dataphor # 12 trimming a string (1)
- dataphor # 14 sql the meaning of Update..From (1)
- dataphor # 15 views with substance (1)
- dataphor # 16 inclusive vs exclusive solutions (1)
- dataphor # 17 a visual look at ranking queries (1)
- dataphor # 18 data scrubbing using lists (1)
- dataphor # 19 create intervals over strings (1)
- dataphor # 20 browsing an sql window (1)
- dataphor # 21 an example of relational division (1)
- dataphor # 22 reusable procedures (1)
- dataphor # 23 repley to Michel (1)
- dataphor # 24 basics of the table type (1)
- dataphor # 25 extending the dense rank function (1)
- dataphor # 26 query a hierarchy with explode (1)
- dataphor # 27 combine strings with Split and Concat (1)
- dataphor # 28 constants and variables or sql and D4 (1)
- dataphor # 29 another example of relational division (1)
- dataphor #1 introduction (1)
- dataphor #2 splitting strings (1)
- dataphor #3 string concatenation (1)
- dataphor #4 comment (1)
- dataphor #5 comment (1)
- dataphor #6 formal definition (1)
- dataphor #7 sql: table this (1)
- dataphor #8 list to table (1)
- dataphor #9 table constraints (1)
- dataphor creating lists in a query (1)
- extracting numbers from a string with dataphor (1)
- jeff modens dynamic crosstabs for sql server (1)
- linq to sql the what and why (1)
- linq to sql as a window of opportunity to sql users (1)
- linq to sql should be important to sql users (1)
- linq to sql vs. older 4GL attempts (1)
- listing missing table item (1)
- Multiple cascade paths to the same table (1)
- RAC (4)
- RAC #1 comment (1)
- RAC #2 example (1)
- RAC #3 finding the Nth number in a string (1)
- RAC #4 Sql Server 2005 ranking functions vs. Rac ranking (1)
- sorting a delimited string by its numerical string parts (1)
- sql an example of extreme implicit conversions (1)
- sql can't handle complicated cascading updates (1)
- sql CTE should be a variable not a value (1)
- sql dense rank for identifying consecutive runs (1)
- sql is there really a table variable (1)
- sql ranking functions explained by relational types (1)
- sql server triggers are best set based (1)
- sql the idea of using substring to simulate lists (1)
- sql the undefined trigger in Sql Server (1)
- sql vs relational on tables (1)
- sql what the sql CTE covers up (1)
- types and procedures (1)
Tuesday, November 25, 2008
Linq to Sql as an opportunity to sql users
Subscribe to:
Post Comments (Atom)
5 comments:
This is my first time pay a visit at here and i am in fact impressed to read all at
single place.
Also visit my web-site オークリー激安
Hello, I enjoy reading through your article post.
I wanted to write a little comment to support you.
Here is my webpage オークリーメガネ
Nice post. I was checking continuously this blog and I am impressed!
Extremely useful info particularly the last part :) I care for such information much.
I was seeking this certain information for a very long time.
Thank you and good luck.
My web site ... オークリーメガネ
Hi! I know this is kind of off topic but I was wondering which blog platform are you using for this website?
I'm getting sick and tired of Wordpress because I've had problems with hackers and I'm looking at options for another platform. I would be fantastic if you could point me in the direction of a good platform.
Also visit my site; オークリー
Very good blog! Do you have any hints for aspiring writers?
I'm hoping to start my own site soon but I'm a little lost on everything.
Would you propose starting with a free platform like Wordpress or go
for a paid option? There are so many options out there that I'm completely overwhelmed .. Any suggestions? Thank you!
my website ... レイバンサングラス
Post a Comment