With the popularization of NoSQL database management system, the data storage of many software has turned to MongoDB database. It uses dynamic mode to transform data into structured JSON document storage to improve application performance.In this
A few days ago wrote an article on the introduction of the simple use of springboot. As well as using springboot JPA to do a database of a curd (address: http://blog.csdn.net/canot/article/details/51449589) This document is simply learning the
MongoDB sort () method
Using the sort () method to sort the data in MongoDB, the sort () method can specify the sorted field by parameter and use 1 and-one to specify the sort, where 1 is sorted in ascending order, and-1 is used in descending order.
MongoDB Shard
In MongoDB there is another cluster, that is, the Shard technology, can meet the requirements of a large number of MONGODB data volume growth.
When MongoDB stores massive amounts of data, a machine may not be enough
Suppose there is a user table in the database with two records in it. We want to export it.
Common export Methods[Root @ localhost bin] #./export-D my_mongodb-C user-o User. dat
Connected to: 127.0.0.1
Exported 2 records
[Root @ localhost bin] #
Brief description: MongoDB is a distributed file storage-based database. Written in C ++. It is designed to provide scalable, high-performance data storage solutions for Web applications.
Environment: centos 5.5x64
Installation:CD/root/tools
Wget
This article will introduce you to the new Optimistic Locking feature of DB2 database 9, which enables DB2 to retrieve rows in a specific period of time and understand their last modification time, with good auxiliary effect.
DB2 for z/OS customers
This article describes how to execute SQL scripts in batches in DB2, including preparation, execution of different types of SQL statements, and writing batch processing scripts, hope to help you.
Environment:
Windows
DB2 client or server
I.
The modification method of DB2 columns may not be available to everyone. The following describes the modification and restrictions of DB2 columns in detail. If you are interested in the modification method of DB2 columns, take a look.
1. Modify the
How should I set the DB2 logfilsiz parameter? If the log file gradually becomes full, you need to increase the value of the DB2 logfilsiz parameter. The following describes how to set the DB2 logfilsiz parameter.
Configuration type
Database
The DB2 lock mechanism plays an important role in the DB2 database. Let's take a look at what the DB2 lock mechanism is.
In relational databases DB2, Oracle, Sybase, Informix, and SQL Server, the minimal recovery and transaction unit is a
Guidance:InDB2 databaseWe often encounterCatalogMany people are not very familiar with this word, and catalog is difficult to understand. Specifically, cataloguing includes cataloguing nodes and cataloguing databases. If you want to understand the
No Operation is allowed on the table. The error "SQLSTATE = 57016 SQLCODE =-668" is returned. The error code "7": SQL0668N Operation not allowed for reason code "7" on table XXX.
First, check:
Db2? 57016
SQLSTATE 57016: the table cannot be accessed
You may encounter some problems when resetting the silent State of the DB2 tablespace. The following describes how to reset the silent State of the DB2 tablespace.Correct Method to reset the silent State of the DB2 tablespace:The cause is that the
Db2 database restoration command 1. the names of the backup database (olddb) and the data to be restored (newdb) are different: db2 restore db olddb into newdb; www.2cto.com 2. multiple backup files exist in the current directory. you need to
DB2 auto-increment column Import and Export test DB2 auto-increment column test 1 when you want to change a column in the table to auto-increment, run the following command: alter table alter column set not nullAlter table alter column set
Commonly Used in DB2 development ----- date function (commonly used date function) get time 1. Get current date: values current date; 2012-08-28 2. Get current time of values; 11:56:36 3. Obtain the current timestamp; 2012-08-28 11:57:32 4. year ()
DB2 contains the Import and Export abstract of BLOB field table data: after the Toad tool is connected, execute the statement either in the control center or in the folder without other files. After the Toad tool is connected, execute the statement
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service