Questions tagged [databases]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
1answer
56 views

How to load a RelationalDatabase stored in the WolframCloud?

I have an SQLite database with about 13 "tables" represented as a file and stored in the WolframCloud with public permissions located at the following URL: ...
2
votes
0answers
64 views

Converting Datasets into EntityStores: best practice?

The advent of the family of *edEntityClass functions in V12 looks very promising. Dataset and its related queries are ideal for ...
16
votes
1answer
264 views

What are the benefits of Entity Classes for Databases?

To me, using the older database functionality is much simpler: ...
1
vote
0answers
75 views

Failure to connect to a relational database

I'm trying to use the V12 functionality to connect to a PostgreSQL database on my local machine. I start with ...
3
votes
1answer
151 views

RelationalDatabase in Mathematica 12

My first attempt at using MMA's database capabilities appears to be a failure: ref = DatabaseReference[FindFile["optiondb_tb_options.sql"]]; DatabaseConnect[ref] ...
3
votes
1answer
60 views

How to use SPARQLSelect filter (SPARQLEvaluation[“CONTAINS”]) on two named graphs?

I would like to match triplets from two graphs in a RDFStores on the string value of one containing the string value of the other. To test this I made the ...
2
votes
0answers
46 views

SQLSelect - Bit (true/false) as condition

I have a table in a MySQL-DB which is of datatype "bit". The name of this column is "abk". If I write the following statement: ...
3
votes
0answers
65 views

How can I access data from a redis database in Mathematica?

I have a program which writes data to a redis database and would like to visualize that data live in Mathematica. I only found DatabaseLink which seems to support only SQL databases. Is there a more ...
3
votes
0answers
56 views

How to connect to ncbi databases for text search? MathIOmica authoring instructions now do not work [closed]

Mias's suplementary material in the notebook MmaBioinfo_Ch4_Databases contains a code for search the snp related to autism ...
0
votes
0answers
21 views

Need help understanding SQLConnectionUsableQ

On a program that relies on database connectivity asking SQLConnectionUsableQ@conn is very important and may be asked many times while the program is running. I ...
1
vote
1answer
66 views

How do I visualize images stored in SQL?

here is the background: I have a SQL database that (among other data) contains images I connect to the database, extract and store the relevant data in variable picData like so ...
0
votes
1answer
166 views

How to create and implement a small database on Mathematica?

I have a function f[x_,y_,z_]:= a^x b^y c^z and I want to evaluate it for various values of x,y,z always coming in triples. This means I have a database with ...
4
votes
0answers
85 views

Is there a DatabaseLink for Hive?

I have a Hadoop based data warehouse with which and I typically use the command line or Hue to perform Hive queries. I was hoping there is a built-in library or third party connector for doing this ...
0
votes
2answers
58 views

SQLInsert SQLExpr not working in V11

This worked fine in Mathematica 7. Any ideas how to fix it for version 11? ...
3
votes
0answers
88 views

Is Mathematica / the Wolfram language able to query LDAP databases?

I looked through the Wolfram language pages on data access and also searched the site but found nothing. Is it possible to query an LDAP database (actually MS Active Directory) using the Wolfram ...
0
votes
0answers
128 views

Import MDB in ZIP as ASSOCIATION

I have a zip file which contains an access database file (mdb format). How do I extract the database and the headers and convert them to association format? I know the command for doing that ...
0
votes
0answers
46 views

How to pass a table type parameter to SQLExecute?

In MS SQL Server 2016 I have a table type parameter: CREATE TYPE dbo.Ids AS TABLE (Id INTEGER NOT NULL); and a stored procedure: ...
2
votes
0answers
129 views

Random sample from sql database uniformly over time [closed]

I'd like to sample rows from a table uniformly over time, here is the naive way to do this: SELECT * FROM table ORDER BY RAND() LIMIT 10000 Unfortunately, ...
3
votes
1answer
188 views

Cloud Form Function Database

I am trying to build a web inventory application using a SQLite database hosted in the cloud home directory. I have a database in the home directory and I can query that database while in the code ...
3
votes
2answers
304 views

Importing crude oil prices from WolframAlpha

WolframAlpha has knowledge of crude oil prices, as a simple query will show. I am trying to obtain this data for use in Mathematica but I am not able to figure out the input. If I try ...
9
votes
2answers
473 views

Mathematica with MongoDB database

I try connect mathematica with my database NOSQL mongoDB but I have problem with create collection. I have Mathematica 10.2 and I download driver .net version 2.2 from this website a link! I unpacking ...
4
votes
0answers
56 views

Mathematica 10.3 on Windows 10 Home Premium Connection to SQL Server 2016 [duplicate]

Having installed sql server 2016 evaluation copy. I have setup a sample database using sql server management studio. Typed the following in mathematica ...
3
votes
1answer
414 views

How can I connect database oracle with Mathematica

I try to connect to an Oracle database with Mathematica but I get this error: DBC::classnotfound: oracle.jdbc.driver.OracleDriver" My code: ...
1
vote
0answers
121 views

Using Mathematica to connect to Cloudera Impala

I am trying to connect to Cloudera Impala via Mathematica, but so far I have not been able to do so. Has anyone ever done it? I have been able to connect to it via R using the JDBC or ODBC interface ...
5
votes
2answers
229 views

Importing SQL view vs table

I am trying to import a SQL view not a table in Mathematica. The command: SQLSelect[conn, "DataByYear"] This will correctly bring in the table. However using the ...
1
vote
0answers
210 views

Awkward DatabaseLink JDBC Error [closed]

I've created a GUI application (a database editor) that uses DatabaseLink and it is currently working fine on my PC (M10.02, Windows 7) and on a clients's PC (CDF Player Pro 10.02, Windiws 8). While ...
1
vote
1answer
84 views

How to specify the number of precision digits for columns using DatabaseLink functions and options

Some databases (e.g. MySQL) does not store decimal places for seconds unless the number of digits needed is directly specified (e.g. DATETIME(4) for 4 digits) when creating the table in the database. ...
0
votes
0answers
107 views

Mathematica SQL command that counts records in table

Is there a DatabaseLink command other than SQLExecute that can be used to count the total records in a database table?
1
vote
0answers
382 views

I can create an H2 database with the H2 Console, but I can't find the database with MMA

I can create an H2(Server) database using the tool that H2 provides, but although i can create a memory based H2 database with the Database Explorer, when I try to create a connection to the H2(...
0
votes
0answers
79 views

Improve performance of processing transactions in a large file

I want to work with a table which has 296,705 transactionslines and 172,147 transactions. ...
11
votes
1answer
1k views

Slow work of SQLInsert with MS SQL Server in V10

This question is very similar to: Slow work of SQLInsert with SQLite, but for MS SQL Server. Unfortunately the use of SQLBeginTransaction and ...
3
votes
1answer
451 views

How to Insert Multiples Rows in Database (SQL)

I want to insert a matrix into a database, preferably with syntax like this: ...
6
votes
1answer
412 views

How to update bundled SQLite library (or driver?) in V10 for OS X

I've been using undocumented Database functions with Mathematica V9 to acces my SQLite database, which is a Firefox-generated database that contains cookies. ...
5
votes
1answer
1k views

Insert large amount of data in HSQL

I create HSQL database with one table ...
1
vote
1answer
901 views

How to check empty tables using SQL Select or Execute?

If[SQLExecute[con, "Select * from TABLE"] == "{}", Print["TRUE"], Print["FALSE"]] I need to know the way, if the TABLE is empty or not
10
votes
3answers
2k views

Slow work of SQLInsert with SQLite

I want to store my data in SQLite database, but writing large numbers of data its too slow. For example: ...
1
vote
0answers
175 views

Datastream to Mathematica

I currently use data from Thomson Reuters Datastream. With an add-in in Excel, the data can be requested. Because I need to use the data in Mathematica, and I need to update the data frequently: Is it ...
3
votes
2answers
816 views

Create Table of replacement rules

I want to create a table of replacement rules. ...
3
votes
0answers
1k views

Problem inserting data into a mysql table with column names having a space

I have a mysql table whose column name has space. I tried inserting the data into this column. I got an error I tried a sample code, which tests accessing the columns with a space and that returns ...
1
vote
1answer
198 views

OpenSQLConnection error

I used to be able to connect to a SQL Server database. I haven't run this program for a few months. I tried it today and it failed, so I went back to try OpenSQLConnection[] and got the following ...
2
votes
1answer
403 views

MySQL or PostgreSQL? Using Mathematica only I need to choose one

Installing either MySQL or PostgreSQL. My concern is just with Mathematica. I am going to be using it to store a good bit of basic data but the main thing is fast image retrieval and comparison using ...
29
votes
6answers
3k views

Graph databases / Nosql with Mathematica

I am very new to mathematica but it looks like an interesting language and I would like to explore it for a future project to create a web search engine. It seems like it would be fairly well suited ...
4
votes
4answers
2k views

Connect to remote Ms-sql Database

I can connect to the local Database(installed in my system) from Mathematica via ...
5
votes
3answers
1k views

Working with a database

I just started to work with a database through Mathematica. I have a large data set. I use an .mx file to store my data. Now I have to store the data in a database, ...
2
votes
0answers
311 views

Can Mathematica use a MySQL ODBC connector?

I have a MySQL database that I connect to using Mathematica and would like to distribute my Mathematica code to others. We already have ODBC DSNs setup on peoples machines using the MySQL ODBC ...
3
votes
1answer
665 views

How can I connect database(MSSQL Server) with Mathematica?

Newly I started working with database(MSSQL Server 2012). by google help, I created Table name as EmployeesList and also ...
4
votes
1answer
203 views

How can I write image to MySQL database?

I have a database, such as: In Mathematica, the final code is: img1=Export["/home/user/Desktop/1.jpg",resultimg1]; I tried ...
19
votes
2answers
5k views

How do you deal with very large datasets in Mathematica?

This question is in two related parts. The first is about dataset size, the second data wrangling. Part 1: I've built a naive Bayesian classifier on Mathematica. It uses ...
115
votes
1answer
7k views

File-backed lists/variables for handling large data

Background Currently I am working with some large data (most of it generated by Mathematica itself). I usually find it a hassle to do this. For example, I just exported a large amount of data to ...