Database Management Systems - Leon, 1/e Alexis Leon & Mathews Leon-S.CHAND
₹695.00
₹625.00
- Part I – Introduction: Data, Information and Information Processing
- Secondary (Auxiliary) Storage Devices
- Files, File Organization and Files Structures
- Indexing and Hashing
- Software Development Life Cycle (SDLC) and Database Development Life Cycle (DDLC)
- Information to Relational Database Management Systems (RDBMS)
- Part II – Database Architecture, Design and Data Modeling
- Database Architecture and Data Modeling
- Entity-Relationship (E-R) Modeling
- Enhanced Entity-Relationship (EER) Model
- Data Normalization
- Part III – Query Languages: Relational Algebra and Relational Calculus
- Tables Used in this Book
- Introduction to Structured Query Language (SQL)
- Tables, Views and Indexes
- Nulls
- Queries and Subqueries
- Aggregate Functions
- Insert, Update and Delete Operations
- Cursors
- Joins and Unions
- Programming with SQL
- Query-by-Example (QBE)
- QUEL
- Triggers
- Query processing and Optimization
- Part IV – Database Implementations Issues
- Database Security
- Data Integrity
- Transaction Management and Concurrency Control
- Backup and Recovery
- Part V – Database Technologies: Evolution of Computing Models
- Client/Server Technology and Client/Server Database
- Distributed Database
- Multidimensional Data and Database
- Parallel Processing and Parallel Database
- Spatial and Multimedia Database
- Mobile Computing and Mobile Database
- Web Database
- Part VI – Database Applications: Knowledge Discovery in Database (KDD)
- Data Warehousing and Data Marts
- Data Mining
- On-Line Transaction Processing (OLTP)
- On-Line Analytical Processing (OLAP)
- Customer Relationship Management (CRM)
- Supply Chain Management (SCM)
- Geographic Information System (GIS)
- Part VII – Appendices
