NO.1 SQL Server, My SQL, Oracle and Hadoop, which is the future trend? What’s the difference?

Answer: SQL Server, Mysql and Oracle are all established database products. In terms of products themselves, these three database products are all successful. These three products have clear market positioning :Sql Server focuses on serving The Windows service platform and provides a large number of database services for small and medium-sized applications. It has the same reputation as Windows products, with simple operation, good interface interaction and good performance. Of course, you need to pay to use Sql Server, and the price is reasonable. Affordable for small and medium enterprises, it is a standard database for the.NET platform. Given Microsoft’s strong appeal and position in the software platform space, SQL Server must be an integral part of its future map. Mysql is the leader of open source database, with a large number of users, remarkable single performance and strong cluster performance. In the early years, Taobao adopted 2000 mysql database server clusters to serve merchants, which can be said to have experienced the test of the market. Mysql has been slow to update until after version 5.0, but this has not affected its widespread use. PHP +mysql is a classic combination that is widely used in web development and still is today! With the popularity of Java development and a large number of applications, mysql has also been further developed, almost all Java programmers have deployed Java +mysql solutions, because mysql and Java currently belong to the same company (Oracle), natural compatibility is no problem. Based on mysql’s huge user base and good reputation of programmers, mysql will definitely occupy a considerable market share in the future. Another thing that can’t be ignored is that mysql is open source software, and its almost zero cost of use also makes it have strong competitiveness! Oracle can be said to be the leader in the field of database, robust and comprehensive performance, stable service, has been the best choice for all rich! From version I to G to C, Oracle has been the leader in commercial databases. It’s safe to say that if your budget is adequate, no one will turn down Oracle, which is a luxury in the eyes of programmers. But expensive ones are not necessarily the best choice, and there is no need to use Oracle if the data volume is small. In addition, Oracle has now acquired mysql and Java, and completed the high and low matching, it can be predicted that Oracle will remain the leading player in the commercial database field for a long time to come. Finally, let’s talk about Hadoop. With the rapid popularization of big data, solutions represented by Hadoop have also been widely applied. Data service providers represented by Amazon in the industry have seriously threatened Oracle’s market position. I think the recent attacks on Amazon by Larry Ellison, the boss of Oracle, are telling, but can Amazon completely replace Oracle? Not in the short term, at least, as Ellison put it: Amazon is spending a lot of money buying Oracle’s services when everyone else is coming to Amazon. Hadoop is known for its fast processing of huge amounts of data in seconds, which excites programmers who are used to waiting. However, its accuracy and mathematical relationships are far less rigorous than traditional databases. It can be said that it sacrifices accuracy for speed. However, there is no denying that a number of data processing methods represented by Hadoop, including Spark, will definitely see great development in the future, because this is an era of big data.

NO.2 What are the advantages of a Linux server?

Answer: I think the short answer is the following. 1. After testing, compared with Windows IOComplete, Epoll of Linux is slightly worse in performance, but only in socket set function, Linux has a little more function. Everybody shares the same score. 2. In addition, there are many people who can use Windows. Most of the novices who receive network protection fees in China attack servers with Windows tools, and most of them know how to attack Windows servers, which makes Windows servers look less secure (there are many people who attack), while Linux is relatively ignored. Relatively few have attacked. 3 do server distribution, the rented server is the cluster. If it is rented, the price is also more expensive Windows server. If you buy your own server installation system, you will waste more money to buy legitimate Windows. Or you’ll be sued by Microsoft. For cost reasons, Linux still has the edge. 4. One of the bullshit issues is that Linux is easy to maintain. Since we do the server, we can remove the INTERFACE of XWindows and so on, so that the server can bear the maximum load. This greatly increased the operation difficulty of remote login after being attacked by hackers, after all, there are a lot of fake hackers are really no technology, just do not know where to get some tools, on the disaster ah… Also, installing Linux is faster than installing Windows because the system is smaller. 5. One last thing I hate about Linux, there are so many versions… Different versions support different features… Very annoying, because Linux is open source, and it is being developed and maintained by various civic and “official” organizations. Unlike Windows, which is owned by Microsoft alone, Windows has a very uniform standard of functionality, whereas Linux is very diverse and difficult to use, so it is difficult to break down. So I feel that there are a lot of Windows viruses, but Linux, really can not say a few we are very familiar with… 1. In terms of operating system type, Linux originated from Unix is a time-sharing operating system that supports multi-user and multi-task, while Windows is essentially a single-user preemptive multi-task operating system. 4. Linux users do not affect each other, which makes It difficult for Windows to realize. 5. The preemption of Windows is different from that of Linux. There are a lot of excellent resources under Linux. Stability is guaranteed, as long as you don’t mess around with Linux. Security, this is a matter of operation and maintenance, Windows security is known to all software refers to the service software, mainly thanks to the developer support, Linux tools and services, although some of the two systems support, Linux is much more than Windows. All kinds of new technologies are also used on Linux without Windows, such as the current hottest ‘container’. Finally, Linux features such as freedom and knowledge sharing have attracted countless fans and created countless classic software and tools. Linux is open source like Android. Why are there so few PCS running Linux?

Answer a; It is well known that Linux has many distributions, and most of them are run by enterprise servers, such as Red Hat, CentOS, and other Linux distributions. When it comes to individual users, it’s mostly limited to a few distributions, such as the familiar Ubuntu. So let’s think about what features PC users need. In fact, in the network so developed today, a lot of work can be completed with the browser, and Linux graphical interface after so many years of development, should be able to meet the needs of the general user, but, for the user has been set in mind, this is still far from enough. You can’t have an average user, skip the graphical interface, use the command line to control the computer, it’s too expensive for the average user. In the end, the victory of Windows on the PC was not a victory of the system, but a victory of the GRAPHICAL interface GUI. Answer two: First of all, to make clear the concept. Linux is essentially a single kernel and only source code, thanks to Linus, and the distributions we use are self-compiled by various companies and organizations. Android, on the other hand, is a complete operating system with a Linux kernel and various drivers, Android runtime, Java virtual machine developed by Google, and UI. For the user, the UI is almost all they feel, which is the desktop. Steve Jobs, the greatest product manager ever, did this best, but Apple didn’t build their own kernel, they adapted it from Unix. Why aren’t Distributions of Linux as popular? Because there’s no big company behind it. The reason why the world is growing so fast is not by non-profit organizations, but by corporations looking to make money. Behind Windows is the mighty Microsoft, and behind Android is the mighty Google, not to mention Apple. But what about the major Linux distributions? Red Hat is successful, but it’s nowhere near as big as Microsoft, and they can’t come up with a product that can compete with Google and Microsoft, even though Red Hat is good. Ubuntu is based on Debian and there is no big company behind it. By the way, Windows should be that expensive. Because at a time when everyone was building operating systems using Unix or Linux kernels, Microsoft had to build their own from scratch. You think Jobs is great, I don’t think Gates is the greatest, you know, the world started from scratch with only Unix and Windows, the great Linus borrowed Unix. Answer three: the reason is very simple, because Windows has piracy. Microsoft was smart enough not to block piracy but to do nothing about it in order to gain market share. It turned out that Microsoft was right. Once users got used to the system, it was hard to switch. If you think about it, if Windows had not been pirated, Linux would have been widely available on PCS a decade or two ago, and applications and user experiences would have evolved accordingly. Answer 4: The main reason is that these Linux do not have a unified standard, a set of standards for developers. We can see that in the world, there are various Linux systems (according to incomplete statistics, there are about 300 Linux systems), and each Linux system has its own standard specification (from the bottom UI framework to the bottom development interface), which has been fighting for itself since the birth of Linux. As a result, the development and maintenance costs of software developers are extremely expensive. They not only need to maintain the problems between the current Linux system versions, but also maintain the problems of other Linux systems, while Windows has long formed a set of its own standards. We never lack good technical developers, what we lack is a set of universally recognized standards and specifications, on which we need to seek common ground while reserving differences.

Answer: Data query website 1.36 big data 2. new list 3. webmaster tools 4. Baidu Search top 5. Baidu statistics 6. Baidu Index 7. Baidu data 8. CNZZ 12.Datahoop Big Data 13. Data View 15. Yiguan 16. China Statistics 17. Website data analysis 18. DCCI Internet data center No.5 How about Linux?

Answer: First, Linux system is free, it is free software, anyone can develop Linux system with their name, of course, you have to be able to program. Second, Linux is mostly used on servers. Servers on large websites almost always run Linux because it is extremely stable. Third, Linux is a command line operating system, learning and using it requires a lot of text commands, unlike Windows, which can solve most problems with a mouse. Fourth, Linux developers are communities, scattered around the world, unlike Windows developers who are all in one company. Linux was not developed to make money or cater to user habits, so it is not intended to dominate the market. Fifth, the Linux desktop is different from the Windows desktop. The Windows desktop is itself a system, while the Linux desktop is a program. Therefore, Linux has a variety of different desktops, and users can freely choose to install and uninstall them. Windows can’t run without a desktop, and Linux can run without a desktop. Sixth, although Linux has a desktop, but its efficiency and Windows are still a gap, because the Linux desktop is not a system, but an application, it and the Linux kernel rely on hundreds of protocols, each time running the desktop, some or most of these protocols have to be executed once or several times. Its efficiency is certainly not comparable to Windows. Seventh, Linux has most of the functions of Windws (except games), it can be said that in addition to playing games, Windows can do things, Linux can do, Windows under the mainstream software, Linux can replace the program. Eighth, Linux configuration is mostly text editing, unlike Windows configuration with a click of a mouse. Beginners will find this difficult. Ninth, The powerful functions of Linux make it easy to make special effects in movies. Since Titanic, movie magicians have used Linux to create special effects that Windows can’t do. Spielberg spent millions of dollars on the software and hardware alone to make Jurassic Park, including the special effects software to run on Linux. No. 10, Linux is free, and so is Android. In fact, Linux is very close to us, the TV box system is basically Android, smart TV system is Also Android. The vast majority of our online shopping websites and web disk servers are Linux system. It can be said that without Linux, we will lose a lot of convenient life interest.

Answer: Linux from 0 last year, writing in Ruby, is also recommended to program on Linux or MAC. It started out as a Linux and MacOS virtual machine installed in Windows, but since Linux wouldn’t work, it was installed directly on a laptop. Now it’s MAC Air and Linux server. In the past, the concept of Linux is just a server. I heard that it is often used by technical giants, and command line operation is mostly used. There are other things in the company, so I have been afraid of software compatibility problems. It’s hard to imagine that three years ago, I knew nothing about Linux, including how to install software from the command line, especially source code that requires self-compilation. Getting started: No matter which distribution you use, install it first and use it later. Of course, it is better to find a distribution that is used more often so that there are more solutions. If there are no specific requirements, it is highly recommended to install Linux on a physical machine rather than a virtual machine. For Linux version selection: If you know which distribution your server is using, just use that version and save yourself the hassle. The development environment should be the same as the server environment, not only the system, but also the version number, which is important. The server we use is Ubuntu, so Ann’s distribution is the same. The user experience of the current Linux release is much better than before. The interface also has imitation Windows, which can be changed. The interface operation is basically not much different from win, so the cost of learning this operation is very small. Whether it’s Linux or MacOS, the command line is the absolute favorite of all programs. It’s much cooler than the interface (but not visually). It does what the interface does, and it does what the interface doesn’t. For example, if I want to install a version controller, if my distribution is Ubuntu, I can: Apt-get install git this command can do a lot of things for me, WHAT I need to do is to wait patiently. Of course, distributions also come with some software, but the version is usually low, and the package manager is a few beats slower to update. If you want to try the latest version, you may need to download the source code, compile and install it yourself, which is quite enjoyable, really. Download Most distributions have their own download center, or app store, which is good enough for office work. Developers can also use the command line to download, such as apt-get, such as yum, or download the installation package and install it directly. Some installation package is the source code, strongly recommend their own hand installation, installation will know how to install. Most Windows software has alternatives. Open source software similar to Word includes OpenOffice, LibreOffice, etc. You can download it and try it out. There are also a lot of software common to the three systems, such as libreOffice text editor, which is the most troublesome one for Win users. In Linux, you will use both VIM and EMACS more when viewing documents. The big boys will say, it’s so convenient, and the new boys will say, what is it? It’s so hard to use. As you can imagine, once you enter the editor, you cannot edit the text, but you are still in command mode, and the text editor uses the command…….. I first used this in the DOS era when I used WPS. Once inside, if you type directly, you may find that your cursor does not know where to go, and the letter you type will not appear on the screen, this actually requires the letter I key to enter the so-called edit mode. If you exit, even better, you need to press Esc to exit text edit mode, go into command mode, ZZ, exit without save, or :q, yes, there’s a colon as soon as you touch Linux, open the system, you’re bound to look, where’s drive C? D? Sometimes you don’t know where to install the software, because you don’t have to choose the installation path when installing the Linux command line, and you won’t generate shortcut ICONS on the desktop. Never mind, Linux system installation is to follow some conventions of the law, that a few places, one by one to find, there must be harvest, no command line search, to know that command line search is Linux proud of the tool, this tool graphical interface but not as good as. Culture Windows and Linux are two different cultures. One is open source and the other is closed source. The concept and operation mode are different, which requires gradual exploration, learning and accumulation. Ok, today share this, hope you pay more attention to! Pay attention to wechat public number, a lot of welfare oh!