Skip to content
Coffing Data Warehousing Software

The Extinction of Hardware Dinosaurs

Tera-Tom here!

Sixty-five million years ago an asteroid roughly 10 km (6 miles) across and traveling at close to 50,000 Miles Per Hour hit Earth. It had such an impact that it created a crater that was 110 miles wide.  

This led to the extinction of roughly 3/4 of species that existed at that time, including the dinosaurs. This horrific event paved the way for a new era, where creatures called “mammals” began to rule.  The mass extinction led to the evolution of humankind, the rise of prophets, and computers.  

Sixty-five months ago, the “Amazon Cloud” hit planet Earth traveling at the speed of business and this led to the extinction 3/4 of the hardware dinosaurs! This terrific event lead to the evolution of high-quality service to men and women customers, a rise in profits, and computer cost savings!  The Amazon Cloud proves that there isn’t a silver lining in every cloud, but that there is gold in cloud computing.  

Dinosaurs couldn’t predict the asteroid, but the cloud put a crater in the industry with this much impact:

  1. According to IDC, cloud computing spending is expected to grow at better than 6x the rate of IT.
  2. According to Forbes, 74% of Tech Chief Financial Officers say cloud computing has had the largest impact on their business.
  3. According to Vormetric, 85% of major companies are keeping sensitive data in the cloud.

What are the biggest factors driving companies to the cloud? Desktop Virtualization provides access to data at any time anywhere.  Employees need to access data whether they are on-premises or if they are traveling across the globe! And many companies are adopting a multi-cloud strategy.  Who are the top cloud vendors?

  1. Amazon Web Services
  2. Microsoft Azure
  3. Google Cloud
  4. IBM

And Salesforce is dominating the SAAS (Software As A Service) space.  Another rising star is a company called Snowflake.

Don’t think of the cloud as amazing vaporware where the magic happens.  The cloud vendors provide giant warehouses of hardware servers and inexpensive disk storage.  Customers can rent the hardware servers and disk storage and choose almost any database they want.  The cloud provider manages the hardware and backs-up the data for the customer. The cloud provides to customers:

  • Enhances to disaster recovery
  • Reduction in the support burden on the IT staff

Desktop virtualization provides customers with the ability to access software on a remote desktop.  Companies don’t have to house the software inside their firewall but can utilize the software on the cloud.

Fifteen years ago I saw the asteroid coming.  I had worked with Teradata, IBM, Netezza, Greenplum, DATAllegro, and Microsoft.  I wrote over 75 books on everything from Hadoop to Amazon Redshift. I knew that the future of the computing industry was no longer going to be dominated by the T-Rex companies of old, but that customers would embrace many different vendors and platforms.  The inclusion of multiple vendors was obvious by the outrageous cost that vendors charged customers once they knew they had a monopoly on their business. It was also obvious because data was getting so large that no one customer could even begin to house it all.

The vision became clear to me.  I didn’t want to be one of these computer experts that merely gave advice.  I wanted to put my money where my mouth was and build the greatest software of its time.

The greatest software has to come in two flavors to be successful.  Both flavors are nearly impossible to master.

The first flavor has to be the software of choice for every user on the on-premises desktop and virtual desktop on the cloud.  It has to be able to allow developers to develop, business users to analyze, and the IT staff to support and manage all systems.  Software for your most valuable asset, your people, not only includes access to databases, Excel, flat files, Microsoft Access, graphs and charts for a single database, but across all databases.  Users can write the SQL if they choose, but the biggest challenge is to show tables, Excel, Access, and flat files visually and allow users to point-and-click and have the software build the SQL automatically and brilliantly.  And not for one system, but across all systems. Users need the power to join tables across all systems! Most database vendors build a tool for users to submit SQL to get an answer set from their system, but that is why it takes close to two-decades to master federated queries across all systems.  And the software absolutely must be able to join on-premises systems with multiple cloud systems.

The second flavor must be the software of choice to manage every on-premises and multiple cloud database server.  Data must be moved and joined automatically and instantly as well as scheduled. Federated queries mean data movement, which involves converting table structures and data types between systems and utilizing load utilities from each vendor to move data to each system efficiently and effectively.  

If there are any mistakes, errors, or misjudgments in conversions or speeds the impossible is no longer possible.  In layman terms, “The business user must be on the same playing field as the data scientist.”

We came up with a unique and flexible design that covers every possible scenario.  We put all technology required inside the user’s desktop and called the software, “The Nexus”.  The Nexus of New York City in “Times Square” intersects between all five Burroughs. The Nexus from CoffingDW is the intersection between all data.

We then put the same desktop Nexus software on a server, which we call The NexusCore Server.  The only difference is that the NexusCore Server can impersonate a user’s credentials and run jobs for the user as the user.  The flexibility for a user to run queries, move data, and perform cross-system joins from either the desktop or server is clever enough, but the fact that a company can scale up or down with any number of Nexus desktops and NexusCore servers makes it unique.  Here is how it works.

The Nexus on the desktop can do everything.  Users can move data between systems with a click of the mouse.  Users can still write and develop SQL by hand and see a traditional systems tree with databases, schemas, tables, views, and other objects.  Users can also choose to see their tables and views visually and drop-and-drag tables from any system together and merely click on the columns they want on their report.  The Nexus builds everything instantly to return the answer set. Users can take every answer set they receive throughout the day and join answer sets together. They can also build over 100 analytic reports directly from their answer sets.  They can pivot answer sets, and they can save or see them in Excel worksheets. They can join any table to Excel, flat files or Microsoft Access. Anyone can access any data anywhere and merely point-and-click!

Users then have the option to run everything on their PC or remote cloud desktop, but they also have the choice to run it on the NexusCore Server.  You need to be able to do both! On smaller data, you can run this from your PC or remote desktop, but on big data, you must be able to run things on the server.  Since the desktop Nexus and the NexusCore Server have the same functionality, you have linear scalability and all features capable of running on both!

Isn’t it time your organization became a software mammal?  The new release of Nexus and NexusCore Server is coming the Summer of 2019. 

If your company would like to set up a demo with Tom for a demo of NexusCore in action, please feel free to contact us!