Database Administrator

Exploration of Access database migration and access database migration Background: The Access database architecture was previously designed for business information system software. After a period of operation management, it was found that Access

Install the Vbox extension package and the Vbox extension package **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please

Java oci connection oracle throwing java. lang. UnsatisfiedLinkError: ocijdbc11..., ocijdbc11 First, the oracle client is successfully installed. Use the sqlplus tool to connect to the local service name configured by TNSNAMES. ORA, for

Oracle 11g PL/SQL function result cache, oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends

Database Installation Package and upgrade package script tool RedGate usage introduction, installation package redgate This log records the design of the database installation package I learned at the company. I have encountered some problems in my

Chapter 1 Securing Your Server and Network (1): select the SQL Server Running Account and chaptersecuringSource: http://blog.csdn.net/dba_huangzj/article/details/37924127, topics Directory: http://blog.csdn.net/dba_huangzj/article/details/37906349

Reading: docker container and container cloud (2); reading docker Summarize the learning and building process of dockerI read the 3.1 kernel, which is quite awesome.After reading the plug-ins on the internet, I tried them based on python and

SQL Server Performance Tuning 3 Index MaintenancePreface The previous article introduced how to improve database query performance by creating indexes, which is just the beginning. If you do not need proper maintenance in the future, the indexes you

I. Basic Introduction SQLite is a self-contained, serverless, zero-configuration, and transactional relational database engine. Because it is very small, it can also be built into your application as an embedded database. SQLite is used in Solaris 1

SQL Study Notes (19) ----------- about MySQL database optimization and mysql database Optimization A mature database architecture is not designed with high availability, high scaling, and other features at the beginning. It is gradually improved

Use exp/imp to migrate data, especially between different versions and between different systems,Of course, we recommend that you use expdp/impdp to import and export data. The following is a brief introduction to the basic operations of exp and imp.

SQLite tutorial (4): built-in functions, sqlite tutorial built-in functions 1. Aggregate functions: The aggregate functions supported by SQLite are also supported in many other relational databases. Therefore, here we will just give a brief

(Illustration) mysql client mysqlworkbench in windows connects to the mysql server CentOS on the virtual machine, and the virtual machine installs centos I have installed the mysql server in CentOS Linux and mysql client mysqlworkbench in Windows,

What is the data structure ?, Data structure? What is the data structure? A Data Structure is a data structure that stores and organizes data by computers. A data structure refers to a set of data elements with one or more specific relationships

1. First, you must understand what an execution plan is? An execution plan is a query solution made by the database based on the statistics of SQL statements and related tables. This solution is automatically generated by the query optimizer, for

The OS package and OS patch required for installing oracle database 10gR2 under Solaris 10 or later, sparc10gr2 Reference: Oracle Database (RDBMS) on Unix AIX, HP-UX, Linux, Mac OS X, Solaris, Tru64 Unix Operating Systems Installation and

MongoDB (2)-learn about the installation configuration and mongodb installation Configuration I introduced the general theoretical knowledge of MongoDB. This article will install and use MongoDB on windows and linux. Of course, we will install

[MongoDB] building a Mongo database replica set (similar to a cluster) on the windows platform (III), mongodbmongo I have written two blogs about how to build a Mongo database replica set on windows. Article 1: How to build a Mongo database replica

Compile and install PostgreSQL and osxpostgresql in Mac OSX Originally, the official installation package was used. However, the installation package will create postgre, which is a bit uncomfortable on the login interface. After searching for a

I. background 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 copying data between DB2 and non-DB2