Database Administrator

How to install and deploy Cassandra distributed NoSQL Database Apache Cassandra is an open-source Distributed Key-Value storage system. It was initially developed by Facebook to store particularly large data. Cassandra is suitable for real-time

Oracle 11g Database shutdown causes the crsd process of 10g Database to restart The customer has an Oracle 10 Gb RAC environment. Due to an occasional demand, a database of 11 GB needs to be temporarily started. When we mount the software and

Install MongoDB on Windows MongoDB is widely used in a variety of large portal websites and professional websites with its features such as simple operations, free of charge, open source code, and ready-to-download. This greatly reduces operating

Today, when I used exp/imp for a small backup and recovery operation, I encountered a problem. Many empty tables cannot be expressed. I didn't understand it at the beginning, later, I went to the Oracle official website and read Oracle data. I sent

Install MySql in Ubuntu and connect to the Internet, while tumysql is on the Internet. Pure beginner tutorial. 1. Install mysql apt-get install mysql-server mysql-client libmysqlclient15-dev During the installation process, you will be

[Translated from mos] asmcmd command is used to copy the asm file between the local and remote asm instances. asmcmdasm Use the asmcmd command to copy the asm file between the local and remote asm instances. Reference Original:How to Copy asm files

Introduction to ETL technology: Introduction to ETL, data warehouse, and etl Data WarehouseETL is the abbreviation of Extract-Transform-Load. It is used to describe the process of extracting, transforming, and loading data from the source to the

Oracle client + PLSQL Developer remote login to Oracle database, oracle client plsql Oracle databases have powerful functions and excellent performance. These advantages also result in a large amount of memory occupied by Oracle. To address this

In-depth analysis of NoSQL database distributed algorithms (graphic details), nosql text Although the NoSQL movement has not brought about fundamental technological changes to distributed data processing, it still triggers overwhelming research and

I wrote a piece of code when I used SQL statements to create a table yesterday. I am not sure about the logic and content of the code. I did not hesitate to execute the code, there were several errors in the process. At that time, I didn't care too

This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not

Comprehensive Sqlite Learning (2) and sqlite Learning Finally, CSDN was chosen to sort out the knowledge points published over the past few years. This article was migrated to CSDN in parallel. Because CSDN also supports the MarkDown syntax, it's

PostgreSQL tutorial (1): Detailed description of data tables and detailed description of postgresql I. Table definition: For any relational database, tables are the core and basic object units of data storage. Now let's start from here. 1. Create a

DB2 joint database is a special form of distributed database management. In the federated database system, you can use an SQL command to send command requests to multiple data sources. Before remote replication between DB2 and non-DB2 databases,

Microsoft enterprise database 6 Data Access Application Block Extension, enterprise database block Although the title is an extension of 6, it is also applicable to 4 and 5, because the Enterprise Library has not changed much in these versions. This

Powershell Mail module, which sends all the emails in outbox (A. CSV file represents an email ), Write the creating mail code to the calling place and write the mailxxx.csv file to the outbox. The main content of the email is recorded in the

Solve the Problem of CPU resource depletion caused by a large number of latch free databases in production. latchfree At noon, the cpu of a database we produced remained high. Using the following SQL statement, we can view the database waiting and

This article mainly introduces what is DB2 database partition and why database partition is used. The following uses Balanced Warehouse E7100 as an example to introduce the basic methods and application practices of database partition management. DB2

The advantage of parallel query is that it can process query jobs through multiple threads, thus improving the query efficiency. The SQL Server database provides the parallel query function for database servers with multiple CPUs to optimize the

BKJIA exclusive Article] the SQL client is an essential tool for every developer. They help developers easily Execute SQL queries in any database. They are also very important for solving any database-related problems. 1. SQuirreL SQL Client