Talk:Spatial database: Difference between revisions
m Signing comment by 202.133.55.135 - "→Merge Spatial Index: " |
m Maintain {{WPBS}}: 2 WikiProject templates. Keep majority rating "Start" in {{WPBS}}. Remove 1 same rating as {{WPBS}} in {{WikiProject Databases}}. Keep 1 different rating in {{WikiProject Geography}}. Tag: |
||
(9 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
{{WikiProject banner shell|class=Start| |
|||
{{ |
{{WikiProject Databases|importance=High}} |
||
{{WikiProject Geography|class=C|importance=Mid}} |
{{WikiProject Geography|class=C|importance=Mid}} |
||
}} |
|||
{{merged-from|Spatial index|August 3, 2011}} |
|||
{{COI editnotice}} |
|||
==Spatial Database and geodatabase== |
|||
Spatial Database is a more general term than Geo-database and should be retained. Historically, there is a debate between the adjectives "Geo" and "Spatial". However recent trend prefers "Spatial". For example, NSF chose the adjective "Spatial" in renaming the "Geography and Regional Sciences" program. <span style="font-size: smaller;" class="autosigned">—Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/128.101.34.46|128.101.34.46]] ([[User talk:128.101.34.46|talk]]) 22:37, 1 May 2009 (UTC)</span><!-- Template:UnsignedIP --> <!--Autosigned by SineBot--> |
Spatial Database is a more general term than Geo-database and should be retained. Historically, there is a debate between the adjectives "Geo" and "Spatial". However recent trend prefers "Spatial". For example, NSF chose the adjective "Spatial" in renaming the "Geography and Regional Sciences" program. <span style="font-size: smaller;" class="autosigned">—Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/128.101.34.46|128.101.34.46]] ([[User talk:128.101.34.46|talk]]) 22:37, 1 May 2009 (UTC)</span><!-- Template:UnsignedIP --> <!--Autosigned by SineBot--> |
||
Line 24: | Line 30: | ||
I would tend to disagree too but I don't feel strongly about it. [[User:Jason Quinn|Jason Quinn]] ([[User talk:Jason Quinn|talk]]) 02:21, 21 September 2010 (UTC) |
I would tend to disagree too but I don't feel strongly about it. [[User:Jason Quinn|Jason Quinn]] ([[User talk:Jason Quinn|talk]]) 02:21, 21 September 2010 (UTC) |
||
My instinct was to disagree, but then I realized there isn't too much content in [[Spatial index]] (nor would I expect a large article). I agree with a merge to a section of [[Spatial database]]. < |
My instinct was to disagree, but then I realized there isn't too much content in [[Spatial index]] (nor would I expect a large article). I agree with a merge to a section of [[Spatial database]]. <samp>+[[User:Mwtoews|<span style="color:#008000;">m</span>]][[User talk:Mwtoews|<span style="color:#6B3FA0;">t</span>]]</samp> 20:41, 28 February 2011 (UTC) |
||
I disagree of merging spatial index but under some circumstances it can be added as a subsection. <span style="font-size: smaller;" class="autosigned">—Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/202.133.55.135|202.133.55.135]] ([[User talk:202.133.55.135|talk]]) 04:37, 5 April 2011 (UTC)</span><!-- Template:UnsignedIP --> <!--Autosigned by SineBot--> |
I disagree of merging spatial index but under some circumstances it can be added as a subsection. <span style="font-size: smaller;" class="autosigned">—Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[Special:Contributions/202.133.55.135|202.133.55.135]] ([[User talk:202.133.55.135|talk]]) 04:37, 5 April 2011 (UTC)</span><!-- Template:UnsignedIP --> <!--Autosigned by SineBot--> |
||
I think merging spatial index as a subsection here would be a good idea; that subject is certainly a sub-area of the spatial database, and the current article ends up having to describe what a spatial database is, before it describes the index-specific information. [[User:MeekMark|MeekMark]] ([[User talk:MeekMark|talk]]) 20:34, 5 May 2011 (UTC) |
|||
== Example DDL and query == |
|||
I think an example of the [[data definition language|DDL]] required to create a simple spatial table, and sample [[Structured Query Language|SQL]] showing some features, would be quite helpful here. [[User:MeekMark|MeekMark]] ([[User talk:MeekMark|talk]]) 20:38, 5 May 2011 (UTC) |
|||
== Non-notable entry removed == |
|||
I have removed the recent - probably self-promotional - addition for GeoSpark, as it lacked any independent source let alone an existing Wikipedia article based on such sources. Wikipedia is no venue to promote relatively new applications, and editors with a likely conflict of interest should follow the guideline at [[WP:COI]]. [[User:GermanJoe|GermanJoe]] ([[User talk:GermanJoe|talk]]) 22:55, 22 October 2018 (UTC) |
Latest revision as of 20:59, 26 February 2024
This article is rated Start-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | ||||||||
|
The contents of the Spatial index page were merged into Spatial database on August 3, 2011. For the contribution history and old versions of the redirected page, please see its history; for the discussion at that location, see its talk page. |
Individuals with a conflict of interest, particularly those representing the subject of the article, are strongly advised not to directly edit the article. See Wikipedia:Conflict of interest. You may request corrections or suggest content here on the Talk page for independent editors to review, or contact us if the issue is urgent. |
Spatial Database and geodatabase
[edit]Spatial Database is a more general term than Geo-database and should be retained. Historically, there is a debate between the adjectives "Geo" and "Spatial". However recent trend prefers "Spatial". For example, NSF chose the adjective "Spatial" in renaming the "Geography and Regional Sciences" program. —Preceding unsigned comment added by 128.101.34.46 (talk) 22:37, 1 May 2009 (UTC)
I agree. A spatial database is not proprietary, but is a distinct type of spatial data tool. A geodatabase is primarily an ESRI product, and does not have the same query ability, or complex tabular management that may be found in a spatially enabled database. These topics should be seperate. SCmurky (talk) 07:07, 28 August 2009 (UTC)
I'm not sure the "Spatial Databox" product entry applies to this article. I have visited the linked page and it looks more like a web server to me, but I don't know the product, so I can not be sure. —Preceding unsigned comment added by 217.12.16.53 (talk) 09:57, 26 October 2009 (UTC)
I think that Spatial dataBase is more general than geodata base feels like the spatial data base is a super class and the geodata base is a sub class. —Preceding unsigned comment added by 212.118.13.124 (talk) 08:25, 22 December 2009 (UTC)
The term geodatabase is also a bit proprietary - having been used by ESRI to describe a database that includes (sometimes discipline specific) spatial objects and operators for those objects. Spatial database is more general term and is probably correct for this article. —Preceding unsigned comment added by 71.56.219.48 (talk) 05:12, 29 December 2009 (UTC)
"Spatial Database" in particular applies to any dimensionality; while "Geo-Database" somewhat implies a connection to the real world, i.e. 2D or 3D data models (on the spatial index / query key level, that is). So I'm opposed to a "full" merger; however it could make sense to include geo-databases in spatial databases. But there is also a lot to say about requirements specific to geodata, and optimizations possible on geodata, due to its physical properties. For example, euclidean distance is a physical bound for the distance. Such as restriction may not hold for arbitrary spatial databases. --Chire (talk) 17:17, 4 June 2010 (UTC)
I am sorry: this should be a clear no since the term "Geodatabase" is the name of a product by ESRI - whereas "Spatial Database" is a proper general software description (actually it should be Spatial Database Management System for the software since Spatial Database includes the data). 75.152.163.213 (talk) 21:40, 18 June 2010 (UTC)
Merge Spatial Index
[edit]The article Spatial index is currently only a stub, and should IMHO be merged into this article, in particular to differentiate it from the more specialized Geo-Databases subject. --Chire (talk) 11:18, 5 June 2010 (UTC)
I disagree - however it could be subsection. A Spatial Database is a software or a concept - while a Spatial Index is a data structure to query spatial data efficiently. 75.152.163.213 (talk) 21:40, 18 June 2010 (UTC)
I would tend to disagree too but I don't feel strongly about it. Jason Quinn (talk) 02:21, 21 September 2010 (UTC)
My instinct was to disagree, but then I realized there isn't too much content in Spatial index (nor would I expect a large article). I agree with a merge to a section of Spatial database. +mt 20:41, 28 February 2011 (UTC)
I disagree of merging spatial index but under some circumstances it can be added as a subsection. —Preceding unsigned comment added by 202.133.55.135 (talk) 04:37, 5 April 2011 (UTC)
I think merging spatial index as a subsection here would be a good idea; that subject is certainly a sub-area of the spatial database, and the current article ends up having to describe what a spatial database is, before it describes the index-specific information. MeekMark (talk) 20:34, 5 May 2011 (UTC)
Example DDL and query
[edit]I think an example of the DDL required to create a simple spatial table, and sample SQL showing some features, would be quite helpful here. MeekMark (talk) 20:38, 5 May 2011 (UTC)
Non-notable entry removed
[edit]I have removed the recent - probably self-promotional - addition for GeoSpark, as it lacked any independent source let alone an existing Wikipedia article based on such sources. Wikipedia is no venue to promote relatively new applications, and editors with a likely conflict of interest should follow the guideline at WP:COI. GermanJoe (talk) 22:55, 22 October 2018 (UTC)