[DataBase] 각종 정보

!markdown

# DataBase (데이터베이스)

### ORACLE (오라클)

- SITE: 

[https://www.oracle.com/](https://www.oracle.com/)

- DOWNLOAD: 

[http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/](http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/)

- DRIVERCLASS: oracle.jdbc.driver.OracleDriver

- URL: jdbc:oracle:thin:@192.168.0.158:1521:DA

- CMD: sqlplus

- CONNECT: 

```

$ sqlplus {USER}/{PASSWORD}

```

- CONNECT Example)

```

$ sqlplus system/oracle 

```

```

$ sqlplus '/as sysdba' 

```

- Developer Tool: datagrip / toad

### MySQL (마이에스큐엘)

- SITE: 

[http://www.mysql.com/](http://www.mysql.com/)

- DOWNLOAD: 

[http://dev.mysql.com/downloads/mysql/](http://dev.mysql.com/downloads/mysql/)

- DRIVERCLASS: com.mysql.jdbc.Driver

- URL: jdbc:mysql://127.0.0.1:3306/mysql

- CMD: mysql

- CONNECT: 

```

$ mysql -u {USER} -p {DBNAME}

```

- CONNECT Example)

```

$ mysql -u root -p mysql

```

- Developer Tool: datagrip / workBench

### Tibero (티베로)

- SITE: 

[http://www.tmaxdata.com/](http://www.tmaxdata.com/)

- DOWNLOAD: 

[http://technet.tmaxsoft.com/ko/front/download/findDownloadList.do?cmProductCode=0301](http://technet.tmaxsoft.com/ko/front/download/findDownloadList.do?cmProductCode=0301)

- DRIVERCLASS: com.tmax.tibero.jdbc.TbDriver

- URL: jdbc:tibero:thin:@127.0.0.1:8629:tibero

- CMD: tbsql

- CONNECT: 

```

$ tbsql {USER}/{PASSWORD}

```

- CONNECT Example)

```

$ tbsql tibero/tibero

```

- Developer Tool: tbAdmin

### Altibase (알티베이스)

- SITE: 

[http://kr.altibase.com/](http://kr.altibase.com/)

- DOWNLOAD: 

[http://support.altibase.com/kr/product](http://support.altibase.com/kr/product)

- DRIVERCLASS: Altibase.jdbc.driver.AltibaseDriver

- URL: jdbc:Altibase://127.0.0.1:20300/mydb

- CMD: mysql

- CONNECT: 

```

$ isql -u {USER} -p {PASSWORD}

```

- CONNECT Example)

```

$ isql -u sys -p manager

```

- Developer Tool: orange for altibase

### IBM UDB (유디비)

- SITE: 

[http://www.ibm.com/](http://www.ibm.com/)

- DOWNLOAD: 

- DRIVERCLASS: com.ibm.db2.jcc.DB2Driver

- URL: 

- CMD:

- CONNECT: 

- CONNECT Example)

- Developer Tool: 

### IBM DB2 (디비투)

- SITE: 

[http://www.ibm.com/](http://www.ibm.com/)

- DOWNLOAD: 

[https://go.sap.com/cmp/syb/crm-xu15-int-asewindm/typ.html](https://go.sap.com/cmp/syb/crm-xu15-int-asewindm/typ.html)

- DRIVERCLASS: com.ibm.db2.jcc.DB2Driver

- URL: 

- CMD:

- CONNECT: 

- CONNECT Example)

- Developer Tool: 

### informix (인포믹스)

- SITE: 

[http://www.ibm.com/](http://www.ibm.com/)

- DOWNLOAD: 

[https://www-01.ibm.com/software/data/informix/downloads.html](https://www-01.ibm.com/software/data/informix/downloads.html)

- DRIVERCLASS: com.ibm.db2.jcc.DB2Driver

- URL: 

- CMD:

- CONNECT: 

- CONNECT Example)

- Developer Tool: 

### Sybase AS anywhere (사이베이스)

- SITE: 

[http://go.sap.com/korea](http://go.sap.com/korea)

- DOWNLOAD: 

[https://go.sap.com/cmp/syb/crm-xu15-int-asewindm/typ.html](https://go.sap.com/cmp/syb/crm-xu15-int-asewindm/typ.html)

- DRIVERCLASS: com.ibm.db2.jcc.DB2Driver

- URL: 

- CMD:

- CONNECT: 

- CONNECT Example)

- Developer Tool: 

### Enterprise Sybase AS IQ (사이베이스 아이큐)

- SITE: 

[http://go.sap.com/korea](http://go.sap.com/korea)

- DOWNLOAD: 

[https://go.sap.com/cmp/syb/crm-xu15-int-asewindm/typ.html](https://go.sap.com/cmp/syb/crm-xu15-int-asewindm/typ.html)

- DRIVERCLASS: com.ibm.db2.jcc.DB2Driver

- URL: 

- CMD:

- CONNECT: 

- CONNECT Example)

- Developer Tool: datagrip / Interactive SQL

### SQL Server (에스큐엘 서버, 엠에스에스큐엘)

- SITE: 

[https://www.microsoft.com/ko-kr/](https://www.microsoft.com/ko-kr/)

- DOWNLOAD: 

[https://www.microsoft.com/ko-kr/server-cloud/products/sql-server-editions/sql-server-express.aspx](https://www.microsoft.com/ko-kr/server-cloud/products/sql-server-editions/sql-server-express.aspx)

- DRIVERCLASS: com.microsoft.sqlserver.jdbc.SQLServerDriver

- URL: jdbc:sqlserver://server:port;DatabaseName=dbname

- CMD: sqlcmd

- CONNECT: 

```

sqlcmd -S {COMNAME}\{DBNAME} -U {USER} -P {PASSWORD}

```

- CONNECT Example)

```

sqlcmd -S localhost\SqlExpress

```

- Developer Tool: datagrip / ssms

### PostgreSQL (포스트그레에스큐엘)

- SITE: 

[http://www.enterprisedb.com/](http://www.enterprisedb.com/)

- DOWNLOAD: 

[http://www.enterprisedb.com/downloads/](http://www.enterprisedb.com/downloads/)

- DRIVERCLASS: 

org.postgresql.Driver

- URL: 

jdbc:postgresql://127.0.0.1:5432/mydb

- CMD: 

psql

- CONNECT: 

```

psql -U {USER} {DBNAME}

```

- CONNECT Example)

```

psql -U postgres postgres

```

- Developer Tool: pgAdmin

### PPAS (피파스)

- SITE: 

[http://www.enterprisedb.com/](http://www.enterprisedb.com/)

- DOWNLOAD: 

[http://www.enterprisedb.com/downloads/](http://www.enterprisedb.com/downloads/)

- DRIVERCLASS: 

com.edb.Driver

- URL: 

jdbc:edb://127.0.0.1:5444/edb

- CMD: 

- CONNECT: 

- CONNECT Example)

- Developer Tool: