Skip to Content

Happy New Year 2014 to you all!

If you miss the good old Sybase Nautilus (symbol of scalability) like I do, run this in Interactive SQL against a SQL Anywhere database (I used 12; 16 will probably work as good):

select 1 o, new ST_Polygon (new ST_Point (0, -1), new ST_Point (1, 0)) s
union all select 2, new ST_Polygon (new ST_Point (0, 0), new ST_Point (1, 1))
union all select 3, new ST_Polygon (new ST_Point (0, -1), new ST_Point (-2, 1))
union all select 4, new ST_Polygon (new ST_Point (-2, -1), new ST_Point (1, -4))
union all select 5, new ST_CircularString (new ST_Point (0, -1), new ST_Point (1, 0), new ST_Point (0, 1),
                    new ST_Point (-1*sqrt (2), sqrt (2)-1), new ST_Point (-2, -1),

                    new ST_Point (-1.5*sqrt (2)+1, -1-1.5*sqrt (2)), new ST_Point (1, -4))
order  by o;

While the query result may not be spectacular, the Spatial Viewer (Shift-F6) shows the Nautilus:

Nautilus.jpg

I unchecked the “Approximate” box and switched to outline drawing (Ctrl-P) for this representation.

As I hope you can see, the Nautilus is a graphical representation of the Fibonacci numbers, the integer equivalent of the exponential function.

This of course is only a faint glimpse of what you can do with Spatial Data in SQL Anywhere. Feel invited to have a closer look at the samples included in the installation.

For more content related to the SQL Anywhere cosmos, check out my postings in the SAP Services community, starting with SQL Anywhere – Your Flight Mode Database Server.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Reimer Pods

    Works great, but the output is multicolored:

    Nautilus.PNG

    What did you do to get the symbol in monochrome?

    Edit: don’t mind, I’ve found the appropriate button in the spatial viewer.

    (0) 

Leave a Reply