Comparison of relational database management systems: Difference between revisions

Revision as of 18:48, 11 December 2024

Revision as of 20:15, 11 December 2024

Line 195:

| [[IBM]] / [[HCLTech|HCL Technologies]]

| <span style="display:none">1981????</span>1980

| 1415.100.xC90.0

| 20222024-1011-0320

| {{Proprietary}}

| {{No}}

Line 1,914:

|-

! style="text-align:left" | [[Informix Dynamic Server]]

| ≈128≈0.5 PBYB<sup id="limit_12_back">[[#limit 12|12]]</sup>

| ≈128 PB≈0,5YB<sup id="limit_12_back">[[#limit 12|12]]</sup>

| 32,765 bytes (exclusive of large objects)

| 32,765

Line 2,278:

* <cite id="limit_10">[[#limit 10 back|Note (10):]]</cite> Informix DATETIME type has adjustable range from YEAR only through 1/10000th second. DATETIME date range is 0001-01-01 00:00:00.00000 through 9999-12-31 23:59:59.99999.

* <cite id="limit_11">[[#limit 11 back|Note (11):]]</cite> Since version 12c. Earlier versions support up to {{val|4000|u=B}}.

* <cite id="limit_12">[[#limit 12 back|Note (12):]]</cite> The {{val|1280.5|u=PBYB}} limit refers to the storage limit of a single Informix server instance beginning with v15.0. Informix v12.10 and later versions support using sharding techniques to distribute a table across multiple server instances. A distributed Informix database has no upper limit on table or database size.

* <cite id="limit_13">[[#limit 13 back|Note (13):]]</cite> Informix DECIMAL type supports up to 32 decimal digits of precision with a range of {{10^|-130}} to {{10^|125}}. Fixed and variable precision are supported.