ClickHouse vs. Elasticsearch: The Mechanics of Count Aggregations

Introduction # In another blog post, we examined the performance of ClickHouse vs. Elasticsearch on a workload commonly present in large-scale data analytics and observability use cases – count(*) aggregations over billions of table rows. We showed that ClickHouse vastly outperforms Elasticsearch for running aggregation queries over large data volumes.…

Continue ReadingClickHouse vs. Elasticsearch: The Mechanics of Count Aggregations

ClickHouse vs. Elasticsearch: The Billion-Row Matchup

Table of Contents # Introduction Count aggregations in ClickHouse and Elasticsearch Benchmark setup Benchmark queries Benchmark methodology Benchmark results Summary Storage size Aggregation performance Summary Introduction # This blog examines the performance of ClickHouse vs. Elasticsearch for workloads commonly present in large-scale data analytics and observability use cases – count(*)…

Continue ReadingClickHouse vs. Elasticsearch: The Billion-Row Matchup

Oracle Globally Distributed Database supports RAFT Replication in Oracle Database 23ai

Text Size 100%: - + Distributed databases are gaining increasing popularity and significance due to their capacity to manage large and intricate datasets, scalability, flexibility, and compatibility with contemporary application designs and architectures. As organizations embrace cloud-based solutions and microservices-based architectures, there is an anticipated surge in the demand for…

Continue ReadingOracle Globally Distributed Database supports RAFT Replication in Oracle Database 23ai

Unveiling the Power of Oracle Globally Distributed Database: Oracle Database 23ai Advancements

Text Size 100%: - + In the realm of database technology, Oracle Database 23ai marks a transformative era by ushering in a wave of advancements. Among these advancements, a standout focus lies on augmenting the capabilities of the Oracle Globally Distributed Database. As we approach this release, our attention centers…

Continue ReadingUnveiling the Power of Oracle Globally Distributed Database: Oracle Database 23ai Advancements

Introducing Oracle True Cache : In-memory, consistent, and automatically managed SQL cache (Oracle Database 23ai)

Text Size 100%: - + As our digital landscape continues to evolve, delivering real-time responses has become imperative. Latency has emerged as the new outage, and customers' expectations for speed have skyrocketed. It's crucial for organizations to adapt their application architectures to meet the surging demands of a growing user…

Continue ReadingIntroducing Oracle True Cache : In-memory, consistent, and automatically managed SQL cache (Oracle Database 23ai)

JSON Relational Duality: The Revolutionary Unification of Document, Object, and Relational Models

Text Size 100%: - + JSON Relational Duality is a landmark capability in Oracle Database 23ai (formerly Oracle Database 23c) that provides game-changing flexibility and simplicity for Oracle Database developers. This breakthrough innovation overcomes the historical challenges that developers have faced when building applications, either when using the relational model…

Continue ReadingJSON Relational Duality: The Revolutionary Unification of Document, Object, and Relational Models

New! Discover connections with SQL Property Graphs in Oracle Autonomous Database

Text Size 100%: - + Graph analysis is a powerful tool for discovering hidden connections and traversing complex relationships in your data. And now, starting with Oracle Database 23ai (formerly Oracle Database 23c), you can easily use SQL to create and analyze property graphs using your existing database tables. This…

Continue ReadingNew! Discover connections with SQL Property Graphs in Oracle Autonomous Database

Oracle Announces General Availability of AI Vector Search in Oracle Database 23ai

Text Size 100%: - +   Oracle AI Vector Search is a novel capability that allows users to search data based on the semantics or meaning of data, in addition to by the values of data, such as attribute values or keywords, as databases have traditionally supported. A vector, or…

Continue ReadingOracle Announces General Availability of AI Vector Search in Oracle Database 23ai