Database Administrator

What is Database Administrator DBA? Database Administrator (DBA. This position has different meanings for different people. A small software development studio has broader responsibilities than a large company with a highly detailed division of

Use the graphical tool MySQL WorkBench to remotely manage MySQL in Linux If you run a MySQL server on a remote VPS, how do you manage your remote database host? Web-based database management tools such as phpMyAdmin or Adminer may be the first thing

In practice, the libdata1 file of the Zabbix-Server database MySQL is too large. Today, the root space of our zabbix-server machine is insufficient. I found that the libdata1 file under/var/lib/mysql/is too large, which has reached 41 GB. I

Impdp terminate ORA-7445 due to fatal errors [kpodpals] Basic ElementsThe day before yesterday, I finally successfully exported all the data to the user. Today, the user told me that the exported data cannot be imported. First, I asked the user what

The difference among Cursor, hidden Cursor, and dynamic Ref Cursor is displayed in PLSQL. plsqlref1. Explicit cursorExplicit is relative to implicit cursor, that is, there is a clear declared cursor. The declaration of an explicit cursor is similar

Data warehouse design purpose and data warehouse design purpose The purpose of data warehouse design or the criteria for measuring success: 1. The data warehouse must make the information of the Organization easy to access. 2. The data warehouse

Manual PostgreSQL database initialization tutorial in windows, initialize postgresql Environment: win7 64 sp1PG: 9.3.5 1. Create the postgres user, and the password is also postgres: net user postgres postgres /add 2. Create a data directory under

IT Ninja Turtles PL/SQL Developer tips and shortcuts, Ninja Turtles developer 1. SQL plus Window: File-> New-> Command Window. This is similar to the SQL plus client tool of oracle, but it is much easier to use than it. 2. Set the Keyword to

OGG-01232 Receive TCP Params Error: TCP/IP Error 104 (Connection Reset By Peer)., ogg-01232params The following errors are often seen in OGG log files:OGG-01232 Receive TCP Params Error: TCP/IP Error 104 (Connection Reset By Peer ). After checking

Software Engineering-software testing, Software Engineering Software Testing After the system is complete, it is time to test the system. This must have been the first system of acceptance. We are confident that the system will be accepted by the

Use Ubuntu Server to Set Up Windows file sharing based on independent hard disk and FTP Server (configuration work), ubuntu file sharing This chapter covers the environment configuration and New Hard Disk addition and settings of Ubuntu Server. 1)

Principles of database systems (I)-basic concepts of database systems and concepts of Database Systems Concept Model: (1) express the overall logical structure of the data, which is a comprehensive description of the data involved in the entire

Key-Value Pair storage (1): What is key-Value Pair Storage? Why? Author: Emmanuel Goossaert Original article: codecapsule.com In this article, I will begin with a short description of what a key-value pair is. Then I will explain some reasons for

In-depth understanding of how to configure MongoDB in MongoDB (1) LinuxI MongoDB Introduction   MongoDB is a high-performance, open-source, and non-pattern document-based database. It is a popular NoSql database. It can be used in many scenarios to

Hadoop big data basic training course: the only full HD version of the first season, hadoop Training CourseHadoop big data basic training course unique HD full version first seasonThe full version of 30 lessons was born Link:

SQL Injection principle and solution code example, SQL example 1. What is SQL injection? 1. What is SQL injection? SQL injection is to insert SQL commands into Web forms to submit or input query strings for domain names or page requests, and finally

Microsoft's new CEO Nadella said that Microsoft will become "mobile first, cloud first", which means that Microsoft's various cloud services will be improved and strengthened. According to the latest news, after using the new brand OneDrive,

Two problems encountered during impdp import: impdp import encountered two problems Two days ago, you need to import the data dump exported from a remote test database using expdp to a local test environment. Some problems are encountered, which is

MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"

BKJIA: From DB2 9.7, you can use the following query to check indexes not used in DB2: SELECT INDSCHEMA, INDNAME, TABNAME      FROM SYSCAT.INDEXES   WHERE  LASTUSED = '01/01/0001';  The LASTUSED column tells you the last access time of