Designing and Operating Resilient Database Systems
If you’re an IT professional looking to broaden your knowledge of database administration, this practical book takes you through each component of site reliability and operations within the context of database engines. IT staffers with minimal database operations experience can use this knowledge as more » a foundation of the architecture and operations within a specific database.
This book uses open-source engines such as MySQL, PostgreSQL, MongoDB, and Cassandra as examples throughout. « less
For Hibernate 5
Get started with the Hibernate 5 persistence layer and gain a clear introduction to the current standard for object-relational persistence in Java. This updated edition includes the new Hibernate 5.0 framework as well as coverage of NoSQL, MongoDB, and other related technologies, ranging from applications more » to big data. Beginning Hibernate is ideal if you’re experienced in Java with databases (the traditional, or connected, approach), but new to open-source, lightweight Hibernate.
The book keeps its focus on Hibernate without wasting time on nonessential third-party tools, so you’ll be able to immediately start building transaction-based engines and applications. Experienced authors Joseph Ottinger with Dave Minter and Jeff Linwood provide more in-depth examples than any other book for Hibernate beginners. They present their material in a lively, example-based manner―not a dry, theoretical, hard-to-read fashion.
What You'll Learn
- Build enterprise Java-based transaction-type applications that access complex data with Hibernate
- Work with Hibernate 5 using a present-day build process
- Use Java 8 features with Hibernate
- Integrate into the persistence life cycleMap using Java’s annotations
- Search and query with the new version of Hibernate
- Integrate with MongoDB using NoSQL
- Keep track of versioned data with Hibernate Envers
Who This Book Is For
Experienced Java developers interested in learning how to use and apply object-relational persistence in Java and who are new to the Hibernate persistence framework. « less
Keeping It Local
One of the most useful features of today’s modern browsers is the ability to store data right on the user’s computer or mobile device. Even as more people move toward the cloud, client-side storage can still save web developers a lot of time and money, if you do it right. This hands-on guide demonstrates more » several storage APIs in action. You’ll learn how and when to use them, their plusses and minuses, and steps for implementing one or more of them in your application.
* Learn how different browsers support each client-side storage API
* Work with web (aka local) storage for simple things like lists or preferences
* Use IndexedDB to store nearly anything you want on the user’s browser
* Learn how support web apps that still use the discontinued Web SQL Database API
* Explore Lockr, Dexie, and localForage, three libraries that simplify the use of storage APIs
* Build a simple working application that makes use of several storage techniques « less
A textbook introduction to database systems theory and practice
This book provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. The book discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. New in this second edition more » is updated SQL content covering the latest release of the Oracle Database Management System along with a reorganized sequence of the topics which is more useful for teaching. Also included are revised and additional illustrations, as well as a new chapter on using relational databases to anchor large, complex management support systems. There is also added reference content in the appendixes.
The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chance at success.
The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline. These features combine to make Database Systems: A Pragmatic Approach an excellent textbook for students and reader-friendly resource on database theory for the practitioner. « less
Give students a solid foundation in database design and implementation with the practical and easy-to-understand approach in DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, 12E. Filled with diagrams, illustrations, and tables, this market-leading text provides in-depth coverage of database more » design. Students learn the key to successful database implementation is the proper design of databases to fit within a larger strategic view of the data environment. This book combines a clear, straightforward writing style with an outstanding balance of theory and practice.
Students gain the hands-on skills to make them attractive to employers. Updates include the latest coverage of cloud data services and a new chapter on Big Data Analytics and NoSQL, including related Hadoop technologies. In addition, new review questions, problem sets, and cases offer multiple opportunities for students to test their understanding and develop useful design skills. « less
A Set-Oriented Approach
Tagline: Database performance through set-based development practices
A Practical Approach to Enterprise Search
Build an enterprise search engine using Apache Solr: index and search documents; ingest data from varied sources; apply various text processing techniques; utilize different search capabilities; and customize Solr to retrieve the desired results. Apache Solr: A Practical Approach to Enterprise Searchexplains more » each essential concept-backed by practical and industry examples--to help you attain expert-level knowledge.
The book, which assumes a basic knowledge of Java, starts with an introduction to Solr, followed by steps to setting it up, indexing your first set of documents, and searching them. It then introduces you to information retrieval and its implementation in Apache Solr; this will help you understand your search problem, decide the approach to build an effective solution, and use various metrics to evaluate the results.
The book next covers the schema design and techniques to build a text analysis chain for cleansing, normalizing and enriching your documents and addressing different types of search queries. It describes various popular matching techniques which are generally applied to improve the precision and recall of searches.
You will learn the end-to-end process of data ingestion from varied sources, metadata extraction, pre-processing and transformation of content, various search components, query parsers and other advanced search capabilities.
After covering out-of-the-box features, Solr expert Dikshant Shahi dives into ways you can customize Solr for your business and its specific requirements, along with ways to plug in your own components. Most important, you will learn about implementations for Solr scoring, factors affecting the document score, and tuning the score for the application at hand. The book explains why textual scoring is not sufficient for practical ranking of documents and ways to integrate real-world factors for contributing to the document ranking.
You'll see how to influence user experience by providing suggestions and recommendations. You'll also see integration of Solr with important related technologies such as OpenNLP and Tika. Additionally, you will learn about scaling Solr using SolrCloud.
This book concludes with coverage of semantic search capabilities, which is crucial for taking the search experience to the next level. By the end of Apache Solr, you will be proficient in designing and developing your search engine. « less
Elasticsearch in Action teaches you how to build scalable search applications using Elasticsearch. You'll ramp up fast, with an informative overview and an engaging introductory example. Within the first few chapters, you'll pick up the core concepts you need to implement basic searches and more » efficient indexing. With the fundamentals well in hand, you'll go on to gain an organized view of how to optimize your design. Perfect for developers and administrators building and managing search-oriented applications.
About the Technology
Modern search seems like magic—you type a few words and the search engine appears to know what you want. With the Elasticsearch real-time search and analytics engine, you can give your users this magical experience without having to do complex low-level programming or understand advanced data science algorithms. You just install it, tweak it, and get on with your work.
About the Book
Elasticsearch in Action teaches you how to write applications that deliver professional quality search. As you read, you'll learn to add basic search features to any application, enhance search results with predictive analysis and relevancy ranking, and use saved data from prior searches to give users a custom experience. This practical book focuses on Elasticsearch's REST API via HTTP. Code snippets are written mostly in bash using cURL, so they're easily translatable to other languages.
* What is a great search application?
* Building scalable search solutions
* Using Elasticsearch with any language
* Configuration and tuning
About the Reader
For developers and administrators building and managing search-oriented applications.
About the Authors
Radu Gheorghe is a search consultant and software engineer. Matthew Lee Hinman develops highly available, cloud-based systems. Roy Russo is a specialist in predictive analytics.
Table of Contents
** PART 1 CORE ELASTICSEARCH FUNCTIONALITY **
Diving into the functionality
Indexing, updating, and deleting data
Searching your data
Analyzing your data
Searching with relevancy
Exploring your data with aggregations
Relations among documents
** PART 2 ADVANCED ELASTICSEARCH FUNCTIONALITY **
Administering your cluster « less
*** Key Features ***
* Improve user's search experience with the correct configuration
* Deliver relevant search results – fast!
* Save time and system resources by creating stable clusters
*** Book Description ***
Beginning with an overview of the way ElasticSearch stores data, you'll begin more » to extend your knowledge to tackle indexing and mapping, and learn how to configure ElasticSearch to meet your users' needs. You'll then find out how to use analysis and analyzers for greater intelligence in how you organize and pull up search results – to guarantee that every search query is met with the relevant results! You'll explore the anatomy of an ElasticSearch cluster, and learn how to set up configurations that give you optimum availability as well as scalability. Once you've learned how these elements work, you'll find real-world solutions to help you improve indexing performance, as well as tips and guidance on safety so you can back up and restore data. Once you've learned each component outlined throughout, you will be confident that you can help to deliver an improved search experience – exactly what modern users demand and expect.
*** What you will learn ***
* Learn how ElasticSearch efficiently stores data – and find out how it can reduce costs
* Control document metadata with the correct mapping strategies and by configuring indices
* Use ElasticSearch analysis and analyzers to incorporate greater intelligence and organization across your documents and data
* Find out how an ElasticSearch cluster works – and learn the best way to configure it
* Perform high-speed indexing with low system resource cost
* Improve query relevance with appropriate mapping, suggest API, and other ElasticSearch functionalities
*** About the Author ***
Huseyin Akdogan began his software adventure with the GwBasic programming language. He started learning the Visual Basic language after QuickBasic and developed many applications until 2000, after which he stepped into the world of Web with PHP. After this, he came across Java! In addition to counseling and training activities since 2005, he developed enterprise applications with JavaEE technologies. His areas of expertise are JavaServer Faces, Spring Frameworks, and big data technologies such as NoSQL and Elasticsearch. Along with these, he is also trying to specialize in other big data technologies. Huseyin also writes articles on Java and big data technologies and works as a technical reviewer of big data books. He was a reviewer of one of the bestselling books, Mastering Elasticsearch – Second Edition.
*** Table of Contents ***
1. Introduction to Efficient Indexing
2. What is an Elasticsearch Index
3. Basic Concepts of Mapping
4. Analysis and Analyzers
5. Anatomy of an Elasticsearch Cluster
6. Improving Indexing Performance
7. Snapshot and Restore
8. Improving the User Search Experience « less
A Toolkit for SQL Server Integration Services
Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting more » solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS.
SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed.
* Provides a timeless scripting toolkit for all current SSIS versions
* Gives a comprehensive explanation of scripting in SSIS
* Offers a wide array of readymade examples for everyday problems « less