search

alligo / joomla-data-mining-and-machine-learning

Joomla! CMS Data Mining SQL Queries examples. Useful to extract data for analysis on external tools
MIT License
1 stars 0 forks source link

joomla-articles-meta.sql #2

Open fititnt opened 3 years ago

fititnt commented 3 years ago 
-- ID:             joomla-articles-meta
-- DESCRIPTION:    This query focus on return relationships from articles with
--                 users, categories and tags. But, despite title of article,
--                 will not load article content.
-- 
-- AUTHOR:         Emerson Rocha <emerson[at]alligo.com.br>
-- COMPANY:        Alligo
-- LICENSE:        "SPDX-License-Identifier: MIT"
-- CREATED:        2021-01-18 22:44 BRT
-- REVISION:       ---

The joomla-articles-meta.sql is meant to be used for data mining. Some fields, like content_title and category_title are commented out because tools, in special Weka, will complaint about commas and other strange characters.

Also, because of Weka, the last exported field is content_hits. If user does not explicitly change, it will assume as the field that is the class/target.