Bazy danych
Robert (Kent) Collins, Mohankumar Saraswatipura
IBM Db2 is a relational database management system (RDBMS) that helps you store, analyze, and retrieve data efficiently. This comprehensive book is designed to help you master all aspects of IBM Db2 database administration and prepare you to take andpass IBM's Certification Exams C2090-600. Building on years of extensive experience,the authors take you through all areas covered by the test. The book delves deep into each certification topic: Db2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, and security. IBM Db2 11.1 Certification Guide provides you with more than 150 practice questions and answers, simulating real certification examination questions. Each chapter includes an extensive set of practice questions along with carefully explained answers.This book will not just prepare you for the C2090-600 exam but also help you troubleshoot day-to-day database administration challenges.
Instant MongoDB. Get up to speed with one of the the world's most popular NoSQLdatabase
Amol Nayak
MongoDB is a high-performance and feature-rich Document Orientated Database. This popular, highly scalableNoSQL database is used to power some of the world's most used applications and websites.MongoDB Starter is designed to get you working with MongoDB as quickly as possible. Starting with the installation and setup, we quickly show you how to start importing your data into the database. Furthermore, you will learn about CRUD operations in MongoDB, its Map Reduce support, schema design, and performance tuning operations.After successfully installing and setting up MongoDB, you will be introduced to important configuration parameters and the terminologies used in the Mongo world and their equivalent in the relational world. You will learn how to import data into the database and connect to the MongoDB from the Mongo shell and execute some queries. We will then move on to advanced topics such as performing insert, update and upsert(update + insert) operations, executing advanced queries, schema design concepts, and creating indexes for performance. MongoDB Starter finishes with a look at the new aggregation framework, Map Reduce operations, and how to bulk import and export data.
B. M. Madhusudhan Rao, B.M Madhusudhan Rao
Oracle Business Process Management helps in process automation and improvement with a very high level of flexibility for all the process participants from the process planning team to the end users. It also makes it possible to have corporate employees and customers collaborating towards common goals.Instant Oracle BPM for Financial Services How-to covers many concepts that can be easily reused across industries such as core banking, healthcare, travel, self service automation, e-governance, and so on. It highlights various roles of Business Process Management such as Business Process Modeling, Process Developer, Process Owner, and Process Participant along with the way they work together in a financial services environment.Instant Oracle BPM for Financial Services How-to is your guide to implementing Oracle Business Process Management whilst working in the Financial Services industry.Starting through the discovering of implementation and Business challenges for financial services we will move on to Modeling, Implementation, Process ork-flow’s, deployment and testing.Moving on to cover advanced topics such as Process administering, changing business processes using process analysts, business reporting, participants and notifications and finally collaboration. You will learn to setup, maintain and alter your Business Process Management aimed specifically for the Financial services industry.
Tony Bruzzese
Oracle GoldenGate is a comprehensive package for low-impact, real-time data capture, distribution, and delivery of transactional data across heterogeneous systems for continuous availability, zero downtime migration, and disaster recovery. All in all, it is a precise tool for data replication, regardless of the platform that you use in today’s environment. Instant Oracle GoldenGate exemplifies the ease of use of this package through the use of real-world examples. This book gives a good overview and hands-on approach to the most commonly used implementations in an Oracle GoldenGate environment.This How-to book will take you through a number of real-world examples quickly and effectively by eliminating much of the guess work for all users from novices to experienced users.You will learn about the key components of the architecture and simple one-way replication for a number of database tables or an entire schema. You’ll be covering key concepts and the implementation of high availability configurations such as Oracle RAC, encryption, and many different ways to transform and filter data to your target systems.
Satya SK Jayanty, Satya Shyam K Jayanty
SQL Server 2012 includes BI-specific features such as cube analytics, reporting-related features, multidimensional BI semantic models, and many more. This is a new addition that is of great use to Business Analysts, who can now build BI semantic models using the relational tables from the database engine rather than the dimensions from analysis services.Instant Microsoft SQL Server Analysis Services 2012 Cube Security is a practical, hands-on guide that provides clear, step-by-step recipes for getting started with cube security. As a Database Administrator and Data Architect, data security is of prime concern, and this book highlights the key concepts of securing cubes. By the end of this book, you will understand the SQL Server security model and how to effectively implement the same on the data platform.Security is paramount within a data platform, and thankfully, the issues surrounding data access can be fixed in the initial stages of its design. This allows you to avoid any breach of data access layers. The recipes in this book consist of the required ingredients to implement and administer OLAP & BI security management for your cubes. With this book, you will master the key aspects of implementing and managing security essentials and securing data layers.The recipes in this book incorporate best practice implementation, which include step-by-step instructions for creating models that implement security based on the currently logged on Windows user name or based on custom data passed to analysis services. The new BI platform features will help end users, business users, and technology users by providing a robust environment for IT, planning, budgeting, forecasting with scorecards, and reporting capabilities for the business users. These analytics will help end users to create a comprehensive management application to view the data with ease.
Andy Penver
Zestaw aplikacji Oracle jest wykorzystywany przez wiele znaczących przedsiębiorstw biznesowych oraz organizacji sektora publicznego na całym świecie. Oracle E-Business Suite jest najbardziej wszechstronnym zestawem zintegrowanych aplikacji dla dużych przedsiębiorstw, umożliwiającym podejmowanie lepszych decyzji, redukcję kosztów i zwiększanie wydajności. W tej książce pokazujemy, jak tworzyć rozmaite rozszerzenia stosując różne zestawy narzędzi. Zawiera ona szeroki wachlarz przykładów, jak krok po kroku rozwijać Oracle E-Business Suite Release 12 w wielu obszarach. Koncentrujemy się na personalizacji i tworzeniu w OA Framework integratora WebADI oraz wydawcy BI Publisher. W każdym z rozdziałów wyszczególniamy, jak poprawnie budować odpowiednie rozszerzenie, jednocześnie udostępniamy kompletny, w pełni przetestowany kod i skrypty do pobrania. Po każdym rozdziale Czytelnik będzie dobrze rozumiał, co należy czynić, by zacząć stosować omawiane narzędzia w dowolnej dziedzinie. Dla kogo jest ta książka? Ta książka jest dla każdego, kto chce się nauczyć tworzyć rozszerzenia w Oracle E-Business Suite. Okaże się bardzo przydatna, jeśli Czytelnik zajmuje się rozwijaniem lub wspieraniem wdrożeń E-Business Suite. Wszystkie zagadnienia są omawiane bardzo dokładnie, a doświadczenie techniczne wymagane od Czytelnika jest minimalne. Czego możemy się nauczyć? - Poznać architekturę wydania 12; system plików i gdzie należy umieszczać pliki. - Dowiedzieć się, jak personalizować strony struktury OA w Oracle E-Business Suite (EBS) - Zrozumieć architekturę strony OA Framework - Jak instalować JDeveloper z rozszerzeniem OA Extension oraz skonfigurować środowisko deweloperskie - Tworzenia stron OA Framework, wdrażania ich w Oracle E-Business Suite (EBS) i uruchamiania ich za pomocą tej aplikacji. - Jak korzystać z wydawcy BI Publisher do opracowywania, zarządzania oraz udostępniania dokumentów z zaa-wansowanym formatowaniem. - Jak skonfigurować swoją przeglądarkę i aplikacje MS Office do tworzenia i wdrażania integratorów do przekazywania danych do E-Business Suite.
Kellyn Gorman , Allan Hirt , Dave...
Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. If you are looking to work with data processing and management, getting up to speed with Microsoft Server 2019 is key. Introducing SQL Server 2019 takes you through the latest features in SQL Server 2019 and their importance. You will learn to unlock faster querying speeds and understand how to leverage the new and improved security features to build robust data management solutions. Further chapters will assist you with integrating, managing, and analyzing all data, including relational, NoSQL, and unstructured big data using SQL Server 2019. Dedicated sections in the book will also demonstrate how you can use SQL Server 2019 to leverage data processing platforms, such as Apache Hadoop and Spark, and containerization technologies like Docker and Kubernetes to control your data and efficiently monitor it. By the end of this book, you'll be well versed with all the features of Microsoft SQL Server 2019 and understand how to use them confidently to build robust data management solutions.
Jay Gendron
Explore the world of Business Intelligence through the eyes of an analyst working in a successful and growing company. Learn R through use cases supporting different functions within that company. This book provides data-driven and analytically focused approaches to help you answer questions in operations, marketing, and finance. In Part 1, you will learn about extracting data from different sources, cleaning that data, and exploring its structure. In Part 2, you will explore predictive models and cluster analysis for Business Intelligence and analyze financial times series. Finally, in Part 3, you will learn to communicate results with sharp visualizations and interactive, web-based dashboards.After completing the use cases, you will be able to work with business data in the R programming environment and realize how data science helps make informed decisions and develops business strategy. Along the way, you will find helpful tips about R and Business Intelligence.