Shulou(Shulou.com)06/01 Report--

The following content mainly brings you the definition and difference analysis of Mysql and Couchbase. The knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

1. Different data models

Mysql

Customer

Id: numeric primary key

Firstname: varchar

Lastname: varchar

Customer_address

Id: numeric primary key

City: varchar

State: varchar

Zip: varchar

Customer_id: numeric foreign key

The above two tables and their columns are not complex, but they still establish a relationship between primary and foreign keys.

Couchbase

{

"type": "customer"

"first_name": "Nic"

"last_name": "Raboy"

}

{

"type": "customer_address"

"city": "San Francisco"

"state": "CA"

"zip": "94101"

"customer_id": "CRAV 1"

}

Does it look a bit like relational data?

Next, let's take a look at the embedded documents and see if you still think so.

This looks very different from a relational database. With JSON, we can embed documents in documents. So I don't have to build another one.

You may wonder what will happen if you have a very complex relationship in your MySQL database, when swapping Couchbase will result in the same data being embedded in more than one Couchbase file.

This can happen, but it's not a bad thing. You don't need a normalized data NoSQL database such as Couchbase. However, if you are really worried, then mix these two methods? For example, customer_history saves unrelated data.

Second, the search method is different.

Mysql

SELECT c.firstname, c.lastname, ca.city, ca.state FROM customer_address ca LEFT JOIN customer c ON ca.customer_id = c.id

Couchbase

SELECT c.firstname, c.lastname, ca.city, ca.state FROM `bucket- name` ca LEFT JOIN `bucket- name` c ON KEYS ca.customer_id

It's different. You may also notice that we used bucket-name twice because Couchbase has no concept of tables and all different documents and document types are stored in bucket. This is also the feature of Couchbase.

Let's take a look at the difference between inserting data.

Mysql

INSERT INTO customer (id, first_name, last_name) VALUES (1, 'Arun',' Gupta')

Couchbase

INSERT INTO `bucket- name` (KEY, VALUE) VALUES ("1", {"first_name": "Arun", "last_name": "Gupta"})

Third, the way to connect to the database is different

The MySQL JDBC Driver

In Java applications, if you want to connect to a MySQL database, you will use the Java Database Connector (JDBC) driver.

Like this

Couchbase

You have a lot of tools that you can use when using MySQL. For example, if you want to execute a query against a database, you can use MySQL CLI. You still have the ability to use similar tools to switch on and off Couchbase. If you are looking for a command line tool, you can use CBQ to query your data. If you are a heavy user of MySQL Workbench, don't worry. Because there is also Query workbench in Couchbase.

For the above analysis of the definition and difference between Mysql and Couchbase, if you need to know more, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.