Blog – Page 16 – Software connecting all databases

Coffing Data Warehousing - Federated Query and ETL Software, Training, and Books

Virtualization allows users with no technical expertise to join data across all on-premises and cloud databases. Users can also move data from any two systems and ETL teams can migrate thousands of tables. Having a database like Yellowbrick, where billion-row tables can return an answer set in subsecond times, encryption software from Soterosoft to guarantee the security of sensitive data, and the Nexus Server to convert and migrate between systems is the perfect package.

Will we ever see a world where there are no longer gasoline-fueled cars on the road? Of course! Why spend money on gas and pollute the planet when you can save mother earth and spend less? Ironically, gasoline as energy will become extinct, just like the dinosaurs that produced it. Will we ever see a world where users won’t care which database system their data came from, but instead query as quickly as doing a browser search over the internet? Of course! Why spend time and money moving data to a single platform to have a single version of the truth when the truth can reside across many data sources? Ironically, users with no technical background can now join data across platforms thousands of times faster than today’s best data scientists. Virtualization is the ability to join data no matter where it resides without any technical expertise, and it is as inevitable in data as electricity is to cars!

Data virtualization allows users to move or join data across database platforms with no technical experience. Why spend millions moving data when your users can join data across platforms? Data virtualization is the best way to see your data in action, and thus, it has become an important tool for various business lines to get the insights their teams need. Join us on Thursday, January 21st, at 10:00 PST (1:00 EST) for a 20-minute webinar to hear from Yellowbrick, along with two solution partners, Nexus and Soterosoft, to learn how to build a virtualization roadmap.

I have never seen analytic queries perform faster than on a Yellowbrick Data Warehouse. Today, I will begin a series on how to tune a Yellowbrick system. Today, I will start with one of the most critical fundamentals for tuning any parallel processing system, including Yellowbrick.

Before you watch this video take note of where you are because this is a day to remember forever, the most significant change since the cloud is at the desktop and server level connecting all systems. The only way forward is to make all systems one. Last Thursday, the hybrid-cloud took a giant leap forward by combining the database that is 100X faster than legacy systems with the server that allows the desktops to come alive.

The question of the day should be Yellowbrick or Snowflake. As the great playwright William Shakespeare once penned, “To be or not to be, that is the question?” If Shakespeare were alive today, the real question would be, “To be or not to be competitive.”

I can teach you, Yellowbrick! I have never seen analytic queries perform faster than on a Yellowbrick Data Warehouse. Today we are going to learn how to use dates. I will teach you date fundamentals and show you some clever tricks that will help you master dates.

Today you will witness moving and joining data across every platform in your enterprise faster than magic. The Nexus Desktop with a Nexus Server puts the business user on the same playing field as the data scientist. Combine Nexus with Yellowbrick and you get the greatest hybrid-cloud strategy on today’s market. Watch a billion-row table query in one second. Watch joins across all platforms, and watch how easy everyone from the business user to the ETL teams migrate with a button click.

Have you ever seen a query on a billion row table come back in one second? Have you ever seen data migration for thousands of tables set up in 30-seconds? How exciting will it be to join tables from 10 systems with the press of a button? Come see what happens when you put the best desktop and server software next to a Yellowbrick Data Warehouse!

I have never seen analytics run faster than on a Yellowbrick Data Warehouse. Today we learn about Last_Value, which helps with trending.

While Yellowbrick Data Warehouse offers the #1 Price/Performance in the industry, Coffing Data Warehousing’s Nexus products make it quick and easy to move millions of rows out of Teradata, Oracle, SQL Server, DB2, Snowflake, or Redshift, and join and query multiple tables across different systems at blistering speeds. Join us on Thursday, November 12 where our…

I can teach you Yellowbrick analytics! I have never seen analytics perform faster than on Yellowbrick. Today we are going to learn about First_Value. This analytic seems too simple at first, but I will show you how to use First_Value to look for trends. First_Value will display the first value of a specific column residing…

I can teach you Yellowbrick analytics! I have never seen a database perform analytics faster than Yellowbrick. Yellowbrick can load billions of rows and still perform thousands of queries simultaneously. The analytic we will learn about today is CUME_DIST.

I can teach you Yellowbrick analytics! I have never seen a database perform analytics faster than Yellowbrick. Today you are going to smile when you learn about NTile. NTILE is an analytic function. It divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each…

I can teach you Yellowbrick analytics! I have never seen a database do analytics faster than Yellowbrick. Last week we taught you Lead, and this week we are teaching you Lag.

Snowflake has the most extensive and expensive software IPO in history, and this skyrocketed further for an evaluation of 70 billion dollars. What is crazy is that Snowflake is losing money year after year. Yes, they have yet to have a single quarter of profitability. This article will talk about the eight things Snowflake understands…

Since Yellowbrick takes the lead in analytics, we will learn the LEAD command.