Software

Huawei Gauss DB

Huawei GaussDB is an enterprise-class AI-Native distributed database that uses the massively parallel processing (MPP) architecture.

GaussDB supports both row and column-oriented storage and is capable of processing petabytes of data. GaussDB offers a cost-efficient, general-purpose computing platform to manage massive data sets and is compatible with a wide range of data warehousing systems, business intelligence (BI) systems, and decision support systems (DSS).

Huawei GaussDB integrates AI technology into the database kernel architecture and algorithms, providing users distributed databases with higher performance, higher availability, and more diverse computing power.
Más software empresarial

Documentación y recursos

How to repair SQL Server databases with Stellar Repair MS SQL

How to Repair Corrupt SQL Database with the help of Stellar Repair for MS SQL software.Most Recommended software by MVP's and administrators to repair corrupt MDF and NDF files. It recovers tables, triggers, indexes, keys, rules and stored procedures. It supports SQL Server 2017, 2016, 2014, 2012, 2008, 2008R2 and all lower versions.

The beginners guide to NoSQL

Beginners guide to NoSQLTake advantage of noSQL by learning the basics and more with this FREE eBook offered by Robert Gordon University that includes:

  • An introduction to noSQL
  • The four different types of noSQL database that exist
  • The difference between SQL and noSQL and which to choose for your work

 
Más recursos sobre software empresarial

Entradas de blog

Detecting indexes, tables and packages not used on DB2

By Oscar_paredes on Mon, 02/10/2020 - 19:53

DB2, from version 9.7, allows to know easily what indexes are not being used in a Database. The query is also for tables and packages.

This is a useful tool for tuning indexes and detecting problems in their use.

After version 9.7 DB2 includes a new LASTUSED field in the SYSCAT.INDEXES, SYSCAT.TABLES and SYSCAT.PACKAGES tables.

This field indicates the date of last use of indexes, tables or packages.

For example, to query unused indexes since 1/1/2019, you could use this simple query:

more posts
Más videos IT

Publicaciones en la red

PostgreSQL HA with Patroni: Your Turn to Test Failure
Scenarios

PostgreSQL HA with Patroni

A couple of weeks ago, Jobin and I did a short presentation during Percona Live Online bearing a similar title as the one for this post: “…

Read on:

https://www.percona.com/blog/2021/06/11/postgresql-ha-with-patroni-your…

Delaying Standby Database Recovery

Does it ever make sense to delay database recovery from your Standby? With the right DB recovery strategy in place, delays might be your best move.

Read on:

https://www.databasejournal.com/features/standby-database.html

More publications from the net