Database Administrator

LZ has recently studied java web. Today, I just saw hibernate and found that the information on the Internet was too long when I configured the data source in hibernate. Generally, most of the configurations in tomcat version 5 are used. The

A trigger is a special type of subroutine stored in a database. It cannot be called directly by users, but is automatically triggered by the system when a specific event or operation occurs. Call execution. The trigger cannot accept parameters.

Paging statement: Oracle: -- This paging query method is not only a simple query for a single table, but also complex for the innermost layer query. -- The multi-table joint query or the innermost layer query contains the same sorting

I. Log Files1. Error Log: Error LogContent: All severe warnings and error messages during MyQL Server running, as well as detailed information about each MySQL Server startup and shutdown.Path: the default storage location is in the data

MySQL can be viewed as a layer-2 architecture.The first Layer of SQL Layer includes permission judgment, SQL parsing, execution plan optimization, and query cache processing;The Storage Engine Layer (L2) is the implementation of underlying data

Step 1: Interface Definition: Public interface ICommonDao {List findCollectionByConditionNoPage (String codition, Object [] params, Map orderby ); } Step 2:Classes that implement interfaces: Class entityClass = TUtils. getTClass (this.

Previously. Knowledge Point 1: You need to log on to the database and operate create (or replace) directory test_dump as '/opt/test'. test_dump ='/opt/test' cannot be used here ', and/opt/test is enough. You do not need to use/opt/test. Knowledge

I. Problem Introduction ① Assume that Dangdang users bought a book after placing an order. In this case, there is an order with the order number 001 in the database. One of the status fields is "valid", indicating that the order is valid; ② The

-- Requirement Description: In signBook2, there is a column of date_time with a value of 201210201221. I need to change the first 2012 to 2014, so I wrote the following stored procedure-- _ Id is a column in the table and is the primary key

PL/SQL subprograms include functions and procedures. The function here refers to the user-defined function, which is different from the system function. A subroutine is a PL/SQL block that completes a specific function. It is universal and can be

Backtround: I'm trying to set up processing ing between two SQL 2008 R2 databases on different servers in my internal network, as a test run before doing the same thing with two live servers in different locations.When I actually try and switch the

When writing SQL statements, we found that there are usually many implementation methods for the desired results. In the face of these implementation methods, how should we choose to be relatively optimal? This introduces the topic of this blog, how

Find the listener. ora file: My Oracle is installed on the F disk, Path: F: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener. ora: # Listener. ora Network Configuration File: F: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \

We often encounter an SQL Performance problem in a session, but it cannot be determined which SQL causes a high DB performance problem. This is what we need to monitor this session through the dbms_monitor package. First, determine the session sid

Zookeeper Berkeley DB (BDB) is an efficient embedded database programming library. APIs are available in C, C ++, Java, Perl, Python, Tcl, and many other languages. Berkeley DB can store any type of Key/Value pairs (Key/Value Pair) and store

Oracle optimized or replaced with in, exists, and union statements. There is no problem in testing! Select the appropriate statement based on the actual situation! If there is an index, or full table scan, in and not in should also be used with

The developer said that a package was created and some errors occurred during compilation. Prompt for PL/SQL: ORA-00942: table or view does not exists. This is an obvious error, that is, the error message is displayed either because the table does

This self-study note is from the video Hadoop series on Yutube. url: Https://www.youtube.com/watch? V =-TaAVaAwZTs (one of them) I will not repeat it later Self-taught notes are prone to various errors. Please be careful. Hadoop is still used in

1. Add 6 hard disks (100 GB each. This can be done either through hot or cold addition, or by adding hard disks, using san storage to draw Luns, or adding multiple paths.At the operating system layer, the following sdb can identify such a lun. The

1. If you have a plsql client, you can use this user to log on and right-click all tables and Drop them. 2. If you have the permission to delete a user, you can: Drop user user_name cascade; With cascade, you can delete all associated user