This ranking is based on the DB engines list, which analyses 200 different databases on the market, listing top 10.
Undisputed Top 3
Oracle, MySQL, and Microsoft SQL Server have been occupying the top three of the rankings with absolute advantage, carving out the largest number of users in the market with unique advantages.
1. Oracle 11g
First release : 1980
Licensing mechanism : proprietary
whether S
Key-Value Store databaseTemporary: as memcached. The temporary key-value database stores the data in memory, which in two cases results in the loss of data, the first is the power outage, but the data content exceeds the memory size. The benefits of this treatment are very fast.Permanent type: such as Tokyo Tyrant, flare and RomaThe two are both types: Redis. Redis first data in memory, and then meet certain conditions (the default is 15 minutes more than 1 times, 5 minutes more than 10, 11 minu
The top 10 SQL and NoSQL databases in the latest statistics, and nosql databases in the latest statistics
This ranking is based on the ranking of DB Engines, which analyzes the popularity of 200 different databases on the market. The Top 10
Detailed description of distributed algorithms and NoSQL algorithms in nosql Databases
Today, we will study some distributed strategies, such as replication in fault detection. These strategies are marked in italics and divided into three parts:
Data consistency. NoSQL requires a balance between consistency, fault t
relational databases and NoSQL databases what is NoSQLHave you ever heard of "NoSQL"? In recent years, this word has been of great concern. To see the word "NoSQL," you might mistakenly think it was "no! SQL "abbreviation, and deeply outraged:" How can SQL be unnecessary? "
What is nosql?
Nosql (nosql = not only SQL) means not only SQL expansion, but also non-relational databases.
With the rise of Internet Web websites, traditional relational databases are dealing with Web websites, especially ultra-large-scale and high-concurrency SNS type
NoSQL databases: data consistency, nosql Database ConsistencyNoSQL Database: Data ConsistencyRead consistency
High ConsistencyAccess any node in the cluster at any time, and the data obtained is consistent;
User consistency is consistent with the data obtained during cluster access for the same user;Solve user consistency: Use a sticky session to bind the sess
data can be written to a node as soon as possible without being delayed by the network transmission. The disadvantage is that consistency is not always guaranteed, and a small amount of data may be lost in the event of a failure.
The RDBMS adheres to the acid principle, and NoSQL has the base principle , which conforms to the CP in the CAP, which conforms to the AP in the CAP (that is, the former sacrifices availability, the latter sacrifices con
most postgres users will be able to implement the extended tasks of big data OLTP and analytics in a familiar way. The thin public client reference list shows that translattice, like many newsql suppliers, still needs to prove its market appeal. Official website:http://www.translattice.com/index.shtml Voltdb high-speed streaming data DBMS Type: Newsql Description: an in-memory relational database that conforms to the acid and SQL principles
Recently I am reading nosql. A major advantage of nosql over relational databases is high availability. Therefore, some questions are raised:
Why does nosql achieve high availability while relational databases suffer from criticism in this regard?
Relational Database
[TechTarget Chinese original] Q: I am studying various types of database architectures. Can you tell me the security of non-SQL databases (NoSQL) and mainstream commercial relational databases?
For a database that stores information securely, it must provide confidentiality, integrity, and availability (CIA ). When necessary, data must be available (availability
premise, the overhead of data update is very small (the same field basically only has one)
3. complex queries such as Join operations can be performed (Join operations cannot be performed between different servers)
4. There are many practical achievements and professional technical information (mature technologies)
5. All data is expressed in the binary representation of rows and columns, which makes it easier to understand and understand.
Lack of relational
relational database.
Relational databases are widely used for complex processing such as transaction processing and JOIN. Comparatively, NoSQL databases are only applied in specific fields and basically do not carry out complex processing, but they just make up for the shortcomings of the previously listed relational databas
list are used in the key, Redis is also called a data structure server. This system can help you perform atomic operations, such as adding hash values, intersection operations of sets, string concatenation, difference sets, and Union sets. Redis achieves high performance through data sets in the memory. The database is also compatible with most programming languages.6. Riak
Riak is one of the most powerful distributed
models. For the following information, see the Emil Eifrem blog and NoSQL database description.
Document Database
Inheritance: inspired by Lotus Notes.
Data Model: document summary, including key-value summary.
Instance: CouchDB, MongoDB
Advantages: Data Modeling is natural, programmers are easy to use, the development process is short, the webpage mode is compatible, and CRUD (short for adding, querying, updating, and deleting) is easy to achieve ).
information query, may be random, and the news query is based on time, the more new more frequent.NoSQL and relational database combinationIn fact, NoSQL database is only a relational database in some aspects (performance, expansion) of a make up, single-function, NoSQL almost all the functions, in the relational database can be satisfied, so the choice of NoSQL
Label:Original: http://juliashine.com/distributed-algorithms-in-nosql-databases/ A distributed algorithm for NoSQL databasesOn November 9, 2012 in also for rice beam, by Juliashine This article was translated from distributed algorithms in NoSQL Databases The scalability of
Abstract: Although SQL database is a very useful tool, after 15 years of outstanding performance, the monopoly will be broken. This is only a matter of time: I was forced to use relational databases, but I finally found that I could not meet my needs. For details, see my IT-Homer blog: Comparison of eight mainstream NoSQL databases
System scalability is the main reason for promoting the development of NoSQL, including distributed system coordination, failover, resource management and many other features. So that NoSQL listening
System scalability is the main reason for promoting the development of NoSQL, including distributed system coordination, failover, resource management and many other
Recently, many Web2.0 companies, such as Twitter, Digg, and Reddit, have announced that they have switched from MySQL to non-relational databases (NoSQL) to provide Scalable Data Storage Solutions, attracting developers' strong attention to NoSQL. Does NoSQL replace relational data
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.