Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
start [2013/09/12 10:08] gpaffel |
start [2013/09/13 10:27] gpaffel |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| **Property and Casualty Data Model – OMG Approved Submission** | **Property and Casualty Data Model – OMG Approved Submission** | ||
| - | * Adobe Acrobat Publication ({{13-04-04 P&C Data Model Submission.pdf}}) - read the background, requirements and Guidelines & Standards, and view the ‘print’ version of the Models in a Conceptual model and 14 subject areas in Logical and Physical views, with definitions and a Glossary | + | * Adobe Acrobat Publication ({{13-04-04 P&C Data Model Submission.pdf}}) - read the background, requirements and Guidelines & Standards, and view the ‘print’ version of the Models in a Conceptual model and 14 subject areas in Logical and Physical views, with definitions and a Glossary (269 pages). |
| + | **P&C Data Model Documents Imbedded or Illustrated in the Submission. 1st Time viewers may want to open first four documents before opening the Full Submission** | ||
| + | * Word Publication ({{13-04-08 P&C Conceptual Data Model Overview.docx}}) – view the high-level data model identifying major entities and relationships of importance to the P&C business. | ||
| + | |||
| + | * PowerPoint Presentation ({{13-04-12 P&C Data Model C-L-P Diagrams.pptx}}) - Summary with the Conceptual Model Entity Level overview followed by the major subject areas in Entity Level, Logical and Physical views. | ||
| - | **P&C Data Model Documents Imbedded in the Submission** | ||
| * Excel Publication ({{13-04-07 P&C Data Model Glossary of Terms.xlsx}}) – view the key definition of insurance and data model terms that are relevant to the Data Model. | * Excel Publication ({{13-04-07 P&C Data Model Glossary of Terms.xlsx}}) – view the key definition of insurance and data model terms that are relevant to the Data Model. | ||
| - | * Word Publication ({{13-04-08 P&C Conceptual Data Model Overview.docx}}) – view the high-level data model identifying major entities and relationships of importance to the P&C business. | + | * HTML Model View ({{13-04-09 P&C Logical Data Model R1.0 Web Pub v4.zip}}) - For readers without ERwin to view the data model diagrams and definitions in a browser. __This is a true zip file__; download __and__ "Extract all files", and then click on the 1st file in the folder to run the Table of Contents browser: **~P&C LDM Web Pub Table of Contents.htm** in Internet Explorer or your default browser. |
| - | + | ||
| - | * XML Definition ({{P&C LDM R1.0.xml.zip}}) - data model definition in standard technical interchange XML, useable for import into other tools | + | |
| * ERwin Definition ({{13-04-10 P&C Logical Data Model R1.0 ERwin R7.3.11.erwin.zip}}) – view the Logical representation of the data models definition in the data modeling tool, ERwin, for users of this tool. | * ERwin Definition ({{13-04-10 P&C Logical Data Model R1.0 ERwin R7.3.11.erwin.zip}}) – view the Logical representation of the data models definition in the data modeling tool, ERwin, for users of this tool. | ||
| - | * Excel Workbook ({{13-04-11 P&C Logical Data Model Workbook.xlsx}}) - view, sort, lookup, compare the Logical data model object definitions presented in a set of Excel spreadsheets | + | * Excel Workbook ({{13-04-11 P&C Logical Data Model Workbook.xlsx}}) - view, sort, lookup, compare the Logical data model object definitions presented in a set of Excel spreadsheets. |
| * ERwin Definition ({{13-04-13 P&C Physical Data Model R1.0 ERwin R7.3.11 SQL-Server.erwin.zip}}) - view the Physical representation of the data models definition in the data modeling tool, ERwin, for users of this tool. | * ERwin Definition ({{13-04-13 P&C Physical Data Model R1.0 ERwin R7.3.11 SQL-Server.erwin.zip}}) - view the Physical representation of the data models definition in the data modeling tool, ERwin, for users of this tool. | ||
| - | * Excel Workbook ({{13-04-14 P&C Physical Data Model Workbook.xlsx}}) - view, sort, lookup, compare the Physical data model object definitions presented in a set of Excel spreadsheets | + | * Excel Workbook ({{13-04-14 P&C Physical Data Model Workbook.xlsx}}) - view, sort, lookup, compare the Physical data model object definitions presented in a set of Excel spreadsheets. |
| + | |||
| + | * DDL File ({{13-04-15 P&C Physical Data Model DDL SQL Server.ddl.zip}}) – Open and view the models as a Data Definition Language file. | ||
| + | |||
| + | * XML Definition ({{13-04-06 P&C LDM R1.0.xml.zip}}) - Logical data model definition in standard technical interchange XML, useable for import into other tools. | ||
| - | * DDL File ({{13-04-15 P&C Physical Data Model DDL SQL Server.ddl.zip}}) – Open and view the models as a Data Definition Language file | ||
| + | **NOTE: Other than the HTML file, Open -__Save Files__ with the ".zip" extension then rename and remove the .zip as these are __not__ Zipped files. Security will not allow 'native-named' .erwin, .xml or .ddl files to be downloaded.** | ||
| - | **NOTE: Open-__Save Files__ with the ".zip" extension then rename and remove the .zip as these are __not__ Zipped files. Security will not allow 'native-named' .erwin, .xml or .ddl files to be downloaded.** | ||
