s

Size: px

Start display at page:

Download "s"

うきえいなおか
4 years ago
Views:

1 s

2 Google App Engine Bigtable

3 1 1.1 Google App Engine[1]( GAE) 1.2 GAE Eclipse 3.4 (Ganymede)[2] Google Plugin for Eclipse Google 2

4 1.3 [3] PostgreSQL[4] PostGIS[5] GoogleMaps[6] GAE 1.1: 3

5 2 2.1 ( ) 2 1. Infrastructure as a Service( IaaS) Software as a Service(SaaS) 2. IaaS 4

6 2.2 Google App Engine GAE Google Web Web GAE Key-ValueStore Bigtable 2.3 GAE Web Web GAE App Server GAE 5

7 2.1: GAE Eclipse 3.4 (Ganymede)[2] JAVA GAE Eclipse Google App Engine SDK for Java[7] appengine-java-sdk zip Eclipse Google Plugin for Eclipse 3.4[8] ~\workspace\project\war\web-inf\lib lucene-core zip lucene-snowball zip CSV commons-fileupload jar AppEngine API Java Data Object( JDO) 6

8 3 3.1 ( 1 ) App Server ( 2 ) App Server ( 3 ) Datastore ( 4 ) ( 5 ) 6 ( 7 ) ( 8 ) ( 9 ) (10 ) 3.1: 7

9 3.2 Google Maps API GEvent.addListener(map, click,onsmapclick); point.x point.y x y 8

10 3.3 Eclipse Google Eclipse ID appengine-web.xml war appengine-web.xml 3.2: appengine-web.xml application ID 4 version 3.4 [9] [10]

11 3.4.1 ID ID ID ID ID 1/ ( ) 1000 Google Maps km m 10

12 STRING 3.1: Double ID STRING Double X Double Y Double : : : : : : : : : : : : ID STRING Double X Y GEOMETRY Bigtable Double

13 3.4.2 ( ) ID ID ID ID ID STRING : ID ID STRING STRING LIST [u 10894, u 10424,, u ] : : : : [u 10792, u 10174,,u ] : : : : ( ) [u 10832, u 12741,,u ] 3.2 ID, ID STRING SQL LIKE Bigtable

14 3.4.3 ID ID ID ID ID ID ID ( ID) ID ID STRING 3.3: ID STRING INT STRING 1 STRING 132 STRING :30:00 0:00:00 : : : : : : : :20:00 0:00: :20:00 0:00: :20:00 0:00: :20:00 0:00:00 : : : : : : : :30:00 0:00: ID STRING ID INT TIME Bigtable STRING

15 3.4.4 ID ID STRING 3.4: TEXT LINESTRING( , ,, ) : : LINESTRING( , ,, ) : : LINESTRING( , ,, ) 3.4 ID STRING GEOMETRY LINESTRING Bigtable TEXT STRING TEXT STRING :

16 3.5 CSV JavaSDK JDO Java Persistence API( JPA) JDO GAE JDO JDO POJO 15

17 3.3: PersistentCapable Persistent PrimaryKey 16

18 3.5.2 PersistenceManager 3.4: 1. String split CSV 2. trim 3. ( close ) 17

19 3.6 Bigtable Bigtable Key-Value Store( KVS) 1 KVS Key( ) Value( ) Bigtable Key SQL SQL ( ) a) SQL SELECT ID FROM WHERE ID= AND day= 0 AND 10:59:00 ; b)bigtable SELECT FROM WHERE id= && day= 0 a) SELECT FROM b) a) WHERE AND b) && GAE m m 200m 100m 500m m 200m 100m 500m

20 ID PostgreSQL PostGIS DBMS PostgreSQL SQL SELECT FROM WHERE ST DWITHIN(, GeomFromText( POINT( ),SRID[4326]), [500m]) = TRUE WHERE GeomFromText() PostGIS () Geometry SRID POINT PostGIS () Bigtable PostGIS 19

21 3.5: 1. Y Y 500M 3.6: 20

22 2. 1 X 500M 3.7: 3. X Y 500M 3.8: 21

23 4. 500M 500M 3.9: (1264 ) ID ID SQL SELECT ID FROM WHERE LIKE %11220%10732% ; ID WHERE LIKE % 0 Bigtable LIKE 22

24 fts fts ID ID SQL SELECT ID FROM WHERE ID= AND day= 0 AND 10:59:00 ; Bigtable ID ID SELECT FROM WHERE id= && day= : ID ID 23

25 SELECT FROM WHERE id= && day= 0 && bus id= : ID SQL SELECT AsText( ) FROM WHERE ID = WHERE AsText( ) GEOMETRY WKT PostgreSQL GEOMETRY LINESTRING BigTable TEXT AsText( ) 24

26 3.8 JavaScript GoogleAPI 3.12: 25

27 4 GAE GAE 26

28 5 27

29 [1] [2] [3],2009 [4] [5] [6] [7] [8] [9] [10] 28

JTS Google App Engine S119325

JTS Google App Engine S119325 1 3 1.1.............................. 3 1.2.............................. 3 1.3.............................. 4 2 Google App Engine 5 2.1 Google App Engine.....................