Cubrid - Open Source - 27mai2010

Presenter:

Catalin Ciobanu Globalization Team, CUBRID CO., LTD. Thursday, January 24, 2013

Open Source DBMS Optimized for Web Services

Contents What is CUBRID? Why CUBRID? CUBRID Insight CUBRID Manager Web Applications CUBRID Contacts

3

What is CUBRID?

4

What is CUBRID?

Database Management System

DBMS

Linux 32bit Linux 64bit

databa se

Windows 32 bit Windows 64 bit

5

What is CUBRID?

Open Source Project

6

What is CUBRID?

Free Software

sourceforge.net/projects/cu brid

dev.naver.com/projects/cub rid

cubrid.org cubrid.com

7

Why CUBRID?

8

Why CUBRID?

CUBRID is Optimized for Web Services

9

Why CUBRID?

Optimized for

Web Services Web Service s

Click Counter Click Counter

Long & Expensive SELECT article FROM bbs WHERE id = 123; Lock UPDATE bbs SET read_count = read_count + 1 WHERE id = Other DBMS

123;

CUBRID SELECT article , INCR(read_count) FROM bbs WHERE id = 123; Fast & Cheap

Lock

10

Why CUBRID?

Optimized for

Web Services

Hotspot Read (Caching)

Web Service s

Broker N= 50,000

Article 34

Article 34

Hotspot Read (Caching)

Click Counter

Query QueryFragmentation Fragmentation&& Optimization Optimization

Query QueryRequests RequestsCaching Caching

CUBRID DB

Query QueryResults ResultsCaching Caching

11

Why CUBRID?

Optimized for

Web Services Web Service s

High Availability Click Counter

Hotspot Read (Caching)

HA (High Availabilit y)

 Multi-threaded server  Multi-CPU optimization  Extreme Load Balancing  High Traffic Proof  Non-stop Service for 24 Hours and 7 Days!  Can Handle Sudden Increase of Traffic!

12

Why CUBRID?

Optimized for

Web Services Web Service s

Java Stored Procedur es

JSP & Partition Click Counter

Partition

Hotspot Read (Caching)

HA (High Availabilit y)

• Range Partition • List Partition • Hash Partition

13

Why CUBRID?

Optimized for

Web Services

Unlimited Storage

 Multi-volume DB  Number of DB, table and size: Unlimited  Number of column: 6,400  Size of column: 2GB  Number of indices: 6,400 14

Why CUBRID?

Optimized for

Web Services

ACID Support

Atomicity Atomicity

Isolation Isolation

ACI D

Consistency Consistency

Durability Durability

15

CUBRID Insight

16

CUBRID Insight

CUBRID Architecture & License Interfaces

Client

Server

ODBC

OLEDB

JDBC

CCI

Python

Ruby

Job Queuing Query Parser Optimizer

Query Manager

Monitorin g/ Logging

Connectio n Pooling

Lock Caching

Lock Manager

PHP

Object Manag er

Broker s

Transacti on Manager

Database Server Storage Manager

Log Manager

CUBRID Manager Client (GUI)

CUBRID Manager Server

BSD

GPL v2 or higher

Utilities (Backup / Restore / Compact / Check / Lock)

17

CUBRID Insight

Superior Performance DBMS

Optimized for

Web Services

Features of BBS Apps •Read count updates •Hotspot Reads 1 PV = 4~7 Queries Level 1: 101,000 articles Level 2: 602,000 articles

18

CUBRID Manager

19

CUBRID Insight

CUBRID Manager

20

CUBRID Insight

CUBRID Manager

21

CUBRID Insight

CUBRID Manager

22

CUBRID Web Applications

23

Web Applications

CUBRID Web Applications Installation Tools

Tools for Windows

Tools for windows

APC_Install-tools Tools for Linux

Applications Blog CMS

BBS

Blog Blog

BBS

Dev Platform

EC

24

Web Applications

CUBRID AppsPack + + Blog

+ +

BBS

25

Ju n Ju / 06 Au l/ 06 Se g/ 06 p/ O 06 ct N /06 o D v/ 0 ec 6 Ja / 06 n Fe / 07 b/ M 07 ar Ap /07 M r/07 ay Ju /07 n/ Ju 07 Au l/ 07 Se g/ 07 p/ O 07 ct N /07 ov D / 07 ec Ja / 07 n Fe / 08 b M /08 ar Ap /08 M r/08 ay Ju /08 n/ Ju 08 Au l/ 08 g Se / 08 p O / 08 ct N /08 o D v/ 08 ec Ja / 08 n Fe / 09 b/ M 09 ar Ap /09 M r/09 ay Ju /09 n Ju / 09 Au l/ 09 Se g/ 09 p/ O 09 ct N /09 o D v/ 09 ec Ja / 09 n Fe / 10 b/ 10

Web Applications

Free Software: Download Trend

4,500

4,000

3,500

3,000

2,500

Open Source DBMS CUBRID 2008 Release 2.0 Open Source DBMS CUBRID 2008 Release 2.1

Open Source DBMS CUBRID 2008 Release 1.0

2,000

1,500

1,000

500

-

* Total downloads: over 70,000 since June 2006

26

Web Applications

CUBRID: MySQL Compatibility • End of April, 2010 – CUBRID 2008 R2.2 – a major bug-fix release

• End of July, 2010 - CUBRID 2008 R3.0 – significant improvements of the core system – MySQL Compatibility + Migration Tools

27

Web Applications

CUBRID References

28

Summary

29

Summary

CUBRID Key Notes Free Free

Click ClickCounter Counter

Open OpenSource Source

High High Performance Performance

32 32bit bit&&64 64bit bit Version Version

High HighAvailability Availability

Unlimited Unlimited Storage Storage

Load LoadBalancing Balancing

Numerous NumerousWeb Web Applications Applications System System Maintenance Maintenance without withoutService Service Stop Stop 24/7 24/7 Service Service&& Support Support

30

Contact CUBRID?

31

CUBRID Contacts

CUBRID Contacts Cubrid Team contact@cubrid.org

CUBRID.Education education@cubrid.com

CUBRID.Marketing mktg@cubrid.com

CUBRID.Support support@cubrid.com

CUBRID.Sales sales@cubrid.com

32

References • CUBRID Co., Ltd. Corporate Web Site. http://www.cubrid.org, http://www.cubrid.com • CUBRID Open Source Project at SourceForge.org. http://www.sourceforge.org/projects/cubrid • CUBRID Open Source Project at Naver Development Center. http://www.dev.naver.com/projects/cubrid • CUBRID on Facebook. http://www.facebook.com/cubrid • CUBRID on Twitter. http://www.twitter.com/cubrid

33 * All materials provided in this presentation are copyrighted by CUBRID Co., Ltd.