Questions tagged [databases]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
35 views

Extracting city names in the text form from the function CountryData

I was planning to create an array with all capital cities in Europe using the following command: CountryData["Europe", "CapitalCity"] But ...
4
votes
1answer
85 views

Openning JSON file, (NDJSON, new line delimited) — big file

I am trying since many hours to open a JSON file ("new line delimited") that has this as structure ...
2
votes
2answers
74 views

EntityFunction for Relational Database error [closed]

I am a student and I am new of Mathematica. I am working with relational databases and I am following the guide "Relational Database quick start" find here: https://reference.wolfram.com/language/...
0
votes
0answers
35 views

Where is data stored in HSQLDB Mathematica

Where is data stored in HSQLDB in mathematica. I have to move the database file to another computer with data.
5
votes
0answers
78 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
91 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
157 views

How to manipulate date in SQL via the EntityFramework?

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

How to map MS SQL Server onto the Entity Framework?

I created a reference using the following: ...
7
votes
2answers
119 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
107 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
519 views

What are the benefits of Entity Classes for Databases?

To me, using the older database functionality is much simpler: ...
2
votes
0answers
109 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
336 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
155 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
81 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
64 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
165 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
103 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
77 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
80 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
245 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
102 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
120 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
187 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
71 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
156 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
214 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
366 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
573 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
73 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
505 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
247 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
224 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
88 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
115 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
434 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
80 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. ...
12
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
524 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
447 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
1k 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
176 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
1k 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
238 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
444 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 ...