Database Administrator

MongoDB Data Link Modeling The data in MongoDB is very flexible, and the collection does not require a uniform structure for documents. However, seriously considering the data model is still very important, because it will affect application

Detailed introduction to mysqldump Note: mysqldump is a tool used by the database for backup and data transfer. It can be used for backup when the data volume is small (several GB. When the data volume is large, mysqldump is not recommended for

Debugging record of MySQL storage function error [Err] 1064 1. An error is reported when a user creates a storage function.Create definer = 'root' @ 'localhost' FUNCTION 'stuff '(F_old varchar (1000), f_start int, f_length int, f_replace varchar (100

Reproduce the library cache lock wait event at 11 GB in Oracle From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during business

Install MySQL in CentOS and use Navicat for MySQL in WindowsInstall Check whether the installation has been performed:Yum list installed mysql *Rpm-qa | grep mysql * Check whether the installation package is available:Yum list mysql * Install the

[Database Study Notes] (4) JDBC data source and connection pool, learning notes jdbc Different database connection pool and JDBC Simply put, a link pool creates many links and stores them in a pool. You can retrieve them from the

Oracle SQL statement optimization, oraclesql statement Although orm ing is used in the project, the optimization of the Oracle system is very valuable. Here we will summarize the commonly used statements from the perspective of SQL statements. 1.

An error occurred while executing the SQL client in hive. The hivesql Client FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exe c. DDLTask. java. lang. RuntimeException: Unable to instantiate org. apache. hadoop. hive.

Introduction to update subqueries and update queries Basic knowledge1. Associated subqueries and non-associated subqueries In a non-associated subquery, an internal query only executes once and returns its value to an external query. Then, an

Mysql is case insensitive and mysql is case insensitive The following table is used to differentiate the sensitivity of mysql to Case sensitivity in windows and linux by default. Operating System Table Name Variable name Field

Data room charging system-Additional database, additional data room Charging System When attaching a database, the following error occurs: "An error occurred while appending a database. For details, click the hyperlink in the" message "column

MongoDB: Map-Reduce, mongodbmap-reduce Map-reduce is a data processing program (paradigm) that considers large data to obtain useful aggregation results. For map-reduce operations, MongoDB provides mapreduce commands. Consider the following

When OGG is used, data is synchronized one way between two Oracle databases. Configuration: source database 100.100.100.21 Instance name dbsid2 Target database 100.100.100.41 Instance name db1 Tutorial objective: to synchronize the scott user emp

1. Configure the Publishing ServerOn the Publishing Server, perform the following steps:(1) select [configuration Publishing, subscription server and Distribution] from the [copy] sub-menu in the [tools] drop-down menu to see the configuration

Bonecp. properties jdbc.driverClass=oracle.jdbc.driver.OracleDriverjdbc.jdbcUrl=jdbc:oracle:thin:@192.168.30.4:1521:testjdbc.username=testjdbc.password=test#Sets the minimum number of connections that will be contained in every partition.

Create Jobs Syntax: Jobs are created using the DBMS_SCHEDULER package, which is the CREATE_JOB process. For example: SQL>BEGIN 2 DBMS_SCHEDULER.CREATE_JOB ( 3 job_name =>'Insert _ TEST_TBL', 4 job_type =>'Stored _ PROCEDURE', 5 job_action =>'P

Check whether the installation has been installed:Yum list installed mysql *Rpm-qa | grep mysql * Check whether the installation package is available:Yum list mysql * Install the mysql client:Yum install mysql Install the mysql server:Yum install

Bad blocks of Oracle data files can be divided into physical and logical Bad blocks. Physical Bad blocks (or media Bad blocks) mean that the block format itself is bad, and the data in the block has no meaning. The logical bad block refers to the

I wrote a blog about Oracle Database remote connection: Oracle database -- server-side remote connection configuration. In that article, I recommended someone else's blog, which is the topic of this blog. However, I recently used it, so I went

• Describes the options for restoring data faults • use the new RMAN data repair command to perform the following operations: -List faults-receive repair suggestions-repair faults • Perform preventive fault checks • query the data recovery guidance