FBDataGuard 3.3

IBSurgeon is glad to announce the new version of Firebird monitoring, backups and anticorruption tool – FBDataGuard 3.3, which introduces new features and several bugfixes.

Now FBDataGuard monitors lock table and deadlock parameters, which are very important for a good performance for Firebird Classic and SuperClassic architectures. FBDataGuard also gives intelligent suggestions how to change appropriate Firebird configuration parameters to fix encountered problems.

FBDataGuard 3.3 is free for all existing FBDataGuard users, and EUR149/server for new licenses. For companies with many installations of Firebird we offer an ISV unlimited subscription for EUR990/year: an ability to install as many FBDataGuards as needed.
Download FBDataGuard 3.3.

Database .NET 14.9 released

Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface. (Full support for Firebird 1.5~3.0)

You’re welcome to download it from http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multi-language.

Aggregate linear regression functions added in Firebird 3.0

Linear regression functions added in Firebird 3.0 :

REGR_AVGX(Y, X) = SUM(X) / N
REGR_AVGY(Y, X) = SUM(Y) / N
REGR_COUNT(Y, X) = N
REGR_INTERCEPT(Y, X) = REGR_AVGY(Y, X) – REGR_SLOPE(Y, X) * REGR_AVG_X(Y, X)
REGR_R2(Y, X) = POWER(CORR(Y, X),2)
REGR_SLOPE(Y, X) = COVAR_POP(Y, X)
REGR_SXX(Y, X) = N * VAR_POP(X)
REGR_SXY(Y, X) = N * COVAR_POP(Y, X)
REGR_SYY(Y, X) = N * VAR_POP(Y)

Contributed by Hajime Nakagami.

Github pull request: https://github.com/FirebirdSQL/core/pull/4

1 81 82 83 84 85 200