Название: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, 2nd Edition
Автор: Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova
Издательство: Apress
Год: 2024
Страниц: 583
Язык: английский
Формат: pdf
Размер: 13.5 MB

Write optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine’s point of view, and know how to think like the database optimizer. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers. This second edition includes new examples using Postgres 15 and the newest version of the PostgresAir database. It includes additional details and clarifications about advanced topics, and covers configuration parameters in greater depth. Finally, it makes use of advancements in NORM, using automatically generated functions.

Название: Databricks Lakehouse Platform Cookbook: 100+ recipes for building a scalable and secure Databricks Lakehouse
Автор: Alan L. Dennis
Издательство: BPB Publications
Год: 2024
Страниц: 581
Язык: английский
Формат: epub (true)
Размер: 52.2 MB

Analyze, Architect, and Innovate with Databricks Lakehouse. The Databricks Lakehouse is groundbreaking technology that simplifies data storage, processing, and analysis. This cookbook offers a clear and practical guide to building and optimizing your Lakehouse to make data-driven decisions and drive impactful results. This definitive guide walks you through the entire Lakehouse journey, from setting up your environment, and connecting to storage, to creating Delta tables, building data models, and ingesting and transforming data. We start off by discussing how to ingest data to Bronze, then refine it to produce Silver. Next, we discuss how to create Gold tables and various data modeling techniques often performed in the Gold layer. You will learn how to leverage Spark SQL and PySpark for efficient data manipulation, apply Delta Live Tables for real-time data processing, and implement Machine Learning and Data Science workflows with MLflow, Feature Store, and AutoML. The book also delves into advanced topics like graph analysis, data governance, and visualization, equipping you with the necessary knowledge to solve complex data challenges. By the end of this cookbook, you will be a confident Lakehouse expert, capable of designing, building, and managing robust data-driven solutions. A good understanding of SQL, Python, Spark, and cloud computing would benefit the reader but is not required.

Название: Big Data and Hadoop: Fundamentals, tools, and techniques for data-driven success - 2nd Edition
Автор: Mayank Bhushan
Издательство: BPB Publications
Год: 2024
Страниц: 548
Язык: английский
Формат: epub (true)
Размер: 27.8 MB

In today's data-driven world, harnessing the power of big data is no longer a luxury, but a necessity. This comprehensive guide, "Big Data and Hadoop," dives deep into the world of big data and equips you with the knowledge and skills you need to conquer even the most complex data landscapes. Start with the fundamentals of big data, exploring its growing significance and diverse applications. You'll look into the heart of the Apache Hadoop ecosystem, mastering its core components like HDFS and MapReduce. We'll demystify NoSQL databases, introducing you to HBase and Cassandra as powerful alternatives to traditional databases. Clarify the details of MapReduce programming with practical examples, and discover the power of PigLatin and HiveQL for efficient data analysis. Explore advanced tools like Spark, unlocking its potential for real-time data processing and analytics. Rounding out your knowledge, the book delves into practical applications, exploring real-world scenarios and research-based insights. By the end of this book, you'll emerge as a confident big data explorer, equipped to tackle any data challenge with expertise and precision. Whether you are a beginner or have some experience with Big Data. This book is for aspiring Big Data professionals, including data analysts, software developers, IT professionals, and students in Computer Science and related fields.

Название: Hypothesis Generation and Interpretation: Design Principles and Patterns for Big Data Applications
Автор: Hiroshi Ishikawa
Издательство: Springer
Серия: Studies in Big Data
Год: 2024
Страниц: 380
Язык: английский
Формат: pdf (true)
Размер: 11.1 MB

This book focuses in detail on Data Science and data analysis and emphasizes the importance of data engineering and data management in the design of Big Data applications. The author uses patterns discovered in a collection of Big Data applications to provide design principles for hypothesis generation, integrating Big Data processing and management, Machine Learning and data mining techniques. The book proposes and explains innovative principles for interpreting hypotheses by integrating micro-explanations (those based on the explanation of analytical models and individual decisions within them) with macro-explanations (those based on applied processes and model generation). Practical case studies are used to demonstrate how hypothesis-generation and -interpretation technologies work. These are based on “social infrastructure” applications like in-bound tourism, disaster management, lunar and planetary exploration, and treatment of infectious diseases. The novel methods and technologies proposed in Hypothesis Generation and Interpretation are supported by the incorporation of historical perspectives on science and an emphasis on the origin and development of the ideas behind their design principles and patterns. In the Big Data era, characterized by volume, variety, and velocity, which generates a large amount of diverse data at high speed, the role of a hypothesis is more important to generate the final value, and such a hypothesis is more complicated and complex than ever. At the same time, the era of Big Data creates new vague concerns for end users as to whether Big Data relevant to them will be used appropriately.

Название: Synthetic dаta: Revolutionizing the Industrial Metaverse
Автор: Jimmy Nassif, Joe Tekli, Marc Kamradt
Издательство: Springer
Год: 2024
Страниц: 186
Язык: английский
Формат: pdf (true), epub
Размер: 47.2 MB

The book concentrates on the impact of digitalization and digital transformation technologies on the Industry 4.0 and smart factories, how the factory of tomorrow can be designed, built, and run virtually as a digital twin likeness of its real-world counterpart, before the physical structure is actually erected. It highlights the main digitalization technologies that have stimulated the Industry 4.0, how these technologies work and integrate with each other, and how they are shaping the industry of the future. It examines how multimedia data and digital images in particular are being leveraged to create fully virtualized worlds in the form of digital twin factories and fully virtualized industrial assets. It uses BMW Group’s latest SORDI dataset (Synthetic Object Recognition Dataset for Industry), i.e., the largest industrial images dataset to-date and its applications at BMW Group and Idealworks, as one of the main explanatory scenarios throughout the book. For decades, computer scientists attempted and failed to develop computer vision algorithms that could reliably identify what is inside an image—telling us whether an image contains a cat or a dog. Most had given up hope that we would solve this problem in our lifetime. That was until the invention of AlexNet ignited the Big Bang of modern Artificial Intelligence. There’s a beautiful duality to 3D computer graphics and computer vision. 3D computer graphics is a function that transforms a structured description of a 3D world into images over time—a simulation of what a camera sensor would experience in that world. Computer vision is the inverse of this function; transforming images over time into a structured representation of the 3D world. The AIs that will be the most impactful and valuable to human-kind will be the ones that can understand our real world and operate within it. To create these AIs, we must first model the real world and simulate it to generate the life experience for them.

Название: RHCSA Red Hat Enterprise Linux 9 Certification Study Guide (Exam EX200), 8th Edition
Автор: Michael Jang, Alessandro Orsaria
Издательство: McGraw Hill
Год: 2024
Страниц: 527
Язык: английский
Формат: pdf (true)
Размер: 47.6 MB

Take the latest editions of the challenging RHCSA and RHCE certification exams with confidence. This comprehensive self-study guide clearly explains what you need to know—and gets you fully prepared—for the RHCSA and RHCE certification exams. Written by a pair of Linux certification experts and experienced authors, this new edition has been thoroughly revised for Red Hat Enterprise Linux 8 and provides complete coverage of all exam objectives. RHCSA/RHCE Red Hat Enterprise Linux 8 Certification Study Guide, Eighth Edition (Exams EX200 & EX294) is an integrated study system based on proven pedagogy. Each chapter includes step-by-step exercises, special "Exam Watch" and "On the Job" sidebars, "Two-Minute Drills," self-tests, and hands-on lab questions. The companion website contains searchable glossaries, downloadable virtual machine files, four complete lab-based practice exams (two for each exam), and 100+ lab-based exercises with answers and explanations. Today, you can use Linux on everything from laptops and mobile devices to servers and mainframes. This makes Linux a versatile option for many different situations. Linux is also known for its strong security. Because it is open source, any security problems can be quickly found and fixed by the community. Linux also has strong rules about permissions and access, which makes it tough for harmful software to break in. Regular updates also help keep Linux safe and secure.

Название: The Complete Windows 11 User Manual - 9th Edition 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Страниц: 148
Язык: английский
Формат: pdf
Размер: 57.6 MB

Все, что нужно для освоения Windows 11! С момента своего выхода в октябре 2021 года Windows 11 быстро стала основной операционной системой для начинающих, средних и опытных пользователей компьютеров. Она призвана расширить границы, охватить повседневные цифровые технологии и помочь нам стать ближе друг к другу, чем когда-либо прежде. Она получила новый свежий вид и новый мощный код "под капотом". Все, что вам нужно, чтобы двигаться в будущее. Это руководство проведет вас через новейшую ОС Microsoft, предлагая на каждой странице что-то новое и давая необходимые знания, чтобы заставить Windows 11 работать на вас. Здесь вы найдете руководства и советы, откроете секреты ОС, а ваше понимание того, как все работает, поможет вам стать продвинутым пользователем. Итак, давайте погрузимся в Windows и начнем укреплять вашу уверенность и понимание этой замечательной операционной системы.

Название: Architecting Data and Machine Learning Platforms: Enable Analytics and AI-Driven Innovation in the Cloud (Final)
Автор: Marco Tranquillin, Valliappa Lakshmanan, Firat Tekiner
Издательство: O’Reilly Media, Inc.
Год: 2024
Страниц: 362
Язык: английский
Формат: pdf (true), epub (true)
Размер: 16.4 MB

What is a data platform? Why do you need it? What does building a data and Machine Learning (ML) platform involve? Why should you build your data platform on the cloud? This book starts by answering these common questions that arise when dealing with data and ML projects. We then lay out the strategic journey that we recommend you take to build data and ML capabilities in your business, show you how to execute on each step of that strategy, and wrap up all the concepts in a model data modernization case. All cloud architects need to know how to build data platforms that enable businesses to make data-driven decisions and deliver enterprise-wide intelligence in a fast and efficient way. This handbook shows you how to design, build, and modernize cloud native data and machine learning platforms using AWS, Azure, Google Cloud, and multicloud tools like Snowflake and Databricks.

Название: Architecting a Modern Data Warehouse for Large Enterprises
Автор: Anjani Kumar, Abhishek Mishra, Sanjeev Kumar
Издательство: Apress
Год: 2024
Страниц: 378
Язык: английский
Формат: pdf
Размер: 10.1 MB

Design and architect new generation cloud-based data warehouses using Azure and AWS. This book provides an in-depth understanding of how to build modern cloud-native data warehouses, as well as their history and evolution. The book starts by covering foundational data warehouse concepts, and introduces modern features such as distributed processing, big data storage, data streaming, and processing data on the cloud. You will gain an understanding of the synergy, relevance, and usage data warehousing standard practices in the modern world of distributed data processing. The authors walk you through the essential concepts of Data Mesh, Data Lake, Lakehouse, and Delta Lake. And they demonstrate the services and offerings available on Azure and AWS that deal with data orchestration, data democratization, data governance, data security, and business intelligence. After completing this book, you will be ready to design and architect enterprise-grade, cloud-based modern data warehouses using industry best practices and guidelines.

Название: Become a SQL Professional Overnight: The Simplified QuickStart guide for Beginners with Hands-on project
Автор: Aimee Mills
Издательство: Independently published
Год: 2023
Страниц: 204
Язык: английский
Формат: pdf
Размер: 33.1 MB

Unraveling the Overnight SQL Mastery. In a world where time is of the essence, the prospect of becoming a SQL professional overnight might seem like a tantalizing promise. "Become a SQL Professional OVERNIGHT" is a book that boldly claims to transform your understanding of SQL in a remarkably short span. As we embark on this journey of accelerated learning, it's crucial to pause and reflect on the implications of such a bold proposition. The book sets the stage with an assertive promise: the ability to master SQL in the blink of an eye. While this assertion may raise eyebrows and elicit skepticism, it taps into the collective desire for efficiency and instant expertise. As we delve into the content, it becomes evident that the approach is not about shortcuts but rather a strategic and intensive immersion into the world of SQL. This is not just a book; it's a catalyst for transformation, a key to unlocking doors that were once considered time prohibitive. If you find yourself at the intersection of urgency and the need for SQL proficiency, this book beckons you. Embrace the challenge, embark on an accelerated learning journey, and redefine your professional trajectory. The keys to SQL mastery await, promising not just efficiency but a profound transformation in your approach to data. Dive in, and let the overnight transformation begin.