• ORM tools are here to stay, at least for a few years until the next big thing. So is Cloud. Both concepts spin the line that specialist skills at the database and operations layer are not needed. DBAs need to take this on board and work out how they can add value in this new paradigm, or risk being seen as no longer needed.

    That is not my understanding of both tools ORM passes primitive to the RDBMS without data relations and more important without DRI(declarative referential integrity). Cloud on the Microsoft platform at the moment is used for fast changing and disposable data. There is a company running one terabyte every three months PeopleSoft SQL Server such databases cannot be moved to the Cloud.

    ORM and Cloud will move forward by dealing with some low hanging fruit. Third-party applications where the customer has little ability to change anything are prime candidates for Cloud. Small scale apps where ORM database inefficiencies do not cause SLAs to be breached are also headed for the Cloud. This results in a large mass of applications that have a significantly lower development and operational cost than traditional 'optimised' applications, and businesses will be keen to see these cost savings across all applications.

    The two are not related Cloud may use ORM but ORM is also used in most object applications that are data intensive. I would also not say ORM affects application performance if there is a clean relational model in the application, and care is taken to make the relational model RDBMS vendor specific.

    The fact that some applications perform very poorly using the ORM model may become a driver for the business to find an alternative app that can get the Cloud and ORM savings, rather than be a reason for keeping the original application. This could be particularly true if the application is not essential to the main business profit drivers.

    IMHO database professionals need to focus on adding value to the key profit drivers, and how they can minimise costs for everything else. For many people, even finding out what drives their employer's profits will be something new, while others will already be working on these lines.

    The main problem with ORM is the concept of if a references b, b must exist is either not defined and in most cases application uses other convoluted ways to solve such problems.

    Kind regards,
    Gift Peddie