Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Hope ASE/ASA supports Spatial Geometry data storage

2 posts in Product Futures Discussion Last posting was on 2007-12-06 23:20:28.0Z
Sean Posted on 2007-12-06 11:56:33.0Z
Subject: Hope ASE/ASA supports Spatial Geometry data storage
From: Sean <hex.sean@gmail.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=gbk
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Content-Transfer-Encoding: 7bit
Message-ID: <op.t2wwshv1rkx0sm@sean-laptop>
User-Agent: Opera Mail/9.24 (Win32)
NNTP-Posting-Host: 221.221.185.174
X-Original-NNTP-Posting-Host: 221.221.185.174
Date: 6 Dec 2007 03:56:33 -0800
X-Trace: forums-1-dub 1196942193 221.221.185.174 (6 Dec 2007 03:56:33 -0800)
X-Original-Trace: 6 Dec 2007 03:56:33 -0800, 221.221.185.174
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1950
Article PK: 97558

As we know,
Oracle, DB2, Informix did support spatial extension several years ago.
(They support user-defined object data type.)
Such as,

to represent a point,
CREATE TYPE sdo_point_type AS OBJECT (
X NUMBER,
Y NUMBER,
Z NUMBER);
CREATE TYPE sdo_elem_info_array AS VARRAY (1048576) of NUMBER; (number
array type)
CREATE TYPE sdo_ordinate_array AS VARRAY (1048576) of NUMBER; (number
array type)


Now, SQL Server 2008 seems to support Geometry data type too.
Open Source MySQL, PostgreSQL seems support too.

These supports can largely extend database's usage.
They can be used in GIS, CAD and RS etc.

If ASE/ASE both support Geometry data storage, the ASA/Mobilink customer
can develope very pretty mobile GIS application.

And, for PowerBuilder, by extending DB interface to support access spatial
data, it can be extended to
develope Spatial Information System in PB.


Rob Verschoor Posted on 2007-12-06 23:20:28.0Z
Reply-To: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob Verschoor" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <op.t2wwshv1rkx0sm@sean-laptop>
Subject: Re: Hope ASE/ASA supports Spatial Geometry data storage
Lines: 40
Organization: Sypron B.V. / TeamSybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: dhcp-077-251-149-170.chello.nl
X-Original-NNTP-Posting-Host: dhcp-077-251-149-170.chello.nl
Message-ID: <475883bc$1@forums-1-dub>
Date: 6 Dec 2007 15:20:28 -0800
X-Trace: forums-1-dub 1196983228 77.251.149.170 (6 Dec 2007 15:20:28 -0800)
X-Original-Trace: 6 Dec 2007 15:20:28 -0800, dhcp-077-251-149-170.chello.nl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1951
Article PK: 97557

Already answered in sybase.public.ase.general.
Please don't cross-post.

Rob V.

"Sean" <hex.sean@gmail.com> wrote in message
news:op.t2wwshv1rkx0sm@sean-laptop...
> As we know,
> Oracle, DB2, Informix did support spatial extension several years ago.
> (They support user-defined object data type.)
> Such as,
>
> to represent a point,
> CREATE TYPE sdo_point_type AS OBJECT (
> X NUMBER,
> Y NUMBER,
> Z NUMBER);
> CREATE TYPE sdo_elem_info_array AS VARRAY (1048576) of NUMBER; (number
> array type)
> CREATE TYPE sdo_ordinate_array AS VARRAY (1048576) of NUMBER; (number
> array type)
>
>
> Now, SQL Server 2008 seems to support Geometry data type too.
> Open Source MySQL, PostgreSQL seems support too.
>
> These supports can largely extend database's usage.
> They can be used in GIS, CAD and RS etc.
>
> If ASE/ASE both support Geometry data storage, the ASA/Mobilink customer
> can develope very pretty mobile GIS application.
>
> And, for PowerBuilder, by extending DB interface to support access spatial
> data, it can be extended to
> develope Spatial Information System in PB.
>