Incorporate Comments 1 for SQL LOB Guide
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/3b704d7a Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/3b704d7a Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/3b704d7a Branch: refs/heads/master Commit: 3b704d7aaf6cdd1ffcd3bfb429ce820f924eaebc Parents: 9421e11 Author: liu.yu <[email protected]> Authored: Wed Sep 13 15:43:46 2017 +0800 Committer: liu.yu <[email protected]> Committed: Wed Sep 13 15:43:46 2017 +0800 ---------------------------------------------------------------------- docs/lob_guide/pom.xml | 8 +++----- docs/lob_guide/src/asciidoc/_chapters/about.adoc | 10 +++++----- docs/lob_guide/src/asciidoc/_chapters/introduction.adoc | 12 ++++++------ 3 files changed, 14 insertions(+), 16 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b704d7a/docs/lob_guide/pom.xml ---------------------------------------------------------------------- diff --git a/docs/lob_guide/pom.xml b/docs/lob_guide/pom.xml index c5ebf3c..76f26f7 100644 --- a/docs/lob_guide/pom.xml +++ b/docs/lob_guide/pom.xml @@ -25,13 +25,11 @@ --> <modelVersion>4.0.0</modelVersion> <groupId>org.apache.trafodion</groupId> - <artifactId>sql-reference-manual</artifactId> + <artifactId>sql-large-objects-guide</artifactId> <version>${env.TRAFODION_VER}</version> <packaging>pom</packaging> - <name>Trafodion SQL Reference Manual</name> - <description>This manual describes reference information about the syntax of SQL statements, - functions, and other SQL language elements supported by the Trafodion projectâs - database software. + <name>Trafodion SQL Large Objects Guide</name> + <description>This guide describes how to use Large Object (LOB) datatypes in Trafodion SQL. </description> <url>http://trafodion.incubator.apache.org</url> <inceptionYear>2015</inceptionYear> http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b704d7a/docs/lob_guide/src/asciidoc/_chapters/about.adoc ---------------------------------------------------------------------- diff --git a/docs/lob_guide/src/asciidoc/_chapters/about.adoc b/docs/lob_guide/src/asciidoc/_chapters/about.adoc index 8812a0b..d5a1446 100644 --- a/docs/lob_guide/src/asciidoc/_chapters/about.adoc +++ b/docs/lob_guide/src/asciidoc/_chapters/about.adoc @@ -25,7 +25,7 @@ [[About_This_Document]] = About This Document -This guide dwscribes how to use Large Object (LOB) datatypes. +This guide describes how to use Large Object (LOB) datatypes in Trafodion SQL. [[Intended_Audience]] == Intended Audience @@ -41,15 +41,15 @@ This is a new guide. [cols="30%,70%",options="header"] |=== |Chapter | Description -| <<Introduction,Introduction>> | Introduces LOB and covers following topics: + -• 1.1 <<what is lob,What is LOB>> + +| <<Introduction,Introduction>> | Introduces LOBs and covers following topics: + +• 1.1 <<what is a lob,What is a LOB>> + • 1.2 <<lob data types,LOB Data Types>> + • 1.3 <<lob storage,LOB Storage>> + • 1.4 <<lob handle,LOB Handle>> + • 1.5 <<lob restrictions,LOB Restrictions>> + • 1.6 <<lob related sql statements and functions,LOB Related SQL Statements and Functions>>. -| <<Work with LOB,Work with LOB>> | Explains how to use LOB with SQL statement and covers following topics: + +| <<Work with LOB,Work with LOB>> | Explains how to use a LOB with SQL statement and covers following topics: + • 2.1 <<create a sql table with lob columns,Create a SQL Table with LOB Columns>> + • 2.2 <<insert into a sql table containing lob columns,Insert into a SQL Table Containing LOB Columns>> + • 2.3 <<insert into a sql table containing lob columns using select clause,Insert into a SQL Table Containing LOB Columns Using Select Clause>> + @@ -60,7 +60,7 @@ This is a new guide. • 2.8 <<drop a sql table containing lob columns,Drop a SQL Table Containing LOB Columns>> + • 2.9 <<garbage collection,Garbage Collection>> + • 2.10 <<cleanup of a sql table containing lob columns,Cleanup of a SQL Table Containing LOB Columns>> + -• 2.11 <<showddl for lob,SHOWDDL for LOB>> + +• 2.11 <<showddl for lobs,SHOWDDL for LOBs>> + • 2.12 <<get command for lob tables,Get Command for LOB Tables>> |=== http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/3b704d7a/docs/lob_guide/src/asciidoc/_chapters/introduction.adoc ---------------------------------------------------------------------- diff --git a/docs/lob_guide/src/asciidoc/_chapters/introduction.adoc b/docs/lob_guide/src/asciidoc/_chapters/introduction.adoc index e3a9c08..755a8ef 100644 --- a/docs/lob_guide/src/asciidoc/_chapters/introduction.adoc +++ b/docs/lob_guide/src/asciidoc/_chapters/introduction.adoc @@ -26,8 +26,8 @@ [#introduction] = Introduction -[#what is lOB] -== What is LOB +[#what is a lOB] +== What is a LOB LOB (Large Object), a set of large object data types used to store large volumes of data, provides random and piece-wise access to the data. @@ -53,17 +53,17 @@ BLOB is ideal for storing and handling unstructured data, such as images, audio, Stores unusually large amounts of string data in character set format. + -CLOB is ideal for storing and processing semi-structured data, such as large document or string. +CLOB is ideal for storing and processing semi-structured data, such as a large document or string. |=== [#lob storage] == LOB Storage -The basic design idea is to allow a database row to have multiple LOB columns and a table to have multiple such rows. The design takes a combination approach of rows store and column store. +The basic design idea is to allow a database row to have multiple LOB columns and a table to have multiple such rows. The design takes a combination approach of row store and column store. -When a SQL table with LOB column is created, there are several dependent objects that are created to hold metadata information on the LOB as well as the data. +When a SQL table with a LOB column is created, there are several dependent objects that are created to hold metadata information on the LOB as well as the data. -The LOB data itself is stored in HDFS while the Trafodion table contains a unique LOB handle for each row/column. The LOB handle provides the identifier that is used to query the LOB metadata tables to find the location of the LOB data files. +The LOB data itself is stored in an HDFS file while the Trafodion table contains a unique LOB handle for each LOB value. The LOB handle provides the identifier that is used to query the LOB metadata tables to find the location of the LOB data files. The naming conventions for the LOB tables are as follows: [caption="Table 1-2 "]
