Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
22,295
result(s) for
"Database Design"
Sort by:
A data scientist's guide to acquiring, cleaning and managing data in R
The only how-to guide offering a unified, systemic approach to acquiring, cleaning, and managing data in REvery experienced practitioner knows that preparing data for modeling is a painstaking, time-consuming process. Adding to the difficulty is that most modelers learn the steps involved in cleaning and managing data piecemeal, often on the fly, or they develop their own ad hoc methods. This book helps simplify their task by providing a unified, systematic approach to acquiring, modeling, manipulating, cleaning, and maintaining data in R. Starting with the very basics, data scientists Samuel E. Buttrey and Lyn R. Whitaker walk readers through the entire process. From what data looks like and what it should look like, they progress through all the steps involved in getting data ready for modeling. They describe best practices for acquiring data from numerous sources; explore key issues in data handling, including text/regular expressions, big data, parallel processing, merging, matching, and checking for duplicates; and outline highly efficient and reliable techniques for documenting data and recordkeeping, including audit trails, getting data back out of R, and more.The only single-source guide to R data and its preparation, it describes best practices for acquiring, manipulating, cleaning, and maintaining dataBegins with the basics and walks readers through all the steps necessary to get data ready for the modeling processProvides expert guidance on how to document the processes described so that they are reproducibleWritten by seasoned professionals, it provides both introductory and advanced techniquesFeatures case studies with supporting data and R code, hosted on a companion websiteA Data Scientist's Guide to Acquiring, Cleaning and Managing Data in R is a valuable working resource/bench manual for practitioners who collect and analyze data, lab scientists and research associates of all levels of experience, and graduate-level data mining students.
eBook
PostgreSQL 10 High Performance
PostgreSQL is increasingly utilized in all kind of applications, starting from desktop to web and mobile applications. In this book, you will find the best ways to design, monitor and maintain your PostgreSQL solution, with suggestions and tips for high performance, troubleshooting and high availability.
eBook
Mastering postgreSQL 10 expert techniques on postgreSQL 10 development and administration
PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10.
eBook
Optimizing multi-tenant database architecture for efficient software as a service delivery
A multi-tenant database (MTDB) is the backbone for any cloud app that employs a software as a service (SaaS) delivery paradigm. Every cloud-based SaaS delivery strategy relies heavily on the architecture of multitenant databases. The hardware and performance costs for quicker query execution and space savings provided by the architecture of MTDBs are implementation costs. All tenants' data may be kept in a single table with a common schema and database format, making it the most cost-effective MTDB configuration. The arrangement becomes congested if tenants have varying storage needs. In this research, we present a space-saving architecture that improves transactional query execution while avoiding the waste of space due to different attribute needs. Extensible markup language (XML) and JavaScript object notation (JSON) compare the proposed system against the state of the art. The suggested multitenant database architecture reduces unnecessary space and improves query performance. The experimental findings show that the suggested system outperforms the state-ofthe-art extension table method.
Journal Article
Apache Hive Essentials
Apache Hive helps you deal with data summarization, queries, and analysis for huge amounts of data. This book will give you a background in big data, and familiarize you with your Hive working environment. Next you will cover advanced topics like performance and security in Hive and how to work efficiently to find solutions to big data problems.
eBook