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.
|