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.