Package org.odpi.openmetadata.adapters.connectors.duckdb.survey

Class DuckDBDatabaseStatsExtractor

java.lang.Object

org.odpi.openmetadata.adapters.connectors.duckdb.survey.DuckDBDatabaseStatsExtractor

public class DuckDBDatabaseStatsExtractor
extends Object

DuckDBDatabaseStatsExtractor gathers statistics about the schemas, tables and columns of a DuckDB database using DuckDB's own catalog metadata table functions (duckdb_schemas(), duckdb_tables() and duckdb_columns()) and converts them into the same vendor-neutral measurement beans used by the other database connector suites (RelationalDataManagerMeasurement, RelationalSchemaMeasurement, RelationalTableMeasurement and RelationalColumnMeasurement), tagged with the reused SurveyDatabaseAnnotationType constants.
DuckDB, being embedded, does not expose the same workload statistics as a client/server database (there is no equivalent of Postgres's pg_stat_database/pg_table_size/pg_column_size). Where DuckDB does not provide an equivalent measurement, the corresponding field is simply left at its default value.

Constructor Summary

Constructors

Constructor	Description
DuckDBDatabaseStatsExtractor(List<String> validDatabases, List<String> excludedSchemas, List<String> includedSchemas, SurveyActionServiceConnector surveyActionServiceConnector)	Constructor sets up the list of databases to process, the schemas within them to survey, and the connection to the database.
DuckDBDatabaseStatsExtractor(List<String> validDatabases, SurveyActionServiceConnector surveyActionServiceConnector)	Constructor sets up the list of databases to process and the connection to the database.

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

DuckDBDatabaseStatsExtractor

public DuckDBDatabaseStatsExtractor(List<String> validDatabases,
 SurveyActionServiceConnector surveyActionServiceConnector)

Constructor sets up the list of databases to process and the connection to the database. Every schema in those databases is surveyed.

Parameters:

validDatabases - list of database names

surveyActionServiceConnector - calling connector

DuckDBDatabaseStatsExtractor

public DuckDBDatabaseStatsExtractor(List<String> validDatabases,
 List<String> excludedSchemas,
 List<String> includedSchemas,
 SurveyActionServiceConnector surveyActionServiceConnector)

Constructor sets up the list of databases to process, the schemas within them to survey, and the connection to the database.

Parameters:

validDatabases - list of database names

excludedSchemas - schemas to leave out (null means none are excluded)

includedSchemas - the only schemas to survey (null means all that are not excluded); takes precedence over excludedSchemas

surveyActionServiceConnector - calling connector