At 05:59 21/06/00 +0900, Hiroshi Inoue wrote:
>
>Before the details of tablespace implementation,
>
>1) How to change(extend) the syntax of CREATE TABLE
> We only add table(data)space name with some
> keyword ? i.e Do we consider tablespace as an
> abstraction ?
>
It may be worth considering leaving the CREATE TABLE statement alone.
Dec/RDB uses a new statement entirely to define where a table goes. It's
actually a *very* complex statement, but the key syntax is:
CREATE STORAGE MAP <map-name> FOR <table-name> [PLACEMENT VIA INDEX <index-name>] STORE [COLUMNS ([col-name,])]
[IN<area-name> | RANDOMLY ACROSS <area-list>]
;
where <area-name> is the name of a Dec/RDB STORAGE AREA, which is basically
a file that contains one or more tables/indices etc. There are options to
specify area choice by column value, fullness, how to store BLOBs etc etc.
I realize that this is way too complex for a first pass, but it gives an
idea of where you *might* want to go, and hence, possibly, a reason for
starting out with something like:
CREATE STORAGE MAP <map-name> for <table-name> STORE IN <area-name>;
P.S. I really hope this is more cogent than my last message.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/