Our Data modelling process is used to define and analyse data requirements needed to support the business processes within the scope of corresponding information systems in organizations. Therefore, the process of data modelling involves our team professional data modellers working closely with business stakeholders, as well as potential users of the information system. There are three different types of data models produced while progressing from requirements to the actual database to be used for the information system. The data requirements are initially recorded as a conceptual data model which is essentially a set of technology independent specifications about the data and is used to discuss initial requirements with the business stakeholders. The conceptual model is then translated into a logical data model, which documents structures of the data that can be implemented in databases. Implementation of one conceptual data model may require multiple logical data models. The last step in data modelling is transforming the logical data model to a physical data model that organizes the data into tables, and accounts for access, performance and storage details. Our Data model defines not just data elements, but their structures and relationships between them. Data modelling techniques and methodologies are used to model data in a standard, consistent, predictable manner in order to manage it as a resource. The use of data modelling standards is strongly recommended for all projects requiring a standard means of defining and analysing data within an organization, e.g., using data modelling:
- to manage data as a resource;
- for the integration of information systems;
- for designing databases/data warehouses (aka data repositories)
We perform data modelling during various types of projects and in multiple phases of projects. Data models are progressive; there is no such thing as the final data model for a business or application. We use two types of data modelling:
- Strategic data modelling: This is part of the creation of an information systems strategy, which defines an overall vision and architecture for information systems is defined. Information engineering is a methodology that embraces this approach.
- Data modelling during systems analysis: In systems analysis logical data models are created as part of the development of new databases.
We use data modelling for detailing business requirements for specific databases.
