Kouhei Sutou
null+****@clear*****
Thu Oct 15 23:31:52 JST 2015
Kouhei Sutou 2015-10-15 23:31:52 +0900 (Thu, 15 Oct 2015) New Revision: 687cc708b849d418ba3934379a45eaad4f04ea44 https://github.com/pgroonga/pgroonga.github.io/commit/687cc708b849d418ba3934379a45eaad4f04ea44 Message: Start translating tutorial Added files: _po/ja/tutorial/index.po Copied files: ja/tutorial/index.md (from tutorial/index.md) Modified files: tutorial/index.md Added: _po/ja/tutorial/index.po (+1025 -0) 100644 =================================================================== --- /dev/null +++ _po/ja/tutorial/index.po 2015-10-15 23:31:52 +0900 (bd7f117) @@ -0,0 +1,1025 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2015-10-15 23:31+0900\n" +"Language: ja\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=1; plural=0;\n" + +msgid "" +"---\n" +"title: Tutorial\n" +"layout: en\n" +"---" +msgstr "" +"---\n" +"title: チュートリアル\n" +"layout: ja\n" +"---" + +msgid "# Tutorial" +msgstr "# チュートリアル" + +msgid "" +"This document describes how to use PGroonga step by step. If you don't install" +" PGroonga yet, [install](../install/) PGroonga before you read this document." +msgstr "" +"このドキュメントはPGroongaの使い方を段階を追って説明します。まだPGroongaをインストールしていない場合は、このドキュメントを読む前にPGroo" +"ngaを[インストール](../install/)してください。" + +msgid "" +"You can use PGroonga as fast full text search index. You can also use PGroonga" +" as more general index for equality condition (`=`) and comparison conditions " +"(`<`, `>=` and so on)." +msgstr "PGroongaは高速な全文検索インデックスを提供します。さらに、等価条件（`=`）・比較条件（`<`や`>=`など）用の一般的なインデックスも提供します。" + +msgid "" +"PostgreSQL provides GiST and GIN as bundled indexes. You can use PGroonga as a" +"lternative of GiST and GIN. See [PGroonga versus GiST and GIN](../reference/pg" +"roonga-versus-gist-and-gin.html) for differences of them." +msgstr "" +"PostgreSQLは組み込みのインデックスとしてGiSTとGINを提供しています。PGroongaはGiST・GINの代わりに使うことができます。PGro" +"ongaとGiST・GINの違いは[PGroonga対GiST・GIN](../reference/pgroonga-versus-gist-and-gin" +".html)を参照してください。" + +msgid "This document describes about the followings:" +msgstr "このドキュメントは次のことを説明します。" + +msgid "" +" * How to use PGroonga as index for full text search\n" +" * How to use PGroonga as index for equality condition and comparison conditi" +"ons\n" +" * How to use PGroonga as index for array\n" +" * How to use PGroonga as index for JSON\n" +" * How to use Groonga throw PGroonga (advanced topic)" +msgstr "" +" * PGroongaを全文検索用インデックスとして使う方法\n" +" * PGroongaを等価条件・比較条件用インデックスとして使う方法\n" +" * PGroongaを配列用インデックスとして使う方法\n" +" * PGroongaをJSON用インデックスとして使う方法\n" +" * PGroonga経由でGroongaを使う方法（高度な話題）" + +msgid "## Full text search" +msgstr "## 全文検索" + +msgid "This section describes about the followings:" +msgstr "このセクションでは次のことを説明します。" + +msgid "" +" * How to prepare PGroonga based full text search system\n" +" * Operators for full text search\n" +" * Score" +msgstr "" +" * PGroongaベースの全文検索システムの準備方法\n" +" * 全文検索用の演算子\n" +" * スコアー" + +msgid "### How to prepare PGroonga based full text search system" +msgstr "### PGroongaベースの全文検索システムの準備方法" + +msgid "" +"This section describes about how to prepare PGroonga based full text search sy" +"stem." +msgstr "このセクションはPGroongaベースの全文検索システムの準備方法を説明します。" + +msgid "Create a column that you want to enable full text search as `text` type:" +msgstr "全文検索をしたいカラムを`text`型のカラムとして作ります。" + +msgid "" +"```sql\n" +"CREATE TABLE memos (\n" +" id integer,\n" +" content text\n" +");\n" +"```" +msgstr "" + +msgid "`memos.content` column is a full text search target column." +msgstr "`memos.content`カラムが全文検索対象のカラムです。" + +msgid "Create a `pgroonga` index against the column:" +msgstr "このカラムに対して`pgroonga`インデックスを作ります。" + +msgid "" +"```\n" +"CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);\n" +"```" +msgstr "" + +msgid "" +"See [CREATE INDEX USING pgroonga](../reference/create-index-using-pgroonga.htm" +"l) for more details." +msgstr "" +"詳細は[CREATE INDEX USING pgroonga](../reference/create-index-using-pgroonga.html" +")を参照してください。" + +msgid "Insert test data:" +msgstr "テストデータを挿入します。" + +msgid "" +"```sql\n" +"INSERT INTO memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。');\n" +"INSERT INTO memos VALUES (2, 'Groongaは日本語対応の高速な全文検索エンジンです。');\n" +"INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です" +"。');\n" +"INSERT INTO memos VALUES (4, 'groongaコマンドがあります。');\n" +"```" +msgstr "" + +msgid "Disable sequential scan to ensure using `pgroonga` index:" +msgstr "確実に`pgroonga`インデックスを使うためにシーケンシャルスキャンを無効にします。" + +msgid "" +"```sql\n" +"SET enable_seqscan = off;\n" +"```" +msgstr "" + +msgid "" +"NOTE: You should not disable sequential scan on production environment. This i" +"s only for test." +msgstr "注意：本番環境ではシーケンシャルスキャンを無効にするべきではありません。これはテスト用の設定です。" + +msgid "### Operators for full text search" +msgstr "### 全文検索用演算子" + +msgid "There are the following operators to perform full text search:" +msgstr "全文検索をする場合は次の演算子を使います。" + +msgid "" +" * `%%`\n" +" * `@@`\n" +" * `LIKE`" +msgstr "" + +msgid "#### `%%` operator" +msgstr "#### `%%`演算子" + +msgid "You can use `%%` operator to perform full text search by one word:" +msgstr "1語で全文検索を実行する場合は`%%`演算子を使います。" + +msgid "" +"```sql\n" +"SELECT * FROM memos WHERE content %% '全文検索';" +msgstr "" + +msgid "" +"-- id | content\n" +"-- ----+---------------------------------------------------\n" +"-- 2 | Groongaは日本語対応の高速な全文検索エンジンです。\n" +"-- (1 row)\n" +"```" +msgstr "" + +msgid "See [%% operator](../reference/operators/match.html) for more details." +msgstr "詳細は[%% operator](../reference/operators/match.html)を参照してください。" + +msgid "#### `@@` operator" +msgstr "#### `@@`演算子" + +msgid "" +"You can use `@@` operator to perform full text search by query syntax such as " +"`keyword1 OR keyword2`:" +msgstr "`キーワード1 OR キーワード2`というようなクエリー構文を使って全文検索を実行する場合は`@@`演算子を使います。" + +msgid "" +"```sql\n" +"SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL';\n" +"-- id | content\n" +"-- ----+----------------------------------------------------------------------" +"-----\n" +"-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\n" +"-- 1 | PostgreSQLはリレーショナル・データベース管理システムです。\n" +"-- (2 rows)\n" +"```" +msgstr "" + +msgid "" +"Query syntax is similar to syntax of Web search engine. For example, you can u" +"se `OR` to merge result sets of performing full text search by two or more wor" +"ds. In the above example, you get a merged result set. The merged result set h" +"as records that includes `PGroonga` or `PostgreSQL`." +msgstr "" +"クエリー構文はWeb検索エンジンの構文と似ています。たとえば、`OR`を使うと複数のキーワードでの全文検索結果をマージできます。上の例ではマージされた結果が" +"返ってきています。`PGroonga`または`PostgreSQL`を含むレコードがマージされた結果になります。" + +msgid "" +"See [Groonga document](http://groonga.org/docs/reference/grn_expr/query_syntax" +".html) for full query syntax." +msgstr "" +"クエリー構文の詳細は[Groongaのドキュメント](http://groonga.org/ja/docs/reference/grn_expr/query" +"_syntax.html)を参照してください。" + +msgid "See [`@@` operator](../reference/operators/query.html) for more details." +msgstr "詳細は[`@@`演算子](../reference/operators/query.html)を参照してください。" + +msgid "#### `LIKE` operator" +msgstr "#### `LIKE`演算子" + +msgid "" +"PGroonga supports `LIKE` operator. You can perform fast full text search by PG" +"roonga without changing existing SQL." +msgstr "PGroongaは`LIKE`演算子をサポートしています。既存のSQLを変更しなくてもPGroongaを使った高速な全文検索を実現できます。" + +msgid "`column LIKE '%keyword%'` equals to `column %% 'keyword'`:" +msgstr "`column LIKE '%キーワードd%'`は`column %% 'キーワード'`と等価です。" + +msgid "See [`LIKE` operator](../reference/operators/like.html) for more details." +msgstr "詳細は[`LIKE`演算子](../reference/operators/like.html)を参照してください。" + +msgid "{: #score}" +msgstr "" + +msgid "### Score" +msgstr "### スコアー" + +msgid "" +"You can use `pgroonga.score` function to get precision as a number. If a recor" +"d is more precision against searched query, the record has more higher number." +msgstr "" + +msgid "" +"You need to add primary key column into `pgroonga` index to use `pgroonga.scor" +"e` function. If you don't add primary key column into `pgroonga` index, `pgroo" +"nga.score` function always returns `0`." +msgstr "" + +msgid "Here is a sample schema that includes primary key into indexed columns:" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE score_memos (\n" +" id integer PRIMARY KEY,\n" +" content text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_score_memos_content_index\n" +" ON score_memos\n" +" USING pgroonga (id, content);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO score_memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。');\n" +"INSERT INTO score_memos VALUES (2, 'Groongaは日本語対応の高速な全文検索エンジンです。');\n" +"INSERT INTO score_memos VALUES (3, 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの" +"拡張機能です。');\n" +"INSERT INTO score_memos VALUES (4, 'groongaコマンドがあります。');\n" +"```" +msgstr "" + +msgid "Perform full text search and get score." +msgstr "" + +msgid "" +"```sql\n" +"SELECT *, pgroonga.score(score_memos)\n" +" FROM score_memos\n" +" WHERE content %% 'PGroonga' OR content %% 'PostgreSQL';\n" +"-- id | content " +" | score \n" +"-- ----+----------------------------------------------------------------------" +"-----+-------\n" +"-- 1 | PostgreSQLはリレーショナル・データベース管理システムです。 | 1\n" +"-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。 | 2\n" +"-- (2 rows)\n" +"```" +msgstr "" + +msgid "" +"You can sort matched records by precision ascending by using `pgroonga.score` " +"function in `ORDER BY` clause:" +msgstr "" + +msgid "" +"```sql\n" +"SELECT *, pgroonga.score(score_memos)\n" +" FROM score_memos\n" +" WHERE content %% 'PGroonga' OR content %% 'PostgreSQL'\n" +" ORDER BY pgroonga.score(score_memos) DESC;\n" +"-- id | content " +" | score \n" +"-- ----+----------------------------------------------------------------------" +"-----+-------\n" +"-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。 | 2\n" +"-- 1 | PostgreSQLはリレーショナル・データベース管理システムです。 | 1\n" +"-- (2 rows)\n" +"```" +msgstr "" + +msgid "" +"See [`pgroonga.score` function](../reference/functions/pgroonga-score.html) fo" +"r more details such as how to compute precision." +msgstr "" + +msgid "{: #snippet}" +msgstr "" + +msgid "### Snippet (KWIC, keyword in context)" +msgstr "" + +msgid "" +"You can use `pgroonga.snippet_html` function to get texts around keywords from" +" search target text. It's also known as [KWIC](https://en.wikipedia.org/wiki/K" +"ey_Word_in_Context) (keyword in context). You can see it in search result on W" +"eb search engine." +msgstr "" + +msgid "Here is a sample text for description. It's a description about Groonga." +msgstr "" + +msgid "" +"> Groonga is a fast and accurate full text search engine based on inverted ind" +"ex. One of the characteristics of Groonga is that a newly registered document " +"instantly appears in search results. Also, Groonga allows updates without read" +" locks. These characteristics result in superior performance on real-time appl" +"ications." +msgstr "" + +msgid "" +"There are some `fast` keywords. `pgroonga.snippet_html` extracts texts around " +"`fast`. Keywords in extracted texts are surround with `<span class=\"keyword\">`" +" and `</span>`." +msgstr "" + +msgid "" +"`html` in `pgroonga.snippet_html` means that this function returns result for " +"HTML output." +msgstr "" + +msgid "Here is the result of `pgroonga.snippet_html` against the above text:" +msgstr "" + +msgid "" +"> Groonga is a <span class=\"keyword\">fast</span> and accurate full text search" +" engine based on inverted index. One of the characteristics of Groonga is that" +" a newly registered document instantly appears in search results. Also, Gro" +msgstr "" + +msgid "" +"This function can be used for all texts. It's not only for search result by PG" +"roonga." +msgstr "" + +msgid "" +"Here is a sample SQL that describe about it. You can use the function in the f" +"ollowing `SELECT` that doesn't have `FROM`. Note that [`unnest`](http://www.po" +"stgresql.org/docs/current/static/functions-array.html) is a PostgreSQL functio" +"n that converts an array to rows." +msgstr "" + +msgid "" +"```sql\n" +"SELECT unnest(pgroonga.snippet_html(\n" +" 'Groonga is a fast and accurate full text search engine based on ' ||\n" +" 'inverted index. One of the characteristics of Groonga is that a ' ||\n" +" 'newly registered document instantly appears in search results. ' ||\n" +" 'Also, Groonga allows updates without read locks. These characteristics ' ||" +"\n" +" 'result in superior performance on real-time applications.' ||\n" +" '\n" +"' ||\n" +" '\n" +"' ||\n" +" 'Groonga is also a column-oriented database management system (DBMS). ' ||\n" +" 'Compared with well-known row-oriented systems, such as MySQL and ' ||\n" +" 'PostgreSQL, column-oriented systems are more suited for aggregate ' ||\n" +" 'queries. Due to this advantage, Groonga can cover weakness of ' ||\n" +" 'row-oriented systems.',\n" +" ARRAY['fast', 'PostgreSQL']));\n" +" " +" -- unnest " +" " +"\n" +"-- ---------------------------------------------------------------------------" +"------------------------------------------------------------------------------" +"------------------------------------------------------------------------------" +"\n" +"-- Groonga is a <span class=\"keyword\">fast</span> and accurate full text sear" +"ch engine based on inverted index. One of the characteristics of Groonga is th" +"at a newly registered document instantly appears in search results. Also, Gro\n" +"-- ase management system (DBMS). Compared with well-known row-oriented system" +"s, such as MySQL and <span class=\"keyword\">PostgreSQL</span>, column-oriented " +"systems are more suited for aggregate queries. Due to this advantage, Groonga\n" +"-- (2 rows)\n" +"```" +msgstr "" + +msgid "" +"See [`pgroonga.snippet_html` function](../reference/functions/pgroonga-snippet" +"-html.html) for more details." +msgstr "" + +msgid "## Equality condition and comparison conditions" +msgstr "" + +msgid "" +"You can use PGroonga for equality condition and comparison conditions. There a" +"re some differences between how to create index for string types and other typ" +"es. There is no difference between how to write condition for string types and" +" other types." +msgstr "" + +msgid "" +" * How to use PGroonga for not string types\n" +" * How to use PGroonga for string types" +msgstr "" + +msgid "### How to use PGroonga for not string types" +msgstr "" + +msgid "" +"You can use PGroonga for not string types such as number. You can use equality" +" condition and comparison conditions against these types." +msgstr "" + +msgid "Create index with `USING pgroonga`:" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE ids (\n" +" id integer\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_id_index ON ids USING pgroonga (id);\n" +"```" +msgstr "" + +msgid "" +"The special SQL to use PGroonga is only `CREATE INDEX`. You can use SQL for B-" +"tree index to use PGroonga." +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO ids VALUES (1);\n" +"INSERT INTO ids VALUES (2);\n" +"INSERT INTO ids VALUES (3);\n" +"```" +msgstr "" + +msgid "Disable sequential scan:" +msgstr "" + +msgid "Search:" +msgstr "" + +msgid "" +"```sql\n" +"SELECT * FROM ids WHERE id <= 2;\n" +"-- id\n" +"-- ----\n" +"-- 1\n" +"-- 2\n" +"-- (2 rows)\n" +"```" +msgstr "" + +msgid "### How to use PGroonga for string types" +msgstr "" + +msgid "" +"You need to use `varchar` type to use PGroonga as an index for equality condit" +"ion and comparison conditions against string." +msgstr "" + +msgid "" +"You must to specify the maximum number of characters of `varchar` to satisfy t" +"hat the maximum byte size of the column is equal to 4096 byte or smaller. Rela" +"tion between the maximum number of characters and the maximum byte size is rel" +"ated to encoding. For example, you must to specify 1023 or smaller as the maxi" +"mum number of characters for UTF-8 encoding. Because UTF-8 encoding `varchar` " +"keeps 4 byte for one character." +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE tags (\n" +" id integer,\n" +" tag varchar(1023)\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tag_index ON tags USING pgroonga (tag);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO tags VALUES (1, 'PostgreSQL');\n" +"INSERT INTO tags VALUES (2, 'Groonga');\n" +"INSERT INTO tags VALUES (3, 'Groonga');\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"SELECT * FROM tags WHERE tag = 'Groonga';\n" +"-- id | tag\n" +"-- ----+---------\n" +"-- 2 | Groonga\n" +"-- 3 | Groonga\n" +"-- (2 rows)\n" +"--\n" +"```" +msgstr "" + +msgid "## How to use PGroonga for array" +msgstr "" + +msgid "" +"You can use PGroonga as an index for array of `text` type or array of `varchar" +"`." +msgstr "" + +msgid "" +"You can perform full text search against array of `text` type. If one or more " +"elements in an array are matched, the record is matched." +msgstr "" + +msgid "" +"You can perform equality condition against array of `varchar` type. If one or " +"more elements in an array are matched, the record is matched. It's useful for " +"tag search." +msgstr "" + +msgid "" +" * How to use PGroonga for `text` type of array\n" +" * How to use PGroonga for `varchar` type of array" +msgstr "" + +msgid "### How to use PGroonga for `text` type of array" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE docs (\n" +" id integer,\n" +" sections text[]\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_sections_index ON docs USING pgroonga (sections);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO docs\n" +" VALUES (1,\n" +" ARRAY['PostgreSQLはリレーショナル・データベース管理システムです。',\n" +" 'PostgreSQLは部分的に全文検索をサポートしています。']);\n" +"INSERT INTO docs\n" +" VALUES (2,\n" +" ARRAY['Groongaは日本語対応の高速な全文検索エンジンです。',\n" +" 'Groongaは他のシステムに組み込むことができます。']);\n" +"INSERT INTO docs\n" +" VALUES (3,\n" +" ARRAY['PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。',\n" +" 'PostgreSQLに高機能な全文検索機能を追加します。']);\n" +"```" +msgstr "" + +msgid "" +"You can use `%%` operator or `@@` operator for full text search. The full text" +" search doesn't care about the position of element." +msgstr "" + +msgid "" +"```sql\n" +"SELECT * FROM docs WHERE sections %% '全文検索';\n" +"-- id | sections " +" \n" +"-- ----+----------------------------------------------------------------------" +"------------------------------------------------------\n" +"-- 1 | {PostgreSQLはリレーショナル・データベース管理システムです。,PostgreSQLは部分的に全文検索をサポートしています。}\n" +"-- 2 | {Groongaは日本語対応の高速な全文検索エンジンです。,Groongaは他のシステムに組み込むことができます。}\n" +"-- 3 | {PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。,PostgreSQLに高機能な全文検" +"索機能を追加します。}\n" +"-- (3 rows)\n" +"```" +msgstr "" + +msgid "### How to use PGroonga for `varchar` type of array" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE products (\n" +" id integer,\n" +" name text,\n" +" tags varchar(1023)[]\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tags_index ON products USING pgroonga (tags);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO products\n" +" VALUES (1,\n" +" 'PostgreSQL',\n" +" ARRAY['PostgreSQL', 'RDBMS']);\n" +"INSERT INTO products\n" +" VALUES (2,\n" +" 'Groonga',\n" +" ARRAY['Groonga', 'full-text search']);\n" +"INSERT INTO products\n" +" VALUES (3,\n" +" 'PGroonga',\n" +" ARRAY['PostgreSQL', 'Groonga', 'full-text search']);\n" +"```" +msgstr "" + +msgid "" +"You can use `%%` operator to find records that have one or more matched elemen" +"ts. If element's value equals to queried value, the element is treated as matc" +"hed." +msgstr "" + +msgid "" +"```sql\n" +"SELECT * FROM products WHERE tags %% 'PostgreSQL';\n" +"-- id | name | tags \n" +"-- ----+------------+-----------------------------------------\n" +"-- 1 | PostgreSQL | {PostgreSQL,RDBMS}\n" +"-- 3 | PGroonga | {PostgreSQL,Groonga,\"full-text search\"}\n" +"-- (2 行)\n" +"```" +msgstr "" + +msgid "{: #json}" +msgstr "" + +msgid "## How to use PGroonga for JSON" +msgstr "" + +msgid "" +"PGroonga also supports `jsonb` type. You can search JSON data by one or more k" +"eys and/or one or more values with PGroonga." +msgstr "" + +msgid "" +"You can also search JSON data by full text search against all text values in J" +"SON. It's an unique feature of PGroonga. Built-in PostgreSQL features and [JsQ" +"uery](https://github.com/postgrespro/jsquery) don't support it." +msgstr "" + +msgid "Think about the following JSON:" +msgstr "" + +msgid "" +"```json\n" +"{\n" +" \"message\": \"Server is started.\",\n" +" \"host\": \"www.example.com\",\n" +" \"tags\": [\n" +" \"web\",\n" +" ]\n" +"}\n" +"```" +msgstr "" + +msgid "" +"You can find the JSON by full text search with `search`, `example` or `web` be" +"cause all text values are full text search target." +msgstr "" + +msgid "PGroonga provides the following two operators for searching against `jsonb`:" +msgstr "" + +msgid "" +" * `@>` operator\n" +" * `@@` operator" +msgstr "" + +msgid "" +"[`@>` operator is a built-in PostgreSQL operator](http://www.postgresql.org/do" +"cs/current/static/functions-json.html#FUNCTIONS-JSONB-OP-TABLE). `@>` returns " +"true when the right hand side `jsonb` is a subset of left hand side `jsonb`." +msgstr "" + +msgid "You can execute `@>` faster by PGroonga." +msgstr "" + +msgid "" +"`@@` operator is a PGroonga original operator. You can use complex condition t" +"hat can't be written by `@>` operator such as range search." +msgstr "" + +msgid "### Sample schema and data" +msgstr "" + +msgid "Here are sample schema and data for examples:" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE logs (\n" +" record jsonb\n" +");" +msgstr "" + +msgid "CREATE INDEX pgroonga_logs_index ON logs USING pgroonga (record);" +msgstr "" + +msgid "" +"INSERT INTO logs\n" +" VALUES ('{\n" +" \"message\": \"Server is started.\",\n" +" \"host\": \"www.example.com\",\n" +" \"tags\": [\n" +" \"web\",\n" +" \"example.com\"\n" +" ]\n" +" }');\n" +"INSERT INTO logs\n" +" VALUES ('{\n" +" \"message\": \"GET /\",\n" +" \"host\": \"www.example.com\",\n" +" \"code\": 200,\n" +" \"tags\": [\n" +" \"web\",\n" +" \"example.com\"\n" +" ]\n" +" }');\n" +"INSERT INTO logs\n" +" VALUES ('{\n" +" \"message\": \"Send to <info �� example.com>.\",\n" +" \"host\": \"mail.example.net\",\n" +" \"tags\": [\n" +" \"mail\",\n" +" \"example.net\"\n" +" ]\n" +" }');\n" +"```" +msgstr "" + +msgid "{: #jsonb-contain}" +msgstr "" + +msgid "### `@>` operator" +msgstr "" + +msgid "" +"`@>` operator specify search condition by `jsonb` value. If condition `jsonb` " +"value is a subset of the search target `jsonb` value, `@>` operator returns `t" +"rue`." +msgstr "" + +msgid "Here is an example:" +msgstr "" + +msgid "" +"(It uses [`jsonb_pretty()` function](http://www.postgresql.org/docs/devel/stat" +"ic/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE) provided since Postgre" +"SQL 9.5 for readability.)" +msgstr "" + +msgid "" +"```sql\n" +"SELECT jsonb_pretty(record) FROM logs WHERE record @> '{\"host\": \"www.example.c" +"om\"}'::jsonb;\n" +"-- jsonb_pretty \n" +"-- -------------------------------------\n" +"-- { +\n" +"-- \"host\": \"www.example.com\", +\n" +"-- \"tags\": [ +\n" +"-- \"web\", +\n" +"-- \"example.com\" +\n" +"-- ], +\n" +"-- \"message\": \"Server is started.\"+\n" +"-- }\n" +"-- { +\n" +"-- \"code\": 200, +\n" +"-- \"host\": \"www.example.com\", +\n" +"-- \"tags\": [ +\n" +"-- \"web\", +\n" +"-- \"example.com\" +\n" +"-- ], +\n" +"-- \"message\": \"GET /\" +\n" +"-- }\n" +"-- (2 rows)\n" +"```" +msgstr "" + +msgid "" +"See [`@>` operator](../reference/operators/jsonb-contain.html) for more detail" +"s." +msgstr "" + +msgid "### `@@` operator" +msgstr "" + +msgid "" +"`@@` operator is a PGroonga original operator. You can write complex condition" +" that can't be written by `@>` operator such as range search." +msgstr "" + +msgid "" +"Here is an example for range search. The `SELECT` returns records that is matc" +"hed with the following conditions:" +msgstr "" + +msgid "" +" * `code` key exists at the top-level object\n" +" * Value of the `code` is greater than or equal to `200` and less than `300`" +msgstr "" + +msgid "" +"```sql\n" +"SELECT jsonb_pretty(record) FROM logs WHERE record @@ 'paths @ \".code\" && numb" +"er >= 200 && number < 300';\n" +"-- jsonb_pretty \n" +"-- --------------------------------\n" +"-- { +\n" +"-- \"code\": 200, +\n" +"-- \"host\": \"www.example.com\",+\n" +"-- \"tags\": [ +\n" +"-- \"web\", +\n" +"-- \"example.com\" +\n" +"-- ], +\n" +"-- \"message\": \"GET /\" +\n" +"-- }\n" +"-- (1 row)\n" +"```" +msgstr "" + +msgid "" +"See [`@@` operator for `jsonb`](../reference/operators/jsonb-query.html) for m" +"ore details." +msgstr "" + +msgid "{: #groonga}" +msgstr "" + +msgid "## How to use Groonga throw PGroonga" +msgstr "" + +msgid "This is an advanced topic." +msgstr "" + +msgid "In most cases, Groonga is faster than PostgreSQL." +msgstr "" + +msgid "" +"For example, [drilldown feature](http://groonga.org/docs/reference/commands/se" +"lect.html#drilldown) in Groonga is faster than one `SELECT` and multiple `GROU" +"P BY`s (or one `GROUP BY GROUPING SET`) by PostgreSQL. Because all needed resu" +"lts can be done by one query in Groonga." +msgstr "" + +msgid "" +"In another instance, Groonga can perform query that doesn't use all columns in" +" record faster than PostgreSQL. Because Groonga has column oriented data store" +". Column oriented data store (Groonga) is faster than row oriented data store " +"(PostgreSQL) for accessing some columns. Row oriented data store needs to read" +" all columns in record to access only partial columns. Column oriented data st" +"ore just need to read only target columns in record." +msgstr "" + +msgid "" +"You can't use SQL to use Groonga directory. It's not PostgrSQL user friendly. " +"But PGroonga provides a feature to use Groonga directly throw SQL." +msgstr "" + +msgid "### `pgroonga.command` function" +msgstr "" + +msgid "" +"You can execute [Groonga commands](http://groonga.org/docs/reference/command.h" +"tml) and get the result of the execution as string by `pgroonga.command` funct" +"ion." +msgstr "" + +msgid "" +"Here is an example that executes [status command](http://groonga.org/docs/refe" +"rence/commands/status.html):" +msgstr "" + +msgid "" +"```sql\n" +"SELECT pgroonga.command('status');\n" +"-- command " +" " +" \n" +"-- ---------------------------------------------------------------------------" +"------------------------------------------------------------------------------" +"------------------------------------------------------------------------------" +"----\n" +"-- [[0,1423911561.69344,6.15119934082031e-05],{\"alloc_count\":164,\"starttime\":" +"1423911561,\"uptime\":0,\"version\":\"5.0.0-6-g17847c9\",\"n_queries\":0,\"cache_hit_ra" +"te\":0.0,\"command_version\":1,\"default_command_version\":1,\"max_command_version\":" +"2}]\n" +"-- (1 row)\n" +"```" +msgstr "" + +msgid "" +"Result from Groonga is JSON. You can use JSON related functions provided by Po" +"stgreSQL to access result from Groonga." +msgstr "" + +msgid "" +"Here is an example to map one key value pair in the result of `status` command" +" to one row:" +msgstr "" + +msgid "" +"```sql\n" +"SELECT * FROM json_each(pgroonga.command('status')::json->1);\n" +"-- key | value \n" +"-- -------------------------+--------------------\n" +"-- alloc_count | 168\n" +"-- starttime | 1423911561\n" +"-- uptime | 221\n" +"-- version | \"5.0.0-6-g17847c9\"\n" +"-- n_queries | 0\n" +"-- cache_hit_rate | 0.0\n" +"-- command_version | 1\n" +"-- default_command_version | 1\n" +"-- max_command_version | 2\n" +"-- (9 rows)\n" +"```" +msgstr "" + +msgid "" +"See [`pgroonga.command` function](../reference/functions/pgroonga-command.html" +") for more details." +msgstr "" + +msgid "{: #pgroonga-table-name}" +msgstr "" + +msgid "### `pgroonga.table_name` function" +msgstr "" + +msgid "" +"PGroonga stores values of index target columns. You can use these values to se" +"arch and output by [`select` Groonga command](http://groonga.org/docs/referenc" +"e/commands/select.html)." +msgstr "" + +msgid "" +"`select` Groonga command needs table name. You can use `pgroonga.table_name` f" +"unction to convert index name in PostgreSQL to table name in Groonga." +msgstr "" + +msgid "" +"Here is an example to use `select` command with `pgroonga.table_name` function" +":" +msgstr "" + +msgid "" +"```sql\n" +"SELECT *\n" +" FROM json_array_elements(pgroonga.command('select ' || pgroonga.table_name('" +"pgroonga_content_index'))::json->1->0);\n" +"-- value " +" \n" +"-- ---------------------------------------------------------------------------" +"--------\n" +"-- [4]\n" +"-- [[\"_id\",\"UInt32\"],[\"_key\",\"UInt64\"],[\"content\",\"LongText\"]]\n" +"-- [1,1,\"PostgreSQLはリレーショナル・データベース管理システムです。\"]\n" +"-- [2,2,\"Groongaは日本語対応の高速な全文検索エンジンです。\"]\n" +"-- [3,3,\"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\"]\n" +"-- [4,4,\"groongaコマンドがあります。\"]\n" +"-- (6 rows)\n" +"```" +msgstr "" + +msgid "" +"See [`pgroonga.table_name` function](../reference/functions/pgroonga-table-nam" +"e.html) for more details." +msgstr "" + +msgid "## Next step" +msgstr "" + +msgid "" +"Now, you knew all PGroonga features! If you want to understand each feature, s" +"ee [reference](../reference/) manual for each feature." +msgstr "" + +msgid "[How to](../how-to/) may help you to use PGroonga for specific situation." +msgstr "" + +msgid "" +"If you get a problem or want to share your useful information, please contact " +"[PGroonga community](../community/)." +msgstr "" Copied: ja/tutorial/index.md (+48 -47) 84% =================================================================== --- tutorial/index.md 2015-10-15 23:00:59 +0900 (523520c) +++ ja/tutorial/index.md 2015-10-15 23:31:52 +0900 (c26ea14) @@ -1,36 +1,37 @@ --- -title: Tutorial -layout: en +title: チュートリアル +layout: ja --- -# Tutorial +# チュートリアル -This document describes how to use PGroonga step by step. If you don't install PGroonga yet, [install](../install/) PGroonga before you read this document. +このドキュメントはPGroongaの使い方を段階を追って説明します。まだPGroongaをインストールしていない場合は、このドキュメントを読む前にPGroongaを[インストール](../install/)してください。 -You can use PGroonga as fast full text search index. You can also use PGroonga as more general index for equality condition (`=`) and comparison conditions (`<`, `>=` and so on). +PGroongaは高速な全文検索インデックスを提供します。さらに、等価条件（`=`）・比較条件（`<`や`>=`など）用の一般的なインデックスも提供します。 -PostgreSQL provides GiST and GIN as bundled indexes. You can use PGroonga as alternative of GiST and GIN. See [PGroonga versus GiST and GIN](../reference/pgroonga-versus-gist-and-gin.html) for differences of them. +PostgreSQLは組み込みのインデックスとしてGiSTとGINを提供しています。PGroongaはGiST・GINの代わりに使うことができます。PGroongaとGiST・GINの違いは[PGroonga対GiST・GIN](../reference/pgroonga-versus-gist-and-gin.html)を参照してください。 -This document describes about the followings: +このドキュメントは次のことを説明します。 - * How to use PGroonga as full text search index - * How to use PGroonga as index for equality condition and comparison conditions - * How to use PGroonga as index for array - * How to use Groonga throw PGroonga (advanced topic) + * PGroongaを全文検索用インデックスとして使う方法 + * PGroongaを等価条件・比較条件用インデックスとして使う方法 + * PGroongaを配列用インデックスとして使う方法 + * PGroongaをJSON用インデックスとして使う方法 + * PGroonga経由でGroongaを使う方法（高度な話題） -## Full text search +## 全文検索 -This section describes about the followings: +このセクションでは次のことを説明します。 - * How to prepare PGroonga based CJK ready full text search system - * Operators for full text search - * Score + * PGroongaベースの全文検索システムの準備方法 + * 全文検索用の演算子 + * スコアー -### How to prepare PGroonga based CJK ready full text search system +### PGroongaベースの全文検索システムの準備方法 -This section describes about how to prepare PGroonga based CJK ready full text search full text search system. +このセクションはPGroongaベースの全文検索システムの準備方法を説明します。 -Create a column that you want to enable full text search as `text` type: +全文検索をしたいカラムを`text`型のカラムとして作ります。 ```sql CREATE TABLE memos ( @@ -39,17 +40,17 @@ CREATE TABLE memos ( ); ``` -`memos.content` column is a full text search target column. +`memos.content`カラムが全文検索対象のカラムです。 -Create a `pgroonga` index against the column: +このカラムに対して`pgroonga`インデックスを作ります。 ``` CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content); ``` -See [CREATE INDEX USING pgroonga](../reference/create-index-using-pgroonga.html) for more details. +詳細は[CREATE INDEX USING pgroonga](../reference/create-index-using-pgroonga.html)を参照してください。 -Insert test data: +テストデータを挿入します。 ```sql INSERT INTO memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。'); @@ -58,25 +59,25 @@ INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを INSERT INTO memos VALUES (4, 'groongaコマンドがあります。'); ``` -Disable sequential scan to ensure using `pgroonga` index: +確実に`pgroonga`インデックスを使うためにシーケンシャルスキャンを無効にします。 ```sql SET enable_seqscan = off; ``` -NOTE: You should not disable sequential scan on production environment. This is only for test. +注意：本番環境ではシーケンシャルスキャンを無効にするべきではありません。これはテスト用の設定です。 -### Operators for full text search +### 全文検索用演算子 -There are the following operators to perform full text search: +全文検索をする場合は次の演算子を使います。 * `%%` * `@@` * `LIKE` -#### `%%` operator +#### `%%`演算子 -You can use `%%` operator to perform full text search by one word: +1語で全文検索を実行する場合は`%%`演算子を使います。 ```sql SELECT * FROM memos WHERE content %% '全文検索'; @@ -87,11 +88,11 @@ SELECT * FROM memos WHERE content %% '全文検索'; -- (1 row) ``` -See [%% operator](../reference/operators/match.html) for more details. +詳細は[%% operator](../reference/operators/match.html)を参照してください。 -#### `@@` operator +#### `@@`演算子 -You can use `@@` operator to perform full text search by query syntax such as `keyword1 OR keyword2`: +`キーワード1 OR キーワード2`というようなクエリー構文を使って全文検索を実行する場合は`@@`演算子を使います。 ```sql SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL'; @@ -102,17 +103,17 @@ SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL'; -- (2 rows) ``` -Query syntax is similar to syntax of Web search engine. For example, you can use `OR` to merge result sets of performing full text search by two or more words. In the above example, you get a merged result set. The merged result set has records that includes `PGroonga` or `PostgreSQL`. +クエリー構文はWeb検索エンジンの構文と似ています。たとえば、`OR`を使うと複数のキーワードでの全文検索結果をマージできます。上の例ではマージされた結果が返ってきています。`PGroonga`または`PostgreSQL`を含むレコードがマージされた結果になります。 -See [Groonga document](http://groonga.org/docs/reference/grn_expr/query_syntax.html) for full query syntax. +クエリー構文の詳細は[Groongaのドキュメント](http://groonga.org/ja/docs/reference/grn_expr/query_syntax.html)を参照してください。 -See [@@ operator](../reference/operators/query.html) for more details. +詳細は[`@@`演算子](../reference/operators/query.html)を参照してください。 -#### `LIKE` operator +#### `LIKE`演算子 -PGroonga supports `LIKE` operator. You can perform fast full text search by PGroonga without changing existing SQL. +PGroongaは`LIKE`演算子をサポートしています。既存のSQLを変更しなくてもPGroongaを使った高速な全文検索を実現できます。 -`column LIKE '%keyword%'` equals to `column %% 'keyword'`: +`column LIKE '%キーワードd%'`は`column %% 'キーワード'`と等価です。 ```sql SELECT * FROM memos WHERE content %% '全文検索'; @@ -123,11 +124,11 @@ SELECT * FROM memos WHERE content %% '全文検索'; -- (1 row) ``` -See [LIKE operator](../reference/operators/like.html) for more details. +詳細は[`LIKE`演算子](../reference/operators/like.html)を参照してください。 {: #score} -### Score +### スコアー You can use `pgroonga.score` function to get precision as a number. If a record is more precision against searched query, the record has more higher number. @@ -146,7 +147,7 @@ CREATE INDEX pgroonga_score_memos_content_index USING pgroonga (id, content); ``` -Insert test data: +テストデータを挿入します。 ```sql INSERT INTO score_memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。'); @@ -155,7 +156,7 @@ INSERT INTO score_memos VALUES (3, 'PGroongaはインデックスとしてGroong INSERT INTO score_memos VALUES (4, 'groongaコマンドがあります。'); ``` -Disable sequential scan to ensure using `pgroonga` index: +確実に`pgroonga`インデックスを使うためにシーケンシャルスキャンを無効にします。 ```sql SET enable_seqscan = off; @@ -241,7 +242,7 @@ See [`pgroonga.snippet_html` function](../reference/functions/pgroonga-snippet-h You can use PGroonga for equality condition and comparison conditions. There are some differences between how to create index for string types and other types. There is no difference between how to write condition for string types and other types. -This section describes about the followings: +このセクションでは次のことを説明します。 * How to use PGroonga for not string types * How to use PGroonga for string types @@ -262,7 +263,7 @@ CREATE INDEX pgroonga_id_index ON ids USING pgroonga (id); The special SQL to use PGroonga is only `CREATE INDEX`. You can use SQL for B-tree index to use PGroonga. -Insert test data: +テストデータを挿入します。 ```sql INSERT INTO ids VALUES (1); @@ -306,7 +307,7 @@ CREATE INDEX pgroonga_tag_index ON tags USING pgroonga (tag); The special SQL to use PGroonga is only `CREATE INDEX`. You can use SQL for B-tree index to use PGroonga. -Insert test data: +テストデータを挿入します。 ```sql INSERT INTO tags VALUES (1, 'PostgreSQL'); @@ -356,7 +357,7 @@ CREATE TABLE docs ( CREATE INDEX pgroonga_sections_index ON docs USING pgroonga (sections); ``` -Insert test data: +テストデータを挿入します。 ```sql INSERT INTO docs @@ -399,7 +400,7 @@ CREATE TABLE products ( CREATE INDEX pgroonga_tags_index ON products USING pgroonga (tags); ``` -Insert test data: +テストデータを挿入します。 ```sql INSERT INTO products Modified: tutorial/index.md (+7 -6) =================================================================== --- tutorial/index.md 2015-10-15 23:00:59 +0900 (523520c) +++ tutorial/index.md 2015-10-15 23:31:52 +0900 (3f4bd58) @@ -13,22 +13,23 @@ PostgreSQL provides GiST and GIN as bundled indexes. You can use PGroonga as alt This document describes about the followings: - * How to use PGroonga as full text search index + * How to use PGroonga as index for full text search * How to use PGroonga as index for equality condition and comparison conditions * How to use PGroonga as index for array + * How to use PGroonga as index for JSON * How to use Groonga throw PGroonga (advanced topic) ## Full text search This section describes about the followings: - * How to prepare PGroonga based CJK ready full text search system + * How to prepare PGroonga based full text search system * Operators for full text search * Score -### How to prepare PGroonga based CJK ready full text search system +### How to prepare PGroonga based full text search system -This section describes about how to prepare PGroonga based CJK ready full text search full text search system. +This section describes about how to prepare PGroonga based full text search system. Create a column that you want to enable full text search as `text` type: @@ -106,7 +107,7 @@ Query syntax is similar to syntax of Web search engine. For example, you can use See [Groonga document](http://groonga.org/docs/reference/grn_expr/query_syntax.html) for full query syntax. -See [@@ operator](../reference/operators/query.html) for more details. +See [`@@` operator](../reference/operators/query.html) for more details. #### `LIKE` operator @@ -123,7 +124,7 @@ SELECT * FROM memos WHERE content %% '全文検索'; -- (1 row) ``` -See [LIKE operator](../reference/operators/like.html) for more details. +See [`LIKE` operator](../reference/operators/like.html) for more details. {: #score} -------------- next part -------------- HTML����������������������������...Download