Use freebase data on local server?

Question

Are there existing ways to use freebase data dumps to create a database similar to what freebase offers, but on your own server? Quite a lot of free space, but locally, and not through the API?

I think it would be possible to create, but are there already existing solutions for this? Or any alternative solutions for such data without using an API? I did not find this for dbpedia: |

Answer 1

Take a look at the freebase-quad-rdfize project in Google Code. It should allow you to download the weekly Freebase quad dump and upload it to the three-local RDF store of your choice.

Answer 2

The freebase-quad-rdfize alternative is here: https://github.com/castagna/freebase2rdf

I use Apache Jena's TDB repository to load RDF and Fuseki data to serve data through the SPARQL protocol through HTTP.

See also:

• http://markmail.org/thread/mq6ylzdes6n7sc5o
• http://markmail.org/thread/jegtn6vn7kb62zof

In addition, you have another option: http://basekb.com/

Answer 3

I am the creator : BaseKB , the first convenient conversion of Freebase to RDF.

Freebase ATVs have key integrity problems that make it difficult to get completely correct results from the ATV .: BaseKB restores the key Freebase structure, so there is an assumption of a unique name. This is important because the ability to write simple SPARQL queries that work like SQL queries depends on it.

Right now: BaseKB exists in two versions. There is a free version, consisting of 120 million facts about 4 million topics (from Wikipedia), as well as the Pro edition, which contains everything.

Regarding the performance issues raised by Philip Kendal, I can say that it is basically a matter of having enough RAM. With 24 GB of RAM, I can download the free version to the three-local store in an hour. Some queries take longer than I like, but overall query performance is good.

Anyone who wants to use the Pro edition needs unusually powerful hardware and takes a lot of effort to get their tool chain to work. I am working with partners right now to deliver Pro to users in a satisfactory manner.

Answer 4

Importing data into a triple store of your choice will not be difficult - but you will have great difficulty getting any answers in a reasonable amount of time if you are not doing something trivial.

Someone actually imported the entire dataset into MySQL several years ago - it took 2 weeks to load, and even simple queries, such as “the number of things typed as a person,” took> 1 minute to give an answer. It was on large equipment, and the data set is now much larger than then.

Answer 5

If you can export the database to specify delimiters with tab delimiters or commas in TXT files or database files such as MDB, XLS or any other portable data format, you can easily create your own MySQL database on your computer using these data. The main thing is to make sure that you can export data from which you can restore your own database.