Esssential Aspects of Physical Design and Implementation of Relational Databases

The Essential Aspects of Physical Implementation and Design of Relational Databases discusses the physical design and implementation of relational databases -- the two phases in building of databases that often do not get enough attention in textbooks on database design and management. The goal of this book is to give students a solid foundation on how to combine data design and the functionality of today's DBMS to achieve the most effective database and database applications. It provides illustration of essential aspects of physical design and implementation of relational databases with simple examples of real-world business problems. The book includes coverage of Physical Design, Distributed Database Design, Database Security, Database Query Processing and Performance, Transaction Management and Database Recovery. The book is based on the database program taught at the New York City College of Technology.

Citește tot Restrânge

Notă biografică

Prof. Tatiana Malyuta received her master's degree in Applied Mathematics and her PhD in Computer Science from the State University, Lviv, Ukraine. Prof. Malyuta has over twenty years of experience in database development; she consults as a subject matter expert in data design and data integration on projects that use relational and NoSQL data technologies. Her current interests, in addition to data science and technology, include ontologies and semantic technology. Prof. Ashwin Satyanarayana received his master's and PhD degrees in Computer Science from SUNY-Albany. He has over fifteen years of experience in Databases and Data Mining. He was an Applied Researcher at Microsoft, where he worked on Microsoft's search engine Bing. His current interests are in Data Mining, Machine Learning, Data Preparation, Information Theory, Applied Probability with applications in Real World Learning Problems.