Ingres Vectorwise 3.0評測

Dodd發表於2013-07-28
一、下載並安裝 Vectorwise 3.0       
從www.actian.com上下載vectorwise 3.0試用版。試用期為30天。
下載的安裝包為：vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64.tgz
同時，actian會將試用版license傳送到你的郵箱裡，檔名為：

authstring   

建立ingres使用者和組：

[root@node1 opt]# groupadd ingres
[root@node1 opt]# useradd ingres -g ingres 
[root@node1 home]# passwd ingres
Changing password for user ingres.
New password: 
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@node1 home]# 
  
 將下載下來的軟體包上傳到伺服器，解壓：
-rw-r--r-- 1 root root       35 Jul 19 23:30 
authstring-rw-r--r-- 1 root root 68940142 Jul 20 00:30 
vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64.tgz
[root@node1 vectorwise]# tar -zxf vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64.tgz
 [root@node1 vectorwise]# ll

最好將目錄許可權改為ingres使用者所有：
chown -R ingres:ingres vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64

將authstring複製到 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64目錄中。

使用root使用者執行安裝命令：

[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# ./vectorwise_express_install.sh V3 /opt/vectorwise30

v3代表例項名。

Vectorwise 3.0.0 Express Install

Checking public key...
Warning: No key for "Vectorwise 3.0" found
Verifying RPMs... FAIL
/root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/director-1.1.0-207.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#7a05d128) 
/root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/vectorwise-3.0.0-334.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#7a05d128) 
/root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/vectorwise-dbms-3.0.0-334.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#7a05d128) 
/root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/vectorwise-net-3.0.0-334.x86_64.rpm: (SHA1) DSA sha1 md5 (GPG) NOT OK (MISSING KEYS: GPG#7a05d128) 
Warning!
Unable to verify packages as authentic. Please check you have the latest

    Vectorwise 3.0 (RPM)

public key installed. It can be downloaded from http://esd.actian.com
and installed by running:

    rpm --import

as root.

Do you wish to continue? (y or N): Y
warning: /root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/vectorwise-3.0.0-334.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 7a05d128: NOKEY
Checking for current installations...

warning: /root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/vectorwise-3.0.0-334.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 7a05d128: NOKEY
Checking licensing requirements...

The License for Vectorwise 3.0.0 must be read and accepted before
installation of this product can commence. 
Invoking ./ingres-LICENSE...

ACTIAN CORPORATION

THIS CLICK-THROUGH PILOT AGREEMENT (THE "AGREEMENT"),
IS ENTERED INTO BY AND BETWEEN ACTIAN CORPORATION 
("LICENSOR") AND YOU, AND ESTABLISHES A LICENSE TO 
YOU TO EVALUATE CERTAIN SOFTWARE OF LICENSOR ("PROGRAM 
MATERIALS").  IF YOU ARE ENTERING INTO THIS AGREEMENT 
ON BEHALF OF A COMPANY OR AN ENTITY, YOU REPRESENT 
THAT YOU ARE THE EMPLOYEE OR AGENT OF SUCH COMPANY 
OR ENTITY AND THAT YOU HAVE THE AUTHORITY TO ENTER 
INTO THIS AGREEMENT AND LEGALLY BIND YOUR COMPANY OR 
ENTITY. BY USING THE PROGRAM MATERIALS OR CLICKING ON 
THE "I ACCEPT" BUTTON BELOW (OR TYPING "Y" OR "YES" IF 
YOU ARE INSTEAD ASKED FOR A "Y OR N" RESPONSE), YOU 
ACKNOWLEDGE THAT YOU HAVE READ, UNDERSTOOD, AND AGREE 
TO BE BOUND BY ALL OF THE TERMS AND CONDITIONS OF THIS 
AGREEMENT.  IF YOU DO NOT AGREE TO ALL OF THE TERMS 
AND CONDITIONS OF THIS AGREEMENT, LICENSOR SHALL NOT 
LICENSE THE PROGRAM MATERIALS TO YOU, AND YOU MUST 
CLICK ON THE "DECLINE" OR "I DO NOT ACCEPT" BUTTON 
BELOW (OR TYPE "N" OR "NO" IF YOU ARE INSTEAD ASKED 
FOR A "Y OR N" RESPONSE) AND DESTROY OR RETURN ANY 
PROGRAM MATERIALS. THE EFFECTIVE DATE OF THIS 
AGREEMENT IS THE DATE UPON WHICH YOU CLICK THE 
"ACCEPT" BUTTON BELOW.  FOR PURPOSES OF THIS 
AGREEMENT, "CUSTOMER" INCLUDES YOU AND ANY OF YOUR 
COMPANIES OR ENTITIES THAT YOU HAVE BOUND UNDER THIS 
AGREEMENT.

1.  PROGRAM MATERIALS.  "Program Materials" means the 
object code version of the computer software 
delivered to Customer by Licensor in connection with 
this Agreement, including Documentation.  
"Documentation" means any and all related user manuals, 
technical documentation, configuration specifications 
and training materials.  Program Materials may be 
amended from time to time by Licensor.

2.  LICENSE.  Licensor hereby grants to Customer a 
royalty-free, non-exclusive, non-sub-licensable, non-
transferable license, limited to ten (10) concurrent 
users, to use the Program Materials internally from 
the date of delivery for thirty (30) days ("Trial 
Period") for evaluation purposes only, in accordance 
with the terms and non-disclosure requirements 
contained herein.

3.  LIMITATION ON USE.  As a condition of the license 
granted above, Customer shall not: (i) license, 
distribute, sublicense, lease, rent, loan, encumber, 
assign, sell or otherwise transfer or remarket the 
Program Materials to any third parties; (ii) reverse 
engineer, reverse compile, de-compile, or disassemble 
the object code or otherwise attempt to derive the 
source code for any of the Program Materials; 
(iii) modify the Program Materials; (iv) alter, 
remove or violate any of Licensor's or its licensors' 
copyrights, trade secrets or other proprietary rights 
related to the Program Materials; or (v) make copies 
of the Program Materials, other than two (2) copies 
for backup purposes.  If Customer breaches any of 
these conditions, Licensor may immediately upon 
written notice to Customer terminate the Agreement 
and the license granted herein.

4.  WARRANTIES.  THE PROGRAM MATERIALS ARE PROVIDED 
TO CUSTOMER STRICTLY ON AN "AS IS" BASIS, AND 
LICENSOR HEREBY DISCLAIMS ALL WARRANTIES AND 
CONDITIONS, WHETHER EXPRESS, IMPLIED, OR STATUTORY, 
INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY, 
FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-
INFRINGEMENT. LICENSOR DOES NOT WARRANT THAT ANY 
SOFTWARE WILL BE PROVIDED ERROR FREE, WILL OPERATE 
WITHOUT INTERRUPTION OR THAT ANY SOFTWARE WILL 
FULFILL CUSTOMER'S REQUIREMENTS.  TO THE EXTENT THAT 
LICENSOR CANNOT DISCLAIM ANY SUCH WARRANTY AS A 
MATTER OF APPLICABLE LAW, THE SCOPE AND DURATION OF 
SUCH WARRANTY WILL BE THE MINIMUM REQUIRED UNDER 
SUCH LAW.

5.  LIMITATION OF LIABILITY.  TO THE MAXIMUM EXTENT 
PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL 
LICENSOR OR ITS LICENSORS BE LIABLE FOR ANY INDIRECT, 
INCIDENTAL, SPECIAL, CONSEQUENTIAL, OR EXEMPLARY 
DAMAGES ARISING OUT OF, OR RELATED TO, THE PROGRAM 
MATERIALS OR THIS AGREEMENT, HOWEVER CAUSED AND UNDER 
ANY LEGAL THEORY, AND INCLUDING, WITHOUT LIMITATION, 
LOST PROFITS, DATA, REVENUE OR GOODWILL, OR BUSINESS 
INTERRUPTION, EVEN IF LICENSOR HAS BEEN ADVISED OF, 
KNOWS OF, OR SHOULD HAVE KNOWN OF THE POSSIBILITY OF 
SUCH DAMAGES.  LICENSOR'S AND ITS LICENSORS' TOTAL 
CUMULATIVE LIABILITY ARISING OUT OF OR RELATED TO THE 
PROGRAM MATERIALS OR THIS AGREEMENT, WHETHER IN 
CONTRACT, TORT, STATUTORY OR OTHERWISE, WILL NOT 
EXCEED ONE HUNDRED DOLLARS (00).  THE PARTIES 
ACKNOWLEDGE THAT THIS SECTION 5 REFLECTS THE AGREED 
UPON ALLOCATION OF RISK BETWEEN THE PARTIES.

6.  TERMINATION.  This Agreement and the license 
granted herein shall terminate automatically at the 
end of the Trial Period unless earlier terminated in 
accordance with this Section 6.  Either party may 
terminate this Agreement upon written notice to the 
other upon any material breach by such other party.  
Upon expiration or termination of this Agreement for 
any reason, Customer shall return all copies of the 
Program Materials to Licensor, and Sections 1, 3, 4, 
5, 6, 7, 8, 9, 10, 12 and 14 shall survive. Upon 
expiration of this Agreement, the parties may, on 
mutual agreement, negotiate and enter into a longer 
term agreement to license the Program Materials.  

7.  PROPRIETARY INFORMATION.  The Program Materials 
are licensed to Customer, not sold, and title to the 
Program Materials and all associated intellectual 
property rights is retained by Licensor and its 
licensors.

8.  CONFIDENTIALITY.  Customer agrees that the 
Program Materials, and any other information, 
technical data, or know-how related to the Program 
Materials (including working papers), is Confidential 
Information of Licensor and its licensors.  
"Confidential Information" will not include any such 
information, technical data, or know-how which: 
(i) is already or otherwise becomes publicly known, 
not as a result of any action or inaction of the 
Customer; or (ii) is rightfully in the Customer's 
possession prior to disclosure by Licensor as can be 
shown by the files and records of Customer 
immediately prior to disclosure. Customer agrees not 
to use or disclose any Confidential Information 
except as expressly permitted by this Agreement, and 
to protect the confidentiality of all Confidential 
Information and to take the same steps to prevent 
unauthorized disclosure or unauthorized use of the 
Confidential Information as Customer takes with its 
own confidential information (and in no event less 
than those actions standard in Customer's industry).

9. EXPORT CONTROLS.  Customer acknowledges and agrees 
that the downloading, exporting or re-exporting of 
the Program Materials, either directly or indirectly 
and via any means, including electronic transfer, 
must be in compliance with the U.S. Export 
Administration Regulations and the laws of host 
countries, and Customer will comply strictly with all 
such laws and regulations. Licensor assumes no 
responsibility or liability for Customer's failure to 
obtain any necessary export approvals. Specifically, 
no Program Materials may be downloaded or exported to 
Cuba, Iran, North Korea, Sudan, and Syria, or to any 
other embargoed or otherwise restricted countries or 
end-users.  By downloading or evaluating the Program 
Materials, Customer agrees to the foregoing and 
represents and warrants that a) Customer is not 
located in, under the control of, or a national or 
resident of any such country; b) Customer is not on 
any of the restricted lists including U.S. Bureau of 
Industry and Security Denied Parties List or Entity 
List, or the U.S. Office of Foreign Asset Control 
List of Specially Designated Nationals and Blocked 
Persons, or any similar lists maintained by other 
countries, and Customer will not export to anyone on 
such lists without the necessary export licenses.

10.  NOTICES.  All notices to Licensor under this 
Agreement must be delivered in writing in person, by 
courier or by certified or registered mail (postage 
prepaid and return receipt requested) at the 
following address and will be effective upon receipt: 
500 Arguello St., Suite 200, Redwood City, CA  94063, 
USA.  To be effective, such notice must be delivered 
to both (a) the legal department and (b) the Chief 
Executive Officer.   Customer agrees that Licensor 
may provide notice to Customer electronically via 
e-mail or by posting the notice on the website at 
which this Agreement or the Program Materials were 
made available. Receipt of any such notice is the day 
that the notice is sent or posted by Licensor.

11.  RELATIONSHIP OF THE PARTIES; BENEFICIARIES.  The 
parties hereto are independent contractors.  Nothing 
in this Agreement shall be deemed to create an agency, 
employment, partnership, fiduciary, or joint venture 
relationship between the parties.  There are no third 
party beneficiaries to this Agreement.

12.  REMEDIES.  Except as specifically provided 
otherwise in this Agreement, the parties' rights and 
remedies under this Agreement are cumulative and 
there shall be no obligation to exercise a particular 
remedy.  In the event of a party's breach of this 
Agreement, the non-breaching party may avail itself 
of all other rights, remedies and causes of action 
available at law, in equity or otherwise. Customer 
acknowledges that the Program Materials contain 
Licensor's valuable trade secrets and proprietary 
information and that any actual or threatened 
disclosure or unauthorized use or distribution of the 
Program Materials or Confidential Information will 
constitute immediate and irreparable harm to Licensor 
for which monetary damages would be an inadequate 
remedy and entitle Licensor to immediate injunctive 
relief without the need to post a bond or show actual 
monetary damages.

13.  FORCE MAJEURE.  Licensor shall not be liable to 
Customer for any failure or delay in performance 
caused by reasons beyond its control.

14.  GENERAL PROVISIONS.  Any action related to this 
Agreement, and the validity, performance, 
construction and interpretation of this Agreement 
shall be governed by laws of the State of California, 
United States of America, excluding its conflicts of 
laws rules, as applied to agreements entered into in 
California between California residents.  The 
provisions of the United Nations Convention on 
Contracts for the International Sale of Goods shall 
not apply to this Agreement. If any provision of this 
Agreement is held to be unenforceable, that shall not 
affect the enforceability of the remaining provisions. 
This Agreement may not be modified except in writing 
signed by a duly authorized representative of each 
party.  Customer may not assign this Agreement or any 
right granted hereunder, in whole or in part, without 
Licensor's prior written consent.  This Agreement 
represents the entire agreement between the parties 
and supersedes all prior agreements and understandings, 
whether written or oral, with respect to all matters 
covered in this Agreement.  This Agreement is 
executed in the English language.
Do you accept this license agreement? (y or n): y
Building package list...

II_SYSTEM: /opt/vectorwise30
II_INSTALLATION: V3

Invoking RPM...

Preparing...                ########################################### [100%]
   1:vectorwise             ########################################### [ 33%]
   2:vectorwise-dbms        ########################################### [ 67%]
   3:vectorwise-net         ########################################### [100%]
Building the password validation program 'ingvalidpw'.
Executable successfully installed.
Vectorwise 3.0.0 has installed successfully. 
The instance will now be started...

Vectorwise, instance V3 has not been setup
Running setup for Vectorwise 3.0.0-334...
    Running setup for dbms...
                                                              OK
    Running setup for net...
                                                              OK
    Running iisutm...
                                                              OK
    Running iisumgmtsvc...
                                                              OK
    Running iisulib...
Setting up the Vectorwise library...
                                                              OK
    Running iisudas...
                                                              OK
    Running iisuodbc...
                                                              OK
Starting Vectorwise, instance V3:                          [  OK  ]
Starting Remote Manager Service for instance V3:           [  OK  ]
Installing Director...

warning: /root/vectorwise/vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64/./rpm/director-1.1.0-207.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 7a05d128: NOKEY
Preparing...                ########################################### [100%]
   1:director               ########################################### [100%]
[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 
[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 
[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# 
[root@node1 vectorwise-3.0.0-334-NPTL-eval-linux-rpm-x86_64]# su - ingres
[ingres@node1 ~]$ ll

以ingres使用者登入，修改TERM_INGRES=dumb：


[ingres@node1 ~]$ vi .ingV3sh 

# vectorwise environment for V3 installation
# Generated at installation time, any changes made will be lost

export II_SYSTEM=/opt/vectorwise30
export PATH=$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility:$PATH
if [ "$LD_LIBRARY_PATH" ] ; then
    LD_LIBRARY_PATH=/usr/local/lib:$II_SYSTEM/ingres/lib:$LD_LIBRARY_PATH
else
    LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$II_SYSTEM/ingres/lib
fi
export LD_LIBRARY_PATH
export TERM_INGRES=dumb



將.ingV3sh檔案加入到ingres使用者的.bash_profile檔案裡：

. ~/.ingV3sh

使得ingres使用者登入自動匯入.ingV3sh指令碼。

使用ingres使用者建立資料庫：

[ingres@node1 ~]$ createdb ssb
Creating database 'ssb' . . .
 
  Creating DBMS System Catalogs . . . 
  Modifying DBMS System Catalogs . . . 
  Creating Standard Catalog Interface . . . 
  Creating Front-end System Catalogs . . . 

Creation of database 'ssb' completed successfully.
 
[ingres@node1 ~]$ 


建立SSB表結構：

* create table lineorder (
* lo_orderkey        bigint,
* lo_linenumber      int,
* lo_custkey         int,
* lo_partkey         int,
* lo_suppkey         int,
* lo_orderdate       int,
* lo_orderpriority   varchar(15),
* lo_shippriority    varchar(1),
* lo_quantity        int,
* lo_extendedprice   int,
* lo_ordtotalprice   int,
* lo_discount        int,
* lo_revenue         int,
* lo_supplycost      int,
* lo_tax             int,
* lo_commitdate      int,
* lo_shipmode        varchar(10) 
* ) ;
* \g
Executing . . .

continue
* 

* create table part (
* p_partkey    bigint, 
* p_name       varchar(22),
* p_mfgr       varchar(6),
* p_category   varchar(7),
* p_brand1     varchar(9),
* p_color      varchar(11),
* p_type       varchar(25),
* p_size       int,
* p_container  varchar(15)
* ) ;\g
Executing . . .

continue
* create table supplier (
* s_suppkey   int,
* s_name      varchar(25),
* s_address   varchar(25),
* s_city      varchar(10),
* s_nation    varchar(15),
* s_region    varchar(12),
* s_phone     varchar(15)
* ) ;\g
Executing . . .

continue
* create table customer (
* c_custkey      bigint,
* c_name         varchar(25),
* c_address      varchar(25),
* c_city         varchar(10),
* c_nation       varchar(15),
* c_region       varchar(12),
* c_phone        varchar(15),
* c_mktsegment   varchar(10)
* ) ;\g
Executing . . .

continue
* create table dwdate (
* d_datekey            int,
* d_date               varchar(18),
* d_dayofweek          varchar(9),
* d_month              varchar(9),
* d_year               int,
* d_yearmonthnum       int,
* d_yearmonth          varchar(7),
* d_daynuminweek       int,
* d_daynuminmonth      int,
* d_daynuminyear       int,
* d_monthnuminyear     int,
* d_weeknuminyear      int,
* d_sellingseason      varchar(12),
* d_lastdayinweekfl    int,
* d_lastdayinmonthfl   int,
* d_holidayfl          int,
* d_weekdayfl          int
* ) ;\g
Executing . . .

continue
* 
* 
* 
* 
* \q
Your SQL statement(s) have been committed.

Vectorwise Version VW 3.0.0 (a64.lnx/334)NPTL logout
Sun Jul 28 00:35:56 2013
[ingres@node1 bin]$ 

使用vwload工具快速匯入ssb資料：

[ingres@node1 bin]$ date;/opt/vectorwise30/ingres/bin/vwload --table lineorder ssb /opt/dbgen/lineorder.tbl;date                           Sun Jul 28 12:24:30 CST 2013
loading
processed 6001171 records, loaded 6001171 records, 0 errors
Sun Jul 28 12:28:05 CST 2013

[ingres@node1 bin]$ date;/opt/vectorwise30/ingres/bin/vwload --table part ssb /opt/dbgen/part.tbl;date               
Sun Jul 28 15:36:18 CST 2013
loading
processed 200000 records, loaded 200000 records, 0 errors
Sun Jul 28 15:36:22 CST 2013
[ingres@node1 bin]$ date;/opt/vectorwise30/ingres/bin/vwload --table supplier ssb /opt/dbgen/supplier.tbl;date    
Sun Jul 28 15:36:43 CST 2013
loading
processed 10000 records, loaded 10000 records, 0 errors
Sun Jul 28 15:36:43 CST 2013
[ingres@node1 bin]$ date;/opt/vectorwise30/ingres/bin/vwload --table customer ssb /opt/dbgen/customer.tbl;date        
Sun Jul 28 15:37:02 CST 2013
loading
processed 30000 records, loaded 30000 records, 0 errors
Sun Jul 28 15:37:06 CST 2013
[ingres@node1 bin]$ date;/opt/vectorwise30/ingres/bin/vwload --table dwdate ssb /opt/dbgen/date.tbl;date  
Sun Jul 28 15:37:58 CST 2013
loading
processed 2556 records, loaded 2556 records, 0 errors
Sun Jul 28 15:38:10 CST 2013
[ingres@node1 bin]$ 


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7220098/viewspace-767301/，如需轉載，請註明出處，否則將追究法律責任。

相關文章