According to CA its ERwin Data Modeler for Microsoft SQL Azure enables customers to make fact-based decisions about which data to move to the cloud and which to keep on premise, allowing them to: create an inventory of data assets, including both cloud and on-premise databases, using a single visual interface; migrate from on-premise databases, such as Microsoft SQL Server, to cloud-based databases, such as Microsoft SQL Azure; and maintain their cloud-based databases using a familiar desktop data modelling
paradigm, eliminating the need for specialised skills or training.
Data modelling as a discipline came into being in the 1970s and applied both to logical data constructs and the then new physical databases.
Systems such as SAP[TM] and Seibel[TM] software were introduced, but organisations often neglected data modelling alongside these applications, assuming the packages were enough to streamline all the data they needed.
Whereas new systems provide enterprises with all the detailed transactional data they need, data modelling is still essential to control, communicate and define that data within organisations.
Data modelling brings an overview of a company and shows data overlaps, allowing the whole of the company's data to be seen at one point in time.
Management of data in reporting systems must be subject to effective data modelling to give correct definitions and show consistent approaches.
Without added data modelling in SOA, the definition and context of data may not always align correctly.
The use of data modelling alongside even the newest of data management systems upholds a basic principle: that the basics of data modelling are still fundamental to data management.
In addition, Analytic Framework can be used by customer and business focused staff without data modelling
experience unlike traditional modelling systems that require the user to have a high degree of technical knowledge, KXEN says.
is no longer simply a mechanism to create new data structures--it is an integral part of analysing and deconstructing information.
New features include a new 'Fix-it' option that allows designers to debug errors together with new reviews, including business process modelling and data modelling
. Reviewer 2.0 supports end-to-end reviewing throughout the design life cycle and features over 25 new reviews such as naming standards, missing primary keys and unapproved data types.