我想将以下内容存储在数据库中。我该怎么办？ [英] I want to store the following things in a database. How should I proceed?

问题描述

 How to store CPU usage activity to consider it for later use?

How to store RAM usage variation for a certain amount of time?

Similarly, how to store Disk usage?

All these data will be later used for ANOVA test.

什么我试过了：



我试图从ac＃应用程序中获取这些值，这将监视系统的活动一段时间。

What I have tried:

I am trying to get these values from a c# application which will be monitoring the activities of a system for a certain amount of time.

The datatype is not the issue. Can you all tell me the extra attribute I need? 
Or should I store them in a single table or different tables? IF different then what should be foreign key relation among them

推荐答案

Quote：

我需要一种正确的方法来存储这些东西，以便检索是最佳的。

I need a proper way to store these things so that the retrieval is optimal.

简单：将它们以SQL等效数据类型存储到您已汇编的C＃值： DateTime DATETIME列中的值， int32 in INT ， int64 在 BIGINT 中，依此类推。然后将它们作为参数化查询传递。

Simple: store them in the SQL equivalent datatype to the C# values you have assembled: DateTime values in DATETIME columns, int32 in INT, int64 in BIGINT, and so forth. Then pass them over as a parameterised query.

要获取相当多的技能，请向Google询问以下主题：

1.数据库设计

2.数据库的选择及其实现

3. SQL

4.创建具有数据库访问权限的Windows应用程序

There are quite a number of skills to acquire, ask Google for topics on:
1. Database design
2. Choice of databases and their implementation
3. SQL
4. Creating a windows application with database access

这篇关于我想将以下内容存储在数据库中。我该怎么办？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！