Database Administrator

Regex usage in MongoDB Background Part1: Preface Anyone who uses MySQL or other relational databases knows that fuzzy queries are used in similar ways:SELECT * FROM products WHERE sku like "% 789 "; The regex in MongoDB described in this article

Integration of Hazelcast and MongoDBI. Hazelcast and MongoDB Hazelcast's Distributed Data Structure and computing performance enable it to serve as the "MongoDB" at the application backend ". MongoDB is an open-source, document-oriented database

Oracle Database full recovery and Incomplete recovery, and perform user management for multiple generations recovery, oracle user management Comparison between full recovery and Incomplete recovery: 1. Full recovery: restores the database to the

Disclaimer: The system commands described in this article are "#", which indicates the root permission, and "$" indicates the Oracle permission. 1. Install the systemFirst install the Linux system. According to the recommendations in the official

Delete Mysql on Mac and Mysql on Mac First, stop the MySQL service. You can stop the service in preference settings, and then execute the following command $ sudo rm /usr/local/mysql$ sudo rm -rf /usr/local/mysql*$ sudo rm -rf

I found a on the internet, and I think this book is quite good. It is suitable for programmers who are new to Oracle to read it. This book starts with some of the most basic knowledge and works with easy-to-understand examples to help you get

How to update a patch (Rolling Patch) in the Oracle RAC EnvironmentThe Oracle RAC database environment has many similarities and differences with the single-instance database environment. You can use opatch to update database patches. However, there

Use the basic SQLite3 command and the unzip tusqlite3 command in ubuntu System Platform: ubuntu10.04 IntroductionSqlite3 is mainly used for Embedded lightweight databases. This article aims to provide technical documents for familiar with sqlite3

[Introduction to Data Mining]-quality of data quality and quality of Introduction to Data MiningData qualityThe data used by data mining is usually collected or collected for other purposes without explicit purpose. Therefore, data quality cannot be

IP address cocould not be resolved: Temporary failure in name resolution, resolvedresolution Mysql logs were found to have the following warnings this morning: 140724 18:41:25 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary

Use the MySQL Workbench remote management tool to remotely manage Mysql errors and solutions.Overview: Recently, MySQL Workbench is used for remote management of MySQL on virtual machines. However, some problems are encountered during the

This article builds the mirror demonstration for the non-domain environment, for the domain environment establishment, can refer to above: http://blog.csdn.net/dba_huangzj/article/details/28904503Source:

Since the introduction of the relational database model by edugatd in 1970, relational databases began to emerge. After more than 40 years of evolution, today's relational databases have a wide variety of features and are widely used. In the face of

PL/SQL Developer   Remote connection to Oracle Database   I searched many methods online. This is feasible!   1. Configure the server tnsnames. ora file. If oracle is not installed on the local machine, you can copy one (tnsnames. ora file) in the

1. Import CSV data The content of the user.csv file is as follows: _ Id, name, ageObjectID (4eed9f9ca939118694cf05e4), "ming", 10ObjectID (4ef1f3cf3bd18218e6bdfa31), "lisi", 20   You can import the data in user.csv to the user set of the localdb

/* Function: batch process data in the database. For example, enter one thousand data records, it is obviously a waste of time to insert a record after each operation, such as creating a connection, and then disconnecting and then creating an insert,

Big Table data migration,Every morning1Point5Point execution, The execution interval is 10 minutes,Migrate old data to the History Table. DELIMITER $   USE 'dbx' $   Drop procedure if exists 'Pro _ xx' $   Create procedure 'Pro _ xx

SQL Study Notes (14) ------------ data table, SQL statement for creating a data table Operations on Data TablesBasic Database OperationsWith MySQL, you can choose between the three basic database table formats (version 3.23. When creating a table,

Five tips for Instagram to improve PostgreSQL performance, postgresql Performance Optimization As Instagram grows, Postgres continues to serve as a solid foundation for Instagram and stores a vast majority of user data. Less than a year ago, we also

Summary of index, foreign key, and field syntax maintenance for mysql, SQL Server, and oracle databases, and SQL Server oracle Summary of index, foreign key, and field syntax maintenance for mysql, SQL Server, and oracle databases  1. MYSQL database