With the proliferation of enterprise class applications such as ERP, CRM, SFA etc., development of grassroots applications is less commonplace. The industries deploying these enterprise applications
also benefit from the research and development that goes around these products and the resources available for such applications. On the other hand, with business innovations, new business models are
deployed requiring innovative business processes. These creative business processes require new ways to manage data for the organization. And IT departments for such industries are required to model
the data for these enterprise-class applications. IT managers also face at least two other scenarios that can generate the need to model data from ground zero:
- Technology refresh for legacy applications
- Consolidation due to mergers and acquisitions
These enterprise-class applications tend to have large data footprints, which require large-scale data models.
When IT faces such an immediate and large-scale data modeling task, IT managers have two options:
- Develop data models in-house
- Outsource a component or the entire project to a vendor.
Since data modeling requires significant business knowledge and is an extremely interactive process, IT managers favor the first option – in-house development. Business leaders are
required to market the products and/or services in a very short time frame. IT managers are challenged with aggressive deadlines and limited budgets. Missing dates or creating poor quality data
models can have disastrous effects on the business. Data architects and or modelers can certainly benefit from industry-proven strategies for executing large-scale data modeling projects. This
article is an introduction to those strategies that IT managers can find useful.
Strategy 1: Define data modeling standards up front.
model. Project leadership should also make sure that these standards are communicated in a timely manner to all team members and are followed by every team member.
Strategy 2: Train business analysts on the fundamentals of database design and data modeling techniques.
Business analysts are your stakeholders in the project. By training business analysts in the fundamentals of database design and data modeling techniques, you can eliminate the communication
barrier between the business subject-matter experts (SMEs) and data modelers. A short course in database technology and data modeling will also help establish a long-term productive relationship
between IT and business groups.
Strategy 3: Divide and conquer the entire task into sub-task centered on business areas.
but dividing the task into several teams allows you to achieve project deadlines for intermediate and final deliverables.
Strategy 4: Capture and store data architecture-related artifacts in relational format.
the data element lists into the modeling tool, you can jump-start the data modeling process. This strategy also ensures high-quality work products since manual data entry into the data modeling
tool is minimized.
Strategy 5: Use the database to QA the data models.
repetitive checks can be automated (e.g., audit column in tables such as CREATE_DATE is designed as mandatory column). First, you need to export the data model into relational tables and then write
and execute SQL statements to QA the model.
Strategy 6: Push modeling for all business areas through various stages simultaneously throughout the life cycle of the project.
being developed. By pushing all business areas through the stages (e.g., Ballpark, Conceptual, Logical and Physical) at the same time, the chief data architect can ensure the consistency across the
business areas. This strategy also helps the project manager in reporting progress and related release management issues.
Strategy 7: Follow release management process to manage changes made to the data models.
in the project life cycle. It will enable the chief data architect to answer why a change was made, who requested the change and when the change was actually implemented.
Strategy 8: Build data glossary up front using business terms and industry naming standards for data elements and data entities.
glossary at the early stages of the project will ensure that all teams that are developing different business area data models will adopt the same naming conventions.
Strategy 9: Use a data modeling tool that has a rich set of metadata exchange capabilities.
data modeling tool that follows industry standard XML format(s) to import and export metadata from its repository.
Strategy 10: Leverage industry-proven data model templates for business data concepts to jump-start the project.
data models available, data modelers can focus on the complex business data requirements.
Strategy 11: Actively manage the project’s scope.
application. In such cases, the data modelers face never-ending data requirements. The data modelers and the project manager should actively manage the scope of the data modeling effort throughout
the project life cycle.
Strategy 12: Work closely with the business users and business analysts throughout the project.
requirements and business rules are captured in the data model. The business users and the business analysts will reject the final product unless they are consulted along the way and feel like they
have invested something in its development.
Large-scale data modeling projects can be intense IT endeavors for new industries, and these projects can be intimidating for established ones. The strategies listed in this article can help the data
architects and lead data modelers get a good handle on the project. The strategies are technology/platform neutral and are crafted around people and processes involved. By following these simple and
proven strategies, data modelers can focus on the core task of – understanding and modeling data requirements. And IT managers can certainly improve the probability of success for such high