The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
56 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. ...
9
votes
1answer
120 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 ...
9
votes
3answers
321 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: ...
18
votes
4answers
1k 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 ...
3
votes
1answer
75 views

How to Insert Multiples Rows in Database (SQL)

I want to insert a matrix into a database, preferably with syntax like this: ...
4
votes
1answer
162 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. ...
0
votes
0answers
37 views

Mathematica not showing MySQL databases

I have MySQL installed and I want to access the databases from Mathematica. From the command line this is what I have Now I want to edit this db directly form Mathematica. If I do ...
4
votes
1answer
229 views
1
vote
1answer
227 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
1
vote
0answers
92 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 ...
2
votes
2answers
193 views
3
votes
0answers
465 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 ...
2
votes
1answer
205 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 ...
1
vote
1answer
120 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 ...
3
votes
1answer
325 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
3answers
661 views

Connect to remote Ms-sql Database

I can connect to the local Database(installed in my system) from Mathematica via ...
0
votes
0answers
147 views

Cannot access the Database using the JDCB - ODBC

Runnig this code after building the ODBC connection for my access application named WPC : ...
3
votes
2answers
516 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
162 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 ...
4
votes
1answer
160 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 ...
12
votes
2answers
2k 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 ...
82
votes
1answer
4k 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 ...