ER/Studio - A solução definitiva para design de dados, modelagem e colaboração
-
Upload
fernando-rizzato -
Category
Software
-
view
332 -
download
3
Transcript of ER/Studio - A solução definitiva para design de dados, modelagem e colaboração
EMBARCADERO TECHNOLOGIESEMBARCADERO TECHNOLOGIES
ER/StudioA solução definitiva para design de dados, modelagem e colaboração
EMBARCADERO TECHNOLOGIES
Embarcadero Technologies
EMBARCADERO TECHNOLOGIES
Embarcadero Technologies
• Fundadaem1993• 3.2MilhõesdeClientes- 97%doFortune2000• 35+ProdutosPremiados– InovaçãoConstante• 500+Colaboradoresem29Países
EMBARCADERO TECHNOLOGIES
RunsonEmbarcadero
EMBARCADERO TECHNOLOGIES
ER/StudioFamily
EMBARCADERO TECHNOLOGIES
• Engenharia reversa e geração de scripts precisos
• Rápida e eficiente comparação de alterações
• Controle de versões simplificado com repositório
• Modelo lógico e múltiplos físicos para uma completa visão de projeto
EMBARCADERO TECHNOLOGIES
As10PrincipaisRazões…
1. Submodelos2. SeparaçãoLógica/Física3. EngenhariaReversa4. ExtensõesdeMetadata5. PadrõesdeNomenclatura6. CompareeMerge7. Macros
8.UniversalMappings9.SuporteNativoaBigData10.Repositório,PublicaçãoeColaboração
7
EMBARCADERO TECHNOLOGIES
1:Submodels
• WhatisaSubmodel?– Acollectionofmodelobjectsrelevanttoaspecifictopicoraudience
– Breakdownofbusinessareas/subjects– Businessdecomposition– Ideally,shouldbebusinessfocused
8
EMBARCADERO TECHNOLOGIES
1:ER/StudioSubmodels - collapsed
9
EMBARCADERO TECHNOLOGIES
1:ER/StudioSubmodels – expanded
10
EMBARCADERO TECHNOLOGIES
2:Logical/PhysicalModelSeparation
DataManagementBodyofKnowledge(DMBOK):Adatamodelisarepresentationofthedatadescribingreal-worldobjectsandtherelationshipsbetweentheobjects,independentofanyassociatedprocess.Generallyspeaking,thereare3levelsofdatamodelingthatareutilized,inorderofabstraction:– ConceptualModels– LogicalModels– PhysicalModels
11
EMBARCADERO TECHNOLOGIES
2:ConceptualModel- ER/Studio
• Abstract• Businessentities• Businessrelationships• Typicallynotfullyattributed• Typicallynotnormalized
12
EMBARCADERO TECHNOLOGIES
LogicalModelView
EMBARCADERO TECHNOLOGIES
2:ER/Studio– Logical/PhysicalSeparation
14
EMBARCADERO TECHNOLOGIES
2:ER/Studio– WhereUsed
15
EMBARCADERO TECHNOLOGIES
3:ReverseEngineering
• Theabilitytocreateadatamodelbyconnectingtoanexistingdatabase– Nativeconnector– ODBC– CanalsobeSQLscriptratherthandirectconnection
• Vitaltomap&analyzecomplexdatalandscapes
16
EMBARCADERO TECHNOLOGIES
3:ReverseEngineeringWizard– ER/Studio
17
EMBARCADERO TECHNOLOGIES
3:ReverseEngineering– ER/Studiocontinued
18
EMBARCADERO TECHNOLOGIES
4:MetadataExtensions
• Definitionandcreationofadditionalmetadataformodelobjects
• Manyuses– Datagovernance– Dataquality– Masterdatamanagement– Dataretentionpolicies
19
EMBARCADERO TECHNOLOGIES
4:ER/Studio– AttachmentSetup
20
EMBARCADERO TECHNOLOGIES
4:AttachmentsonDiagrams
21
EMBARCADERO TECHNOLOGIES
4:ER/Studio– Attachments,DataDictionary
22
EMBARCADERO TECHNOLOGIES
5:NamingStandards
• Extremelyimportant– Define– Apply– Enforce
• Representrealworldbusinessobjects
• Typicallycomprisedof– Businessterms– Abbreviationforeach– Template(specifyorder)– Case– Prefixes,Suffixes
23
EMBARCADERO TECHNOLOGIES
5:ER/Studio– ApplynamingStandards• Caninvokewithotherwizards
– GeneralPhysicalModel– Compare&Merge– XMLSchemaGeneration– ModelValidation
• Canapplytomodelorsub-modelatanytime
• EitherDirection• Selectivereview/apply• Enabledbyloosemodelcoupling• Namelockdown(freezenames)
24
EMBARCADERO TECHNOLOGIES
DataFlowModelView:Transformations
CONFIDENTIAL – FOR INTERNAL USE ONLY
EMBARCADERO TECHNOLOGIES
6:CompareandMerge
• CompareModel(orsub-model)to– Anothermodel(sub-model)– Database
• Wheretherearedifferences– Characteristicstomergefromsource->targetspecified
• ReportscanbeGenerated
26
EMBARCADERO TECHNOLOGIES
6:ER/StudioCompare&MergeScope• Comparelogicalmodelto
– Aphysicalmodelinthesame.dm1file.– AlogicalmodelofanotherER/StudioDataArchitectdatamodel.– AphysicalmodelofanotherER/StudioDataArchitectdatamodel.
• Comparephysicalmodelto– Thelogicalmodelofthesamedatamodel.– AnotherphysicalmodelofthesamedatamodelthatsharesthesameDBMS
platform(andversion).– AlogicalmodelofanotherER/StudioDataArchitectdatamodel.– AphysicalmodelofanotherER/StudioDataArchitectdatamodelsharingthesame
DBMSplatform(andversion).– Alivedatabase.– AnSQLfile.
27
EMBARCADERO TECHNOLOGIES
6:ER/Studio– CompareandMergeA
28
EMBARCADERO TECHNOLOGIES
6:ER/Studio– CompareandMergeB
29
EMBARCADERO TECHNOLOGIES
30
6:ER/Studio– CompareandMergeC
EMBARCADERO TECHNOLOGIES
31
6:ER/Studio– CompareandMergeD
EMBARCADERO TECHNOLOGIES
32
6:ER/Studio– CompareandMergeE
EMBARCADERO TECHNOLOGIES
33
6:ER/Studio– CompareandMergeF
EMBARCADERO TECHNOLOGIES
34
6:ER/Studio– CompareandMergeScript
EMBARCADERO TECHNOLOGIES
CompareandMerge
EMBARCADERO TECHNOLOGIES
7:Macros
• Scriptinglanguageto– Applyautomationwithinthetool– Applychangestomodelobjects
36
EMBARCADERO TECHNOLOGIES
7:ER/Studio- Macros• Truelanguage (SAXbasic)• Fullyfunctionaleditor• Automationinterface
– Scriptablecontrols– Automaterepetitivetasks– EventHandlers
• Someusecases– Updateobjects– Import/exportmetadata– Changedisplayproperties– Modellayout– GenerationofphysicalDBmetadata
• Extensivemacrosetshippedwithproduct– Canbecopied,modified– Newcanbebuiltfromscratchifdesired
37
EMBARCADERO TECHNOLOGIES
8:UniversalMappings
• Abilitytolink “like”orrelatedobjects– Withinsamemodelfile– Acrossseparatemodelfiles
• Entity/Tablelevel• Attribute/Columnlevel
38
EMBARCADERO TECHNOLOGIES
8:ER/Studio– UniversalMappings
39
EMBARCADERO TECHNOLOGIES
9:NativeSupportforBigData
• Abilitytomodelbigdataconstructs– Nestedobjects– Nestedobjectarrays
• Nativelyreverseengineerbigdataplatforms– InternaltotoolasopposedtoMetaWizard
• Forwardengineering
40
EMBARCADERO TECHNOLOGIES
9:ER/Studio– NativeBigDataSupport
• MongoDB– Versions2.4and2.6
• HadoopHive– Versions0.12and0.13
• Capabilities– Diagramming– ReverseEngineering(JSON,BSON)– DDLsupportedforHive
41
EMBARCADERO TECHNOLOGIES
9:ER/Studio– BigDataNotationEnhancement
• PhysicalModel– ObjectsinsteadofTables
• NestedObjects– “IsContainedIn”relationshiptype
42
EMBARCADERO TECHNOLOGIES
10:Repository,Publishing,Collaboration• Supportoflarge,collaborativeteams
– Dataarchitects,modelers– Businessanalysts– Businessstakeholders
• Repository-basedcheckout,check-in– Fullsub-models– Individualobjects
• Publish&collaborate– Webportal– Nativereports
• Businessstakeholderactiveparticipationincreationofmetadata• Notifications
43
EMBARCADERO TECHNOLOGIES
10:Repository
• Model/submodel orindividualobjectcheckout• Repositoryisrelationaldatabasewithmanytables• Namedversions• Branch&merge• Businessarchitectworkspacecheck-in&checkout
44
EMBARCADERO TECHNOLOGIES
10:Publishing
• PortalPublishing(TeamServer)• NativeReports
– Html,rtf– Clickabledrilldowntometadatainhtml– Rtfcanbeaugmentedinatoollikeword,thenpublished(rtf,pdfetc)
45
EMBARCADERO TECHNOLOGIES
• Powerful enterprise glossary & metadata collaboration
• Integrate key business terms and definitions with business systems
• View, store, and manage a single source of business definitions
• Attach business policies to daily workflows with contextual alerts and tips
EMBARCADERO TECHNOLOGIES
10:ER/StudioTeamServer– ModelExplorer
47
EMBARCADERO TECHNOLOGIES
10:ER/StudioTeamServerCore– Glossary/Terms
48
EMBARCADERO TECHNOLOGIES
TeamCollaboration
EMBARCADERO TECHNOLOGIES
DataSourceRegistry
EMBARCADERO TECHNOLOGIES
Perguntas eRepostas
• Saiba mais sobre afamília deprodutos ER/Studio:http://www.embarcadero.com/data-modeling
• Downloaddeversões deteste:http://www.embarcadero.com/downloads
• Contato:– FernandoRizzato– [email protected]
51