最佳的点/GraphViz布局用于图形数据库模式。

Question

我第一次使用dot + GraphViz来帮助规划图形数据库模式。

随着我添加更多节点，输出结果看起来不太理想。特别是语言和国家部分看起来相当混乱。

我尝试了一些基本排名，但无法对其产生影响。

我该如何获得更清晰的输出？

代码如下：

digraph ReferenceGraph {
  nodesep = 2;
  edge [color=gray50, fontname=Calibri, fontsize=11]
  node [shape=record, fontname=Calibri, fontsize=11]

  root [label="Reference Node", color=darkgreen, fontcolor=darkgreen, fontname=Calibri, fontsize=11]

  sue [label="{{User}|{GivenName=Sue}|{FamilyName=Williams}|{Username=swilliams}|{EmailAddress=[e-mail]}|{BusinessPhone=02 1234 5678}|{MobilePhone=0414 123 456}|{PasswordSalt=fcd376dc}|{PasswordHash=a8635cfd2930ebc0cc78}|{PreviousPasswordSalt=gggf6dc}|{PreviousPasswordHash=wer435cfd2930ebc0cc78}|{RequirePasswordChangeOnNextLogin=true}|FailedLoginAttempts=0|LastLoginAttemptUtc=21 Jun 2011 16:43:01 UTC|{DateCreatedUtc=20 Jun 2011 15:43:07 UTC}}", color=blue, fontcolor=blue]
  sue -> root [label="ADMINISTERS"]

  clint [label="{{Client}|{UniqueId=100}|{GivenName=Clint}|{MiddleNames=ian bill}|{FamilyName=Wood}|{PreferredName=Woods}|{Gender=Male Female Unknown}|{PlaceOfBirthTown}|{PlaceOfBirthState}|{PlaceOfBirthCountry}|{Email=[e-mail]}|{LanguageComments}|{InterpreterRequired=true false}|{InterpreterComments}|{Religion=Buddhist}|{LegalOrders=order1}|{DateOfBirth=21 June 1979}|{DateOfBirthCertainty=Confirmed Unconfirmed Estimated}}", color=blue, fontcolor=blue]
  clint -> acme [label="CLIENT_BELONGS_TO"]
  clint -> english [label ="SPEAKS"]

  cat [label="Cat (Client)"]
  cat -> acme [label="CLIENT_BELONGS_TO"]
  cat -> english [label ="SPEAKS"]
  cat -> mandarin [label ="SPEAKS"]

  acme [label="{{Agency}|{UniqueId=100}|{Key=acme}|{Name=Acme Australia}}", color=blue, fontcolor=blue]
  root -> acme [label="HOSTS"]

  john [label="John (User)"]
  john -> acme [label="USER_BELONGS_TO"]

  jack [label="Jack (User)"]
  jack -> acme [label="USER_BELONGS_TO"]

  centreA [label="{{Centre}|{Name=CentreA}|{BusinessPhone=02 1234 5678}|{Fax=0414 123 456}|{Email=[e-mail]}|{Status=Active}}", color=blue, fontcolor=blue]
  centreA -> acme [label="CENTRE_BELONGS_TO"]

  centreAStreetAddress [label="{{PhysicalAddress}|{Line 1=Level 1}|{Line 2=11 Sydney Road}|{TownSuburb=Sydney}|{State=NSW}|{Postcode=2000}|{Country=Australia}}", color=blue, fontcolor=blue]
  centreA -> centreAStreetAddress [label="HAS_STREET_ADDRESS"]

  centreAPostalAddress [label="PO Box 123 (PhysicalAddress)"]
  centreA -> centreAPostalAddress [label="HAS_POSTAL_ADDRESS"]

  clintCurrentAddress [label="{{CurrentAddress}|{Line 1=Level 1}|{Line 2=11 Sydney Road}|{TownSuburb=Sydney}|{State=NSW}|{Postcode=2000}|{Country=Australia}}", color=blue, fontcolor=blue]
  clint -> clintCurrentAddress [label="HAS_STREET_ADDRESS"]

  referenceData [label="Reference Data"]
  root -> referenceData [label="HAS_REFERENCE_DATA"]

  languagesReferenceData [label="Languages"]
  referenceData -> languagesReferenceData [label="HAS_LANGUAGES"]

  english [label="{{Language}|{Name=English}}", color=blue, fontcolor=blue]
  languagesReferenceData -> english [label="HAS_LANGUAGE"]

  mandarin [label="Mandarin (Language)"]
  languagesReferenceData -> mandarin [label="HAS_LANGUAGE"]

  japanese [label="Japanese (Language)"]
  languagesReferenceData -> japanese [label="HAS_LANGUAGE"]

  countriesReferenceData [label="Countries"]
  referenceData -> countriesReferenceData [label="HAS_COUNTRIES"]

  australia [label="{{Country}|{Name=Australia}}", color=blue, fontcolor=blue]
  countriesReferenceData -> australia [label="HAS_COUNTRY"]

  china [label="China (Country)"]
  countriesReferenceData -> china[label="HAS_COUNTRY"]
}

- Tatham Oddie

Answer 1

您可以尝试添加

splines=true;
overlap=prism;

代替nodesep=2;，并使用neato而不是dot来渲染图形。这将导致更紧凑的布局，虽然一些标签可能会与节点重叠，并且基于记录的节点彼此非常接近。

但请注意，使用graphviz可能永远无法获得完美的数据库模式 - 几乎总会有一些交叉边缘可以以更好的方式布局。手动布局的数据库模式将胜过graphviz输出。

- marapet

---

最终我使用了以下代码：splines=true; overlap=portho; model=subset;这让我朝着正确的方向前进。谢谢！ - Tatham Oddie

非常好，这绝对更好！ - marapet