Home
Solutions
Web and Application Hosting
Site Development Services
InfraServer Application Server
Technical Support
Corporate
Login
|
|
| infraServer components: RelationalDatabase
|
A core feature of the InfraServer is its integrated Relational Database. While it is an entry-level database relative to such commercial products as Oracle, it is flexible, fully web-accessible and configurable, and does not require knowledge of SQL to access all functionality.
The Relational Database component is an XML-based database including the following features:
- Cross-platform -- the InfraServer is a 100% Java application
- Transactional -- support for Java Transaction API
- Junctions -- 1 to 1, 1 to n, m to 1, or m to n linkages can be made between records, where the junctions themselves may have fields.
- Lists -- foreign key constraints can be mimicked by requiring a field be a value within a list or recursive list.
- Security -- SSL support/constraints in web interface.
- Full-text indexing and searching -- fields can be indexed by exact value or tokenized.
- Stored procedures -- frequently used queries may be stored for re-execution, with access privileges to the procedures configurable.
- Views -- a record, records or query results can be displayed within arbitrary and configurable HTML templates.
In addition, the database front-end has been designed distinct from the back-end, without loss of consistency in either with respect to other InfraServer interfaces and back-ends. In this way a RelationalDatabase object may be configured to simply be a UI front-end for a third party database, connected with SQL and a JDBC driver. Or, the component may simply serve as a back-end, providing SQL-based database server.
|