slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
CREATE TABLE reports ( id INTEGER PRIMARY KEY , docid INTEGER, path TEXT, PowerPoint Presentation
Download Presentation
CREATE TABLE reports ( id INTEGER PRIMARY KEY , docid INTEGER, path TEXT,

Loading in 2 Seconds...

play fullscreen
1 / 7

CREATE TABLE reports ( id INTEGER PRIMARY KEY , docid INTEGER, path TEXT, - PowerPoint PPT Presentation


  • 104 Views
  • Uploaded on

CREATE TABLE reports ( id INTEGER PRIMARY KEY , docid INTEGER, path TEXT, val TEXT ); INSERT INTO reports ( 1 , 1, ‘/root/title’, ‘report A’); INSERT INTO reports ( 2 , 1, ‘/root/author’, ‘kaneko’); INSERT INTO reports ( 3 , 1, ‘/root/date’, ‘2009/11/29’);.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'CREATE TABLE reports ( id INTEGER PRIMARY KEY , docid INTEGER, path TEXT,' - mingan


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

CREATE TABLE reports (

id INTEGER PRIMARY KEY,

docid INTEGER,

path TEXT,

val TEXT );

INSERT INTO reports (1, 1, ‘/root/title’, ‘report A’);

INSERT INTO reports (2, 1, ‘/root/author’, ‘kaneko’);

INSERT INTO reports (3, 1, ‘/root/date’, ‘2009/11/29’);

■ The attribute ‘id’ is the PRIMARY KEY

The ‘id’ is key that can be used to identify

each row.

Table ‘reports’

PRIMARY

KEY

Fig. Logical Structure of the Table

slide2

Table ‘reports’

PRIMARY

KEY

Logical Structure

Associated Records

Keys

link

1

Record(1, ‘/root/title’, ‘report A’, ‘2009-12-11 11:20:36’)

link

2

Record(2, ‘/root/author’, ‘kaneko’, ‘2009-12-11 11:20:36’)

link

3

Record(3, ‘/root/date’, ‘2009/11/29’, ‘2009-12-11 11:20:36’)

Each key is associated with each record.

Physical Structure

Fig. Logical Structure and Physical Structure

slide4

Record Header

Record Data

Database Image

slide5

Database Header

SQLite Database File

slide6

SQLite 3 データベースヘッダ

に格納されている情報の例

Page size: 04 00

Database encoding: 00 00 00 01

※ UTF-8: 01

little-endian UTF-16: 02

big-endian UTF-16: 03

slide7

Associated Records

Keys

link

1

Record(1, ‘/root/title’, ‘report A’)

link

2

Record(2, ‘/root/author’, ‘kaneko’)

link

3

Record(3, ‘/root/date’, ‘2009/11/29’)

Each key is associated with each record.

Fig. Physical Structure of the Table

Record Length (Note that record length is variable)

Fig. Database File Layout Example (SQLite 3)