Database Administrator

In-depth analysis of distributed algorithms for NoSQL Databases System scalability is the main reason for promoting the development of NoSQL, including distributed system coordination, failover, resource management and many other features. In this

Data synchronization between Oracle GoldenGate databases on Heterogeneous OS Oracle GoldenGate (hereinafter referred to as OGG) synchronizes data between databases of the same type on Heterogeneous OS. Functions implemented by ogg: It can be refined

Install DB2 V10 and Data Studio V3 in a Linux (Ubuntu) Environment This document describes how to install a DB2 database in Linux. The Linux version used is Ubuntu 12.04. The DB2 version is DB2 Express-C V10.1 Linux 32-bit, that is, the Community

Win8 64-bit connection to oracle Database Using plsql developer, win8plsql Problem: When plsql developer is used on a 64-bit win8 system to connect to a local oracle database, an inexplicable problem may occur. The error prompt box may even be blank.

Data room charging system login BUG, charging system bugDisclaimer: the following content only applies to those who cannot log on multiple times with a single user name at the time of Logon!It is a BUG. In fact, this is not a BUG. Just come up with

Overview of Oracle architecture, Overview of oracle Architecture This document describes the architecture of oracle from the Internet. 1 oracle databases mainly consist of data file databases and database instance instances. The User links to the

Mysql database version control dbv, mysql database version dbv Version Control software includes svn git and so on. These tools control the source code version very well, but what about database version control? The traditional method is to export

Vertica "ERROR: Too many ROS containers exist", verticacontainers Original article: Vertica "ERROR: Too many ROS containers exist" Recently I encountered a problem when using Vertica. After running Vertica for a while, it always encountered the

Mybatis type conversion when using generator to automatically generate code, mybatisgenerator Use the generator of mybatis to automatically generate code, but in the oracle database, number (6, 2) is always automatically converted to BigDecimal, and

Python clears database error logs and python database logs # Coding = gbkFrom encodings import gbkImport reImport sysImport OSImport pyodbcImport tracebackImport decimal   # Connecting to a databaseConn = pyodbc. connect ('driver = {SQL Server};

PostgreSQL code analysis, query optimization, process_duplicate_ors, postgresql PostgreSQL code analysis and query optimization. /** Process_duplicate_ors * Given a list of exprs which are ORed together, try to apply * the inverse OR

Mongodb advanced 2: mongodb aggregation and mongodb advanced AggregationIn the previous article we talked about mongodb's advanced query: http://blog.csdn.net/stronglyh/article/details/46817789 This article introduces mongodb aggregation. I. mongodb

SQL string to Int type, SQL string int In general, SQL statements can be implicitly converted without strong conversion. It is really necessary to replace it with int type. Convert (int, @ str) Today we are talking about another situation,First

Multiple result sets of report data sources and report data sources Diverse data sources are becoming more and more common in report development. the effective support of the collection and computing reports for diverse data sources makes the

Database optimization tutorial (11) Design a beautiful table and database Optimization4. Design a beautiful table The previous chapter describes how to use indexes to accelerate our query statements. This chapter allows us to go back to the initial

The transaction log for database 'xx' is full, Error: 9002, Severity: 17, State: severity Check database logs with the following error message: Error: 9002, Severity: 17, State: 4.The transaction log for database 'SharedServices1_Search_DB' is full.

Mysql import data load data infile usage, mysqlinfile Mysql import data load data infile usageBasic Syntax: load data [low_priority] [local] infile 'file _ name txt '[replace | ignore] Into table tbl_name [Fields [Terminated by 'T'] [OPTIONALLY]

Percona-toolkit installation and introduction, percona-toolkit MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many

ORACLE step-by-step explanation (Lecture 1) and oracle lecture 1 Oracle was not used for a long period of time due to work reasons. Recently, it took some time to learn and record what you learned so that you can consolidate it in the future (taking

Expanded group by for report development and expanded group by for reports In practical use, for example, in a data warehouse, multi-dimensional analysis of data is often required, not only the results of standard grouping (equivalent Group by), you