[Doing] Align graph using tvtropes data with wikipedia

[miaekim]

Table "public.wikipedia_works"

Column	Type	Modifiers	Storage	Stats target	Description
work	character varying	not null	extended
author	character varying		extended

Indexes:

"wikipedia_works_pkey" PRIMARY KEY, btree (work)

Has OIDs: no

Table "public.tvtropes_relations"

origin_namespace	origin_name	destination_namespace	destination_name
Main	Anime of the 2010s	Video Game	Amagami
Manga	Arakawa Under the Bridge	http://tvtropes.org/pmwiki/pmwiki.php/Manga/ArakawaUnderTheBridge

Column	Type	Modifiers	Storage	Stats target	Description
origin_namespace	character varying	not null	extended
origin	character varying	not null	extended
destination_namespace	character varying	not null	extended
destination	character varying	not null	extended

Indexes:

"tvtropes_relations_pkey" PRIMARY KEY, btree (origin_namespace, origin, destination_namespace, destination)

Foreign-key constraints:

"tvtropes_relations_origin_namespace_fkey" FOREIGN KEY (origin_namespace, origin) REFERENCES tvtropes_entities(namespace, name)

Has OIDs: no

Table "public.tvtropes_entities"

namespace	name	url	last_crawled	type
Main	Anime of the 2010s	http://tvtropes.org/pmwiki/pmwiki.php/Main/AnimeOfThe2010s		Trope
Video Game	Amagami	http://tvtropes.org/pmwiki/pmwiki.php/VideoGame/Amagami		Work

Column	Type	Modifiers	Storage	Stats target	Description
namespace	character varying	not null	extended
name	character varying	not null	extended
url	character varying		extended
last_crawled	timestamp without time zone		plain
type	character varying		extended

Indexes:

"tvtropes_entities_pkey" PRIMARY KEY, btree (namespace, name)

Referenced by:

TABLE "tvtropes_redirections" CONSTRAINT "tvtropes_redirections_original_namespace_fkey" FOREIGN KEY (original_namespace, original_name) REFERENCES tvtropes_entities(namespace, name)

TABLE "tvtropes_relations" CONSTRAINT "tvtropes_relations_origin_namespace_fkey" FOREIGN KEY (origin_namespace, origin) REFERENCES tvtropes_entities(namespace, name)

Has OIDs: no

[item4]

I fixed broken table :)

[miaekim]

@item4
👍

[miaekim]

Align Schema 1

Merge table "public.tvtropes_entities" with table "public.wikipedia_works"

Three column made by primary key

1. (namespace, name)
2. work

View "public.cliche_works"

Column	Type	Modifiers	Storage	Stats target	Description
work	character varying	not null	extended
namespace	character varying	not null	extended
name	character varying	not null	extended

Indexes:

"wikipedia_works_pkey" PRIMARY KEY, btree (work)
"tvtropes_entities_pkey" PRIMARY KEY, btree (namespace, name)

Align Schema 2

Table "public.wikipedia_works"

Column	Type	Modifiers	Storage	Stats target	Description
work	character varying	not null	extended
author	character varying		extended
sameas	list		extended

Table "public.tvtropes_entities"

Column	Type	Modifiers	Storage	Stats target	Description
namespace	character varying	not null	extended
name	character varying	not null	extended
url	character varying		extended
last_crawled	timestamp without time zone		plain
type	character varying		extended
sameas	list		extended

[miaekim]

Align strategies

Determine Same As

connect two tables by comparing title and any(author)

1. Bayesian network
2. Sort by entropy

[miaekim]

voting
portability
Equality를 정의
permanent하지 않는다