1 / 9

Rational System Architect Unpacked 24 November 2010

Rational System Architect Unpacked 24 November 2010. Brian Stacey. Agenda. Introduction Database structure Queries Reports. Introduction. Encyclopaedias Microsoft SQL Server Database design. Database design. Classes. Database Structure. Query.

aman
Download Presentation

Rational System Architect Unpacked 24 November 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Rational System ArchitectUnpacked24 November 2010 Brian Stacey

  2. Agenda • Introduction • Database structure • Queries • Reports

  3. Introduction • Encyclopaedias • Microsoft SQL Server • Database design

  4. Database design

  5. Classes

  6. Database Structure

  7. Query • SELECT [Audit],[ID],M.[Name] AS TypeName, E.[Name] • FROM [Entity] E JOIN [Metadata] M • ON E.[Class] = M.[Class] AND E.[Type]= M.[Type] • WHERE E.[Class] = 3 AND E.[Type]= 321

  8. Report: Definition Entities

  9. Shortprops – Entity: Human Resources • [[[GUID]]] 1ed22b9b-b83c-44a4-94f3-00667ffbcf16 [[[Initial Date]]] 20090530 [[[Initial Time]]] 083006 [[[Initial Audit]]] demo [[[In Service Date]]] 20010101 [[[Roles within Unit]]] "HR Director" [[[Description]]] This is a system architect definition. In system architect, you can create new definition types, as well as define you own diagrams. The definitions, once created, may be reused across the entire project, and reported against. A complete history trail is captured for each change, as well as the audit history. The definitions may capture information about Goals, Systems, Applications, Data, or Technolgoy Standards. Linked together, reporting can be done to show impact analysis. [[[Last Change Date]]] 20090607 [[[Last Change Time]]] 054948 [[[Last Change Audit]]] demo

More Related