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
운영게시판
최근게시물
MySQL Columns 23508 게시물 읽기
No. 23508
SAPDB Roks!
작성자
정재익(advance)
작성일
2002-08-08 13:06
조회수
8,494

SAPDB Roks!

 

다음 글은 Remus Pereni 라는 사람이 SAP DB 를 사용해 보고서 적은 개인적인 글로서 SAP DB 에 대한 만족감을 표하고 있다. 처음 윈도우 환경에서 PostgreSQL 을 설치하고서 실망감을 표하고 있는데 이는 PostgreSQL 은 윈도우 환경에서는 돌려서는 안되는 DBMS 이기 때문이며, MySQL 은 Winodws 환경에서 상당히 좋은 performance 를 보여 준다. 이러 한 것들을 생각하면서 다음 글을 읽어 보시기 바랍니다.

 

원본 : http://remus.manilasites.com/discuss/msgReader$58

 

Author: Remus Pereni

Posted: 6/14/2002; 7:26:24 PM

Topic: SAPDB Roks!

Msg #: 58 (top msg in thread)

Prev/Next: 57/59

Reads: 72

 

 

SAPDB Roks!

After I managed to install last week Postgresql under Windows and tested DataStore with disappointing results, today I installed SAPDB and tested again.

 

Fantastic! I used the RFC reference XML documents from xml.resource.org, 3124 XML documents, small ones around 4M at all, DataStore over SAPDB, and an MN8 script to load all this documents and store them using SEP (the Simple Exchange Profile) over XML-RPC.

 

The procedure lasted less than an hour, that means over 60 documents per minute, this is the same as Postgresql, but what is different is that by the time the storing of the documents was completed the indexing was to. With Postgesql this requested around 30 hours.

 

Now, DataStore stores the document as it receives it (it does not alter it), but to allow very fast structured searches (get me the documents which have this element containing this value and this attribute with this value) it breaks the documents in little entities (prety much as Google does) entities which can be used efficiently (actually use their indexes in their queries) by relational databases along with keeping information about the structure of that entity (part of that element ...). That way you can actually query toons of well or not so well formatted documents using complex structure information and get the results instantly.

 

After the 3124 documents, DataStore extracted 27000 entities (most of the time words).

 

And in all this time I worked as usually on the same computer.

 

I can't explain the poor performances of Postgresql, it does not perform much better on the Linux server either and we tried many versions, must be something related to their JDBC drivers, in comparation to IBM DB2 or MySQL is way slower.

 

However SAPDB rocks and it's free (GPL/LGPL) with versions for Linux and Windows (and many other), so if you are looking for an free, industrial strength relation database look no further. Should I mention that it comes (the Windows version) with excellent GUI management tools.

[Top]
No.
제목
작성자
작성일
조회
23511SAP DB Goes Open Source
정재익
2002-08-09
11388
23510SAP DB 의 유래
정재익
2002-08-08
9711
23509SAPDB Source Has Been Released Under The GPL
정재익
2002-08-08
7864
23508SAPDB Roks!
정재익
2002-08-08
8494
23327MySQL [4.1 -> 5.0] 업그레이드시 체크할것
이경환
2005-03-17
10869
23326MySQL [4.0 -> 4.1] 업그레이드시 체크할것
이경환
2005-03-17
14670
23324MySQL [3.23 -> 4.0] 업그레이드시 체크할것
이경환
2005-03-17
10639
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.049초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다