Oracle vs. MySQL vs. SQL Server vs. PostGRESQL

Oracle vs. MySQL vs. SQL Server vs. PostGRESQL: 

Which DBMS Is The Best Choice For You?

There’s always been some contention over which SQL database tool is superior. Every administrator has their preferences, and every programmer has their own unique way of dealing with code. For that reason, if you ask five different sysadmins which platform they prefer, you’re like to receive five different answers.

Let’s see if we can’t help you come to your own answer.

Today, we’re going to look at some of the major database management systems currently available on the web in regards to their pros and cons. Once we’ve worked that part out, we’ll offer up a few recommendations as to which projects each one is best-suited for. Let’s dive right in.

Oracle

• Closed-source; free version has very limited feature set 
• Temporary tables persist across sessions, and must be removed by the user
• Support for four different character/string types: CHAR, VARCHAR2, NCHAR, NVARCHAR2
• Offers both table and row locking
• Extensive and flexible storage customization with commands like tablespace, synonym, and packages
• Extensive backup mechanisms
• Designed to manage tables and databases on a large-scale basis

MySQL

• Open-source
• Compatible with a wide range of engines and interfaces; one of the most mature databases on the market
• Lightweight
• One of the most popular database tools; easy to find support online
• Temporary tables are only visible within the current active session, and are removed automatically afterwards.
• Lacks ACID compliance
• Can partition tables via LIST, HASH, RANGE, and SET
• Support for two different character/string types: CHAR and VARCHAR
• Offers only table locking
• Lacks options for table views
• Limited storage customization
• Admin tools are incredibly powerful
• Two backup mechanisms: mysqlhotcopy and mysqldump
• Experiences significant performance degradation at high scale.

BIT marvels Daily technology digest 25-05-2016 Part-1

I have been very consistent in my bullishness on India: Michael Dell

For the man who is pulling off the largest technology merger in history, Michael Dell appears incredibly calm. Even as tech pundits continue to debate about the merits of the $59-billion marriage between Dell and EMC, which is expected to be consummated by October, Dell CEO Michael Dell flew down to Bengaluru for a day-long visit to review India operations — which is now 20-years old. In an exclusive interview with ET's TV Mahalingam, Dell spoke about engineering the biggest acquisition in tech history, Dell 's future bets and why he continues to remain bullish about India. Edited excerpts:  So, you are engineering the largest acquisition in tech history. Was it a tough decision to green flag? There is a fair bit of history here. Dell and EMC had a partnership for almost a decade (Dell-EMC) and that became a $2-billion business . Then around the fall of 2014, I contacted Joe Tucci (EMC CEO) — we have had this discussion in earlier years if we should combine the two companies. I told him we should look at this again. We had extensive meetings, discussions, due diligence. Over a year later, the transaction was announced. If you look at what we are doing, these companies are highly complementary.  Dell’s new security solutions guard thin clients and virtual desktops against malware Dell is the servers, EMC is the storage and VMware is the virtualization. So, who is your competition now? If you look at what we do now, we are competing with one part of HP or another part of some little company over here or another company over there. I think it is going to be very difficult to be a company in silos. I think the game has changed. If you look at the PC market, it's changing...virtual PCs, physical PCs...we are in our 14th quarter in a row of consecutive market share gain. While we gained in the biggest market in the world — 2.5 points of share, HP lost minus 2.4 of share. We took share away from HP. We also have a better capital structure and we are private company. That allows us to think beyond the next 90 days...we can think about 3 years, 5 years, a lifetime. You have led Dell through several transformations from the PC era to going private. What's next for Dell ? Our industry is change or die. The role of IT is fundamentally changing. For last several decades, it has been about taking existing businesses and making them more efficient with IT. What's happening now is that IT is evolving so quickly that it's enabling all kinds of new businesses and new business models. All this is making companies jump up and embrace digital transformation.

BIT marvels Daily technology digest 18-05-2016 Part-3

BIT marvels Daily technology digest 18-05-2016 Part-3

CEO Bezos: Amazon to open more real-world stores

Amazon's foray into brick-and-mortar outlets began last year in Seattle and continued this year with a package pick-up center at the University of Pennsylvania. That won't be the end of the effort, Chief Executive Jeff Bezos said Tuesday.  "We're definitely going to open additional stores, how many we

BIT Marvels daily technology digest 18-05-2016 part-2

BIT Marvels daily technology digest 18-05-2016 Part-2

Nokia announces return to phone business with Android phones, tablets

Call it the return of the prodigal son. Or the new great hope. Or something like that. But in a big announcement today Nokia, the company which has not been sold to Microsoft, has said that it is returning to the phone business with Android phones and tablets.  To reenter the market, Nokia is working with a Finland-based company HMD that will make and sell Nokia-branded phones based

BIT Marvels Daily technology digest-18-05-2016

BIT Marvels Daily technology digest-18-05-2016

Ten challenges Apple CEO Tim Cook will have to overcome in India

Tim Cook is finally focusing the energies of Apple in India. Tim Cook is in India, and in the process of visiting various officials. Announcements related to Apple stores, and an incubator program to encourage startups plugged in to the iOS ecosystem are expected. While there are signs that India has been taking to Apple, there are some major challenges that the company has to work around.  10.