data modeling

For projects of any scope, we can assist you in the creation of robust logical data models using Entity-Relationship (ER) or Object-Role Modeling (ORM) modeling techniques.  The logical data models will then become the basis for the engineering of the physical data model and, ultimately, your database.

We focus on using the natural language of the business users and existing artifacts (reports, forms, screen layouts, etc...) to define a relational database structure which accurately reflects and supports the needs of your business community now, and in the future. 

data management

Data modeling is just the start.  As part of a comprehensive data management strategy, data modeling becomes an extremely powerful and effective tool for improving software quality.  We can help you develop comprehensive and consistent data management policies, procedures and processes.  We will work with you to drive your software development processes from an architectural perspective, providing greater quality and consistency to your deliverables.

data integration

If yours is like most companies, you have a diverse mix of installed software and systems, some purchased, some custom-built, some old, some new.   Inconsistencies exist between similar data across these systems.  Different database technologies area used.  An enterprise view of your corporate data seems an impossible goal.

Let us show you how to 'put it all together'.  We can help you integrate critical data from disparate systems to achieve a coherent enterprise view for reporting, analysis and forecasting.

training & mentoring

We provide basic and advanced courses in data modeling, access modeling and database design.  It is important for your data management team to develop 'black belt' data modeling and database design skills.  It's also a great idea to train your business analysts in these skills since they will work with both business experts and data analysts.