|
|
|
|
|
|
Database APIs
You can access Mimer SQL using the following native database application interfaces:
- ADO.NET
ADO.NET is the interface of choice when developing database applications in the Microsoft .NET framework and it is the natural successor for ADO (ActiveX Data Objects).
- JDBC
JDBCTM is the Java database API specified by Sun Microsystems Inc.
- ODBC
ODBC is a database independent interface. Through ODBC, Mimer SQL can support many of the tools available on the platforms supporting ODBC, e.g. Windows and UNIX.
- Embedded SQL (ESQL)
ESQL is used through a host programming language (C/C++, COBOL or FORTRAN as available on the host computer). SQL statements are included as part of the source code for an application program, which is compiled and linked with the appropriate language-specific facilities. The SQL statements are executed in the context of the application program.
In addition, Mimer SQL supports other interfaces such as PHP, Perl, QT and ADO. Please see http://developer.mimer.com/interfaces for details.
Prerequisites
Application developers using this manual are assumed to have a working acquaintance with the principles of the relational database model in general and of Mimer SQL in particular.
Knowledge of Mimer SQL is of course an advantage, although experience with other standard-compliant SQL implementations will suffice. Experience of Mimer SQL is best gained through interactive use of the BSQL facility, see the Mimer SQL User's Manual, Mimer BSQL.
Related Mimer SQL Publications
- Mimer SQL Mobile Reference Manual
contains a complete description of the syntax and usage of all statements in Mimer SQL and is a necessary complement to this manual.
- Mimer SQL Mobile User's Manual
contains a description of the BSQL facilities. A user-oriented guide to the SQL statements is also included, which may provide help for less experienced users in formulating statements correctly (particularly the SELECT statement, which can be quite complex).
- Mimer SQL Mobile System Management Handbook
describes system administration functions, including export/import, backup/restore, databank shadowing and the statistics functionality.
The information in that manual is used primarily by the system administrator, and is not required by application program developers. The SQL statements that are part of the System Management API are described in the Mimer SQL Mobile Reference Manual.
- Mimer SQL Platform-specific documents
contain platform-specific information. A set of one or more documents is provided, where required, for each platform on which Mimer SQL is supplied.
- Mimer SQL Mobile Release Notes
contain general and platform-specific information relating to the Mimer SQL release for which they are supplied.
- Mimer JDBC Driver Guide
is intended for Java application developers working with Mimer SQL. It covers all available Mimer JDBC drivers. The guide describes the usage of SQL in Java applications.
Suggestions for Further Reading
We can recommend the many works of C. J. Date. His insight into the potential and limitations of SQL, coupled with his pedagogical talents, make his books invaluable sources of study material in the field of SQL theory and usage. In particular, we can mention:
A Guide to the SQL Standard (Fourth Edition, 1997). ISBN: 0-201-96426-0. This work contains much constructive criticism and discussion of the SQL standard, including SQL99.
SQL: 1999 - Understanding Relational Language Concepts, by Jim Melton, Alan R. Simon, and Jim Gray. ISBN: 1-55860-456-1. Explains SQL-99.
Advanced SQL: 1999 - Understanding Object-Relational and Other Advanced Features, by Jim Melton. ISBN: 1-55860-677-7. In-depth guide to SQL-99's practical application.
JDBC
JDBC information can be found on the internet at: http://java.sun.com/products/jdbc
For information on specific JDBC methods, please see the online documentation, which is normally included in the Java development environment.
JDBC API Tutorial and Reference, 2nd edition. ISBN: 0-201-43328-1. A useful book published by JavaSoft.
ODBC
Microsoft ODBC 3.0 Programmer's Reference and SDK Guide for Microsoft Windows and Windows NT. ISBN: 1-57231-516-4. This manual contains information about the Microsoft Open Database Connectivity (ODBC) interface, including a complete API reference.
SQL Standards
Official documentation of the accepted SQL standards may be found in:
ISO/IEC 9075:2003(E) Information technology - Database languages - SQL. This document contains the standard referred to as SQL-2003.
CAE Specification, Data Management: Structured Query Language (SQL), Version 2.
X/Open document number: C449. ISBN: 1-85912-151-9. This document contains the
X/Open-95 SQL specification.Definitions, Terms and Trademarks
All other trademarks are the property of their respective holders.
 Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se |
|
|
|
|
|
|