API tools faq
paste
Guest User

Промт для теста text-to-SQL 7 (cross_db_1)

a guest
Jul 5th, 2025
36
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 53.09 KB | None | 0 0
raw download clone embed print report
  1. <НАЗВАНИЕ ТЕСТА>cross_db_1</НАЗВАНИЕ ТЕСТА>
  2. <ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>Нужно преобразовать запрос в свободной форме (тег «ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ») в SQL-запрос, воспользовавшись схемой базы данных (тег «СХЕМА БАЗЫ ДАННЫХ») и словарём знаний (тег «СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ»). При наличии комментариев и пояснений пишите их на русском языке.</ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>
  3. <ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>List the top 5 high-risk data flows, showing each flow’s ID, Risk Exposure Score (rounded to 2 decimals), and Data Sensitivity Level. Sort by Risk Exposure Score descending.</ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>
  4. <ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>Выведите 5 наиболее рискованных потоков данных: ID потока, показатель риска (округлён до 2 знаков) и уровень чувствительности. Отсортируйте по риску по убыванию.</ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>
  5. <СХЕМА БАЗЫ ДАННЫХ>
  6. CREATE TABLE "dataflow" (
  7. recordregistry character NOT NULL, /* CHAR(10) primary key uniquely identifying each data flow record in the DataFlow table. */
  8. flowstamp timestamp without time zone NULL, /* TIMESTAMP(6) for the moment this data flow record was created or logged. Microsecond precision. */
  9. flowtag character varying NULL, /* A short identifier or tag (VARCHAR(20)) for the data flow, previously 'DataFlowID'. */
  10. orignation character varying NULL, /* VARCHAR(80) storing the source/origin country's name for this data flow. */
  11. destnation character varying NULL, /* VARCHAR(80) storing the destination country's name for this data flow. */
  12. origactor character varying NULL, /* VARCHAR(150) referencing the source entity/system initiating the flow (person, organization, or app). */
  13. destactor character varying NULL, /* VARCHAR(150) referencing the destination entity/system receiving the flow. */
  14. chanproto character varying NULL, /* VARCHAR(30) for the protocol used (HTTP, FTP, SFTP, etc.). Currently possible values: (Blockchain, SFTP, Private Network, HTTPS). */
  15. chanfreq character varying NULL, /* VARCHAR(25) specifying how frequently data is transferred (daily, weekly, on-demand, etc.). Currently possible values: (Weekly, Hourly, Real-time, Daily). */
  16. datasizemb numeric NULL, /* NUMERIC(12,2) representing the size in MB of each data transfer. */
  17. durmin smallint NULL, /* SMALLINT capturing the average or actual duration (in minutes) of the data flow. */
  18. bwidthpct numeric NULL, /* NUMERIC(5,2) for bandwidth utilization percentage (0 to 100%). */
  19. successpct numeric NULL, /* NUMERIC(5,2) measuring the success rate (0–100%) of the flow attempts. */
  20. errtally smallint NULL, /* SMALLINT counting the total errors or failures observed for this data flow. */
  21. rtrytally smallint NULL, /* SMALLINT storing how many retry attempts were made after failures. */
  22. PRIMARY KEY (recordregistry)
  23. );
  24.  
  25. First 3 rows:
  26. recordregistry flowstamp flowtag orignation destnation origactor destactor chanproto chanfreq datasizemb durmin bwidthpct successpct errtally rtrytally
  27. ---------------- -------------------------- --------- ---------------------------- ------------ -------------- ----------------------- --------------- ---------- ------------ -------- ----------- ------------ ---------- -----------
  28. CB932064 2024-03-11 11:43:31.039769 DF7811 Niue Djibouti Hill Ltd Davis, Harper and Weber Blockchain Weekly 42668.4 1068 68.81 99.93 39 1
  29. CB339111 2024-05-01 07:58:45.040384 DF9309 Israel Monaco Boyer-Mcdonald Rogers Inc SFTP Hourly 32804 996 7.52 91.77 68 48
  30. CB899685 2024-05-07 04:39:04.040801 DF8105 United States Virgin Islands Germany Curtis Inc Horton LLC Private Network Real-time 93843.2 1325 62.66 93.76 80 45
  31. ...
  32.  
  33.  
  34. CREATE TABLE "auditandcompliance" (
  35. audittrace integer NOT NULL DEFAULT nextval('auditandcompliance_audittrace_seq1'::regclass), /* SERIAL primary key uniquely identifying each audit-and-compliance record. */
  36. profjoin integer NOT NULL, /* INT referencing DataProfile(ProfileTrace). Ties this audit to a specific data profile. */
  37. compjoin integer NOT NULL, /* INT referencing Compliance(ComplianceTrace). Links the audit to a compliance record. */
  38. vendjoin integer NOT NULL, /* INT referencing VendorManagement(VendorTrace). Connects this record to a specific vendor. */
  39. recordregistry character NULL, /* CHAR(10) optional cross-reference for older 'RecordID'. */
  40. audtrailstate USER-DEFINED NULL, /* auditstatus_enum enumerating the audit trail status. Currently possible values: (Complete, Missing, Partial). */
  41. findtally smallint NULL, /* SMALLINT storing the count of audit findings identified. */
  42. critfindnum smallint NULL, /* SMALLINT counting how many critical findings were discovered. */
  43. remedstate character varying NULL, /* VARCHAR(40) describing remediation status (e.g., 'Pending', 'In Progress'). Currently possible values: (In Progress, Not Started, Completed). */
  44. remeddue date NULL, /* DATE specifying the deadline for remediation actions. */
  45. authnotify character varying NULL, /* VARCHAR(40) describing if/when authorities must be notified. Currently possible values: (Not Required, Required, Submitted). */
  46. bordermech character varying NULL, /* VARCHAR(40) capturing cross-border mechanism (SCC, BCR, etc.) if relevant. Currently possible values: (SCCs, Adequacy Decision, Derogations, BCRs). */
  47. transimpassess text NULL, /* TEXT describing any transfer impact assessment for cross-border data flows. Currently possible values: (Required, Completed, In Progress). */
  48. localreqs text NULL, /* TEXT detailing local requirements or constraints on the data flow. Currently possible values: (Not Met, Met, Partial). */
  49. datamapstate character varying NULL, /* VARCHAR(40) describing the data mapping status (complete, partial, etc.). Currently possible values: (Partial, Complete, Outdated). */
  50. sysintstate character varying NULL, /* VARCHAR(40) referencing the system integration status. Currently possible values: (Fully Integrated, Manual, Partial). */
  51. accreqnum smallint NULL, /* SMALLINT counting how many access requests have been received. */
  52. delreqnum smallint NULL, /* SMALLINT counting how many data deletion requests were filed. */
  53. rectreqnum smallint NULL, /* SMALLINT counting how many rectification (correction) requests were made. */
  54. portreqnum smallint NULL, /* SMALLINT counting how many data portability requests were received. */
  55. resptimeday numeric NULL, /* NUMERIC(4,1) capturing the average or allowed response time (days) to subject requests. */
  56. PRIMARY KEY (audittrace),
  57. FOREIGN KEY (compjoin) REFERENCES compliance(compliancetrace),
  58. FOREIGN KEY (profjoin) REFERENCES dataprofile(profiletrace),
  59. FOREIGN KEY (vendjoin) REFERENCES vendormanagement(vendortrace)
  60. );
  61.  
  62. First 3 rows:
  63. audittrace profjoin compjoin vendjoin recordregistry audtrailstate findtally critfindnum remedstate remeddue authnotify bordermech transimpassess localreqs datamapstate sysintstate accreqnum delreqnum rectreqnum portreqnum resptimeday
  64. ------------ ---------- ---------- ---------- ---------------- --------------- ----------- ------------- ------------ ---------- ------------ ----------------- ---------------- ----------- -------------- ---------------- ----------- ----------- ------------ ------------ -------------
  65. 1 1 1 1 CB932064 Complete 3 6 In Progress 2025-03-16 Not Required SCCs Required Not Met Partial Fully Integrated 959 409 76 53 4.5
  66. 2 2 2 2 CB339111 Complete 49 8 In Progress 2025-04-14 Required Adequacy Decision Completed Met Partial Manual 36 326 196 21 13.4
  67. 3 3 3 3 CB899685 6 5 Not Started 2025-04-10 Required Derogations In Progress Partial Partial Fully Integrated 650 122 0 89 23.2
  68. ...
  69.  
  70.  
  71. CREATE TABLE "riskmanagement" (
  72. risktrace integer NOT NULL DEFAULT nextval('riskmanagement_risktrace_seq'::regclass), /* SERIAL primary key uniquely identifying each risk management record. */
  73. flowlink character NOT NULL, /* CHAR(10) referencing DataFlow(RecordRegistry), linking this risk record to a specific data flow. */
  74. recordregistry character NULL, /* CHAR(10) formerly 'RecordID'; can be used for cross-references or historical reasons. */
  75. riskassess numeric NULL, /* NUMERIC(4,2) storing the assessed risk score (0–100 or custom). */
  76. riskmitstate character varying NULL, /* VARCHAR(40) describing how the risk is being mitigated. Currently possible values: (Pending, Partial, Implemented). */
  77. secureaction text NULL, /* TEXT describing security measures or controls used to reduce identified risks. Currently possible values: (Adequate, Strong, Insufficient). */
  78. breachnotify text NULL, /* TEXT outlining the procedure for breach notification if a security event occurs. Currently possible values: (Partial, Established, Missing). */
  79. incidentplan text NULL, /* TEXT capturing the incident response plan or steps for handling security/operational events. Currently possible values: (Missing, Active, Outdated). */
  80. incidentcount smallint NULL, /* SMALLINT counting incidents recorded for this data flow or scenario. */
  81. breachcount smallint NULL, /* SMALLINT counting data breaches recorded. */
  82. nearmissnum smallint NULL, /* SMALLINT enumerating near misses (close calls that didn't escalate). */
  83. avgresolhrs numeric NULL, /* NUMERIC(5,2) average incident resolution time in hours. */
  84. slapct numeric NULL, /* NUMERIC(4,2) indicating SLA (Service Level Agreement) compliance percentage (0–100%). */
  85. costusd numeric NULL, /* NUMERIC(11,2) capturing the cost of compliance in USD (security, risk measures, etc.). */
  86. penusd numeric NULL, /* NUMERIC(11,2) storing potential or actual penalty/fine risk in USD. */
  87. coveragestate character varying NULL, /* VARCHAR(40) describing insurance coverage status (e.g., 'Full', 'Partial', 'None'). Currently possible values for discovered data: (Limited, Adequate). */
  88. residrisklevel character varying NULL, /* VARCHAR(40) naming the residual risk level after mitigation (Low, Medium, High, etc.). Currently possible values: (Medium, High, Low). */
  89. ctrleff numeric NULL, /* NUMERIC(4,2) rating the effectiveness of current controls (0–100). */
  90. compscore numeric NULL, /* NUMERIC(4,2) measuring overall compliance posture (0–100 or custom). */
  91. maturitylevel character varying NULL, /* VARCHAR(40) describing the maturity of processes (Initial, Managed, Optimized, etc.). Currently possible values: (Optimized, Managed, Initial). */
  92. nextrevdate date NULL, /* DATE specifying when the next risk/compliance review is scheduled. */
  93. planstate character varying NULL, /* VARCHAR(45) capturing improvement or remediation plan status (e.g., 'Planned', 'Completed'). Currently possible values: (On Track, Not Started, Delayed). */
  94. PRIMARY KEY (risktrace),
  95. FOREIGN KEY (flowlink) REFERENCES dataflow(recordregistry)
  96. );
  97.  
  98. First 3 rows:
  99. risktrace flowlink recordregistry riskassess riskmitstate secureaction breachnotify incidentplan incidentcount breachcount nearmissnum avgresolhrs slapct costusd penusd coveragestate residrisklevel ctrleff compscore maturitylevel nextrevdate planstate
  100. ----------- ---------- ---------------- ------------ -------------- -------------- -------------- -------------- --------------- ------------- ------------- ------------- -------- --------- ---------------- --------------- ---------------- --------- ----------- --------------- ------------- -----------
  101. 1 CB932064 CB932064 75.89 Pending Adequate Partial Missing 8 1 1 42.7 97.28 62143.3 1.03576e+06 Medium 30.51 76.41 Optimized 2025-06-02 On Track
  102. 2 CB339111 CB339111 67.11 Pending Strong Established Active 54 2 7 149.6 92.63 697140 1.90198e+06 Limited High 25.93 75.01 Optimized 2025-10-14 On Track
  103. 3 CB899685 CB899685 17.4 Pending Insufficient Established Outdated 40 6 3 92.3 99.54 81412.1 110601 Medium 61.71 51.95 Managed 2025-10-04 Not Started
  104. ...
  105.  
  106.  
  107. CREATE TABLE "dataprofile" (
  108. profiletrace integer NOT NULL DEFAULT nextval('dataprofile_profiletrace_seq1'::regclass), /* SERIAL primary key identifying each data profile record. */
  109. flowsign character NOT NULL, /* CHAR(10) referencing DataFlow(RecordRegistry), linking this profile to a particular data flow. */
  110. riskjoin integer NOT NULL, /* INT referencing RiskManagement(RiskTrace). Associates the data profile with a relevant risk record. */
  111. recordregistry character NULL, /* CHAR(10), an optional cross-reference, formerly 'RecordID'. */
  112. datatype character varying NULL, /* VARCHAR(80) describing the category of data (financial, personal, logs, etc.). Currently possible values: (Commercial, Personal, Financial, Industrial, Medical). */
  113. datasense character varying NULL, /* VARCHAR(30) designating data sensitivity level (High, Medium, Low). Currently possible values: (High, Low, Critical, Medium). */
  114. volgb numeric NULL, /* NUMERIC(10,2) representing the approximate data volume in gigabytes. */
  115. rectally bigint NULL, /* BIGINT counting how many records exist in this data set or flow. */
  116. subjtally bigint NULL, /* BIGINT enumerating how many unique data subjects are impacted/contained. */
  117. retdays integer NULL, /* INT storing the retention duration (in days) for this data. */
  118. formattype character varying NULL, /* VARCHAR(80) naming the data format (CSV, JSON, XML, proprietary, etc.). Currently possible values: (Mixed, Unstructured, Structured). */
  119. qltyscore numeric NULL, /* NUMERIC(4,2) capturing data quality on a custom 0–100 scale. */
  120. intcheck USER-DEFINED NULL, /* checkstatus_enum enumerating data integrity check status. Currently possible values: (Passed, Failed, Partial). */
  121. csumverify USER-DEFINED NULL, /* checkstatus_enum enumerating checksum verification status. Currently possible values: (Failed, Success, Pending). */
  122. srcvalstate USER-DEFINED NULL, /* checkstatus_enum enumerating source validation status. Currently possible values: (Pending, Verified, Failed). */
  123. destvalstate USER-DEFINED NULL, /* checkstatus_enum enumerating destination validation status. Currently possible values: (Pending, Verified, Failed). */
  124. PRIMARY KEY (profiletrace),
  125. FOREIGN KEY (flowsign) REFERENCES dataflow(recordregistry),
  126. FOREIGN KEY (riskjoin) REFERENCES riskmanagement(risktrace)
  127. );
  128.  
  129. First 3 rows:
  130. profiletrace flowsign riskjoin recordregistry datatype datasense volgb rectally subjtally retdays formattype qltyscore intcheck csumverify srcvalstate destvalstate
  131. -------------- ---------- ---------- ---------------- ---------- ----------- ------- ---------- ----------- --------- ------------ ----------- ---------- ------------ ------------- --------------
  132. 1 CB932064 1 CB932064 Commercial High 1093.6 2629296 754585 2208 Mixed 52.45 Passed Failed Pending Pending
  133. 2 CB339111 2 CB339111 Personal Low 9970.36 921745 797722 3456 Unstructured 81.09 Passed Success Verified Verified
  134. 3 CB899685 3 CB899685 Financial Low 7306.78 751112 384363 1728 Mixed 25.2 Failed Pending Failed Failed
  135. ...
  136.  
  137.  
  138. CREATE TABLE "securityprofile" (
  139. securitytrace integer NOT NULL DEFAULT nextval('securityprofile_securitytrace_seq1'::regclass), /* SERIAL primary key uniquely identifying each security profile record. */
  140. flowkey character NOT NULL, /* CHAR(10) referencing DataFlow(RecordRegistry). Associates security details with a data flow. */
  141. riskkey integer NOT NULL, /* INT referencing RiskManagement(RiskTrace). Links security measures to a risk record. */
  142. profilekey integer NOT NULL, /* INT referencing DataProfile(ProfileTrace). Ties security info to a data profile. */
  143. recordregistry character NULL, /* CHAR(10) optional cross-reference historically called 'RecordID'. */
  144. encstate USER-DEFINED NULL, /* encryptionstatus_enum. Possible values: (Full, Partial). */
  145. encmeth character varying NULL, /* VARCHAR(40) describing the encryption method used (AES, RSA, etc.). Currently possible values: (SM4, Custom, RSA-2048, AES-256). */
  146. keymanstate character varying NULL, /* VARCHAR(40) for key management status. Currently possible values: (Hybrid, Distributed, Centralized). */
  147. masklevel USER-DEFINED NULL, /* partialnone_enum enumerating data masking. Currently possible values: (Partial, Full). */
  148. anonmeth character varying NULL, /* VARCHAR(40) describing the anonymization methodology. Currently possible values: (T-Closeness, K-Anonymity, L-Diversity). */
  149. psymstate character varying NULL, /* VARCHAR(40) describing pseudonymization status. Currently possible values: (Partial, Applied). */
  150. authmeth character varying NULL, /* VARCHAR(40) specifying the authentication method (Basic, OAuth, SAML, etc.). Currently possible values: (Basic, SSO, MFA). */
  151. authzframe character varying NULL, /* VARCHAR(45) specifying the authorization framework (RBAC, ABAC, etc.). Currently possible values: (ABAC, Custom, RBAC). */
  152. aclstate character varying NULL, /* VARCHAR(30) describing the current access control status. Currently possible values: (Adequate, Strong, Weak). */
  153. apisecstate character varying NULL, /* VARCHAR(30) enumerating the API security posture. Currently possible values: (Vulnerable, Secure, Review Required). */
  154. logintcheck character varying NULL, /* VARCHAR(30) specifying the log integrity check mechanism. Currently possible values: (Pending, Passed, Failed). */
  155. logretdays smallint NULL, /* SMALLINT indicating how many days audit logs are retained. */
  156. bkpstate character varying NULL, /* VARCHAR(35) describing the backup status. Currently possible values: (Current, Failed, Outdated). */
  157. drecstate character varying NULL, /* VARCHAR(35) describing the disaster recovery status. Currently possible values: (Untested, Tested, Missing). */
  158. bcstate character varying NULL, /* VARCHAR(35) storing the business continuity status or plan stage. Currently possible values: (Active, Outdated, Review Required). */
  159. PRIMARY KEY (securitytrace),
  160. FOREIGN KEY (flowkey) REFERENCES dataflow(recordregistry),
  161. FOREIGN KEY (profilekey) REFERENCES dataprofile(profiletrace),
  162. FOREIGN KEY (riskkey) REFERENCES riskmanagement(risktrace)
  163. );
  164.  
  165. First 3 rows:
  166. securitytrace flowkey riskkey profilekey recordregistry encstate encmeth keymanstate masklevel anonmeth psymstate authmeth authzframe aclstate apisecstate logintcheck logretdays bkpstate drecstate bcstate
  167. --------------- --------- --------- ------------ ---------------- ---------- --------- ------------- ----------- ----------- ----------- ---------- ------------ ---------- ------------- ------------- ------------ ---------- ----------- ---------
  168. 1 CB932064 1 1 CB932064 Full SM4 Hybrid T-Closeness Partial Basic ABAC Adequate Vulnerable Pending 905 Current Untested Active
  169. 2 CB339111 2 2 CB339111 Partial SM4 Hybrid T-Closeness SSO ABAC Adequate Vulnerable Pending 439 Failed Tested Outdated
  170. 3 CB899685 3 3 CB899685 Partial Custom Distributed Partial T-Closeness Partial SSO Custom Strong Vulnerable Passed 621 Failed Missing Outdated
  171. ...
  172.  
  173.  
  174. CREATE TABLE "vendormanagement" (
  175. vendortrace integer NOT NULL DEFAULT nextval('vendormanagement_vendortrace_seq1'::regclass), /* SERIAL primary key uniquely identifying each vendor management record. */
  176. secjoin integer NOT NULL, /* INT referencing SecurityProfile(SecurityTrace). Ties vendor data with a security profile. */
  177. riskassoc integer NOT NULL, /* INT referencing RiskManagement(RiskTrace). Connects vendor data to risk management info. */
  178. recordregistry character NULL, /* CHAR(10) an optional cross-ref field, historically 'RecordID'. */
  179. vendassess character varying NULL, /* VARCHAR(40) describing vendor assessment status. Currently possible values: (Completed, In Progress, Due). */
  180. vendsecrate USER-DEFINED NULL, /* securityrating_enum enumerating vendor security rating. Currently possible values: (A, B, C, D). */
  181. vendauddate date NULL, /* DATE indicating when the vendor was last audited. */
  182. contrstate character varying NULL, /* VARCHAR(30) capturing the contract state. Currently possible values: (Active, Under Review, Expired). */
  183. contrexpire date NULL, /* DATE specifying when the current contract expires. */
  184. dpastate character varying NULL, /* VARCHAR(30) referencing Data Processing Agreement status. Currently possible values: (Required, Signed, Pending). */
  185. sccstate character varying NULL, /* VARCHAR(30) referencing Standard Contractual Clauses status. Currently possible values: (Implemented, Partial, Not Required). */
  186. bcrstate character varying NULL, /* VARCHAR(30) capturing the status of Binding Corporate Rules. Currently possible values: (Approved, Pending, Not Applicable). */
  187. docustate character varying NULL, /* VARCHAR(30) describing the vendor’s documentation completeness. Currently possible values: (Complete, Incomplete, Partial). */
  188. polcomp character varying NULL, /* VARCHAR(30) enumerating vendor’s policy compliance. Currently possible values: (Partial, Full, Non-compliant). */
  189. proccomp character varying NULL, /* VARCHAR(30) enumerating vendor’s procedure compliance status. Currently possible values: (Non-compliant, Full, Partial). */
  190. trainstate character varying NULL, /* VARCHAR(30) referencing the training status of vendor employees. Currently possible values: (Due, Overdue, Current). */
  191. certstate character varying NULL, /* VARCHAR(30) referencing certifications the vendor holds. Currently possible values: (Pending, Expired, Valid). */
  192. monstate character varying NULL, /* VARCHAR(30) storing the vendor’s monitoring status or approach. Currently possible values: (Inactive, Partial, Active). */
  193. repstate character varying NULL, /* VARCHAR(30) capturing the vendor’s reporting requirements or status. Currently possible values: (Delayed, Current, Overdue). */
  194. stakecomm text NULL, /* TEXT detailing stakeholder communication or engagement strategy for the vendor relationship. Currently possible values: (Limited, Poor, Regular). */
  195. PRIMARY KEY (vendortrace),
  196. FOREIGN KEY (riskassoc) REFERENCES riskmanagement(risktrace),
  197. FOREIGN KEY (secjoin) REFERENCES securityprofile(securitytrace)
  198. );
  199.  
  200. First 3 rows:
  201. vendortrace secjoin riskassoc recordregistry vendassess vendsecrate vendauddate contrstate contrexpire dpastate sccstate bcrstate docustate polcomp proccomp trainstate certstate monstate repstate stakecomm
  202. ------------- --------- ----------- ---------------- ------------ ------------- ------------- ------------ ------------- ---------- ----------- ---------- ----------- --------- ------------- ------------ ----------- ---------- ---------- -----------
  203. 1 1 1 CB932064 Completed A 2024-05-30 Active 2027-01-12 Required Implemented Approved Complete Partial Non-compliant Due Pending Inactive Delayed Limited
  204. 2 2 2 CB339111 Completed A 2024-06-30 Under Review 2026-08-16 Required Implemented Pending Incomplete Full Non-compliant Overdue Expired Inactive Delayed Poor
  205. 3 3 3 CB899685 In Progress B 2024-11-14 Expired 2026-04-26 Signed Partial Pending Incomplete Full Non-compliant Current Valid Partial Delayed Limited
  206. ...
  207.  
  208.  
  209. CREATE TABLE "compliance" (
  210. compliancetrace integer NOT NULL DEFAULT nextval('compliance_compliancetrace_seq1'::regclass), /* SERIAL primary key uniquely identifying each compliance record. */
  211. risktie integer NOT NULL, /* INT referencing RiskManagement(RiskTrace). Links compliance data to a specific risk record. */
  212. vendortie integer NOT NULL, /* INT referencing VendorManagement(VendorTrace). Connects compliance info to a specific vendor record. */
  213. recordregistry character NULL, /* CHAR(10) optionally referencing an older 'RecordID'. May be used for cross references. */
  214. legalbase character varying NULL, /* VARCHAR(150) describing the legal basis for data processing (e.g., 'Consent', 'Legal Obligation'). Currently possible values: (Legal Obligation, Contract, Legitimate Interest, Consent). */
  215. consentstate character varying NULL, /* VARCHAR(30) capturing the status of consent (e.g., 'Obtained', 'Revoked'). Currently possible values: (Not Required, Valid, Expired, Pending). */
  216. consentcoll date NULL, /* DATE indicating when user consent was collected. */
  217. consentexp date NULL, /* DATE indicating when that consent expires or needs renewal. */
  218. purplimit character varying NULL, /* VARCHAR(300) specifying the purpose limitation or constraints (GDPR principle). Currently possible values: (General, Multiple, Specific). */
  219. purpdesc text NULL, /* TEXT describing the purpose for data processing in detail. Currently possible values: (Business Operations, Research, Marketing, Compliance). */
  220. gdprcomp USER-DEFINED NULL, /* compliancelevel_enum enumerating GDPR compliance level. Currently possible values: (Partial, Non-compliant, Compliant). */
  221. ccpacomp USER-DEFINED NULL, /* compliancelevel_enum enumerating CCPA compliance level. Currently possible values: (Compliant, Non-compliant, Partial). */
  222. piplcomp USER-DEFINED NULL, /* compliancelevel_enum enumerating PIPL compliance level. Currently possible values: (Non-compliant, Partial, Compliant). */
  223. loclawcomp USER-DEFINED NULL, /* compliancelevel_enum enumerating local law compliance. Currently possible values: (Non-compliant, Compliant, Partial). */
  224. regapprovals character varying NULL, /* VARCHAR(300) listing any regulatory approvals or licenses obtained. Currently possible values: (Obtained, Not Required, Pending). */
  225. privimpassess text NULL, /* TEXT capturing the privacy impact assessment details or outcome. Currently possible values: (Completed, In Progress, Required). */
  226. datasubjright character varying NULL, /* VARCHAR(40) describing data subject rights or status (access, erasure, portability, etc.). Currently possible values: (Partial, Fully Supported, Limited). */
  227. PRIMARY KEY (compliancetrace),
  228. FOREIGN KEY (risktie) REFERENCES riskmanagement(risktrace),
  229. FOREIGN KEY (vendortie) REFERENCES vendormanagement(vendortrace)
  230. );
  231.  
  232. First 3 rows:
  233. compliancetrace risktie vendortie recordregistry legalbase consentstate consentcoll consentexp purplimit purpdesc gdprcomp ccpacomp piplcomp loclawcomp regapprovals privimpassess datasubjright
  234. ----------------- --------- ----------- ---------------- ---------------- -------------- ------------- ------------ ----------- ------------------- ---------- ------------- ------------- ------------- -------------- --------------- ---------------
  235. 1 1 1 CB932064 Legal Obligation Not Required 2024-09-13 2026-05-17 General Business Operations Partial Compliant Non-compliant Non-compliant Obtained Completed Partial
  236. 2 2 2 CB339111 Legal Obligation Valid 2025-01-15 2025-02-25 Multiple Research Partial Non-compliant Partial Compliant Not Required In Progress Fully Supported
  237. 3 3 3 CB899685 Contract Expired 2024-10-13 2025-03-30 Multiple Research Partial Partial Non-compliant Non-compliant Pending In Progress Limited
  238. ...
  239. </СХЕМА БАЗЫ ДАННЫХ>
  240. <СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
  241. {"id": 0, "knowledge": "Data Transfer Efficiency (DTE)", "description": "Measures the efficiency of data transfers based on success rate and error count.", "definition": "DTE = \\frac{\\text{SuccessPct}}{\\text{ErrTally} + 1}", "type": "calculation_knowledge", "children_knowledge": -1}
  242. {"id": 1, "knowledge": "Bandwidth Saturation Index (BSI)", "description": "Quantifies how close a data flow is to saturating available bandwidth.", "definition": "BSI = \\text{BwidthPct} \\times \\frac{\\text{DataSizeMB}}{\\text{DurMin}}", "type": "calculation_knowledge", "children_knowledge": -1}
  243. {"id": 2, "knowledge": "Risk Exposure Score (RES)", "description": "Calculates the overall risk exposure by combining risk assessment and residual risk.", "definition": "RES = \\text{RiskAssess} \\times \\text{CtrlEff}^{-1}", "type": "calculation_knowledge", "children_knowledge": -1}
  244. {"id": 3, "knowledge": "Compliance Cost Ratio (CCR)", "description": "Evaluates the cost of compliance relative to potential penalties.", "definition": "CCR = \\frac{\\text{CostUSD}}{\\text{PenUSD} + 1}", "type": "calculation_knowledge", "children_knowledge": -1}
  245. {"id": 4, "knowledge": "Data Sensitivity Index (DSI)", "description": "Quantifies the sensitivity of data based on volume and sensitivity level.", "definition": "DSI = \\text{VolGB} \\times \\begin{cases} 3 & \\text{if DataSense = 'High'} \\\\ 2 & \\text{if DataSense = 'Medium'} \\\\ 1 & \\text{if DataSense = 'Low'} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": -1}
  246. {"id": 5, "knowledge": "Security Robustness Score (SRS)", "description": "Measures the strength of security controls based on encryption and access controls.", "definition": "SRS = \\begin{cases} 3 & \\text{if EncState = 'Full' and AclState = 'Strong'} \\\\ 2 & \\text{if EncState = 'Full' or AclState = 'Adequate'} \\\\ 1 & \\text{otherwise} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": -1}
  247. {"id": 6, "knowledge": "Vendor Reliability Index (VRI)", "description": "Assesses vendor reliability based on security rating and contract status.", "definition": "VRI = \\text{VendSecRate value} \\times \\begin{cases} 1 & \\text{if ContrState = 'Active'} \\\\ 0.5 & \\text{otherwise} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": -1}
  248. {"id": 7, "knowledge": "Audit Finding Severity (AFS)", "description": "Quantifies the severity of audit findings based on critical findings.", "definition": "AFS = \\frac{\\text{CritFindNum}}{\\text{FindTally} + 1}", "type": "calculation_knowledge", "children_knowledge": -1}
  249. {"id": 8, "knowledge": "Data Subject Request Load (DSRL)", "description": "Measures the workload from data subject requests.", "definition": "DSRL = \\text{AccReqNum} + \\text{DelReqNum} + \\text{RectReqNum} + \\text{PortReqNum}", "type": "calculation_knowledge", "children_knowledge": -1}
  250. {"id": 9, "knowledge": "Cross-Border Risk Factor (CBRF)", "description": "Evaluates risk associated with cross-border data transfers.", "definition": "CBRF = \\text{RES} \\times \\begin{cases} 2 & \\text{if OrigNation \\neq DestNation} \\\\ 1 & \\text{otherwise} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": [2]}
  251. {"id": 10, "knowledge": "High-Risk Data Flow", "description": "Identifies data flows with elevated risk based on risk exposure and sensitivity.", "definition": "A data flow where RES > 0.7 and DSI > 100", "type": "domain_knowledge", "children_knowledge": [2, 4]}
  252. {"id": 11, "knowledge": "Secure Data Flow", "description": "Classifies data flows with strong security controls.", "definition": "A data flow where SRS = 3", "type": "domain_knowledge", "children_knowledge": [5]}
  253. {"id": 12, "knowledge": "Non-Compliant Vendor", "description": "Identifies vendors failing compliance standards.", "definition": "A vendor where PolComp = 'Non-compliant' or ProcComp = 'Non-compliant'", "type": "domain_knowledge", "children_knowledge": -1}
  254. {"id": 13, "knowledge": "Critical Audit Issue", "description": "Flags audits with significant issues requiring urgent remediation.", "definition": "An audit where AFS > 0.5", "type": "domain_knowledge", "children_knowledge": [7]}
  255. {"id": 14, "knowledge": "Sensitive Data Exposure", "description": "Highlights data profiles with high sensitivity and weak security.", "definition": "A data profile where DSI > 100 and SRS < 2", "type": "domain_knowledge", "children_knowledge": [4, 5]}
  256. {"id": 15, "knowledge": "Cross-Border Compliance Gap", "description": "Identifies compliance issues in cross-border data flows.", "definition": "A compliance record where GdprComp = 'Non-compliant' or LocLawComp = 'Non-compliant' and OrigNation ≠ DestNation", "type": "domain_knowledge", "children_knowledge": -1}
  257. {"id": 16, "knowledge": "Vendor Risk Tier", "description": "Categorizes vendors into risk tiers based on security and compliance.", "definition": "A vendor is: High Risk if VRI < 2, Medium Risk if 2 ≤ VRI < 3, Low Risk if VRI ≥ 3", "type": "domain_knowledge", "children_knowledge": [6]}
  258. {"id": 17, "knowledge": "Data Integrity Failure", "description": "Identifies data profiles with failed integrity checks.", "definition": "A data profile where IntCheck = 'Failed' or CsumVerify = 'Failed'", "type": "domain_knowledge", "children_knowledge": -1}
  259. {"id": 18, "knowledge": "Overloaded Data Flow", "description": "Flags data flows with high bandwidth saturation and low efficiency.", "definition": "A data flow where BSI > 50 and DTE < 1.0", "type": "domain_knowledge", "children_knowledge": [0, 1]}
  260. {"id": 19, "knowledge": "Regulatory Risk Exposure", "description": "Identifies data flows with high regulatory risk due to compliance gaps and cross-border transfers.", "definition": "A data flow with CBRF > 1.5 and Cross-Border Compliance Gap exists", "type": "domain_knowledge", "children_knowledge": [9, 15]}
  261. {"id": 20, "knowledge": "DataFlow.SuccessPct", "description": "Illustrates the success rate of data transfers.", "definition": "Ranges from 0 to 100%. A SuccessPct of 95% indicates reliable transfers, while <80% suggests frequent failures, from DataFlow.", "type": "value_illustration", "children_knowledge": -1}
  262. {"id": 21, "knowledge": "RiskManagement.RiskAssess", "description": "Illustrates the risk assessment score.", "definition": "Ranges from 0 to 100. A RiskAssess > 80 indicates high risk, while <20 suggests minimal risk, from RiskManagement.", "type": "value_illustration", "children_knowledge": -1}
  263. {"id": 22, "knowledge": "DataProfile.VolGB", "description": "Illustrates the volume of data in gigabytes.", "definition": "Ranges from 0 to millions. A VolGB of 1000 might represent a large dataset, while 0.1 is typical for small logs, from DataProfile.", "type": "value_illustration", "children_knowledge": -1}
  264. {"id": 23, "knowledge": "SecurityProfile.EncState", "description": "Illustrates the encryption status of data.", "definition": "Enum: 'Full', 'Partial'. 'Full' indicates all data is encrypted, while 'Partial' suggests gaps, from SecurityProfile.", "type": "value_illustration", "children_knowledge": -1}
  265. {"id": 24, "knowledge": "VendorManagement.VendSecRate", "description": "Illustrates the vendor security rating.", "definition": "Enum: 'A' = 4, 'B' = 3, 'C' = 2, 'D' or others = 1. This numeric scale quantifies vendor security, where 'A' reflects top-tier security (score 4), and lower ratings (down to 'D') indicate progressively weaker security controls.", "type": "value_illustration", "children_knowledge": -1}
  266. {"id": 25, "knowledge": "Compliance.GdprComp", "description": "Illustrates GDPR compliance status.", "definition": "Enum: 'Compliant', 'Non-compliant', 'Partial'. 'Compliant' meets all GDPR rules, 'Non-compliant' fails key requirements, from Compliance.", "type": "value_illustration", "children_knowledge": -1}
  267. {"id": 26, "knowledge": "AuditAndCompliance.RespTimeDay", "description": "Illustrates the response time for data subject requests.", "definition": "Ranges from 0 to days. A RespTimeDay of 1.5 suggests quick responses, while >7 indicates delays, from AuditAndCompliance.", "type": "value_illustration", "children_knowledge": -1}
  268. {"id": 27, "knowledge": "DataFlow.ErrTally", "description": "Illustrates the count of errors in data transfers.", "definition": "Integer ≥ 0. An ErrTally of 0 indicates flawless transfers, while >10 suggests reliability issues, from DataFlow.", "type": "value_illustration", "children_knowledge": -1}
  269. {"id": 28, "knowledge": "RiskManagement.CtrlEff", "description": "Illustrates the effectiveness of risk controls.", "definition": "Ranges from 0 to 100. A CtrlEff of 90% shows strong controls, while <50% indicates weaknesses, from RiskManagement.", "type": "value_illustration", "children_knowledge": -1}
  270. {"id": 29, "knowledge": "SecurityProfile.LogRetDays", "description": "Illustrates the retention period for audit logs.", "definition": "Integer ≥ 0 days. A LogRetDays of 365 meets many compliance needs, while <30 may violate regulations, from SecurityProfile.", "type": "value_illustration", "children_knowledge": -1}
  271. {"id": 30, "knowledge": "Data Flow Reliability Score (DFRS)", "description": "Quantifies the reliability of a data flow based on success rate and retry attempts.", "definition": "DFRS = \\text{DTE} \\times (1 - \\text{RtryTally} / (\\text{ErrTally} + 1))", "type": "calculation_knowledge", "children_knowledge": [0, 27]}
  272. {"id": 31, "knowledge": "Security Control Cost Ratio (SCCR)", "description": "Evaluates the cost-effectiveness of security controls relative to compliance costs.", "definition": "SCCR = \\text{SRS} / (\\text{CostUSD} + 1)", "type": "calculation_knowledge", "children_knowledge": [5]}
  273. {"id": 32, "knowledge": "Vendor Compliance Burden (VCB)", "description": "Measures the compliance burden of a vendor based on audit findings and security rating.", "definition": "VCB = \\text{AFS} \\times (5 - \\text{VendSecRate value})", "type": "calculation_knowledge", "children_knowledge": [7, 24]}
  274. {"id": 33, "knowledge": "Cross-Border Data Volume Risk (CDVR)", "description": "Assesses risk from large cross-border data volumes.", "definition": "CDVR = \\text{CBRF} \\times \\text{VolGB}", "type": "calculation_knowledge", "children_knowledge": [9, 22]}
  275. {"id": 34, "knowledge": "Data Subject Request Pressure (DSRP)", "description": "Quantifies pressure from data subject requests relative to response time.", "definition": "DSRP = \\text{DSRL} \\times \\text{RespTimeDay}", "type": "calculation_knowledge", "children_knowledge": [8, 26]}
  276. {"id": 35, "knowledge": "Encryption Coverage Ratio (ECR)", "description": "Measures the extent of encryption coverage relative to data sensitivity.", "definition": "ECR = \\text{SRS} \\times \\text{DSI}", "type": "calculation_knowledge", "children_knowledge": [4, 5]}
  277. {"id": 36, "knowledge": "Audit Remediation Load (ARL)", "description": "Calculates the workload required for audit remediation based on findings and compliance gaps.", "definition": "ARL = \\text{AFS} \\times \\text{DSRL}", "type": "calculation_knowledge", "children_knowledge": [7, 8, 25]}
  278. {"id": 37, "knowledge": "Bandwidth Risk Factor (BRF)", "description": "Evaluates risk from bandwidth overuse in sensitive data flows.", "definition": "BRF = \\text{BSI} \\times \\text{DSI}", "type": "calculation_knowledge", "children_knowledge": [1, 4]}
  279. {"id": 38, "knowledge": "Vendor Risk Amplification (VRA)", "description": "Quantifies how vendor issues amplify overall risk exposure.", "definition": "VRA = \\text{VRI} \\times \\text{RES}", "type": "calculation_knowledge", "children_knowledge": [2, 6]}
  280. {"id": 39, "knowledge": "Critical Data Flow Risk", "description": "Identifies data flows with both high risk exposure and poor reliability.", "definition": "A data flow where RES > 0.7 and DFRS < 0.5", "type": "domain_knowledge", "children_knowledge": [2, 30]}
  281. {"id": 40, "knowledge": "Overburdened Compliance Flow", "description": "Flags data flows with high compliance costs and audit remediation needs.", "definition": "A data flow where CCR > 0.8 and ARL > 10", "type": "domain_knowledge", "children_knowledge": [3, 36]}
  282. {"id": 41, "knowledge": "Unprotected Sensitive Data", "description": "Identifies sensitive data lacking adequate encryption coverage.", "definition": "A data profile where DSI > 100 and ECR < 2", "type": "domain_knowledge", "children_knowledge": [4, 35]}
  283. {"id": 42, "knowledge": "High-Pressure Data Flow", "description": "Highlights data flows under strain from data subject requests and bandwidth saturation.", "definition": "A data flow where DSRP > 50 and BSI > 50", "type": "domain_knowledge", "children_knowledge": [1, 34]}
  284. {"id": 43, "knowledge": "Vendor-Driven Risk Flow", "description": "Identifies data flows with elevated risk due to vendor issues.", "definition": "A data flow where VRA > 3 and VCB > 2", "type": "domain_knowledge", "children_knowledge": [32, 38]}
  285. {"id": 44, "knowledge": "Cross-Border Audit Risk", "description": "Flags cross-border data flows with significant audit issues.", "definition": "A data flow where CDVR > 1000 and AFS > 0.5", "type": "domain_knowledge", "children_knowledge": [7, 33]}
  286. {"id": 45, "knowledge": "Insecure High-Volume Flow", "description": "Identifies high-volume data flows with weak security controls.", "definition": "A data flow where VolGB > 500 and SRS < 2", "type": "domain_knowledge", "children_knowledge": [5, 22]}
  287. {"id": 46, "knowledge": "Regulatory Overload Flow", "description": "Highlights data flows with both regulatory risk and compliance gaps.", "definition": "A data flow with Regulatory Risk Exposure and GdprComp = 'Non-compliant'", "type": "domain_knowledge", "children_knowledge": [19, 25]}
  288. {"id": 47, "knowledge": "Bandwidth-Constrained Risk", "description": "Identifies data flows where bandwidth saturation amplifies risk.", "definition": "A data flow where BRF > 100 and RES > 0.7", "type": "domain_knowledge", "children_knowledge": [2, 37]}
  289. {"id": 48, "knowledge": "Incident Resolution Efficiency (IRE)", "description": "Measures how efficiently incidents are resolved relative to SLA compliance.", "definition": "IRE = \\text{SLApct} / (\\text{AvgResolHrs} + 1), \\text{where SLApct and AvgResolHrs are from RiskManagement, adding 1 to avoid division by zero.}", "type": "calculation_knowledge", "children_knowledge": -1}
  290. {"id": 49, "knowledge": "Incident-Prone Data Flow", "description": "Flags data flows with poor incident resolution and high risk.", "definition": "A data flow where IRE < 0.5 and High-Risk Data Flow", "type": "domain_knowledge", "children_knowledge": [10, 30]}
  291. {"id": 50, "knowledge": "Data Flow Stability Index (DFSI)", "description": "Quantifies the stability of data flows by balancing reliability and error recovery.", "definition": "DFSI = \\text{DFRS} \\times \\frac{\\text{SuccessPct}}{\\text{ErrTally} + 1}", "type": "calculation_knowledge", "children_knowledge": [20, 27, 30]}
  292. {"id": 51, "knowledge": "Compliance Overhead Ratio (COR)", "description": "Measures the operational burden of compliance relative to data subject request load.", "definition": "COR = \\text{DSRP} / (\\text{CostUSD} + 1)", "type": "calculation_knowledge", "children_knowledge": [34]}
  293. {"id": 52, "knowledge": "Security Posture Maturity (SPM)", "description": "Evaluates the maturity of security controls based on encryption and audit log retention.", "definition": "SPM = \\text{ECR} \\times \\frac{\\text{LogRetDays}}{365}", "type": "calculation_knowledge", "children_knowledge": [29, 35]}
  294. {"id": 53, "knowledge": "Vendor Risk Concentration (VRC)", "description": "Assesses the concentration of risk from a vendor’s compliance and security issues.", "definition": "VRC = \\text{VRA} \\times (1 - \\text{VRI})", "type": "calculation_knowledge", "children_knowledge": [6, 38]}
  295. {"id": 54, "knowledge": "Cross-Border Compliance Exposure (CBCE)", "description": "Quantifies compliance risk for cross-border flows based on regulatory gaps and volume.", "definition": "CBCE = \\text{CDVR} \\times \\begin{cases} 2 & \\text{if GdprComp = 'Non-compliant'} \\\\ 1 & \\text{otherwise} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": [25, 33]}
  296. {"id": 55, "knowledge": "Incident Impact Factor (IIF)", "description": "Measures the potential impact of incidents based on risk exposure and resolution efficiency.", "definition": "IIF = \\text{RES} \\times (1 - \\text{IRE})", "type": "calculation_knowledge", "children_knowledge": [2, 48]}
  297. {"id": 56, "knowledge": "Data Retention Risk Score (DRRS)", "description": "Evaluates risk from prolonged data retention relative to sensitivity.", "definition": "DRRS = \\text{DSI} \\times \\frac{\\text{RetDays}}{365}", "type": "calculation_knowledge", "children_knowledge": [4]}
  298. {"id": 57, "knowledge": "Audit Compliance Pressure (ACP)", "description": "Quantifies pressure from audit findings and compliance remediation needs.", "definition": "ACP = \\text{ARL} \\times \\text{AFS}", "type": "calculation_knowledge", "children_knowledge": [7, 36]}
  299. {"id": 58, "knowledge": "Bandwidth Compliance Risk (BCR)", "description": "Assesses compliance risk from bandwidth-constrained data flows.", "definition": "BCR = \\text{BRF} \\times \\begin{cases} 1.5 & \\text{if GdprComp = 'Partial'} \\\\ 2 & \\text{if GdprComp = 'Non-compliant'} \\\\ 1 & \\text{otherwise} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": [25, 37]}
  300. {"id": 59, "knowledge": "Vendor Security Cost Index (VSCI)", "description": "Evaluates the cost-effectiveness of vendor security relative to compliance burden.", "definition": "VSCI = \\text{VCB} / (\\text{SCCR} + 1)", "type": "calculation_knowledge", "children_knowledge": [31, 32]}
  301. {"id": 60, "knowledge": "Unstable High-Risk Flow", "description": "Identifies high-risk data flows with poor stability.", "definition": "A data flow where DFSI < 0.5 and Critical Data Flow Risk exists", "type": "domain_knowledge", "children_knowledge": [39, 50]}
  302. {"id": 61, "knowledge": "Overloaded Security Flow", "description": "Flags data flows with high security burden and compliance exposure.", "definition": "A data flow where SPM < 1 and CBCE > 100", "type": "domain_knowledge", "children_knowledge": [52, 54]}
  303. {"id": 62, "knowledge": "Excessive Retention Risk", "description": "Highlights data profiles with prolonged retention and high sensitivity.", "definition": "A data profile where DRRS > 50 and DSI > 100", "type": "domain_knowledge", "children_knowledge": [4, 56]}
  304. {"id": 63, "knowledge": "Vendor Compliance Risk Cluster", "description": "Identifies vendors contributing to concentrated compliance risks.", "definition": "A vendor where VRC > 2 and VCB > 2", "type": "domain_knowledge", "children_knowledge": [32, 53]}
  305. {"id": 64, "knowledge": "Incident-Prone Compliance Flow", "description": "Flags data flows with high incident impact and compliance gaps.", "definition": "A data flow where IIF > 0.8 and GdprComp = 'Non-compliant'", "type": "domain_knowledge", "children_knowledge": [25, 55]}
  306. {"id": 65, "knowledge": "Audit-Stressed Data Flow", "description": "Identifies data flows under pressure from audit findings and compliance burdens.", "definition": "A data flow where ACP > 5 and COR > 0.5.", "type": "domain_knowledge", "children_knowledge": [51, 57]}
  307. {"id": 66, "knowledge": "Bandwidth-Limited Compliance Risk", "description": "Highlights data flows where bandwidth constraints exacerbate compliance risks.", "definition": "A data flow where BCR > 50 and Cross-Border Compliance Gap exists", "type": "domain_knowledge", "children_knowledge": [15, 58]}
  308. {"id": 67, "knowledge": "Costly Vendor Risk Flow", "description": "Identifies data flows with high vendor-related costs and risks.", "definition": "A data flow where VSCI > 1 and VRA > 3", "type": "domain_knowledge", "children_knowledge": [38, 59]}
  309. {"id": 68, "knowledge": "Sensitive Unstable Flow", "description": "Flags sensitive data flows with stability issues.", "definition": "A data flow where DFSI < 0.5 and Sensitive Data Exposure exists", "type": "domain_knowledge", "children_knowledge": [14, 50]}
  310. {"id": 69, "knowledge": "High-Impact Audit Risk Flow", "description": "Identifies data flows with severe audit findings and regulatory risks.", "definition": "A data flow where Regulatory Risk Exposure exists and ACP > 5", "type": "domain_knowledge", "children_knowledge": [19, 57]}
  311. {"id": 70, "knowledge": "Transfer Path", "description": "Describes the data flow path from origin to destination nation.", "definition": "A string concatenating OrigNation and DestNation as 'OrigNation -> DestNation'", "type": "domain_knowledge", "children_knowledge": -1}
  312. {"id": 71, "knowledge": "Request Breakdown", "description": "Describes the types and counts of data subject requests.", "definition": "An array of strings listing request types and their counts: 'Access: AccReqNum', 'Deletion: DelReqNum', 'Rectification: RectReqNum', 'Portability: PortReqNum', unnested for display", "type": "domain_knowledge", "children_knowledge": -1}
  313. {"id": 72, "knowledge": "Integrity Failure Count (IFC)", "description": "Counts the number of failed integrity checks per data profile.", "definition": "IFC = \\begin{cases} 1 & \\text{if IntCheck = 'Failed'} \\\\ 0 & \\text{otherwise} \\end{cases} + \\begin{cases} 1 & \\text{if CsumVerify = 'Failed'} \\\\ 0 & \\text{otherwise} \\end{cases}", "type": "calculation_knowledge", "children_knowledge": -1}
  314. {"id": 73, "knowledge": "Failure Types List", "description": "Concatenates the types of integrity failures for a data profile into a single string.", "definition": "A comma-separated string listing failure types: 'Integrity Check' if IntCheck = 'Failed', 'Checksum Verification' if CsumVerify = 'Failed'.", "type": "domain_knowledge", "children_knowledge": -1}
  315. {"id": 74, "knowledge": "High Audit Compliance Pressure", "description": "Identifies data flows with elevated audit compliance pressure based on audit findings and data subject request load.", "definition": "A data flow where ACP > 5", "type": "domain_knowledge", "children_knowledge": [57]}
  316. {"id": 75, "knowledge": "Cross-Border Data Flow", "description": "Identifies data flows where the origin and destination nations differ.", "definition": "A data flow where OrigNation != DestNation", "type": "domain_knowledge", "children_knowledge": -1}
  317. {"id": 76, "knowledge": "Slow Remediation Timeline", "description": "Identifies data flows where the remediation deadline has passed.", "definition": "A data flow where CURRENT_DATE - RemedDue > 0", "type": "domain_knowledge", "children_knowledge": -1}
  318. {"id": 77, "knowledge": "Nearing Remediation Deadline", "description": "Identifies data flows where the remediation deadline is within 5 days.", "definition": "A data flow where (CURRENT_DATE - RemedDue) is between -5 and 0", "type": "domain_knowledge", "children_knowledge": -1}
  319. {"id": 78, "knowledge": "High Vendor Risk Concentration", "description": "Identifies vendors with elevated risk concentration based on vendor risk amplification and reliability.", "definition": "A data flow where CURRENT_DATE - RemedDue > 0", "type": "domain_knowledge", "children_knowledge": -1}
  320. </СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!