Litgu.ru - Литературный Гуру

Название: Learning and Operating Presto: Fast Federated SQL Analytics (Second Early Release)
Автор: Angelica Lo Duca, Vivek Bharathan, George Wang
Издательство: O’Reilly Media, Inc.
Год: 2023-01-13
Язык: английский
Формат: pdf, epub
Размер: 10.2 MB

The Presto community has mushroomed since its origins at Facebook in 2012. But ramping up this distributed SQL query engine can be challenging even for the most experienced engineers. This practical book shows you how to begin Presto operations at your organization to derive insights on datasets wherever they reside. Authors Angelica Lo Duca, Vivek Bharathan, and George Wang explain what Presto is, where it came from, and how it differs from other data warehousing solutions. You'll discover why Facebook, Uber, Twitter, and cloud providers, including AWS, Google Cloud, and Alibaba, use Presto and how you can quickly deploy Presto in production.

Название: Semantic Knowledge Modelling via Open Linked Ontologies: Ontologies in E-Governance
Автор: Stamatios Theocharis, George A. Tsihrintzis
Издательство: Springer
Серия: Artificial Intelligence-Enhanced Software and Systems Engineering
Год: 2023
Страниц: 381
Язык: английский
Формат: pdf (true)
Размер: 18.2 MB

Evolving technological advances in Artificial Intelligence-empowered Software present significant potential to lead e-Government towards more collective efforts, exchange of experiences on best practices both at national and international levels and dissemination of secluded administrative knowledge. In this book, novel semantic web-based and linked open data-based approaches are developed for the modelling and management of the huge volume of administrative data and the procedures followed by public sector bodies and for the production and management of relevant administrative knowledge. Knowledge in Semantic Web is in the form of triplets RDF, to which specific languages are focused. Their main object is the recovery of results upon submission of tailored questions in the form of triplets. Such languages are RQL and SPARQL.

Название: Mathematical Methods in Data Science
Автор: Jingli Ren, Haiyan Wang
Издательство: Elsevier
Год: 2023
Страниц: 260
Язык: английский
Формат: pdf (true), epub
Размер: 23.4 MB

Mathematical Methods in Data Science introduces a new approach based on network analysis to integrate Big Data into the framework of ordinary and partial differential equations for data analysis and prediction. The mathematics is accompanied with examples and problems arising in Data Science to demonstrate advanced mathematics, in particular, data-driven differential equations used. Chapters also cover network analysis, ordinary and partial differential equations based on recent published and unpublished results. Finally, the book introduces a new approach based on network analysis to integrate Big Data into the framework of ordinary and partial differential equations for data analysis and prediction. There are a number of books on mathematical methods in Data Science. Currently, all these related books primarily focus on linear algebra, optimization and statistical methods. However, network analysis, ordinary and partial differential equation models play an increasingly important role in Data Science.

Название: Resilient Oracle PL/SQL: Building Resilient Database Solutions for Continuous Operation (2nd Early Release)
Автор: Stephen B. Morris
Издательство: O’Reilly Media, Inc.
Год: 2023-01-10
Страниц: 325
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, and cloud architects with a concise yet comprehensive overview on how to use PL/SQL to develop resilient database solutions. A solid knowledge of relational databases such as, those from Oracle, IBM, Microsoft and others remains a good addition to the IT skillset. The same is true for the open source relational databases, such as, MySQL. Pretty much every developer job I’ve done has required at least some knowledge of SQL. Some jobs have also required knowledge of stored procedure languages, such as, PL/SQL. As you’ll see in the book, there is often a great deal of confusion about the role of SQL and PL/SQL in the context of high level languages, such as, Java, C#, jаvascript, and so on.

Название: Ultimate Linux Projects - 2nd Edition, 2023
Автор: Drew Sleep (Editor)
Издательство: Future Publishing
Год: 2023
Страниц: 132
Язык: английский
Формат: pdf (true)
Размер: 16.2 MB

Linux is the gateway to exciting open-source software, stimulating coding projects and, of course, impressive Raspberry Pi machinations. In Ultimate Linux Projects, we throw those doors wide open and explore the opportunities that Linus Torvalds’ creation can offer us. Inside, the minds behind Linux Format magazine provide their expertise to bring you specialist tutorials, guides and advice to help you get some extra joy from your machine. From coding masterclasses that will tell you how to tap into weather satellites and more, to plug-in-and-play Raspberry Pi guides, and open-source alternatives to popular services like Google Photos and Plex – we’re sure that if you’re a Linux fan, you’ll find something to obsess over here. So, pop that kettle on, boot up your machine and get ready to explore the possibilities that Linux has to offer.

Название: Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database, Third Edition
Автор: Thomas LaRock, Enrico van de Laar
Издательство: Apress
Год: 2023
Страниц: 410
Язык: английский
Формат: pdf, epub
Размер: 38.7 MB

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You’ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more.

Название: Acing the System Design Interview (MEAP v5)
Автор: Zhiyong Tan
Издательство: Manning Publications
Год: 2022
Страниц: 331
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

The system design interview can be the hardest part of the software engineering hiring process. This practical book gives you the insights, skills, and practice you need to ace the toughest system design interview questions and land the job and salary you want. Acing the System Design Interview teaches you how to effectively demonstrate your system design expertise in an interview environment. This in-depth guide's serious technical overviews cover everything there is to know about system design—from the frameworks for functional partitioning, to different API paradigms. This book is divided into two main parts. Part 1 is presented like a typical textbook, with chapters that cover the various topics discussed in a system design interview. Part 2 consists of discussions of sample interview questions that reference the concepts covered in part 1, and discusses antipatterns and common misconceptions and mistakes.

Название: Analyzing US Census dаta: Methods, Maps, and Models in R
Автор: Kyle Walker
Издательство: CRC Press
Серия: The R Series
Год: 2023
Страниц: 378
Язык: английский
Формат: pdf (true)
Размер: 147.7 MB

Census data are widely used by practitioners to understand demographic change, allocate resources, address inequalities, and make sound business decisions. Until recently, projects using US Census data have required proficiency with multiple web interfaces and software platforms to prepare, map, and present data products. This book introduces readers to tools in the R programming language for accessing and analyzing Census data, helping analysts manage these types of projects in a single computing environment. R is one of the most popular programming languages and software environments for statistical computing and is the focus of this book with respect to software applications. This section introduces some basics of working with R and covers some terminology that will help readers work through the sections of this book. The tidyverse ecosystem developed by RStudio is one of the most popular frameworks for data analysis in R and attempts to respond to problems introduced by package fragmentation. The tidyverse consists of a series of R packages designed to address common data analysis tasks (data wrangling, data reshaping, and data visualization, among many others) using a consistent syntax.

Название: MCA Microsoft 365 Certified Associate Modern Desktop Administrator Complete Study Guide with 900 Practice Test Questions: Exam MD-100 and Exam MD-101, 2nd Edition
Автор: William Panek
Издательство: Sybex
Год: 2023
Страниц: 971
Язык: английский
Формат: pdf (true)
Размер: 30.1 MB

Complete, UPDATED study guide for MCA Modern Desktop Administrator certification exams, MD-100 and MD-101. Covers new Windows 11, services, technologies, and more! MCA Microsoft 365 Certified Associate Modern Desktop Administrator Complete Study Guide, Second Edition, is your all-in-one guide to preparing for the exams that will earn you the MCA Modern Desktop Administrator certification! In this book, well-known Windows guru and five-time Microsoft MVP, William Panek, guides you through the latest versions of the Windows Client exam (MD-100) and the Managing Modern Desktops exam (MD-101). This one-stop resource covers 100% of the objectives for both exams, providing real world scenarios, hands-on exercises, and challenging review questions. You’ll also dive deeper into some of the more complex topics and technologies, including deploying, maintaining, and upgrading Windows; managing devices and data; configuring storage and connectivity; managing apps and data; and more.

Название: SQLite Internals : How The World's Most Used Database Works
Автор: Abdur-Rahmaan Janhangeer
Издательство: Leanpub
Год: 2023-01-02
Язык: английский
Формат: pdf (true), mobi, epub
Размер: 10.2 MB

SQLite is famous for it's ubiquity. This book is a deep dive into the mechanisms that drive it! To all SQLite lovers. This book discusses SQLite internals in depth. SQLite is a file-based database which is extremely reliable and stable. It is the world’s most used database. It’s used on military devices, on planes (the A350 for instance) and in space. The codebase and mechanisms it uses is extremely complex. The seemingly simple nature of it and adoption makes a good case for deep diving into in a fascinating piece of software. It also implemented many features years ahead of popular databases like partial indexes. It’s pronounced S-Q-L-ite, like mineral. SQLite is notorious for implenting a bunch of functionalities from scratch. It’s a daring, amazing, bold and crazy spirit which requires confidence and professionalism.