子信息工程毕业论文中英文对照 数据仓库 正确选择数据采集系统

1、Selecting the Right Data Acquisition SystemprocessEngineers often must monitor a handful of signals over extended periods of time, and then graph and analyze the resulting data. The need to monitor, record and analyze data arises in a wide range of applications, including the design-verification sta

2、ge of product development, environmental chamber monitoring, component inspection, benchtop testing and trouble-shooting.acquire, todaysThis application note describes the various methods and devices you can use to record and analyze data, from the simple pen-and-paper method to using sophisticated

3、data acquisition systems. It discusses the advantages and disadvantages of each method and provides a list of questions that will guide you in selecting the approach that best suits your needs.IntroductionIn geotechnical engineering, we sometime encounter some difficulties such as monitoring instrum

4、ents distributed in a large area, dangerous environment of working site that cause some difficulty for easy access. In this case, operators may adopt remote control, by which a large amount of measured data will be transmitted to a observation room where the data are to be collected, stored and proc

5、essed.The automatic data acquisition control system is able to complete the tasks as regular automatic data monitoring, acquisition and store, featuring high automation, large data store capacity and reliable performance.The system is composed of acquisition control system and display system, with t

6、he following features:1. No. of Channels: 32 ( can be increased or decreased according to users real needs.)2. Scanning duration: decided by user, fastest 32 points/second3. Store capacity: 20G( may be increased or decreased)4. Display: (a) Table of parameter (b) History tendency (c) Column graphics

7、.5. Function: real time monitoring control, warning6. Overall dimension: 50cm50CmX 72cmData acquisition systems, as the name implies, are products and/or processes used to collect information to document or analyze some phenomenon. Inthe simplest form, a technicianlogging the temperature of an oven

8、on a piece of paper is performing data acquisition. As technology has progressed, this type of process has been simplified and made more accurate, versatile, and reliable through electronic equipment. Equipment ranges from simple recorders to sophisticated computer systems. Data acquisition products

9、 serve as a focal point in a system, tying together a wide variety of products, such as sensors that indicate temperature, flow, level, or pressure. Some common data acquistion terms are shown below:Data acquisition technology has taken giant leaps forward over the last 30 to 40 years. For example,

10、40 years ago, in a typical college lab, apparatus for tracking the temperature rise in a crucible of sodiumtungsten- bronze consisted of a thermocouple, a bridge, a lookup table, a pad of paper and a pencil.Todays college students are much more likely to use an automated process and analyze the data

11、 on a PC Today, numerous options are available for gathering data. The optimal choice depends on several factors, including the complexity of the task, the speed and accuracy you require, and the documentation you want. Data acquisition systems range from the simple to the complex, with a range of p

12、erformance and functionality.Pencil and paperThe old pencil and paper approach is still viable for some situations, and it is inexpensive, readily available, quick and easy to get started. All you need to do is hook up a digital multimeter (DMM) and begin recording data by hand.Unfortunately, this m

13、ethod is error-prone, tends to be slow and requires extensive manual analysis. In addition, it works only for a single channel of data; while you can use multiple DMMs, the system will quickly becomes bulky and awkward. Accuracy is dependent on the transcribers level of fastidiousness and you may ne

14、ed to scale input manually. For example, ifthe DMM is not set up to handle temperature sensors, manual scaling will be required. Taking these limitations into account, this is often an acceptable method when you need to perform a quick experiment. Strip chart recorder Modern versions of the venerabl

15、e strip chart recorder allow you to capture data from several inputs. They provide a permanent paper record of the data, and because this data graphical format, they allow you to easily spot trends. Once set up, most recorders sufficient internal intelligence to run unattended without the aid of eit

16、her an operator or acomputer. Drawbacks include a lack of flexibility and relatively low accuracy, which is often constrained to a few percentage points. You can typically perceive only small changes in the pen plots. While recorders perform well when monitoring a few channels over a long period of

17、time, their value can be limited. For example, they are unable to turn another device on or off. Other concerns include pen and paper maintenance, paper supply and data storage, all of which translate into paper overuse and waste. Still, recorders are fairly easy to set up operate, and offer a perma

18、nent record of the data for quick and simple analysis. Scanning digital multimeter Some benchtop DMMs offer an optional scanning capability. A slot in the rear instrument accepts a scanner card that can multiplex between multiple inputs, with 8 to 10 channels of mux being fairly common. DMM accuracy

19、 andthe functionality inherent ininstruments front panel are retained. Flexibility is limited in that it is not possible to expandofis inhaveandthethethePCthisbeyond the number of channels available in the expansion slot. An external PC usually handles data acquisition and analysis.PC plug-in cards

20、PC plug-in cards are single-board measurement systems that take advantage of the ISA or PCI-bus expansion slots in a PC. They often have reading rates as high as 100,000 readings per second. Counts of 8 to 16 channels are common, and acquired data is stored directly into the computer, where it can t

21、hen be analyzed. Because the card is essentially part of computer, it is easy to set up tests. PC cards also are relatively inexpensive, in part, because they rely on the host PC to provide power, the mechanical enclosure and the user interface. Data acquisition options In the downside, PC plug-in c

22、ards often have only 12 bits of resolution, so you cant perceive small variations with the input signal. Furthermore, the electrical environment inside a tends to be noisy, with high-speed clocks and bus noise radiated throughout. Often,electrical interference limits the accuracy of the PC plug-in c

23、ard to that of a handheld DMM .These cards also measure a fairly limited range of dc voltage. To measure other inputsystemsignals, such as ac voltage, temperature or resistance, you may need some sort of external signal conditioning. Additional concerns include problematic calibration and overall co

24、st, especially if you need to purchase additional signal conditioning accessories or a PC to accommodate the cards. Taking that into consideration, PC plug-in cards offer an attractive approach to data acquisition if your requirements fall within the capabilities and limitations of the card. Data lo

25、ggers Data loggers are typically stand-alone instruments that, once they are setup, can measure, record and display data without operator or computer intervention. They can handle multiple inputs, in some instances up to 120 channels. Accuracy rivals that found in standalone bench DMMs, with perform

26、ance in the 22-bit, 0.004-percent accuracy range. Some data have the ability to scale measurements, check results against user-defined limits, and output signals for control.able tosignalOne advantage of using data loggers is their built-in signal conditioning. Most are directly measure a number of

27、different inputs without the need for additional conditioning accessories. One channel could be monitoring a thermocouple, another a resistive temperature device (RTD) and still another could be looking at voltage.loggersThermocouple reference compensation for accurate temperature measurement is typ

28、icallybuilt into the multiplexer cards. A data loggers built-in intelligence helps you set up the test routine and specify the parameters of each channel. Once youhave completeddata loggers can run as standalone devices, much like a recorder. They store data locally in internal memory, which can acc

29、ommodate 50,000 readings or more. PC connectivity makes it easy to transfer data to your computer for in-depth analysis. data loggers are designed for flexibility and simple configuration and operation, provide the option of remote site operation via battery packs or other methods. Depending onthese

30、tup,andMostmanythe A/D converter technique used, certain data loggers take readings at a relatively slow rate, especially compared to many PC plug-in cards. Still, reading speeds of 250 readings/second are not uncommon. Keep in mind that many of the phenomena being monitored are physical in nature s

31、uch as temperature, pressure and flow and change at a fairly slow rate. Additionally, because of a data loggers superior measurement accuracy, multiplereadingsand averaging are not necessary, as they often are in PC plug-in solutions.Data acquisition front endsData acquisition front ends are often m

32、odular and are typically connected to a PC or controller. They are used in automated test applications for gathering data and for controlling and routing signals in other parts of the test setup. Front end performance can be very high, with speed and accuracy rivaling the best standalone instruments

33、. Data acquisition front ends are implemented in a number of formats, including VXI versions, such as the Agilent E1419A multifunction measurement andcontrol VXI module, andproprietary card cages. Althoughfront-end cost has been decreasing, these systems can be fairly expensive, and unless you requi

34、re the high performance they provide, you may find their price to be prohibitive. On the plus side, they do offer considerable flexibility and measurement capability.Data Logger ApplicationsA good, low-cost data logger with moderate channel count (20 - 60 channels) and a relatively slow scan rate is

35、 more than sufficient for many of the applications engineers commonly face. Some key applications include: ? Product characterization? Thermal profiling of electronic products? Environmental testing; env ironmental monitoring? Component characterization? Battery testing? Building and computer room m

36、onitoring? Process monitoring, evaluation and troubleshooting No single data acquisition system works for all applications. Answering the following questions may help you decide which will best meet your needs:1. Does the system match my application?What is the measurement resolution, accuracy and n

37、oise performance? How fast does it scan?What transducers and measurement functions are supported? Is it upgradeable or expandable to meet future needs? How portable is it? Can it operate as a standalone instrument?2. How much does it cost?Is software included, or is it extra? Does it require signal

38、conditioning add-ons? What is the warranty period? How easy and inexpensive is it to calibrate?3. How easy is it to use?Can the specifications be understood? What is the user interface like? How difficult is it to reconfigure for new applications? Can data be transferred easily to new applications?

39、Which application packages are supported?ConclusionData acquisition can range from pencil, paper and a measuring device, to a highly sophisticated system of hardware instrumentation and software analysis tools. The first step for users contemplating the purchase of a data acquisition device or syste

40、m is to determine the tasks at hand and the desired output, and then select the type and scope of equipmentthat meets their criteria. All of the sophisticated equipment and analysis tools that are available are designed to help users understand the phenomena they are monitoring. The tools are merely

41、 a means to an end.正确选择数据采集系统 工程师经常要对很长时间内的很多信号进行监测、画图和分析产生的数据。监测、记录和分析 数据在大范围内的应用趋势上升，包括设计-检定产品发展状态、环境的监测、组成物的检验、benchtop 测试和处理故障检查。 从简单的纸笔记录方法到现在所使用的复杂的数据采集系统这些应用笔记描述了你能获得、记 录和分析数据的很多种不同方法和装置。讨论每一种方法的缺点和优点，然后列出一张能够指 引你选择适合你实际需要的问题单。、八 前言 在工程上，我们有时遇到一些困难，诸如监控设备分散在大范围内，危险的工作环境很容易引 发一些困难。在这种情况下，操作者可能

42、采用视讯遥控，通过大量检测数据传输到检测室，在 那里收集、存储和处理数据。自动数据采集的控制系统能够完成很多任务，像自动定时数据监测，数据采集和存储，高度自 动化为特色，大量数据存储能力和可靠功能。32 点自动数据采集的控制系统和显示系统优如下特点： 1 多通路数： 32 （根据使用者的需要增长或减少） 2 扫描持续时间：由使用者决定，最快一秒种扫描 3 存储容量： 20G （可能增加或减少）4显示：（a）参数表 （b）历史趋势（c）专栏图表5 功能：实时监测、控制和报警6 大体尺寸：50cmX 50cmX 72cm 数据采集系统， 正如名字所暗示的， 是一种用来采集信息成文件或分析一些现象的

43、产品或过程。在最简单的形式中，技术人员将烤箱的温度记录在一张纸上就是数据采集。随着技术的发展， 通过电子设备，这个过程已经得到简化和变得比较精确、多用途和可靠。设备从简单的存储器 发展到复杂的电脑系统。数据采集产品像聚焦点一样为系统服务，和一系列产品一起，诸如传 感器显示温度、水流、程度或者过程。数据采集技术在过去 30 到 40 年以来已经取得了很大的飞跃。举例来说,在 40 年以前 ,在一个著名的学院实验室中 ,为追踪用青铜做的坩埚中的温度上升情况的装置是由热电偶、继电器、查 询台、一捆纸和一支铅笔。今天的大学学生很可能在 PC 机上自动处理和分析数据，有很多种可供你选择的方法去采集数 据

44、。至于选择哪一种方法取决于多种因素，包括任务的复杂度、你所需要的速度和精度、你想 要的证据资料等等。无论是简单的还是复杂的，数据采集系统都能够运行并发挥它的作用。铅笔和纸 用铅笔和纸的旧方式对于一些情形仍然是可行的，而且它便宜、易获得、快速和容易开始。而 你所需要的就是捕捉到多路数字信息（ DMM ），然后开始用手记录数据。 不幸的是这种方法容易发生错误、采集数据变慢和需要太多的人工分析。此外，它只能单通道 采集数据；但是当你使用多通道 DMM 时，系统将很快变得非常庞大和呆笨拙。精度取决于誊 写器的水平，并且你可能需要自己动手依比例输入。举例来说 , 如果 DMM 没有配备处理温度 的传感器

45、 ,旧需要动手找比例。考虑到这些限制，只有当你需要实行一个快速实验时，它才是一 个可接受的方法。长条图表记录仪 现代多种版本的长条图表记录仪允许你从多个输入取得数据。 他们提供数据的长备纸记录 ,因为 数据是图解的格式 ,他们易于现场采集数据。一旦建立了长条图表记录仪，在没有操作员或计算 机的情况下，大多数记录仪具有足够的内部智能运行。缺点是缺乏灵活性和相对的精度低，时 常限制在百分点。你能很清楚地感觉到与笔只有小的改变。在多通道内较长时间的监控，记录 仪能发挥很好的作用，除此之外，它们的价值得到限制。举例来说，他们不能够与另外的装置 轮流作用。其他的顾虑就是笔和纸的维护,纸的供给和数据的存储

46、 ,最重要的是纸的滥用和浪费。然而，记录仪相当容易建立和操作，为数据快速而简单的分析提供永久的记录。数字扫描传多用表 一些 benchtop DMMs 提供可选择的扫描能力。仪器的背面有一个槽孔接收一张在较多输入时 能多重发讯的扫描仪卡片，通常是 8 到 10 通道的 mux 。固有的在仪器的前面嵌板中的受到限 制。它的柔韧性也受到限制，因为它不能超过可用通道数。外部的 PC 机通常处理数据采集和 分析。PC 机插件卡片,建立测试是容易的。 PC 机卡也相对的便宜 ,一部分地， 机械附件和使用界面。12 字的容量 ,因此你不能察觉输入信号的小变化。此外,PC产生高速率的时钟和总线噪声，电子接触

47、面限制 PC 机PC 机插件卡片是单板测量系统，它利用 ISA 或 PCI 总线在 PC 机内扩大插槽。它们时常具有 高达每秒 1000 的阅读速率。 8 到 16 通道是普遍的，采集的数据直接存储在电脑里，然后进行 分析。因为卡片本质上是计算机的一部分 因为他们以来主机 PC 去提供能源、 数据采集的选择 在缺点上， PC 机插件卡片时常只有 机内的电子环境经常很容易发出噪声、 插件卡片的精度。这些插件卡片也测量一定范围的电压。为了测量其他输入信号，如电压、温 度和阻力，你也许需要一些外部信号监测的器件。其它关心包括复杂的校正和全部的系统成本 尤其如果你需要购买额外信号监测器件或用 PC 机

48、适应插件卡片。把这些考虑进去，如果你的 需要在卡片的能力和限制范围内变动， PC 机插件卡片给数据采集提供吸引人的方法。 数据电子自动记录仪 数据电子自动记录仪是典型的单机仪器，一旦配备它们,就能测量、记录和显示数据而不需要操作员或计算机参与。它们能够处理多信号输入，有时可达 120 通道。 精度可与无与伦比的台 式 DMMs 匹敌 , 由于它在 22 字、 0.004 个百分率的精度范围内运转。一些数据电子自动记录 仪有能力按比例测量 ,检查结果不受使用者定义的限制 ,而且输出为控制作信号。 使用数据电子自动记录仪的一个好处就是他们的内部监测信号。大部分能够直接地测量若干不 同的输入信号，而

49、不需要额外的信号监测器件。一个通道能够监测热电偶、温阻器（ RTD ）和 电压。 热电偶为准确的温度测量提供具有参考价值的补偿，是很典型的配备了多路插件卡片。内设智 能数据电子自动记录仪帮助你设定测量周期和具体指定每个通道的参数。一旦你全部设定好， 数据电子自动记录仪就如同无与伦比的装置运行。它们存储的数据分布在内存中, 能够容纳500000 或更多的阅读量。与 PC 机连接容易将数据传送到电脑进行进一步的分析。大多数数据电子自动记录仪可设计为 柔性和简单的组态和操作 , 而且经由电池包裹或其它方法，多数提供远程位置的操作选项。靠A/ D 转换技术 ,一定的数据电子自动记录仪阅读的速率比较低，

50、尤其是跟PC 机插件卡片比较。然而，每秒 250 的阅读速率比较少见。要牢记正在测量的许多现象本质上是物理的，如温度、 压力和流量，而且一般有较少的变动。此外，因为数据电子自动记录仪的监测精度,多量且平均阅读没有必要，就像它们经常在 PC 记插件卡片一样。前端数据采集 前端数据采集经常做成模块而且是典型地与 PC 机或控制器连接。 他们被用于自动化的测试中， 为其它测试装备采集数据、控制和循环检测信号。发送信号测试装备的零配件。前端运转的效 率是非常高的 , 能与速度和精度与最好的单机仪器匹敌。前端数据采集在很多模型里都能运行， 包括VXI版本,如Agile nt E1419A 多功能测量和

51、VXI控制模型，还有专有的卡片升降室。虽然 前端器成本已经降低 ,但是这些系统可能会非常贵 ,除非你需要提供高的运转 ,而查找它们的价格 是禁止的。另一方面 ,它们的确能够提供相当多的可挠性和测量能力。20-60 通道）和扫描速率相对低但对于数据电子自动记录仪的应用 好的、成本低的数据电子自动记录仪有合适的通道数（ 多数工程师的普遍应用已足够。一些关键的应用包括 ?产品特征 ?电子产品的热靠模切削 ?环境的测试 ; 环境的监测 ?组成物特征 ?电池测试 ?建筑物和计算机容量监测 ?过程监测，评估和故障修理 没有哪一种数据采集系统能够适应所有情况。回答下列各问题，可能帮助你决定选哪一种数据 采集

52、系统最适合你的实际情况：?它扫描多快 ? 什么传感器和支持什么测量功能?为了将来的?它是便携式的吗 ? 它操作起来，是一个无与伦比的仪器吗 ?1 系统跟我的应用匹配吗 ? 测量方法、精度和噪声处理是什么 需要，它是可升级的还是可扩张的2 它的成本是多少 ?软件被包括在内 ,还是额外之物 ?它需要以信号数据片为条件吗 ?可靠的周期是多少 ?它有多容易 的校正 ?3 它有多容易使用 ?规格能被了解吗 ?使用者界面如何 ?为新的应用，再配置有多困难 ?数据能容易地被转移到新的 应用吗 ?支持哪一种应用包 ?结论 数据采集能从铅笔，纸和一个测定装置发展到一个高度复杂的系统硬件仪表和软件分析工具。 使用

53、者打算购买数据采集装置或系统的第一步决定于身边的任务和想要的输出，然后选择类型 和仪器符合他们的标准的范围。所有的复杂的设备和分析工具是帮助使用者理解检测对象。工 具仅仅是对一个目的的一种方法。DATA WAREHOUSEData warehousing provides architectures and tools for business executives to systematically organize, understand, and use their data to make strategic decisions. A large number of organizat

54、ions have found that data warehouse systems are valuable tools in todays competitive, fast evolving world. In the last several years, many firms have spent millions of dollars in building enterprise-wide data warehouses. Many people feel that with competition mounting in every industry, data warehou

55、sing is the latest must-have marketing weapon a way to keep customers by learning more about their needs.“ So, you may ask, full of intrigue,“ what exactly is a data warehouse?Data warehouses have been defined in many ways, making it difficult to formulate a rigorous definition. Loosely speaking, a

56、data warehouse refers to a database that is maintained separately from an organizations operational databases. Data warehouse systems allow for the integration of a variety of application systems. They support information processing by providing a solid platform of consolidated, historical data for

57、analysis.According to W. H. Inmon, a leading architect in the construction of data warehouse systems, “ a data warehouse is a su-obrjieecntted, integrated, time-variant, and nonvolatile collection of data in support of managements decision making process. This short, but comprehensive definition pre

58、sents the major features of a data warehouse. The four keywords, subject-oriented, integrated, time-variant, and nonvolatile, distinguish data warehouses from other data repository systems, such as relational database systems, transaction processing systems, and file systems. Lets take a closer look

59、 at each of these key features.(1) .Subject-oriented: A data warehouse is organized around major subjects, such as customer, vendor, product, and sales. Rather than concentrating on the day-to-day operations and transaction processing of an organization, a data warehouse focuses on the modeling and analysis of data for decisio