SQL Server術(shù)語(yǔ)詞匯表

《SQL Server術(shù)語(yǔ)詞匯表》由會(huì)員分享，可在線閱讀，更多相關(guān)《SQL Server術(shù)語(yǔ)詞匯表（50頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

1、術(shù)術(shù)語(yǔ)語(yǔ).NET FrameworkActiveX 數(shù)據(jù)對(duì)象(ActiveX DataObjects)ActiveX 數(shù)據(jù)對(duì)象MultiDimensional.NET(ActiveX DataObjects MultiDimensional.NET)ActiveX 數(shù)據(jù)對(duì)象（多維）(ActiveXData Objects(Multidimensional)ADO MDADOMD.NETAMOAPI 服務(wù)器游標(biāo)(API server cursor)B 樹(shù)(B-tree)bcp 文件(bcp file)CLRCLR 觸發(fā)器(CLR trigger)CLR 存儲(chǔ)過(guò)程(CLR stored proce

2、dure)CLR 函數(shù)(CLR function)CLR 用戶定義類型(CLR user-definedtype)CPU 忙(CPU busy)datareaderDBCSdboDDLDDL 觸發(fā)器(DDL trigger)DMLDML 觸發(fā)器(DML trigger)DMVDSNETLFor 循環(huán)容器(For Loop container)Foreach 循環(huán)容器(Foreach Loopcontainer)GACGCguestHoBTHTMLHTML 查看器(HTML Viewer)IAMIECInternet 協(xié)議安全(Internet Protocolsecurity)IPsecISO

3、KPILCIDLSNmaster 數(shù)據(jù)庫(kù)(master database)MBCSMDACMDXMicrosoft 數(shù)據(jù)訪問(wèn)組件(MicrosoftData Access Components)model 數(shù)據(jù)庫(kù)(model database)niladic 函數(shù)(niladic functions)NULLNull 鍵(null key)NUMAODBC 驅(qū)動(dòng)程序(ODBC driver)ODBC 數(shù)據(jù)源(ODBC data source)OLAPOLE DBOLE DB for OLAPOLE 自動(dòng)化對(duì)象(OLE Automationobjects)OLE 自動(dòng)化服務(wù)器(OLE Autom

4、ationserver)OLE 自動(dòng)化控制器(OLE Automationcontroller)PALRDARDBMSRDLReportViewer 控件(ReportViewercontrols)RIDRTIMSBCSSMDLSQLSQL Server 登錄名(SQL Server login)SQL Server 身份驗(yàn)證(SQL ServerAuthentication)SQL Server 事件轉(zhuǎn)發(fā)服務(wù)器(SQLServer Event Forwarding Server)SQL 表達(dá)式(SQL expression)SQL 查詢(SQL query)SQL 排序規(guī)則(SQL coll

5、ation)SQL 語(yǔ)句(SQL statement)tablixTDSTransact-SQLTransact-SQL 游標(biāo)(Transact-SQLcursor)UnicodeUnicode 格式(Unicode format)Unicode 排序規(guī)則(Unicode collation)uniqueifierVLDBWeb 服務(wù)(Web service)Web 同步(Web synchronization)Windows ManagementInstrumentationWindows 排序規(guī)則(Windows collation)Windows 數(shù)據(jù)訪問(wèn)組件(Windows DataA

6、ccess Components)(Windows DAC)WMIWMI 查詢語(yǔ)言(WMI Query Language)WQLXcopyXML for AnalysisXMLAXSLXSLT安全代碼(safe code)安全對(duì)象(securable)安全擴(kuò)展插件(security extension)安全套接字層（Secure SocketsLayer，SSL）安全主體(security principal)安裝程序初始化文件(Setupinitialization file)按范圍分區(qū)(range partitioning)半角字符(half-width character)半累加性度量值

7、(semiadditivemeasure)綁定(binding)包(package)包含列的索引(Included column index)保存點(diǎn)(savepoint)保護(hù)級(jí)別(protection level)報(bào)表布局(report layout)報(bào)表布局模板(report layouttemplate)報(bào)表呈現(xiàn)(report rendering)報(bào)表處理擴(kuò)展插件(report processingextension)報(bào)表定義(report definition)報(bào)表定義語(yǔ)言(Report DefinitionLanguage)報(bào)表服務(wù)器(report server)報(bào)表服務(wù)器 Web 服

8、務(wù)(Report ServerWeb service)報(bào)表服務(wù)器服務(wù)(Report Serverservice)報(bào)表服務(wù)器管理員(report serveradministrator)報(bào)表服務(wù)器數(shù)據(jù)庫(kù)(report serverdatabase)報(bào)表服務(wù)器文件夾命名空間(reportserver folder namespace)報(bào)表服務(wù)器執(zhí)行帳戶(report serverexecution account)報(bào)表快照(report snapshot)報(bào)表歷史記錄(report history)報(bào)表歷史記錄快照(report historysnapshot)報(bào)表鏈接(report link)報(bào)

9、表模型(report model)報(bào)表特定計(jì)劃(report-specificschedule)報(bào)表項(xiàng)(report item)報(bào)表執(zhí)行快照(report executionsnapshot)報(bào)告中間格式(report intermediateformat)備份集(backup set)備份設(shè)備(backup device)備用服務(wù)器(standby server)備用文件(standby file)備注(memo)被鏈接表(linked table)被引用鍵(referenced key)本地登錄標(biāo)識(shí)(local loginidentification)本地訂閱(local subscrip

10、tion)本地多維數(shù)據(jù)集(local cube)本地分發(fā)服務(wù)器(local Distributor)本地分區(qū)視圖(local partitionedview)本地服務(wù)器(local server)本地化(localization)本地組(local group)本機(jī)格式(native format)變化的維度(changing dimension)變量(variable)標(biāo)記(token)標(biāo)量(scalar)標(biāo)量聚合(scalar aggregate)標(biāo)識(shí)符(identifier)標(biāo)識(shí)列(identity column)標(biāo)識(shí)屬性(identity property)標(biāo)識(shí)字段(identifyi

11、ng field)標(biāo)注字符(diacritic character)表(table)表達(dá)式(expression)表達(dá)式宿主程序集(expression hostassembly)表格格式數(shù)據(jù)流(tabular data stream)表級(jí)約束(table-level constraint)表掃描(table scan)表數(shù)據(jù)區(qū)域(table data region)表鎖(table lock)別名(alias)別名(nickname)并發(fā)(concurrency)不安全代碼(unsafe code)不感知游標(biāo)(insensitive cursor)不可縮放 EM(Non-scalable E

12、M)不可縮放的 K-means(Non-scalable K-means)不可為 Null 的參數(shù)(nonnullableparameter)不可重復(fù)讀(nonrepeatable read)不齊整層次結(jié)構(gòu)(ragged hierarchy)布爾值(Boolean)部分備份(partial backup)部分差異備份(partial differentialbackup)參數(shù)(argument)參數(shù)化(parameterization)參數(shù)化報(bào)表(parameterized report)參數(shù)化行篩選器(parameterized rowfilter)層次結(jié)構(gòu)(hierarchy)查詢調(diào)控器(

13、query governor)查詢優(yōu)化器(query optimizer)查找表(lookup table)差異備份(differential backup)差異基準(zhǔn)(differential base)常量(constant)超文本標(biāo)記語(yǔ)言(Hypertext MarkupLanguage)撤消(revoke)撤消階段(undo phase)成員(member)成員委托(member delegation)成員屬性(member property)呈現(xiàn)的報(bào)表(rendered report)呈現(xiàn)對(duì)象模型(rendering objectmodel)呈現(xiàn)擴(kuò)展插件(rendering exten

14、sion)呈現(xiàn)擴(kuò)展插件(rendering extension)程序集(assembly)持久化計(jì)算列(persisted computedcolumn)持久性(persistence)初始快照(initial snapshot)初始同步(initial synchronization)觸發(fā)器(trigger)傳遞查詢(pass-through query)傳遞擴(kuò)展插件(delivery extension)傳遞順序(pass order)傳遞通道(delivery channel)傳遞通道類型(delivery channel type)傳遞協(xié)議(delivery protocol)傳遞語(yǔ)句

15、(pass-through statement)串聯(lián)(concatenation)創(chuàng)建器(producer)垂直分區(qū)(vertical partitioning)垂直篩選(vertical filtering)純?nèi)罩緜浞?pure log backup)詞干分析器(stemmer)詞匯切分(tokenization)磁帶備份(tape backup)粗粒度鎖(coarse-grained lock)存儲(chǔ)過(guò)程(stored procedure)存儲(chǔ)庫(kù)(repository)存儲(chǔ)庫(kù) SQL 架構(gòu)(Repository SQLschema)存儲(chǔ)庫(kù)對(duì)象(repository object)存儲(chǔ)庫(kù)類型信

16、息模型(Repository TypeInformation Model)存儲(chǔ)庫(kù)引擎(repository engine)錯(cuò)誤日志(error log)錯(cuò)誤狀態(tài)號(hào)(error state number)大容量日志恢復(fù)模式(bulk-loggedrecovery model)代理帳戶(proxy account)代碼訪問(wèn)安全性(code accesssecurity)代碼頁(yè)(code page)單用戶模式(single-user mode)單元(cell)單元集(cellset)單字節(jié)字符集(single-byte characterset)登錄安全模式(login security mode)

17、遞歸層次結(jié)構(gòu)(recursive hierarchy)點(diǎn)擊鏈接型報(bào)表(clickthrough report)訂閱(subscription)訂閱服務(wù)器(Subscriber)訂閱服務(wù)器(subscribing server)訂閱過(guò)期時(shí)間(subscriptionexpiration period)訂閱事件規(guī)則(subscription eventrule)訂閱數(shù)據(jù)庫(kù)(subscription database)訂閱預(yù)定規(guī)則(subscription scheduledrule)定位更新(positioned update)定型數(shù)據(jù)集(training data set)動(dòng)態(tài) SQL 語(yǔ)句(d

18、ynamic SQLstatement)動(dòng)態(tài)管理視圖(dynamic managementview)動(dòng)態(tài)恢復(fù)(dynamic recovery)動(dòng)態(tài)快照(dynamic snapshot)動(dòng)態(tài)連接字符串(dynamic connectionstring)動(dòng)態(tài)篩選器(dynamic filter)動(dòng)態(tài)鎖定(dynamic locking)動(dòng)態(tài)游標(biāo)(dynamic cursor)度量值(measure)度量值組(measure group)段落還原(piecemeal restore)斷點(diǎn)(breakpoint)斷字(word-breaking)斷字符(word breaker)隊(duì)列(queue)

19、對(duì)稱密鑰(symmetric key)對(duì)等復(fù)制(peer-to-peer replication)對(duì)等數(shù)據(jù)庫(kù)(peer database)對(duì)話(dialog)對(duì)齊(alignment)對(duì)象(object)對(duì)象變量(object variable)對(duì)象標(biāo)識(shí)符(object identifier)對(duì)象依賴關(guān)系(object dependencies)多播傳遞(multicast delivery)多對(duì)多關(guān)系(many-to-manyrelationship)多對(duì)多維度(many-to-many dimension)多對(duì)一關(guān)系(many-to-onerelationship)多服務(wù)器管理(multi

20、serveradministration)多個(gè)實(shí)例(multiple instances)多基準(zhǔn)差異備份(multibasedifferential)多維 OLAP(multidimensional OLAP)多維表達(dá)式(MDX)多維結(jié)構(gòu)(multidimensionalstructure)多維數(shù)據(jù)集(cube)多維數(shù)據(jù)集角色(cube role)多線程服務(wù)器應(yīng)用程序(multithreadedserver application)多用戶(multiuser)多重繼承(multiple inheritance)多字節(jié)字符集(multibyte characterset)二進(jìn)制大型對(duì)象(bina

21、ry large object)發(fā)布(publication)發(fā)布保持期(publication retentionperiod)發(fā)布表(publishing table)發(fā)布訪問(wèn)列表(publication accesslist)發(fā)布服務(wù)器(Publisher)發(fā)布服務(wù)器(publishing server)發(fā)布數(shù)據(jù)庫(kù)(publication database)反身關(guān)系(reflexive relationship)范圍查詢(range query)方法(method)防故障操作員(fail-safe operator)訪問(wèn)接口(provider)非鍵索引列(Nonkey index col

22、umn)非聚集索引(nonclustered index)非均衡層次結(jié)構(gòu)(unbalancedhierarchy)非強(qiáng)制關(guān)系(unenforced relationship)非托管代碼(unmanaged code)非葉(nonleaf)非葉成員(nonleaf member)非一致性內(nèi)存訪問(wèn)(non-uniform memoryaccess)分布式查詢(distributed query)分布式分區(qū)視圖(distributedpartitioned view)分布式事務(wù)(distributed transaction)分段(segmentation)分發(fā)(distribute)分發(fā)保持期(d

23、istribution retentionperiod)分發(fā)服務(wù)器(Distributor)分發(fā)數(shù)據(jù)庫(kù)(distribution database)分隔標(biāo)識(shí)符(delimited identifier)分隔符(delimiter)分配單元(allocation unit)分區(qū)(partition)分區(qū)(partitioning)分區(qū)方案(partition scheme)分區(qū)函數(shù)(partition function)分區(qū)快照(partitioned snapshot)分區(qū)依據(jù)列(partitioning column)分析管理對(duì)象(Analysis ManagementObjects)分組(

24、grouping)服務(wù)(service)服務(wù)程序(service program)服務(wù)器訂閱(server subscription)服務(wù)器聚合(server aggregate)服務(wù)器名稱(server name)服務(wù)器排序規(guī)則(server collation)服務(wù)器游標(biāo)(server cursor)服務(wù)主體名稱(service principalname)輔助服務(wù)器(secondary server)輔助數(shù)據(jù)庫(kù)(secondary database)父級(jí)(parent)復(fù)制(replication)復(fù)制的數(shù)據(jù)(replicated data)復(fù)制拓?fù)?replication topolo

25、gy)干擾詞(noise word)高可用性(high availability)格式化文件(format file)隔離級(jí)別(isolation level)跟蹤令牌(tracer token)跟蹤文件(trace file)更改腳本(change script)更新鎖(update lock)更新統(tǒng)計(jì)信息(update statistics)公共語(yǔ)言運(yùn)行時(shí)(common languageruntime)公用表表達(dá)式(common tableexpression)共享計(jì)劃(shared schedule)共享數(shù)據(jù)源項(xiàng)(shared data sourceitem)共享鎖(shared loc

26、k)共享維度(shared dimension)固定服務(wù)器角色(fixed server role)固定數(shù)據(jù)庫(kù)角色(fixed database role)故障轉(zhuǎn)移群集(failover clustering)關(guān)鍵績(jī)效指標(biāo)(key performanceindicator)關(guān)鍵字(keyword)關(guān)系(relationship)關(guān)系 OLAP(relational OLAP)關(guān)系對(duì)象(relationship object)關(guān)系類型(relationship type)關(guān)系數(shù)據(jù)庫(kù)(relational database)關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)(relationaldatabase manageme

27、nt system)歸置(collocation)規(guī)范化規(guī)則(normalization rules)規(guī)則(rule)規(guī)則(rules)規(guī)則觸發(fā)(rule firing)滾動(dòng)(scroll)滾動(dòng)更新文件(rollover file)國(guó)際標(biāo)準(zhǔn)化組織(InternationalOrganization for Standardization)國(guó)際電工委員會(huì)(InternationalElectrotechnical Commission)過(guò)程(process)過(guò)程緩存(procedure cache)過(guò)度擬合(overfitting)函數(shù)(function)行(row)行版本控制(row vers

28、ioning)行標(biāo)識(shí)符(row identifier)行集(rowset)行聚合函數(shù)(row aggregate function)行篩選器(row filter)行鎖(row lock)行溢出數(shù)據(jù)(row-overflow data)合并復(fù)制(merge replication)后代(descendant)候選鍵(candidate key)還原(restore)還原順序(restore sequence)緩沖池(buffer pool)幻影(phantom)恢復(fù)(recover)恢復(fù)(recovery)恢復(fù)點(diǎn)(recovery point)恢復(fù)分叉點(diǎn)(recovery fork point

29、)恢復(fù)分支(recovery branch)恢復(fù)間隔(recovery interval)恢復(fù)路徑(recovery path)恢復(fù)模式(recovery model)回滾(roll back)會(huì)話(conversation)會(huì)話(session)會(huì)話端點(diǎn)(conversation endpoint)會(huì)話句柄(conversation handle)混合 OLAP(hybrid OLAP)混合模式(Mixed Mode)活動(dòng)語(yǔ)句(active statement)伙伴(partner)基表(base table)基礎(chǔ)表(underlying table)基對(duì)象(base object)基數(shù)(c

30、ardinality)基準(zhǔn)備份(base backup)級(jí)別(level)級(jí)別(rank)級(jí)聯(lián)更新(cascading update)級(jí)聯(lián)刪除(cascading delete)即席報(bào)表(ad hoc report)集合(collection)計(jì)劃備份(scheduled backup)計(jì)劃強(qiáng)制(plan forcing)計(jì)劃指南(plan guide)計(jì)算成員(calculated member)計(jì)算傳遞(calculation pass)計(jì)算公式(calculation formula)計(jì)算機(jī) DSN(machine DSN)計(jì)算列(calculated column)計(jì)算列(comput

31、ed column)計(jì)算條件(calculation condition)計(jì)算子多維數(shù)據(jù)集(calculationsubcube)計(jì)算字段(calculated field)計(jì)算字段(computed field)記錄(record)記錄集(recordset)加密(encryption)架構(gòu)(schema)架構(gòu)快照(schema snapshot)架構(gòu)行集(schema rowset)監(jiān)視服務(wù)器(monitor server)檢查點(diǎn)(checkpoint)簡(jiǎn)單恢復(fù)模式(simple recovery model)見(jiàn)證服務(wù)器(witness server)鍵(key)鍵范圍鎖(key rang

32、e lock)鍵列(key column)鍵屬性(key attribute)僵停(zombie)交互式結(jié)構(gòu)化查詢語(yǔ)言(interactivestructured query language)角色(role)角色扮演維度(role-playingdimension)角色定義(role definition)角色分配(role assignment)角色切換(role switching)腳本(script)接口(interface)接口隱含(interface implication)結(jié)構(gòu)化查詢語(yǔ)言(Structured QueryLanguage)結(jié)果集(result set)結(jié)尾日志備份

33、(tail-log backup)解決策略(resolution strategy)僅下載類項(xiàng)目(download-only article)進(jìn)程間通信(interprocesscommunication)精度(precision)警報(bào)(alert)靜態(tài)連接字符串(static connectionstring)靜態(tài)行篩選器(static row filter)靜態(tài)游標(biāo)(static cursor)鏡像(mirroring)鏡像服務(wù)器(mirror server)鏡像媒體集(mirrored media set)鏡像數(shù)據(jù)庫(kù)(mirror database)局部變量(local variable

34、)矩形(rectangle)矩陣數(shù)據(jù)區(qū)域(matrix data region)聚合(aggregation)聚合查詢(aggregate query)聚合函數(shù)(aggregate function)聚合前綴(aggregation prefix)聚合設(shè)計(jì)(aggregation design)聚集索引(clustered index)聚類分析(clustering)決策樹(shù)(decision tree)決策支持(decision support)均衡層次結(jié)構(gòu)(balanced hierarchy)開(kāi)放式數(shù)據(jù)服務(wù)(Open Data Services)開(kāi)放式數(shù)據(jù)庫(kù)連接(Open Database

35、Connectivity)可變間隔(variable interval)可擴(kuò)展樣式表語(yǔ)言(ExtensibleStylesheet Language)可擴(kuò)展樣式表語(yǔ)言轉(zhuǎn)換(ExtensibleStylesheet Language Transformations)可為 Null 的屬性(nullable property)可信連接(trusted connection)可序列化(serializable)可預(yù)測(cè)列(predictable column)可執(zhí)行文件(executable)可重用書(shū)簽(reusable bookmark)刻度條(scale bar)客戶端訂閱(client subs

36、cription)客戶端應(yīng)用程序(client application)客戶端游標(biāo)(client cursor)空閑時(shí)間(idle time)控制流(control flow)控制流語(yǔ)言(control-of-flowlanguage)控制中斷報(bào)表(control-break report)庫(kù)(library)跨數(shù)據(jù)庫(kù)所有權(quán)鏈接(cross-databaseownership chaining)塊(blocks)快照(shadow copy)快照(snapshot)快照復(fù)制(snapshot replication)快照隔離級(jí)別(snapshot isolationlevel)快照共享(sna

37、pshot share)擴(kuò)展存儲(chǔ)過(guò)程(extended storedprocedure)擴(kuò)展屬性(extended property)垃圾收集(garbage collection)垃圾收集器(garbage collector)離散化列(discretized column)歷史記錄(chronicle)立即更新(Immediate Updating)立即更新訂閱(immediate updatingsubscriptions)利潤(rùn)圖(profit chart)粒度(granularity)粒度屬性(granularity attribute)粒子(particle)連接(connectio

38、n)連接管理器(connection manager)聯(lián)合數(shù)據(jù)庫(kù)服務(wù)器(federated databaseservers)聯(lián)機(jī)分析處理(online analyticalprocessing)聯(lián)機(jī)還原(online restore)聯(lián)機(jī)事務(wù)處理(online transactionprocessing)聯(lián)接(join)聯(lián)接表(junction table)聯(lián)接列(join column)聯(lián)接路徑(join path)聯(lián)接篩選器(join filter)聯(lián)接條件(join condition)聯(lián)接運(yùn)算符(join operator)鏈接報(bào)表(linked report)鏈接表(linking

39、table)鏈接度量值組(linked measure group)鏈接服務(wù)器(linked server)鏈接維度(linked dimension)兩階段提交(two-phase commit)列綁定(column binding)列表數(shù)據(jù)區(qū)域(list data region)列分隔符(column delimiter)列級(jí)排序規(guī)則(column-levelcollation)列級(jí)約束(column-level constraint)列篩選器(column filter)鄰近搜索(proximity search)臨時(shí)表(temporary table)臨時(shí)存儲(chǔ)過(guò)程(temporary

40、storedprocedure)瀏覽模式(browse mode)路徑(path)路由(route)輪詢查詢(polling query)邏輯記錄(logical record)邏輯名稱(logical name)邏輯運(yùn)算符(logical operators)碼位(code point)枚舉(enumeration)媒體標(biāo)頭(media header)媒體集(media set)密度(density)密碼策略(password policy)敏感游標(biāo)(sensitive cursor)明文(plaintext)命令(command)命令關(guān)系(command relationship)命名關(guān)系

41、(naming relationship)命名管道(named pipe)命名集(named set)命名實(shí)例(named instance)模糊分組(Fuzzy Grouping)模塊(module)模型依賴關(guān)系(model dependency)默認(rèn)成員(default member)默認(rèn)實(shí)例(default instance)默認(rèn)數(shù)據(jù)庫(kù)(default database)默認(rèn)值(default)目標(biāo)(destination)目標(biāo)分區(qū)(target partition)目標(biāo)服務(wù)器(target server)目標(biāo)適配器(destination adapter)內(nèi)部標(biāo)識(shí)符(internal

42、identifier)內(nèi)部聯(lián)接(inner join)內(nèi)核(kernel)內(nèi)容格式化程序(content formatter)內(nèi)置函數(shù)(built-in functions)逆透視(unpivot)匿名訂閱(anonymous subscription)爬網(wǎng)(crawl)排名函數(shù)(ranking function)排他鎖(exclusive lock)排序規(guī)則(collation)排序順序(sort order)派生列(derived column)配置(configuration)配置(configurations)配置文件(config file)配置文件(configuration fi

43、le)批處理(batch)批注屬性(annotational property)平面文件(flat file)平展界面(flattened interface)平展行集(flattened rowset)憑據(jù)(credential)啟動(dòng)(bootstrap)啟用寫功能(write enable)起始磁帶(initial tape)起始對(duì)象(origin object)前導(dǎo)字節(jié)(lead byte)前滾(roll forward)前滾集(roll forward set)前綴長(zhǎng)度(prefix length)前綴搜索(prefix search)前綴字符(prefix characters)嵌套

44、表(nested table)嵌套查詢(nested query)強(qiáng)制服務(wù)(forced service)切片(slice)請(qǐng)求訂閱(pull subscription)求解次序(solve order)區(qū)(extent)區(qū)域(region)區(qū)域設(shè)置(locale)區(qū)域設(shè)置標(biāo)識(shí)符(locale identifier)取模(modulo)全角字符(full-width character)全局程序集緩存(global assemblycache)全局訂閱(global subscription)全局規(guī)則(global rule)全局默認(rèn)值(global default)全文查詢(full-tex

45、t query)全文服務(wù)(full-text service)全文目錄(full-text catalog)全文搜索(Full-Text Search)全文索引(full-text index)權(quán)限(permission)熱備用服務(wù)器(hot standby server)任務(wù)(task)日志備份(log backup)日志傳送(log shipping)日志傳送操作(log shipping job)日志傳送配置(log shippingconfiguration)日志讀取器代理(Log Reader Agent)日志鏈(log chain)日志提供程序(log provider)日志文件(

46、log file)日志序列號(hào)(log sequence number)容器(container)篩選(filtering)篩選表達(dá)式(filter expression)篩選器(filter)上下文切換(context switch)設(shè)備類型(device type)設(shè)備名稱(device name)設(shè)置(provision)身份驗(yàn)證(authentication)深化/淺化(drill down/drill up)深化/淺化(drilldown/drillup)失敗的事務(wù)(failed transaction)時(shí)點(diǎn)恢復(fù)(point-in-time recovery)時(shí)間維度(time dim

47、ension)實(shí)例(instance)實(shí)體(entity)實(shí)體完整性(entity integrity)使非規(guī)范化(denormalize)事件(event)事件表(event table)事件處理程序(event handler)事件架構(gòu)(event schema)事件類(event class)事件歷史記錄(event chronicle)事件歷史記錄規(guī)則(event chroniclerule)事件收集存儲(chǔ)過(guò)程(event collectionstored procedures)事件提供程序(event provider)事件通知(event notification)事件源(event

48、 source)事例(case)事例集(case set)事例鍵(case key)事實(shí)(fact)事實(shí)數(shù)據(jù)表(fact table)事實(shí)維度(fact dimension)事務(wù)(transaction)事務(wù)保持期(transaction retentionperiod)事務(wù)處理(transaction processing)事務(wù)復(fù)制(transactional replication)事務(wù)回滾(transaction rollback)視圖生成(view generation)手動(dòng)故障轉(zhuǎn)移(manual failover)授予(grant)書(shū)簽(bookmark)輸入成員(input mem

49、ber)輸入集(input set)輸入源(input source)數(shù)據(jù)包(packet)數(shù)據(jù)爆炸(data explosion)數(shù)據(jù)備份(data backup)數(shù)據(jù)倉(cāng)庫(kù)(data warehouse)數(shù)據(jù)操作語(yǔ)言(data manipulationlanguage)數(shù)據(jù)成員(data member)數(shù)據(jù)處理擴(kuò)展插件(data processingextension)數(shù)據(jù)定義(data definition)數(shù)據(jù)定義查詢(data-definition query)數(shù)據(jù)定義語(yǔ)言(data definitionlanguage)數(shù)據(jù)集(dataset)數(shù)據(jù)控制語(yǔ)言(Data Control

50、Language)數(shù)據(jù)庫(kù)(database)數(shù)據(jù)庫(kù)備份(database backup)數(shù)據(jù)庫(kù)部分還原(partial databaserestore)數(shù)據(jù)庫(kù)對(duì)象(database object)數(shù)據(jù)庫(kù)關(guān)系圖(database diagram)數(shù)據(jù)庫(kù)架構(gòu)(database schema)數(shù)據(jù)庫(kù)角色(database role)數(shù)據(jù)庫(kù)腳本(database script)數(shù)據(jù)庫(kù)鏡像(database mirroring)數(shù)據(jù)庫(kù)鏡像伙伴(database mirroringpartners)數(shù)據(jù)庫(kù)快照(database snapshot)數(shù)據(jù)庫(kù)目錄(database catalog)數(shù)據(jù)庫(kù)所有者(

51、database owner)數(shù)據(jù)庫(kù)完整還原(complete databaserestore)數(shù)據(jù)庫(kù)文件(database file)數(shù)據(jù)庫(kù)項(xiàng)目(database project)數(shù)據(jù)庫(kù)語(yǔ)言(database language)數(shù)據(jù)塊(data block)數(shù)據(jù)類型(data type)數(shù)據(jù)連接(data connection)數(shù)據(jù)流(data flow)數(shù)據(jù)流任務(wù)(data flow task)數(shù)據(jù)流引擎(data flow engine)數(shù)據(jù)清理(data scrubbing)數(shù)據(jù)區(qū)域(data region)數(shù)據(jù)驅(qū)動(dòng)訂閱(data-drivensubscription)數(shù)據(jù)市場(chǎng)(dat

52、a mart)數(shù)據(jù)適配器(data adapter)數(shù)據(jù)收斂(data convergence)數(shù)據(jù)挖掘(data mining)數(shù)據(jù)挖掘模型定型(Data Mining ModelTraining)數(shù)據(jù)完整性(data integrity)數(shù)據(jù)源(data source)數(shù)據(jù)源名稱(data source name)數(shù)據(jù)源視圖(data source view)數(shù)據(jù)字典(data dictionary)數(shù)值表達(dá)式(numeric expression)刷新數(shù)據(jù)(refresh data)閂鎖(latch)雙字節(jié)字符集(double byte characterset)水平分區(qū)(horizon

53、tal partitioning)順序關(guān)系(sequenced relationship)順序集合(sequenced collection)死鎖(deadlock)搜索條件(search condition)碎片(fragmentation)所有權(quán)鏈(ownership chain)索引(index)索引 DDL 操作(index DDL operation)索引 OR 運(yùn)算(index ORing)索引分配映射(Index Allocation Map)索引視圖(indexed view)索引頁(yè)(index page)鎖(lock)鎖升級(jí)(lock escalation)特大型數(shù)據(jù)庫(kù)(ve

54、ry large database)特征(trait)提交(commit)提交事務(wù)(commit transaction)提取(fetch)提升圖(lift chart)填充(padding)填充(population)填充因子(fill factor)條帶媒體集(striped media set)條件性拆分(conditional split)同步(synchronization)同步管理器(synchronization manager)同等聯(lián)接(equijoin)同級(jí)(sibling)同類數(shù)據(jù)(homogeneous data)偷取的頁(yè)(stolen page)透視(perspecti

55、ve)透視(pivot)圖表數(shù)據(jù)區(qū)域(chart data region)推理攻擊(inference attack)推送訂閱(push subscription)托管代碼(managed code)脫離(defection)挖掘結(jié)構(gòu)(mining structure)挖掘模型(Mining Model)外表(foreign table)外部傳遞系統(tǒng)(external deliverysystem)外部聯(lián)接(outer join)外鍵(foreign key)外接程序(add-in)外圍應(yīng)用(surface area)完全外部聯(lián)接(full outer join)完整備份(full backu

56、p)完整差異備份(full differentialbackup)完整恢復(fù)模式(full recovery model)完整性約束(integrity constraint)網(wǎng)格(grid)網(wǎng)絡(luò)庫(kù)(Net-Library)為 Null 性(nullability)唯一索引(unique index)維持?jǐn)?shù)據(jù)(holdout data)維度(dimension)維度表(dimension table)維度粒度(dimension granularity)尾字節(jié)(trail byte)未知成員(unknown member)位圖篩選器(bitmap filter)位運(yùn)算(bitwise opera

57、tion)位置(position)溫備用服務(wù)器(warm standby server)文檔結(jié)構(gòu)圖(document map)文件 DSN(file DSN)文件差異備份(file differentialbackup)文件存儲(chǔ)類型(file storage type)文件滾動(dòng)(file rollover)文件還原(file restore)文件夾層次結(jié)構(gòu)(folder hierarchy)文件連接管理器(File connectionmanager)文件映射(file mapping)文件映射對(duì)象(file-mapping object)文件組(filegroup)問(wèn)題模板(question

58、 template)無(wú) DSN 連接(DSN-less connection)無(wú)法提交的事務(wù)(uncommitabletransaction)物理讀取(physical reads)物理名稱(physical name)物理設(shè)計(jì)結(jié)構(gòu)(physical designstructure)稀疏度(sparsity)稀疏文件(sparse file)系統(tǒng)變量(system variable)系統(tǒng)表(system tables)系統(tǒng)存儲(chǔ)過(guò)程(system storedprocedures)系統(tǒng)函數(shù)(system functions)系統(tǒng)角色定義(system roledefinition)系統(tǒng)角色分配(

59、system roleassignment)系統(tǒng)數(shù)據(jù)庫(kù)(system databases)細(xì)粒度鎖(fine-grained lock)先導(dǎo)貨幣(pivot currency)纖程模式(fiber mode)顯示計(jì)劃(Showplan)顯式事務(wù)(explicit transaction)線程(thread)相對(duì)日期(relative date)相關(guān)子查詢(correlated subquery)項(xiàng)目(article)項(xiàng)目級(jí)角色定義(item-level roledefinition)項(xiàng)目級(jí)角色分配(item-level roleassignment)象形文字(ideograph)象形字符(id

60、eographic character)消息隊(duì)列(Message Queuing)消息類型(message type)校驗(yàn)和(checksum)協(xié)定(contract)協(xié)議(protocol)寫回(write back)寫回(writeback)信息模型(information model)星型查詢(star query)星型架構(gòu)(star schema)星型聯(lián)接(star join)修飾(adornment)虛擬日志文件(virtual log file)虛影記錄(ghost record)虛影行(ghost row)序列容器(Sequence container)選擇列表(select l

61、ist)雪花型架構(gòu)(snowflake schema)延遲的事務(wù)(deferred transaction)延續(xù)磁帶(continuation tape)嚴(yán)重級(jí)別(severity level)驗(yàn)證（語(yǔ)法）(validation(syntactic)驗(yàn)證（語(yǔ)義）(validation(semantic)驗(yàn)證器(authenticator)業(yè)務(wù)邏輯處理程序(business logichandler)葉(leaf)葉成員(leaf member)葉級(jí)別(leaf level)頁(yè)(page)頁(yè)拆分(page split)頁(yè)面還原(page restore)一對(duì)多關(guān)系(one-to-manyrela

62、tionship)一對(duì)一關(guān)系(one-to-one relationship)依賴項(xiàng)(dependencies)已發(fā)布數(shù)據(jù)(published data)已分區(qū)表(partitioned table)已分區(qū)索引(partitioned index)異類(heterogeneous)異類數(shù)據(jù)(heterogeneous data)意向鎖(intent lock)引用表(reference table)引用完整性(referential integrity)引用維度(reference dimension)隱式權(quán)限(implied permission)隱式事務(wù)(implicit transact

63、ion)隱式游標(biāo)轉(zhuǎn)換(implicit cursorconversion)應(yīng)用程序(application)應(yīng)用程序角色(application role)應(yīng)用程序數(shù)據(jù)庫(kù)(applicationdatabase)硬編碼(hard-coding)用戶定義函數(shù)(user-defined function)用戶定義聚合（函數(shù)）(user-definedaggregate(function)用戶定義聚合函數(shù)(user-definedaggregate function)用戶實(shí)例(user instance)優(yōu)化的位圖篩選器(optimized bitmapfilter)優(yōu)先約束(precedence

64、constraint)由鍵集驅(qū)動(dòng)的游標(biāo)(keyset-drivencursor)游標(biāo)(cursor)游標(biāo)降級(jí)(cursor degradation)游標(biāo)庫(kù)(cursor library)有效策略(effective policy)有序集(ordered set)右外部聯(lián)接(right outer join)語(yǔ)言中的大小寫(linguistic casing)語(yǔ)義模型定義語(yǔ)言(Semantic ModelDefinition Language)預(yù)測(cè)(prediction)預(yù)計(jì)算分區(qū)(precomputed partition)預(yù)寫日志(write-ahead log)域(domain)域完整性(

65、domain integrity)元數(shù)據(jù)(metadata)元組(tuple)原始文件(raw file)原子(atomic)源(source)源代碼管理(source control)源對(duì)象(source object)源多維數(shù)據(jù)集(source cube)源分區(qū)(source partition)源和目標(biāo)(source and target)源適配器(source adapter)源數(shù)據(jù)庫(kù)(source database)遠(yuǎn)程表(remote table)遠(yuǎn)程存儲(chǔ)過(guò)程(remote storedprocedure)遠(yuǎn)程登錄標(biāo)識(shí)(remote loginidentification)遠(yuǎn)程分發(fā)

66、服務(wù)器(remote Distributor)遠(yuǎn)程分區(qū)(remote partition)遠(yuǎn)程服務(wù)綁定(remote servicebinding)遠(yuǎn)程數(shù)據(jù)(remote data)遠(yuǎn)程數(shù)據(jù)訪問(wèn)(remote data access)約束(constraint)躍點(diǎn)(hop)運(yùn)算符(operator)臟讀(dirty read)臟頁(yè)(dirty page)增量更新(incremental update)整數(shù)(integer)證書(shū)(certificate)支持 Internet(Internet-enabled)執(zhí)行樹(shù)(execution tree)直觀合計(jì)(visual total)直接連接(direct connect)直接響應(yīng)模式(direct response mode)值表達(dá)式(value expression)只進(jìn)游標(biāo)(forward-only cursor)智能標(biāo)記(smart tag)滯后時(shí)間(latency)仲裁(quorum)重播(replay)重新發(fā)布(republish)重新發(fā)布服務(wù)器(republisher)重做階段(redo phase)軸(axis)主表(p