Text Size 100%: － ＋ Traditional XML storage in Oracle Database In 2010, Oracle Database introduced native XML storage capabilities to optimize the storage and usage of XML documents with Oracle Database 11g (11.2.0.2). Oracle's approach for native XMLType storage then was purely document-centric, called Compact Schema-Aware XML (CSX) or…
Introduction # Recently, when helping a user who wanted to compute centroids from vectors held in ClickHouse, we realized that the same solution could be used to implement K-Means clustering. They wanted to solve this at scale across potentially billions of data points while ensuring memory could be tightly managed.…
Text Size 100%: － ＋ ORA-04030: out of process memory when trying to allocate bytes, occurs when an Oracle process runs out of operating system memory. The error is caused by either: Exhausting total machine physical memory Exhausting designated space in the Program Global Area (PGA). Follow these step-by-step instructions…
tl;dr This week, we're releasing a major update to ClickHouse Cloud. Over the last nine months, we've worked hard to rethink, redesign, and reimplement the Cloud user experience, and we're excited to share these changes with you today. The ClickHouse SQL console is integral to the way many Cloud users…
Text Size 100%: － ＋ One of the common arguments I hear about avoiding XA distributed transactions is due to their complexity. In this series of blog posts I’ll examine that claim by looking at three versions of the same application. The first version of the application ignores data consistency…
This post demonstrates how data in ClickHouse can be used to train models through a feature store. As part of this, we also show how the common tasks that data scientists and engineers need to perform when exploring a dataset and preparing features can be achieved in seconds with ClickHouse…
Text Size 100%: － ＋ As some of you might know, an exciting part of my job is working with the Oracle Database API for MongoDB (short MongoDB API), a part of Oracle's converged database that brings MongoDB's document store API to the world's best database (personal opinion, no need…
At the beginning are the triples An introduction to Dgraph core concepts through hands-on. The hands-on examples are a way to better understand each concept by experiencing directly with Dgraph. They are not a substitute for product documentation. Prerequisite Get a Dgraph instance up and running You can start in…
Table of Contents # Introduction Choosing ClickHouse The scale of the problem ClickHouse Cloud infrastructure Building on top of ClickHouse Cloud Understanding your users Some early design decisions Choosing OpenTelemetry (OTel) Architectural overview Ingest processing Schema Enhancing Grafana Cross-region querying Performance and cost Looking forward Conclusion Introduction # We believe…
Text Size 100%: － ＋ If you're in North America, it's safe to say you're aware that we're having a solar eclipse next month. Maybe you're even lucky enough to live close enough to the path of totality to view it. But how to do you decide where to go?…