如何最好地编码媒体监控系统 [英] How best to code a media monitoring system

问题描述

我是新来的，所以我的问题对大多数人来说似乎有些愚蠢，编程也不是我的力量。



我的任务就是创建一个媒体监测和报告系统在工作。我仍然是一名实习生，所以我不太擅长从哪里开始。它应该是非常基础的，数据输入应该是手动的。例如：如果电视节目提到某个关键字，如公司名称，系统的用户应该能够输入电视节目的名称，频道，时间/日期和提及的情绪并保存（我是我已经看到我需要一个DB了。系统应该能够从数据库中提取信息以形成报告和图形。



我非常感谢对此事的一些见解。特别是关于哪些技术和/或程序最好用于构建这样的系统。现在一切都应该是手动的，所以我不需要在线。我还被告知不要担心将系统扩展到在线平台。重点是其他形式的媒体（电视，广播，杂志等）。



提前谢谢



我尝试了什么：



我在考虑使用SQL Server Express和Visual Studio Express来简化（因为它们都是属于MS），我也熟悉它们。但我也被告知有关MySQL，XAMPP和MyPHPAdmin的简单替代方案，但我对这些程序一无所知。我对它们进行了一些研究，但我想知道你的偏好是什么以及为什么。

正如我所提到的，我仍然是这一切的新手，我正在寻找方向甚至开始

I'm new here so my question might seem a bit dumb to most and also, programming is not my strength.

I was just tasked with creating a media monitoring and reporting system at work. I am still an intern so I'm not too clued up on where to start. It is supposed to be very basic and data input should be manual. For example: if a TV program mentioned a certain keyword like the company name, the user of the system should be able to input the name of the TV show, channel, time/date and sentiment of the mention and save it (I'm already seeing that I'll need a DB for this). The system should have the ability to pull information from the database to form reports and graphs.

I would extremely appreciate some insight on this matter. Particularly about which technologies and/or programs are best to use to build such a system. For now everything should be manual so I don't need it be online. I was also told not to worry about expanding the system to online platforms. The focus is on other forms of media (TV, radio, magazines etc.).

Thank you in advance

What I have tried:

I was thinking of using SQL Server Express with Visual Studio Express for simplicity (since they both belong to MS) and I am also familiar with them. But I was also told about MySQL, XAMPP and MyPHPAdmin as easy alternatives but I know nothing about those programs. I did a bit of research on them but I would like to know what your preferences are and why.
As I mentioned, I am still new to all this and I am seeking direction about where to even start

推荐答案

第一个 - 也许是最痛苦的 - 部分是根据所需的报告（要创建的存储过程）设计数据库。



这部分可以在不决定以后使用哪种SQL数据库引擎和编程语言的情况下完成。



使用MS产品时因为你知道它们可能会更快实现它，XAMPP解决方案可以更简单地移植到不同的平台，比如基于Linux的平台。

The first - and probably most painful - part is designing the database with respect to the required reports (stored procedures to be created).

This part can be done without deciding which SQL database engine and programming language will be used later.

While using the MS products will get it probably faster realised because you know them, an XAMPP solution can be simpler ported to a different platform like a Linux based one later.

添加Jochen所说的，如果你是实习生和你的主管推荐MySql和PHP，然后我建议在做出决定之前与他交谈：可能是他们是整个公司的首选语言，所以使用其他东西可能是不可接受的。

To add to what Jochen says, if you are an intern and your supervisor is recommending MySql and PHP, then I'd suggest talking to him before making a decision: it may be that they are the "preferred languages" for the whole company so using something else may be unacceptable.

这篇关于如何最好地编码媒体监控系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！