Database Administrator

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to

15 useful MySQL/MariaDB performance tuning and Optimization Techniques MySQL is a powerful open-source Relational Database Management System (RDBMS ). It was released in 1995 (20 years ago ). It uses Structured Query Language (SQL), which may be the

Install and configure MongoDB in Linux1. MongoDB simple description A MongoDB is an open-source database system written in C ++ Based on Distributed File storage. It aims to provide scalable and high-performance data storage solutions for WEB

Installing PostgreSQL using RPM packages in Linux Postgresql and MySQL are currently popular and active open source relational database systems. Compared with high-end Oracle commercial products, Postgresql and MyQL have much room for improvement in

How does SQL Server modify the auto-increment column value and corresponding solutions? A special task encountered in today's work is to change the values of the two auto-incrementing columns.Since the SQL Server platform has previously migrated the

Common MongoDB commands and examples (3). Common mongodb commands Common commands and advanced commands I. Details of advanced applications for addition, deletion, modification, and query: Add: * ** if c1 is not inserted at the time of insertion,

Oracle cloud control 12c startup and shutdown, cloud12c The entire installation of Oracle cloud control 12c is complicated. The installation path, logon password, port number, and many other configurations are confusing. This article describes how

[Sqlite], sqliteI. Install SQLite on Windows 1. Download Visit the SQLite download page http://www.sqlite.org/download.html to download pre-compiled binary files from windows. You need to download the sqlite-shell-win32-*. zip and sqlite-dll-win32-*.

I uninstalled PL/SQL Developer and compared it with Toad for Oracle. Previously, PL/SQL Developer was used to manage Oracle, which was inconvenient to use. It is very difficult to open, and there is always an extra box in the upper left corner of

MongoDB: Data Model introduction, mongodb Data Model Data in MongoDB has a flexible mode. Unlike SQL databases, you must determine the mode of a table before inserting data. The MongoDB set does not force the structure of the document. This

DateDiff function, datediffIn MySQL, you can use the DATEDIFF () function to calculate the number of days between two dates. Syntax: datediff(date1,date2)Note: date1 and date2 must be valid date or date/time expressions Example 1 SELECT DATEDIFF('2

How to Use ZOL one-click installer to download the Zhongguancun online source installation package, zol Zhongguancun online How to Use the ZOL one-click installer to download the Zhongguancun online source installation package Magenfeng(Guangdong

I. Backup and Recovery Overview1. Backup and Recovery Overview1.1 What is Backup and Recovery?Generally, backup and recovery references various policies and procedures to protect your database from data loss, and recreate the database after any data

Comparison table of operations between MongoDB and MySQL and comparison table of mongodb Comparison tables and differences between MongoDB and MySQL MySQL and MongoDB are both open-source common databases, but MySQL is a traditional relational

After several days, I have completed HADR. Next, let's share it with you. System Environment: OS: SUSE 11sp1-64bit DB: db29.7.0.5   DB2server1: 192.168.5.151 db2inst1 DB2server2: 192.168.5.152 db2inst2 Steps: Operations on DB2server1: Db2inst1 @

Windows 10 install oracle 12c error: [INS-30131], 12cins-30131 "[INS-30131] the Initial Setup That Is Required to Run the Installation Program Validation Was Not Successful" Error While Installing Oracle Database (Doc ID 1569962.1)

SQLite tutorial (11): temporary files, sqlite tutorial I. Introduction: Although the SQLite database is composed of a single file, some hidden temporary files exist in the SQLite runtime. These temporary files exist for different purposes,

PostgreSQL tutorial (18): client commands (2), postgresql tutorial VII. pg_dump: Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking

MongoDB Practice Notes for beginners-install, create databases, save and query data, and learn mongodb MongoDB is a scalable and High-Performance Distributed Document storage database written in C. It is designed to provide scalable and

Test Data Management: creative solutions and Data Management Solutions Mario Matthee is a tester, Consultant, certified Master Scrum and very unqualified mountain motorcycle drivers (learning ). He is keen to introduce young IT experts