TY  - BOOK
AU  - Kifer, Michael
AU  -  Bernstein, Arthur J.;
AU  -  Lewis, Philip M.
TI  - Database systems : an application-oriented approach
SN  - 0321312562
U1  - 005.6 KIF 
PY  - 2006///
CY  - Boston
PB  - Addison-Wesley.
KW  - Database management
KW  - Transaction systems (Computer systems)
N1  - Includes index; PART ONE Introduction Chapter 1 Overview of Databases and TransactionsWhat Are Databases and Transactions?Features of Modern Database and Transaction Processing SystemsMajor Players in the Implementation and Support of Database and Transaction Processing SystemsDecision Support Systems-OLAP and OLTP Chapter 2 The Big PictureCase Study: A Student Registration SystemIntroduction to Relational DatabasesWhat Makes a Program a Transaction-The ACID PropertiesBibliographic NotesExercises PART TWO Database Management Chapter 3 The Relational Data ModelWhat Is a Data Model?The Relational ModelSQL-Data Definition SublanguageBibliographic NotesExercises Chapter 4 Conceptual Modeling of Databases with Entity-Relationship Diagrams and the Unified Modeling LanguageConceptual Modeling with the E-R ApproachEntities and Entity TypesRelationships and Relationship TypesAdvanced Features in Conceptual Data ModelingFrom E-R Diagrams to Relational Database SchemasUML: A New Kid on the BlockA Brokerage Firm ExampleCase Study: A Database Design for the Student Registration SystemLimitations of Data Modeling MethodologiesBibliographic NotesExercises Chapter 5 Relational Algebra and SQLRelational Algebra: Under the Hood of SQLThe Query Sublanguage of SQLModifying Relation Instances in SQLBibliographic NotesExercises Chapter 6 Database Design with the Relational Normalization TheoryThe Problem of RedundancyDecompositionsFunctional DependenciesProperties of Functional DependenciesNormal FormsProperties of DecompositionsAn Algorithm for BCNF DecompositionSynthesis of 3NF SchemasThe Fourth Normal FormAdvanced 4NF DesignSummary of Normal Form DecompositionCase Study: Schema Refinement for the Student Registration SystemTuning Issues: To Decompose or Not to Decompose?Bibliographic NotesExercises Chapter 7 Triggers and Active DatabasesWhat Is a Trigger?Semantic Issues in Trigger HandlingTriggers in SQLAvoiding a Chain ReactionBibliographic NotesExercises Chapter 8 Using SQL in an ApplicationWhat Are the Issues Involved?Embedded SQLMore on Integrity ConstraintsDynamic SQLJDBC and SQLJODBCComparisonBibliographic NotesExercises PART THREE Optimizing DBMS Performance Chapter 9 Physical Data Organization and IndexingDisk OrganizationHeap FilesSorted FilesIndicesMultilevel IndexingHash IndexingSpecial-Purpose IndicesTuning Issues: Choosing Indices for an ApplicationBibliographic NotesExercises Chapter 10 The Basics of Query ProcessingOverview of Query ProcessingExternal SortingComputing Projection, Union, and Set DifferenceComputing SelectionComputing JoinsMultirelational JoinsComputing Aggregate FunctionsBibliographic NotesExercises Chapter 11 An Overview of Query OptimizationQuery Processing ArchitectureHeuristic Optimization Based on Algebraic EquivalencesEstimating the Cost of a Query Execution PlanEstimating the Size of the OutputChoosing a PlanBibliographic NotesExercises Chapter 12 Database TuningDisk CachesTuning the SchemaTuning the Data Manipulation LanguageToolsManaging Physical ResourcesInfluencing the OptimizerBibliographic NotesExercises PART FOUR Advanced Topics in Databases Chapter 13 Relational Calculus, Visual Query Languages, and Deductive DatabasesTuple Relational CalculusUnderstanding SQL through Tuple Relational CalculusDomain Relational Calculus and Visual Query LanguagesVisual Query Languages: QBE and PC DatabasesThe Relationship between Relational Algebra and the CalculiDeductive DatabasesBibliographic NotesExercises Chapter 14 Object DatabasesLimitations of the Relational Data ModelObject Databases versus Relational DatabasesThe Conceptual Object Data ModelObjects in SQL:1999 and SQL:2003The ODMG StandardCommon Object Request Broker ArchitectureBibliographic NotesExercises Chapter 15 XML and Web DataSemistructured Data Overview of XMLXML SchemaXML Query LanguagesBibliographic NotesExercises Chapter 16 Distributed DatabasesThe Application Designer's View of the DatabaseDistributing Data among Different DatabasesQuery Planning StrategiesBibliographic NotesExercises Chapter 17 OLAP and Data MiningOLAP and Data Warehouses-Old and NewA Multidimensional Model for OLAP ApplicationsAggregationROLAP and MOLAPImplementation IssuesPopulating a Data WarehouseData Mining TasksMining AssociationsClassification and Prediction Using Decision TreesClassification and Prediction Using Neural NetsClusteringBibliographic NotesExercises PART FIVE Transaction Processing Chapter 18 ACID Properties of TransactionsConsistencyAtomicityDurabilityIsolationThe ACID PropertiesBibliographic NotesExercises Chapter 19 Models of TransactionsFlat TransactionsProviding Structure within a TransactionStructuring an Application as Multiple TransactionsBibliographic NotesExercises Chapter 20 Implementing IsolationSchedules and Schedule EquivalenceRecoverability, Cascaded Aborts, and StrictnessModels for Concurrency ControlA Strategy for Immediate-Update Pessimistic Concurrency ControlsDesign of an Immediate-Update Pessimistic Concurrency ControlObjects and Semantic CommutativityAtomicity, Recoverability, and Compensating OperationsIsolation in Structured Transaction ModelsOther Concurrency ControlsBibliographic NotesExercises Chapter 21 Isolation in Relational DatabasesConflicts in a Relational DatabaseLocking and the SQL Isolation LevelsGranular Locking: Intention Locks and Index LocksTuning TransactionsMultiversion Concurrency ControlsBibliographic NotesExercises Chapter 22 Atomicity and DurabilityCrash, Abort, and Media FailureImmediate-Update Systems and Write-Ahead LogsRecovery in Deferred-Update SystemsRecovery from Media FailureBibliographic NotesExercises PART SIX Distributed Applications and the Web Chapter 23 Architecture of Transaction Processing SystemsTransaction Processing in a Centralized SystemTransaction Processing in a Distributed SystemThe TP Monitor: An OverviewThe TP Monitor: Global Atomicity and the Transaction ManagerThe TP Monitor: Remote Procedure CallThe TP Monitor: Peer-to-Peer CommunicationThe TP Monitor: Event CommunicationStorage ArchitecturesTransaction Processing on the InternetWeb Application Servers-J2EEBibliographic NotesExercises Chapter 24 Implementing Distributed TransactionsImplementing the ACID PropertiesAtomic TerminationTransfer of CoordinationDistributed DeadlockGlobal SerializationWhen Global Atomicity Cannot Be GuaranteedReplicated DatabasesDistributed Transactions in the Real WorldBibliographic NotesExercises Chapter 25 Web ServicesThe Basic IdeaWeb BasicsHypertext Transfer ProtocolSOAP: Message PassingWSDL: Specifying Web ServicesBPEL: Specifying Business ProcessesUDDI: Publishing and Discovering Information about ServicesWS-Coordination: Transactional Web ServicesBibliographic NotesExercises Chapter 26 Security and Electronic CommerceAuthentication, Authorization, and EncryptionEncryptionDigital SignaturesKey Distribution and AuthenticationAuthorizationAuthenticated Remote Procedure CallElectronic CommerceThe Secure Sockets Layer Protocol: CertificatesPassport: Single Sign-OnKeeping Credit Card Numbers PrivateThe Secure Electronic Transaction Protocol: Dual SignaturesGoods Atomicity, Certified Delivery, and EscrowElectronic Cash: Blind SignaturesSecurity in XML-Based Web ServicesBibliographic NotesExercises BibliographyIndexAppendices, available on the Web A An Overview of Transaction ProcessingIsolationAtomicity and DurabilityImplementing Distributed TransactionsBibliographic NotesExercises B Requirements and SpecificationsSoftware Engineering MethodologyThe Requirements Document for the Student Registration SystemRequirements Analysis-New IssuesSpecifying the Student Registration SystemThe Specification Document for the Student Registration System: Section IIIThe Next Step in the Software Engineering ProcessBibliographic NotesExercises C Design, Coding, and TestingThe Design ProcessTest PlanProject PlanningCodingIncremental DevelopmentThe Project Management PlanDesign and Code for the Student Registration SystemBibliographic NotesExercises
ER  -