리버's 아름다운 소풍

구글에서 이씨플라자로 소포를 하나 보내왔다. 우리회사는 구글 애드워즈 광고를 하는 - 금액은 그리 크지 않음- 광고주여서 연말이 되면 구글이 선물을 보내준다. 작년에는 전자앨범을 받았었는데, 선물을 받았다는 자체에 너무 신났었던것 같다.

Dare Obasanjo has done a comparison of two new protocols for accessing database style data via HTTP. These protocols, based on REST, are the Google Base and Microsoft's Astoria.

The basic concept between the two protocols is the same. URLs are used in lieu of SQL to specify queries. Relationships and filters must be encoded as part of the URL and all requests are GETs.

The first difference pointed out by Dare is that Astoria uses a hierarchical format to represent relationships. For example, to specify that you wanted the orders for customer key 5 you would have something like "/Customers[5]/Orders". Google Base, on the other hand, uses a flat model where categories and predicates have to be used to ferret out relationships.

Both support filtering and sorting, but Google Base has a richer syntax and support for full-text queries across all categories. Google Base does get a bit carried away however, with support for inline If/Else constructs.

Astoria does have a really nice feature called expand. It allows the user to indicate they also want the children nodes for the data they requested. This eliminates the need to perform 1+N queries to get a collection of rows and the related child rows. The data comes back as inline XML under the appropriate node.

Google Base likewise has some features not found in Astoria. For example one can turn on spelling correction, which works in a manner similar to Google Search. You can also filter out repetitive information using the Crowd feature. In the article, Dare requested, "all restaurants stored within Google Base but show no more than 2 per cuisine type".

Dare Obasanjo concludes:

In comparing both approaches there is a lot to like and dislike. I like the "expand" feature in Astoria as well as the fact that I can retrieve XML results from multiple paths of the hierarchy. However there does seem to be a paucity of operators and functions for better filtering of results.

From the Google Base data API, I love the "crowd" feature and having a full library of functions for performing tests within predicates. Also some of the operators such as the ones for finding results near a certain location are quite impressive although unnecessary for the majority of RESTful protocols out there. That said, I do think they went overboard on some of the features such as having if...else blocks within the URIs. I suspect that some of that complexity wouldn't have been needed if they just had hierarchies instead of a flat namespace that requires complex filtering to get anything out of it.

AdSenseBuddy는 구글 애드센스의 수익관리를 도와주는 윈두우용 어플이다. 설치를 해서 이름과 이메일을 쓰면 이메일로 등록키가 발송이 되고 이를 등록하면 사용할 수 있다. 난 등록까지는 됐는데 AdSesne에 로그인 하려고 하면 로그인이 되지 않는다. 한번 쓰고 싶은데, 혹시나 쓰시고 계신 분 없는지?

adsensebuddy.zip