Database Administrator

What is 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 labor. A company, whether it

MongoDB Study Notes (1)-install MongoDB on WindowsOverview This document describes how to install MongoDB in Windows. Official website of MongoDB: http://www.mongodb.org/. the latest version is 2.6.7. Note: MongoDB does not support Windows XP since

An error solution for ORA-600 [13011] Sunoperating 5.10Oracle 10.2.0.2.0A ORA-600 error occurs in a database in the development environment. Error message in alert. log:Thu Nov 13 15:11:43 2014Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc:

Configure Oracle Gateway 12 to connect to SQL Server 2014 In recent work, we need to connect to SQL Server 2014 based on Oracle. We can configure Gateway to implement this function. This Gateway is actually implemented through dblink. That is, the

Rman backup method-Incremental backup and rman backup method incremental Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night.

Chapter 3 Protecting the Data (1): Understanding permissions, chapterprotectingSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not responsible for any

Big Data graph database: Data sharding and Data graph database This is excerpted from Chapter 14 "Big Data day: Architecture and algorithms". The books are listed in In a distributed computing environment, the first problem facing massive data to

MongoDB Learning (2): common modification operations and mongodb learning and ModificationInsert document (insert database)Db. person. insert ({_ id: "0001", name "yuexin "})Clear DataDb. person. drop ()Batch insert documentsBatch insert is not

[Translated from mos] in unix/linux, how does one delete a shard by using a File descriptor (File Descriptors) to retrieve the deleted File (Data File or redo log )?Use File Descriptors in unix/linux to retrieve deleted files (Data Files or redo

In Linux, how does one change the database script file from the sh format to the SQL format, In the process of software development, it often involves changing the database script file from sh format to SQL format in Linux. This document uses an

Atitit. java parses the implementation of the SQL parser interpreter, atitit. javasql Atitit. java parses the implementation of the SQL parser Interpreter 1. parsing the essence of SQL: Implementing a 4gl dsl programming language compiler 1 2.

JSP uses UTF-8 link MYSQL database (UTF8) garbled and connection failure issues: Preface: the databases used by these big companies are not human-friendly... It took me a long time to get it done. Csdn does not seem to be able to transmit images

Install the latest MySQL server in 64-bit Windows 7 Install the latest MySQL server in 64-bit Windows 7 Recently, I have been studying MySQL Databases and often modify configuration files. As a result, MySQL databases cannot be used and I have to

SQL Server Performance Tuning methodology and common tools, SQL Server Tuning In earlier articles, we mentioned the DETECT methodology in Performance Tuning. Here we will briefly review the DETECT methodology. Discover the problem: found the

Postgres-XL: PostgreSQL-based open-source scalable Database Cluster,Postgres-XL: PostgreSQL-based open-source scalable Database ClusterIn the past year, IOE has become more and more popular in the industry. Many traditional enterprises have also

Client Character Set, oracle client Character SetThis part is supported by oracle globalization. For more information, see the documentation.First, let's talk about the database character set. When we use dbca to create a database, we will let you

I. Scenarios In SQL Server 2005, there is a table TestDatetime, where the data type of the Dates field is datetime. If you see a table record, what do you first think? Figure 1: Data List) When you see this data, do you think this design is a waste

Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly, db6.03  Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly Magenfeng (Guangdong Union Electronic Service Co., Ltd.,

ORA-01003: no statement parsed, ora-01003parsed Environment: delphi 5, BDE, oracle10 Delphi with tStoreProc call stored procedures appear ORA-01003: no statement parsed. Solution: the stored procedure name assigned by tStoreProc. StoredProcName

The target of PostgreSQL is very similar to that of the current MySQL database. So what are the advantages of PostgreSQL? This article will be explained to you. This article introduces the basic concepts of PostgreSQL's transaction processing