Yioop - PHP Search Engine

Sep 4 In-Class Exercise Thread.

Post your solutions to the Sep 4 In-Class Exercise to this thread.

Best,

Chris

Post your solutions to the Sep 4 In-Class Exercise to this thread. Best, Chris

-- Sep 4 In-Class Exercise Thread

Pages(unique_Id : Int, Page_Name: String, publish_date: String, language: String)

Primary-key : unique_id

(Edited: 2019-09-04)

Pages(unique_Id : Int, Page_Name: String, publish_date: String, language: String) Primary-key : unique_id

-- Sep 4 In-Class Exercise Thread

page(title, author, publishedDate, description ,references)

(Edited: 2019-09-04)

page(title, author, publishedDate, description ,references)

-- Sep 4 In-Class Exercise Thread

The DBM system in wiki we want to store an Art History "Mona Lisa" The Art type ( Artist,Year,material).

(Edited: 2019-09-04)

The DBM system in wiki we want to store an Art History "Mona Lisa" The Art type ( Artist,Year,material).

-- Sep 4 In-Class Exercise Thread

Wiki Schema: WikiPage(title: string, topic: string, contents:string)

(Edited: 2019-09-04)

Wiki Schema: WikiPage(title: string, topic: string, contents:string)

-- Sep 4 In-Class Exercise Thread

WikiPage(

	id:integer,
	url:string,
	title:string,
	author:string,
	date_created:date

) key = id,url

(Edited: 2019-09-04)

WikiPage( id:integer, url:string, title:string, author:string, date_created:date ) key = id,url

-- Sep 4 In-Class Exercise Thread

Pages(PageID:integer, timestamp:integer, body:string)

Pages(1, 123402, '<head>Some wiki title here</head>')

Key = PageID

(Edited: 2019-09-04)

Pages(PageID:integer, timestamp:integer, body:string) Pages(1, 123402, '<head>Some wiki title here</head>') Key = PageID

-- Sep 4 In-Class Exercise Thread

Page(title:string, year:integer, length:integer, editor:string, latestEdit:integer)

(Edited: 2019-09-04)

Page(title:string, year:integer, length:integer, editor:string, latestEdit:integer)

-- Sep 4 In-Class Exercise Thread

WikiPage(uid: String, title: String, author: String, languages: [String], article: String, page_description: String, date_published: Date, corrections: [String], references: [String], see_also: [String], extra_links: [String], related: [String])

key(author, title, date) key(uid)

(Edited: 2019-09-04)

WikiPage(uid: String, title: String, author: String, languages: [String], article: String, page_description: String, date_published: Date, corrections: [String], references: [String], see_also: [String], extra_links: [String], related: [String]) key(author, title, date) key(uid)

-- Sep 4 In-Class Exercise Thread

WikiPage (URL: String, Title: String, Language: String) (https://en.wikipedia.org/wiki/Italy, Italy, English) (https://en.wikipedia.org/wiki/Database, Database, English) Key: URL

(Edited: 2019-09-04)

WikiPage (URL: String, Title: String, Language: String) (https://en.wikipedia.org/wiki/Italy, Italy, English) (https://en.wikipedia.org/wiki/Database, Database, English) Key: URL