标准数据库技术词汇之ISO/IEC 9075-2（9）

字数 9094阅读 728评论 0赞 1

[**前言**](https://www.talkwithtrend.com/Article/264637 "**前言**")
[**ISO/IEC 2382（1）**](https://www.talkwithtrend.com/Article/264639 "**ISO/IEC 2382（1）**")
[**ISO/IEC 2382（2）**](https://www.talkwithtrend.com/Article/264641 "**ISO/IEC 2382（2）**")
[**ISO/IEC 2382（3）**](https://www.talkwithtrend.com/Article/264643 "**ISO/IEC 2382（3）**")
[**ISO/IEC 2382（4）**](https://www.talkwithtrend.com/Article/264667 "**ISO/IEC 2382（4）**")
[**ISO/IEC 2382（5）**](https://www.talkwithtrend.com/Article/264671 "**ISO/IEC 2382（5）**")
[**ISO/IEC 2382（6）**](https://www.talkwithtrend.com/Article/264673 "**ISO/IEC 2382（6）**")
[**ISO/IEC 2382（7）**](https://www.talkwithtrend.com/Article/264679 "**ISO/IEC 2382（7）**")
[**ISO/IEC 2382（8）**](https://www.talkwithtrend.com/Article/264683 "**ISO/IEC 2382（8）**")
[**ISO/IEC 2382（9）**](https://www.talkwithtrend.com/Article/264687 "**ISO/IEC 2382（9）**")
[**ISO/IEC 2382（10）**](https://www.talkwithtrend.com/Article/264689 "**ISO/IEC 2382（10）**")
[**ISO/IEC 2382（11）**](https://www.talkwithtrend.com/Article/264693 "**ISO/IEC 2382（11）**")
[**ISO/IEC 2382（12）**](https://www.talkwithtrend.com/Article/264697 "**ISO/IEC 2382（12）**")
[**ISO/IEC 2382（13）**](https://www.talkwithtrend.com/Article/264707 "**ISO/IEC 2382（13）**")
[**ISO/IEC 9075-1（1）**](https://www.talkwithtrend.com/Article/264709 "**ISO/IEC 9075-1（1）**")
[**ISO/IEC 9075-1（2）**](https://www.talkwithtrend.com/Article/264713 "**ISO/IEC 9075-1（2）**")
[**ISO/IEC 9075-1（3）**](https://www.talkwithtrend.com/Article/264717 "**ISO/IEC 9075-1（3）**")
[**ISO/IEC 9075-2（1）**](https://www.talkwithtrend.com/Article/264725 "**ISO/IEC 9075-2（1）**")
[**ISO/IEC 9075-2（2）**](https://www.talkwithtrend.com/Article/264773 "**ISO/IEC 9075-2（2）**")
[**ISO/IEC 9075-2（3）**](https://www.talkwithtrend.com/Article/264777 "**ISO/IEC 9075-2（3）**")
[**ISO/IEC 9075-2（4）**](https://www.talkwithtrend.com/Article/264779 "**ISO/IEC 9075-2（4）**")
[**ISO/IEC 9075-2（5）**](https://www.talkwithtrend.com/Article/264781 "**ISO/IEC 9075-2（5）**")
[**ISO/IEC 9075-2（6）**](https://www.talkwithtrend.com/Article/264787 "**ISO/IEC 9075-2（6）**")
[**ISO/IEC 9075-2（7）**](https://www.talkwithtrend.com/Article/264807 "**ISO/IEC 9075-2（7）**")
[**ISO/IEC 9075-2（8）**](https://www.talkwithtrend.com/Article/264813 "**ISO/IEC 9075-2（8）**")

**ISO/IEC 9075-2（9）**

subtype (of a data type)
data type T2 such that every value of T2 is also a value of data type T1
Note 1 to entry: If T1 and T2 are not compatible, then T2 is a proper subtype of T1. “Compatible” is defined in Subclause 4.1.4, “Data type terminology”. See also supertype.
**（数据类型的）子类型**
数据类型T2，使得T2的每个值也是数据类型T1的值
注：如果T1与T2不兼容，则T2是T1的真子类型。

supertype (of a data type)
data type T1 such that every value of T2 is also a value of data type T1
Note 1 to entry: If T1 and T2 are not compatible, then T1 is a proper supertype of T2. “Compatible” is defined in Subclause 4.1.4, “Data type terminology”. See also subtype.
**（数据类型的）超类型**
数据类型T1，使得T2的每个值也是数据类型T1的值
注：如果T1与T2不兼容，则T1是T2的真超类型。

transliteration
method of translating characters in one character set into characters of the same or a different character set
**转写**
将一个字符集中的字符 转换 为 同一字符集 或不同字符集的字符的方法

type-preserving function
SQL-invoked function, one of whose parameters is a result SQL parameter
Note 1 to entry: The most specific type of the value returned by an invocation of a type-preserving function is identical to the most specific type of the SQL argument value substituted for the result SQL parameter.
**类型保留函数**
SQL调用函数，其参数之一是结果SQL参数
注：调用类型保留函数返回的值的最特定类型，与替换结果SQL参数的SQL实参值的最特定类型相同。

union row pattern variable
![](/home/attachment/202212/26/993931_167202231393167.png)
**联合行样式变量**
![](/home/attachment/202212/26/993931_167202234928703.png)

universal row pattern variable
implementation-dependent union row pattern variable that is defined implicitly as the union of all primary row pattern variables
**通用行样式变量**
依赖于实现的联合行样式变量，隐式地定义为所有主行样式变量的联合

user-defined type
data type whose interface is user-defined
**用户定义类型**
数据类型，其接口是用户定义的

variable-length
characteristic of the declared type of sites whose types are character string types or binary string types that allows values in those sites to contain any number of characters or octets, respectively, between 0 (zero) and some maximum number, known as the maximum length in characters or octets, respectively, of the site
**变长**
若干站点的声明类型的特性，其类型为字符串类型或二进制串类型，允许那些站点中的值分别包含介于0（零）与某最大数之间的任意数目的字符或八位字节，分别称为站点的最大字符长度或最大八位字节长度

white space
sequence of one or more characters that have no glyphs
![](/home/attachment/202212/26/993931_167202275466728.png)
**空格**
一个或多个无形字符的序列
![](/home/attachment/202212/26/993931_167202278333032.png)

with-return cursor
cursor that, when opened, creates a result set that is capable of becoming a returned result set
![](/home/attachment/202212/26/993931_167202294034290.png)
**带返回游标**
游标，其打开时创建结果集，该结果集能够成为返回的结果集
![](/home/attachment/202212/26/993931_167202296495643.png)

XQuery captured substring
captured substring, as defined by [XQueryFO]
XPath and XQuery Functions and Operators 【W3C标准】
When, in the course of evaluating a regular expression, a particular substring of the input matches a capturing sub-expression, that substring becomes available as a captured substring. The string matched by the Nth capturing sub-expression is referred to as the Nth captured substring. By convention, the substring captured by the entire regular expression is treated as captured substring 0 (zero).
**XQuery捕获子串**
在计算正则表达式过程中，当输入的特定子串与捕获子表达式匹配时，该子串成为捕获子串。
【译注：未提供此术语定义的文字描述，而是“借用”W3C标准《XPath and XQuery Functions and Operators》。《XPath and XQuery Functions and Operators》文本结构与国际标准不同，没有“定义”章节，术语定义不规范。属于不明确的定义。】

XQuery option flag
valid value of the $flags argument of fn:matches, as defined by [XQueryFO]
XPath and XQuery Functions and Operators 【W3C标准】
All these functions provide an optional parameter, $flags, to set options for the interpretation of the regular expression. The parameter accepts a xs:string, in which individual letters are used to set options. The presence of a letter within the string indicates that the option is on; its absence indicates that the option is off. Letters may appear in any order and may be repeated. If there are characters present that are not defined here as flags, then a dynamic error is raised [err:FORX0001].
Function  Meaning
fn:matches  Returns true if the supplied string matches a given regular expression.
**XQuery选项标志**
fn:matches的$flags实参的有效值。
【译注：本标准“定义”章节未提供 fn:matches 和 $flags 的定义。属于低质量的定义。】

XQuery regular expression
regular expression, as defined by [XQueryFO]
XPath and XQuery Functions and Operators 【W3C标准】
The regular expression syntax used by these functions is defined in terms of the regular expression syntax specified in XML Schema (see [XML Schema Part 2: Datatypes Second Edition]), which in turn is based on the established conventions of languages such as Perl. However, because XML Schema uses regular expressions only for validity checking, it omits some facilities that are widely-used with languages such as Perl. This section, therefore, describes extensions to the XML Schema regular expressions syntax that reinstate these capabilities.
XML Schema Definition Language (XSD) 1.1 Part 2: Datatypes 【W3C标准】
A regular expression R is a sequence of characters that denote a set of strings L(R). When used to constrain a  lexical space,  a regular expression R asserts that only strings in L(R) are valid literals  for values of that type.
**XQuery正则表达式**
正则表达式R是表征一组串 L(R) 的字符序列。当用于约束词空间时，正则表达式R判定只有断言只有 L(R) 中的串才是该类型值的有效文字。
【译注：未提供此术语定义的文字描述，而是“借用”W3C标准《XPath and XQuery Functions and Operators》。《XPath and XQuery Functions and Operators》转而采用W3C标准《XML Schema Definition Language (XSD) 1.1 Part 2: Datatypes》。属于不明确的定义。】

XQuery regular expression parenthesized sub-expression
regular expression parenthesized sub-expression, as defined by [XQueryFO]
XPath and XQuery Functions and Operators 【W3C标准】
Sub-expressions (groups) within the regular expression are recognized. The regular expression syntax defined by [XML Schema Part 2: Datatypes Second Edition] allows a regular expression to contain parenthesized sub-expressions, but attaches no special significance to them. Some operations associated with regular expressions (for example, back-references, and the fn:replace function) allow access to the parts of the input string that matched a sub-expression (called captured substrings).
**正则表达式由圆括号括起的子表达式**
正则表达式内识别的子表达式（组）。
注：正则表达式句法允许正则表达式包含若干由圆括号括起 的子表达式 。
【译注：未提供此术语定义的文字描述，而是“借用”W3C标准《XPath and XQuery Functions and Operators》。《XPath and XQuery Functions and Operators》文本结构与国际标准不同，没有“定义”章节，术语定义不规范。属于不明确的定义。】

XQuery replacement string
valid value of the $replacement argument of fn:replace, as defined by [XQueryFO]
**XQuery替换串**
fn:replace的$replacement 实参的 有效值
【译注：本标准“定义”章节未提供 fn:replace 和 $replacement 的定义。属于低质量的定义。】

数据库标准

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

标准数据库技术词汇之ISO/IEC 9075-2（9）

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料