madlib_keras.sql_in File Reference

SQL functions for multilayer perceptron. More...

Functions
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations, integer gpus_per_host, varchar validation_table, integer metrics_compute_frequency, boolean warm_start, varchar name, varchar description)
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations, integer gpus_per_host, varchar validation_table, integer metrics_compute_frequency, boolean warm_start, varchar name)
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations, integer gpus_per_host, varchar validation_table, integer metrics_compute_frequency, boolean warm_start)
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations, integer gpus_per_host, varchar validation_table, integer metrics_compute_frequency)
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations, integer gpus_per_host, varchar validation_table)
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations, integer gpus_per_host)
void	madlib_keras_fit (varchar source_table, varchar model, varchar model_arch_table, integer model_arch_id, varchar compile_params, varchar fit_params, integer num_iterations)
bytea	fit_transition (bytea state, smallint[] dependent_var, real[] independent_var, text model_architecture, text compile_params, text fit_params, integer current_seg_id, integer[] seg_ids, integer[] images_per_seg, integer gpus_per_host, integer segments_per_host, bytea prev_serialized_weights)
bytea	fit_merge (bytea state1, bytea state2)
bytea	fit_final (bytea state)
aggregate bytea	fit_step (smallint[], real[], text, text, text, integer, integer[], integer[], integer, integer, bytea)
void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type, integer gpus_per_host)
void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table, varchar pred_type)
void	madlib_keras_predict (varchar model_table, varchar test_table, varchar id_col, varchar independent_varname, varchar output_table)
float8[]	internal_keras_predict (real[] independent_var, text model_architecture, bytea model_data, boolean is_response, float8 normalizing_const, integer current_seg_id, integer[] seg_ids, integer[] images_per_seg, integer gpus_per_host, integer segments_per_host)
void	madlib_keras_evaluate (varchar model_table, varchar test_table, varchar output_table, integer gpus_per_host)
void	madlib_keras_evaluate (varchar model_table, varchar test_table, varchar output_table)
real[3]	internal_keras_eval_transition (real[3] state, smallint[] dependent_var, real[] independent_var, text model_architecture, bytea serialized_weights, text compile_params, integer current_seg_id, integer[] seg_ids, integer[] images_per_seg, integer gpus_per_host, integer segments_per_host)
real[3]	internal_keras_eval_merge (real[3] state1, real[3] state2)
real[2]	internal_keras_eval_final (real[3] state)
aggregate real[2]	internal_keras_evaluate (smallint[], real[], text, bytea, text, integer, integer[], integer[], integer, integer)
varchar	madlib_keras_fit (varchar message)
varchar	madlib_keras_fit ()
varchar	madlib_keras_evaluate (varchar message)
varchar	madlib_keras_evaluate ()
varchar	madlib_keras_predict (varchar message)
varchar	madlib_keras_predict ()

Detailed Description

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Date

June 2012

Function Documentation

bytea fit_final

(

bytea

state

)

bytea fit_merge	(	bytea	state1,
		bytea	state2
	)

aggregate bytea fit_step	(	smallint	[],
		real	[],
		text	,
		text	,
		text	,
		integer	,
		integer	[],
		integer	[],
		integer	,
		integer	,
		bytea
	)

bytea fit_transition	(	bytea	state,
		smallint[]	dependent_var,
		real[]	independent_var,
		text	model_architecture,
		text	compile_params,
		text	fit_params,
		integer	current_seg_id,
		integer[]	seg_ids,
		integer[]	images_per_seg,
		integer	gpus_per_host,
		integer	segments_per_host,
		bytea	prev_serialized_weights
	)

real [2] internal_keras_eval_final

(

real

state[3]

)

real [3] internal_keras_eval_merge	(	real	state1[3],
		real	state2[3]
	)

real [3] internal_keras_eval_transition	(	real	state[3],
		smallint[]	dependent_var,
		real[]	independent_var,
		text	model_architecture,
		bytea	serialized_weights,
		text	compile_params,
		integer	current_seg_id,
		integer[]	seg_ids,
		integer[]	images_per_seg,
		integer	gpus_per_host,
		integer	segments_per_host
	)

aggregate real [2] internal_keras_evaluate	(	smallint	[],
		real	[],
		text	,
		bytea	,
		text	,
		integer	,
		integer	[],
		integer	[],
		integer	,
		integer
	)

float8 [] internal_keras_predict	(	real[]	independent_var,
		text	model_architecture,
		bytea	model_data,
		boolean	is_response,
		float8	normalizing_const,
		integer	current_seg_id,
		integer[]	seg_ids,
		integer[]	images_per_seg,
		integer	gpus_per_host,
		integer	segments_per_host
	)

void madlib_keras_evaluate	(	varchar	model_table,
		varchar	test_table,
		varchar	output_table,
		integer	gpus_per_host
	)

void madlib_keras_evaluate	(	varchar	model_table,
		varchar	test_table,
		varchar	output_table
	)

varchar madlib_keras_evaluate

(

varchar

message

)

varchar madlib_keras_evaluate

(

)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		integer	gpus_per_host,
		varchar	validation_table,
		integer	metrics_compute_frequency,
		boolean	warm_start,
		varchar	name,
		varchar	description
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		integer	gpus_per_host,
		varchar	validation_table,
		integer	metrics_compute_frequency,
		boolean	warm_start,
		varchar	name
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		integer	gpus_per_host,
		varchar	validation_table,
		integer	metrics_compute_frequency,
		boolean	warm_start
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		integer	gpus_per_host,
		varchar	validation_table,
		integer	metrics_compute_frequency
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		integer	gpus_per_host,
		varchar	validation_table
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations,
		integer	gpus_per_host
	)

void madlib_keras_fit	(	varchar	source_table,
		varchar	model,
		varchar	model_arch_table,
		integer	model_arch_id,
		varchar	compile_params,
		varchar	fit_params,
		integer	num_iterations
	)

varchar madlib_keras_fit

(

varchar

message

)

varchar madlib_keras_fit

(

)

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type,
		integer	gpus_per_host
	)

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table,
		varchar	pred_type
	)

void madlib_keras_predict	(	varchar	model_table,
		varchar	test_table,
		varchar	id_col,
		varchar	independent_varname,
		varchar	output_table
	)

varchar madlib_keras_predict

(

varchar

message

)

varchar madlib_keras_predict

(

)