What does open source data mean?

Question 1: What is the function of open source database? Do you make websites? Open source is open source, not encrypted.

Open source database means that the database is not encrypted and the code is open.

The function of database is a website developed by dynamic language.

Question 2: Which four open source databases are free databases in the open source world?

Release time: 20111-22 09: 34: 30 source: CSDN comments: 0 clicks: 1476 times font size: large, medium and small.

QQ Space Sina Weibo Tencent Weibo Renren.com Douban.com Baidu Space Baidu Search Kaixin.com Copy More 0

Open source database MySQL MySQL is a small open source relational database management system, which was developed by Swedish MySQL AB company. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, it is especially open source. ...

Open source database MySQL

MySQL is an open source small relational database management system, which was developed by MySQL AB Company in Sweden. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database to reduce the total cost of ownership.

Inventory: those free database software in the open source community.

MySQL provides APIs for many programming languages, including C, C++, C#, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl. Moreover, it is written in C and C++, and has been tested by various compilers, so MySQL can ensure that the source code has strong portability. Such a database can naturally support almost all operating systems, from Unix, Linux to Windows, including AIX, BSDi, FreeBSD, HP -UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, OS/2 Wrap, Solaris, SunOS, Windows and other operating systems. Most importantly, it is a large database that can handle tens of millions of records.

At the same time, MySQL has also made many branch versions of the database, which is also highly recommended.

The first is MariaDB, which is a branch version of MySQL with Maria storage engine. It is a free and open source database server developed by the company founded by Michael Widenius, the original author of MySQL. Compared with MySQL, MariaDB has more engines, including Maria storage engine, PBXT storage engine, XtraDB storage engine and FederatedX storage engine. It can replicate query processing faster, run faster, perform better functional tests, and support Unicode sorting.

Secondly, rcona, which improves the MySQL database server, has significantly improved its function and performance compared with MySQL. This version improves the performance of InnoDB under high load. At the same time, it also provides some very useful performance diagnostic tools for DBA, and provides many parameters and commands to control server behavior.

The third is Percona Server, which uses google-mysql-tools, ProveScaling and Open Query to transform mysql. Moreover, it only contains the server version of MySQL, and does not provide corresponding improvements to MySQL connectors and GUI tools.

Non-relational database NoSQL

Literally speaking, NoSQL is not just SQL, it is regarded as a brand-new database revolution movement by the industry. Earlier, it was suggested that the development trend in 2009 would be higher and higher. NoSQL advocates the use of non-relational data storage. Compared with the overwhelming use of relational databases, this concept is undoubtedly an injection of new thinking.

Inventory: those free database software in the open source community.

Of course, NoSQL can make great progress only with the rise of Internet Web2.0 website. The key requirement is that the traditional relational database should be able to cope with Web2.0 websites, especially >:>

Question 3: What is an open source database? Open source is unencrypted open source.

Open source database means that the database is not encrypted and the code is open.

The function of database is a website developed by dynamic language.

Question 4: What is open source big data technology? That is, the amount of data is huge, the structure of data body is unclear and there are many redundant data.

Big data technology uses these data to analyze them with faster speed and better logical cleaning. And through some algorithms, the valuable parts of these complex data are mined, which provides new hidden parameters of relationship interests and scientific guidance for the company.

Open source is open source, that is, free and free secondary development, such as the most widely used hadoop ecosystem.

Question 5: Which open source database relational mysql should I choose?

Non-relational mongodb

Question 6: What does the data source mean? A chart data source is a device or original media that provides some needed data. The data source of the information system must be reliable and have the ability to update. At present, the commonly used data sources are: ① observation data, that is, measured data obtained in the field, including field survey data, station observation record data, telemetry data, etc. ② Analysis and determination data, that is, analysis and determination data by physical and chemical methods. (3) graphic data, various topographic maps, thematic maps, etc. (4) Statistical survey data, various statistical reports, social survey data, etc. ⑤ Remote sensing data, data obtained from ground, aviation or space remote sensing. At present, there are a lot of data sources in China. For example, the national land resources inventory and detailed survey data, aerial photogrammetry images and land survey satellite data have covered the whole country, and the network of positioning and semi-positioning observation stations has spread all over the country, with a large number of data such as ground survey and map mapping.

The data source examples mentioned above are only a small part. In fact, the data source can be any data type.

Question 7: What open source graphic databases are there at present? First of all, MariaDB is a branch version of MySQL with Maria storage engine, and it is a free open source database server developed by the company founded by Michael Widenius, the original author of MySQL. Compared with MySQL, MariaDB has more engines, including Maria storage engine, PBXT storage engine, XtraDB storage engine and FederatedX storage engine. It can replicate query processing faster, run faster, perform better functional tests, and support Unicode sorting.

Secondly, rcona, which improves the MySQL database server, has significantly improved its function and performance compared with MySQL. This version improves the performance of InnoDB under high load. At the same time, it also provides some very useful performance diagnostic tools for DBA, and provides many parameters and commands to control server behavior.

The third is Percona Server, which uses google-mysql-tools, ProveScaling and Open Query to transform mysql. Moreover, it only contains the server version of MySQL, and does not provide corresponding improvements to MySQL connectors and GUI tools.

Question 8: Which open source database should I choose? Which is better? Access is a desktop database, which is only suitable for applications with small data. It is very good and efficient when dealing with a small amount of data and databases accessed by a single computer. But it cannot access more than four clients at the same time. Microsoft Access database has certain restrictions. If the data reaches about 100M, it is easy to cause the server iis to fake death, or consume the server memory to cause the server to crash, which means "the service is unavailable" in English.

MS SQL Server is a medium-sized database based on server, which can be suitable for the application of large-capacity data and is much better than Microsoft Access in function management. It has powerful efficiency in dealing with massive data, flexibility and expansibility in background development. Because now the database is managed by standard SQL language, if it is a standard SQL language, both of them can be basically used. Microsoft SQL Server has many extensions, which can use stored procedures, and the database size is not limited.

MySql is short and pithy. It is a file-based database like access, but it is a hundred times stronger than access. It is a real multi-user and multi-task database system. It is transplanted from Linux, and its security is very good. However, most operations are carried out under dos. Although there is a graphical interface developed by a third party, it is not easy to use. MySQL is a multi-platform database management software, which can run on LINUX, nt, UNIX and other systems, and can support command and graphical management. It is enough for the general database, which occupies less system resources, is faster, and is open source.

Oracle Bone Inscriptions is mature in all aspects, but it has high requirements for hardware. It can be used in occasions with high requirements for data integrity and security. It can run on all mainstream platforms, fully support all industrial standards, and adopt a completely open strategy. Can let customers choose the most suitable solution and give developers full support. Parallel server expands the server's ability by sharing the work among a group of nodes in the same cluster, provides a cluster solution with high availability and scalability, obtains the highest certification level of iso standard certification, supports multi-level network computing, supports a variety of industrial standards, and can connect network customers such as ODBC, JDBC and OCI, which is more complicated. Both gui and command line are provided, and the operation is the same under windows and unix. If windows can't meet the needs, users can migrate the database to unix. Its operation and setting are complicated, and it is suitable for users with certain operating experience.

Db2 can run on all major platforms (including windows). Most suitable for massive data. DB2 is the most widely used enterprise. In the world's 500 largest enterprises, almost 85% use DB2 database server, while in China, the figure of 1997 is only 5%.

In short, each mainstream database has its own advantages and emphases. For beginners, it is recommended to start learning from MS SQL Server. As we all know, Microsoft's things are easy to understand.

Question 9: Which open source database should I choose? If you plan to choose a free open source database for your project, then you may hesitate between MySQL and PostgreSQL. MySQL and PostgreSQL are free, open source and powerful databases. Your main question may be: which is the best open source database, MySQL or PostgreSQL? Which open source database should I choose?

When choosing a database, you have to make a long-term decision, because it is very difficult and expensive to change this decision in the future. You want to make the right choice from the beginning. MySQL and PostgreSQL, two popular open source databases, are often the last choice products. A high-level overview of these two open source databases will help you choose the one that best suits your needs.

relational database

MySQL is relatively young and first appeared in 1994. It claims to be the most popular open source database. MySQL is the M in LAMP (a software package developed by Web, including Linux, Apache and Perl/PHP/Python). Most applications based on LAMP stack will use MySQL, including those well-known applications such as WordPress, Drupal, Zend and phpBB.

At first, MySQL was designed as the fast back-end of Web server, which used the fast index sequential access method (ISAM) and did not support ACID. After early rapid development, MySQL began to support more storage engines, and realized ACID through InnoDB engine. MySQL also supports other storage engines, provides the function of temporary tables (using memory storage engine), and realizes high-speed reading of databases through MyISAM engine, in addition to other core storage engines and third-party engines.

MySQL has a wealth of documents, including many high-quality free reference manuals, books and online documents, as well as training and support from Oracle and third-party suppliers.

MySQL has experienced ownership changes and some dramatic events in recent years. Originally developed by MySQL AB, it was sold to Sun Company in 2008 at a price of $65.438 billion, and Sun Company was acquired by Oracle in 2065.438+00. Oracle supports multiple versions of MySQL: Standard Edition, Enterprise Edition, Classic Edition, Cluster Edition, Embedded Edition and Community Edition. Some are downloaded for free, and some are charged. Its core code is based on GPL license, and commercial license is also available for developers and manufacturers who don't want to use GPL license.

Now, there are more databases to choose from based on the original MySQL code, because several core MySQL developers have released MySQL branches. Michael Monty Widenius, one of the original founders of MySQL, seems to regret selling MySQL to Sun, so he developed his own MySQL branch MariaDB, which is free and based on GPL license. Mao Mao Rain is a branch created by Brian Aker, a well-known MySQL developer, and has done a lot of rewriting, especially for multi-CPU, cloud, network applications and high concurrency.

A database system

PostgreSQL boasts of being the most advanced open source database in the world. Some PostgreSQL fans say that it is comparable to Oracle, and it is not so expensive and arrogant in customer service. It has a long history and was originally developed by the University of California at Berkeley at 1985 as the successor of Ingres database.

PostgreSQL is a completely community-driven open source project maintained by more than 1000 contributors worldwide. It provides a single full-featured version, unlike MySQL, which provides multiple different community, business and enterprise versions. PostgreSQL is based on a free BSD/MIT license. Organizations can use, copy, modify and redistribute code by providing copyright notices.

......& gt& gt

Question10: What does it mean to draw with data sources in Excel? That is, the diagram you draw with excel is generated according to the data, which must be attached.

Right-click the drawing area of excel chart, chart options-data table tab, and check the check box before "Show data table" to display the source data under your drawing area.

Or you can right-click the drawing area and the source data-data area tab of the excel chart, view the data address in the data area box, find the corresponding address, and copy the content.