Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • English  (72)
  • Birmingham, UK : Packt Publishing  (72)
  • Database management  (72)
Datasource
Material
Language
  • English  (72)
Years
  • 1
    ISBN: 9781800560659
    Language: English
    Pages: 1 online resource (246 pages)
    Edition: [First edition].
    DDC: 005.74
    Keywords: Database management ; SQL (Computer program language) ; Cloud computing ; Application software Development ; Web applications ; Relational databases ; Bases de données ; Gestion ; SQL (Langage de programmation) ; Infonuagique ; Logiciels d'application ; Développement ; Applications Web ; Bases de données relationnelles ; Application software ; Development ; Cloud computing ; Database management ; Relational databases ; SQL (Computer program language) ; Web applications ; Electronic books ; Electronic books
    Abstract: Get hands-on with deploying and managing your database services to provide scalable and high-speed data access on CockroachDB. Getting Started with CockroachDB will introduce you to the inner workings of CockroachDB and help you to understand how it provides faster access to distributed data through a SQL interface. The book will also uncover how you can use the database to provide solutions where the data is highly available. Starting with CockroachDB's installation, setup, and configuration, this SQL book will familiarize you with the database architecture and database design principles. You'll then discover several options that CockroachDB provides to store multiple copies of your data to ensure fast data access. The book covers the internals of CockroachDB, how to deploy and manage it on the cloud, performance tuning to get the best out of CockroachDB, and how to scale data across continents and serve it locally. In addition to this, you'll get to grips with fault tolerance and auto-rebalancing, how indexes work, and the CockroachDB Admin UI. The book will guide you in building scalable cloud services on top of CockroachDB, covering administrative and security aspects and tips for troubleshooting, performance enhancements, and a brief guideline on migrating from traditional databases. By the end of this book, you'll have gained sufficient knowledge to manage your data on CockroachDB and interact with it from your application layer.
    Note: Includes bibliographical references
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 2
    Online Resource
    Online Resource
    Birmingham, UK : Packt Publishing
    ISBN: 9781789800814 , 1789800811
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Information technology ; Management ; Electronic data processing ; Backup processing alternatives ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems. Key Features Explore more than 20 real-world use cases to understand SQL Server features Get to grips with the SQL Server Always On technology Learn how to choose HA and DR topologies for your system Book Description Professional SQL Server High Availability and Disaster Recovery explains the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You'll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. Note that this course does not cover SQL Server Failover Cluster Installation with shared storage. By the end of the book, you'll be equipped with all that you need to know to develop robust and high performance infrastructure. What you will learn Configure and troubleshoot Replication, AlwaysOn, and Log Shipping Study the best practices to implement HA and DR solutions Design HA and DR topologies for the SQL Server and study how to choose a topology for your environment Use T-SQL to configure replication, AlwaysOn, and log shipping Migrate from On-Premise SQL Server to Azure SQL Database Manage and maintain AlwaysOn availability groups for extended database mirroring Who this book is for Professional SQL Server High Availability and Disaster Recovery is for you if you are a database administrator or database developer who wants to improve the performance of your production environment. Prior experience of working with SQL Server will help you get the most out of this book.
    Note: Includes bibliographical references. - Description based on online resource; title from copyright page (Safari, viewed March 26, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 3
    ISBN: 9781788833790 , 1788833791
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Database management ; Relational databases ; Electronic books ; Electronic books ; local
    Abstract: Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL Key Features Explore the new and advanced features of MySQL 8.0 Use advanced techniques to optimize MySQL performance Create MySQL-based applications for your enterprise with the help of practical examples Book Description Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential. By the end of this book, you'll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments. What you will learn Explore new and exciting features of MySQL 8.0 Analyze and optimize large MySQL queries Understand MySQL Server 8.0 settings Master the deployment of Group Replication and use it in an InnoDB cluster Monitor large distributed databases Discover different types of backups and recovery methods for your databases Explore tips to help your critical data reach its full potential Who this book is for Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.
    Note: Description based on online resource; title from title page (Safari, viewed March 19, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 4
    ISBN: 9781788991919 , 1788991915
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Information technology ; Management ; Database management ; Computer files ; Electronic books ; Electronic books ; local
    Abstract: Big data processing and analytics at speed and scale using command line tools. Key Features Perform string processing, numerical computations, and more using CLI tools Understand the essential components of data science development workflow Automate data pipeline scripts and visualization with the command line Book Description The Command Line has been in existence on UNIX-based OSes in the form of Bash shell for over 3 decades. However, very little is known to developers as to how command-line tools can be OSEMN (pronounced as awesome and standing for Obtaining, Scrubbing, Exploring, Modeling, and iNterpreting data) for carrying out simple-to-advanced data science tasks at speed. This book will start with the requisite concepts and installation steps for carrying out data science tasks using the command line. You will learn to create a data pipeline to solve the problem of working with small-to medium-sized files on a single machine. You will understand the power of the command line, learn how to edit files using a text-based and an. You will not only learn how to automate jobs and scripts, but also learn how to visualize data using the command line. By the end of this book, you will learn how to speed up the process and perform automated tasks using command-line tools. What you will learn Understand how to set up the command line for data science Use AWK programming language commands to search quickly in large datasets. Work with files and APIs using the command line Share and collect data with CLI tools Perform visualization with commands and functions Uncover machine-level programming practices with a modern approach to data science Who this book is for This book is for data scientists and data analysts with little to no knowledge of the command line but has an understanding of data science. Perform everyday data science tasks using the power of command line tools.
    Note: Includes bibliographical references. - Description based on online resource; title from title page (Safari, viewed March 25, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 5
    ISBN: 9781788996433 , 1788996437
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Relational databases ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Find, explore, and extract big data to transform into actionable insights Key Features Perform end-to-end data analysis - from exploration to visualization Real-world examples, tasks, and interview queries to be a proficient data scientist Understand how SQL is used for big data processing using HiveQL and SparkSQL Book Description SQL Server is a relational database management system that enables you to cover end-to-end data science processes using various inbuilt services and features. Hands-On Data Science with SQL Server 2017 starts with an overview of data science with SQL to understand the core tasks in data science. You will learn intermediate-to-advanced level concepts to perform analytical tasks on data using SQL Server. The book has a unique approach, covering best practices, tasks, and challenges to test your abilities at the end of each chapter. You will explore the ins and outs of performing various key tasks such as data collection, cleaning, manipulation, aggregations, and filtering techniques. As you make your way through the chapters, you will turn raw data into actionable insights by wrangling and extracting data from databases using T-SQL. You will get to grips with preparing and presenting data in a meaningful way, using Power BI to reveal hidden patterns. In the concluding chapters, you will work with SQL Server integration services to transform data into a useful format and delve into advanced examples covering machine learning concepts such as predictive analytics using real-world examples. By the end of this book, you will be in a position to handle the growing amounts of data and perform everyday activities that a data science professional performs. What you will learn Understand what data science is and how SQL Server is used for big data processing Analyze incoming data with SQL queries and visualizations Create, train, and evaluate predictive models Make predictions using trained models and establish regular retraining courses Incorporate data source querying into SQL Server Enhance built-in T-SQL capabilities using SQLCLR Visualize data with Reporting Services, Power View, and Power BI Transform data with R, Python, and Azure Who this book is for Hands-On Data Science with SQL Server 2017 is intended for data scientists, data analysts, and big data professionals who want to master their skills learning SQL and its applications. This book will be helpful even for beginners who want to build their career as data scie...
    Note: Description based on online resource; title from title page (Safari, viewed February 13, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 6
    ISBN: 9781789130096 , 1789130093
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Windows Azure ; Data warehousing ; Database management ; Information storage and retrieval systems ; Data processing ; Cloud computing ; Electronic books ; Electronic books ; local
    Abstract: Leverage the power of Microsoft Azure Data Factory v2 to build hybrid data solutions About This Book Combine the power of Azure Data Factory v2 and SQL Server Integration Services Design and enhance performance and scalability of a modern ETL hybrid solution Interact with the loaded data in data warehouse and data lake using Power BI Who This Book Is For This 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. What You Will Learn Understand the key components of an ETL solution using Azure Data Factory and Integration Services Design the architecture of a modern ETL hybrid solution Implement ETL solutions for both on-premises and Azure data Improve the performance and scalability of your ETL solution Gain thorough knowledge of new capabilities and features added to Azure Data Factory and Integration Services In Detail ETL 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. Style and approach A step-by-step guide to develop data movement code using SSIS, Azure Data Factory, and database stored procedures for implementing intelligent BI solutions. Downloading the example code for this book You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you ...
    Note: Description based on online resource; title from title page (Safari, viewed June 29, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 7
    ISBN: 9781788470537 , 1788470532
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of PostgreSQL 10 to efficiently manage and maintain your database About This Book Your one-stop guide to mastering advanced concepts in PostgreSQL 10 with ease Master query optimization, replication, and high availability with PostgreSQL Extend the functionalities of your PostgreSQL instance to suit your organizational needs with minimal effort Who This Book Is For If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book. What You Will Learn Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries Work with stored procedures and manage backup and recovery Master replication and failover techniques Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle In Detail 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. Style and approach This mastering-level guide delves into the advanced functionalities of PostgreSQL 10
    Note: Description based on online resource; title from title page (Safari, viewed February 27, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 8
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Build smarter and efficient database application systems for your organization with SQL Server 2017 About This Book Build database applications by using the development features of SQL Server 2017 Work with temporal tables to get information stored in a table at any time Use adaptive querying to enhance the performance of your queries Who This Book Is For Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book. What You Will Learn Explore the new development features introduced in SQL Server 2017 Identify opportunities for In-Memory OLTP technology Use columnstore indexes to get storage and performance improvements Exchange JSON data between applications and SQL Server Use the new security features to encrypt or mask the data Control the access to the data on the row levels Discover the potential of R and Python integration Model complex relationships with the graph databases in SQL Server 2017 In Detail Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you'll be introduced to R and how to use the R language with Transact-SQL for data exploration and a...
    Note: Description based on online resource; title from title page (viewed April 2, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 9
    Online Resource
    Online Resource
    Birmingham, UK : Packt Publishing
    ISBN: 9781788296441 , 1788296443
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: PostGIS ; Geographic information systems ; Database management ; Spatial data infrastructures ; Electronic books ; Electronic books ; local
    Abstract: Create and manage spatial data with PostGIS About This Book Import and export geographic data from the PostGIS database using the available tools Maintain, optimize, and fine-tune spatial data for long-term viability Utilize the parallel support functionality that was introduced in PostgreSQL 9.6 Who This Book Is For This book is for developers who need some quick solutions for PostGIS. Prior knowledge of PostgreSQL and spatial concepts would be an added advantage. What You Will Learn Import and export geographic data from the PostGIS database using the available tools Structure spatial data using the functionality provided by a combination of PostgreSQL and PostGIS Work with a set of PostGIS functions to perform basic and advanced vector analyses Connect PostGIS with Python Learn to use programming frameworks around PostGIS Maintain, optimize, and fine-tune spatial data for long-term viability Explore the 3D capabilities of PostGIS, including LiDAR point clouds and point clouds derived from Structure from Motion (SfM) techniques Distribute 3D models through the Web using the X3D standard Use PostGIS to develop powerful GIS web applications using Open Geospatial Consortium web standards Master PostGIS Raster In Detail PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. If you want to explore the complete range of PostGIS techniques and expose related extensions, then this book is for you. This book is a comprehensive guide to PostGIS tools and concepts which are required to manage, manipulate, and analyze spatial data in PostGIS. It covers key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks. Furthermore, you will learn to take advantage of basic and advanced vector, raster, and routing approaches along with the concepts of data maintenance, optimization, and performance, and will help you to integrate these into a large ecosystem of desktop and web tools. By the end, you will be armed with all the tools and instructions you need to both manage the spatial database system and make ...
    Note: Includes bibliographical references. - Description based on online resource; title from title page (Safari, viewed April 19, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 10
    ISBN: 9781787280922 , 1787280926
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Develop and run efficient R scripts and predictive models for SQL Server 2017 About This Book Learn how you can combine the power of R and SQL Server 2017 to build efficient, cost-effective data science solutions Leverage the capabilities of R Services to perform advanced analytics - from data exploration to predictive modeling A quick primer with practical examples to help you get up- and- running with SQL Server 2017 Machine Learning Services with R, as part of database solutions with continuous integration / continuous delivery. Who This Book Is For This book is for data analysts, data scientists, and database administrators with some or no experience in R but who are eager to easily deliver practical data science solutions in their day-to-day work (or future projects) using SQL Server. What You Will Learn Get an overview of SQL Server 2017 Machine Learning Services with R Manage SQL Server Machine Learning Services from installation to configuration and maintenance Handle and operationalize R code Explore RevoScaleR R algorithms and create predictive models Deploy, manage, and monitor database solutions with R Extend R with SQL Server 2017 features Explore the power of R for database administrators In Detail R Services was one of the most anticipated features in SQL Server 2016, improved significantly and rebranded as SQL Server 2017 Machine Learning Services. Prior to SQL Server 2016, many developers and data scientists were already using R to connect to SQL Server in siloed environments that left a lot to be desired, in order to do additional data analysis, superseding SSAS Data Mining or additional CLR programming functions. With R integrated within SQL Server 2017, these developers and data scientists can now benefit from its integrated, effective, efficient, and more streamlined analytics environment. This book gives you foundational knowledge and insights to help you understand SQL Server 2017 Machine Learning Services with R. First and foremost, the book provides practical examples on how to implement, use, and understand SQL Server and R integration in corporate environments, and also provides explanations and underlying motivations. It covers installing Machine Learning Services;maintaining, deploying, and managing code;and monitoring your services. Delving more deeply into predictive modeling and the RevoScaleR package, this book also provides insights into operationalizing code and exploring and visualizing data. To complete the...
    Note: Description based on online resource; title from title page (viewed March 30, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 11
    ISBN: 9781789539172 , 178953917X
    Language: English
    Pages: 1 online resource (1 volume)
    Edition: Second edition.
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database Key Features Master advanced concepts of PostgreSQL 11 with real-world datasets and examples Explore query parallelism, data replication, and database performance while working with larger datasets Extend the functionalities of your PostgreSQL instance to suit your organization's needs with minimal effort Book Description This second edition of Mastering PostgreSQL 11 helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both the physical and technical aspects of the system architecture with ease. This book begins with an introduction to the newly released features in PostgreSQL 11 to help you build efficient and fault-tolerant PostgreSQL applications. You'll examine all of the advanced aspects of PostgreSQL in detail, including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you'll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases. By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease. What you will learn Get to grips with advanced PostgreSQL 11 features and SQL functions Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries Work with stored procedures and manage backup and recovery Master replication and failover techniques Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems Perform database migration from MySQL and Oracle to PostgreSQL with ease Who this book is for This book is for data and database professionals wanting to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11. Prior experience of database administration with PostgreSQL database will aid in understanding the concepts covered in this book.
    Note: Description based on online resource; title from title page (viewed January 7, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 12
    ISBN: 9781789342796 , 1789342791
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Data integration (Computer science) ; Data mining ; Decision support systems ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Get productive quickly with Pentaho Data Integration Key Features Take away the pain of starting with a complex and powerful system Simplify your data transformation and integration work Explore, transform, and validate your data with Pentaho Data Integration Book Description Pentaho Data Integration(PDI) is an intuitive and graphical environment packed with drag and drop design and powerful Extract-Transform-Load (ETL) capabilities. Given its power and flexibility, initial attempts to use the Pentaho Data Integration tool can be difficult or confusing. This book is the ideal solution. This book reduces your learning curve with PDI. It provides the guidance needed to make you productive, covering the main features of Pentaho Data Integration. It demonstrates the interactive features of the graphical designer, and takes you through the main ETL capabilities that the tool offers. By the end of the book, you will be able to use PDI for extracting, transforming, and loading the types of data you encounter on a daily basis. What you will learn Design, preview and run transformations in Spoon Run transformations using the Pan utility Understand how to obtain data from different types of files Connect to a database and explore it using the database explorer Understand how to transform data in a variety of ways Understand how to insert data into database tables Design and run jobs for sequencing tasks and sending emails Combine the execution of jobs and transformations Who this book is for This book is for software developers, business intelligence analysts, and others involved or interested in developing ETL solutions, or more generally, doing any kind of data manipulation.
    Note: Description based on online resource; title from title page (Safari, viewed October 1, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 13
    ISBN: 9781789535679 , 1789535670
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Windows Azure ; Database management ; Client/server computing ; Cloud computing ; Electronic books ; Electronic books ; local
    Abstract: Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases. Key Features Implement backup, restore, and recovery of Azure SQL databases Create shards and elastic pools to scale Azure SQL databases Automate common management tasks with PowerShell Implement over 40 practical activities and exercises across 24 topics to reinforce your learning Book Description As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It's important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database. What you will learn Learn how to provision a new database or migrate an existing on-premise solution Understand how to backup, restore, secure, and scale your own Azure SQL Database Optimize the performance by monitoring and tuning your cloud-based SQL instance Implement high availability and disaster recovery procedures with SQL Database Develop a roadmap for your own scalable cloud solution with Azure SQL Database Who this book is for This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed August 28, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 14
    ISBN: 9781789343502 , 178934350X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; Database management ; Client/server computing ; SQL (Computer program language) ; Web servers ; Electronic books ; Electronic books ; local
    Abstract: Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language Key Features Learn the concepts of PostgreSQL 11 with lots of real-world datasets and examples Learn queries, data replication, and database performance Extend the functionalities of your PostgreSQL instance to suit your organizational needs Book Description PostgreSQL is a rock-solid, scalable, and safe enterprise-level relational database. With a broad range of features and stability, it is ever increasing in popularity.This book shows you how to take advantage of PostgreSQL 11 features for server-side programming. Server-side programming enables strong data encapsulation and coherence. The book begins with the importance of server-side programming and explains the risks of leaving all the checks outside the database. To build your capabilities further, you will learn how to write stored procedures, both functions and the new PostgreSQL 11 procedures, and create triggers to perform encapsulation and maintain data consistency. You will also learn how to produce extensions, the easiest way to package your programs for easy and solid deployment on different PostgreSQL installations. What you will learn Explore data encapsulation Write stored procedures in different languages Interact with transactions from within a function Get to grips with triggers and rules Create and manage custom data types Create extensions to package code and data Implement background workers and Inter-Process Communication (IPC) How to deal with foreign languages, in particular Java and Perl Who this book is for This book is for database administrators, data engineers, and database engineers who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11.
    Note: Includes bibliographical references. - Description based on online resource; title from title page (Safari, viewed February 14, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 15
    ISBN: 9781789135107 , 1789135109
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Linux ; Windows Azure ; Cloud computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Learn to efficiently run Linux-based workloads in Azure Key Features Manage and deploy virtual machines in your Azure environment Explore various open source tools to integrate automation and orchestration Leverage Linux features to create, run, and manage containers Book Description Azure's market share has increased massively and enterprises are adopting it rapidly. Linux is a widely-used operating system and has proven to be one of the most popular workloads on Azure. It has become crucial for Linux administrators and Microsoft professionals to be well versed with the concepts of managing Linux workloads in an Azure environment. Hands-On Linux Administration on Azure starts by introducing you to the fundamentals of Linux and Azure, after which you will explore advanced Linux features and see how they are managed in an Azure environment. Next, with the help of real-world scenarios, you will learn how to deploy virtual machines(VMs) in Azure, along with extending Azure VMs capabilities and managing them efficiently. You will then understand continuous configuration automation and use Ansible, SaltStack and Powershell DSC for orchestration. As you make your way through the chapters, you will understand containers and how they work, along with managing containers and the various tasks you can perform with them. In the concluding chapters, you will cover some Linux troubleshooting techniques on Azure, and you will also be able to monitor Linux in Azure using different open source tools. By the end of this book, you will be able to administer Linux on Azure and make the most of the important tools required for deployment. What you will learn Understand why Azure is the ideal solution for your open source workloads Master essential Linux skills and learn to find your way around the Linux environment Deploy Linux in an Azure environment Use configuration management to manage Linux in Azure Manage containers in an Azure environment Enhance Linux security and use Azure's identity management systems Automate deployment with Azure Resource Manager (ARM) and Powershell Employ Ansible to manage Linux instances in an Azure cloud environment Who this book is for Hands-On Linux Administration on Azure is for Linux administrators and Microsoft professionals that need to deploy and manage their workloads in Azure. Prior knowledge of Linux and Azure isn't necessary.
    Note: Includes bibliographical references. - Description based on online resource; title from title page (Safari, viewed October 1, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 16
    ISBN: 9781788622844 , 1788622847
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: Internet of things ; Computer networks ; Security measures ; Computer security ; Database management ; Electronic books ; Electronic books ; local
    Abstract: A practical, indispensable security guide that will navigate you through the complex realm of securely building and deploying systems in our IoT-connected world Key Features Learn best practices to secure your data from the device to the cloud Use systems security engineering and privacy-by-design principles to design a secure IoT ecosystem A practical guide that will help you design and implement cyber security strategies for your organization Book Description With the advent of the Internet of Things (IoT), businesses have to defend against new types of threat. The business ecosystem now includes the cloud computing infrastructure, mobile and fixed endpoints that open up new attack surfaces. It therefore becomes critical to ensure that cybersecurity threats are contained to a minimum when implementing new IoT services and solutions. This book shows you how to implement cybersecurity solutions, IoT design best practices, and risk mitigation methodologies to address device and infrastructure threats to IoT solutions. In this second edition, you will go through some typical and unique vulnerabilities seen within various layers of the IoT technology stack and also learn new ways in which IT and physical threats interact. You will then explore the different engineering approaches a developer/manufacturer might take to securely design and deploy IoT devices. Furthermore, you will securely develop your own custom additions for an enterprise IoT implementation. You will also be provided with actionable guidance through setting up a cryptographic infrastructure for your IoT implementations. You will then be guided on the selection and configuration of Identity and Access Management solutions for an IoT implementation. In conclusion, you will explore cloud security architectures and security best practices for operating and managing cross-organizational, multi-domain IoT deployments. What you will learn Discuss the need for separate security requirements and apply security engineering principles on IoT devices Master the operational aspects of planning, deploying, managing, monitoring, and detecting the remediation and disposal of IoT systems Use Blockchain solutions for IoT authenticity and integrity Explore additional privacy features emerging in the IoT industry, such as anonymity, tracking issues, and countermeasures Design a fog computing architecture to support IoT edge analytics Detect and respond to IoT security incidents and compromises Who t...
    Note: Description based on online resource; title from title page (viewed February 4, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 17
    ISBN: 9781788393843 , 1788393848
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Database management ; Relational databases ; Electronic books ; Electronic books ; local
    Abstract: Step by step guide to monitor, manage, and secure your database engine About This Book Your companion to master all the administration-related tasks in MySQL 8 Ensure high performance and high availability of your MySQL solution using effective replication and backup techniques A comprehensive guide to performing query optimization, security and a whole host of other administrative tasks in MySQL 8 Who This Book Is For This book is intended for MySQL administrators who are looking for a handy guide covering all the MySQL administration-related tasks. If you are a DBA looking to get started with MySQL administration, this book will also help you. Knowledge of the basic database concepts is required to get started with this book. What You Will Learn Understanding different MySQL 8 data types based on type of contents and storage requirements Best practices for optimal use of features in MySQL 8 Explore globalization configuration and caching techniques to improve performance Create custom storage engine as per system requirements Learn various ways of index implementation for flash memory storages Configure and implement replication along with approaches to use replication as solution Understand how to make your MySQL 8 solution highly available Troubleshoot common issues and identify error codes while using MySQL 8 In Detail MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This handbook will be your companion to understand the newly introduced features in MySQL and how you can leverage them to design a high-performance MySQL solution for your organization. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial administration topics that you will find useful in your day to day work. Topics such as migrating to MySQL 8, MySQL benchmarking, achieving high performance by implementing the indexing techniques, and optimizing your queries are covered in this book. You will also learn how to perform replication, scale your MySQL solution and implement effective security techniques. A special section on the common and not so common troubleshooting techniques for effective MySQL administration is also covered in this book. By the end of this highly practical book, you will have all the knowledge you need to tackle an...
    Note: Description based on online resource; title from title page (Safari, viewed March 7, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 18
    ISBN: 9781787127142 , 1787127141
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Non-relational databases ; Database management ; SQL (Computer program language) ; Electronic books ; Electronic books ; local
    Abstract: A beginner's guide to get you up and running with Cassandra, DynamoDB, HBase, InfluxDB, MongoDB, Neo4j, and Redis About This Book Covers the basics of 7 NoSQL databases and how they are used in the enterprises Quick introduction to MongoDB, DynamoDB, Redis, Cassandra, Neo4j, InfluxDB, and Hbase Includes effective techniques for database querying and management Who This Book Is For If you are a budding DBA or a developer who wants to get started with the fundamentals of NoSQL databases, this book is for you. Relational DBAs who want to get insights into the various offerings of popular NoSQL databases will also find this book to be very useful. What You Will Learn Understand how MongoDB provides high-performance, high-availability, and automatic scaling Interact with your Neo4j instances via database queries, Python scripts, and Java application code Get familiar with common querying and programming methods to interact with Redis Study the different types of problems Cassandra can solve Work with HBase components to support common operations such as creating tables and reading/writing data Discover data models and work with CRUD operations using DynamoDB Discover what makes InfluxDB a great choice for working with time-series data In Detail This is the golden age of open source NoSQL databases. With enterprises having to work with large amounts of unstructured data and moving away from expensive monolithic architecture, the adoption of NoSQL databases is rapidly increasing. Being familiar with the popular NoSQL databases and knowing how to use them is a must for budding DBAs and developers. This book introduces you to the different types of NoSQL databases and gets you started with seven of the most popular NoSQL databases used by enterprises today. We start off with a brief overview of what NoSQL databases are, followed by an explanation of why and when to use them. The book then covers the seven most popular databases in each of these categories: MongoDB, Amazon DynamoDB, Redis, HBase, Cassandra, InfluxDB, and Neo4j. The book doesn't go into too much detail about each database but teaches you enough to get started with them. By the end of this book, you will have a thorough understanding of the different NoSQL databases and their functionalities, empowering you to select and use the right database according to your needs. Style and approach This book is a quick-start guide with short and simple introductory content on the seven popular databa...
    Note: Description based on online resource; title from title page (Safari, viewed April 30, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 19
    ISBN: 9781789531893 , 1789531896
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Third edition.
    Keywords: Python (Computer program language) ; Database management ; Information visualization ; Electronic books ; Electronic books ; local
    Abstract: Gain useful insights from your data using popular data science tools Key Features A one-stop guide to Python libraries such as pandas and NumPy Comprehensive coverage of data science operations such as data cleaning and data manipulation Choose scalable learning algorithms for your data science tasks Book Description Fully expanded and upgraded, the latest edition of Python Data Science Essentials will help you succeed in data science operations using the most common Python libraries. This book offers up-to-date insight into the core of Python, including the latest versions of the Jupyter Notebook, NumPy, pandas, and scikit-learn. The book covers detailed examples and large hybrid datasets to help you grasp essential statistical techniques for data collection, data munging and analysis, visualization, and reporting activities. You will also gain an understanding of advanced data science topics such as machine learning algorithms, distributed computing, tuning predictive models, and natural language processing. Furthermore, You'll also be introduced to deep learning and gradient boosting solutions such as XGBoost, LightGBM, and CatBoost. By the end of the book, you will have gained a complete overview of the principal machine learning algorithms, graph analysis techniques, and all the visualization and deployment instruments that make it easier to present your results to an audience of both data science experts and business users What you will learn Set up your data science toolbox on Windows, Mac, and Linux Use the core machine learning methods offered by the scikit-learn library Manipulate, fix, and explore data to solve data science problems Learn advanced explorative and manipulative techniques to solve data operations Optimize your machine learning models for optimized performance Explore and cluster graphs, taking advantage of interconnections and links in your data Who this book is for If you're a data science entrant, data analyst, or data engineer, this book will help you get ready to tackle real-world data science problems without wasting any time. Basic knowledge of probability/statistics and Python coding experience will assist you in understanding the concepts covered in this book. Downloading the example code for this book You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support an...
    Note: Description based on online resource; title from title page (viewed November 5, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 20
    ISBN: 9781789531060 , 1789531063
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Git (Computer file) ; Computer software ; Development ; Information technology ; Management ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Port projects over from GitHub and convert SVN projects to GitLab hosted git projects Key Features Effective guide for GitLab migration from GitHub and SVN Learn to implement DevOps with GitLab 11 Manage projects with issue boards and time tracking Book Description Gitlab is an open source repository management and version control toolkit with an enterprise offering. This book is the ideal guide to GitLab as a version control system (VCS), issue management tool, and a continuous integration platform. The book starts with an introduction to GitLab, a walkthrough of its features, and explores concepts such as version control systems, continuous integration, and continuous deployment. It then takes you through the process of downloading and installing a local copy of the on-premise version of GitLab in Ubuntu and/or CentOS. You will look at some common work?ows associated with GitLab work?ow and learn about project management in GitLab. You will see tools and techniques for migrating your code base from various version control systems such as GitHub and SVN to GitLab. By the end of the book, you will be using Gitlab for repository management, and be able to migrate projects from other VCSs to GitLab. What you will learn Set up CI and test builds for your projects Understand the benefits and limitations of GitLab work?ow Migrate from other common VCS platforms to Gitlab Create, review, and merge code changes Learn to branch local code and create a new branch in GitLab Configure sequential stages and simultaneous stages for CI/CD Access Mattermost for on-premise GitLab Discover the issue tracking features of GitLab Who this book is for The book is intended for the developers, SREs, and DevOps professionals who are looking for techniques to port their codebase to GitLab from GitHub or are looking to work with GitLab as their version control system of choice. If you've used other VCSs before, that will help with this book.
    Note: Description based on online resource; title from title page (Safari, viewed February 1, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 21
    ISBN: 9781789133783 , 1789133785
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Apache Mesos (Electronic resource) ; Cloud computing ; Database management ; Application software ; Development ; Electronic books ; Electronic books ; local
    Abstract: Scale applications with high availability and optimized resource management across data centers Key Features Create clusters and perform scheduling, logging, and resource administration with Mesos Explore practical examples of managing complex clusters at scale with real-world data Write native Mesos frameworks with Python Book Description Apache Mesos is an open source cluster manager that provides efficient resource isolation and sharing across distributed applications or frameworks. This book will help you build a strong foundation of Mesos' capabilities along with practical examples to support the concepts explained throughout the book. Learn Apache Mesos dives straight into how Mesos works. You will be introduced to the distributed system and its challenges and then learn how you can use Mesos and its framework to solve data problems. You will also gain a full understanding of Mesos' internal mechanisms and get equipped to use Mesos and develop applications. Furthermore, this book lets you explore all the steps required to create highly available clusters and build your own Mesos frameworks. You will also cover application deployment and monitoring. By the end of this book, you will have learned how to use Mesos to make full use of machines and how to simplify data center maintenance. What you will learn Deploy and monitor a Mesos cluster Set up servers on AWS to deploy Mesos components Explore Mesos resource scheduling and the allocation module Deploy Docker-based services and applications using Mesos Marathon Configure and use SSL to protect crucial endpoints of your Mesos cluster Debug and troubleshoot services and workloads on a Mesos cluster Who this book is for This book is for DevOps and data engineers and administrators who work with large data clusters. You'll also find this book useful if you have experience working with virtualization, databases, and platforms such as Hadoop and Spark. Some experience in database administration and design will help you get the most out of this book.
    Note: Description based on online resource; title from title page (Safari, viewed March 20, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 22
    ISBN: 9781789139778 , 1789139775
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Windows Azure ; Database management ; Client/server computing ; Cloud computing ; Electronic books ; Electronic books ; local
    Abstract: Explore Azure services such as networking, virtual machines, web apps, databases, cloud migration, and security Key Features Understand Azure services to build, deploy, and manage workloads on cloud Learn in-depth core Azure services and work through real-world scenarios and case studies A concise and practical guide for learning cloud administration on Azure Book Description Azure continues to dominate the public cloud market and grow rapidly thanks to a number of recent innovations. Azure's wide range of services and support has led to a large number of customers switching to Azure cloud. Hands-On Cloud Administration in Azure starts with the basics of Azure cloud fundamentals and key concepts of the cloud computing ecosystem and services. Then, you will gradually get acquainted with core services provided by Azure, including Azure VNet, types and assignments of IP addresses, and network security groups. You will also work on creating and administering Azure Virtual Machines, types of virtual machines (VMs), and design VM solutions based on computing workloads. As you make your way through the chapters, you will explore Azure App Service, discover how to host your web apps in Azure, and monitor and troubleshoot them. In the concluding chapters, you will learn more complex and abstract services, such as Azure Storage, Azure Backup, and Azure Site Recovery. You will also get to grips with Azure SQL Databases and the SQL on Azure VM concept. By the end of this book, you will have obtained practical experience of working with Azure services and Azure administration, along with maintaining, monitoring, and securing your Azure resources. What you will learn Understand the concepts of IaaS and PaaS Learn design patterns for Azure solutions Design data solutions in Azure Explore concepts of hybrid clouds with Azure Implement Azure Security in cloud Create and manage Azure resources with script-based tools Who this book is for Hands-On Cloud Administration in Azure is for system administrators, cloud admins, cloud engineers, and DevOps engineers who are interested in understanding administration-related services in Azure. Prior experience of working with Azure is an added advantage.
    Note: Description based on online resource; title from title page (Safari, viewed November 26, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 23
    ISBN: 9781788398442 , 1788398440
    Language: English
    Pages: 1 online resource (1 volume)
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Database management ; Relational databases ; Electronic books ; Electronic books ; local
    Abstract: Design and administer enterprise-grade MySQL 8 solutions About This Book Store, retrieve, and manipulate your data using the latest MySQL 8 features Practical recipes on effective administration in MySQL, with a focus on security, performance tuning, troubleshooting, and more Contains tips, tricks, and best practices for designing, developing, and administering your MySQL 8 database solution without any hassle Who This Book Is For If you are a MySQL developer or administrator looking for quick, handy solutions to solve the most common and not-so-common problems in MySQL, this book is for you. MySQL DBAs looking to get up-to-speed with the latest MySQL 8 development and administration features will also find this book very useful. Prior knowledge of Linux and RDBMS is desirable. What You Will Learn Install and configure your MySQL 8 instance without any hassle Get to grips with new features of MySQL 8 like CTE, Window functions and many more Perform backup tasks, recover data and set up various replication topologies for your database Maximize performance by using new features of MySQL 8 like descending indexes, controlling query optimizer and resource groups Learn how to use general table space to suit the SaaS or multi-tenant applications Analyze slow queries using performance schema, sys schema and third party tools Manage and monitor your MySQL instance and implement efficient performance-tuning tasks In Detail MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before. This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL. It shows you the newest improvements in MySQL 8 and gives you hands-on experience in managing high-transaction and real-time datasets. If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL administration, with tips on effective user management, data recovery, security, database monitoring, performance tuning, troubleshooting, and more. With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8, the book contains practical...
    Note: Description based on online resource; title from title page (viewed February 21, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 24
    ISBN: 9781789136517 , 1789136512
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: Apache Hadoop ; Big data ; Database management ; Databases ; Development ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: This book takes you on a fantastic journey to discover the attributes of big data using Apache Hive. About This Book Grasp the skills needed to write efficient Hive queries to analyze the Big Data Discover how Hive can coexist and work with other tools within the Hadoop ecosystem Uses practical, example-oriented scenarios to cover all the newly released features of Apache Hive 2.3.3 Who This Book Is For If you are a data analyst, developer, or simply someone who wants to quickly get started with Hive to explore and analyze Big Data in Hadoop, this is the book for you. Since Hive is an SQL-like language, some previous experience with SQL will be useful to get the most out of this book. What You Will Learn Create and set up the Hive environment Discover how to use Hive's definition language to describe data Discover interesting data by joining and filtering datasets in Hive Transform data by using Hive sorting, ordering, and functions Aggregate and sample data in different ways Boost Hive query performance and enhance data security in Hive Customize Hive to your needs by using user-defined functions and integrate it with other tools In Detail In this book, we prepare you for your journey into big data by frstly introducing you to backgrounds in the big data domain, alongwith the process of setting up and getting familiar with your Hive working environment. Next, the book guides you through discovering and transforming the values of big data with the help of examples. It also hones your skills in using the Hive language in an effcient manner. Toward the end, the book focuses on advanced topics, such as performance, security, and extensions in Hive, which will guide you on exciting adventures on this worthwhile big data journey. By the end of the book, you will be familiar with Hive and able to work effeciently to find solutions to big data problems Style and approach This book takes on a practical approach which will get you familiarized with Apache Hive and how to use it to efficiently to find solutions to your big data problems. This book covers crucial topics like performance, and data security in order to help you make the most of the Hive working environment. Downloading the example code for this book You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-ma...
    Note: Previous edition published: 2015. - Description based on online resource; title from title page (Safari, viewed July 31, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 25
    ISBN: 9781788999564 , 1788999568
    Language: English
    Pages: 1 online resource (1 volume) , illustrations, map
    Keywords: Apache Superset ; Dashboards (Management information systems) ; Database management ; Business planning ; Electronic books ; Electronic books ; local
    Abstract: Integrate open source data analytics and build business intelligence on SQL databases with Apache Superset. The quick, intuitive nature for data visualization in a web application makes it easy for creating interactive dashboards. Key Features Work with Apache Superset's rich set of data visualizations Create interactive dashboards and data storytelling Easily explore data Book Description Apache Superset is a modern, open source, enterprise-ready business intelligence (BI) web application. With the help of this book, you will see how Superset integrates with popular databases like Postgres, Google BigQuery, Snowflake, and MySQL. You will learn to create real time data visualizations and dashboards on modern web browsers for your organization using Superset. First, we look at the fundamentals of Superset, and then get it up and running. You'll go through the requisite installation, configuration, and deployment. Then, we will discuss different columnar data types, analytics, and the visualizations available. You'll also see the security tools available to the administrator to keep your data safe. You will learn how to visualize relationships as graphs instead of coordinates on plain orthogonal axes. This will help you when you upload your own entity relationship dataset and analyze the dataset in new, different ways. You will also see how to analyze geographical regions by working with location data. Finally, we cover a set of tutorials on dashboard designs frequently used by analysts, business intelligence professionals, and developers. What you will learn Get to grips with the fundamentals of data exploration using Superset Set up a working instance of Superset on cloud services like Google Compute Engine Integrate Superset with SQL databases Build dashboards with Superset Calculate statistics in Superset for numerical, categorical, or text data Understand visualization techniques, filtering, and grouping by aggregation Manage user roles and permissions in Superset Work with SQL Lab Who this book is for This book is for data analysts, BI professionals, and developers who want to learn Apache Superset. If you want to create interactive dashboards from SQL databases, this book is what you need. Working knowledge of Python will be an advantage but not necessary to understand this book.
    Note: Description based on online resource; title from title page (viewed February 15, 2019)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 26
    ISBN: 9781788627504 , 1788627504
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Fourth edition.
    Keywords: Puppet (Computer file) ; Client/server computing ; Database management ; Cloud computing ; High performance computing ; Electronic books ; Electronic books ; local
    Abstract: Write custom plugins for Puppet, including facts, providers, and functions About This Book Grasp recipes that work with centralized and decentralized deployments Explore language differences and enhancements anticipated in Puppet version 5.x Gain expert understanding of Puppet's latest and most advanced features Who This Book Is For Puppet 5 Cookbook is for anyone who builds and administers servers, especially in a web operations context. You'll need some experience of Linux systems administration, including familiarity with the command line, filesystem, and text editing. No prior programming experience is required. What You Will Learn Discover the latest and most advanced features of Puppet Bootstrap your Puppet installation using powerful tools like Rake Master techniques to deal with centralized and decentralized Puppet deployments Use exported resources and forge modules to set up Puppet modules Create efficient manifests to streamline your deployments Automate Puppet master deployment using Git hooks and PuppetDB Make Puppet reliable, performant, and scalable In Detail Puppet is a configuration management system that automates all your IT configurations, giving you control of managing each node.Puppet 5 Cookbook will take you through Puppet's latest and most advanced features, including Docker containers, Hiera, and AWS Cloud Orchestration. Updated with the latest advancements and best practices, this book delves into various aspects of writing good Puppet code, which includes using Puppet community style, checking your manifests with puppet-lint, and learning community best practices with an emphasis on real-world implementation. You will learn to set up, install, and create your first manifests with Puppet version control, and also understand various sysadmin tasks, including managing config files, using Augeas, and generating files from snippets and templates. As the book progresses, you'll explore virtual resources and use Puppet's resource scheduling and auditing features. In the concluding chapters, you'll walk through managing applications and writing your own resource types, providers, and external node classifiers. By the end of this book, you will have learned to report, log, and debug your system. Style and approach A recipe-based guide filled with quick step-by-step instructions that are immediately applicable
    Note: Includes bibliographical references. - Description based on online resource; title from title page (Safari, viewed August 1, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 27
    ISBN: 9781788472456 , 1788472454
    Language: English
    Pages: 1 online resource (1 volume)
    Parallel Title: Erscheint auch als
    Keywords: PostgreSQL. ; SQL (Computer program language) ; Database management ; Databases Design
    Note: Description based on online resource; title from title page (Safari, viewed May 30, 2018)
    URL: Volltext  (URL des Erstveröffentlichers)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 28
    ISBN: 9781787282339 , 1787282333
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Data warehousing ; Database management ; Relational databases ; Information storage and retrieval systems ; Data processing ; Electronic books ; Electronic books ; local
    Abstract: Data management and analytics simplified with Teradata About This Book Take your understanding of Teradata to the next level and build efficient data warehousing applications for your organization Covers recipes on data handling, warehousing, advanced querying and the administrative tasks in Teradata. Contains practical solutions to tackle common (and not-so-common) problems you might encounter in your day to day activities Who This Book Is For This book is for Database administrator's and Teradata users who are looking for a practical, one-stop resource to solve all their problems while handling their Teradata solution. If you are looking to learn the basic as well as the advanced tasks involved in Teradata querying or administration, this book will be handy. Some knowledge of relational database concepts will be helpful to get the best out of this book. What You Will Learn Understand Teradata's competitive advantage over other RDBMSs. Use SQL to process data stored in Teradata tables. Leverage Teradata's available application utilities and parallelism to play with large datasets Apply various performance tuning techniques to optimize the queries. Acquire deeper knowledge and understanding of the Teradata Architecture. Easy steps to load, archive, restore data and implement Teradata protection features Gain confidence in running a wide variety of Data analytics and develop applications for the Teradata environment In Detail Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata. The book begins with recipes on quickly setting up a development environment so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you'll master various administrative tasks such as user and security management, workload management, high availability, performance tuning, and monitoring. This book is designed to take you through the best practices of performing the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process. Style...
    Note: Description based on online resource; title from title page (Safari, viewed March 6, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 29
    ISBN: 9781786467324 , 1786467321
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Implement and administer successful database solution with SQL Server 2017 About This Book Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution Design and configure, manage, and secure a rock-solid SQL server Comprehensive guide in keeping your SQL server disaster proof and all-time availability Who This Book Is For This book targets database administrators with an interest in SQL Server 2017 administration. Readers are expected to have some experience with previous SQL Server versions. What You Will Learn Learn about the new features of SQL Server 2017 and how to implement them Build a stable and fast SQL Server environment Fix performance issues by optimizing queries and making use of indexes Perform a health check of an existing troublesome database environment Design and use an optimal database management strategy Implement efficient backup and recovery techniques in-line with security policies Combine SQL Server 2017 and Azure and manage your solution by various automation techniques Perform data migration, cluster upgradation and server consolidation In Detail Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution. You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth. Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017. Style and approach A comprehensive guide for database professionals, covering a wide range of topics from installation, maintenance, and configuration to managing systems for operational efficiency and high availability;...
    Note: Description based on online resource; title from title page (Safari, viewed January 19, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 30
    ISBN: 9781783555369 , 178355536X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease Master query optimization, replication, and high availability with PostgreSQL Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort Who This Book Is For If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book. What You Will Learn Get to grips with the advanced features of PostgreSQL 9.6 and handle advanced SQL Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries Work with the stored procedures and manage backup and recovery Master the replication and failover techniques Troubleshoot your PostgreSQL instance for solutions to the common and not-so-common problems Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle In Detail PostgreSQL is an open source database used for handling large datasets (Big Data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently. We begin by explaining the advanced database design concepts in PostgreSQL 9.6, 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 and high availability, and much more. You will understand the 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 the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL. Style and Approach This book is a comprehensive guide covering all the concepts you need to master PostgreSQL. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. E...
    Note: Description based on online resource; title from title page (Safari, viewed June 21, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 31
    ISBN: 9781788290074 , 1788290070
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Third edition.
    Keywords: Data integration (Computer science) ; Data mining ; Decision support systems ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide About This Book Manipulate your data by exploring, transforming, validating, and integrating it using Pentaho Data Integration 8 CE A comprehensive guide exploring the features of Pentaho Data Integration 8 CE Connect to any database engine, explore the databases, and perform all kind of operations on relational databases Who This Book Is For This book is a must-have for software developers, business intelligence analysts, IT students, or anyone involved or interested in developing ETL solutions. If you plan on using Pentaho Data Integration for doing any data manipulation task, this book will help you as well. This book is also a good starting point for data warehouse designers, architects, or anyone who is responsible for data warehouse projects and needs to load data into them. What You Will Learn Explore the features and capabilities of Pentaho Data Integration 8 Community Edition Install and get started with PDI Learn the ins and outs of Spoon, the graphical designer tool Learn to get data from all kind of data sources, such as plain files, Excel spreadsheets, databases, and XML files Use Pentaho Data Integration to perform CRUD (create, read, update, and delete) operations on relationaldatabases Populate a data mart with Pentaho Data Integration Use Pentaho Data Integration to organize files and folders, run daily processes, deal with errors, and more In Detail Pentaho Data Integration(PDI) is an intuitive and graphical environment packed with drag-and-drop design and powerful Extract-Tranform-Load (ETL) capabilities. This book shows and explains the new interactive features of Spoon, the revamped look and feel, and the newest features of the tool including transformations and jobs Executors and the invaluable Metadata Injection capability. We begin with the installation of PDI software and then move on to cover all the key PDI concepts. Each of the chapter introduces new features, enabling you to gradually get practicing with the tool. First, you will learn to do all kind of data manipulation and work with simple plain files. Then, the book teaches you how you can work with relational databases inside PDI. Moreover, you will be given a primer on data warehouse concepts and you will learn how to load data in a data warehouse. During the course of this book, you will be familiarized with its intuitive, graphical and drag-and-drop design envir...
    Note: Description based on online resource; title from title page (Safari, viewed January 12, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 32
    ISBN: 9781787128361 , 1787128369
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: Web site development ; Database management ; Digital media ; Management ; Information resources management ; Electronic books ; Electronic books ; local
    Abstract: Discover what it means to be an expert developer by exploring the latest features available to you in Alfresco One 5.x About This Book Create reliable and secure enterprise apps with the latest Alfresco One 5.x platform Explore all the latest Alfresco One 5.x APIs such as the CMIS API, Alfresco One API, and the integrated RESTful API to get more out of your enterprise apps Unleash the power of the latest JavaScript engine and the JavaScript API for Alfresco to customize your existing apps for the Alfresco 5 platform Who This Book Is For If you're an enterprise app developer who wants to create custom applications with Alfresco, then this book is for you. Previous knowledge with Alfresco would be helpful but is not necessary. What You Will Learn Create and manage a custom content model Configure the Alfresco Share user interface Build a new AngularJS 2.0 application Create business process definitions using Activiti Designer Discover the most common extensions provided by Alfresco Configure Alfresco to authenticate against LDAP, including & chaining" LDAP with Alfresco authentication Get familiar with the latest features of Alfresco Mobile SDK, Smart Search, and the new Angular framework In Detail Do you want to create more reliable and secure solutions for enterprise apps? Alfresco One 5.x is your gateway to developing the best industry-standard enterprise apps and this book will help you to become a pro with Alfresco One 5.x development. This book will help you create a complete fully featured app for your organization and while you create that perfect app, you will explore and implement the new and intriguing features of Alfresco. The book starts with an introduction to the Alfresco platform and you'll see how to configure and customize it. You will learn how to work with the content in a content management system and how you can extend it to your own use case. Next, you will find out how to work with Alfresco Share, an all-purpose user interface for general document management, and customize it. Moving on, you write web scripts that create, read, and delete data in the back-end repository. Further on from that, you'll work with a set of tools that Alfresco provides; to generate a basic AnglularJS application supporting use cases, to name a few authentication, document list, document view. Finally, you'll learn how to develop your own Alfresco Mobile app and understand how Smart Folders and Search manager work. By the end of the book, you'll...
    Note: Previous edition published: 2008. - Description based on online resource; title from cover (Safari, viewed March 22, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 33
    ISBN: 9781785287244 , 1785287249
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: Get to know effective ways to improve PostgreSQL's performance and master query optimization, and database monitoring. About This Book Perform essential database tasks such as benchmarking the database and optimizing the server's memory usage Learn ways to improve query performance and optimize the PostgreSQL server Explore a wide range of high availability and replication mechanisms to build robust, highly available, scalable, and fault-tolerant PostgreSQL databases Who This Book Is For If you are a developer or administrator with limited PostgreSQL knowledge and want to develop your skills with this great open source database, then this book is ideal for you. Learning how to enhance the database performance is always an exciting topic to everyone, and this book will show you enough ways to enhance the database performance. What You Will Learn Build replication strategies for homogeneous and heterogeneous databases Test and build a powerful machine with multiple bench marking techniques Get to know a few SQL injection techniques Find out how to manage the replication using multiple tools Benchmark the database server using multiple strategies Work with the query processing algorithms and their internal behaviors Build a proper plan to upgrade or migrate to PostgreSQL from other databases See the essential database load balancing techniques and the various partitioning approaches PostgreSQL provides Learn memory optimization techniques and database server configurations In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems. If you run a database, you want it to perform well and you want to be able to secure it. As the world's most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database's performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. This book is your one-stop guide to elevate your PostgreSQL knowledge to the next level. First, you'll get familiarized with essential developer/administrator concepts such as lo...
    Note: Description based on online resource; title from cover (Safari, viewed April 19, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 34
    ISBN: 9781783983070 , 1783983078
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Distributed databases ; Handbooks, manuals, etc ; Electronic data processing ; Distributed processing ; Database management ; Open source software ; Electronic books ; Electronic books ; local
    Abstract: Exciting projects that will teach you how complex data can be exploited to gain maximum insights About This Book Architect a good HBase cluster for a very large distributed system Get to grips with the concepts of performance tuning with HBase A practical guide full of engaging recipes and attractive screenshots to enhance your system's performance Who This Book Is For This book is intended for developers and architects who want to know all about HBase at a hands-on level. This book is also for big data enthusiasts and database developers who have worked with other NoSQL databases and now want to explore HBase as another futuristic scalable database solution in the big data space. What You Will Learn Configure HBase from a high performance perspective Grab data from various RDBMS/Flat files into the HBASE systems Understand table design and perform CRUD operations Find out how the communication between the client and server happens in HBase Grasp when to use and avoid MapReduce and how to perform various tasks with it Get to know the concepts of scaling with HBase through practical examples Set up Hbase in the Cloud for a small scale environment Integrate HBase with other tools including ElasticSearch In Detail Apache HBase is a non-relational NoSQL database management system that runs on top of HDFS. It is an open source, disturbed, versioned, column-oriented store and is written in Java to provide random real-time access to big Data. We'll start off by ensuring you have a solid understanding the basics of HBase, followed by giving you a thorough explanation of architecting a HBase cluster as per our project specifications. Next, we will explore the scalable structure of tables and we will be able to communicate with the HBase client. After this, we'll show you the intricacies of MapReduce and the art of performance tuning with HBase. Following this, we'll explain the concepts pertaining to scaling with HBase. Finally, you will get an understanding of how to integrate HBase with other tools such as ElasticSearch. By the end of this book, you will have learned enough to exploit HBase for boost system performance. Style and approach This book is intended for software quality assurance/testing professionals, software project managers, or software developers with prior experience in using Selenium and Java to test web-based applications. This books also provides examples for C#, Python, and Ruby users.
    Note: Includes index. - Description based on online resource; title from cover (viewed February 16, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 35
    ISBN: 9781788477895 , 1788477898
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database management ; Databases ; Design ; Electronic books ; Electronic books ; local
    Abstract: A practical guide to administer, monitor and replicate your PostgreSQL 10 database About This Book Get to grips with the capabilities of PostgreSQL 10 to administer your database more efficiently Monitor, tune, secure and protect your database for optimal performance A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL 10 administration with ease Who This Book Is For This book is for database administrators, data architects, developers, or anyone with an interest in planning for, or running, live production databases using PostgreSQL. It is most suited to those looking for hands-on solutions to any problem associated with PostgreSQL administration. What You Will Learn Get to grips with the newly released PostgreSQL 10 features to improve database performance and reliability Manage open source PostgreSQL versions 10 on various platforms. Explore best practices for planning and designing live databases Select and implement robust backup and recovery techniques in PostgreSQL 10 Explore concise and clear guidance on replication and high availability Discover advanced technical tips for experienced users In Detail PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration. Throughout this book, you will be introduced to these new features such as logical replication, native table partitioning, additional query parallelism, and much more. You will learn how to tackle a variety of problems that are basically the pain points for any database administrator - from creating tables to managing views, from improving performance to securing your database. More importantly, the book pays special attention to topics such as monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication. By the end of this book, you will know everything you need to know to be the go-to PostgreSQL expert in your organization. Style and approach The book is a step by step guide with example-driven recipes, focused on the new features of the latest PostgreSQL version10. This book will serve as a specific guide to understand and leverage useful PostgreSQL functionalities to create better and more efficient databases. Down...
    Note: Description based on online resource; title from title page (Safari, viewed June 14, 2018)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 36
    ISBN: 9781786466884 , 1786466880
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Third edition.
    Keywords: Lucene (Electronic resource) ; Database searching ; Database management ; Client/server computing ; Electronic books ; Electronic books ; local
    Abstract: Over 170 advanced recipes to search, analyze, deploy, manage, and monitor data effectively with Elasticsearch 5.x About This Book Deploy and manage simple Elasticsearch nodes as well as complex cluster topologies Write native plugins to extend the functionalities of Elasticsearch 5.x to boost your business Packed with clear, step-by-step recipes to walk you through the capabilities of Elasticsearch 5.x Who This Book Is For If you are a developer who wants to get the most out of Elasticsearch for advanced search and analytics, this is the book for you. Some understanding of JSON is expected. If you want to extend Elasticsearch, understanding of Java and related technologies is also required. What You Will Learn Choose the best Elasticsearch cloud topology to deploy and power it up with external plugins Develop tailored mapping to take full control of index steps Build complex queries through managing indices and documents Optimize search results through executing analytics aggregations Monitor the performance of the cluster and nodes Install Kibana to monitor cluster and extend Kibana for plugins Integrate Elasticsearch in Java, Scala, Python and Big Data applications In Detail Elasticsearch is a Lucene-based distributed search server that allows users to index and search unstructured content with petabytes of data. This book is your one-stop guide to master the complete Elasticsearch ecosystem. We'll guide you through comprehensive recipes on what's new in Elasticsearch 5.x, showing you how to create complex queries and analytics, and perform index mapping, aggregation, and scripting. Further on, you will explore the modules of Cluster and Node monitoring and see ways to back up and restore a snapshot of an index. You will understand how to install Kibana to monitor a cluster and also to extend Kibana for plugins. Finally, you will also see how you can integrate your Java, Scala, Python, and Big Data applications such as Apache Spark and Pig with Elasticsearch, and add enhanced functionalities with custom plugins. By the end of this book, you will have an in-depth knowledge of the implementation of the Elasticsearch architecture and will be able to manage data efficiently and effectively with Elasticsearch. Style and approach This book follows a problem-solution approach to effectively use and manage Elasticsearch. Each recipe focuses on a particular task at hand, and is explained in a very simple, easy to understand manner. Downloading the ex...
    Note: Description based on online resource; title from cover (Safari, viewed March 1, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 37
    Online Resource
    Online Resource
    Birmingham, UK : Packt Publishing
    ISBN: 9781787128408 , 1787128407
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: Apache Cassandra ; Database management ; Database design ; Web services ; Information storage and retrieval systems ; Electronic books ; Electronic books ; local
    Abstract: Build a scalable, fault-tolerant and highly available data layer for your applications using Apache Cassandra About This Book Install Cassandra and set up multi-node clusters Design rich schemas that capture the relationships between different data types Master the advanced features available in Cassandra 3.x through a step-by-step tutorial and build a scalable, high performance database layer Who This Book Is For If you are a NoSQL developer and new to Apache Cassandra who wants to learn its common as well as not-so-common features, this book is for you. Alternatively, a developer wanting to enter the world of NoSQL will find this book useful. It does not assume any prior experience in coding or any framework. What You Will Learn Install Cassandra Create keyspaces and tables with multiple clustering columns to organize related data Use secondary indexes and materialized views to avoid denormalization of data Effortlessly handle concurrent updates with collection columns Ensure data integrity with lightweight transactions and logged batches Understand eventual consistency and use the right consistency level for your situation Understand data distribution with Cassandra Develop simple application using Java driver and implement application-level optimizations In Detail Cassandra is a distributed database that stands out thanks to its robust feature set and intuitive interface, while providing high availability and scalability of a distributed data store. This book will introduce you to the rich feature set offered by Cassandra, and empower you to create and manage a highly scalable, performant and fault-tolerant database layer. The book starts by explaining the new features implemented in Cassandra 3.x and get you set up with Cassandra. Then you'll walk through data modeling in Cassandra and the rich feature set available to design a flexible schema. Next you'll learn to create tables with composite partition keys, collections and user-defined types and get to know different methods to avoid denormalization of data. You will then proceed to create user-defined functions and aggregates in Cassandra. Then, you will set up a multi node cluster and see how the dynamics of Cassandra change with it. Finally, you will implement some application-level optimizations using a Java client. By the end of this book, you'll be fully equipped to build powerful, scalable Cassandra database layers for your applications. Style and approach This book takes a step-...
    Note: Description based on online resource; title from title page (Safari, viewed May 11, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 38
    ISBN: 9781787125674 , 178712567X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: PostgreSQL ; Database management ; SQL (Computer program language) ; Electronic books ; Electronic books ; local
    Abstract: Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL About This Book Create a PostgreSQL cluster that stays online even when disaster strikes Avoid costly downtime and data loss that can ruin your business Updated to include the newest features introduced in PostgreSQL 9.6 with hands-on industry-driven recipes Who This Book Is For If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you. What You Will Learn Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, pglogical, and WAL-E Hardware planning to help your database run efficiently Prepare for catastrophes and prevent them before they happen Reduce database resource contention with connection pooling using pgpool and PgBouncer Automate monitoring and alerts to visualize cluster activity using Nagios and collected Construct a robust software stack that can detect and fix outages Learn simple PostgreSQL High Availability with Patroni, or dive into the full power of Pacemaker. In Detail Databases are nothing without the data they store. In the event of a failure - catastrophic or otherwise - immediate recovery is essential. By carefully combining multiple servers, it's even possible to hide the fact a failure occurred at all. From hardware selection to software stacks and horizontal scalability, this book will help you build a versatile PostgreSQL cluster that will survive crashes, resist data corruption, and grow smoothly with customer demand. It all begins with hardware selection for the skeleton of an efficient PostgreSQL database cluster. Then it's on to preventing downtime as well as troubleshooting some real life problems that administrators commonly face. Next, we add database monitoring to the stack, using collectd, Nagios, and Graphite. And no stack is complete without replication using multiple internal and external tools, including the newly released pglogical extension. Pacemaker or Raft consensus tools are the final piece to grant the cluster the ability to heal itself. We even round off by tackling the complex problem of data scalability. This book exploits many new features introduced in PostgreSQL 9.6 to make the database ...
    Note: Previous edition published 2014. - Description based on online resource; title from title page (Safari, viewed March 3, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 39
    ISBN: 9781786460875 , 1786460874
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease About This Book Acquaint yourself with all the newly introduced features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality This detailed, step-by-step guide covers everything you need to develop efficient data integration and data transformation solutions for your organization Who This Book Is For This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017. What You Will Learn Understand the key components of an ETL solution using SQL Server 2016-2017 Integration Services Design the architecture of a modern ETL solution Have a good knowledge of the new capabilities and features added to Integration Services Implement ETL solutions using Integration Services for both on-premises and Azure data Improve the performance and scalability of an ETL solution Enhance the ETL solution using a custom framework Be able to work on the ETL solution with many other developers and have common design paradigms or techniques Effectively use scripting to solve complex data issues In Detail SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you'll gain complete hands-on experience of SSIS 2017 as well as the 2016 new features, design and development improvements including SCD, Tuning, and Customizations. At the start, you'll learn to install and set up SSIS as well other SQL Server resources to make optimal use of this Business Intelligence tools. We'll begin by taking you through the new features in SSIS 2016/2017 and implementing the necessary features to get a modern scalable ETL solution that fits the modern data warehouse. Through the course of chapters, you will learn how to design and build SSIS data warehouses packages using SQL Server Data Tools. Additionally, you'll learn to develop SSIS packages designed to maintain a data warehouse using the Data Flow and other control flow tasks. You'll also be demonstrated many recipes on cleansing...
    Note: Description based on online resource; title from title page (Safari, viewed July 21, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 40
    ISBN: 9781785889806 , 178588980X
    Language: English
    Pages: 1 online resource (1 volume)
    Edition: 9.5/9.6 edition.
    Keywords: PostgreSQL ; SQL (Computer program language) ; Query languages (Computer science) ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Over 150 recipes to help you administer your PostgreSQL database more efficiently About This Book Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently Monitor, tune, secure and protect your database A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease Who This Book Is For This book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience. What You Will Learn Implement PostgreSQL features for performance and reliability Harness the power of the latest PostgreSQL 9.6 features Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms Discover advanced technical tips for experienced users Explore best practices for planning and designing live databases Select and implement robust backup and recovery techniques Explore concise and clear guidance on replication and high availability See the latest details on Logical Replication and Bi-Directional Replication In Detail PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management. Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance. By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently. Style and approach This book takes a step-by-step, recipe-based approach, where each recipe focuses on a particular challenge faced by a PostgreSQL administrator while administering his/her database. Explained in a very easy to follow man...
    Note: Description based on online resource; title from title page (Safari, viewed May 15, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 41
    ISBN: 9781782172130 , 1782172130
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Series Statement: Quick answers to common problems
    Keywords: Oracle (Computer file) ; Relational databases ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Secure your Oracle Database 12c with this valuable Oracle support resource, featuring more than 100 solutions to the challenges of protecting your data About This Book Explore and learn the new security features introduced in Oracle Database 12c, to successfully secure your sensitive data Learn how to identify which security strategy is right for your needs ? and how to apply it Each 'recipe' provides you with a single step-by-step solution, making this book a vital resource, delivering Oracle support in one accessible place Who This Book Is For This book is for DBAs, developers, and architects who are keen to know more about security in Oracle Database 12c. This book is best suited for beginners and intermediate-level database security practitioners. Basic knowledge of Oracle Database is expected, but no prior experience of securing a database is required. What You Will Learn Analyze application privileges and reduce the attack surface Reduce the risk of data exposure by using Oracle Data Redaction and Virtual Private Database Control data access and integrity in your organization using the appropriate database feature or option Learn how to protect your databases against application bypasses Audit user activity using the new auditing architecture Restrict highly privileged users from accessing data Encrypt data in Oracle Database Work in a real-world environment where a multi-layer security strategy is applied In Detail Businesses around the world are paying much greater attention toward database security than they ever have before. Not only does the current regulatory environment require tight security, particularly when dealing with sensitive and personal data, data is also arguably a company's most valuable asset - why wouldn't you want to protect it in a secure and reliable database? Oracle Database lets you do exactly that. It's why it is one of the world's leading databases ? with a rich portfolio of features to protect data from contemporary vulnerabilities, it's the go-to database for many organizations. Oracle Database 12c Security Cookbook helps DBAs, developers, and architects to better understand database security challenges. Let it guide you through the process of implementing appropriate security mechanisms, helping you to ensure you are taking proactive steps to keep your data safe. Featuring solutions for common security problems in the new Oracle Database 12c, with this book you can be confident about securing your database ...
    Note: Description based on online resource; title from cover page (Safari, viewed June 24, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 42
    ISBN: 9781786468062 , 1786468069
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: Electronic data processing ; Distributed processing ; Management ; Data structures (Computer science) ; Database management ; Big data ; Electronic books ; Electronic books ; local
    Abstract: Combine the incredible powers of Spark, Mesos, Akka, Cassandra, and Kafka to build data processing platforms that can take on even the hardest of your data troubles! About This Book This highly practical guide shows you how to use the best of the big data technologies to solve your response-critical problems Learn the art of making cheap-yet-effective big data architecture without using complex Greek-letter architectures Use this easy-to-follow guide to build fast data processing systems for your organization Who This Book Is For If you are a developer, data architect, or a data scientist looking for information on how to integrate the Big Data stack architecture and how to choose the correct technology in every layer, this book is what you are looking for. What You Will Learn Design and implement a fast data Pipeline architecture Think and solve programming challenges in a functional way with Scala Learn to use Akka, the actors model implementation for the JVM Make on memory processing and data analysis with Spark to solve modern business demands Build a powerful and effective cluster infrastructure with Mesos and Docker Manage and consume unstructured and No-SQL data sources with Cassandra Consume and produce messages in a massive way with Kafka In Detail SMACK is an open source full stack for big data architecture. It is a combination of Spark, Mesos, Akka, Cassandra, and Kafka. This stack is the newest technique developers have begun to use to tackle critical real-time analytics for big data. This highly practical guide will teach you how to integrate these technologies to create a highly efficient data analysis system for fast data processing. We'll start off with an introduction to SMACK and show you when to use it. First you'll get to grips with functional thinking and problem solving using Scala. Next you'll come to understand the Akka architecture. Then you'll get to know how to improve the data structure architecture and optimize resources using Apache Spark. Moving forward, you'll learn how to perform linear scalability in databases with Apache Cassandra. You'll grasp the high throughput distributed messaging systems using Apache Kafka. We'll show you how to build a cheap but effective cluster infrastructure with Apache Mesos. Finally, you will deep dive into the different aspect of SMACK using a few case studies. By the end of the book, you will be able to integrate all the components of the SMACK stack and use them together to ach...
    Note: Description based on online resource; title from cover (Safari, viewed January 17, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 43
    ISBN: 9781786462831 , 1786462834
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Keywords: Python (Computer program language) ; Database management ; Information visualization ; Electronic books ; Electronic books ; local
    Abstract: Become an efficient data science practitioner by understanding Python's key concepts About This Book Quickly get familiar with data science using Python 3.5 Save time (and effort) with all the essential tools explained Create effective data science projects and avoid common pitfalls with the help of examples and hints dictated by experience Who This Book Is For If you are an aspiring data scientist and you have at least a working knowledge of data analysis and Python, this book will get you started in data science. Data analysts with experience of R or MATLAB will also find the book to be a comprehensive reference to enhance their data manipulation and machine learning skills. What You Will Learn Set up your data science toolbox using a Python scientific environment on Windows, Mac, and Linux Get data ready for your data science project Manipulate, fix, and explore data in order to solve data science problems Set up an experimental pipeline to test your data science hypotheses Choose the most effective and scalable learning algorithm for your data science tasks Optimize your machine learning models to get the best performance Explore and cluster graphs, taking advantage of interconnections and links in your data In Detail Fully expanded and upgraded, the second edition of Python Data Science Essentials takes you through all you need to know to suceed in data science using Python. Get modern insight into the core of Python data, including the latest versions of Jupyter notebooks, NumPy, pandas and scikit-learn. Look beyond the fundamentals with beautiful data visualizations with Seaborn and ggplot, web development with Bottle, and even the new frontiers of deep learning with Theano and TensorFlow. Dive into building your essential Python 3.5 data science toolbox, using a single-source approach that will allow to to work with Python 2.7 as well. Get to grips fast with data munging and preprocessing, and all the techniques you need to load, analyse, and process your data. Finally, get a complete overview of principal machine learning algorithms, graph analysis techniques, and all the visualization and deployment instruments that make it easier to present your results to an audience of both data science experts and business users. Style and approach The book is structured as a data science project. You will always benefit from clear code and simplified examples to help you understand the underlying mechanics and real-world datasets.
    Note: Previous edition published: 2015. - Description based on online resource; title from cover (Safari, viewed November 10, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 44
    ISBN: 9781782161097 , 1782161090
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Series Statement: Quick answers to common problems
    Keywords: Apache (Computer file : Apache Group) ; Apache Hadoop ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Easy, hands-on recipes to help you understand Hive and its integration with frameworks that are used widely in today's big data world About This Book Grasp a complete reference of different Hive topics. Get to know the latest recipes in development in Hive including CRUD operations Understand Hive internals and integration of Hive with different frameworks used in today's world. Who This Book Is For The book is intended for those who want to start in Hive or who have basic understanding of Hive framework. Prior knowledge of basic SQL command is also required What You Will Learn Learn different features and offering on the latest Hive Understand the working and structure of the Hive internals Get an insight on the latest development in Hive framework Grasp the concepts of Hive Data Model Master the key concepts like Partition, Buckets and Statistics Know how to integrate Hive with other frameworks such as Spark, Accumulo, etc In Detail Hive was developed by Facebook and later open sourced in Apache community. Hive provides SQL like interface to run queries on Big Data frameworks. Hive provides SQL like syntax also called as HiveQL that includes all SQL capabilities like analytical functions which are the need of the hour in today's Big Data world. This book provides you easy installation steps with different types of metastores supported by Hive. This book has simple and easy to learn recipes for configuring Hive clients and services. You would also learn different Hive optimizations including Partitions and Bucketing. The book also covers the source code explanation of latest Hive version. Hive Query Language is being used by other frameworks including spark. Towards the end you will cover integration of Hive with these frameworks. Style and approach Starting with the basics and covering the core concepts with the practical usage, this book is a complete guide to learn and explore Hive offerings.
    Note: Includes index. - Description based on online resource; title from cover (viewed May 10, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 45
    ISBN: 9781786468628 , 178646862X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: RethinkDB (Computer file) ; Database management ; Application software ; Development ; Computer programs ; Open source software ; Electronic books ; Electronic books ; local
    Abstract: Master the capabilities of RethinkDB and implement them to develop efficient real-time web applications. The way to better database development is here! About This Book Master the powerful ReQL queries to manipulate your JSON data, Learn how to develop scalable, real-time web applications using RethinkDB and Node.js and deploy them for production, A detailed, step-by-step guide to help you master the concepts of RethinkDB programming with ease Who This Book Is For This book caters to all the real-time application developers looking forward to master their skills using RethinkDB. A basic understanding of RethinkDB and Node.js is essential to get the most out of this book. What You Will Learn Master the web-based management console for data-center configuration (sharding, replication, and more), database monitoring, and testing queries. Run queries using the ReQL language Perform Geospatial queries (such as finding all the documents with locations within 5km of a given point). Deal with time series data, especially across various times zones. Extending the functionality of RethinkDB and integrate it with third party libraries such as ElasticSearch to enhance our search In Detail RethinkDB has a lot of cool things to be excited about: ReQL (its readable,highly-functional syntax), cluster management, primitives for 21st century applications, and change-feeds. This book starts with a brief overview of the RethinkDB architecture and data modeling, and coverage of the advanced ReQL queries to work with JSON documents. Then, you will quickly jump to implementing these concepts in real-world scenarios, by building real-time applications on polling, data synchronization, share market, and the geospatial domain using RethinkDB and Node.js. You will also see how to tweak RethinkDB's capabilities to ensure faster data processing by exploring the sharding and replication techniques in depth. Then, we will take you through the more advanced administration tasks as well as show you the various deployment techniques using PaaS, Docker, and Compose. By the time you have finished reading this book, you would have taken your knowledge of RethinkDB to the next level, and will be able to use the concepts in RethinkDB to develop efficient, real-time applications with ease. Style and approach This book is a unique blend of comprehensive theory and real-world examples to help you master RethinkDB.
    Note: Description based on online resource; title from cover (viewed January 18, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 46
    ISBN: 9781785880292 , 1785880292
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Internet of things ; Computer networks ; Security measures ; Database management ; Electronic books ; Electronic books ; local
    Abstract: A practical, indispensable security guide that will navigate you through the complex realm of securely building and deploying systems in our IoT-connected world About This Book Learn to design and implement cyber security strategies for your organization Learn to protect cyber-physical systems and utilize forensic data analysis to beat vulnerabilities in your IoT ecosystem Learn best practices to secure your data from device to the cloud Gain insight into privacy-enhancing techniques and technologies Who This Book Is For This book targets IT Security Professionals and Security Engineers (including pentesters, security architects and ethical hackers) who would like to ensure security of their organization's data when connected through the IoT. Business analysts and managers will also find it useful. What You Will Learn Learn how to break down cross-industry barriers by adopting the best practices for IoT deployments Build a rock-solid security program for IoT that is cost-effective and easy to maintain Demystify complex topics such as cryptography, privacy, and penetration testing to improve your security posture See how the selection of individual components can affect the security posture of the entire system Use Systems Security Engineering and Privacy-by-design principles to design a secure IoT ecosystem Get to know how to leverage the burdgening cloud-based systems that will support the IoT into the future. In Detail With the advent of Intenret of Things (IoT), businesses will be faced with defending against new types of threats. The business ecosystem now includes cloud computing infrastructure, mobile and fixed endpoints that open up new attack surfaces, a desire to share information with many stakeholders and a need to take action quickly based on large quantities of collected data. . It therefore becomes critical to ensure that cyber security threats are contained to a minimum when implementing new IoT services and solutions. . The interconnectivity of people, devices, and companies raises stakes to a new level as computing and action become even more mobile, everything becomes connected to the cloud, and infrastructure is strained to securely manage the billions of devices that will connect us all to the IoT. This book shows you how to implement cyber-security solutions, IoT design best practices and risk mitigation methodologies to address device and infrastructure threats to IoT solutions. This book will take readers on a journey th...
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed July 13, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 47
    ISBN: 9781783988198 , 1783988193
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Information retrieval ; Computer programs ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Take your knowledge of Redis to the next level to build enthralling applications with ease About This Book Detailed explanation on Data structure server with powerful strings, lists, sets, sorted-sets, and hashes Learn to Scale your data with Redis Cluster's distributed setup This is a fast paced practical guide full of screenshots and real work examples to help you get to grips with Redis in no time. Who This Book Is For If you are a software developer with some experience with Redis and would now like to elevate your Redis knowledge and skills even further, then this book is for you. What You Will Learn Choose the right Redis data structure for your problem Understand Redis event-loop and implement your own custom C commands Solve complex workflows with Redis server-side scripting with Lua Configure your Redis instance for optimal memory management Scale your data in a distributed manner with Redis Cluster Improve the stability of your Redis solution using Redis Sentinel Complement your existing database and NoSQL environment with Redis Exploit a wide range of features provided by Redis to become a DevOps expert. In Detail Redis is the most popular, open-source, key value data structure server that provides a wide range of capabilities on which multiple platforms can be be built. Its fast and flexible data structures give your existing applications an edge in the development environment. This book is a practical guide which aims to help you deep dive into the world of Redis data structure to exploit its excellent features. We start our journey by understanding the need of Redis in brief, followed by an explanation of Advanced key management. Next, you will learn about design patterns, best practices for using Redis in DevOps environment and Docker containerization paradigm in detail. After this, you will understand the concept of scaling with Redis cluster and Redis Sentinel , followed by a through explanation of incorporating Redis with NoSQL technologies such as Elasticsearch and MongoDB. At the end of this section, you will be able to develop competent applications using these technologies. You will then explore the message queuing and task management features of Redis and will be able to implement them in your applications. Finally, you will learn how Redis can be used to build real-time data analytic dashboards, for different disparate data streams. Style and approach This is a hands on guide full of easy-to-follow examples, that illust...
    Note: Includes index. - Description based on online resource; title from cover (viewed June 21, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 48
    ISBN: 9781783989010 , 1783989017
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: PostgreSQL ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Develop programmatic functions to create powerful database applications About This Book Write complex SQL queries and design a robust database design that fits your application's need Improve database performance by indexing, partitioning tables, and query optimizing A comprehensive guide covering the advanced PostgreSQL concepts without any hassle Who This Book Is For If you are a PostgreSQL developer with a basic knowledge of PostgreSQL development and you're want deeper knowledge to develop applications, then this book is for you. As this book does not cover basic installation and configurations, you should have PostgreSQL installed on your machine as a prerequisite. What You Will Learn Write more complex queries with advanced SQL queries Design a database that works with the application exactly the way you want Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing Develop applications in other programming languages such as Java and PHP Use extensions to get extra benefits in terms of functionality and performance Build an application that does not get locked by data manipulation Explore in-built db functions and data type conversions In Detail PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it's difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database. The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts Style and approach Every chapter follows a step by ste...
    Note: Description based on online resource; title from cover (Safari, viewed October 11, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 49
    ISBN: 9781785884467 , 1785884468
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Series Statement: Community experience distilled
    Keywords: Node.js ; Database management ; Application software ; Development ; Electronic books ; Electronic books ; local
    Abstract: Absorb the knowledge required to utilize, manage, and deploy RethinkDB using Node.js About This Book Make the most of this open source, scalable database - RethinkDB - to ease the construction of web applications Run powerful queries using ReQL, which is the most convenient language to manipulate JSON documents with Develop fully-fledged real-time web apps using Node.js and RethinkDB Who This Book Is For Getting Started with RethinkDB is ideal for developers who are new to RethinkDB and need a practical understanding to start working with it. No previous knowledge of database programming is required, although a basic knowledge of JavaScript or Node.js would be helpful. What You Will Learn Download and install the database on your system Configure RethinkDB's settings and start using the web interface Import data into RethinkDB Run queries using the ReQL language Create shards, replicas, and RethinkDB clusters Use an index to improve database performance Get to know all the RethinkDB deployment techniques In Detail RethinkDB is a high-performance document-oriented database with a unique set of features. This increasingly popular NoSQL database is used to develop real-time web applications and, together with Node.js, it can be used to easily deploy them to the cloud with very little difficulty. Getting Started with RethinkDB is designed to get you working with RethinkDB as quickly as possible. Starting with the installation and configuration process, you will learn how to start importing data into the database and run simple queries using the intuitive ReQL query language. After successfully running a few simple queries, you will be introduced to other topics such as clustering and sharding. You will get to know how to set up a cluster of RethinkDB nodes and spread database load across multiple machines. We will then move on to advanced queries and optimization techniques. You will discover how to work with RethinkDB from a Node.js environment and find out all about deployment techniques. Finally, we'll finish by working on a fully-fledged example that uses the Node.js framework and advanced features such as Changefeeds to develop a real-time web application. Style and approach This is a step-by-step book that provides a practical approach to RethinkDB programming, and is explained in a conversational, easy-to-follow style.
    Note: Incudes index. - Description based on online resource; title from cover page (Safari, viewed March 30, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 50
    ISBN: 9781786467997 , 1786467992
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016's features and capabilities. What You Will Learn Key capabilities, architecture, and components of Reporting Services New features that have been added to Reporting Services Design the architecture for reporting solutions Design the architecture for BI solutions Implement reporting solutions using Reporting Services Improve the performance, availability, and scalability of the reporting solution Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You'll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you'll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail ...
    Note: Description based on online resource; title from cover (Safari, viewed January 3, 2017)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 51
    ISBN: 9781785284281 , 1785284282
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Database management ; Client/server computing ; Application software ; Development ; Electronic books ; Electronic books ; local
    Abstract: Design documents and implement real world e-commerce applications with Couchbase About This Book Get acquainted with Couchbase architecture and design your document-based data schema Implement full text search using industry standard elastic search plugins Develop critical and high performance applications using this hands-on tutorial guide Who This Book Is For If you are new to the NoSQL document system or have little or no experience in NoSQL development and administration and are planning to deploy Couchbase for your next project, then this book is for you. It would be helpful to have a bit of familiarity with Java. What You Will Learn Get acquainted with the concept of NoSQL databases and configure your Couchbase database cluster Maintain Couchbase effectively using the web-based administrative console with ease Enable partition capabilities by making use of Buckets Analyze important design considerations for maintaining relationship between various documents Use Couchbase SDK Java API to store and retrieve document Write views using map/reduce to retrieve documents efficiently Get familiar with N1QL and how to use it in Java applications Integrate Couchbase with Elasticsearch to implement full text search Configure XDCR for disaster recovery and develop ecommerce application using Couchbase In Detail NoSQL database systems have changed application development in terms of adaptability to dynamics schema and scalability. Compared with the currently available NoSQL database systems, Couchbase is the fastest. Its ease of configuration and powerful features for storing different schema structures, retrieval using map reduce and inbuilt disaster recovery by replicating document across the geographical region, make it one of the most powerful, scalable and comprehensive NoSQL in the market. Couchbase also introduces smart client API for various programming language to integrate the database with the application easily, yet providing very complex features like cluster health awareness. This book achieves its goal by taking up an end-to-end development structure, right from understanding NOSQL document design to implementing full fledged eCommerce application design using Couchbase as a backend. Starting with the architecture of Couchbase to get you up and running, this book quickly takes you through designing a NoSQL document and implementing highly scalable applications using Java API. You will then be introduced to document design and get to kn...
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed February 9, 2016)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 52
    ISBN: 9781784397104 , 1784397105
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Series Statement: Professional expertise distilled
    Keywords: SQL server ; Database management ; Database design ; SQL (Computer program language) ; Windows PowerShell (Computer program language) ; Electronic books ; Electronic books ; local
    Abstract: Manage and monitor SQL Server administration and application deployment with PowerShell In Detail PowerShell for SQL Server Essentials helps us to manage and monitor server administration and application deployment. Use PowerShell along with SQL Server to perform common DBA tasks. Starting with a basic introduction to PowerShell, the initial chapters will provide the SQL Server professional PowerShell fundamentals, covering topics such as PowerShell notations and syntax, cmdlets, pipeline, and getting help. Succeeding chapters build upon these fundamentals, and illustrate how to administer and automate SQL Server. Tasks covered throughout include profiling the SQL Server instance, performing backup and restores, invoking T-SQL scripts using PowerShell, and monitoring jobs, security, and permissions. Packed with practical examples and numerous ready-to-use snippets, this book gets you to an intermediate level in using PowerShell for SQL Server. What You Will Learn Create scripts using PowerShell to manage and monitor server administration and application deployment Automate the creation of SQL Database objects through PowerShell with the help of the SQL Server module (SQLPS) and SQL Server snap-ins Use PowerShell to work with SQL Server specific providers and cmdlets Identify and manage SQL Server services, instances, settings, and confi gurations Profile your SQL Server instances and export current configurations to a file Monitor SQL Server jobs and alerts Manage logins, database users, and instance security and permissions Invoke T-SQL queries from PowerShell and export results Accomplish tasks from your DBA daily/weekly/monthly/yearly checklists with PowerShell
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed March 26, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 53
    ISBN: 9781783989218 , 1783989211
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Apache Cassandra ; Database management ; Database design ; Web services ; Information storage and retrieval systems ; Electronic books ; Electronic books ; local
    Abstract: Build an efficient, scalable, fault-tolerant, and highly-available data layer into your application using Cassandra In Detail Cassandra is a distributed database that stands out for its robust feature set and intuitive interface, while still providing the high availability and scalability of a distributed store. Starting from installing Cassandra and creating your first keyspace, to mastering the different table structures Cassandra offers and exploring the latest and most powerful features of the Cassandra Query Language, CQL3, this book explores each topic through the lens of a real-world example application. With plenty of examples, tips, and clear explanations, you'll master compound primary keys, collection columns, lightweight transactions, and many other advanced aspects of Cassandra. By the end of the book, you'll be fully equipped to build powerful, scalable Cassandra database layers for your applications. What You Will Learn Install Cassandra and create your first keyspace Choose the right table structure for the task at hand in a variety of scenarios Use range slice queries for efficient data access Effortlessly handle concurrent updates with collection columns Ensure data integrity with lightweight transactions and logged batches Understand eventual consistency and use the right consistency level for your situation Implement best practices for data modeling and access
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed March 26, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 54
    ISBN: 9781783989119 , 1783989114
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Apache Cassandra ; Database design ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Create your own massively scalable Cassandra database with highly responsive database queries About This Book Create a Cassandra cluster and tweak its configuration to get the best performance based on your environment Analyze the key concepts and architecture of Cassandra, which are essential to create highly responsive Cassandra databases A fast-paced and step-by-step guide on handling huge amount of data and getting the best out of your database applications Who This Book Is For If you are a developer who is working with Cassandra and you want to deep dive into the core concepts and understand Cassandra's non-relational nature, then this book is for you. A basic understanding of Cassandra is expected. What You Will Learn Install and set up your Cassandra Cluster using various installation types Use Cassandra Query Language (CQL) to design Cassandra database and tables with various configuration options Design your Cassandra database to be evenly loaded with the lowest read/write latencies Employ the available Cassandra tools to monitor and maintain a Cassandra cluster Debug CQL queries to discover why they are performing relatively slowly Choose the best-suited compaction strategy for your database based on your usage pattern Tune Cassandra based on your deployment operation system environment In Detail Apache Cassandra Essentials takes you step-by-step from from the basics of installation to advanced installation options and database design techniques. It gives you all the information you need to effectively design a well distributed and high performance database. You'll get to know about the steps that are performed by a Cassandra node when you execute a read/write query, which is essential to properly maintain of a Cassandra cluster and to debug any issues. Next, you'll discover how to integrate a Cassandra driver in your applications and perform read/write operations. Finally, you'll learn about the various tools provided by Cassandra for serviceability aspects such as logging, metrics, backup, and recovery. Style and approach This step-by-step guide is packed with examples that explain the core concepts as well as advanced concepts, techniques, and usages of Apache Cassandra.
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed December 4, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 55
    ISBN: 9781783980598 , 1783980591
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Series Statement: Community experience distilled
    Keywords: PostgreSQL ; SQL (Computer program language) ; Database design ; Database management ; Web servers ; Databases ; Programming ; Electronic books ; Electronic books ; local
    Abstract: Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language In Detail This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and a host of other features that the PostgreSQL engine provides. You will get to grips with creating libraries of useful code, grouping them into even more useful components, and distributing them to the community. Then, you will take a look at user-defined functions, and how to define and utilize them efficiently. You will also learn how to extract data from a multitude of foreign data sources and extend PostgreSQL to do it natively. What's more, you can do all of this in a nifty debugging interface that will allow you to do it efficiently and reliably. This book explores all possible ways to extend PostgreSQL and write server-side code using various programming languages with concrete and easy-to-understand examples. What You Will Learn Write functions in the built-in PL/pgSQL language or your language of choice Define and use user-defined functions (UDF) Scale your data with PL/Proxy Extend PostgreSQL to overcome the limitations of classical SQL servers Debug using NOTIFY and using PL/pgSQL debugging extensions Discover the new features in PostgreSQL 9.4 such as event triggers and other improvements relevant to server-side programming Fully integrate the database layer into your development
    Note: Includes index. - Description based on online resource; title from cover page (Safari, viewed March 20, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 56
    ISBN: 9781783554843 , 1783554843
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Series Statement: Quick answers to common problems
    Keywords: Lucene (Electronic resource) ; Database searching ; Database management ; Client/server computing ; Electronic books ; Electronic books ; local
    Abstract: Over 130 advanced recipes to search, analyze, deploy, manage, and monitor data effectively with ElasticSearch In Detail This book will guide you through the complete ElasticSearch ecosystem. From choosing the correct transport layer and communicating with the server to creating and customizing internal actions, you will develop an in-depth knowledge of the implementation of the ElasticSearch architecture. After creating complex queries and analytics, mapping, aggregation, and scripting, you will master the integration of ElasticSearch's functionality in user-facing applications and take your knowledge one-step further by building custom plugins, developing tailored mapping, executing powerful analytics, and integrating with Python and Java applications. What You Will Learn Make ElasticSearch work for you by choosing the best cloud topology and powering it with plugins Develop tailored mapping to take full control of index steps Build complex queries through managing indices and documents Optimize search results through executing analytics aggregations Manage rivers (SQL, NoSQL, and web-based) to synchronize and populate cross-source data Develop web interfaces to execute key tasks Monitor the performance of the cluster and nodes
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed February 24, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 57
    ISBN: 9781782175711 , 1782175717
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Series Statement: Community experience distilled
    Keywords: MariaDB ; MySQL (Electronic resource) ; Relational databases ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Explore the powerful features of MariaDB with practical examples In Detail MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available. From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it. What You Will Learn Install MariaBD on Windows, Mac OS X, and Linux Configure MariaDB for better performance using the features of version 10 Get familiar with the usage of operators for retrieving rows more selectively Use MariaDB 10's powerful tools to store, retrieve, and analyze data Secure MariaDB from unauthorized access Maintain the databases associated with MariaDB to ensure efficient and optimum functioning Retrieve data and learn how to sort, summarize, group, and manipulate it.
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed July 28, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 58
    ISBN: 9781783980772 , 178398077X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Series Statement: Professional expertise distilled
    Keywords: Oracle (Computer file) ; Middleware ; Database management ; Real-time data processing ; Information retrieval ; Electronic books ; Electronic books ; local
    Abstract: Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise In Detail GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips. What You Will Learn Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives Deliver best-in-class data integration solutions by integrating GoldenGate with other Oracle products Deploy data integration solutions effectively to lower your total cost of ownership and increase you ROI Extend GoldenGate functionality through APIs and reduce your IT operational expenditure Leverage the designs to build efficient, cost effective data integration solutions Enhance system management and monitoring in your GoldenGate environment Generate real-time statistics to gauge data throughput and performance Evaluate data integration concepts through Oracle's new Integration Cloud Service offering
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed August 13, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 59
    Online Resource
    Online Resource
    Birmingham, UK : Packt Publishing
    ISBN: 9781783980130 , 1783980133
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community Experience Distilled
    Keywords: Database design ; Computer programs ; Database management ; Data warehousing ; Management information systems ; Open source software ; Electronic books ; Electronic books ; local
    Abstract: Design efficient web and business solutions with Redis Model and design databases effectively in Redis Learn about sharding, indexing, and migrating strategies in Redis A simple step-by-step tutorial explaining the main concepts of Redis through practical examples In Detail This book will introduce Redis and help you understand its various facets. Starting with an introduction to NoSQL, you will learn how to install Redis and how to classify and work with data structures. By working with real world scenarios pertaining to using Redis, you will discover sharding and indexing techniques, along with how to improve scalability and performance through persistent strategies and data migration techniques. With the help of multiple examples, you will learn to design web and business applications. You will also learn how to configure Redis for setting up clusters and tuning it for performance. At the end of this book, you will find essential tips on backup and recovery strategies for the Redis environment. What You Will Learn Familiarise yourself with NoSQL and install Redis Build solutions and enhance your web applications in Redis Understand the persistent mechanism for better scalability Configure and tune the server to improve performance Identify bottlenecks and how to handle fault management in Redis Learn about backups and recovery strategies for the Redis environment Discover the commands and functions of Redis
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed July 20, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 60
    ISBN: 9781849519076 , 1849519072
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Keywords: PostgreSQL ; SQL (Computer program language) ; Query languages (Computer science) ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Over 150 recipes to help you run an efficient PostgreSQL database in the cloud In Detail PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world's most popular server databases with an enviable reputation for performance and stability and an enormous range of advanced features. Starting with short and simple recipes to get you back up and running with an exploration of the ins and outs of your database, you will soon dive into core features such as configuration, server control, tables, and data. This is a practical guide aimed at giving sysadmins and database administrators the necessary toolkit to be able to set up, run, and extend powerful databases with PostgreSQL. What You Will Learn Implement PostgreSQL features for reliability and performance Harness the power of the latest PostgreSQL 9.4 features Manage PostgreSQL versions 9.0, 9.1, 9.2, 9.3, and 9.4 Advanced technical tips for experienced users Explore best practices for planning and designing live databases Select and implement robust backup and recovery techniques Concise and clear guidance on replication and high availability Latest details on Logical Replication and Bi-Directional Replication
    Note: "Quick answers to common problems.". - Includes index. - Description based on online resource; title from cover (Safari, viewed May 26, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 61
    ISBN: 9781785283611 , 1785283618
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Quick answers to common problems
    Keywords: SQL server ; Windows PowerShell (Computer program language) ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Over 150 real-world recipes to simplify database management, automate repetitive tasks, and enhance your productivity About This Book This book helps you build a strong foundation to get you comfortable using PowerShell with SQL Server, empowering you to create more complex scripts for your day-to-day job The book provides numerous guidelines, tips, and explanations on how and when to use PowerShell cmdlets, WMI, SMO, .NET classes, or other components It offers easy-to-follow, practical recipes to help you get the most out of SQL Server and PowerShell Who This Book Is For If you are a SQL Server database professional (DBA, developer, or BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks, this books is for you. Prior knowledge of scripting would be helpful, but it is not necessary. What You Will Learn Explore database objects and execute queries on multiple servers Manage and monitor the running of SQL Server services and accounts Back up and restore databases Create an inventory of database properties and server configuration settings Maintain permissions and security for users Work with CLR assemblies, XML, and BLOB objects in SQL Manage and deploy SSIS packages and SSRS reports In Detail PowerShell can be leveraged when automating and streamlining SQL Server tasks. PowerShell comes with a rich set of cmdlets, and integrates tightly with the .NET framework. Its scripting capabilities are robust and flexible, allowing you to simplify automation and integration across different Microsoft applications and components. The book starts with an introduction to the new features in SQL Server 2014 and PowerShell v5 and the installation of SQL Server. You will learn about basic SQL Server administration tasks and then get to know about some security-related topics such as the authentication mode and assigning permissions. Moving on, you will explore different methods to back up and restore your databases and perform advanced administration tasks such as working with Policies, Filetables, and SQL audits. The next part of the book covers more advanced HADR tasks such as log shipping and data mirroring, and then shows you how to develop your server to work with BLOB, XML, and JSON. Following on from that, you will learn about SQL Server's BI stack, which includes SSRS reports, the SSIS package, and the SSAS cmdlet and database. Snippets not specific to SQL Server will help you perform tasks quickly on SQL servers...
    Note: Includes index. - Description based on online resource; title from cover page (Safari, viewed December 22, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 62
    ISBN: 9781783988488 , 1783988487
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Second edition.
    Series Statement: Community experience distilled
    Keywords: Apache Cassandra ; Database management ; Software patterns ; Electronic books ; Electronic books ; local
    Abstract: Build real-world, industry-strength data storage solutions with time-tested design methodologies using Cassandra About This Book Explore design patterns which co-exist with legacy data stores, migration from RDBMS, and caching technologies with Cassandra Learn about design patterns and use Cassandra to provide consistency, availability, and partition tolerance guarantees for applications Handle temporal data for analytical purposes Who This Book Is For This book is intended for big data developers who are familiar with the basics of Cassandra and wish to understand and utilize Cassandra design patterns to develop real-world big data solutions. Prior knowledge of RDBMS solutions is assumed. What You Will Learn Enable Cassandra to co-exist with RDBMS and other legacy data stores Explore various design patterns to build effective and robust storage solutions Migrate from RDBMS-based data stores and caching solutions to Cassandra Understand the behaviour of Cassandra when trying to balance the needs of consistency, availability, and partition tolerance Deal with time stamps related to data effectively See how Cassandra can be used in analytical use cases Apply the design patterns covered in this book in real-world use cases In Detail There are many NoSQL data stores used by big data applications. Cassandra is one of the most widely used NoSQL data stores that is frequently used by a huge number of heavy duty Internet-scale applications. Unlike the RDBMS world, the NoSQL landscape is very diverse and there is no one way to model data stores. This mandates the need to have good solutions to commonly seen data store design problems. Cassandra addresses such common problems simply. If you are new to Cassandra but well-versed in RDBMS modeling and design, then it is natural to model data in the same way in Cassandra, resulting in poorly performing applications and losing the real purpose of Cassandra. If you want to learn to make the most of Cassandra, this book is for you. This book starts with strategies to integrate Cassandra with other legacy data stores and progresses to the ways in which a migration from RDBMS to Cassandra can be accomplished. The journey continues with ideas to migrate data from cache solutions to Cassandra. With this, the stage is set and the book moves on to some of the most commonly seen problems in applications when dealing with consistency, availability, and partition tolerance guarantees. Cassandra is exceptionally good at...
    Note: Includes index. - Description based on online resource; title from cover page (Safari, viewed November 23, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 63
    ISBN: 9781784397852 , 1784397857
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Client/server computing ; Computer science ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Harness the power of Couchbase to build flexible and scalable applications In Detail Couchbase is an extremely fast, flexible, and highly scalable database that applies MapReduce techniques and patterns to find data. Whether you need to store unstructured data or be able to store and retrieve vast amounts of data quickly, Couchbase Server is your database! This book gives you enough information to successfully set up a Couchbase cluster and provides details on basic server maintenance. It then goes on to give you a detailed overview of how to program against Couchbase Server using both its key/value features and its document capabilities. It also introduces you to the concept of creating views using Couchbase's implementation of MapReduce. This book will then conclude with a walkthrough of building an actual application from scratch using Couchbase. What You Will Learn Download, install, and configure a single-node Couchbase Server cluster Explore the Couchbase Server key/value APIs used to put data in and get data out of a Couchbase bucket Review the basics of MapReduce as a programming model used to transform data structures Create simple secondary indexes using Couchbase MapReduce views Learn how to create advanced views to aggregate data in a Couchbase bucket Understand how to design a schema for documents in a schema-less document database Query for data in a Couchbase bucket using the new query language N1QL Design and develop an application from scratch using Couchbase
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed March 26, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 64
    ISBN: 9781784396084 , 1784396087
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Data warehousing ; Database design ; Database management ; Management information systems ; Open source software ; Electronic books ; Electronic books ; local
    Abstract: Harness the power of Redis to integrate and manage your projects efficiently About This Book Learn how to use Redis's data types efficiently to manage large data sets Scale Redis to multiple servers with Twemproxy, Redis Sentinel, and Redis Cluster A fast-paced guide, full of real-world examples to help you get the best out of the features offered by Redis Who This Book Is For If 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. What You Will Learn Build analytics applications using Bitmaps and Hyperloglogs Enhance scalability with Twemproxy, Redis Sentinel, and Redis Cluster Build a Time Series implementation in Node.js and Redis Create your own Redis commands by extending Redis with Lua Get 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 RDB Understand how to use Node.js, PHP, Python, and Ruby clients for Redis Avoid common pitfalls when designing your next solution In Detail Redis 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. Style and approach A practical guide that offers the foundation upon which you can begin to understand the capabilities of Redis using a s...
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed September 20, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 65
    ISBN: 9781784393731 , 1784393738
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Third edition.
    Keywords: Client/server computing ; Database management ; Cloud computing ; High performance computing ; Electronic books ; Electronic books ; local
    Abstract: Jump-start your Puppet deployment using engaging and practical recipes In Detail Puppet is a configuration management system that automates all your IT configurations, giving you control of what you do to each node, when you do it, and how you do it. Puppet Cookbook Third Edition takes the reader from a basic knowledge of Puppet to a complete and expert understanding of Puppet's latest and most advanced features. Updated with the latest advancements and best practices, it gives you a clear view on how to "connect the dots" and expands your knowledge to successfully use and extend Puppet. This book delves into various aspects of writing good Puppet code, which includes using Puppet community style, checking your manifests with puppet-lint, and learning community best practices, with an emphasis on real-world implementation. What You Will Learn Install and set up Puppet for the first time Discover the latest, most advanced, and experimental features of Puppet Bootstrap your Puppet installation Master techniques to deal with centralized and decentralized Puppet deployments Use exported resources and forge modules Create efficient manifests to streamline your deployments Automate Puppet master deployment using Git hooks, r10k, and PuppetDB Make Puppet reliable, performant, and scalable
    Note: "Quick answers to common problems"--Cover. - Includes index. - Description based on online resource; title from cover (Safari, viewed March 13, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 66
    ISBN: 9781783982875 , 178398287X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: MariaDB ; Database management ; Relational databases ; Electronic books ; Electronic books ; local
    Abstract: Quickly get up to speed with MariaDB - the leading, drop-in replacement for MySQL, through this practical tutorial About This Book Get to know the basic SQL queries so you can quickly start using MariaDB Take control of your data through the advanced features of MariaDB Exploit the full potential of MariaDB's exclusive features through quick, practical examples Who This Book Is For If you don't know the SQL language, but you want to quickly jump into the SQL world and learn how to use MariaDB, or if you already know how to use MySQL but you want to go further, then this book is ideal for you. What You Will Learn Install and configure MariaDB Create databases, tables, and indexes Import and export data from and to external files Work with views and virtual columns Create, read, update, and delete records in your database Use dynamic columns Set up a powerful full-text search system Access your external data from MariaDB through the CONNECT engine In Detail This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB's advanced features. At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL. Moving on, you'll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you'll get to grips with full-text searches and queries in MariaDb. You'll also be familiarized with the CONNECT storage engine. At the end of the book, you'll be introduced to the community of MariaDB. Style and approach This is a complete guide that uses concrete examples to help you understand and exploit the full potential of MariaDB.
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed November 17, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 67
    ISBN: 9781783288618 , 1783288612
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience disitlled
    Keywords: PostgreSQL ; Database management ; Database design ; Electronic books ; Electronic books ; local
    Abstract: Discover how to design, develop, and maintain your database application effectively with PostgreSQL In Detail PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up. PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running. The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, you'll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors. Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery. What You Will Learn Compile PostgreSQL from source and understand the PostgreSQL architecture Configure parameters and change default settings for a PostgreSQL server Leverage the logging mechanism to identify errors and suboptimal queries Use replication to scale horizontally Set up backup and recovery processes Tweak parameters to optimize queries and processes Troubleshoot connection errors Use indexes and rewrite queries to improve performance Install and use PostgreSQL extensions Learn how to leverage the command-line client (psql)
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed April 16, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 68
    ISBN: 9781782169987 , 1782169989
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Database management ; Application software ; Development ; Computational grids (Computer systems) ; Java (Computer program language) ; Electronic books ; local
    Abstract: Master Infinispan to create scalable and high-performance applications In Detail Infinispan is an extremely scalable, highly available key/ value data store and data grid platform. In-memory data grids (IMDG) have recently been gaining a lot of attention, and the market for this technology is steadily increasing. This book is a practical guide that covers all Infinispan features in a progressive manner with the help of real-world and ready-to-use examples. You will learn how to install Infinispan and create a perfect development environment. Next, you will learn how to persist data to a permanent store and integrate Infinispan with technologies such as Hibernate OGM, Amazon Web Services (AWS), and CDI. Finally, we will present a sample application that you can download from the JBoss Developer Framework. By the end of this book, you will be able to build extremely scalable applications, providing a highly available key/value data store. What You Will Learn Install Infinispan and create the perfect development environment Get acquainted with topologies and strategies for different situations and data access patterns Familiarize yourself with scaling techniques and concepts including distributed transactions, ACID, and database sharding Monitor your Infinispan instances by using RHQ or JMX clients Control and manage transactions using JTA and use the available APIs to manipulate your cache data Create an application called TicketMonster and learn how to implement Infinispan Learn about JGroups and how to use it with Infinispan for reliable communication Learn the concepts behind big data and how to work with Infinispan MapReduce API
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed June 17, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 69
    ISBN: 9781782174127 , 1782174125
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Professional expertise distilled
    Keywords: SAP HANA (Electronic resource) ; Real-time data processing ; Database management ; Business enterprises ; Data processing ; Electronic books ; Electronic books ; local
    Abstract: Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics About This Book This book will help you to process analytical and transactional data in real time with the help of SAP HANA. Walk through the steps of the data modeling process and build various data models and artifacts in SAP HANA Studio. Packed with rich examples and use cases that are closely focused on developing real-time applications. Who This Book Is For If you are a SAP HANA data modeler, developer, implementation/migration consultant, project manager, or architect who is responsible for implementing/migrating to SAP HANA, then this book is for you. What You Will Learn Get to grips with the basic building blocks of Analytics/Data models in the SAP HANA environment. Discover various schemas, modeling principles, Joins, and the architecture of the SAP HANA engine. Build data models and artifacts in Sap HANA Studio. Design decision tables and understand the concept of transport management in the SAP HANA landscape. Work with the different views in SAP HANA Studio. Explore full-text search and fuzzy search in SAP HANA. Create your own scenarios and use cases using sample data and code. In Detail SAP HANA is an in-memory database created by SAP. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, pre-aggregation, and tuning. SAP HANA and in-memory computing allow you to instantly access huge volumes of structured and unstructured data, including text data, from different sources. Starting with data modeling, this fast-paced guide shows you how to add a system to SAP HANA Studio, create a schema, packages, and delivery unit. Moving on, you'll get an understanding of real-time replication via SLT and learn how to use SAP HANA Studio to perform this. We'll also have a quick look at SAP Business Object DATA service and SAP Direct Extractor for Data Load. After that, you will learn to create HANA artifacts - Analytical Privileges and Calculation View. At the end of the book, we will explore the SMART DATA access option and AFL library, and finally deliver pre-packaged functionality that can be used to build information models faster and easier. Style and approach This is an easy-to-follow, step-by-step, rapid guide to help you learn analytics in SAP HANA through ample hands-on exercises and use case scenarios.
    Note: Includes index. - Description based on online resource; title from cover page (Safari, viewed December 9, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 70
    ISBN: 9781783988549 , 1783988541
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Edition: Second edition.
    Series Statement: Community experience distilled
    Keywords: PostgreSQL ; Database management ; SQL (Computer program language) ; Electronic books ; Electronic books ; local
    Abstract: Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast In Detail PostgreSQL offers a comprehensive set of replication - related features. Unleashing the power of PostgreSQL provides you with countless opportunities and a competitive advantage over other database systems. This book will guide you through the most important concepts of PostgreSQL replication. It contains all the information you need to design and operate replicated setups. Beginning by giving you an understanding of replication concepts, the PostgreSQL transaction log, and Point-in-time Recovery, we gradually move on to setting up asynchronous and synchronous replication. Next up, you will learn to monitor a PostgreSQL cluster setup, deal with monitoring tools, and then move on to understanding Linux High Availability. Further, we explore widely-used tools such as Slony, SkyTools, Postgres-XC, and walbouncer, and set up PL/Proxy. Finally, you'll get acquainted with the new technology of BDR, which allows bidirectional replication in PostgreSQL. What You Will Learn Use Point-in-time Recovery to perform data recovery as well as replication Set up synchronous as well as asynchronous streaming replication Get familiarized with the transaction log, the core component of most replication setups and its purpose Improve speed and reliability with an understanding of pgpool and PgBouncer Increase your data security and geographically distribute data Make your systems more available and secure with Linux High Availability Scale out with PL/Proxy and Postgres-XC Detect, investigate, and solve replication-related problems
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed August 13, 2015)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 71
    ISBN: 9781784390624 , 1784390623
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Series Statement: Community experience distilled
    Keywords: Web site development ; Management information systems ; Information resources management ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Learn a powerful way to successfully implement unique integration solutions with Alfresco In Detail Alfresco web scripts is a key feature of the Alfresco enterprise content management system that enables other applications to interact with the Alfresco repository in a secure way. This book will help you understand everything you need to know about web scripts so that you can practically apply them to your own projects. You will begin by learning the basics of Alfresco web scripts, giving you a clear idea about how web scripts are a useful solution to your business problems. Moving on, you will delve into the powerful web script framework and then get a complete walk-through of all the components required to build web scripts. Later in this book, you will discover various ways to execute web scripts. You will learn about useful JavaScript APIs in Alfresco that you can leverage when building business solutions with web scripts. Moving further, you will learn about deployment, debugging, and troubleshooting web scripts, and find instructions to develop web scripts in a Maven project that will help you learn how to build web scripts in a real development environment. What You Will Learn Implement web scripts in Alfresco and learn about their fundamentals Understand the end-to-end execution flow with core details and get an insight into the robust web script framework Gain extensive knowledge about the building components of web scripts Explore different options to invoke Alfresco web scripts Leverage the power of useful JavaScript APIs in web script implementation Understand various deployment options, debugging techniques, and troubleshooting pointers Learn about extension capabilities to extend the web script framework
    Note: Includes index. - Description based on online resource; title from cover page (Safari, viewed November 22, 2014)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 72
    ISBN: 9781783985951 , 178398595X
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Series Statement: Community experience distilled
    Keywords: Electronic data processing ; Distributed processing ; Distributed databases ; Handbooks, manuals, etc ; Database management ; Open source software ; Electronic books ; Electronic books ; local
    Abstract: Learn the fundamentals of HBase administration and development with the help of real-time scenarios In Detail Apache HBase is a nonrelational NoSQL database management system that runs on top of HDFS. It is an open source, distributed, versioned, column-oriented store. It facilitates the tech industry with random, real-time read/write access to your Big Data with the benefit of linear scalability on the fly. This book will take you through a series of core tasks in HBase. The introductory chapter will give you all the information you need about the HBase ecosystem. Furthermore, you'll learn how to configure, create, verify, and test clusters. The book also explores different parameters of Hadoop and HBase that need to be considered for optimization and a trouble-free operation of the cluster. It will focus more on HBase's data model, storage, and structure layout. You will also get to know the different options that can be used to speed up the operation and functioning of HBase. The book will also teach the users basic- and advance-level coding in Java for HBase. By the end of the book, you will have learned how to use HBase with large data sets and integrate them with Hadoop. What You Will Learn Understand the fundamentals of HBase Understand the prerequisites necessary to get started with HBase Install and configure a new HBase cluster Optimize an HBase cluster using different Hadoop and HBase parameters Make clusters more reliable using different troubleshooting and maintenance techniques Get to grips with the HBase data model and its operations Get to know the benefits of using Hadoop tools/JARs for HBase
    Note: Includes index. - Description based on online resource; title from cover (Safari, viewed December 18. 2014)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...