What do you think will become the next coming SQL trends ?

[Edisandro Bessa]

Hi Lynn,

Over the years we have seen a bunch of technologies and tools related to database modeling/development such as stored procedures, triggers, views, datawarehousing, geografical data gathering, fine grained cubes, OLAP, MOLAP, HOLAP ... bla bla bla ... which are very helpful for us on these days.

Even considering the recent days, there is still so much effort to become what is already better in something so much better, for example, the recent Java EJB3 specs which allow developers to construct queries from within their applications by solely using Java objects as they are used to do on database tables thru native SQL.

Still on Java arena, there is the JPA technology which controls behind the scenes all aspects of database transactions commonly handled manually by developers in old days.

So, we can see trends where community efforts are aimed to isolate developers from very proprietary SQL and tunning, or at least, reduce the need of developer involviment on very low details of SQL programming.

What do you think about that ? As an expert, what do you think we are gonna see over next years on SQL arena?

Best Regards,
Edisandro Bessa.
[ October 16, 2007: Message edited by: Bear Bibeault ]

[Lynn Beighley]

Edisandro,
This is a very good question, and a very tough one, and one that I need to give some thought to to answer. I'd be very interested to hear what others on this board think...

[Jeanne Boyarsky]

Edisandro,
I think we will see expansion of existing functionality. For example, the latest versions of most databases support XPath and XML. I think we will see more use of this over the next few years.