大量的GPS数据该怎么存储？

[qwer_boo]

现在服务器端接收来自手机端的GPS采集数据，存储在数据库中是不是应该比文本文件中高效？那数据库中GPS数据该怎样定义呢？（也就是表的设计）

[qwer_boo]

也就是表中关于经纬度的存储的时候，怎么定义表？这样么： lat char(15) not null long char(15) not null

[qwer_boo]

引用 3 楼 ACMAIN_CHM 的回复:

参考MYSQL的地理信息数据库。

引用

11.13. Spatial Extensions MySQL supports spatial extensions to allow the generation, storage, and analysis of geographic features. These features are available for MyISAM, InnoDB, NDB, and ARCHIVE tables. For spatial columns, MyISAM supports both SPATIAL and non-SPATIAL indexes. Other storage engines support non-SPATIAL indexes, as described in Section 12.1.11, “CREATE INDEX Syntax”. This chapter covers the following topics: The basis of these spatial extensions in the OpenGIS geometry model Data formats for representing spatial data How to use spatial data in MySQL Use of indexing for spatial data MySQL differences from the OpenGIS specification Additional Resources The Open Geospatial Consortium publishes the OpenGIS® Simple Features Specifications For SQL, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial data. This specification is available from the OGC Web site at http://www.opengis.org/docs/99-049.pdf. If you have questions or concerns about the use of the spatial extensions to MySQL, you can discuss them in the GIS forum: http://forums.mysql.com/list.php?23. 11.13.1. Introduction to MySQL Spatial Support MySQL implements spatial extensions following the specification of the Open Geospatial Consortium (OGC). This is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial data

谢谢，研究一下`

[ACMAIN_CHM]

参考MYSQL的地理信息数据库。

引用

11.13. Spatial Extensions MySQL supports spatial extensions to allow the generation, storage, and analysis of geographic features. These features are available for MyISAM, InnoDB, NDB, and ARCHIVE tables. For spatial columns, MyISAM supports both SPATIAL and non-SPATIAL indexes. Other storage engines support non-SPATIAL indexes, as described in Section 12.1.11, “CREATE INDEX Syntax”. This chapter covers the following topics: The basis of these spatial extensions in the OpenGIS geometry model Data formats for representing spatial data How to use spatial data in MySQL Use of indexing for spatial data MySQL differences from the OpenGIS specification Additional Resources The Open Geospatial Consortium publishes the OpenGIS® Simple Features Specifications For SQL, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial data. This specification is available from the OGC Web site at http://www.opengis.org/docs/99-049.pdf. If you have questions or concerns about the use of the spatial extensions to MySQL, you can discuss them in the GIS forum: http://forums.mysql.com/list.php?23. 11.13.1. Introduction to MySQL Spatial Support MySQL implements spatial extensions following the specification of the Open Geospatial Consortium (OGC). This is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial data