Monday, December 16, 2013

Importance of Progress Database and Administration


           
                  Progress DB is one of the oldest and legacy Databases. The number of companies using this Database may be less but the data handled by progress is extremely huge. I am working as a Progress DBA since April 2013, i am working in Progress Openedge 10.2B so whatever the information i provide here will be applicable to this and higher version of DB. Here I can share you the importance of Progress DB related stuffs.


Progress Database Key Capabilities:
  • Supports 32-bit systems and 64-bit addressable systems as well
  • Compatible ODBC, JDBC, and ABL access to data
  • Java stored procedures supported by OpenEdge SQL
  • Large file support for 64-bit file addressing (requires OS enablement)
  • Support for 1,000 files per database storage area
  • Support for 32,000 storage areas per database
  • Support for 32,000 concurrent users
  • Support for tables of up to 9 quintillion rows
  • Databases can grow to 5 Exabyte
  • Support for up to 1 terabyte of memory

Available for:
  • HP-UX (PA-RISC) 64- and 32-bit
  • HP-UX Itanium2
  • IBM AIX Power PC 64-bit
  • Red Hat Linux
  • SuSE LINUX
  • Sun Solaris (SPARC) 64- and 32-bit
  • Windows


         

No comments:

Post a Comment