微机发展简史
I EEE的论文剑桥大学，2004/2/5
莫里斯威尔克斯
计算机实验室
剑桥大学
第一台存储程序的计算开始出现于1950前后，它就是1949年夏天在剑桥大学，我们创造的延迟存储自动电子计算机（EDSAC）。
最初实验用的计算机是由象我一样有着广博知识的人构造的。我们在电子工程方面都有着丰富的经验，并且我们深信这些经验对我们大有裨益。后来，被证明是正确的，尽管我们也要学习很多新东西。最重要的是瞬态一定要小心应付，虽然它只会在电视机的荧幕上一起一个无害的闪光，但是在计算机上这将导致一系列的错误。
在电路的设计过程中，我们经常陷入两难的境地。举例来说，我可以使用真空二级管做为门电路，就象在EDSAC中一样，或者在两个栅格之间用带控制信号的五级管，这被广泛用于其他系统设计，这类的选择一直在持续着直到逻辑门电路开始应用。在计算机领域工作的人都应该记得TTL，ECL和CMOS，到目前为止，CMOS已经占据了主导地位。
在最初的几年，IEE（电子工程师协会）仍然由动力工程占据主导地位。为了让IEE 认识到无线工程和快速发展的电子工程并行发展是它自己的一项权利，我们不得不面对一些障碍。由于动力工程师们做事的方式与我们不同，我们也遇到了许多困难。让人有些愤怒的是，所有的IEE出版的论文都被期望以冗长的早期研究的陈述开头，无非是些在早期阶段由于没有太多经验而遇到的困难之类的陈述。
60年代的巩固阶段
60年代初，个人英雄时代结束了，计算机真正引起了重视。世界上的计算机数量已经增加了许多，并且性能比以前更加可靠。这些我认为归因与高级语言的起步和第一个操作系统的诞生。分时系统开始起步，并且计算机图形学随之而来。
综上所述，晶体管开始代替正空管。这个变化对当时的工程师们是个不可回避的挑战。他们必须忘记他们熟悉的电路重新开始。只能说他们鼓起勇气接受了挑战，尽管这个转变并不会一帆风顺。
小规模集成电路和小型机
很快，在一个硅片上可以放不止一个晶体管，由此集成电路诞生了。随着时间的推移，一个片子能够容纳的最大数量的晶体管或稍微少些的逻辑门和翻转门集成度达到了一个最大限度。由此出现了我们所知道7400系列微机。每个门电路或翻转电路是相互独立的并且有自己的引脚。他们可通过导线连接在一起，作成一个计算机或其他的东西。
这些芯片为制造一种新的计算机提供了可能。它被称为小型机。他比大型机稍逊，但功能强大，并且更能让人负担的起。一个商业部门或大学有能力拥有一台小型机而不是得到一台大型组织所需昂贵的大型机。
随着微机的开始流行并且功能的完善，世界急切获得它的计算能力但总是由于工业上不能规模供应和它可观的价格而受到挫折。微机的出现解决了这个局面。
计算消耗的下降并非起源与微机，它本来就应该是那个样子。这就是我在概要中提到的“通货膨胀”在计算机工业中走上了歧途之说。随着时间的推移，人们比他们付出的金钱得到的更多。
硬件的研究
我所描述的时代对于从事计算机硬件研究的人们是令人惊奇的时代。7400
系列的用户能够工作在逻辑门和开关级别并且芯片的集成度可靠性比单独晶体管高很多。大学或各地的研究者，可以充分发挥他们的想象力构造任何微机可以连接的数字设备。在剑桥大学实验室力，我们构造了CAP，一个有令人惊奇逻辑能力的微机。
7400在70年代中期还不断发展壮大，并且被宽带局域网的先驱组织Cambridge Ring所采用。令牌环设计研究的发表先于以太网。在这两种系统出现之前，人们大多满足于基于电报交换机的本地局域网。
令牌环网需要高可靠性，由于脉冲在令牌环中传递，他们必须不断的被放大并且再生。是7400的高可靠性给了我们勇气，使得我们着手Cambridge Ring.项目。
精简指令计算机的诞生
早期的计算机有简单的指令集，随着时间的推移，商业用微机的设计者增加了另外的他们认为可以微机性能的特性。很少的测试方法被建立，总的来说特性的选取很大程度上依赖于设计者的直觉。
1980年，RISC运动改变了微机世界。该运动是由Patterson 和Ditzel发表了一篇命名为精简指令计算机的情况论文而引起的。
除了RISC这个引人注目缩略词外，这个标题传达了一些指令集合设计的见解，随之引发了RISC运动。从某种意义上说，它推动了线程的发展，在处理器中，同一时间有几个指令在不同的执行阶段称为线程。线程不是个新概念，但是它对微机来说是从未有过的。
RISC受益于一个最近的可用的方法的诞生，该方法使估计计算机性能成为可能而不去真正实现该微机的设计。我的意思是说利用目前存在的功能强大的计算机去模拟新的设计。通过模拟该设计，RISC的提倡者能够有信心的预言，一台使用和传统计算机相同电路的RISC计算机可以和传统的最好的计算机有同样的性能。
模拟仿真加快了开发进度并且被计算机设计者广泛采用。随后，计算机设
计者变的多些可理性少了一些艺术性。今天，设计者们希望有满屋可用计算机做他们的仿真，而不只是一台，
X86指令集
除非出现很大意外，要不很少听到有计算机使用早期的RISC指令集了。INTEL 8086及其后裔都与x86密切相关。X86构架已经占据了计算机核心指令集的主导地位。被认为是相当成功的RISC指令集现在的生存空间越来越小了。
对于我们这些从事计算机学术研究的人，X86的统治地位让我们感到失望。毫无疑问，商业上对于x86的生存会有更多的考虑，但是这里还有很多原因，尽管我们多么希望人们考虑其他的方面。高级语言并没有完全消除对机器原始编码的的使用。我们仍需要不断提醒我们自己：我们应该严格的与先前的应用在机器层面上保持兼容。然而，情况也许有所不同，如果Intel的主要目的是为是生产一个好的RISC芯片。有一个已经取得了更大的成功，我所说的i860(不是i960,它们有一些不同)。从许多方面来说，i860是个卓越的芯片，但是它的软件借口不适合在工作站上应用。
对于x86取得胜利的最后有一件有意思的事情。直接应用先前x86的实现方式对于满足RISC处理器的持续增长的速度要求，是不可能的。因此，设计者们没有完全实现RISC指令集，尽管这不是很明显。表面上，一片现代的x86芯片包含了隐藏实现的部分，好象和实现RISC指令集的芯片一样。当致命的异常发生时，X86引入的代码是，经过适当的篡改后，被转化为它的内部代码并且被RISC芯片处理。
对于以上RISC运动的总结，我非常信赖最新版本的哈里斯和培生出版社的有关计算机设计的书籍。请参考特殊计算机体系构造，第三版，2003，P146，151-4，157-8
IA-64指令集
很久以前，Intel 和Hewlett-Packard引进了IA-64指令集。这最初主要是为了满足通常的64位地址空间问题。在这种情况下，随后出现了MIPS R4000和Alpha。然而，人们普遍认为Intel应该与x86构架保持兼容，可令人疑惑的是恰恰相反。
进一步说，IA-64的设计与其他所有的指令集在主要实现方式上有所不同。特别的，每条指令它需要附加的6位。这打乱了传统的在指令字长和信息内容的平衡，并且它改变了编译器作者的原先的大纲。
尽管IA-64是个全新的指令集，但Intel发表了一个令人困惑的声明：基于IA-64的芯片将与早期的x86芯片保持兼容。很难弄懂它所指的是什么。
最新的称为Itaninu IA-64处理器显然需要特殊的兼容性的硬件，尽管如此，x86编码运行的相当慢。
由于以上的复杂因素，IA-64的实现需要更大的体积相对与传统的指令集，这暗示着更大的消耗。因此，在任何情况下，作为常识和一般性的标准，Gordon Moore在访问剑桥最近开放的Betty and Gordon Moore 图书馆时所反复强调。在听到他说问题出现在Intel内部也许有所不同，我很不理解。但是我已经作好了准备，去接受这样的事实，我已经完全不了解半导体经济学了。
AMD已经定义了一种64位的与x86更加兼容的指令集，并且他们已经取得了进展。这种片子并不是很大。很多人认为这才是Intel应该做的。（在这篇演讲稿被提交之前，Intel表示他们将销售一系列本质上与AMD兼容的芯片）
更小晶体管的出现
集成度还在不断增加，这是通过缩小原始晶体管以致可以更容易放在一个片子上。进一步说，物理学的定律占在了制造商的一方。晶体管变的更快，更简单，更小。因此，同时导致了更高的集成度和速度。
这有个更明显的优势。芯片被放在硅片上，称为晶片。每一个晶片拥有很大数量的独立芯片，他们被同时加工然后分离。因为缩小以致在每块晶片上有了更多的芯片，所以每块芯片的价格下降了。
单元价格下降对于计算机工业是重要的，因为，如果最新的芯片性能和以前一样但价格更便宜，就没有理由继续提供老产品，至少不应该无限期提供。对于整个市场只需一种产品。
附录2
Progress in Computers
Prestige Lecture delivered to IEE, Cambridge, on 5 February 2004
Maurice Wilkes
Computer Laboratory
University of Cambridge
The first stored program computers began to work around 1950. The one we built in Cambridge, the EDSAC was first used in the summer of 1949.
These early experimental computers were built by people like myself with varying backgrounds. We all had extensive experience in electronic engineering and
were confident that that experience would stand us in good stead. This proved true, although we had some new things to learn. The most important of these was that transients must be treated correctly; what would cause a harmless flash on the screen of a television set could lead to a serious error in a computer.
As far as computing circuits were concerned, we found ourselves with an embarass de richess. For example, we could use vacuum tube diodes for gates as we did in the EDSAC or pentodes with control signals on both grids, a system widely used elsewhere. This sort of choice persisted and the term families of logic came into use. Those who have worked in the computer field will remember TTL, ECL and CMOS. Of these, CMOS has now become dominant.
In those early years, the IEE was still dominated by power engineering and we had to fight a number of major battles in order to get radio engineering along with the rapidly developing subject of electronics.dubbed in the IEE light current electrical engineering.properly recognised as an activity in its own right. I remember that we had some difficulty in organising a conference because the power engineers’ ways of doing things were not our ways. A minor source of irritation was that all IEE published papers were expected to start with a lengthy statement of earlier practice, something difficult to do when there was no earlier practice
Consolidation in the 1960s
By the late 50s or early 1960s, the heroic pioneering stage was over and the computer field was starting up in real earnest. The number of computers in the world had increased and they were much more reliable than the very early ones . To those years we can ascribe the first steps in high level languages and the first operating systems. Experimental time-sharing was beginning, and ultimately computer graphics was to come along.
Above all, transistors began to replace vacuum tubes. This change presented a formidable challenge to the engineers of the day. They had to forget what they knew about circuits and start again. It can only be said that they measured up superbly well to the challenge and that the change could not have gone more smoothly.
Soon it was found possible to put more than one transistor on the same bit of silicon, and this was the beginning of integrated circuits. As time went on, a sufficient level of integration was reached for one chip to accommodate enough transistors for a small number of gates or flip flops. This led to a range of chips
known as the 7400 series. The gates and flip flops were independent of one another and each had its own pins. They could be connected by off-chip wiring to make a computer or anything else.
These chips made a new kind of computer possible. It was called a minicomputer. It was something less that a mainframe, but still very powerful, and much more affordable. Instead of having one expensive mainframe for the whole organisation, a business or a university was able to have a minicomputer for each major department.
Before long minicomputers began to spread and become more powerful. The world was hungry for computing power and it had been very frustrating for industry not to be able to supply it on the scale required and at a reasonable cost. Minicomputers transformed the situation.
The fall in the cost of computing did not start with the minicomputer; it had always been that way. This was what I meant when I referred in my abstract to inflation in the computer industry ‘going the other way’. As time goes on people get more for their money, not less.
Research in Computer Hardware.
The time that I am describing was a wonderful one for research in computer hardware. The user of the 7400 series could work at the gate and flip-flop level and yet the overall level of integration was sufficient to give a degree of reliability far above that of discreet transistors. The researcher, in a university or elsewhere, could build any digital device that a fertile imagination could conjure up. In the Computer Laboratory we built the Cambridge CAP, a full-scale minicomputer with fancy capability logic.
The 7400 series was still going strong in the mid 1970s and was used for the Cambridge Ring, a pioneering wide-band local area network. Publication of the design study for the Ring came just before the announcement of the Ethernet. Until these two systems appeared, users had mostly been content with teletype-based local area networks.
Rings need high reliability because, as the pulses go repeatedly round the ring, they must be continually amplified and regenerated. It was the high reliability provided by the 7400 series of chips that gave us the courage needed to embark on the project for the Cambridge Ring.
The RISC Movement and Its Aftermath
Early computers had simple instruction sets. As time went on designers of commercially available machines added additional features which they thought would improve performance. Few comparative measurements were done and on the whole the choice of features depended upon the designer’s intuition.
In 1980, the RISC movement that was to change all this broke on the world. The movement opened with a paper by Patterson and Ditzel entitled The Case for the Reduced Instructions Set Computer.
Apart from leading to a striking acronym, this title conveys little of the insights into instruction set design which went with the RISC movement, in particular the way it facilitated pipelining, a system whereby several instructions may be in different stages of execution within the processor at the same time. Pipelining was not new, but it was new for small computers
The RISC movement benefited greatly from methods which had recently become available for estimating the performance to be expected from a computer design without actually implementing it. I refer to the use of a powerful existing computer to simulate the new design. By the use of simulation, RISC advocates were able to predict with some confidence that a good RISC design would be able to
out-perform the best conventional computers using the same circuit technology. This prediction was ultimately born out in practice.
Simulation made rapid progress and soon came into universal use by computer designers. In consequence, computer design has become more of a science and less of an art. Today, designers expect to have a roomful of, computers available to do their simulations, not just one. They refer to such a roomful by the attractive name of computer farm.
The x86 Instruction Set
Little is now heard of pre-RISC instruction sets with one major exception, namely that of the Intel 8086 and its progeny, collectively referred to as x86. This has become the dominant instruction set and the RISC instruction sets that originally had a considerable measure of success are having to put up a hard fight for survival.
This dominance of x86 disappoints people like myself who come from the research wings.both academic and industrial.of the computer field. No doubt, business considerations have a lot to do with the survival of x86, but there are other reasons as well. However much we research oriented people would like to think otherwise. high level languages have not yet eliminated the use of machine code
altogether. We need to keep reminding ourselves that there is much to be said for strict binary compatibility with previous usage when that can be attained. Nevertheless, things might have been different if Intel’s major attempt to produce a good RISC chip had been more successful. I am referring to the i860 (not the i960, which was something different). In many ways the i860 was an excellent chip, but its software interface did not fit it to be used in a workstation.
There is an interesting sting in the tail of this apparently easy triumph of the x86 instruction set. It proved impossible to match the steadily increasing speed of RISC processors by direct implementation of the x86 instruction set as had been done in the past. Instead, designers took a leaf out of the RISC book; although it is not obvious, on the surface, a modern x86 processor chip contains hidden within it a RISC-style processor with its own internal RISC coding. The incoming x86 code is, after suitable massaging, converted into this internal code and handed over to the RISC processor where the critical execution is performed.
In this summing up of the RISC movement, I rely heavily on the latest edition of Hennessy and Patterson’s books on computer design as my supporting authority; see in particular Computer Architecture, third edition, 2003, pp 146, 151-4, 157-8.
The IA-64 instruction set.
Some time ago, Intel and Hewlett-Packard introduced the IA-64 instruction set. This was primarily intended to meet a generally recognised need for a 64 bit address space. In this, it followed the lead of the designers of the MIPS R4000 and Alpha. However one would have thought that Intel would have stressed compatibility with the x86; the puzzle is that they did the exact opposite.
Moreover, built into the design of IA-64 is a feature known as predication which makes it incompatible in a major way with all other instruction sets. In particular, it needs 6 extra bits with each instruction. This upsets the traditional balance between instruction word length and information content, and it changes significantly the brief of the compiler writer.
In spite of having an entirely new instruction set, Intel made the puzzling claim that chips based on IA-64 would be compatible with earlier x86 chips. It was hard to see exactly what was meant.
Chips for the latest IA-64 processor, namely, the Itanium, appear to have special hardware for compatibility. Even so, x86 code runs very slowly.
Because of the above complications, implementation of IA-64 requires a larger
chip than is required for more conventional instruction sets. This in turn implies a higher cost. Such at any rate, is the received wisdom, and, as a general principle, it was repeated as such by Gordon Moore when he visited Cambridge recently to open the Betty and Gordon Moore Library. I have, however, heard it said that the matter appears differently from within Intel. This I do not understand. But I am very ready to admit that I am completely out of my depth as regards the economics of the semiconductor industry.
AMD have defined a 64 bit instruction set that is more compatible with x86 and they appear to be making headway with it. The chip is not a particularly large one. Some people think that this is what Intel should have done. [Since the lecture was delivered, Intel have announced that they will market a range of chips essentially compatible with those offered by AMD.]
The Relentless Drive towards Smaller Transistors
The scale of integration continued to increase. This was achieved by shrinking the original transistors so that more could be put on a chip. Moreover, the laws of physics were on the side of the manufacturers. The transistors also got faster, simply by getting smaller. It was therefore possible to have, at the same time, both high density and high speed.
There was a further advantage. Chips are made on discs of silicon, known as wafers. Each wafer has on it a large number of individual chips, which are processed together and later separated. Since shrinkage makes it possible to get more chips on a wafer, the cost per chip goes down.
Falling unit cost was important to the industry because, if the latest chips are cheaper to make as well as faster, there is no reason to go on offering the old ones, at least not indefinitely. There can thus be one product for the entire market.
Structure and fun cti on of the MCS-51 series Structure and function of the MCS-51 series one-chip computer MCS-51is a nameof a piece of one-chip computer series which In tel Compa ny produces. This compa ny in troduced 8 top-grade on e-chip computers of MCS-51 series in 1980 after in troduc ing 8 on e-chip computers of MCS-48 series in 1976. It belong to a lot of kinds this line of one-chip computer the chips have,such as 8051, 8031,8751, 80C51BH, 80C31BH,etc., their basic compositi on, basic performa nee and in structi on system are all the same. 8051 daily representatives- 51 serial on e-chip computers . An one-chip computer system is made up of several followi ng parts: ( 1) One microprocessor of 8 (CPU). ( 2) At slice data memory RAM (128B/256B),it use not depositti ng not can read ing /data that write, such as result not middle of operati on, final result and data wan ted to show, etc. ( 3) Procedure memoryROM/EPRC(4KB/8KB ), is used to preserve the procedure , some in itial data and form in slice. But does not take ROM/EPROM within some on e-chip computers, such as 8031 , 8032, 80C ,etc.. ( 4) Four 8 run side by side I/O in terface P0 four P3, each mouth can use as introduction , may use as export ing too. ( 5) Two timer / coun ter, each timer / coun ter may set up and count in the way, used to count to the exter nal in cide nt, can set up into a timi ng way too, and can accord ing to count or result of timing realize the control of the computer. (6) Five cut off cutting off the control system of the source .
五、外文资料翻译 Stress and Strain 1.Introduction to Mechanics of Materials Mechanics of materials is a branch of applied mechanics that deals with the behavior of solid bodies subjected to various types of loading. It is a field of study that i s known by a variety of names, including “strength of materials” and “mechanics of deformable bodies”. The solid bodies considered in this book include axially-loaded bars, shafts, beams, and columns, as well as structures that are assemblies of these components. Usually the objective of our analysis will be the determination of the stresses, strains, and deformations produced by the loads; if these quantities can be found for all values of load up to the failure load, then we will have obtained a complete picture of the mechanics behavior of the body. Theoretical analyses and experimental results have equally important roles in the study of mechanics of materials . On many occasion we will make logical derivations to obtain formulas and equations for predicting mechanics behavior, but at the same time we must recognize that these formulas cannot be used in a realistic way unless certain properties of the been made in the laboratory. Also , many problems of importance in engineering cannot be handled efficiently by theoretical means, and experimental measurements become a practical necessity. The historical development of mechanics of materials is a fascinating blend of both theory and experiment, with experiments pointing the way to useful results in some instances and with theory doing so in others①. Such famous men as Leonardo da Vinci(1452-1519) and Galileo Galilei (1564-1642) made experiments to adequate to determine the strength of wires , bars , and beams , although they did not develop any adequate theo ries (by today’s standards ) to explain their test results . By contrast , the famous mathematician Leonhard Euler(1707-1783) developed the mathematical theory any of columns and calculated the critical load of a column in 1744 , long before any experimental evidence existed to show the significance of his results ②. Thus , Euler’s theoretical results remained unused for many years, although today they form the basis of column theory. The importance of combining theoretical derivations with experimentally determined properties of materials will be evident theoretical derivations with experimentally determined properties of materials will be evident as we proceed with
英文参考文献标准格式:论文参考文献格式规范 也可以在标点.之后加上一个空格，但一定要保证所有的项目空格个数一致一、参考文献的类型 参考文献（即引文出处）的类型以单字母方式标识，具体如下： [M]--专著,著作 [C]--论文集(一般指会议发表的论文续集，及一些专题论文集，如《***大学研究生学术论文集》 [N]-- 报纸文章 [J]--期刊文章：发表在期刊上的论文，尽管有时我们看到的是从网上下载的（如知网），但它也是发表在期刊上的，你看到的电子期刊仅是其电子版 [D]--学位论文：不区分硕士还是博士论文 [R]--报告：一般在标题中会有"关于****的报告"字样 [S]-- 标准 [P]--专利 [A]--文章：很少用，主要是不属于以上类型的文章 [Z]--对于不属于上述的文献类型，可用字母"Z"标识，但这种情况非常少见 常用的电子文献及载体类型标识： [DB/OL] --联机网上数据(database online) [DB/MT] --磁带数据库(database on magnetic tape) [M/CD] --光盘图书(monograph on CDROM) [CP/DK] --磁盘软件(computer program on disk)
[J/OL] --网上期刊(serial online) [EB/OL] --网上电子公告(electronic bulletin board online) 很显然，标识的就是该资源的英文缩写，/前面表示类型，/后面表示资源的载体，如OL表示在线资源 二、参考文献的格式及举例 1．期刊类 【格式】[序号]作者.篇名[J].刊名,出版年份,卷号(期号)起止页码. 【举例】 [1] 周融，任志国，杨尚雷，厉星星.对新形势下毕业设计管理工作的思考与实践[J].电气电子教学学报，2003(6):107-109. [2] 夏鲁惠.高等学校毕业设计(论文)教学情况调研报告[J].高等理科教育,2004(1):46-52. [3] Heider, E.R.& D.C.Oliver. The structure of color space in naming and memory of two languages [J]. Foreign Language Teaching and Research, 1999, (3): 62 67. 2．专著类 【格式】[序号]作者.书名[M].出版地:出版社,出版年份:起止页码. 【举例】 [4] 刘国钧,王连成.图书馆史研究[M].北京:高等教育出版社,1979:15-18,31. [5] Gill, R. Mastering English Literature [M]. London: Macmillan, 1985: 42-45. 3．报纸类 【格式】[序号]作者.篇名[N].报纸名,出版日期(版次). 【举例】 [6] 李大伦.经济全球化的重要性[N]. 光明日报，1998-12-27(3).
数据库外文参考文献及翻译 数据库外文参考文献及翻译数据库管理系统——实施数据完整性一个数据库，只有用户对它特别有信心的时候。这就是为什么服务器必须实施数据完整性规则和商业政策的原因。执行SQL Server的数据完整性的数据库本身，保证了复杂的业务政策得以遵循，以及强制性数据元素之间的关系得到遵守。因为SQL Server的客户机/服务器体系结构允许你使用各种不同的前端应用程序去操纵和从服务器上呈现同样的数据，这把一切必要的完整性约束，安全权限，业务规则编码成每个应用，是非常繁琐的。如果企业的所有政策都在前端应用程序中被编码，那么各种应用程序都将随着每一次业务的政策的改变而改变。即使您试图把业务规则编码为每个客户端应用程序，其应用程序失常的危险性也将依然存在。大多数应用程序都是不能完全信任的，只有当服务器可以作为最后仲裁者，并且服务器不能为一个很差的书面或恶意程序去破坏其完整性而提供一个后门。SQL Server使用了先进的数据完整性功能，如存储过程，声明引用完整性（DRI），数据类型，限制，规则，默认和触发器来执行数据的完整性。所有这些功能在数据库里都有各自的用途;通过这些完整性功能的结合，可以实现您的数据库的灵活性和易于管理，而且还安全。声明数据完整性声明数据完整原文请找腾讯3249114六,维-论'文.网 https://www.doczj.com/doc/6a870449.html, 定义一个表时指定构成的主键的列。这就是所谓的主键约束。SQL Server使用主键约束以保证所有值的唯一性在指定的列从未侵犯。通过确保这个表有一个主键来实现这个表的实体完整性。有时，在一个表中一个以上的列（或列的组合）可以唯一标志一行，例如，雇员表可能有员工编号（ emp_id ）列和社会安全号码（ soc_sec_num ）列，两者的值都被认为是唯一的。这种列经常被称为替代键或候选键。这些项也必须是唯一的。虽然一个表只能有一个主键，但是它可以有多个候选键。 SQL Server的支持多个候选键概念进入唯一性约束。当一列或列的组合被声明是唯一的， SQL Server 会阻止任何行因为违反这个唯一性而进行的添加或更新操作。在没有故指的或者合适的键存在时，指定一个任意的唯一的数字作为主键，往往是最有效的。例如，企业普遍使用的客户号码或账户号码作为唯一识别码或主键。通过允许一个表中的一个列拥有身份属性，SQL Server可以更容易有效地产生唯一数字。您使用的身份属性可以确保每个列中的值是唯一的，并且值将从你指定的起点开始，以你指定的数量进行递增（或递减）。（拥有特定属性的列通常也有一个主键或唯一约束，但这不是必需的。）第二种类型的数据完整性是参照完整性。 SQL Server实现了表和外键约束之间的逻辑关系。外键是一个表中的列或列的组合，连接着另一个表的主键（或着也可能是替代键）。这两个表之间的逻辑关系是关系模型的基础;参照完整性意味着这种关系是从来没有被违反的。例如，一个包括出版商表和标题表的简单的select例子。在标题表中，列title_id （标题编号）是主键。在出版商表，列pub_id （出版者ID ）是主键。 titles表还包括一个pub_id列，这不是主键，因为出版商可以发布多个标题。相反， pub_id是一个外键，它对应着出版商表的主键。如果你在定义表的时候声明了这个关系， SQL Server由双方执行它。首先，它确保标题不能进入titles表，或在titles表中现有的pub_id无法被修改，除非有效的出版商ID作为新pub_id出现在出版商表中。其次，它确保在不考虑titles表中对应值的情况下，出版商表中的pub_id的值不做任何改变。以下两种方法可
基于单片机的大棚温湿度控制系统设计 发布: 2011-9-1 | 作者: —— | 来源:caiminghao| 查看: 530次| 用户关注： 摘要：针对研究蔬菜大棚智能温湿度控制，设计了一种基于计算机自动控制的智能蔬菜大棚温湿度控制系统。详细阐述了该系统的温湿度采集、温湿度显示、控制系统等系统软硬件的设计思想，以DS18B20和HM1500LF作为温湿度传感器，以AT89S52单片机为系统核心，最后利用DELPHI软件进行系统仿真。该研究设计的蔬菜大棚智能温湿度控制系统人机界面良好，操作简单方便，自动化程度高，造价低廉，具有良好的应用前景和推广价值。关键词：温度采 摘要：针对研究蔬菜大棚智能温湿度控制，设计了一种基于计算机自动控制的智能蔬菜大棚温湿度控制系统。详细阐述了该系统的温湿度采集、温湿度显示、控制系统等系统软硬件的设计思想，以DS18B20和HM1500LF作为温湿度传感器，以AT89S52单片机为系统核心，最后利用DELPHI软件进行系统仿真。该研究设计的蔬菜大棚智能温湿度控制系统人机界面良好，操作简单方便，自动化程度高，造价低廉，具有良好的应用前景和推广价值。 关键词：温度采集；湿度采集；LCD显示；单片机 0 引言 植物的生长都是在一定的环境中进行的，在生长过程中受到环境中各种因素的影响，其中影响最大的是温度和湿度。若昼夜的温度和湿度变化很大，其对植物生长极为不利。因此必须对温度和湿度进行监测和控制，使其适合植物的生长，以提高其产量和质量。 本系统就是针对大棚内温度、湿度，研究单片机控制的温室大棚自动控制，综合考虑系统的精度、效率以及经济性要求多方面因素之后，设计一种基于计算机自动控制的大棚温湿度控制系统。 本系统实现的蔬菜大棚温湿度控制系统的目标功能如下： (1)系统能对大棚环境温湿度进行采集和显示(现场观温、湿度，软件记录)。 (2)能通过上位机端远程设定蔬菜的生长期适宜温湿度。由主控机统一设置系统时间和温度湿度修正值。 (3)当大棚的环境温湿度参数超过设定的上下限值时控制相应的系统启动。 (4)可实时显示当前温度、时间、报警阈值等信息，并可查询各时间段的温湿度情况，并加以控制。 1 系统各组成模块
在广州甚至广东的住宅小区电气设计中,一般都会涉及到小区的高低压供配电系统的设计.如10kV高压配电系统图,低压配电系统图等等图纸一大堆.然而在真正实施过程中,供电部门(尤其是供电公司指定的所谓电力设计小公司)根本将这些图纸作为一回事,按其电脑里原有的电子档图纸将数据稍作改动以及断路器按其所好换个厂家名称便美其名曰设计(可笑不?),拿出来的图纸根本无法满足电气设计的设计意图,致使严重存在以下问题:(也不知道是职业道德问题还是根本一窍不通) 1.跟原设计的电气系统货不对板,存在与低压开关柜后出线回路严重冲突,对实际施工造成严重阻碍,经常要求设计单位改动原有电气系统图才能满足它的要求(垄断的没话说). 2.对消防负荷和非消防负荷的供电(主要在高层建筑里)应严格分回路(从母线段)都不清楚,将消防负荷和非消防负荷按一个回路出线(尤其是将电梯和消防电梯,地下室的动力合在一起等等,有的甚至将楼顶消防风机和梯间照明合在一个回路,以一个表计量). 3.系统接地保护接地型式由原设计的TN-S系统竟曲解成"TN-S-C-S"系统(室内的还需要做TN-C,好玩吧?),严格的按照所谓的"三相四线制"再做重复接地来实施,导致后续施工中存在重复浪费资源以及安全隐患等等问题.. ............................(违反建筑电气设计规范等等问题实在不好意思一一例举,给那帮人留点混饭吃的面子算了) 总之吧,在通过图纸审查后的电气设计图纸在这帮人的眼里根本不知何物,经常是完工后的高低压供配电系统已是面目全非了,能有百分之五十的保留已经是谢天谢地了. 所以.我觉得:住宅建筑电气设计,让供电部门走!大不了留点位置,让他供几个必需回路的电,爱怎么折腾让他自个怎么折腾去.. Guangzhou, Guangdong, even in the electrical design of residential quarters, generally involving high-low cell power supply system design. 10kV power distribution systems, such as maps, drawings, etc. low-voltage distribution system map a lot. But in the real implementation of the process, the power sector (especially the so-called power supply design company appointed a small company) did these drawings for one thing, according to computer drawings of the original electronic file data to make a little change, and circuit breakers by their the name of another manufacturer will be sounding good design (ridiculously?), drawing out the design simply can not meet the electrical design intent, resulting in a serious following problems: (do not know or not know nothing about ethical issues) 1. With the original design of the electrical system not meeting board, the existence and low voltage switchgear circuit after qualifying serious conflicts seriously hinder the actual construction, often require changes to the original design unit plans to meet its electrical system requirements (monopoly impress ). 2. On the fire load and fire load of non-supply (mainly in high-rise building in) should be strictly sub-loop (from the bus segment) are not clear, the fire load and fire load of non-qualifying press of a circuit (especially the elevator and fire elevator, basement, etc.
中文参考文献格式 参考文献（即引文出处）的类型以单字母方式标识： M——专著，C——论文集，N——报纸文章，J——期刊文章，D——学位论文，R——报告，S——标准，P——专利；对于不属于上述的文献类型，采用字母“Z”标识。 参考文献一律置于文末。其格式为： （一）专著 示例 [1] 张志建.严复思想研究[M]. 桂林：广西师范大学出版社，1989. [2] 马克思恩格斯全集：第1卷[M]. 北京：人民出版社，1956. [3] [英]蔼理士.性心理学[M]. 潘光旦译注.北京：商务印书馆，1997. （二）论文集 示例 [1] 伍蠡甫.西方文论选[C]. 上海：上海译文出版社，1979. [2] 别林斯基.论俄国中篇小说和果戈里君的中篇小说[A]. 伍蠡甫.西方文论选：下册[C]. 上海：上海译文出版社，1979. 凡引专著的页码，加圆括号置于文中序号之后。 （三）报纸文章 示例 [1] 李大伦.经济全球化的重要性[N]. 光明日报，1998-12-27，（3） （四）期刊文章 示例 [1] 郭英德.元明文学史观散论[J]. 北京师范大学学报（社会科学版），1995（3）. （五）学位论文 示例 [1] 刘伟.汉字不同视觉识别方式的理论和实证研究[D]. 北京：北京师范大学心理系，1998. （六）报告 示例 [1] 白秀水，刘敢，任保平. 西安金融、人才、技术三大要素市场培育与发展研究[R]. 西安：陕西师范大学西北经济发展研究中心，1998. （七）、对论文正文中某一特定内容的进一步解释或补充说明性的注释，置于本页地脚，前面用圈码标识。 参考文献的类型 根据GB3469-83《文献类型与文献载体代码》规定，以单字母标识： M——专著（含古籍中的史、志论著） C——论文集 N——报纸文章 J——期刊文章 D——学位论文 R——研究报告 S——标准 P——专利 A——专著、论文集中的析出文献 Z——其他未说明的文献类型 电子文献类型以双字母作为标识： DB——数据库 CP——计算机程序 EB——电子公告
基于反馈神经网络肘关节力矩的动态预测 R.Song K.Y.Tong 健康技术与信息学系，香港理工大学 KowIoon，香港
摘要 肌肉模型是身体部分运动分析的一个重要组成部分。尽管许多研究已经集中在静态条件下,但是肌电信号（EMG）和关节转矩在自愿动态情况下之间的关系并没有被很好的研究。本研究的目的是调查的一个反馈人工神经网络的性能（RANN）自愿动态情况下的复杂肘扭矩估计。肌电信号和运动数据，其中包括角度和角速度，被用来作为估计在运动过程中预期的扭矩输入。此外，角度和角速度的预测精度的作用进行了研究，并比较两个模型。一个模型的肌电图和关节运动的投入和其他的模型只使用肌电图无运动数据输入。六例健康体检者，和两个平均角速度（60°S 7和90°S 7）三种不同负荷（0公斤，1公斤，2公斤）在手的位置被选择来训练和测试90°屈肘、全伸肘之间的递归神经网络（0 ~）。训练结束后，根平均平方误差（RMSE）预期的扭矩和扭矩之间的模型预测，在训练数据集的肌电图和关节运动的投入和测试数据集，分别为0.17±0.03 nm和0.35 + 0.06 nm。预期的扭矩和预测模型的RMSE值之间的扭矩，在训练数据集只有肌电输入和测试集，分别为0.57 t - 0.07 nm和0.73 T 0.11 nm。结果表明，肌电信号一起运动的数据提供了更好的性能预测的关节力矩；关节角度和角速度提供了重要信息的关节力矩的估计在自愿的运动。 关键词:肌肉骨骼模型，自愿的运动，反馈人工神经网络，逆动力学模型
第一章绪论 由于希尔提出了1938肌肉的经典论文，神经生理学和神经肌肉骨骼系统的生物力学已被广泛研究，使人体运动生成的原理可以发现（希尔，1938）。 探讨中枢神经系统（CNS）激发肌肉和其后的发展力和产生不同的人体运动，许多模型来描述和定性的肌肉骨骼系统的不同层次的性能（温特斯，1990；扎杰克和温特斯，1990）。一个被普遍接受的山为基础的神经肌肉骨骼系统由以下子模型，一步一步：肌肉兴奋-收缩模型；肌腱骨骼模型；动态模型（扎耶克，1989）。 图1 肌肉骨骼模型框图 图1显示了基于hillbased模型的运动生成。图1，肌肉兴奋收缩模型是用来估计中枢神经系统指挥肌肉活动的状态。肌腱模型产生的肌肉力量不仅基于肌肉激活状态，而且基于肌腱式长度和肌腱式收缩速度，这与关节角速度和角速度（温特斯和斯塔克，1988）。前项状态的肌肉力量，它决定了肌腱的依从性，还负责肌肉力在后一阶段（扎耶克，1989）。一旦所有负责的关节运动的肌肉力量已经发现，肌肉的力量与各自的肌肉力臂和的结果求和乘法可以产生关节力矩。所有子模型的数学积分可以用来描述关节运动是中枢神经系统的命令产生哪些参数斧负责关节力矩。 肌电信号反映肌肉的活动，和许多类似的肌电力矩的关系已经在静态和动态情况的研究（张等人，1997；麦森纳和莫润，1995）。肌肉的肌电信号也常被认
[1] 王青云. 基于单片机的温度测量系统[J] 2010，(05). [2] 彭立，张建洲，王少华. 自适应温度控制系统的研制[J]东北师大学报(自然科学版), 1994,(01) . [3] Jack Shandle. 即将来临的32位浪潮——ARM构架在32位微控制器领域的应用[J]单片机与嵌入式系统应用, 2004,(03) . [4] 刘侃,张永泰,刘洛琨. ARM程序设计优化策略与技术[J]单片机与嵌入式系统应用, 2004,(04) . [5] 何立民．从Cygnal 80C51F看8位单片机发展之路．单片机与嵌入式系统应用[M]，2002年，第5期：P5~8 [6] 夏继强. 单片机实验与实践教程. 北京：北京航空航天大学出版社, 2001 [7] 徐惠民、安德宁．单片微型计算机原理接口与应用．第1版[M]．北京：北京邮电大学出版社，1996 [8] 张媛媛,何怡刚,徐雪松. 基于C8051F020的温湿度控制箱设计[J]国外电子元器件, 2004,(10) . [9] 江孝国,王婉丽,祁双喜. 高精度PID温度控制器[J]电子与自动化, 2000,(05) . [10] 于洋. 高低温试验箱微机自动控制系统的设计[J]工业仪表与自动化装置, 2003,(02) . [11] 沈聿农.传感器及应用技术[M].北京:化学工业出版社,2001. [12] 范晶彦.传感器与检测技术应用[M].北京:机械工业出版社,2005. [13] 王俊峰,孟令启.现代传感器应用技术[M].北京:机械工业出版社,2007. [14] 金发庆.传感器技术与应用[M].北京:机械工业出版社,2006. [15] Goldman JM, Petterson MT, Kopotic RJ, Barker SJ.Masimosignal extraction pulse oximetry[J].J Clin Monit Comput.2000;16(7):7 5-83. [16] D. Tulone. On the feasibility of global time estimation under isolation conditions in wireless sensor networks. [17] 王春晖. 环境试验箱中制冷系统的原理分析及优化概述[J]电子质量, 2003,(12) [18] 李建中. 单片机原理及应用[M]西安电子科技大学出版社,2010.(02) [19] 周航慈.单片机应用程序设计技术[M].北京：北京航空航大大学出版社，2005. [20] 何立民.单片机高级教程[M].北京：北京航空航天大学出版社，2001. [21] 夏继强.单片机实验与实践教程[M].北京：北京航空航天大学出版社, 2001. [22] 徐惠民,安德宁.单片微型计算机原理接口与应用[M]．北京：北京邮电大学出版社，1996. [23] 李广第．单片机基础[M]．北京：北京航空航天大学出版社，1999. [24] 赵晓安. MCS-51单片机原理及应用[M]. 天津：天津大学出版社，2001. [25] 杨清梅,孙建民.传感器与测试技术[M].哈尔滨: 哈尔滨工程大学出版社,2005. [26] 范晶彦.传感器与检测技术应用[M].北京:机械工业出版社,2005. [27] 王俊峰,孟令启.现代传感器应用技术[M].北京:机械工业出版社,2007. [28] 宋文绪,杨帆.自动检测技术[M].北京:高等教育出版社,2000. [1] 王青云. 基于单片机的温度测量系统[J] 2010，(05). [2] 彭立，张建洲，王少华. 自适应温度控制系统的研制[J]东北师大学报(自然科学版), 1994, [3] YD. Tulone. Is it possible to ensure strong data guarantees in highly mobile [4] Jack Shandle. 即将来临的32位浪潮——ARM构架在32位微控制器领域的应用[J]单片机与嵌入式系统应用, 2004,(03) .
International Journal of Minerals, Metallurgy and Materials Volume 17, Number 4, August 2010, Page 500 DOI: 10.1007/s12613-010-0348-y Corresponding author: Zhuan Li E-mail: li_zhuan@https://www.doczj.com/doc/6a870449.html, ? University of Science and Technology Beijing and Springer-Verlag Berlin Heidelberg 2010 Preparation and properties of C/C-SiC brake composites fabricated by warm compacted-in situ reaction Zhuan Li, Peng Xiao, and Xiang Xiong State Key Laboratory of Powder Metallurgy, Central South University, Changsha 410083, China (Received: 12 August 2009; revised: 28 August 2009; accepted: 2 September 2009) Abstract: Carbon fibre reinforced carbon and silicon carbide dual matrix composites (C/C-SiC) were fabricated by the warm compacted-in situ reaction. The microstructure, mechanical properties, tribological properties, and wear mechanism of C/C-SiC composites at different brake speeds were investigated. The results indicate that the composites are composed of 58wt% C, 37wt% SiC, and 5wt% Si. The density and open porosity are 2.0 g·cm–3 and 10%, respectively. The C/C-SiC brake composites exhibit good mechanical properties. The flexural strength can reach up to 160 MPa, and the impact strength can reach 2.5 kJ·m–2. The C/C-SiC brake composites show excellent tribological performances. The friction coefficient is between 0.57 and 0.67 at the brake speeds from 8 to 24 m·s?1. The brake is stable, and the wear rate is less than 2.02×10?6 cm3·J?1. These results show that the C/C-SiC brake composites are the promising candidates for advanced brake and clutch systems. Keywords: C/C-SiC; ceramic matrix composites; tribological properties; microstructure [This work was financially supported by the National High-Tech Research and Development Program of China (No.2006AA03Z560) and the Graduate Degree Thesis Innovation Foundation of Central South University (No.2008yb019).] 温压-原位反应法制备C / C-SiC刹车复合材料的工艺和性能 李专，肖鹏，熊翔 粉末冶金国家重点实验室，中南大学，湖南长沙410083，中国（收稿日期：2009年8月12日修订：2009年8月28日;接受日期：2009年9月2日） 摘要：采用温压?原位反应法制备炭纤维增强炭和碳化硅双基体(C/C-SiC)复合材
英语毕业论文引用和参考文献格式 英语专业毕业论文引用和参考文献格式采用APA格式及规。 一、文中夹注格式 英语学位论文引用别人的观点、方法、言论必须注明出处，注明出处时使用括号夹注的方法（一般不使用脚注或者尾注），且一般应在正文后面的参考文献中列出。关于夹注，采用APA格式。 （一）引用整篇文献的观点 引用整篇文献（即全书或全文）观点时有两种情况： 1.作者的姓氏在正文中没有出现，如： Charlotte and Emily Bronte were polar opposites, not only in their personalities but in their sources of inspiration for writing (Taylor, 1990). 2. 作者的姓氏已在正文同一句中出现，如： Taylor claims that Charlotte and Emily Bronte were polar opposites, not only in their personalities but in their sources of inspiration for writing (1990). 3. 如果作者的姓氏和文献出版年份均已在正文同一句中出现，按APA的规不需使用括号夹注，如： In a 1990 article, Taylor claims that Charlotte and Emily Bronte were polar opposites, not only in their personalities but in their sources of inspiration for writing. 4. 在英文撰写的论文中引用中文著作或者期刊，括号夹注中只需用汉语拼音标明作者的姓氏，不得使用汉字，如：(Zhang, 2005) （二）引用文献中具体观点或文字 引用文献中某一具体观点或文字时必须注明该观点或者该段文字出现的页码出版年份，没有页码是文献引用不规的表现。 1.引用一位作者的文献 （1）引用容在一页，如： Emily Bronte “expressed increasing hostility for the world of human relationships, whether sexual or social” (Taylor, 1988：11). （2）引用容在多页上，如： Newmark (1988：39-40) notes three characteristically expressive text-types: (a) serious imaginative literature (e.g. lyrical poetry); (b) authoritative statements (political speeches and documents, statutes and legal documents, philosophical and academic works by acknowledged authorities); (c) autobiography, essays, personal correspondence (when these are personal effusions).
Web应用程序安全外文翻译参考文献(文档含中英文对照即英文原文和中文翻译) 原文： Basic Security Practices for Web Applications Even if you have limited experience with and knowledge of application security, there are basic measures that you should take to help protect your Web applications. The following sections in this topic provide minimum-security guidelines that apply to all Web applications.General Web Application Security Recommendations;Run Applications with Minimum Privileges ;Know Your Users; Guard Against Malicious User Input;Access Databases Securely;Create Safe Error Messages;Keep Sensitive Information Safely;Use Cookies Securely;Guard Against Denial-of-Service Threats. 1. General Web Application Security Recommendations
Structure and function of the MCS-51 series Structure and function of the MCS-51 series one-chip computer MCS-51 is a name of a piece of one-chip computer series which Intel Company produces. This company introduced 8 top-grade one-chip computers of MCS-51 series in 1980 after introducing 8 one-chip computers of MCS-48 series in 1976. It belong to a lot of kinds this line of one-chip computer the chips have,such as 8051, 8031, 8751, 80C51BH, 80C31BH,etc., their basic composition, basic performance and instruction system are all the same. 8051 daily representatives- 51 serial one-chip computers . An one-chip computer system is made up of several following parts: ( 1) One microprocessor of 8 (CPU). ( 2) At slice data memory RAM (128B/256B),it use not depositting not can reading /data that write, such as result not middle of operation, final result and data wanted to show, etc. ( 3) Procedure memory ROM/EPROM (4KB/8KB ), is used to preserve the procedure , some initial data and form in slice. But does not take ROM/EPROM within some one-chip computers, such as 8031 , 8032, 80C ,etc.. ( 4) Four 8 run side by side I/O interface P0 four P3, each mouth can use as introduction , may use as exporting too. ( 5) Two timer / counter, each timer / counter may set up and count in the way, used to count to the external incident, can set up into a timing way too, and can according to count or result of timing realize the control of the computer. ( 6) Five cut off cutting off the control system of the source . ( 7) One all duplexing serial I/O mouth of UART (universal asynchronous receiver/transmitter (UART) ), is it realize one-chip computer or one-chip computer and serial communication of computer to use for. ( 8) Stretch oscillator and clock produce circuit, quartz crystal finely tune electric capacity need outer. Allow oscillation frequency as 12 megahertas now at most. Every the above-mentioned part was joined through the inside data bus .Among them, CPU is a core of the one-chip computer, it is the control of the computer and command centre, made up of such parts as arithmetic unit and controller , etc.. The arithmetic unit can carry on 8 persons of arithmetic operation and unit ALU of logic operation while including one, the 1 storing device temporarilies of 8, storing device 2 temporarily, 8's accumulation