Ingres Vectorwise 3.0评测

微生俊健

2023-12-01

一、下载并安装 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...

Running setup for net...

Running iisutm...

Running iisumgmtsvc...

Running iisulib...

Setting up the Vectorwise library...

Running iisudas...

Running iisuodbc...

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]# 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

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

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

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

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

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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7220098/viewspace-767301/

Ingres Vectorwise 3.0评测

相关阅读

相关文章

相关问答

相关文档