Friday, September 25, 2020

SQL or NoSQL or NewSQL!

 "In the relational model, there is an built-in and foolproof method of ensuring and enforcing business logic and rules at the database layer, for instance that a withdrawal is charged to the correct bank account, through primary keys and foreign keys.  In key-value stores, this responsibility falls squarely on the application logic and many people are very uncomfortable leaving this crucial responsibility just to the application.  This is one reason why relational databases will continued to be used."

"So in summary, RDBMS’s suffer from no horizontal scaling for high transaction loads (millions of read-writes), while NoSQL databases solve high transaction loads but at the cost of data integrity and joins."

"NewSQL is a class of modern RDBMS’s that seek to provide the same scalable performance of NoSQL systems for OLTP read-write workloads while still maintaining the ACID guarantees of a traditional relational database system.  The disadvantages is they are not for OLAP-style queries, and they are inappropriate for databases over a few terabytes.  Examples include VoltDB, NuoDB, MemSQL, SAP HANA, Splice Machine, Clustrix, and Altibase."

Relational databases vs Non-relational databases



















Tuesday, February 4, 2020

#CMGIMPACT2020 conference #livestreaming - Join and enjoy!

I know a lot of the CMG (and mine) friends want to attend our hashtag#CMGIMPACT2020 conference, but for a understandable reason could not go. But what about subscribing for a live streaming https://lnkd.in/eXMR4BB . Join and enjoy!

Do not forget to see my presentation! (http://www.trub.in/2019/12/cmgnews-my-new-presentation-cloud.html)


https://cmgimpact.com/livestream/

Tuesday, January 28, 2020

What is CMG - my 2¢

What is CMG?
Membership based professional association, covering the following professions/disciplines for multiplatform (MF, CLoud, Network, DBs, Mobil) IT business :
- Capacity Management service including System Performance Engineering, Capacity Planning and Cloud rightsizing/optimization
- NFR engineering and software/hardware testing.
- Availability Management including high and continuous availability systems engineering.
- IT systems Observability and Monitoring
- Information Security Management system including intruder detection.
- Site Reliability Engineering 
- AI and Big data  in relation to above-mentioned  professions/discipline

The main organization's goal is to share knowledge  by organizing seminars, meetups, virtual and real conferences, webinars, blogging, newsletters, training, and websites with access to an extensive and valuable knowledge base. 

What do I want it to be? 
Basically the same but focusing on our specific niche  (above-mentioned  professions/discipline) and to be vendor agnostics which should help us to compete. Also the board and officers should be a real expert in above-mentioned  professions/discipline

What topics should we talk about?
Above-mentioned  professions/discipline  

Where do I see value in CMG?
Sharing among members the vendor agnostic user experience and expertice.

What are tangible benefits CMG should offer?
Proved and trusted Subject Matter Expertise and effective high quality knowledge transfer (sharing) among members and members and officers/knowledge base. Plus continues industry trends updates by partnership with key vendors in the area of our expertise. Good and organized and cheap events.

Where are our growth opportunities?
We should be respectful and trustworthy experts in the subject area as well as good event organizers, so members would interact with us and through us often and new members would consider joining as we should be a good source of professional development and networking.