Questions tagged [databases]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
0answers
67 views

Speeding up postgres queries in v12.1?

New in v12.1 is the ability to connect to Postgres. I have a Postgresql database with a few million images (stored as byte data). Each image retrieval is ~10 seconds, so I need to speed it up! But how ...
6
votes
1answer
82 views

RelationalDatabases and dates (Mathematica 12)

As related to the new database functionality in version 12, I am trying to retrieve a specific entity (row) or group of entities (multiple rows) between a date range in an MS SQL database. The ...
8
votes
1answer
126 views

How to manipulate date in SQL via the EntityFramework?

I have an MicrosoftSQL Server database connected to entity framework as follows: ...
5
votes
1answer
112 views

How to map MS SQL Server onto the Entity Framework?

I created a reference using the following: ...
0
votes
0answers
40 views

Can not edit a print output(Trying to make a database)

So, I'm trying to make a database of a recursion coefficient to reuse inside the kernel to get the next coefficients (in the end is to get faster, because with only c[1] and c[2] is taking a lot to ...
7
votes
2answers
107 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
99 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 ...
18
votes
1answer
434 views

What are the benefits of Entity Classes for Databases?

To me, using the older database functionality is much simpler: ...
2
votes
0answers
97 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 ...
5
votes
1answer
270 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] ...
7
votes
1answer
129 views

How to do a database query on substrings?

With the package DatabaseLink I can open a connection to my MYSQL database. Then I can use SQL commands like ...
4
votes
1answer
73 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
59 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: ...
6
votes
0answers
155 views

Benefits of using the high level entity framework over raw SQL

Has anyone that has used both SQL particularly TSQL used in Microsoft SQL Server and Wolfram Database integration into its Entity framework, provide some particular examples where the high level ...
3
votes
0answers
91 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
70 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 ...
1
vote
1answer
78 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
221 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
94 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
59 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
103 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
161 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
63 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
147 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
203 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
347 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
532 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
68 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
472 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
130 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
241 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
219 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
86 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
111 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
425 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
506 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
431 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
969 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
971 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 ...
2
votes
1answer
221 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
436 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 ...
30
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, ...