A Universal Approach To Integration Using UNIVERSAL DATA .

2y ago
40 Views
3 Downloads
244.00 KB
22 Pages
Last View : Today
Last Download : 2m ago
Upload by : Kelvin Chao
Transcription

A Universal Approach to IntegrationUsingUNIVERSAL DATA MODELSProprietary information of Universal Data Models, LLC1

“No (person) is an island,entire of itself;every (person) is a piece of thecontinent, a part of the main”John, Donne, English poet (1572-1631)Proprietary information of Universal Data Models, LLC2

AgendaWhat are Universal Data Models?n The need for Universal Data Modelsn Examples of Universal Data Modelsn How Universal Data Models can be usedn Application of Universal Data modelsnProprietary information of Universal Data Models, LLC3

What are Universal Data Models?nBest practice, template data models–nIntegrated data structures–nGenerally applicable to most enterprisesIllustrating broad way to view data relationshipsCommon ways to model information for:–General constructsn E.G.people, organizations, contact info, demographics,products, orders, shipments, invoicing, budgeting, accounting–Various industriesn E.G.,manufacturing, telecommunications, financial, travel,e-commerce, insurance, government,Proprietary information of Universal Data Models, LLC4

Why Universal Data Models?Why re-invent the wheel?n Why make the same mistakes?n Need a common language for storing andpassing informationn Need proven structures that have beenthrough several iterationsn Need integrated perspectiven Need to produce business value!nProprietary information of Universal Data Models, LLC5

A Practical Solutionn“Universal Data Models”–––––Common, re-usable data structuresFacilitates common understanding of dataProven models for production systems60% of common constructs applySaves time and increases qualityProprietary information of Universal Data Models, LLC6

Examples of Universal Data ModelsProprietary information of Universal Data Models, LLC7

People, Organizations, Parties and RolesStoring information about a party once!PARTY ROLE# PARTY ID# ROLE TYPE ID* FROM DATEo THRU DATECUSTOMERBILL TO CUSTOMERo CREDIT RATINGORGANIZATION ROLEPERSON ROLESHIP TO CUSTOMERCUSTOMER CONTACTSUPPLIEREND USER CUSTOMERSUPPLIER CONTACTPARTNERPLACING ROSPECTWEB VISITOR acting asPARTY# PARTY IDPERSONo CURRENT LAST NAMEo CURRENT FIRST NAMEORGANIZATIONo NAMEProprietary information of Universal Data Models, LLC8

Integrated party data for governmentORGANIZATION ROLEORGANIZATION ROLETERRORIST ORGANIZATIONPARTY ROLE# PARTY ID# ROLE TYPE ID# FROM DATEo THRU DATENATIONGOVERNMENT AGENCYPERSON ROLEWATCH LIST SUSPECTCRIMINALFELONORGANIZATION MEMBERCOMMERCIAL ENTERPRISETRANSPORTATIONAIRLINES CARGOENTERPRISEFINANCIAL BANK OTHER OTHER PERSON ROLEORGANIZATION UNITDEPARTMENT DIVISIONSUBSIDIARYREGULATORY AGENCYOTHERORGPARENT ORG UNITOTHER ORGANIZATION ROLEfor acting asPARTY# PARTY IDPERSONo CURRENT FIRST NAMEo CURRENT LAST NAMEo SOCIAL SECURITY NUMBERORGANIZATION* NAMEo FEDERAL TAX ID NUMBERProprietary information of Universal Data Models, LLC9

Imagine knowing all communicationevents for a party together!COMMUNICATION EVENTEVENTCORRESPONDENCE# EVENT IDo FROM DATETIMETELE-COMMUNICATIONo THRU DATETIMEo NOTEINTERNET COMMUNICATIONIN-PERSON COMMUNICATIONOTHER COMMUNICATION EVENTTRANSACTION EVENTFINANCIAL TRANSACTIONTRANSPORTATION TRANSACTIONCRIMINAL TRANSACTIONSUSPICIOUS ACTIVITYLICENSING TRANSACTIONOTHER TRANSACTION EVENTEVENT ROLE# FROM DATEo THRU DATEPARTY# PARTY IDPERSONo CURRENT FIRST NAMEo CURRENT LAST NAMEo SOCIAL SECURITY NUMBERORGANIZATION* NAMEo FEDERAL TAX ID NUMBERProprietary information of Universal Data Models, LLC10

Getting a Complete Picture!All Activity for a Party!PARTYCOMMUNICATIONEVENT IPMENTORDERITEMSHIPMENTITEMWORK EFFORTROLEWORK ENTPAYMENTAPPLICATIONGENERAL NSACTIONDETAILPRODUCTProprietary information of Universal Data Models, LLC11

How can these models be used?nCommon language to communicate––Within an enterpriseAcross enterprisesCommon data structures to either store orpass informationn Overall data management – same datastructures used across applicationsn Jump-start database design effortsn Jump-start data warehousing effortsnProprietary information of Universal Data Models, LLC12

Application vendors beginning touse PARTY modelnnnnSiebel 7.5 logical data model– Has PARTY and PARTY RELATIONSHIP constructOracle Financials 11i– Uses PARTY and PARTY RELATIONSHIP constructPeoplesoft’s latest version– Uses PARTY and PARTY RELATIONSHIP constructsJD Edwards– Uses Address Book concept – very similar to PARTYProprietary information of Universal Data Models, LLC13

Application of Universal Data ModelsnGovernment––nIntegrated information for counter-terrorismSharing government information forefficienciesCorporate––CRM - relationship developmentManaging enterprise data as a corporateresourceProprietary information of Universal Data Models, LLC14

Terrorism: A Call for IntegrationnTerrorism:feeds on fear and disorganizationnIntegrated data is a key– Forexample, an integrated Govt databasenNationalleaders focused on integrationnTerrorist Research Center– Mostcrucial defenseis current andaccurate informationProprietary information of Universal Data Models, LLC15

Is Our Government Sharing Information?n FBI–2Watchlist Info not sharedhijackers were on this listn Immigration–2not available to airlineshijackers had overstayed visasn Leaderhave commented that information is indozens of different databases (or more)n Data not shared between FBI, CIA, NSA, INS, localenforcement, and moren Many efforts underway– ForeignTerrorist Tracking Task Force established to helpProprietary information of Universal Data Models, LLC16

Common National Data ModelData model for common understanding.n How can agencies share if their data is sodifferent?n Sharing of people and organization profilesn Key entitiesn–PARTY, PARTY ROLE, PARTYRELATIONSHIP, EVENTProprietary information of Universal Data Models, LLC17

Possible Common National Data ModelPARTY ION ROLEPERSON ROLEWATCH LISTSUSPECTTERRORISTORGANIZATIONGOVTAGENCY NATIONtoin CRIMINALFELONinGOVERNMENTAGENCYWATCH LISTSUSPECTIMMIGRANTfor acting asPARTY# PARTY IDAIRLINES CARGOORGANIZATIONMEMBERSHIPof inthe context forwithin the context ofROLE TYPEEVENTinof forinCOMMUNICATION EVENTEVENTfor ROLETRANSACTION EVENTinvolving PERSONORGANIZATIONfrom NATIONALAFFILIATIONCOMMERCIALENTERPRISE ORGANIZATIONMEMBERProprietary information of Universal Data Models, LLC18

Universal Data Models Appliedfor Commercial EnterprisesProprietary information of Universal Data Models, LLC19

Data Architectureused at RATIONOTHERDATADATAISSUESSYNCHRONIZATION, INTEGRATIONDataStewardsINFORMATIONDIRECTORY1 COMMON,INTEGRATED DATABASEBASED UPONUNIVERSAL DATA MODELSDATA MARTSHR ARTY RELATIONSHIPWEB INTRANET DATAWAREHOUSEPARTY ROLEPARTY Proprietary information of Universal Data Models, LLCFOR ANALYSIS20

Manufacturing enterpriseUsed Virtual Enterprise Data TIONINTEGRATION LAYER,INFORMATIONDIRECTORYBASED UPONUNIVERSAL DATA MODELSSynchronizedcustomer andResolutions of product infodata issuesn Universalmethod forpassing infonOTHERDATASTORESDATA ISSUESDataStewardsProprietary information of Universal Data Models, LLC21

Questions?nUniversal Data univdata.comBooks www.wiley.com/compbooks or silverston.wiley.com– The Data Model Resource Book Revised Edition Volume 1:A Library ofUniversal Data Models For All Enterprises, Wiley, 2001– The Data Model Resource Book Revised Edition Volume 2:A Library ofUniversal Data Models For Industry Types, Wiley, 2001– Electronic products for generic models and for each industry2002 DM Review article series on Universal Data ModelsMicrosoft SQL Server Enterprise Edition now includes universal models msdn.microsoft.com/library/psdk/sql/samp schema 9mlv.htmSeminars - public course “Universal Data Models”Software- Universal Data Models repositories for ErwinConsulting- 10 day jump-starts – an enterprise data model in 10 daysProprietary information of Universal Data Models, LLC22

Proprietary information of Universal Data Models, LLC 13 Application vendors beginning to use PARTY model Siebel 7.5 logical data model – Has PARTY and PARTY RELATIONSHIP construct Oracle Financials 11i – Uses PARTY and PARTY RELATIONSHIP construct Peoplesoft’s latest version – Uses PARTY and PARTY RELATIONSHIP constructs JD Edwards

Related Documents:

2210 fresadora universal marca fexac up 9.000,00 2296 fresadora universal marca ghe 1.000,00 2314 fresadora universal kondia modelo 2 2.300,00 2315 fresadora universal ghe modelo 2 2.100,00 2364 fresadora universal marca fexac up 2.500,00 2429 fresadora universal. marca mrf. mod. fu 115. 7.000,00 2456 fresadora universal marca correa mod. f1 u .

Gehl to Mini Universal Adapter Plate ASV RC-30 or Terex PT-30 to Mini Universal Adapter Plate Mini Universal Adapter - Bolt or Weld-on. Thomas to Mini Universal Adapter Plate MT-50/52/55 & 463 to Mini Universal Adapter Plate Mini Universal Adapter - Bolt or Weld-on. SS Universal Quick Attach

work/products (Beading, Candles, Carving, Food Products, Soap, Weaving, etc.) ⃝I understand that if my work contains Indigenous visual representation that it is a reflection of the Indigenous culture of my native region. ⃝To the best of my knowledge, my work/products fall within Craft Council standards and expectations with respect to

Universal Messaging Clustering Guide Version 10.1 8 What is Universal Messaging Clustering? Universal Messaging provides guaranteed message delivery across public, private, and wireless infrastructures. A Universal Messaging cluster consists of Universal Messaging servers working together to provide increased scalability, availability, and .

Integration EMR/EHR Integration "Healthcare data exchange platform" "Data extraction and interoperability" "Data integration for healthcare" "EHR-specific, cloud-based interface engine" "EHR integration and third-party developer marketplace" "EMR integration to software products" "Specific EHR integration for HL7

Integration from SAP Ariba Different integration options 1. Ariba Network integration -Standard integration between SAP S/4HANA and SAP ERP with Ariba Network solutions 2. SAP Ariba Applications integration -Standard integration between SAP S/4HANA OP and SAP ERP with SAP Ariba Applications that cover the entire source-to-settle process 3.

akuntansi musyarakah (sak no 106) Ayat tentang Musyarakah (Q.S. 39; 29) لًََّز ãَ åِاَ óِ îَخظَْ ó Þَْ ë Þٍجُزَِ ß ا äًَّ àَط لًَّجُرَ íَ åَ îظُِ Ûاَش

Collectively make tawbah to Allāh S so that you may acquire falāḥ [of this world and the Hereafter]. (24:31) The one who repents also becomes the beloved of Allāh S, Âَْ Èِﺑاﻮَّﺘﻟاَّﺐُّ ßُِ çﻪَّٰﻠﻟانَّاِ Verily, Allāh S loves those who are most repenting. (2:22