Posts Tagged ‘ELT’
Yellowbrick 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 MoreMove to Teradata
Teradata is taking all of the awards for Data Warehouse Analytics. You should consider consolidating users on Teradata and use the platform for your major analytic jet engine. With a few clicks of the mouse, my Nexus and NexusCore Server can make the migration to Teradata easy.
Read MoreAm I Crazy? ETL for Everyone!
Moving data between systems is called ETL, which stands for Extract, Transform, and Load. The ETL team almost always does the moving of data because load scripts are easier to learn than Latin, transformation is more difficult than brain surgery, and computing resources are about as easy to manage as cats.
Read More