TY - BOOK AU - Silberschatz,Abraham AU - Korth,Henry F. AU - Sudarshan,S. TI - Database system concepts SN - 0072958863 (hard : alk. paper) U1 - 005.74 22 PY - 2006/// CY - Boston PB - McGraw-Hill Higher Education KW - Database management N1 - Chapter 1 Introduction 1.1 Database-system applications 1.2 Purpose of database systems 1.3 View of data 1.4 Database languages etc. PART 1 RELATIONAL DATABASES Chapter 2 Relational model 2.1 Structure of relational databases 2.2 Fundamental relational algebra 2.3 Additional relational algebra operations 2.4 Extended relational algebra operations etc. Chapter 3 SQL 3.1 Background 3.2 Data definition 3.3 basic structure of SQL queries 3.4 Set operators etc. Chapter 4 Advanced SQL 4.1 SQL data types and schemas 4.2 Integrity constraints 4.3 Authorization 4.4 Embedded SQL etc. Chapter 5 Other relational languages 5.1 Tuple relational calculus 5.2 The domain relational calculus 5.3 Query-by-example 5.4 Datalog etc. PART 2 DATABASE DESIGN Chapter 6 Database design and the E-R model 6.1 Overview of the design process 6.2 The entity relationship model 6.3 Constraints 6.4 Entity relationships etc. Chapter 7 Relational database design 7.1 Features of good relational designs 7.2 Atomic domains and first normal formal 7.3 Decomposition using functional dependencies 7.4 Functional-dependency etc. Chapter 8 Application design and development 8.1 User interfaces and tools 8.2 Web interfaces 8.3 Web fundamentals 8.4 Servlets and JSP etc. PART3 OBJECT-BASED DATABASES AND XML Chapter 9 Object-based databases 9.1 Overview 9.2 Complex data types 9.3 Structured types and inheritance in SQL 9.4 Table inheritance etc. Chapter 10 XML 10.1 Motivation 10.2 Structure of XML data 10.3 XML document schema 10.4 Querying and transformation etc. PART 4 DATA STORAGE AND QUERYING Chapter 11 Storage and file structure 11.1 Overview of physical 11.2 Magnetic disks 11.3 RAID 11.4 Tertiary storage etc. Chapter 12 Indexing and hashing 12.1 Basic concepts 12.2 Ordered indices 12.3 B+-tree index files 12.4 B-tree index files etc. Chapter 13 Query processing 13.1 Overview 13.2 Measures of query cost 13.3 Selection operation 13.4 Sorting etc. Chapter 14 Query optimization 14.1 Overview 14.2 Transformation of relational expressions 14.3 Estimating statistics of expression results 14.4 Choice of evaluation plans etc. PART 5 TRANSACTION MANAGEMENT Chapter 15 Transactions 15.1 Transaction concept 15.2 transaction state 15.3 Implementation of atomicity and durability 15.4 concurrent executions etc. Chapter 16 Concurrency control 16.1 Lock-based protocols 16.2 Timestamp-based protocols 16.3 Validation-based protocols 16.4 Multiple granularity etc. Chapter 17 Recovery system 17.1 Failure classification 17.2 Storage structure 17.3 Recovery and atomicity 17.4 Log-based recovery etc. PART 6 DATA MINING AND INFORMATION RETRIEVAL Chapter 18 Data analysis and mining 18.1 Decision support systems 18.2 Data analysis 18.3 Data warehousing 18.4 Data mining etc. Chapter 19 Information retrieval 19.1 Overview 19.2 Relevance ranking using terms 19.3 Relevance using hyperlinks 19.4 Synonyms, homonyms and ontologies etc. PART 7 SYSTEM ARCHITECTURE Chapter 20 Database system architecture 20.1 Centralized and client server architectures 20.2 Server system architectures 20.3 Parallel systems 20.4 Distributed systems etc. Chapter 21 Parallel databases 21.1 Introduction 21.2 I/O parallelism 21.3 Interquery parallelism 21.4 Intraquery parallelism etc. Chapter 22 Distributed databases 22.1 Homogeneous and heterogeneous databases 22.2 Distributed data storage 22.3 Distributed transactions 22.4 Commit protocols etc. PART 8 OTHER TOPICS Chapter 23 Advanced application development 23.1 Performance tuning 23.2 Performance benchmarks 23.3 Standardization 23.4 Application migration etc. Chapter 24 Advanced data types and new applications 24.1 Motivation 24.2 Time in databases 24.3 Spatial and geographic data 24.4 Multimedia databases etc. Chapter 25 Advanced transaction processing 25.1 Transaction processing monitors 25.2 Transaction workflows 25.3 E-commerce 25.4 Main memory databases etc. PART 9 CASE STUDIES Chapter 26 Poatgre SQL 26.1 Introduction 26.2 User interface 26.3 SQL variations and extensions 26.4 Transaction management in postgre SQL etc. Chapter 27 Oracle 27.1 Database design and querying tools 27.2 SQL variations and extensions 27.3 Storage and indexing 27.4 Concurrency etc. Chapter 28 IBM DB2 Universal database 28.1 Overview 28.2 Database design tools 28.3 SQL variations and extensions 28.4 Storage and indexing etc. Chapter 29 Microsoft SQL server 29.1 Management, design and querying 29.2 SQL variations and extensions 29.3 Storage and indexing 29.4 Query processing and optimization etc ; Bibliography : p. 1101 - 1128 .-- Index : p. 1129 - 1142 UR - http://www.loc.gov/catdir/toc/ecip059/2005006392.html UR - http://www.loc.gov/catdir/enhancements/fy0632/2005006392-d.html ER -