月沙工具箱
現在位置:月沙工具箱 > 學習工具 > 英語單詞大全

referential integrity是什麼意思,referential integrity的意思翻譯、用法、同義詞、例句

輸入單詞

常用詞典

  • [計] 參照完整性;引用完整性

  • 例句

  • How should I keep referential integrity to users in a separate membership provider?

    我應該如何在一個單獨的成員提供者向用戶保持參照完整性?

  • This referential integrity can be checked in one or both directions depending on the project goal.

    取決于項目的目的,可以從一個方向或同時從兩個方向檢查引用完整性。

  • If referential integrity violations are discovered during the load test, then you might also need to set the sequence grouping for container managed persistence.

    如果在負載測試過程中發現存在引用完整性違規,則可能還需要為容器管理的持久性設置順序分組。

  • That ensures referential integrity between the tables.

    這樣就保證了表間的引用完整性。

  • It is also a sound choice if you want to use database referential integrity to enforce associations.

    如果你想用數據庫的引用完整性來做關聯,那它也是個合適的選擇。

  • Even though referential integrity and check constraints are very helpful during the ETL process to help detect data problems, implementing them on final data warehouse tables is not efficient.

    在ETL過程中,即時參照完整性和檢查約束極其有助于檢測數據問題,在最終的數據倉庫表中實現它們也不會高效。

  • You can copy tables, data, stored procedures, referential integrity constraints, security, and indexes. Choose the object(s) to copy.

    可以複制表、數據、存儲過程、引用完整性約束、安全性和索引。選擇要複制的對象。

  • You can transfer tables, data, stored procedures, referential integrity constraints, security, and indexes. Choose the object(s) to transfer.

    可以傳輸表、數據、存儲過程、引用完整性約束、安全性和索引。選擇要傳輸的對象。

  • Referential integrity is a fancy SQL term that refers to keeping all the data in your database clean, free from incorrect or unused data, and accurate in terms of joins across tables.

    引用完整性是一個美妙的SQL術語,它指的是保持數據庫中的所有數據都是幹淨的,沒有錯誤或者多餘的數據,表之間的連接準确合理。

  • In reality, it's up to you to decide whether you want your classes to maintain strict referential integrity (in other words, have all deletes cascade) or to allow a looser relationship.

    實際上,您可以自己決定是否希望類保持嚴格的引用完整性(換句話說,所有删除操作都是級聯的)或者允許更松散的關系。

  • It had good ANSI SQL support, referential integrity, and good performance as long as the number of concurrent accesses didn't grow too large.

    它有很好的ANSISQL支持和引用完整性,并且隻要并發用戶的增長不太大它可以保持良好的性能。

  • Replication to non-DB2 target tables with referential integrity constraints is supported only if you manually define the constraints on the corresponding nicknames.

    隻有在相應别名上手工定義約束,才支持到帶有參照完整性約束的非DB2目标表的複制。

  • This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (RI)) verification.

    這一類的開銷包括檢查約束驗證和外鍵約束(參照完整性(RI))驗證。

  • This table uses referential integrity constraints to ensure data validity.

    這個表使用引用完整性約束确保數據的有效性。

  • State the primary types of tables found in a data warehouse and the order which they must be loaded to enforce referential integrity.

    簡述數據倉庫中的表的基本類型,以及為了保證引用完整性該以什麼樣的順序對它們進行加載。

  • Do not include any clauses defining declarative referential integrity constraints.

    不要包括可定義聲明引用完整性約束的子句。

  • You can't use database features such as referential integrity, and you can't rely on tools to discover the relationships based on the names of your columns.

    不能使用諸如引用完整性這樣的數據庫特性,也不能依賴于工具來基于列的名稱發現這些關系。

  • Control over the database aspects of persistent classes including indices, constraints, and referential integrity.

    持久類保持和數據庫一緻。包括索引,約束和參照完整性。

  • The technical data quality dimension defines the data quality criteria often found in logical data modeling entity integrity and referential integrity rules.

    技術性數據質量維定義在邏輯數據建模實體完整性和引用完整性規則中常見的數據質量标準。

  • For example, this might happen when two ore more of the tables in the MQT have a referential integrity relationship defined and the join predicate is on their primary key - foreign key columns.

    例如,當MQT 中的兩個或多個表定義了引用完整性關系并且聯結謂詞在它們自己的主鍵-外鍵列上時,就會出現這種情況。

  • Copy tables, data, stored procedures, referential integrity constraints, security, and indexes. Specify the object(s) to copy.

    複制表、數據、存儲過程、引用完整性約束、安全性和索引。請指定要複制的對象。

  • This paper presents a class of specific covert channels in database system-the covert channel using referential integrity. We compute their bandwidth and propose the methods to handle them.

    該文提出了一類數據庫系統所特有的隱通道一利用引用完整性約束傳送信息的隱通道,分析了它們的帶寬,并提出了處理這類隱通道的方法。

  • For instance, complex data relationships would require full referential integrity enforcement.

    比如,複雜的數據關系要求有完全的引用完整性限制。

  • This ensures that the atomicity, consistency, isolation, and durability (ACID) criteria for transactions are met and that referential integrity is enforced.

    這可确保滿足事務的原子性、一緻性、隔離和持久性 (ACID)标準,且保證引用完整性。

  • Transfer tables, data, stored procedures, referential integrity constraints, security, and indexes. Specify the object(s) to transfer.

    可以傳輸表、數據、存儲過程、引用完整性約束、安全性和索引。請指定要傳輸的對象。

  • A relationship that does not enforce referential integrity appears as a thin line between the common fields supporting the relationship.

    不實施參照完整性的關系在支持該關系的公共字段之間顯示為細線。

  • Depending on which methods your database developers have used, the database will be vulnerable to different sorts of referential integrity issues.

    根據數據庫開發人員所使用手段的不同,應用程式的數據庫将會經受不同程度的引用完整性的問題。

  • It is very important to implement referential integrity when developing a DBAS (Database Application System).

    參照完整性的實施是數據庫應用系統設計的關鍵之一。

  • If one document contains the authoritative data that other documents refer to, it is more difficult to maintain referential integrity.

    如果一個文檔包含其他文檔引用的可靠數據,就很難維護引用完整性。

  • 專業解析

    參照完整性(Referential Integrity)是關系型數據庫中的核心約束機制,用于确保不同數據表間關聯關系的準确性和一緻性。其核心規則是:若表A包含指向表B的外鍵字段,則該外鍵的值必須與表B中對應主鍵的值完全匹配,或為空值(若允許空值)。

    這一概念由IBM研究員Edgar F. Codd在1970年提出,作為關系模型的十二準則之一。美國國家标準與技術研究院(NIST)數據庫資源指南指出,參照完整性通過阻止以下非法操作維護數據質量:

    1. 在從表中插入不存在于主表的外鍵值
    2. 删除主表中已被從表引用的記錄
    3. 修改主表主鍵值導緻從表外鍵失效

    微軟技術文檔顯示,現代數據庫系統如SQL Server通過FOREIGN KEY約束自動執行參照完整性。當違反規則時,系統可觸發級聯操作(CASCADE)、設為空值(SET NULL)或拒絕變更(NO ACTION)等處理策略。

    Oracle數據庫白皮書證實,實施參照完整性可降低數據冗餘率達30%-60%,同時提升事務處理可靠性。國際标準化組織ISO/IEC 9075标準明确規定參照完整性的語法規範和執行要求,确保跨平台數據庫的兼容性。

    網絡擴展資料

    參照完整性(Referential Integrity)是數據庫設計中的一個核心概念,用于确保數據庫中表之間關系的有效性和一緻性。以下是詳細解釋:

    1.定義

    參照完整性要求:如果一個字段(外鍵)引用了另一個表的主鍵,那麼該外鍵的值必須始終指向另一個表中實際存在的主鍵值,或者為NULL(如果允許空值)。這防止了“無效引用”或“孤兒記錄”的産生。

    2.核心作用

    3.實現方式

    通過外鍵約束(Foreign Key Constraint)實現,例如在SQL中:

    CREATE TABLE 訂單 (
    訂單ID INT PRIMARY KEY,
    客戶ID INT,
    FOREIGN KEY (客戶ID) REFERENCES 客戶(客戶ID)
    ON DELETE CASCADE
    );

    此代碼表示:删除客戶表中的某條記錄時,所有關聯訂單也會被自動删除。

    4.違反示例

    若未啟用參照完整性,可能出現以下問題:

    5.與其他完整性的區别

    參照完整性是維護數據庫邏輯可靠性的基石,尤其在涉及多表關聯的複雜系統中(如電商、ERP)。它通過外鍵約束強制執行業務規則,避免數據孤立或邏輯錯誤,從而提升整體數據質量。

    别人正在浏覽的英文單詞...

    banunmarriedbarrageimpelstellarauthorizationsbokodyedgerminationhalterMVAOslopixelsresendreusablechromosome doublingiodine valuepleistocene epochprobability densitySong of SongsAldebaranalleluiaDeinotherioideadisinsertionelandgibbanegreasepaintheptahedronintroflexionMapica