Sql Graph Database

As a software developer or DBA, one of the essential tasks is to deal with databases, such as MS SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, and so on. As we all know, MySQL is currently the most widely used and the best free open source database, in addition, there are some you do not know or useless but excellent open source database, such as PostgreSQL, MongoDB, HBase, Cassandra, Couchba ...

It was easy to choose a database two or three years ago. Well-funded companies will choose Oracle databases, and companies that use Microsoft products are usually SQL Server, while budget-less companies will choose MySQL. Now, however, the situation is much different. In the last two or three years, many companies have launched their own Open-source projects to store information. In many cases, these projects discard traditional relational database guidelines. Many people refer to these items as NoSQL, the abbreviation for "not only SQL." Although some NoSQL number ...

In the current enterprise IT architecture, system administrators and DBAs will consider using the NoSQL database to solve problems that the RDBMS cannot solve, especially the internet industry. Traditional relational databases store data mainly as tables (table), and cannot meet the challenge of unstructured data. In the process of data standardization, the performance of relational database is encountering bottleneck. NoSQL, as its name suggests, is Not-only SQL, which can be a good complement to relational databases. In the report before the TechTarget database, ...

There are two main ways to store data: Database and filesystem, and the object-oriented storage are developed behind, but the overall thing is to store both structured and unstructured data. DB is initially serviced for structured data storage and sharing. FileSystem storage and sharing is large files, unstructured data, such as pictures, documents, audio and video. With the increase in data volume, stand-alone storage can not meet the needs of structured and unstructured data, then in the era of cloud computing, there is a distributed ...

Michael Stonebraker is a pioneer in the field of databases. His deep expertise has also helped to develop some of the most popular database systems such as Postgres, Ingres and Vertica. One of his most recent studies is VoltDB, a memory-based OLTP (Online Transaction Processing) system, which he claims is two orders of magnitude faster than traditional solutions. However, Stonebraker's opinion has been controversial over the years, on the one hand being ...

In the past few years, relational databases have been the only choice for data persistence, and data workers are considering only filtering in these traditional databases, such as SQL Server, Oracle, or MySQL. Even make some default choices, such as using. NET will typically choose SQL Server, and Java may be biased toward Oracle,ruby, Mysql,python is PostgreSQL or MySQL, and so on. The reason is simple: In the past a long time, the relational database is robust ...

Hadoop is often identified as the only solution that can help you solve all problems. When people refer to "Big data" or "data analysis" and other related issues, they will hear an blurted answer: hadoop! Hadoop is actually designed and built to solve a range of specific problems. Hadoop is at best a bad choice for some problems. For other issues, choosing Hadoop could even be a mistake. For data conversion operations, or a broader sense of decimation-conversion-loading operations, E ...

In January 2014, Aliyun opened up its ODPS service to open beta. In April 2014, all contestants of the Alibaba big data contest will commission and test the algorithm on the ODPS platform. In the same month, ODPS will also open more advanced functions into the open beta. InfoQ Chinese Station recently conducted an interview with Xu Changliang, the technical leader of the ODPS platform, and exchanged such topics as the vision, technology implementation and implementation difficulties of ODPS. InfoQ: Let's talk about the current situation of ODPS. What can this product do? Xu Changliang: ODPS is officially in 2011 ...

The development of spark for a platform with considerable technical threshold and complexity, spark from the birth to the formal version of the maturity, the experience of such a short period of time, let people feel surprised. Spark was born in Amplab, Berkeley, in 2009, at the beginning of a research project at the University of Berkeley. 　　It was officially open source in 2010, and in 2013 became the Aparch Fund project, and in 2014 became the Aparch Fund's top project, the process less than five years time. Since spark from the University of Berkeley, make it ...

Orient DB is a scalable document database that supports ACID transaction processing. Implemented using Java 5. Orientdb is a deeply scalable document-graph DBMS with the flexibility of the Document databases and the power to manage links of T He Graph Databas ...