MonetDB用户指南5——自动加载脚本

原文：http://www.monetdb.org/Documentation/UserGuide/AutoloadingScript

 

Autoloading scripts

        

Autoloading  is used to initialize a new SQL catalog with scripts containing tables, functions, and procedures while creating a new database withmonetdb. Such scripts are kept in the MonetDB library area./lib/monetdb5/createdb/ . Look them up for the details. The prefix number is used to direct the order of their execution.  A summary of the current collection is illustrated below

 

自动加载脚本用于初始化SQL catalog中的表、函数、存储过程。这些脚本保存在./lib/monetdb5/createdb 目录下。按照前面的序号顺序执行。

 

 

ScriptDescription09_like.sqlString regular pattern matching using PCRE10_math.sqlPolar arithmetic11_times.sqlOS timer and io12_url.sqlURL manipulations (see manual )13_date.sqlPOSIX formatted date coercions ((see man strptime/strftime)14_inet.sqlPostgreSQL inet data type (see manual)15_querylog.sqlQuery history management (see manual)16_tracelog.sqlQuery trace table (see manual)17_compress.sqlBulk gzip column compression (experimental!)18_dictionary.sqlDictionary encoding compression (experimental!)19_cluster.sqlTable clustering functionality (experimental!)20_vacuum.sqlTable vacuum commands (experimental!)21_dependency_functions.sqlSchema analysis22_clients.sqlClient administration procedures23_skyserver.sqlApplication support library24_zorder.sqlApplication support library (experimental!)25_debug.sqlDebugging tools for optimziers26_sysmon.sqlActive SQL query queue management30_rdf.sqlRDF support module39_analytics.sqlAnalytic functions40_jsonstore.sqlMinimalistic Json functionality45_uuid.sqlUUID data type functionality40_geom.sqlGIS extension library (see manual)75_storagemodel.sqlStorage footprint analysis and prediction.80_statistics.sqlAnalyze tables for optimizer statistics99_system.sqlSystem administration (internal)

 

Along the same line, MonetDB library area ./lib/monetdb5/autoload/ contains MAL scripts to be executed each time the server is started.