Course Catalog

Information Modeling for Information Analysts

Database Design and Performance Tuning

Advanced Topics in Information Modeling

Training Rates


Scheduled Classes

If you are looking for the most effective information modeling training available, then contact us to schedule a class!

Did You Know?

We can tailor our presentations to fit your system development environment?  For example, our Information Modeling course can be presented in any of five different CASE tool dialects, and may be edited to suit the number of days you have available for training. These options come at no additional cost.

Gary Schuldt is also available for consulting projects. Please contact us for rates and schedules. 

 

 

 

 


Advanced Topics in Information Modeling

Overview of ADVIM: 3 Days

The Method

Information Modeling is an analysis method that defines and structures business information. A completed Information Model:

  • Shows the information architecture in terms of three components: entities, relationships, and attributes
  • Records the business rules that apply to each component
  • For the Information Systems Analyst, the primary uses of Information Modeling are:
  • Analyzing and defining business information in a structured manner
  • Specifying the requirements for a database in a conceptual business model which is free from implementation technology influence
  • The Syncretics Information Modeling approach includes the following features
  • E-R diagrams for first-cut modeling and graphic clarity
  • Structured natural language definitions and descriptions for each modeling component
  • Standard questions the analyst can use to elicit relevant business knowledge
  • Expert-style heuristics for handling common modeling patterns
  • Completeness and consistency rules for entities and relationships
  • Full-bodied relationships: n-ary, attribute-bearing, recursive
  • Full attribute definition, including derivables
  • Data structures in "entity-relationship normal form"
  • Basis for a performance-based Access Model
  • Directly translatable into a relational design
  • The Seminar

  • ADVIM-5 supplements the basic E-R discovery and representation techniques taught in Syncretics' Information Modeling workshop. The Advanced Topics cover extensions to the original Chen E-R model as well as some of the thornier practical problems which most experienced modelers have probably faced.
  • Examples of extensions treated include inheritance relationships (multi-typing, aggregation, and generalization), the object-oriented connection, leveling E-R models, .modeling of complex business policies using the "cross-component rule", and the seven deadly sins of the data analyst.
  • ADVIM-5 also presents ways of dealing with such common modeling problems as representing "create and delete" rules, modeling "time", learning from null-valued attributes, applying the five secrets of attribution, deciding what is and what isn't an entity (including sub-entities), the connections with other models (such as the process model, the event model, and the relational model), and modeling business rules.
  • Many organizations are beginning to realize that they must learn to share business data, both its values as well as its definitions, among their various business units. ADVIM-5 presents a model for Data Integration and explains the eight essential ingredients for making it work in your organization.
  • The material in ADVIM-5 draws upon the expertise of Gary Schuldt, who has been active in the field of database development doing teaching, consulting, building courses, and creating and extending data modeling methods for the past 20 years. Many attendees find the chapter on "Breaking The Rules!", drawn from Mr. Schuldt's extensive experience, to be especially valuable.
  • ADVIM-5 is conducted mainly in a fast-paced lecture format. Participants are expected to be experienced practitioners of data analysis and are encouraged to share their own data modeling problems and solutions to the seminar.
  • Attendance is limited to 30 people.

    Instructional Objectives

    • The seminar is designed to alert the attendees to new ideas, to challenge and deepen their knowledge of familiar ones, and to common solutions to thorny data modeling problems. The course is designed to serve the higher goal of helping the attendee to build useful Information Models better and faster.

    Who Should Attend

    The seminar is primarily directed toward experienced data modelers who have worked with the E-R-style of Information Modeling:

  • Information Systems Analysts who analyze and organize business data for business reengineering and expanding computer-based support
  • Database Analysts who specify the requirements for a database to support some area of business
  • Applications Analysts who need a data-oriented modeling method to complement process or function-oriented methods such as Structured Analysis
  • Business Users who are interested in improving the business as well as assisting in defining requirements and preparing specifications for an Information System
  • The seminar will also serve the needs of:

  • Database Designers who need a reading knowledge of the Information Model in order to transform it accurately into a workable database design
  • Data Administrators for whom an Information Model can function as a dictionary-like definition of the data resource they must manage
  • Methodologists who must integrate Information Modeling into an existing methodological framework
  • CASE tool specialists who provide automated support for system development

  • Materials

    Each participant will receive a copy of the seminar visuals (about 180 pages).

    Core Topics

    Section I

    A. Introduction and Perspective

    B. Data Modeling Paradigms

    C. Connections to Other Models

    D. The Natural Language Connections

    E. Inheritance Relationships

    F. The Essence of an Entity

    G. Seven Deadly Sins of the Data Analyst

    H. Sub-entities

    I. Leveling E-R Models

    J. Event Modeling and Entity Life Histories

    K. Breaking the Rules!

    L. Relationships

    M. Information Modeling and the Object-Oriented Viewpoint

    N. Flexible Models

    O. The Importance of Being "Useful"

    Z. Attendees' Modeling Issues

    Section 2

    A. The "Business Rule" Paradigm

    B. Metaphors for the Analyst

    C. Data Integration

    D. Walk-thru Techniques

    E. Statistical Data in the Information Model

    F. Modeling "Time"

    G. Cross-Component Rules

    H. Create and Delete Rules

    I. Null-Valued Attributes

    J. More on Attributes

    K. Nested Relations

    L. Dependent Entities

    M. Shortcuts

    N. Performance Tuning

    P. The Kitchen Sink!

    O. References

    Go back to the top

     

    About...  |  Curriculum  |  News  |  Raves  |  Site Map 

    1335 Pear Street NE, Olympia, WA 98506-3945 U.S.A.
    telephone: 360/754-1261
     fax: 360/754-9769
     e-mail: information@syncretics.com

    © 2000-2003  Syncretics.  All rights reserved.