Posts Tagged ‘ELT’
Nexus Sings to the Blues
I will always be grateful to HCSC, Blue Cross Blue Shield of Illinois, Texas, and New Mexico for sponsoring my company to build customized software back in 2002, which gave me the start I needed.
Read MoreSnowflake Unstructured Data – Part 3
Let me once again explain the rules. Snowflake rules when it comes to unstructured data. Tera-Tom Coffing, Teradata and Snowflake guru, will explain Snowflake unstructured data with great structure. Read the last blog of this series here.
Read MoreIs your cloud migration moving at a snail’s pace?
Don’t take months or years and spend millions to migrate to the cloud when the technology is present today to migrate in days. Signup for the webinar below and watch how easy and efficient migration can become. After the webinar, you can practice migration yourself for free. Take a test drive, migrate data, and then…
Read MoreMigration and Virtualization Details About the Nexus Server
Migration and Virtualization Details About the Nexus Server will show you why Nexus is the most advanced big data software in the world.
Read MoreWebinar – Cloud Migration
Are you migrating thousands of tables to the cloud? Do you want business users to be able to move data between any two systems? Can you imagine giving users the ability to join tables across disparate platforms?
Read MoreTeradata’s QueryGrid Vs. a Nexus Server
Teradata’s QueryGrid product is a brilliant concept that connects Teradata systems to multiple data sources for cross-system functionality. However, QueryGrid does not compare with CoffingDW’s high-speed Nexus Server. Teradata is a proprietary database, but Nexus combines all database platforms. Teradata broke barriers within the database world by allowing users to join data across several…
Read MoreData Virtualization – Webinar Recording
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.
Read MoreData Virtualization – Electric Car of Data
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!
Read MoreSnowflake or Yellowbrick?
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.”
Read MoreMastering Dates on a Yellowbrick Data Warehouse
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.
Read MoreWebinar Today Live – 1:00 est – Yellowbrick and Nexus
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.
Read MoreYellowbrick Analytics – CUME_DIST
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.
Read MoreRosetta Stone of Compute
In July 1799, Rosetta Stone, discovered during Napoleon Bonaparte’s campaign through Egypt, became one of the British Museum’s most famous objects. But what is it, and why is it important to computing?
Read MoreYellowbrick Analytics – Lag
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.
Read MoreMigrate OFF Oracle at One Million Rows per Second
Oracle makes it much tougher to migrate off of Oracle than to migrate to Oracle. Last week we migrated a million row Oracle table to a Yellowbrick system in one second.
Read MoreYellowbrick Analytics – Lead
Since Yellowbrick takes the lead in analytics, we will learn the LEAD command.
Read MoreYellowbrick Analytics MAVG
This week we are working on the Moving Average, which is interchangeable with the word MAVG. You use a Moving Average (MAVG) to look for trends.
Read MoreNexus Server wins POC against Amazon Data Migration Services
A fortune 100 company had changed its on-premises strategy to the cloud and needed to move its on-premises systems to the AWS cloud. It wanted to migrate its Netezza, Oracle, and Teradata systems to Amazon Redshift, Snowflake, MySQL, and Postgres. At the time, they decided that their best choice was to use Amazon’s Data Migration Services (DMS). After finding that DMS was not reliable enough for this massive project, they began a Proof of Concept with the Nexus Pro desktop and Nexus Server combination.
Read MoreNexus – Big Data Product of the Decade
The two concepts in our Big Data vision is the user’s desktop and the database server. The Nexus desktop allows a user to access any data, at any time, anywhere from their desktop or laptop, no matter whether they are at the office, a coffee shop, or home. The Nexus Server sits in between the many different database platforms, both on-premises and on every cloud, and manages and controls the data movement between systems. Users use the desktop to build anything and everything, but they have the option to run it from their desktop or the Server.
Read MoreFederate, Migrate, and Query Great
The only architecture able to accomplish the ability to federate, migrate, and query great is to implement an intelligent Windows Server, which we call the Nexus Server. The Nexus Pro desktop automatically builds federated queries, can join Excel to production tables, writes the SQL for the user, and allows the user to query every database platform on the market. Still, the Nexus Server runs the jobs for the user.
Read More