Search

Build scalable ETL data pipelines in the cloud using Azure Data Factory's Mapping Data Flows. Each chapter of this book addresses different aspects of an end-to-end data pipeline that includes repeatable design patterns based on best practices using ADF's code-free data transformation design tools. The book shows data engineers how to take raw business data at cloud scale and turn that data into business value by organizing and transforming the data for use in data science projects and analytics systems. The book begins with an introduction to Azure Data Factory followed by an introduction to its Mapping Data Flows feature set. Subsequent chapters show how to build your first pipeline and corresponding data flow, implement common design patterns, and operationalize your result. By the end of the book, you will be able to apply what you've learned to your complex data integration and ETL projects in Azure. These projects will enable cloud-scale big analytics and data loading and transformation best practices for data warehouses.What You Will LearnBuild scalable ETL jobs in Azure without writing codeTransform big data for data quality and data modeling requirementsUnderstand the different aspects of Azure Data Factory ETL pipelines from datasets and Linked Services to Mapping Data FlowsApply best practices for designing and managing complex ETL data pipelines in Azure Data FactoryAdd cloud-based ETL patterns to your set of data engineering skillsBuild repeatable code-free ETL design patternsWho This Book Is ForData engineers who are new to building complex data transformation pipelines in the cloud with Azure; and data engineers who need ETL solutions that scale to match swiftly growing volumes of data

With constantly expanding options such as Azure Data Lake Server (ADLS) and Azure SQL Data Warehouse (ADW), how can developers learn the process and components required to successfully move this data? Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse teaches you the basics of moving data between Azure SQL solutions using Azure Data Factory. Discover how to build and deploy each of the components needed to integrate data in the cloud with local SQL databases. Mark Beckner's step by step instructions on how to build each component, how to test processes and debug, and how to track and audit the movement of data, will help you to build your own solutions instantly and efficiently. This book includes information on configuration, development, and administration of a fully functional solution and outlines all of the components required for moving data from a local SQL instance through to a fully functional data warehouse with facts and dimensions.

Leverage the power of Microsoft Azure Data Factory v2 to build hybrid data solutionsKey FeaturesCombine the power of Azure Data Factory v2 and SQL Server Integration ServicesDesign and enhance performance and scalability of a modern ETL hybrid solutionInteract with the loaded data in data warehouse and data lake using Power BIBook DescriptionETL is one of the essential techniques in data processing. Given data is everywhere, ETL will always be the vital process to handle data from different sources. Hands-On Data Warehousing with Azure Data Factory starts with the basic concepts of data warehousing and ETL process. You will learn how Azure Data Factory and SSIS can be used to understand the key components of an ETL solution. You will go through different services offered by Azure that can be used by ADF and SSIS, such as Azure Data Lake Analytics, Machine Learning and Databrick's Spark with the help of practical examples. You will explore how to design and implement ETL hybrid solutions using different integration services with a step-by-step approach. Once you get to grips with all this, you will use Power BI to interact with data coming from different sources in order to reveal valuable insights. By the end of this book, you will not only learn how to build your own ETL solutions but also address the key challenges that are faced while building them. What you will learnUnderstand the key components of an ETL solution using Azure Data Factory and Integration ServicesDesign the architecture of a modern ETL hybrid solutionImplement ETL solutions for both on-premises and Azure dataImprove the performance and scalability of your ETL solutionGain thorough knowledge of new capabilities and features added to Azure Data Factory and Integration ServicesWho this book is forThis book is for you if you are a software professional who develops and implements ETL solutions using Microsoft SQL Server or Azure cloud. It will be an added advantage if you are a software engineer, DW/ETL architect, or ETL developer, and know how to create a new ETL implementation or enhance an existing one with ADF or SSIS.

As the first to focus on the issue of Data Warehouse Requirements Engineering, this book introduces a model-driven requirements process used to identify requirements granules and incrementally develop data warehouse fragments. In addition, it presents an approach to the pair-wise integration of requirements granules for consolidating multiple data warehouse fragments. The process is systematic and does away with the fuzziness associated with existing techniques. Thus, consolidation is treated as a requirements engineering issue.The notion of a decision occupies a central position in the decision-based approach. On one hand, information relevant to a decision must be elicited from stakeholders; modeled; and transformed into multi-dimensional form. On the other, decisions themselves are to be obtained from decision applications. For the former, the authors introduce a suite of information elicitation techniques specific to data warehousing. This information is subsequently converted into multi-dimensional form. For the latter, not only are decisions obtained from decision applications for managing operational businesses, but also from applications for formulating business policies and for defining rules for enforcing policies, respectively. In this context, the book presents a broad range of models, tools and techniques. For readers from academia, the book identifies the scientific/technological problems it addresses and provides cogent arguments for the proposed solutions; for readers from industry, it presents an approach for ensuring that the product meets its requirements while ensuring low lead times in delivery.

This book delves into the fundamentals of SAP BW based on SAP HANA Advanced Data Store Objects (aDSOs). Explore the various aDSO types and templates available and learn how to quickly create aDSOs specific to your business needs. Create, manage, and use aDSOs tables enhanced reporting capabilities. Dive into new objects in SAP BW on SAP HANA including open ODS views, composite providers, and advanced DSOs. Explore data modeling with SAP HANA Studio, using composite providers, advanced DSOs, open ODS views, and InfoObjects. Walk through detailed example of how to use templates, embed aDSOs in queries, and create your first query using field-based modeling. Get detailed information and guidelines on how to create a data acquisition layer, corporate memory, and data warehouse layer for delta calculation and datamart. By using practical examples, tips, and screenshots, this book explores: - Fundamentals of Advanced Data Store Objects - Modeling with SAP HANA Studio - How to create an SAP HANA-optimized InfoProvider - Examples and screenshots based on real-world scenarios

Planungs- und Reportinglösungen leiden in vielen Unternehmen immer noch unter mangelnder Datenqualität, sind unzureichend integriert und häufig zeit- und kostenintensiv.Dieses praxisorientierte Buch zeigt Schritt für Schritt, wie es anders geht. Es wird systematisch gezeigt, wie moderne Planungs- und Reportingsysteme im BI-gestützten Controlling mit dem Einsatz von Data-Warehouse- und Big-Data-Technologie aufgebaut werden.Für die 3. Auflage wurde das Buch umfassend aktualisiert. Hierbei wurde ein umfangreiches Beispiel mit Cockpitvorschlägen für die Bereiche Unternehmensleitung, Vertrieb, Einkauf und Projektsteuerung ergänzt. Zudem werden die neusten Entwicklungen im BI-gestützten Controlling mit Unterstützung der traditionellen und explorativen BI aufgezeigt, u. a. Data Mining, Predictive Analytics, Data Discovery, Data Visualization, App-Technologie, Self Service BI sowie Cloud Computing. Weitere Neuerungen betreffen die Themen Datenqualität und Datenmodellierung. Den Abschluss bildet weiterhin das wichtige Kapitel „Mobile BI“, bei dem es um den Ausbau von leistungsfähigen mobilen Analyse- und Planungslösungen mithilfe von Tablets, Handys und anderen mobilen Endgeräten geht.

Leverage the power of Redis 4.x to develop, optimize and administer your Redis solutions with ease Key Features[•]Build, deploy and administer high performance and scalable applications in Redis[•]Covers a range of important tasks - including development and administration of Redis[•]A practical guide that takes your understanding of Redis to the next levelBook DescriptionRedis is considered the world's most popular key-value store database. Its versatility and the wide variety of use cases it enables have made it a popular choice of database for many enterprises. Based on the latest version of Redis, this book provides both step-by-step recipes and relevant the background information required to utilize its features to the fullest. It covers everything from a basic understanding of Redis data types to advanced aspects of Redis high availability, clustering, administration, and troubleshooting. This book will be your great companion to master all aspects of Redis. The book starts off by installing and configuring Redis for you to get started with ease. Moving on, all the data types and features of Redis are introduced in detail. Next, you will learn how to develop applications with Redis in Java, Python, and the Spring Boot web framework. You will also learn replication tasks, which will help you to troubleshoot replication issues. Furthermore, you will learn the steps that need to be undertaken to ensure high availability on your cluster and during production deployment. Toward the end of the book, you will learn the topmost tasks that will help you to troubleshoot your ecosystem efficiently, along with extending Redis by using different modules.What you will learn[•]Install and configure your Redis instance[•]Explore various data types and commands in Redis[•]Build client-side applications as well as a Big Data framework with Redis[•]Manage data replication and persistence in Redis[•]Implement high availability and data sharding in Redis[•]Extend Redis with Redis Module[•]Benchmark, debug, fine-tune and troubleshoot various issues in RedisWho this book is forThis book is for database administrators, developers and architects who want to tackle the common and not so common problems associated with the different development and administration-related tasks in Redis. A fundamental understanding of Redis is expected to get the best out of this book.

This book dives into SAP BW on SAP HANA. Explore the fundamentals of data warehousing on SAP HANA and identify what is different about running in an SAP HANA environment. Readers can utilize this handbook prior to or post migration to maximize their ROI. Review data loading methods and virtualization options. Walk step by step through external data integration in SAP BW 7.4 including enhanced composite providers, open ODS views, and virtual tables. Explore the new reporting options for SAP BW on SAP HANA and look at changes to the BI analytical engine, calculated key figures, and query connections to SAP BusinessObjects tools. Dive into data architecture and learn more about virtualization options for enterprise data warehouse in conjunction with SAP HANA. Get detailed instructions for upgrading, maintaining, and running SAP BW on SAP HANA including service packs, transports, and admin functions. Learn more about modeling in SAP BW enabled by SAP HANA in regards to moving from LSA to LSA++. By using practical examples, tips, and screenshots, the author brings readers up to speed on running SAP BW on SAP HANA. - Tips for upgrading, maintaining, and running BW on HANA - Data loading methods and real-time data acquisition - New reporting paradigm for BW on HANA - HANA data architecture

Lernen Sie mit diesem Buch den richtigen Einsatz und die optimale Anwendung der Reporting- und Analysewerkzeuge von SAP, um Ihre Unternehmensdaten professionell auswerten und aufbereiten zu können. Von den neu eingeführten Cloud-Werkzeugen bis zum Einsatz von Embedded Analytics für das operative Reporting werden dabei alle aktuellen Entwicklungen berücksichtigt. Umfassende Schritt-für-Schritt-Anleitungen mit vielen Screenshots unterstützen Sie bei der konkreten Anwendung und Umsetzung.Aus dem Inhalt:Operatives und strategisches ReportingSAP BusinessObjects BI 4.2BEx Query Designer und der neue Eclipse-basierte Query-DesignerSAP BusinessObjects Analysis for Microsoft OfficeSAP Lumira Designer und DiscoverySAP Crystal Reports for EnterpriseSAP BusinessObjects Web IntelligenceSAP BusinessObjects MobileNeue Reporting-Tools für die CloudSAP HANA Live und SAP S/4HANA Embedded Analytics

What is SAP BW/4HANA? More importantly, what can it do for you? Between these pages, you'll explore the answers to these questions, from simplified data models and SAP BW/4HANA Analytics to automated data lifecycle management. You'll find step-by-step instructions for installation and setup, a guide to administrative tasks to keep your SAP BW/4HANA system in tip-top shape, and the low-down on security in your new system. Explore the data warehouse of the future!Highlights:-SAP HANA -SAP BW/4HANA Analytics -Installation and deployment -Data modeling -Reporting and analytics -Data lifecycle management -Administration -Security -Data warehousing solution

Planungs- und Reportinglösungen leiden in vielen Unternehmen immer noch unter mangelnder Datenqualität, sind unzureichend integriert und häufig zeit- und kostenintensiv. Dieses praxisorientierte Buch zeigt Schritt für Schritt, wie es anders geht und wie sich moderne Planungs- und Reportingsysteme mit Business Intelligence und dem Einsatz von Data-Warehouse- und/oder Big-Data-Technologie implementieren lassen. Die 2. Auflage erläutert dabei u.a. die neusten Entwicklungen einer explorativen BI mit Data Mining bzw. Predictive Analytics sowie Cloud Computing. Weiterhin werden personelle und organisatorische Innovationen hinsichtlich der Etablierung eines Data Scientist und der Nutzung von Self-Service BI im Unternehmen vorgestellt. Den Abschluss bildet das wichtige Thema „Mobile BI“, bei dem es um den Ausbau von leistungsfähigen mobilen Analyse- und Planungslösungen mithilfe von Tablets, Handys und anderen mobilen Endgeräten geht. Zahlreiche Tipps und Gestaltungsvorschläge für Einzelberichte, Planungsformulare und komplette Cockpit- und Dashboard-Lösungen können als Anregung für die Weiterentwicklung der eigenen Planungs- und Reportinglösung genutzt werden.

Building upon his earlier book that detailed agile data warehousing programming techniques for the Scrum master, Ralph's latest work illustrates the agile interpretations of the remaining software engineering disciplines: - Requirements management benefits from streamlined templates that not only define projects quickly, but ensure nothing essential is overlooked. - Data engineering receives two new'hyper modeling'techniques, yielding data warehouses that can be easily adapted when requirements change without having to invest in ruinously expensive data-conversion programs. - Quality assurance advances with not only a stereoscopic top-down and bottom-up planning method, but also the incorporation of the latest in automated test engines. Use this step-by-step guide to deepen your own application development skills through self-study, show your teammates the world's fastest and most reliable techniques for creating business intelligence systems, or ensure that the IT department working for you is building your next decision support system the right way. - Learn how to quickly define scope and architecture before programming starts - Includes techniques of process and data engineering that enable iterative and incremental delivery - Demonstrates how to plan and execute quality assurance plans and includes a guide to continuous integration and automated regression testing - Presents program management strategies for coordinating multiple agile data mart projects so that over time an enterprise data warehouse emerges - Use the provided 120-day road map to establish a robust, agile data warehousing program

One of the most popular databases worldwide is the Microsoft's SQL Server. The Microsoft Azure Cloud is rapidly making T-SQL one of the standards of SQL among millions of companies. The Microsoft SQL Server 2012 T-SQL book is your key to mastering T-SQL. With easy to use sample tables, and 700 pages of real-world example's and explanations, this book is your perfect reference guide. Each chapter in this book starts with simple examples and continues to use a building block approach to teach both the new user and the advanced user. Pleasing to the eye, and stimulating to the mind, makes this book a worldwide masterpiece where all can learn.

Greenplum is the first open source data warehouse. Purchased and improved by EMC, sold to Dell, makes Greenplum one of the most powerful and widely-used systems in the world. This incredible MPP data warehouse is designed for on-premises systems and the cloud. This book details the architecture of the Greenplum Data Warehouse and the SQL commands available. This book is perfect for anyone who designs, administers or queries Greenplum. The book educates readers on how to create tables and indexes, how the data is distributed, and how the system processes the data. Plus, it is followed up with over 700 pages of SQL examples and explanations. The Authors Tera-Tom Coffing, who has written over 75 successful books on Data Warehousing and Leona Coffing, Chief Financial Officer (CFO) of Coffing Data Warehousing bring a combined 40 years of experience of data warehouse knowledge to create this must have book.

Sams Teach Yourself Big Data Analytics with Microsoft HDInsight in 24 Hours In just 24 lessons of one hour or less, Sams Teach Yourself Big Data Analytics with Microsoft HDInsight in 24 Hours helps you leverage Hadoop's power on a flexible, scalable cloud platform using Microsoft's newest business intelligence, visualization, and productivity tools. This book's straightforward, step-by-step approach shows you how to provision, configure, monitor, and troubleshoot HDInsight and use Hadoop cloud services to solve real analytics problems. You'll gain more of Hadoop's benefits, with less complexity–even if you're completely new to Big Data analytics. Every lesson builds on what you've already learned, giving you a rock-solid foundation for real-world success. Practical, hands-on examples show you how to apply what you learn Quizzes and exercises help you test your knowledge and stretch your skills Notes and tips point out shortcuts and solutions Learn how to… · Master core Big Data and NoSQL concepts, value propositions, and use cases · Work with key Hadoop features, such as HDFS2 and YARN · Quickly install, configure, and monitor Hadoop (HDInsight) clusters in the cloud · Automate provisioning, customize clusters, install additional Hadoop projects, and administer clusters · Integrate, analyze, and report with Microsoft BI and Power BI · Automate workflows for data transformation, integration, and other tasks · Use Apache HBase on HDInsight · Use Sqoop or SSIS to move data to or from HDInsight · Perform R-based statistical computing on HDInsight datasets · Accelerate analytics with Apache Spark · Run real-time analytics on high-velocity data streams · Write MapReduce, Hive, and Pig programs Register your book at informit.com/register for convenient access to downloads, updates, and corrections as they become available.

Dieses Praxishandbuch bietet einen Überblick der möglichen Anwendungsfelder und der rechtlichen Rahmenbedingungen von Big Data im Unternehmen. Im ersten Teil wird gezeigt, wie Entscheidungsprozesse mit Daten fundiert werden können und welche Anwendungsmöglichkeiten in verschiedenen Branchen denkbar sind. Der zweite Teil behandelt die rechtlichen Aspekte von Big Data. Die Autoren geben praktische Empfehlungen, wie Big Data-Anwendungen nach geltendem Recht umgesetzt werden können und dabei den technischen und organisatorischen Aufwand so gering wie möglich zu halten. Auch wird erläutert, wie Unternehmen ihre Datenbestände schützen können. Der dritte Teil beschäftigt sich mit den technischen Voraussetzungen von Big Data-Anwendungen.

One of the most popular databases in the world is IBM's DB2. This book has over 600 pages of SQL examples and explanations. This book is a must have for anyone who develops or writes SQL for an IBM DB2 system. Readers will also understand how to create tables, views and indexes. The Authors Tera-Tom Coffing, who has written over 75 successful books on Data Warehousing and Leslie Nolander, Chief Operations Officer (COO) of Coffing Data Warehousing bring a combined 40 years of experience of data warehouse knowledge to create this must have book.

If you're making the leap from SAP BW to SAP HANA, this book is your indispensable companion. Thanks to detailed pre-migration and post-migration steps, as well as a complete guide to the actual migration process, it's never been easier to HANA-ify your SAP BW system. Once your migration is complete, learn everything you need to know about data modeling, reporting, and administration. Are you ready for the next generation of SAP BW?Highlights:Implementation options Preparing for migration Step-by-step migration guide Post-migration steps LSA++ Data modeling Reporting Administration

Harness the power of Redis to integrate and manage your projects efficiently Key FeaturesBook DescriptionRedis is the most popular in-memory key-value data store. It's very lightweight and its data types give it an edge over the other competitors. If you need an in-memory database or a high-performance cache system that is simple to use and highly scalable, Redis is what you need. Redis Essentials is a fast-paced guide that teaches the fundamentals on data types, explains how to manage data through commands, and shares experiences from big players in the industry. We start off by explaining the basics of Redis followed by the various data types such as Strings, hashes, lists, and more. Next, Common pitfalls for various scenarios are described, followed by solutions to ensure you do not fall into common traps. After this, major differences between client implementations in PHP, Python, and Ruby are presented. Next, you will learn how to extend Redis with Lua, get to know security techniques such as basic authorization, firewall rules, and SSL encryption, and discover how to use Twemproxy, Redis Sentinel, and Redis Cluster to scale infrastructures horizontally. At the end of this book, you will be able to utilize all the essential features of Redis to optimize your project's performance.What you will learnBuild analytics applications using Bitmaps and HyperloglogsEnhance scalability with Twemproxy, Redis Sentinel, and Redis ClusterBuild a Time Series implementation in Node.js and RedisCreate your own Redis commands by extending Redis with LuaGet to know security techniques to protect your data (SSL encryption, firewall rules, basic authorization)Persist data to disk and learn the trade-offs of AOF and RDBUnderstand how to use Node.js, PHP, Python, and Ruby clients for RedisAvoid common pitfalls when designing your next solutionWho this book is forIf you are a competent developer with experience of working with data structure servers and want to boost your project's performance by learning about features of Redis, then this book is for you.

One of the most exciting new technologies is Columnar and one of the premier pioneers of this technology is Actian's Matrix database. This book details the architecture of the Matrix system and shows all SQL commands with real-world examples that work. This book educates readers on how to create tables and indexes, how the data is distributed, how columnar works, and how the system processes the data. Plus, it is followed up with over 500 pages of SQL examples and explanations. This book is a must have for anyone designing, implementing or querying a Matrix system. The Authors, Tera-Tom Coffing and Ed Bernier, bring experience and expertise together. Tom Coffing has written over 70 books on all technologies and is considered one of the best technical authors in the world. Ed Bernier is a past employee of Actian and Netezza, and has inside knowledge because of his system engineering background on a wide variety of systems.

Key FeaturesBook DescriptionThis book is for SQL developers who want to learn about Redis, the key value database for scalability and performance. Prior understanding of a programming language is essential; however no knowledge of NoSQL is required.What you will learnFamiliarise yourself with NoSQL and install RedisBuild solutions and enhance your web applications in RedisUnderstand the persistent mechanism for better scalabilityConfigure and tune the server to improve performanceIdentify bottlenecks and how to handle fault management in RedisLearn about backups and recovery strategies for the Redis environmentDiscover the commands and functions of RedisWho this book is forThis book is for SQL developers who want to learn about Redis, the key value database for scalability and performance. Prior understanding of a programming language is essential; however no knowledge of NoSQL is required.

One of the most exciting new database inventions is Columnar technology. HP has built one of the best columnar databases in the world. HP Vertica is designed for both on-premises and cloud technology. This book details the architecture of the HP Vertica database and the SQL commands available. The book educates readers on how to create tables and indexes, how the data is distributed, and how the system process the data. Plus, it is followed up with over 500 pages of SQL examples and explanations. This book is a must have for anyone designing, implementing or querying the HP Vertica system. The Authors Tera-Tom Coffing, who has written over 75 successful books on Data Warehousing and Leslie Nolander, Chief Operations Officer (COO) of Coffing Data Warehousing bring a combined 40 years of experience of data warehouse knowledge to create this must have book.

One of the most popular databases worldwide is Microsoft's SQL Server. Now Microsoft has introduced their MPP data warehouse system, designed for the cloud, called the Microsoft Azure SQL Data Warehouse. The Microsoft Azure Cloud is rapidly making T-SQL one of the standards of SQL among millions of companies. This book details the architecture of the Azure SQL Data Warehouse and the SQL commands available. This book is perfect for anyone who works with the Microsoft Azure SQL Data Warehouse. This book educates readers on how to create tables and indexes, how the data is distributed, and how the system process the data. Plus, it is followed up with over 700 pages of SQL examples and explanations. This book is a must have for anyone designing, implementing or querying the system. The Authors of Tera-Tom Coffing, who has written over 70 successful books and Todd Wilson, CTO of Coffing Data Warehousing bring a combination of minds together made up of experience and real business world knowledge.

This long-awaited resource offers the daily, weekly, monthly, quarterly, and yearly tasks that will make your SAP BW system shine. Walk through system setup and configuration to lay a sound foundation for effective data storage, and then employ performance tuning techniques to optimize system performance.Highlights:System design and installation System and data architecture Data loading and management Hardware maintenance Alerting Reporting performance tuning Database maintenance Data modeling performance tuning Log and trace cleanup System checks Housekeeping tasks

This book contains nearly 700 pages of brilliant Netezza examples ranging from simple commands to advanced procedures. Netezza SQL, like all others in the Genius Series, guides readers in a clear and logical manner using pictures and real-life examples. This book is a must-have for any Netezza environment.

You are going to love this book because your confidence and knowledge will soar. V14 Certification: Teradata Basics has been designed to help you pass the test, but it is so much more. It is an incredible reference guide, learning tool, and foundation for passing all the tests and becoming a Teradata Certified Master.

This book is for developers who are already proficient in programming and capable of designing systems using traditional databases, but are new to Redis. It is assumed that you understand the basics of Redis and are familiar with the various data structures. You are also expected to be proficient in one or more programming languages through which you want to use Redis.

Maximize the New and Improved Features of Oracle Database 12c Written by Master Principle Database Expert, Oracle, and Oracle ACE Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you'll find everything you need to know to get up and running quickly on Oracle Database 12c. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12c Architectural changes, such as Oracle Multitenant The most current information on upgrading and migrating to Oracle Database 12c The pre-upgrade information tool and parallel processing for database upgrades Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System Oracle RMAN enhancements, including cross-platform backup and recovery Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync SQL, PL/SQL, DML, and DDL new features Improvements to partitioning manageability, performance, and availability Advanced business intelligence and data warehousing capabilities Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges Manageability, performance, and optimization improvements