Lionsgate Software has earned extensive experiences on numerous data architectural design and data modeling projects in many years practices. Our consultants achieved both logical and physical data modeling for 10+ large projects, each has more than 3 modules, one of them contains 6 modules with 600+ tables.
Our 48-page thesis on how to build a database-driven web application discussed how to build a structured, large scale and portable system.
We do both relational and spatial (ESRI ArcGIS-based) data architectural design.
Our toolbox includes tools like CA ERWin, MS Visio (with ESRI spatial extension) and Visual Paradigm, etc. With these tools and our rich experiences, we may implement either ER diagram or UML diagram, based on the specific project needs. In short, in data architectural design area, we do:
- Conceptual, logical and physical data modeling;
- Relational and spatial (ESRI ArcGIS-based) data modeling;
- Database-driven application architectural design;
- ER diagram or UML diagram;
- ERD-UML two-way conversion (to gain benefits from OOD).
We have proven track records in this field, with a long list of renowned clients in both public and private sectors. We clearly know how to help our client design a database schema that lasts for years with below features:
- Modular-based, well-structured;
- Naming-convention applied;
- Well design to avoid performance bottleneck for BI;
- Transaction tracking design;
- Easy to understand and manage (privileges, changes, etc).
Here are some of data architectural design and data modeling projects that were achieved by us:
|Location||Project / Module||Tool||Diagram||Client|
|BC, CA||EPIC (Energy Planning Info Central)||VP SDE||UML||BCHydro|
|BC, CA||MMR - Materials Management Reporting, Data Warehouse||VP SDE||UML||BCHydro|
|AB, CA||SIS (Silviculture Information System)||ERWin||ERD||AP|
|AB, CA||OPS (Operation Planning System)||ERWin||ERD||Alpac|
|BC, CA||Block, Road, Silviculture||Visio*||UML||MoF|
|BC, CA||Block, Road, Planning||Visio*||UML||WFM|
|AB, CA||Silviculture, Planning, Scheduling, Block, Road, Survey||Visio*||UML||Alpac|
|ON, CA||Block, Road, Silviculture,||Visio*||UML||Tembec|
|WA, US||Block, Road||Visio*||UML||Rayonier|
|BC, CA||Block, Road, Silviculture||Visio*||UML||CL|
|BC, CA||SIS (Silviculture Information System)||ERWin||ERD||BRL|
|MB, CA||Block, Road, Silviculture||Visio*||UML||Prov. MB|
- Visio (with ESRI ArcGIS modeling plugin or forward engineering plugin)
- Visual Paradigm (Eclipse plugin)