June 2020 Summaries

Couchbase Cloud is a new Database-as-a-Service (DBaaS) product available on Amazon Web Services (AWS), designed to meet the growing demand for alternatives to legacy systems and reduce IT operating costs by enabling rapid application development. This fully managed, automated, and secure DBaaS is built on Couchbase Server, allowing customers to maintain control over costs and clusters without compromising data security. It supports multicloud deployments, end-to-end data security, and leverages open-source technologies like Kubernetes for easy deployment and management. Couchbase Cloud's architecture lets the data plane run in the customer's public cloud environment, offering economic benefits by allowing customers to procure their IaaS directly from cloud providers and manage data security on their terms. The system includes a unified control plane for monitoring and managing clusters, providing self-service database access for developers with various SDKs, and featuring a SQL-based query language for JSON called N1QL. Offering flexible pricing models, including hourly consumption and prepaid credits, Couchbase Cloud aims to provide a cost-effective and high-performance solution for enterprises seeking to optimize their cloud data strategies.

Couchbase has introduced two new instructor-led training courses: the Couchbase Advanced Operations Workshop (CS400) and the Couchbase Advanced N1QL Workshop (CD410). The CS400 course is designed for experienced Couchbase administrators who have attended the basic administration course, while the CD410 course is geared towards experienced developers and architects who have a solid understanding of Couchbase data modeling, querying, and tuning. Both courses are hands-on, 4-day workshops that focus on advanced topics such as cluster sizing, server features, tooling usage, log analysis, and N1QL query optimization. The courses are designed to be advanced and come after preliminary classes, with public remote training sessions available later this year in both the US and EMEA.

At a recent Red Hat Users Group meeting in North Texas, a presentation was given on deploying Couchbase NoSQL using the Couchbase Autonomous Operator on the OpenShift platform. The session, hosted by the Red Hat Dallas team, included a live demonstration showcasing the rapid deployment of a fully configured Couchbase cluster with various services such as data, query, index, search, eventing, and analytics, all utilizing the Operator Lifecycle Manager. The demonstration highlighted the ease and speed of provisioning Couchbase on OpenShift, and additional resources are available for those interested in further exploring Couchbase's capabilities on this platform, including a blog by Evan Pease on why Couchbase is an optimal NoSQL choice for Red Hat OpenShift.

Couchbase has introduced a new free online training course aimed at helping enterprises onboard to its Support services, designed by experienced Technical Support engineers to enhance the customer support experience. This course, which consists of several 5-minute modules and takes 30 minutes to complete, covers essential topics such as registering and raising a ticket, providing necessary information for effective case handling, using First Time Data Capture tools, and offering guidance for critical issues. Couchbase emphasizes its commitment to tackling complex problems and supporting mission-critical applications, aiming for quick and efficient resolutions through streamlined support interactions. The course is recommended for those responsible for administering and maintaining Couchbase software, reflecting the company's ongoing dedication to serving its clients effectively and efficiently.

The text outlines a comparison between Couchbase and MongoDB in terms of their capabilities for handling analytics workloads, emphasizing how each system has evolved to address complex data processing needs. Couchbase, originally a NoSQL system designed for extreme scalability, has developed distinct engines for query and analytics, both utilizing the N1QL language. These engines cater to operational and analytical workloads, respectively, following a multi-dimensional architecture that includes massively parallel processing (MPP) strategies to manage large datasets. In contrast, MongoDB has introduced analytic nodes within its clusters that use its MongoDB Query Language (MQL) and are designed to manage both operational and analytical queries using the same query processing methods. Key differences highlighted include their approaches to indexing, query optimization, parallel processing, and support for windowed aggregate functions, with Couchbase offering more advanced features for analytics. MongoDB supports external data processing via integration with additional data sources and S3, whereas Couchbase's capabilities include analyzing data from multiple clusters and supporting external JSON, CSV, and TSV data in S3. Both systems support integration with business intelligence tools like Tableau and Knowi, but differ in their data visualization features and subquery handling.

Couchbase, an enterprise software company, recently received several prestigious awards for its innovative products and customer satisfaction. Notably, Couchbase Cloud, their fully managed DBaaS solution, won the Cloud Innovation of the Year award from Tech Ascension for its unique technology and business impact. Furthermore, Couchbase was recognized as a 2020 Top Rated NoSQL database by TrustRadius, based on positive customer feedback highlighting its speed, management ease, and reliability. Additionally, Couchbase was listed in the DBTA 100 Companies That Matter Most in Data, acknowledging its significant contributions to data management innovation. These accolades underscore Couchbase's commitment to delivering top-tier NoSQL database solutions and its role in shaping the future of data management.

I recently joined Couchbase's product team to lead Couchbase Analytics, a service that enables customers to measure near-real-time business operations, derive insights from data, and drive agile decisions. I met with customers to learn about their usage of Couchbase Analytics and identified key business pain points it addresses, including operational workloads being heavily impacted by analytical queries, the need for near-real-time data science experiments, and the inability to efficiently run complex analytical ad hoc queries. Customers use Couchbase Analytics in various ways, such as analyzing customer loyalty and promotion offers, targeting consumer offers based on buying patterns, and optimizing revenue management in healthcare organizations. By working with customers, I aim to improve our products, validate product investments, and shape product roadmaps to support their strategies and successes, ultimately driving customer satisfaction and achieving business goals. The Analytics Service differentiates itself by providing near-real-time analysis of application data without slowing down operational data or query services.

The June drop for Index Advisor service provides fixes for bugs found after the last refresh in May, making the service more reliable and efficient. The Index Advisor is a free service available to users of Couchbase Community Edition, providing index recommendations to optimize query performance and meet SLAs. The latest version includes improvements such as fixing issues with covering indexes for join operations, generating advice without creating buckets or uploading schemas/data, and returning correct index recommendations for unnest queries. However, there are still some issues with the service, including recommending incorrect indexes in certain cases and not handling duplicate index definitions properly.

The text discusses the architectural design of data systems, referencing Martin Kleppmann's book "Designing Data-Intensive Applications," which highlights strategies and trade-offs in modern data infrastructure. The author illustrates how to simplify these architectures using Couchbase, which integrates scalable caching, database, search, and event processing features, thereby eliminating unnecessary components. By incorporating Couchbase, the architecture can also support data analysis and visualization through its analytics services. The text emphasizes the importance of continuously refining and adjusting the system architecture to manage complexity and meet business objectives, while acknowledging that not all systems can be simplified to a few products due to inherent complexities. Additionally, the comments section touches on the role of deployment tools like Mesos and Kubernetes and addresses concerns like serializable transaction scopes and write skew anomalies in databases like MySQL and PostgreSQL.

This blog post explores the implementation of a FHIR Search REST API Server using Couchbase services, focusing on transforming FHIR search patterns into Couchbase N1QL queries. It provides guidance for organizations developing FHIR-compliant Electronic Health Record systems and highlights the advantages of Couchbase's NoSQL database, including distributed high availability and multi-dimensional scalability. The post discusses setting up a FHIR server using Couchbase and Synthea's synthetic FHIR data, along with detailed examples of various search functionalities such as searching by ID, name, medical identifier, phone, email, and date range. It emphasizes the benefits of using Couchbase N1QL for FHIR data querying due to its support for hierarchical and relational data structures, and the integration of Full Text Search capabilities without the need for external platforms like ElasticSearch or Solr. The blog also addresses the simplicity and efficiency of using Couchbase N1QL's array constructs and ANSI JOINs for processing complex FHIR data models.

Couchbase Mobile supports a JSON document style NoSQL data model that accommodates both standard JSON data types and binary data, such as images and PDFs, through attachments or blobs. These attachments can be synced between Couchbase Lite clients and the server using the Sync Gateway. The article explores the creation, retrieval, and update of binary data attachments in Couchbase Mobile 2.x deployments, detailing the differences in handling attachments between versions 1.x and 2.x. Developers are guided on how to manage these discrepancies, especially when dealing with the Sync Gateway's backward compatibility with the 1.x style attachments. The post also discusses the limitations on attachment size and quantity, the robustness of the sync protocol in handling failures, and best practices for managing large binary data, such as storing them externally and using references. Additionally, the article touches on current limitations with Couchbase Server SDKs for direct attachment management and hints at future improvements.