SharkSQL Community Forum

As a FYI, the SharkSQL database field test V5.0-4 update release notes for OpenVMS X86, Integrity, (Alpha later this week) are now available on the SharkSQL.com web site: SharkSQL Document and Resource Library

In addition to a few bug fixes, this release contains two (2) new utilities in sharksql$examples -

1. PERSONNEL.COM in sharksql$examples. This is a DCL menu driven utility that can be used to create the SharkSQL sample database PERSONNEL and perform various database operations (backup, restore, loading data from binary load files and CSV files and dropping the database). The PERSONNEL database is very similar to the sample database provided by Oracle Rdb and highlights various SharkSQL configuration options.
   
   By examining the DCL script PERSONNEL.COM, one can see actual examples of configuring:
   
   Multiple schemas using -
   1. Value based partitioning
   2. Domain usage
   3. Cross-schema views
   4. Cross-schema foreign key constraints
   5. Cross-schema triggers
   6. Check constraints and computed values
   7. Data security features
      - Page and Record encryption
      - Signature constraint
      - Column NO UPDATE constraint (prevents a column from being updated with an UPDATE statement)
2. BENCHMARK.COM in sharksql$examples. This is a DCL menu driven utility and is based on the pgbench benchmark test available for PostgreSQL (sort of TPC-B test). With this SharkSQL benchmark utility you can:
   1. Create the BENCHMARK database
   2. Load data into the tables of the BENCHMARK database, so one can run benchmark tests with different amounts of data
   3. Execute read-write benchmark tests
   4. Execute read-only benchmark tests
   5. Display all benchmark test results since the BENCHMARK database has been created

Resources:
- General Information: Info@sharksql.com
- Technical Support: Support@sharksql.com
- SharkSQL Community Forum