"Springmvc+mybatis project" Jie Xin Business-2. Database configuration

Let's start by understanding the architecture of the project


We used MySQL and Oracle databases separately, which are heterogeneous databases. We do a single platform to support multiple databases.
Database
Modeling we use Sybase's PowerDesigner (hereafter referred to as PD) and use it for database modeling has a good function, that is, you can automatically generate a table statement.

The industry rarely uses Hibernate's auto-build table, and also uses PD to model the database before creating the database, because our general development projects are demand research, summary design, detailed design, development, in these four stages of our database preliminary modeling is at the time of the outline design, Then in the detailed design and development phase has been to improve it, so we have already built the mold before the development.

The database we have installed is the Oraclexeuniv Lite version of the Oracle database (the simplified version is lower than the normal version, mainly for the programmer's internal testing), but we are now working on the development, so we only use lite version here.

Heterogeneous database technology: The current system directly supports the mainstream database, requires a small number of coding
Oraclexeuniv simple version (recommended)
11g full version installation package, 2 files, 3G

Before the simple version of 10g, you cannot create a local service, no command to import data commands and export data.
Sqlplus it can be accessed directly using the account number. (Large permissions)
PL/SQL Oracle Client Tools do not have direct remote access to Oracle. Channel must be created (Local service)

We use the PL/SQL Developer Database graphical Interface management tool to manage Oracle

The Oracle database services are listed as follows:


General installation of the Oracle database, the default services are automatically started, daily use, you can stop the service, speed up the system to boot, do not account for memory.

Install Oracle Create SID, CREATE DATABASE (account), default System/sys system account. Be sure to remember the password.

A) Create an account (created in user)

b) Authorization

c) Login with the account you created

d) Select Myobjects to see only their own content

"Springmvc+mybatis project" Jie Xin Business-2. Database configuration