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 ]
"If someone asks you to do something you don't know how to, don't tell I don't know, tell I can learn instead." - Myself
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.