Using uby with sqlite for matlab interface

2 次查看（过去 30 天）
Edward Moran
Edward Moran 2019-11-15
Hello!
Uby includes WordNet, FrameNet, and VerbNet. I download an Uby database and try to run sqlite.
The sqlite connection seems to be made. I'm having trouble importing the tables of this database into MATLAB.
My question is: how do I import the tables? Also, how do I find the names of all the tables in the database in the first place?
I got the name of the table in the code below from the Uby website but I'm not sure if it is correct. It is just one of many tables.
I am not able to import any of them.
Thanks!
The code is as follows:
>> dbfile = fullfile(pwd,'uby_open_0_6_0.sql');
>> conn = sqlite(dbfile)
conn =
sqlite with properties:
Database: 'C:\Users\edward\Desktop\uby_open_0_6_0.sql\uby_open_0_6_0.sql'
IsOpen: 1
IsReadOnly: 0
>> data = fetch(conn,'SELECT * FROM SubcatFrameSetElement');
Error using sqlite/fetch
Received exception upon attempting an operation. Exception:
[C:\Users\edward\Desktop\uby_open_0_6_0.sql\uby_open_0_6_0.sql is not a database. (file is not a database)]. Details:
[SELECT * FROM SubcatFrameSetElement].
>>

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by