滤波性能考量

新万博移动客户端多端关系遍历查询树时,性能受到影响,因为对Collibra内部存储引擎新查询在上述例子中,社区与责任实体之间的关系多至多类型,因为社区可以承担多项相关职责。视结果的形状和数量而定,性能罚法范围从完全无关到大块加到整体查询时间不等。

最优查询方式

狗万新闻c{    "ViewConfig": {      "Resources": {        "Community": {          "Id": { "name": "communityId" },          "Name": { "name": "communityName" },          "Responsibility": {            "Id": { "name": "responsibilityId" },            "User": {              "Id": { "name": "userId" },              "FirstName": { "name": "firstName" },              "LastName": { "name": "lastName" }            },            "Group": {              "Id": { "name": "groupId" },              "GroupName": { "name": "groupName" }            },            "Role": {              "Signifier": { "name": "roleName" }            }          }        }      }    }  }

狗万新闻c---  ViewConfig:    Resources:      Community:        Id:          name: "communityId"        Name:          name: "communityName"        Responsibility:          Id:            name: "ResponsibilityId"          User:            Id:              name: "userId"            FirstName:              name: "firstName"            LastName:              name: "lastName"          Group:            Id:              name: "groupId"            GroupName:              name: "groupName"          Role:            Signifier:              name: "roleName"

结果格式化像下例

{    "view": {      "Community0": [        {          "communityId": "c87f166e-041f-4bea-8ff7-c1ffbab2ceeb",          "communityName": "First Community"        },        {          "communityId": "12345678-0020-0000-0000-000000000000",          "communityName": "Second Community",          "Responsibility1": [            {              "responsibilityId": "0ecb2fff-d5de-43d0-be60-f7f201c10d41",              "User2": [                {                  "userId": "00000000-0000-0000-0000-000000900002",                  "firstName": "Admin",                  "lastName": "Istrator"                }              ],              "Group3": [                {}              ],              "Role4": [                {                  "roleName": "Admin"                }              ]            },            {              "responsibilityId": "42b9d114-2c0c-4e96-a1ce-b645d5e92365",              "User2": [                {                  "userId": "00000000-0000-0000-0000-000000900002",                  "firstName": "Admin",                  "lastName": "Istrator"                }              ],              "Group3": [                {}              ],              "Role4": [                {                  "roleName": "Steward"                }              ]            },            {              "responsibilityId": "5fc0cc5f-e30e-488c-94bc-acdea171219d",              "User2": [                {}              ],              "Group3": [                {                  "groupId": "4eb1f4a9-14a3-4539-8afc-733925161179",                  "groupName": "admin"                }              ],              "Role4": [                {                  "roleName": "Admin"                }              ]            }          ]        }      ]    }  }