The amount of data and the processing power it takes is growing exponentially so companies continue to buy more servers. Each query needs processor power and memory to bring back an answer set, but competition for these resources is fierce. A company that has 50,000 users must continue to upgrade their systems to get more processing power and memory to satisfy each user.
This race for processing power and memory utilization as well as disk I/O was partially solved by cloud computing, where companies could rent systems inexpensively and thus scale up or down. It was also a huge reason for the success of Hadoop because companies could basically purchase a cheaper version of CPU, memory, and disk. But the real gold that I could take advantage of was right under every corporation’s nose all along and they just didn’t see it.
The biggest mistake is that a company with 50,000 users have 50,000 PC’s that all have processors, memory, and disk, and these resources have no competition because they are dedicated to each individual PC’s owner. Most of these PCs barely utilize these resources. The competition for these resources on the servers are as fierce as an ocean hurricane, but the PC is where the waters are calm.
That is probably one of the greatest revelations I have ever had, so I allowed for my Nexus Chameleon to process data inside the user’s PC. I call it the ‘Garden of Analysis’, and I suspect that it will prove one day to be one of the best inventions the computer world has ever seen.
I owe my wife Leona a lot of credit here. One day she grabbed me by the shirt, pulled me close, and said, “We don’t have enough money so you need to think of something brilliant. Go take a walk and come back with a brilliant idea.” I responded, “Yes, dear.”
As I walked by the river it came to me. The Nexus can query over 22 different systems simultaneously, so how can I take advantage of that? That is when I realized that if I could re-query answer sets inside the PC with easy-to-use templates I could save companies millions of dollars. And this would work on all systems! I had my developers begin to build what I called ‘The Garden of Analysis,’ and the beautiful thing is that the more powerful PCs become the more powerful this idea.
After phase one, all Nexus users could see every answer set they received that day in their ‘Garden.’ They could choose any answer set and instantly get new reports on Aggregates, Grouping Sets, Rank, Dense Rank, Percentage Ranks, Cumulative Sums, Moving Sums, Moving Differences, Moving Averages, and TOP commands. I knew we had something special in phase one.
In phase two, all Nexus users could join answer sets together and sort answer sets any way they wanted. They could also instantly see graphs and charts and even dynamic drag-and-drop charts instantly. This is where I knew that I could change the industry forever.
In phase three, all Nexus users could drop-and-drag tables inside the Nexus Super Join Builder from different systems, define the join columns one time and even decide on which system they wanted to process the joins, but the real brilliance here was that Nexus could then perform cross-system joins by automatically querying each table separately and then behind the scenes join the tables inside the PC!
In our current phase four, our goal is to be able to process any SQL by merely gathering the base table information from the servers and then processing the query inside the user’s PC. This gives a company with 50,000 users an additional 50,000 processors and memory which makes the processing power magnitudes of order more efficient than their current concept of processing everything on the data warehouse! The PC is the most underutilized resource in every company! This is like throwing enormous amounts of money away!
Let me give you a demo or please feel free to try the Nexus out yourself by downloading from our website. Try a five-table join from five different systems and have it all process inside your PC. You will then understand the biggest mistake in big data. And to think that your PC was right under your nose from the beginning! Maybe that is why they call it a Personal Computer!