Database Access Kit

What is the Database Access Kit?

Database Access provides a flexible, powerful and convenient interface to ODBC compatible relational database management systems like Oracle, Microsoft Access, FoxPro and SQLServer, Sybase, Informix Information Server, DB2 and many more. Using the ODBC control panel, the Database Access Kit also provides full access to a number of flat file databases like Excel or dBase files.  Database Access users can query any ODBC compliant database using SQL or Mathematica commands. Database Access Kit also allows to construct SQL compliant data tables and enter data that can be used with any SQL compatible software.

How does the Database Access Kit work?

Within any Database Access session, one or more links are established between Mathematica and one or more data sources. If the opened data sources already contain data, the user can retrieve, add to, delete, or alter the data. The user can also define new database structures such as additional columns and add data to new databases. Database Access Kit also lets Mathematica users construct data tables and enter data usable with any SQL-compatible software.

Who can use it?

Database Access Kit is designed to be used by both those who have knowledge of SQL and those who are not familiar with SQL statements.Database Access Kit contains a set of predefined Mathematica-based functions that perform operations equivalent to standard SQL statements. For users who prefer SQL, Database Access Kit is able to interpret and execute SQL statements directly on the database.

What are the platform requirements?

It is designed for use with Mathematica 3 or higher and is available for Windows 95/98/NT. During internal and external testing, we verified that it works with 

-Microsoft Access, FoxPro, SQLServer, Excel
-Oracle 7,8 and 8i
-Informix Information Server
-Sybase
-MySQL

What does Database Access offer?

Database Access provides Mathematica users and SQL specialists with a familiar, easy to use and extremely flexible solution for sophisticated analysis and design in a familiar environment

Database Access makes Mathematica a powerful scripting language for databases

Database Access enables developers to prototype and deploy sophisticated database analysis algorithms and solutions

Database Access works seamlessly with other parts of the Applications Package Library. This enables developers to do more intense analysis (TimeSeries), deploy easy interfaces (Mathematica Link for Excel), or create scalable applications (Parallel Computing Toolkit)

Possible Markets

People in most fields that analyze and manipulate databases. This includes life scientists, engineers, physical scientists, and social scientists, finance and insurance analysts, market researchers... .

Non-Mathematica users

Examples

Population

Northwind

Stocks

Create

Benefits of the Database Access Kit

Access Mathematica's computational power to analyze and manipulate data

Exchange data between databases and Mathematica notebooks

Easy-to-use interface to SQL and ability to use SQL commands directly

Generate Mathematica graphics to visualize your data and findings

Create great looking reports with the Mathematica front end.

Create Mathematica-based applications for financial analysts, engineers, scientists...

Create databases and store data in them directly from within Mathematica