FirstSQL, released as FirstSQL/J, is an Object-Relational Database Management System (ORDBMS) written fully in Java. It provides intermediate level support to the SQL92 standard and full Java object capabilities in the physical database using Java classes. SQL is the data access language and Java Database Connectivity (JDBC) is used as the client interface. In addition to the primitive data types, columns of the database can map to Java Objects. Moreover, stored procedures written in Java can be called by JDBC. Application developers can combine the their database and application code into a single .jar file and execute on any device, embedded system, or server computing platform with a Java Virtual Machine.[03][02]
- Website
- http://www.firstsql.com[01]
- Developer
- Country of Origin
- US
- Start Year
- 2001
- Project Type
- Commercial
- Written in
- Java
- Supported Languages
- Java
- Operating System
- All OS with Java VM
- License
- Proprietary
FirstSQL, released as FirstSQL/J, is an Object-Relational Database Management System (ORDBMS) written fully in Java. It provides intermediate level support to the SQL92 standard and full Java object capabilities in the physical database using Java classes. SQL is the data access language and Java Database Connectivity (JDBC) is used as the client interface. In addition to the primitive data types, columns of the database can map to Java Objects. Moreover, stored procedures written in Java can be called by JDBC. Application developers can combine the their database and application code into a single .jar file and execute on any device, embedded system, or server computing platform with a Java Virtual Machine.[03][02]
History[04][05][06]
The development of FirstSQL/J started in 2001. The first publicly available version, FirstSQL/J v1.0, was released in February 2002. The initial release came in two versions: the Enterprise version to be used by client/server applications and the professional version to be used by embedded desktop applications. FirstSQL/J has since been undergoing continuous development and support. In addition to the original Enterprise and Professional versions, versions to be used for embedded mobile systems and Android devices were released in October 2005 and October 2015, respectively.
Data Model[02]
Columns can map to Java Objects. Java classes, methods, and inheritance are fully supported in the physical database. They can be managed using JDBC client APIs and accessed using SQL.
Foreign Keys[02]
The supported SQL foreign key features are cascaded Update and Delete, Self-referencing and Cross-referencing.
Stored Procedures[07]
Stored Procedures need to be written in Java. They can be called directly using SQL commands or by other Java code in the client application.
System Architecture[03]
The system architecture depends on the configuration being used. In FirstSQL/J Professional Edition, the client application and the DBMS run on the same Java Virtual Machine and thereby the same physical machine. All data is embedded to the DBMS engine. In FirstSQL/J Enterprise Edition, the client application and the DBMS engine run on different Java Virtual Machines and physical machines. The JVM running the DBMS engine is responsible for both execution and storage.
Views[02]
Views are stored underneath as trees of database elements. The supported clauses include GROUP, UNION, and WITH CHECK OPTION as specified in the SQL92 standard.
Citations
7 sources- http://www.firstsql.com firstsql.com
- Home - SFirst-QL firstsql.com
- Home - SFirst-QL firstsql.com
- Home - SFirst-QL firstsql.com
- Home - SFirst-QL firstsql.com
- https://www.thefreelibrary.com/FirstSQL+Releases+FirstSQL/J+Professional+100%+Java+Object-relational+...-a083011881 thefreelibrary.com
- Home - SFirst-QL firstsql.com