You are here

DataStore

JAVA DataStore Products (Available today)

The Java databases are proven and being used in 52 countries for both business and consumer applications supporting 50,000+ users per application. The Lite version has a 70K footprint (smallest in the industry), the Standard version has a 130K footprint and the Advanced version has a 300K footprint. The Standard or higher versions have most SQL 92 features, encryption, UTF8, language-specific sort templates, triggers, views, nested queries, and many more features. The advance version includes 2D and 3D geospatial capabilties.

Characteristics (Many of the functions can be removed upon request to shrink the DB size and further improve performance):

  • Storage mode, Memory mode, Combination of storage and memory mode
  • Built-in JDBC (In the very near future, we will also have an ODBC driver)
  • Database Encryption: great for financial transactions and digital media (music, video, etc.)
  • UTF-8 Unicode Support: with language, specific sort templates (starting with English, Spanish, French, German, Italian, Chinese and Arabic)
  • Views with limited update and delete capabilities
  • Triggers
  • Referential integrity
  • ACID Support (Autocommit, Commit, Rollback)
  • Data Types: Data Types: INTEGER, STRING, TEXT,CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, DATE, TIME, TIMESTAMP, DECIMAL, BYTE, SHORT, BLOB, CLOB, NCLOB, BOOLEAN, FLOAT, DOUBLE, SMALLINT, INT
  • Select Statements: Support WHERE, and all Aggregate Functions, all Predicate Functions, etc.
  • Joins Functions: Inner Joins (Equi-join / Natural join, Cross join), Outer Joins (Left outer join, Right outer join, Full outer join), Self Join, Sub-Queries, Nested Queries, Union
  • Predicate Functions: Comparison (">","<", "=", etc.), LIKE, AND, OR NOT, BETWEEN, LIMIT
  • Aggregate Functions: DISTINCT, COUNT, GROUP BY, HAVING, IN, EXISTS, SUM, TOTAL, MAX, MIN, AVG
  • String Functions: UPPER, LOWER, LENGTH, LTRIM, RTRIM, ISNULL, REPLACE, SOUNDEX, SUBSTRING, TRIM
  • Arithmetic Functions: ABS, COALESCE, CEIL, FLOOR, EXP, POW, LN, ROUND, ROOT
  • Date Functions: ADDMONTHS, ADDDAYS, CURRENTDATE, CURRENTTS, DIFFDATE, DATEFORMAT, TODATE, TOTIME, TOTIMESTAMP
  • Cursor Functions: Scrollable and Updatable

Communities

© Zoduna Corportation 2012