数据库

图书标准信息

• 作者 奥尼尔 著
• 出版社 高等教育出版社
• 出版时间 2001-05
• 版次 2
• ISBN 9787040100402
• 定价 49.50元
• 装帧 平装
• 开本 16开
• 纸张 胶版纸
• 页数 870页
• 字数 1344千字
• 正文语种 英语

【内容简介】

《数据库：原理编程与性能（影印版）（第2版）》自1994年初版以来，已成为学习、设计及使用关系数据库人员的一本经典教材。它从理论和实践两方面对数据库设计和编程均做了严谨的表述。其内容包括关系理论、数据库设计、数据库编程及运行-转储结果。每一部分均从基本原理出发，再用实际系统中的实例来说明。
本次修订版反映了6年来数据库领域总体的进步和发展动态，书中重点讲述了对象关系模型；介绍了一些系统（如Oracle、DB2和Informix等）中通用的新概念；对隔离技术作了更新介绍；对运行结果的表述更现代。相对于初始标准来说，SQL数据库语言有了非常重要的变化，所以对对象关系给予特别讲述。《数据库：原理编程与性能（影印版）（第2版）》还介绍了SQL-99设计方法及与之相关的原理方法及主要产品。《数据库：原理编程与性能（影印版）（第2版）》的作者是在数据库界工作30多年的资深专家，富于教学和实践经验。《数据库：原理编程与性能（影印版）（第2版）》力图在数据库领域各不相同的思想和趋势中找到一个统一的观点提供给读者。
《数据库：原理编程与性能（影印版）（第2版）》对于初接触数据库系统的读者不啻为一本极好的教材；对于那些对数据库领域的发展还未给予足够关注的人是一本易于接受的参考书；同时也是设计人员和编程人员及时更新知识的有用的参考书。
内容：1.简介2.关系模型3.基本SQL查询语言4.对象关系SQL5.数据库编程访问6.数据库设计7.完整性、视图、安全性和目录8.索引9.查询处理10.事务更新11.并行与分布式数据库附录A介绍性指南附录B编程细节附录CSQL语句语言附录D设置查询计数。

【作者简介】

ParickONeilisaprofessorofcomputerscienceattheUniersityofMassachusettsatBoston.Heisresponsibleforanumberofimportantresultsintransactonalperformanceanddiskaccessalgorithms,andheholdspatentsforhisworkintheseandotherdatabaseareas.
ElizabethONeilisaprofessorofcomputerscienceattheUniversityofMassachusettsatBoston.Sheservesasacomsult-anttoSybaseIQinConcor,Massachusetts,andhasworkedwithanumberofothercorporations,includinMicrosoftadnBolt,Beranek,andNewman.

【目录】

Foreword
Preface
Chapter1Introduction
1.1FundamentalDatabaseConcepts
HistoryofDatabaseSystems
TheRelationalandObject-RelationalModels
TheDatabaseSystemsCovered
ARelationalDatabaseExample
AnObject-RelationalDatabaseExample
1.2DatabaseUsers
1.3OverviewofRelationalandObject-RelationalDBMS
Chapter2:TheRelationalModel
Chapter3:BasicSQLQueryLanguage
Chapter4:TheObject-RelationalModel
Chapter5:ProgramstoAccessaDatabase
Chapter6:DatabaseDesign
Chapter7:Integrity,Views,Security,andCatalogs
Chapter8:Indexing
Chapter9:QueryProcessing
Chapter10:UpdateTransactions
Chapter11:ParallelandDistributedDatabases
1.4PuttingItAllTogether

Chapter2TheRelationalModel
2.1TheCAPDatabase
2.2NamingthePartsofaDatabase
DomainsandDatatypes
TablesandRelations
2.3RelationalRules
2.4Keys,Superkeys,andNullValues
NullValues
2.5Relationalalgebra
FundamentalOperationsofRelationalAlgebra
2.6Set-TheoreticOperations
TheUnion,Intersection,andDifferenceOperations
AssignmentandAlias
TheProductOperation
2.7NativeRelationalOperations
TheProjectionOperation
TheSelectionOperation
PrecedenceofRelationalOperations
TheJoinOperation
TheDivisionOperation
2.8TheInterdependenceofOperations
2.9IllustrativeExamples
2.10OtherRelationalOperations
OuterJoin
ThetaJoin

Chapter3BasicSQLQueryLanguage
3.1Introduction
SQLCapabilities
SQLHistory-StandardsandDialects
3.2SettingUptheDatabase
StandardTypographicalConventions
APracticalExercise
3.3SimpleSelectStatements
3.4Subqueries
TheINPredicate
TheQuantifiedComparisonPredicate
TheEXISTSPredicate
AWeaknessofSQL:TooManyEquivalentForms
3.5UNIONOperatorsandFORALLConditions
TheUNIONOperator
Division:SQL"FORALL..."Conditions
3.6SomeAdvancedSQLSyntax
TheINTERSECTandEXCEPTOperatorsinAdvancedSQL
JoinFormsinAdvancedSQL
OUTERJOIN
JoinFormsImplementedinDatabaseSystems
3.7SetFunctionsinSQLHandlingNullValues
3.8GroupsofRowsinSQL
3.9ACompleteDescriptionofSQLSelect
Identifiers
Expressions,Predicates,andthesearch_condition
ScalarSubqueriesasExpressions:AdvancedSQL
BasicSQLversusAdvancedSQL:Summary
ADiscussionofthePredicates
3.10Insert,Update,andDeleteStatements
TheInsertStatement
TheUpdateStatement
TheDeleteStatement
3.11ThePoweroftheSelectStatement
TheNon-ProceduralSelectStatement
TuringPower
LimitedPoweroftheBasicSQLSelectStatement

Chapter4Object-RelationalSQL
4.1Introduction
ORSQLCapabilities
FormofPresentationforThisChapter
Object-RelationalHistory
4.2ObjectsandTables
4.2.1ObjectTypesinORACLE
DefinitionoftheREFObjectReference
4.2.2INFORMIXRowTypesforObjects
AbsenceofRefsinINFORMIX
TypeInheritanceinINFORMIX
4.2.3ObjectsandTables:Summary
ObjectOrientation
4.3CollectionTypes
4.3.1CollectionTypesinORACLE
TableTypesandNestedTables
TwoTechniquesforRetrievingfromaTableofTables
UnnestingviaTableProducts
NestedCursors
ArrayTypesforVARRAYs
SQLSyntaxforCollectionsinORACLE
InsertsandUpdatesinORACLE
4.3.2CollectionTypesinINFORMIX
SetsinINFORMIX
ListsinINFORMIX
SQLSyntaxforCollectionsinINFORMIX
insertsandUpdatesinINFORMIX
4.3.3CollectionTypes:Summary
4.4ProceduralSQL,User-DefinedFunctions(UDFs),andMethods
4.4.1ORACLEPL/SQLProcedures,UDFs,andMethods
PL/SQL:ORACLEsProceduralSQLLanguage
UsingPL/LQLtoImplementMethodsinORACLE
UpdateMethods
4.4.2INFORMIXUser-DefinedFunctions
SPL:INFORMIXsProceduralSQLLanguage
UsingSPLtoImplementUDFsinINFORMIX
UpdateFunctions
4.4.3User-DefinedFunctions:Summary
4.5ExternalFunctionsandPackagedUser-DefinedTypes(UDTs)
BinaryDataandBLOBs
ExternalFunctions
Encapsulation
DistinctTypes
BLOBObjects
PackagedUDTsandOtherEncapsulatedUDTs
Summary

Chapter5ProgramstoAccessaDatabase
5.1IntroductiontoAccessaDatabase
ASimpleProgramUsingEmbeddedSQL
SelectingMultipleRowswithaCursor
5.2ConditionHandling
WheneverStatement:ScopeandFlowofControl
ExplicitErrorChecking
HandlingError:GettingErrorMessagesfromtheDatabase
IndicatorVariables
5.3SomeCommonEmbeddedSQLStatements
TheSelectStatement
TheDeclareVursorStatement
Chapter6DatabaseDesign
Chapter7Integrity,Views,Security,andCatalogs
Chapter8Indexing
Chapter9QueryProcessing
Chapter10UpdateTransactions
Chapter11ParallelandDistributedDatabases
AppendixAIntroductoryTutorial
AppendixBProgrammingDetails
AppendixCSQLStatementSyntax
AppendixDSetQueryCounts
SolutionstoSelectedExercises
Index