database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
ㆍDB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
DB2 Columns 149 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 149
IBM DB2 7.2 vs Oracle 9i
작성자
정재익(advance)
작성일
2001-10-18 23:24
조회수
10,526
첨부파일: orac91vsdb272.pdf (551,157bytes)

IBM 사에서 나온 글로서 IBM DB2 와 Oracle 9i 의 Technical comparision 에 대한 글입니다. IBM 사에서 나온 글이니 만큼 당연히 DB2 에 유리하게 적혀 있는 글입니다. 그런 배경하에서 그냥 DB2 7.2 에 어떤 점이 장점인가 하는 것을 안다는 의미로서 한번 읽어 보시기 바랍니다.

 

결론 부분만 잠시 원문 그대로 옮겨 보겠습니다.

 

 

Conclusion

 

Both IBM and Oracle follow the general trend to position their DBMS both in the operational (relational and object-oriented) and the decision support application area. Especially the data warehousing arena is in focus and therefore enriched with functionality: DB2 has integrated the Data Warehouse Center and the OLAP Starter Kit within the data base engine since 7.1.; The Data Warehouse Manager was and will be enriched gradually with adapters for external data, currently available adapters include SAP, I2 and Websphere Site Analyzer. Since 7.2, DB2 offers integrated mining functionality by means of a DB2 Extender. OLAP extensions to SQL, handled by the SQL3 Standard (ISO 99), have been added for the last versions of DB2. The functionality now offered is quite impressive and can compete with MDBMS solutions. Oracle has only recently likewise enriched its data base engine with OLAP functionality. ETL-functionality is offered with the so-called Warehouse Builder, scheduling is covered with the Workflow Manager.

DB2 adapters show slight advantages above Oracle in this area. Differences in functionality of OLAP extensions and ETL tools need to be practically evaluated and compared, a task not performable for this paper due to complexity. The benefit of this functionality anyhow remains to be determined once OLAP tool vendors begin to use these extensions.

The integration of eBusiness applications is also focussed by both vendors. XML, messaging services and application server integration are featured.

 

Positioning of the DBMS as the single point of access to enterprise data (structured and unstructured, relational and non-relational types) was handled in detail in chapter “5.7 Connectivity / Interoperability”).

From a users view Oracle’s approach of tightly integrated software packages can be rewarding.

But only a few enterprises begin from scratch – for others, the DBMS-ability to integrate applications and tools of other vendors is of far greater importance. IBM‘s strategy of being the middleware provider and openly partnering with best-of-breed application and tool vendors seems better suitable to address the users requirements for free choice of solutions.

In summary we see DB2 in a leading position in this area – not only because of IBM’s partnering strategy.

이 글에 대한 댓글이 총 1건 있습니다.

건신님 위의 사항들을 쭉 읽어 보니, 전반적으로 리눅스에서 상당한 지원 사항이 는 것 같습니다. 그리고 아울러 로그 등 보안 관련 문제에 대해서 신경을 더 많이 쓴 것 같군요. :-)

 

언젠가는 DB2 도 한번 사용해 보고 싶은데 기회가 잘 오질 않네요. :-)

leejg68님이 2001-10-23 11:07에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
214가용성 측면에서 살펴본 DB2 Software
정재익
2001-11-29
15432
213데이터베이스 가용성의 향상
정재익
2001-11-28
12819
154DB2 UDB 7.2의 새로운 기능 정리 [1]
이전건
2001-10-23
11334
149IBM DB2 7.2 vs Oracle 9i [1]
정재익
2001-10-18
10526
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.018초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다