src/ports/postgres/modules/convex/test/lmf.ic.sql_in

/* ----------------------------------------------------------------------- *//**
 *
 * 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.
 *
 *//* ----------------------------------------------------------------------- */

/* -----------------------------------------------------------------------------
 * Test Low-rank Matrix Factorization
 * -------------------------------------------------------------------------- */

CREATE TABLE "Mlens" (
    id serial,
    "User_id" integer,
    "Movie_id" integer,
    "Rating" double precision
);

COPY "Mlens" ("User_id", "Movie_id", "Rating") FROM stdin DELIMITER ',';
22,377,1
6,86,3
62,257,2
95,546,2
38,95,5
13,225,4
12,203,3
\.

SELECT lmf_igd_run(
    'test_lmf_model',
    '"Mlens"',
    '"User_id"',
    '"Movie_id"',
    '"Rating"',
    943,        -- row_dim
    1682,       -- col_dim
    2,          -- max_rank
    0.03,       -- stepsize
    0.1,        -- init_value
    5,          -- num_iterations
    1e-3        -- tolerance
    );