1,609 Hits in 7.5 sec

Using Table Valued Functions in SQL Server 2005 To Implement a Spatial Data Library [article]

Jim Gray, Alex Szalay, Gyorgy Fekete
2007 arXiv   pre-print
That C# library is connected to SQL Server 2005 via a set of scalar-valued and table-valued functions. These functions act as a spatial index.  ...  This article explains how to add spatial search functions (point-near-point and point in polygon) to Microsoft SQL Server 2005 using C# and table-valued functions.  ...  The SQL Server 2005 data import wizard can be used to import the data (we have already done that in the sample database.)  ... 
arXiv:cs/0701163v1 fatcat:nrtp4amvo5ajzobziouqvdge7e

CfunBASE: A Cosmological Functions Library for Astronomical Databases

M. Taghizadeh-Popp
2010 Publications of the Astronomical Society of the Pacific  
Its primary use is in CasJobs/SkyServer, where the functions are ported into a MS-SQL Server database hosting the SDSS science archive, and can be executed through simple T-SQL commands.  ...  CfunBASE is a customizable C# cosmological functions library in the .NET framework.  ...  In this article we present CfunBASE, 3 a .NET framework library written in C# that contains functions relevant in cosmology and extragalactic astronomy, made ready to be uploaded into a MS-SQL 2005/2008  ... 
doi:10.1086/655666 fatcat:zbhz3txp7nfqhlc2zky4ppb37m

The Catalog Archive Server Database Management System

Ani R. Thakar, Alex Szalay, George Fekete, Jim Gray
2008 Computing in science & engineering (Print)  
The multiterabyte Sloan Digital Sky Survey's (SDSS's) catalog data is stored in a commercial relational database management system with SQL query access and a built-in query optimizer.  ...  The SDSS Catalog Archive Server adds advanced data mining features to the DBMS to provide fast online access to the data.  ...  The spherical HTM functions implemented in C# comprise an assembly (dynamically linked library) that extends SQL Server 2005 with new scalar and table-valued functions.  ... 
doi:10.1109/mcse.2008.15 fatcat:7c3ktnjurzea3m6vz5asgbj4wq

Array requirements for scientific applications and an implementation for microsoft SQL server

László Dobos, Alexander Szalay, José Blakeley, Tamás Budavári, István Csabai, Dragan Tomic, Milos Milovanovic, Marko Tintor, Andrija Jovanovic
2011 Proceedings of the EDBT/ICDT 2011 Workshop on Array Databases - AD '11  
We also present a working implementation of an array data type for Microsoft SQL Server 2008 to support large-scale scientific applications.  ...  A common feature of all these use cases is that subsetting and preprocessing the data on the server side (as far as possible inside the database server process) is necessary to avoid the client-server  ...  Acknowledgements The JHU group would like to thank the support of the Gordon and Betty Moore Foundation and Microsoft Research.  ... 
doi:10.1145/1966895.1966897 dblp:conf/edbt/DobosSBBCTMTJ11 fatcat:2ejl63oqcralddsl56fngnjoce

MonetDB/SQL Meets SkyServer: the Challenges of a Scientific Database

M. Ivanova, N. Nes, R. Goncalves, M. Kersten
2007 International Conference on Scientific and Statistical Database Management  
performance is competitive to the reference platform, MS SQL Server 2005, and 3) the analysis of SDSS query traces hints at several techniques to boost performance by utilizing repetitive behavior and  ...  However, the application also challenged the functionality of our implementation and revealed that a fully operational SQL environment is needed, e.g. including persistent stored modules; 2) the initial  ...  Acknowledgments The authors would like to thank to the SkyServer team for delivering the data. This work was supported by Bsik Bricks program.  ... 
doi:10.1109/ssdbm.2007.19 dblp:conf/ssdbm/IvanovaNGK07 fatcat:l7lp6i4imfcmvcyyyf25wzps3e

Graywulf: A platform for federated scientific databases and services [article]

László Dobos and Alexander S. Szalay and Tamás Budavári and István Csabai and Nolan Li
2013 arXiv   pre-print
a sophisticated workflow execution framework, and a SQL parser library.  ...  Queries are formulated in a slightly modified syntax of SQL that offers a transparent view of the distributed data.  ...  The project was also supported by the Hungarian grants OTKA 103244, NAP 2005/ KCKHA005 and the MAKOG Foundation.  ... 
arXiv:1308.1440v1 fatcat:35akjhyx3japfo4lw7mqot73g4

A Distributed GIS for Managing Shanghai Landscape Resources

Yue Zhu, Chaowei Yang, David W. Wong, Menas Kafatos
2005 Annals of GIS  
computer network, and (4) spatial data access through a spatial data engine.  ...  This paper suggests possible solutions to these four issues and illustrates how general landscape management functions are implemented through a Distributed GIS.  ...  Server side spatial data processing(SSDP) implementation The SSDP is based upon SQL Server 2000, and all the tables described before are managed by SQL Server 2000.  ... 
doi:10.1080/10824000509480598 fatcat:xpxnjv4xp5hnxfctlsdi6ok5o4

Spatial indexing in microsoft SQL server 2008

Yi Fang, Marc Friedman, Giri Nair, Michael Rys, Ana-Elisa Schmid
2008 Proceedings of the 2008 ACM SIGMOD international conference on Management of data - SIGMOD '08  
Microsoft SQL Server 2008 adds built-in support for 2-dimensional spatial data types for both planar and geodetic geometries to address the increasing demands for managing location-aware data.  ...  This paper will present an overview of the spatial indexing implementation in SQL Server 2008 and outline how the indexing is implemented and how the cost-based query optimizer chooses among the different  ...  SQL Server 2008 joins its peers in offering support for spatial data with a simple to use, OGC aligned spatial feature set.  ... 
doi:10.1145/1376616.1376737 dblp:conf/sigmod/FangFNRS08 fatcat:n57rrh2fkbdiponz6uykchnrba

Ophidia: Toward Big Data Analytics for eScience

S. Fiore, A. D'Anca, C. Palazzo, I. Foster, D.N. Williams, G. Aloisio
2013 Procedia Computer Science  
The Ophidia platform extends, in terms of both primitives and data types, current relational database system implementations (in particular MySQL) to enable efficient data analysis tasks on scientific  ...  To enable big data analytics it exploits well-known scientific numerical libraries, a distributed and hierarchical storage model and a parallel software framework based on the Message Passing Interface  ...  We use a few examples to illustrate some of the functionalities currently implemented.  ... 
doi:10.1016/j.procs.2013.05.409 fatcat:ro7oovrq7jentliudepivqejgm

A comparison of open source geospatial technologies for web mapping

Andrea Ballatore, Ali Tahir, Gavin McArdle, Michela Bertolotto
2011 International Journal of Web Engineering and Technology  
In order to implement this architecture, 14 projects were selected and analysed, including the client-side libraries and the server-side components.  ...  The past decade has witnessed a steady growth of open source software usage in industry and academia, leading to a complex ecosystem of projects.  ...  OpenLayers is a JavaScript library for displaying spatial data in web browsers, without server-side dependencies.  ... 
doi:10.1504/ijwet.2011.043440 fatcat:i2bz3gl5wjglhdvxxkm6w4mbpu

Indexing astronomical database tables using HTM and HEALPix [article]

Luciano Nicastro, Giorgio Calderone
2007 arXiv   pre-print
indexed using one or both these pixelisation schema in a completely transparent way.  ...  The DIF (Dynamic Indexing Facilities) package distributed within the MCS library, creates and manages a combination of Views, Triggers, DB-engine and plug-ins allowing the user to deal with database tables  ...  The last two parameters are the SQL expressions which convert to degrees the coordinate values contained in the table fields RAcs and DECcs.  ... 
arXiv:0711.4964v1 fatcat:ilbnsjgzm5hfjothiawq2nxwvi


H. Ostadabbas, H. Merz, H. Weippert
2021 The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences  
In recent years, efficient management of urban spatial data has played a major role in improving urban planning projects both in terms of cost and time savings.  ...  multimodal data for a proper workflow.  ...  Therefore, QGIS server which employs QGIS as a backend for GIS functions and map rendering, and Qt library will be used for graphical interface.  ... 
doi:10.5194/isprs-archives-xliii-b4-2021-307-2021 fatcat:6rrm3aeui5a6xkhatafzyu2qwi

Supporting Finite Element Analysis with a Relational Database Backend, Part I: There is Life beyond Files [article]

Gerd Heber, Jim Gray
2007 arXiv   pre-print
In this paper, we show how to use a Relational Database Management System in support of Finite Element Analysis.  ...  We believe it is a new way of thinking about data management in well-understood applications to prepare them for two major challenges, - size and integration (globalization).  ...  He would like to thank all members of the Cornell Fracture Group for years of inspiring collaborations and for their continued help in understanding the challenges of engineering.  ... 
arXiv:cs/0701159v1 fatcat:gjeiymo2mnantnvhozxptxxmle

Database Prebuffering as a Way to Create a Mobile Control and Information System with Better Response Time [chapter]

Ondrej Krejcar, Jindrich Cernohorsky
2008 Lecture Notes in Computer Science  
User location is used for data pre-buffering and pushing information from server to user's PDA. All server data is saved as artifacts (together) with its position information in building.  ...  The experimental framework prototype uses a WiFi network infrastructure to let a mobile device determine its indoor position.  ...  The application (locator) is now implemented in C# using the MS Visual Studio .NET 2005 with .NET compact framework and a special OpenNETCF library enhancement [6] .  ... 
doi:10.1007/978-3-540-69384-0_54 fatcat:oisj67ke6nfkjlfhrztf2a3lqm

A Survey on Spatio-temporal Data Analytics Systems [article]

Md Mahbub Alam and Luis Torgo and Albert Bifet
2021 arXiv   pre-print
real-world problems, a plethora of research and development work has been done in the area of spatial and spatio-temporal data analytics in the past decade.  ...  Due to the surge of spatio-temporal data volume, the popularity of location-based services and applications, and the importance of extracted knowledge from spatio-temporal data to solve a wide range of  ...  Redis [197] is an in-memory key-value store that has implemented a geohash spatial index to accelerate query processing.  ... 
arXiv:2103.09883v1 fatcat:ndpqz67bvnghpng36o3liqlr2q
« Previous Showing results 1 — 15 out of 1,609 results