On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
|
|
400+ Course Offerings:
| DB2 for z/OS |
| DB2 for Linux, UNIX, Windows |
| Structured Query Language (SQL) |
| Java, Java EE, Frameworks and OO Design |
| Oracle |
| WebSphere MQ |
| CICS/TS |
| Mainframe - Assembler, COBOL, MVS/JCL, REXX, SAS |
| HTML, XML, Web Services and SOA |
| WebSphere Application Server |
| WebLogic |
| IMS |
| Linux |
| UNIX, C, C++ |
| PowerBuilder / InfoMaker |
| Microsoft - .NET, SharePoint, SQL Server |
| Project Management |
| Business Intelligence/Cognos |
|
|
DW1015 Advanced Data Modeling
|
|
|
|
Request a Course using our convenient on-line form, or Call 800.756.3000 to schedule a class in your area.
|
|
Full Course Description
|
| |
|
Duration |
4 Days |
|
Delivery Method |
Instructor Led, Hands-on Workshops |
|
Public Price |
$1950.00 | |
DESCRIPTION (Return to Top)
This workshop addresses all of the issues that trouble the experienced practicing data modeler:
- How far to abstract in the data model
- How to deal with time and history
- How to deal with complex business rules, how to represent entity life histories
- How to interrelate data and process models
- How to reconcile data modeling concepts with object oriented concepts.
This is a workshop and relies on realistic exercises. You will learn how to apply leading edge data modeling principles to practical and difficult modeling situations. All of the exercises have been derived from real modeling situations.
This workshop emphasizes three things: 1. analysis of business rules to develop detailed understanding of the business; 2. expression of these in the data model; and 3. the use of these to verify the entity model. The entity model must support process requirements, editing and validation constraints, and time considerations.
Two types of business rules are distinguished: static rules that are represented in associations among entities; and dynamic rules which represent processing requirements. Non-procedural techniques for expressing rules, triggers, and automatic actions are examined.
The workshop focuses especially on comprehensive transaction discovery, complex event histories, state transition and time dependent constraints. The concepts of entity life cycle and compatible conventions for their specifications are introduced. So too are various entity abstraction techniques. As much as possible business rules are expressed against the minimal piece of data to which they are applicable. This provides a leading-edge bases for object-based application analysis and database systems development.
AUDIENCE (Return to Top)
Data analysts, data administrator, database designers, system analysts and designers, and other practicing data modelers.
TOPICS (Return to Top)
- Review of Data Modeling
- Business Rules
- Creating Data Views
- Modeling Time and Change
- Abstraction in Data Modeling
- Inheritance Rules
- Flexibility in Models
- Different Kinds of Relationships
- Entity Life Histories
- Process Discovery Methods
- Model Reconciliation
- Object Orientation Review
- Data Design Compromises
- Summary and Conclusion
|
|
|
|
Copyright ©2013, Themis Inc. All Rights Reserved