Database Administrator

[Transfer tablespace] use the EXPDP/IMPDP tool's transfer tablespace to complete data migration This article demonstrates how to use the EXPDP/IMPDP tool to completely simulate the process of transferring tablespaces for your reference.Task

Oracle GoldenGate Studio graphical interface management tool Installation Oracle GoldenGate Studio is a graphical interface management tool that allows you to conveniently complete OGG replication design. To install this tool, you need Java 8 (1.8)

Mysql-proxy read/write splitting :Mysql-proxy-0.8.3-linux-glibc2.3-x86-64bit.tar.gzHttp://downloads.mysql.com/archives/proxy/Add User:[Root @ martin tools] # groupadd-r-g 303 mysql-proxy[Root @ martin tools] # user add-g mysql-u 303-r-s/sbin/nologin

Redis source code analysis (1) -- Redis Data Structure-string SDS, redissds 1. SDS Overview The strings used in Redis are Simple Dynamic strings (SDS. SDS is packaged Based on the C string to make it more suitable for Redis use scenarios. In

Global Database ranking in December: PostgreSQL steadily increases and postgresql steadily increases Author: Zhou Qi DB-Engines released the database ranking for January. Among the top 20 databases, Oracle ranked first, with Cassandra ranking 9th

Python basics 6: formatting characters, colors, and python Basics Character formatting: 1.% placeholder, % s, % d, % 2. Use format. The format is easy to use. It can be centered, %, binary, and character-filling; 1. Use Case of % Tp1 = "I am % s" %

Comparison between MySQL and Oracle: Four-condition loop statement: mysqloracle Loop statement No. Category ORACLE MYSQL Note 1 IF statements use different IF iv_weekly_day = 'mon 'THENIi_weekly_day: =

Linux CentOS 7 source code compilation and installation of PostgreSQL9.5, centos7 source code compilation rpm The previous blog recorded the installation of PostgreSQL 9.3 in the form of an rpm package (PostgreSQL 9.3 is installed in Linux CentOS 7 (

Package cn.com. JDBC; import java. SQL. connection; import java. SQL. resultSet; import java. SQL. SQLException; import java. SQL. statement; public class CRUD {public static void main (String [] args) throws SQLException {// TODO Auto-generated

This initialization parameter needs to be modified only when the performance of large applications or databases is significantly reduced. From this perspective, the adjustment of initialization parameters is an advanced application in the Oracle

This article describes the overhead of accessing the database from A. NET application from an instance. The author mainly talks about improving the database traversal sequence for. NET applications. Of course, what we are familiar with is the SQL

Record detailed requirement documents Before writing SQL statements, you must clarify the requirements, specific data to be taken, and specific constraints. In the data warehouse environment, you can also consider the specific reports corresponding

Dynamic SQL: code that is executed dynamically. It is generally an SQL statement block dynamically combined based on user input or external conditions. Dynamic SQL can give full play to the powerful functions of SQL and easily solve problems that

Distributed DatabaseThere are two types of systems: physical distribution, but logical centralization. This distributed database is only suitable for a single, small unit or department. Another distributed database system is physically and logically

In large databases, Procedure is often called because of development needs. Procedure development on Oracle and SQLServer varies with syntax. debugging Procedure is not easy on both systems, especially when error processing is performed. Debugging:

So far, the export/import toolset is still the preferred utility for transferring data across multiple platforms with the minimum labor intensity, although it is often complained that it is too slow. Import only reads each record from the export

Connect to the application Each application needs to identify the database server to which it connects to for data retrieval. You can use a connection string to connect an application to a database server. The typical connection string is as follows:

Each database of SQL Server, whether it is a system database master, model, sybsystemprocs, tempdb) or a user database, has its own transaction log, and each database has a syslogs table. Logs record user operations on the database, so if you do not

What is Bloom Filter] Bloom Filter is a space-efficient random data structure. It uses a bit array to easily represent a set and determines whether an element belongs to the set. The efficiency of the Bloom Filter has a certain price: when

I. Usage of autonomous transactions Audit that cannot be rolled back: Generally, when a trigger is used to prohibit operations such as table updates, if logs are recorded, the trigger will cause log rollback when an exception is thrown. Autonomous