Spatial Data for Nautilumni

[Former Member]

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:

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 volkerstoeffler/content in the SAP Services community, starting with SQL Anywhere – Your Flight Mode Database Server.