4S零配件管理系统毕业设计（论文）

1、大连交通大学信息工程学院2012届本科生毕业设计外文翻译大连交通大学信息工程学院毕业设计(论文)任务书题 目 鼎盛4s零配件管理系统任务及要求：1.设计（研究）内容和要求任务：1、 调查鼎盛4s店零配件管理系统当前技术的发展近况，完成实习报告，字数不少于3000，第三周交给指导老师。2、 结合自己实习情况安排进度，填写进度计划表，第二周完成后交给指导老师签字，并严格执行。3、 按照软件工程思想，独立完成系统的设计和程序开发，完成代码估计2000行左右。4、 用javaee技术实现鼎盛4s店零配件管理系统。5、 程序简洁，算法可行，运行情况良好。要求：1、 每周和指导老师至少见面沟通一次，回报课

2、题进展情况，接受老师询问。2、 接到任务书后，查阅与题目及专业相关的外文资料进行翻译，要求不少于10000个外文字符，译出汉字不得少于3000，于第四周交给指导老师审阅。3、 毕业设计第13周完成毕业论文的装订，并由指导老师评阅。论文要求12000字以上，包括综述、系统总体设计、系统实现、性能分析、结论等。4、 教学第13周通过中软及教研室组织进行软件验收，验收时要提供软件使用说明书。5、 于第13周提出毕业答辩申请并签字。6、 第14 周答辩，要求制作ppt2.原始依据通过大学几年的学习，已经学习了诸如软件工程、数据库原理及应用、数据结构、c+、visual basic、java等多门程序设

3、计语言和网络等基础知识和专业知识，学生有能力而且可以独立完成小中型项目的设计与开发。学校现有设备和环境可以提供给学生实习和上机，而且具有专业老师可以指导学生。3.参考文献1 温涛.东软java软件工程师.大连:东软电子出版社.20072 毛璟骏.macromedia dreamweaver mx动态网站开发标准教程.北京:人民大学出社.20073 黄璐.高永梅.基于jsp的网络管理系统的设计与实现.北京:清华大学出版社.20074 刘鲁.软件测试讲解.北京:航天航空大学出版社.20065 黄映霞.jsp项目开发案例.北京:清华大学出版社.2010.26 飞思科技产品研发中心.sql2000基础

4、与提高m.北京:电子工业出版社.20067 邹启杰.软件工程实用教程m.大连:东软信息学院.20088 张青.sql2000中文版基础教程m.北京:清华大学出版社.20039 闫海珍.java实用教程基于weblogic和eclipse m.大连:电子工业出版社.200710 sun. inc. javatm 2 sdk. standard edition documentation version 1.4.1 eb/ol. sun microsystems.inc.2002指导教师签字：教研室主任签字：2012年3月26日大连交通大学信息工程学院毕业设计(论文)进度计划与考核表学生姓名刘畅专

5、业班级软件工程08-1班指导教师常敬岩史 原本课题其他人员无题目鼎盛4s店零配件管理系统日期计划完成内容完成情况指导老师检查签字第1周拟订毕业论文进度计划与考核表第2周完成实习或调研报告第3周提交外文文献翻译资料第4周系统概要设计阶段第5周系统详细设计阶段第6周系统编码实施、完成论文初稿第7周完成系统编码实施第8周系统编码调试、提交论文初稿第9周完成系统编码调试、完善毕业论文第10周完成撰写毕业设计论文编写及代码测试第11周完成论文终稿、准备毕业论文打印、装订第12周提交毕业论文终稿及代码第13周完成毕业论文第14周毕业论文答辩指导教师签字： 年月日注：“计划完成内容”由学生本人认真填写，其它

6、由指导教师考核时填写。大连交通大学信息工程学院毕业设计(论文)调研报告学生姓名 刘畅 专业班级 软件工程08-1班指导教师 常敬岩 史原 职 称 高工 讲师 所在单位 信息科学系软件工程教研室 教研室主任 刘瑞杰 完成日期 2012年 4月6日database trendsdatabase management system has experienced 30 years of evolution, has made brilliant achievements, developed into a rich subject, forming a total tens of billions

7、of dollars in a software industry. according to gartner dataquests survey, in 2000 total sales of the international database market $ 8.8 billion, up 10% over 1999. according to ccids report, chinas 2000 total sales of database management systems market, 2.48 billion yuan, compared with an increase

8、of 41.7% in 1999, accounting software market, 10.8% of total sales. can be seen, the database has become a huge and rapidly growing market.currently, the representative of the market oracles database products, including oracle, ibms db2 and microsoft sql server and so on. in a certain sense, these c

9、haracteristics of the product reflects the current database, the highest industry standards and trends. therefore, the analysis of these mainstream product development status of our understanding of database technology is an important aspect of development.relational database technology is still the

10、 mainstreamrelational database technology in the 1970s, after 80 years to 90 years of development is relatively mature, once in the early 1990s by the great challenges of object-oriented database, but the market finally chose a relational database. whether it is oracles oracle 9i, ibms db2, or micro

11、soft sql server are all relational databases. gartner dataquest report shows relational database management system (rdbms) the largest market share in 2000, the rdbms market share of 80% of the database market, this proportion increased by more than 15% in 1999. this set of data to fully explain tod

12、ays rdbms is still the most popular database software. at present, due to the rise of internet applications, xml-formatted data have emerged, some scholars believe that the next generation of academic database model to support the new xml database. author of this negative attitude that the relations

13、hip between the technology is still the mainstream, whether it is multi-media content management, xml data support, or support for complex objects in a relational system and so will be the core technology based on the expansion. products to form a series on the one hand, web and data warehousing app

14、lications such as the rise of the absolute amount of data at an alarming rate in the rapid expansion; the other hand, rapid growth in mobile and embedded applications. for the different needs of the market, the database is the direction towards the series. for example, ibms db2 universal database pr

15、oducts ranging from high-end enterprise-class parallel database server, db2 everywhere products to the mobile terminal set of series. see from the support platform, todays db2 on the mainframe is no longer the exclusive product, which supports the current mainstream variety of platforms, including l

16、inux and windows nt. in addition, it also has a variety of middleware products, such as db2 connect, db2 datajointer, db2 replication, which form a large database of family.support a variety of internet applicationsdatabase management system is a network economy, one of the important infrastructure.

17、 support the internet (and even mobile internet) database applications has become an important aspect of database system. for example, oracles full support starting from version 8 of internet applications, the representative of the internet database. microsoft is sql server as its whole. net program

18、 is an important component. for internet applications, because users can not be predicted in advance, which requires the database to handle more than before with large amounts of data as well as the more users the ability to provide services, that is to have good scalability and high availability .

19、in addition, the internet provides a lot of data in xml format is characterized by semi-structured data to support this type of data storage, sharing, management, retrieval is the development direction of the various database vendors.extended to the intelligent direction of integrationwidespread use

20、 of database technology for businesses and organizations to collect and accumulate a large amount of data. extensive knowledge of the reality of poor data led directly to online analytical processing (olap), data warehouse (data warehousing) and data mining (data mining) and other technologies, to p

21、romote the database to the intelligent direction. at the same time more and more complex enterprise applications will involve the application server, web server, other databases, legacy systems and third party software applications, database products and the software is often a good integration of t

22、he entire system performance. oracles products include oracle 9i olap, data mining, etl tools such as a complete set of bi (business intelligence) support platform, middleware and its tight integration with the core database features, oracle application server, a key function is to increase cache fe

23、ature that can unload data from the database to the application server to speed up web users for data access speed. ibm has also put its bi suite as a key to the development of the database. microsoft believes that the next generation of business intelligence will be its main profit point.trends in

24、database technology data, computer hardware and database applications, these three technologies and systems to promote the development of the database. database to manage the data complexity and data volumes are growing rapidly; computer hardware platform development is still the practice of moores

25、law; database applications quickly to the depth, breadth. in particular, the emergence of the internet has greatly changed the database application environment, the database field to make an unprecedented technical challenge. changes in these factors driving advances in database technology, a number

26、 of new database technology, such as web database technology, parallel database technology, data warehousing and online analytical techniques, data mining and business intelligence, content management technology, massive data management technology. due to space limitations, this can not be started o

27、ne by one to explain these changes, but from the sum of these changes in the development of database technology presents the salient features.four high that dbms with high reliability, high performance, high scalability and high security. database is the core of enterprise information systems and in

28、frastructure, its reliability and performance is of great concern to business leaders. because, once the downtime will result in huge economic losses businesses, and even lead to legal disputes. the most typical example is the securities trading system, if a market is coming, as trading volume soare

29、d, resulting in insufficient capacity of database systems, database systems led to the collapse of securities companies and investors will be to huge losses. early computer applications in china, as the computer system is not necessary components of business operations, people understand the importa

30、nce of the database, and in order to save funds are often used on some low-level data management software, such as dbase, etc., or piracy the software. however, with the deepening of the process of information technology, computer systems increasingly become an indispensable part of the operation, t

31、hen, stable and efficient database system is a necessary condition. in the internet environment, but also thousands or tens of thousands of users consider supporting both access and 7x24 hours continuous operation requirements, to provide online data backup, fault tolerance, disaster recovery and in

32、formation security measures.in fact, the database system is technically stable and efficient long-lasting pursuit. in addition, the development of enterprise information systems from the point of view, a system scalability is very important. as the business expanded, the original size and capacity o

33、f the system is no longer time to adapt to new requirements, not to replace the higher-end machines, but based on the original new equipment, such as processor, memory, etc., which to distribute the load purposes. data security is another important issue, the ordinary mechanisms based authorization

34、can not meet the requirements of many applications, the new role-based authorization mechanisms, and some security elements, such as storage covert channel analysis, mark, encryption, reasoning control and so, in some applications need to be surly.internet means the database system to support the ap

35、plication of the internet environment, information systems to support internet visits to achieve the data exchange between different databases and sharing, to deal with xml data type as the representative of online data, even to consider the development of wireless communications has brought revolut

36、ionary change. compared with traditional databases, the internet environment, the database system to be equipped to handle larger amounts of data and provide services for more users the ability to provide effective support for long transactions, to provide fast access to xml data type effective supp

37、ort.synergy requirement for industry applications, the core of the dbms, based on the development of a rich suite of database and application components, with manufacturing information, and other areas of e-government suite of applications bundled to form the core of the dbms for the industry applic

38、ation software product family. to meet application needs, joint development of database and application suite components, database technology has become the new trend and product development. planning major expansion in oracle 11i also alleged a variety of major support for the application suite.in

39、the early 1970s, eecodd first proposed the relational model. the mid-1970s, ibm corporation in the development of system r relational database management system developed by the sql language, the earliest of the sql language (called sequel2) in november 1976 the ibm journal of r & d on the published

40、.in 1979, oracle corporation offers the first commercial sql, ibms db2 and sql / ds database system also achieved sql. in october 1986, the united states using ansi sql relational database management system as a standard language (ansi x3. 135-1986), after the international organization for standard

41、ization (iso) adopted as international standards. in 1989, the u.s. ansi in ansi x3.135-1989 to adopt the report as defined in the sql relational database management system standard language, known as the ansi sql 89, instead of the standard ansi x3.135-1986 version. the standard adopted by the foll

42、owing organizations: the international organization for standardization (iso), for the iso 9075-1989 report database language sql with integrity enhancementu.s. federal government, published in the federal information processing standard publication (fips pub) 127currently, all major relational data

43、base management systems support some form of sql language, most of the database intended to comply with ansi sql89 standard.advantages of sqlsql is widely used is indicative of its advantages. it allows all users, including the application programmer, dba administrators and end users benefit greatly

44、.(1) non-procedural languagesql is a non-procedural language, because it is a deal with a record of data to provide automatic navigation. sql allows the user to work on high-level data structures, rather than a single record of the operation, operational records set. collection of all the sql statem

45、ents received as input and returns a collection as output. a collection of sql feature allows an sql statement results as input to another sql statement. sql does not require the user to specify the data storage method. this feature allows users to more easily focus on the results obtained. all sql

46、statements use the query optimizer, which is part of the rdbms, which it has decided to specify the data access speed of the fastest means. the query optimizer knows what indexes exist, where suitable, and the user never needs to know whether there is an index table, the table what type of index.(2)

47、 a unified languagesql db can be used for all user activity model, including system administrators, database administrators, application programmers, decision support system personnel, and many other types of end users. basic sql commands can be learned with little time, the most senior command can

48、be mastered within a few days. sql provides commands for many tasks,previous database management system for these types of operations to provide a separate language, and sql will be fully unified in a language task.(3) is the common language for all relational databaselanguage developed by microsoft

49、 sql server relational database management and promotion system (dbms), which was originally developed by microsoft, sybase and ashton-tate three companies jointly developed and launched in 1988, the first os / 2 version. in recent years, continually updated version of sql server 1996, microsoft int

50、roduced the sql server 6.5 version; 1998, sql server 7.0 version and users to meet; sql server 2000 is microsofts launch in 2000, the latest version. microsoft sql server 2000 is a distributed relational database management system with client / server architecture, using a technique known as transac

51、t-sql in sql passed between client and server requests the client and server processing results . support for xml (extensive markup language, extensible markup language. a powerful web-based analysis support the ole db and a variety of queries. supports distributed partitioned views.sql server is a

52、relational database management system. it was originally developed by microsoft sybase and ashton-tate three companies jointly developed in 1988 introduced the first os / 2 version. in the introduction of windows nt, microsoft sql server and sybase in the development of on separate ways, microsoft s

53、ql server is ported to windows nt systems, focusing on the development and promotion of sql server version of windows nt. sybase sql server is more focused on the unix operating system on the application.2数据库的发展趋势数据库管理系统经历了30多年的发展演变，已经取得了辉煌的成就，发展成了一门内容丰富的学科，形成了总量达数百亿美元的一个软件产业。根据gartner dataquest公司的调

54、查，2000年国际数据库市场销售总额达88亿美元，比1999年增长10%。根据ccid的报告，2000年的中国数据库管理系统市场销售总额达24.8亿元，比1999年增长了41.7%，占软件市场总销售额的10.8%。可见，数据库已经发展成为一个规模巨大、增长迅速的市场。 目前，市场上具有代表性的数据库产品包括oracle公司的oracle、ibm公司的db2以及微软的sql server等。在一定意义上，这些产品的特征反映了当前数据库产业界的最高水平和发展趋势。因此，分析这些主流产品的发展现状，是我们了解数据库技术发展的一个重要方面。 关系数据库技术仍然是主流 关系数据库技术出现在20世纪70年

55、代、经过80年代的发展到90年代已经比较成熟，在90年代初期曾一度受到面向对象数据库的巨大挑战，但是市场最后还是选择了关系数据库。无论是oracle公司的oracle 9i、ibm公司的db2、还是微软的sql server等都是关系型数据库。gartner dataquest的报告显示关系数据库管理系统(rdbms)的市场份额最大， 2000年rdbms的市场份额占整个数据库市场的80%，这个比例比1999年增长了15%。这组数据充分说明rdbms仍然是当今最为流行的数据库软件。当前，由于互联网应用的兴起，xml格式的数据的大量出现，学术界有一部分学者认为下一代数据库将是支持xml模型的新型

56、的数据库。作者对此持否定态度，认为关系技术仍然是主流，无论是多媒体内容管理、xml数据支持、还是复杂对象支持等都将是在关系系统内核技术基础上的扩展。 产品形成系列化 一方面，web和数据仓库等应用的兴起，数据的绝对量在以惊人的速度迅速膨胀；另一方面，移动和嵌入式应用快速增长。针对市场的不同需求，数据库正在朝系列化方向发展。例如ibm公司的db2通用数据库产品包括了从高端的企业级并行数据库服务器，到移动端产品db2 everywhere的一整套系列。从支持平台看，今天的db2已经不再是大型机上的专有产品，它支持目前主流的各种平台，包括linux和windows nt。此外，它还有各种中间件产品，

57、如db2 connect、db2 datajointer、db2 replication等，构成了一个庞大的数据库家族。 持各种互联网应用 数据库管理系统是网络经济的重要基础设施之一。支持internet（甚至于mobile internet）数据库应用已经成为数据库系统的重要方面。例如，oracle公司从8版起全面支持互联网应用，是互联网数据库的代表。微软公司更是将sql server作为其整个.net计划中的一个重要的成分。对于互联网应用，由于用户数量是无法事先预测的，这就要求数据库相比以前拥有能处理更大量的数据以及为更多的用户提供服务的能力，也就是要拥有良好的可伸缩性及高可用性。此外，互联网提供大量以xml格式数据为特征的半结构化数据，支持这种类型的数据的存储、共享、管理、检索等也是各数据库厂商的发展方向。 向智能化集成化方向扩展 数据库技术的广泛使用为企业和组织收集并积累了大量的数据。数据丰富知识贫乏的现实直接导致了联机分析处理（olap）、数据仓库（data warehousing）和数据挖掘(data mining)等技术的出现，促使数据库向智能化方向发展。同时企业应用越来越复杂，会涉及到应用服务器、web服务器、其它数据库、旧系统中的应用以及第三方软件等，数据库产品与这些软件是否具有良好集成性往往关系到整个系统的性能。oracle公司的oracl