Advanced Database Systems

Cover....1 Title Page....2 Copyright....3 About The Editor....4 Contents....6 List of Figures....12 List of Tables....14 List of Abbreviations....16 Preface....18 Chapter 1: Introduction To Database Systems....20 Unit Introduction....20 1.1. Basics Of Database Systems....23 1.2. History Of Database Systems....25 1.3. Importance Of Database Systems....26 1.4. Components Of Database Systems....28 1.5. Data Storage And Retrieval....34 1.6. Characteristics Of Database Systems....35 1.7. Architecture Of Database Systems....37 1.8. Query Processing And Optimization....39 1.9. Importance Of Database Systems In Modern World....40 Summary....42 Multiple Choice Questions....42 Review Questions....43 References....44 Chapter 2: Types Of Databases....48 Unit Introduction....48 2.1. Hierarchical Databases....51 2.2. Network Databases....57 2.3. Relational Databases....64 2.4. Object-oriented Databases....72 2.5. Graph Databases....79 2.6. Nosql Databases....86 2.7. Document Databases....93 Summary....100 Review Questions....100 Multiple Choice Questions....100 References....103 Chapter 3: Database Modeling....112 Unit Introduction....112 3.1. Overview Of Data Modeling....115 3.2. The Entity-relationship Model....117 3.3. Database Design Is A Part Of Data Modeling....119 3.4. Classifying Data Objects And Relationships....122 3.5. Derived Attributes And Code Values....125 3.6. Developing The Basic Schema....130 3.7. Refining – The Entity-relationships Diagrams....133 3.8. Primary And Foreign Keys....135 3.9. Adding Qualities To The Model....139 3.10. Generalization Hierarchies....142 3.11. Adding Data Integrity Rules....144 3.12. Outline Of The Relational Model....147 Summary....149 Review Questions....149 Multiple Choice Question....149 References....151 Chapter 4: Big Data Analytics....158 Unit Introduction....158 4.1. Data Structures....161 4.2. Analyst Outlook On Data Repositories....162 4.3. Formal Practice In Analytics....165 4.4. New Approaches To Analyzing Big Data....172 4.5. Importance Of Different Immense Data Ecosystem....175 Summary....179 Review Questions....179 Multiple Choice Questions....179 References....180 Chapter 5: Stream Processing Systems....186 Unit Introduction....186 5.1. Characteristics Of Stream Processing Systems....189 5.2. Stream Processing Frameworks....190 5.3. Stream Processing Applications....191 5.4. Integration With Database Management Systems....192 5.5. Challenges Of The Stream Processing....194 5.6. Future Trends In Stream Processing Systems....195 5.7. Implications For Industry And Research....195 Summary....197 Review Questions....197 Multiple Choice Questions....197 References....199 Chapter 6: Cloud-based Database Systems....202 Unit Introduction....202 6.1. Structure Of Cloud Database....204 6.2. Cloud Database Service....208 6.3. Challenges To Cloud Database....210 Summary....213 Review Questions....213 Multiple Choice Questions....213 References....214 Chapter 7: Main Memory Database System....218 Introduction....218 7.1. Difference Between Main Memory And Magnetic Disks....220 7.2. Applications Of Data Partition....221 7.3. Frequency Of Backups....223 7.4. Impact Of Memory Resident Data....224 Summary....230 Review Questions....230 Multiple Choice Questions....230 References....231 Chapter 8: Advanced Database Security....234 Introduction....234 8.1. Development Of Advanced Database Security....236 8.2. Security Risks To Databases....237 8.3. Database Security Considerations....240 8.4. Encryption....241 Summary....247 Review Questions....247 Multiple Choice Questions....247 References....248 Index....252 Back Cover....258