Blog

In today’s data-driven world, optimizing performance and reducing storage costs are top priorities for businesses using Teradata. One of the most effective ways to achieve both is by implementing Multi-Value Compression (MVC), a feature that can significantly reduce storage requirements without impacting performance. However, manually configuring MVC across an entire Teradata system can be a…

Data shouldn’t be locked in silos. What if you could instantly query, migrate, and integrate across all major database platforms? Meet Nexus, the enterprise-grade data powerhouse that large financial, manufacturing, semiconductors, and insurance companies trust to unify their data strategy. Federated Queries Across 25+ Databases – Query any system via ODBC in real-time. Auto-Generate SQL…

I was contacted by the oldest and most renowned data vendor about a potential partnership between my Nexus software and their AI capabilities. In a one-hour demo, I showcased how Nexus queries all systems, writes SQL automatically, converts and migrates thousands of tables across platforms, and performs federated queries between any combination of databases—all in…

Federated Querying: Comparing Presto and Nexus Federated queries are essential for organizations needing to analyze data across disparate systems without centralizing it into a single repository. Both Presto and Nexus offer solutions for executing federated queries, but their approaches, architectures, and capabilities differ significantly. While Presto provides a powerful distributed query engine, Nexus offers unparalleled…

The Rosetta Stone, a 2,200-year-old slab of black granite, unlocked the secrets of ancient Egypt, bridging a 1,400-year gap in understanding their written language. Discovered in 1799, it bears the same decree inscribed in three scripts: Greek, Demotic, and Egyptian hieroglyphs. This trifecta became the key for scholars, led by Jean-François Champollion, to decode hieroglyphs,…

It’s a bird, it’s a plane, it’s Superman. Wait, it’s a query tool, it’s a Toad, it’s Informatica, it’s Tableau, it’s MicroStrategy, it’s a Rosetta Stone, it’s a data warehouse. Oh my goodness, it’s Nexus. Your company has 10,000 laptops and PCs with a CPU and memory capable of processing data like a data warehouse.…

Database vendors have enormous power because once you choose them, they own you. I love databases, but my first goal was to build the world’s greatest query tool and put the power into the hands of the users. I chose the name Nexus because it is the intersection where all databases meet. My second goal…

Every company stores data on dozens to hundreds of databases and purchases different query tools, costing millions annually. Getting users to give up their favorite query tool used to be impossible, but anyone who has tried Nexus Version 18.5 (available for a free trial) soon finds it the only query tool everyone loves using. While…

Introduction to Federated Queries Almost every developer or database user has joined two or more tables on a database using SQL. A federated query joins two or more tables or views on separate database platforms and runs as a single query. The layman’s term is a cross-system join, but experts refer to these as federated…

I can teach you analytics! Postgres is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! Greenplum is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! Netezza is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! Vertica is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! Yellowbrick is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! IBM DB2 is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…

I can teach you analytics! Oracle is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! Teradata is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…

I can teach you analytics! Amazon Redshift is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…

I can teach you analytics! Google BigQuery is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…

I can teach you analytics! SQL Server is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…