Название: Business Database Technology: Theories and Design Process of Relational Databases, SQL, Introduction to OLAP, Overview of NoSQL Databases, 2nd Edition Автор: Shouhong Wang, Hai Wang Издательство: Universal Publishers Год: 2022 Страниц: 280 Язык: английский Формат: epub (true) Размер: 26.5 MB
Business Database Technology provides essential knowledge of database technology for four-year college/university business students who study information technology and data resource management.
Students will learn basic data structure techniques in databases, relational database model, design and implementation of relational databases, normalization, SQL, physical relational database design techniques, database administration, relational databases in computer networks, data warehouses, overview of OLAP (online analytical processing), and introduction to NoSQL databases.
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the relational data model. Previously, NoSQL referred to “non-relational” or “non-SQL”, but it actually means “Not only SQL”. This is because NoSQL systems commonly support SQL-like query languages and/or include relational (SQL) databases in integrated polyglot architectures.
Because NoSQL is mainly aimed at non-relational data models when the flexibility of data resource management and process speed, instead of data redundancy, are the major concerns, NoSQL approaches are rather artistic without restriction rules, depending upon the nature of the target applications. Thus, there is no NoSQL “standard”. Each NoSQL system has its unique user-interface environment. Unlike relational databases and SQL which can be understood through learning one typical database management system, NoSQL platforms differ one from another in many aspects, and there is no single “typical” NoSQL platform for learning diversified NoSQL applications.
PREFACE CHAPTER 1. INTRODUCTION CHAPTER 2. DATA STRUCTURE TECHNIQUES FOR DATABASES CHAPTER 3. DATA MODELS CHAPTER 4. RELATIONAL DATABASE CHAPTER 5. NORMALIZATION AND LOGICAL DATABASE DESIGN CHAPTER 6. DATABASE PROCESSING AND SQL CHAPTER 7. PHYSICAL DATABASE DESIGN CHAPTER 8. DATABASE IN COMPUTER NETWORKS CHAPTER 9. DATA WAREHOUSE CHAPTER 10. DATABASE ADMINISTRATION CHAPTER 11. ONLINE ANALYTICAL PROCESSING (OLAP) CHAPTER 12. NoSQL DATABASES TECHNICAL GUIDE A. CONSTRUCTING DATABASE USING MICROSOFT ACCESS TECHNICAL GUIDE B. AN EXAMPLE OF NORMALIZATION BASED ON DATASHEET SAMPLES ANSWERS TO EXERCISE QUESTIONS AND REVIEWS INDEX
Скачать Business Database Technology: Theories and Design Process of Relational Databases, SQL, Introduction to OLAP, 2nd Edition