FirstSQL Releases FirstSQL/J Professional 100% Java Object-relational Database.Business Editors, Technology Writers EL CERRITO El Cerrito (ĕl sərē`tō), city (1990 pop. 22,869), Contra Costa co., W Calif., on San Francisco Bay; inc. 1917. It is primarily residential. Golden Gate Fields Racetrack is nearby. , Calif.--(BUSINESS WIRE)--Feb. 18, 2002 FirstSQL(R), Inc., a developer of advanced high performance 100% Java Object-relational SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. database technology announced today general availability of FirstSQL/J Professional v1.0. FirstSQL/J not only brings object persistence and convenient manipulation of objects to object-oriented applications; it delivers the power of objects integrated with a relational database relational database Database in which all data are represented in tabular form. The description of a particular entity is provided by the set of its attribute values, stored as one row or record of the table, called a tuple. and SQL. Java, as the basis for the object capabilities, ensures the widest availability of services and flexibility for application developers. Designed for use in any type of embedded system Any electronic system that uses a CPU chip, but that is not a general-purpose workstation, desktop or laptop computer. Such systems generally use microprocessors, or they may use custom-designed chips or both. , device, or server computing application that supports a JVM See Java Virtual Machine. JVM - Java Virtual Machine , FirstSQL/J provides a scalable, high performance multi-threaded database engine with reliable transaction processing Updating the appropriate database records as soon as a transaction (order, payment, etc.) is entered into the computer. It may also imply that confirmations are sent at the same time. Transaction processing systems are the backbone of an organization because they update constantly. and low total cost of ownership. Applications, from communication infrastructure to on-line, can be developed on any platform supporting a JVM. FirstSQL/J Professional provides ANSI (American National Standards Institute, New York, www.ansi.org) A membership organization founded in 1918 that coordinates the development of U.S. voluntary national standards in both the private and public sectors. It is the U.S. member body to ISO and IEC. SQL 92 Intermediate level compliance along with extensions and full object capabilities in the database using Java Classes. Java serves as the stored procedure language to enhance the power of SQL. Object extensions allow Java methods to be called anywhere in SQL commands, for example, SELECT List, WHERE Clause, SET Clause. Database clients using JDBC (Java DataBase Connectivity) A programming interface that lets Java applications access a database via the SQL language. Since Java interpreters (Java Virtual Machines) are available for all major client platforms, this allows a platform-independent database can retrieve and send database objects and they can then execute the retrieved objects in the client JVM environment. Java database objects offer application developers flexibility by opening infinite possibilities for storage of information. FirstSQL/J supports full object capabilities in the database using Java Classes. The CREATE CLASS command catalogs a Java class into the database. Once cataloged, the Java Class has multiple uses, for: -- User Defined Functions -- the static methods of the class can be called as functions in SQL. -- Stored Procedures -- the static methods of the class can be called as stored procedures. The class methods have direct access to the current database connection and can return multiple result sets. -- Data Wrappers -- instances of the class can be used by the client application to pass data to and from the ORDBMS. -- Column Data Types -- table columns can use the class as their data type. Values for the columns in table rows are then instances of the class. SQL statements construct instance values for the column with the NEW operator and utilize the object column values by calling their methods. The small, dynamic footprint is less than 800k but functionality can easily be removed to create a smaller footprint. |
|
||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion