CSV Format

CSV-formatted dumps are provided for easy loading of DBpedia data into legacy databases.

In My SQL, for example, a table accommodating a data set can be created as:

CREATE TABLE `infobox_en` (

  `subject` varchar(255) NOT NULL,

  `predicate` varchar(255) NOT NULL,

  `object` text NOT NULL,

  `object_is` enum('r','l') NOT NULL,

  KEY `subject` (`subject`),

  KEY `predicate` (`predicate`),

  KEY `object_is` (`object_is`),

  KEY `object` (`object`(20))

)

The command for loading the data set is:

LOAD DATA INFILE 'infobox_en.csv' INTO TABLE `infobox_en`

The resulting tables can be easily queried using standard SQL commands.

There are no files on this page. [Display files/form]

There is no comment on this page. [Display comments/form]

Information

Last Modification: 2008-07-08 20:21:41 by Ted Thibodeau Jr