数据库外文文献翻译

Transact-SQL Cookbook

第一章数据透视表

1.1使用数据透视表

1.1.1 问题

支持一个元素序列往往需要解决各种问题。例如，给定一个日期范围，你可能希望产生一行在每个日期的范围。或者，您可能希望将一系列的返回值在单独的行成一系列单独的列值相同的行。实现这种功能，你可以使用一个永久表中存储一系列的顺序号码。这种表是称为一个数据透视表。

许多食谱书中使用数据透视表，然后，在所有情况下，表的名称是。这个食谱告诉你如何创建表。

1.1.2 解决方案

首先，创建数据透视表。下一步，创建一个表名为富，将帮助你在透视表：CREATE TABLE Pivot (

i INT,

PRIMARY KEY(i)

)

CREATE TABLE Foo(

i CHAR(1)

)

富表是一个简单的支持表，你应插入以下10行：

INSERT INTO Foo VALUES('0')

INSERT INTO Foo VALUES('1')

INSERT INTO Foo VALUES('2')

INSERT INTO Foo VALUES('3')

INSERT INTO Foo VALUES('4')

INSERT INTO Foo VALUES('5')

INSERT INTO Foo VALUES('6')

INSERT INTO Foo VALUES('7')

INSERT INTO Foo VALUES('8')

INSERT INTO Foo VALUES('9')

利用10行在富表，你可以很容易地填充枢轴表1000行。得到1000行10行，加入富本身三倍，创建一个笛卡尔积：

INSERT INTO Pivot

SELECT f1.i+f2.i+f3.i

FROM Foo f1, Foo F2, Foo f3

如果你名单上的行数据透视表，你会看到它所需的数目的元素，他们将编号从0到999。

1.1.3讨论

你会看到食谱，跟随在这本书中，枢轴表通常是用来添加一个排序属性查询。某种形式的数据透视表中发现许多数据库为基础的系统，尽管它往往是隐藏的用户，主要用在预定义的查询和程序。

你已经看到一些表连接（的富表）控制的行数，我们插入语句生成的数据透视表。从0到999的值是通过连接生成的字符串。数字值，是字符串。因此，当加号（+）运算符用来串连，我们得到的结果如下：

'0' + '0' + '0' = '000'

'0' + '0' + '1' = '001

这些结果是插入整数列在目的地的数据透视表。当你使用一个插入语句插入字符串到整数列的数据库，含蓄地转换成整数的字符串。笛卡尔积富情况下确保

所有可能的组合生成，和，因此，所有可能的值从0到999的产生。

这是值得指出的，这个例子使用行从0999和负数。你可以很容易地产生负面的号码，如果需要，重复插入声明“-”符号前面的连接字符串，小心点大约0排。有没有这样的事，作为一个- 0，所以你不想将' 000 '行时产生的负轴数。如果你这样做，你最终会与0行的数据透视表。在我们的例子中，0行是不可能的，因为我们定义一个主键的透视表。

枢轴表可能是最有用的表中的世界。一旦你使用它，它几乎是不可能创造一个严重的应用没有它。作为一个示范，让我们用枢轴表生成一个图表迅速从32码到126：

SELECT i Ascii_Code, CHAR(i) Ascii_Char FROM Pivot

WHERE i BETWEEN 32 AND 126

Ascii_CodeAscii_Char

----------- ----------

32

33 !

34 "

35 #

36 $

37 %

38 &

39 '

40 (

41 )

42 *

43 +

44 ,

45 -

46 .

47 /

48 0

49 1

50 2

51 3

...

如何更好的使用数据透视表在这个特定的例子是你产生行输出不具有同等数量的行输入。没有数据透视表，这是困难的，如果不是不可能的任务。简单的指定一个范围，然后选择枢轴行在该范围内，我们能够产生的数据，不存在任何数据库中的表。

作为另一个例子，数据透视表的有用性，我们可以很容易地使用它来生成一个日历的下一个七天：

SELECT

CONVERT(CHAR(10),DATEADD(d,i,CURRENT_TIMESTAMP), 121) date, DATENAME(dw,DATEADD(d,i,CURRENT_TIMESTAMP)) day FROM Pivot

WHERE i BETWEEN 0 AND 6

date day

---------- ------------------------------

2001-11-05 Monday

2001-11-06 Tuesday

2001-11-07 Wednesday

2001-11-08 Thursday

2001-11-09 Friday

2001-11-10 Saturday

2001-11-11 Sunday

这些查询只是快速震荡，列在这里向您展示如何一个数据透视表可用于查询。你会看到其他的食谱，枢轴表往往是一个必不可少的工具，为快速有效的解决问题。

第二章集

结构化查询语言，作为一种语言，是围绕这一概念集。你可能记得在小学学习，或者也许你研究套代数在高中或大学。虽然语句如选择，更新，删除和可用于在一个数据行在一个时间，该报表设计运行数据集，且你获得最好的优势时，使用这种方式。尽管这一切，我们通常看到的程序，使用操纵数据一次一行，而不是采取优势的强大的订珠加工能力。我们希望，这一章，我们可以打开你的眼睛的力量，集合操作。

当你写语句，不知道对程序，选择一个记录，更新它，然后选择另一个。相反，认为无论在经营上的记录集，一下子。如果你使用的程序性思维，思维可以采取一些习惯。为了帮助你，这一章提出了一些食谱表明权力的一套面向编程方法与结构化查询语言。

食谱，在本章的组织表现出不同类型的操作，可以进行设置。你会看到如何找到共同的要素，总结的一组数据，并找出元素集是一个极端。行动不一定符合数学定义的集合运算。相反，我们这些定义和解决现实世界的问题，用代数术语。在现实世界中，有些偏离严格的数学定义是必要的。例如，它往往是必要的元素的集合，一个操作是不可能的数学定义集。

2.1简介

潜水前的食谱，我们想通过一些基本步骤作了简要的概念和定义的术语在本章。虽然我们相信你所熟悉的数学概念，交叉口，和工会，我们想把这些set-algebra条款纳入一个现实世界的例子。

2.1.1部件

有三种类型的部件时应注意工作组。第一个是自己设定的。一个集合是一个集合的元素，和，为我们的宗旨，元素是数据库表中的行或列的查询返回的。最后，我们的宇宙，这是我们长期使用参考的所有可能的元素为一组给定。

2.1.1.1集

一个集合是一个集合的元素。根据定义，内容不得复制，和他们没有命令。在这里，数学定义的一组不同于其实际使用中的语言。在现实世界中，它往往是有益的排序集合的元素到一个指定的顺序。这样做可以让你找到极端等五大，或底部五，记录。图2 - 1显示了一例2套。我们会提到这些例子，我们讨论的各个方面的术语。

我们的目的，我们将考虑一组是一个收集表中的行确定一个共同的元素。考虑，例如，下面的表项。这张桌子是一家集集，其中每个集是一个独特的标识order-identification数。

CREATE TABLE OrderItems(

OrderId INTEGER,

ItemId INTEGER,

ProductIdCHAR(10),

Qty INTEGER,

PRIMARY KEY(OrderId,ItemId)

)

每一集都在这个案件是一个秩序和有很多元素，不重复。将元素行定义产品的数量和这些产品被命令。常见的元素是订单列。

使用SQL，很容易从一组列表中的所有元素。你只是问题的一条语句的选择与确定一套具体的利益。以下查询将返回所有单项记录集合中的顺序确定的：SELECT * FROM OrderItems WHERE OrderId=112

在这一章中，我们将与集，总是在一个表。许多作者试图证明集合操作使用不同的表。这个方法有2个问题。首先，从实证角度而有利，你很少会发现一个数据库表，都具有相同的结构。其次，有许多隐藏的可能性书面查询来当你认为不同的设置为不同的片同表。通过集中在一个表，我们希望能打开你的心，这些可能性。

2.1.1.2元素

一个元素是一个成员的一组。图2 - 1，每一个人的信是一个元素。我们的目的，工作时，一个元素是一个行的表。结构化查询语言，它往往是有益的，不认为元素统一实体。在纯数学意义上来说，这是不可能的，一个集合的元素划分为2个或多个组件。结构化查询语言，然而，你可以分为组成元素。一个表通常是由许多不同的栏目，你就会经常查询写入操作只有一个子集，这些列。

例如，让我们说，你想找到的所有订单，包含一个炸药，无论数量。你的元素排在orderitems表。你需要使用产品编号列识别爆炸物，你会需要返回订单列

确定的订单，但你没有使用其他表中的列。这里的查询：

SELECT OrderId

FROM OrderItems o

GROUP BY OrderId

HAVING EXISTS(

SELECT *

FROM OrderItems o1

WHERE o1.ProductId='Explosive' AND o.OrderId=o1.OrderId) 此查询实际使用的一组操作，你会读到这一章。操作称为包含操作，和它对应的查询关键字的存在。

2.1.1.3合集

一个合集的所有可能的元素可以是一个给定的集合。考虑1和2图。每一集是由字母的字母表。如果我们决定，只有字母可以设置元素，宇宙的两队会设置的所有信件，如图2 - 2所示。

一个更现实的例子一个宇宙，认为一个学校课程的学生提供40种可能。每个学生选择一个小数目40课程采取在某一学期。课程内容。本课程，使学生正在制定一套。不同的学生采取不同的组合和数量的课程。该集是不一样的，也不是所有大小相同，但他们都包含元素相同的宇宙。每个学生必须选择从相同的40种可能性。

在学生/课程的例子了，所有的元素都来自同一个宇宙。它也可能为一些套在一个表有不同的宇宙人。例如，假设一个表列出完成案例研究，学生提出了。进一步假设，宇宙可能的情况是不同的每个过程研究。如果你认为一套定义一个课程和学生，宇宙的元素，将取决于课程的学生。每个课程都会有不同的宇宙。

2.1.2集合运算

设置操作允许你把两只集并返回一些有意义的结果。确切的结果取决于要执行的操作。例如，你可以把两只，只返回那些元素出现在两套。这个过程被称为交叉。其他业务包括：包含，工会，补充，和差异。

2.1.2.1包含

包含操作告诉你是否一个特定的元素可以被发现在一个集合。图2 - 3显示1（图1）包含字母“d”

包含是一个非常基本的set-algebra操作，可以实现直接在查询相结合的选择语句的存在条款。例如，在下面的查询，存在用于每个学生的studentmaster表看，学生在组学生采取accn101课程编号：

SELECT * FROM StudentMastersm

WHERE EXISTS (SELECT * FROM Students s

WHERE sm.StudentName = s.StudentName

AND s.CourseId = 'ACCN101')

使用的存在是如此普遍，你可能甚至不想太多的基本操作，它代表。

2.1.2.2交叉

交叉是一个运行在2个或更多的是比较常见的元素。例如，图2 - 4显示1和2之间的交叉。

一个典型的问题回答了一个路口，学生已accn101谁也采取了mgmt120。SQL - 92标准指定关键字的使用交叉实施交叉操作。因此，你应该能写：

SELECT DISTINCT StudentName

FROM Students

WHERE CourseId='ACCN101'

INTERSECT

SELECT DISTINCT StudentName

FROM Students

WHERE CourseId='MGMT120

不幸的是，服务器不实施相交关键字。在这一章的交叉食谱显示一些技术解决了这个问题。此外，本章告诉你如何执行部分路口。一部分路口允许你查找元素属于某个特定的集数，但不一定是所有集合。

2.1.2.3联盟

工会是一种结合成一个较大的一套或多套，如图2 - 5所示。结果集包含的所有要素两套。

结构化查询语言（如语言）是装备精良的工作与工会和实行联合操作使用联合关键字。这允许你把返回的行选择报表和混合在一起到一个结果集。例如，下面的查询返回一个列表的学生谁采取任何accn101或mgmt120：

SELECT * FROM Students

WHERE CourseId = 'ACCN101'

UNION

SELECT * FROM Students

WHERE CourseId = 'MGMT120'

在合并操作，删除所有重复的结果。这方面的例子，如果一个学生采取了两个课程，他仍将只显示一次。如果你想保存重复行，你可以使用所有的地方工会联盟。

当你执行一个语句的选择使用欧盟运营商，服务器必须执行每个查询分别。在许多情况下，工会可以实现更有效的联盟商。一个典型的例子是当你定义一条为一组或多组标识相结合。另一个这样的情况是当你计算信息汇总数集。

2.1.2.4补充

补语是这个集合的所有元素在宇宙中缺少一套。图2 - 6显示设置1及其补充关于宇宙图2 - 2。

补充操作是密切相关的宇宙的一套，和一个联盟既补充和原来的宇宙，给你。你会看到在一个食谱，这样的一个例子是查找学生的记录，生成一个名单，失踪的学期论文。

不要被误导了的简单的概念。与补充，需要定义一个宇宙。它往往是可能定义一个宇宙范围；例如，你可以定义一个特定的容器有100个可能的插槽。在这种情况下，它是相当容易操作的补充。然而，如果你的问题需要你的具体定义的每一个可能的元素为一套，复杂的补充操作将增加。在这种情况下，你必须定义一个宇宙在不同的表和表查询。

2.1.2.5差异

两国之间的差异集的元素的集合，一组是不存在的。图2 - 7说明之间的差异1和2集。

设置不同的是一个常见的问题时，程序集，它是有用的当你想找到2个或更多的之间的差异。你可以减去一个从另一个，一套或多套从所有人，从一个特定的设置。

SQL - 92标准规定，除了关键字用于实现set-difference操作。不幸的是，由于交叉口，除了关键字尚未实现在服务器。在这一章中，我们会给你一个不同的方式产生了两国之间的差异集。

1.1 Using a Pivot Table

1.1.1 Problem

Support for a sequence of elements is often needed to solve various SQL problems. For example, given a range of dates, you may wish to generate one row for each date in the range. Or, you may wish to translate a series of values returned in separate rows into a series of values in separate columns of the same row. To implement such functionality, you can use a permanent table that stores a series of sequential numbers. Such a table is referred to as a Pivot table.

Many of the recipes in our book use a Pivot table, and, in all cases, the table's name is Pivot. This recipe shows you how to create that table.

1.1.2 Solution

First, create the Pivot table. Next, create a table named Foo that will help you populate the Pivot table:

CREATE TABLE Pivot (

i INT,

PRIMARY KEY(i)

)

CREATE TABLE Foo(

i CHAR(1)

)

The Foo table is a simple support table into which you should insert the following 10 rows:

INSERT INTO Foo VALUES('0')

INSERT INTO Foo VALUES('1')

INSERT INTO Foo VALUES('2')

INSERT INTO Foo VALUES('3')

INSERT INTO Foo VALUES('4')

INSERT INTO Foo VALUES('5')

INSERT INTO Foo VALUES('6')

INSERT INTO Foo VALUES('7')

INSERT INTO Foo VALUES('8')

INSERT INTO Foo VALUES('9')

Using the 10 rows in the Foo table, you can easily populate the Pivot table with 1,000 rows. To get 1,000 rows from 10 rows, join Foo to itself three times to create a Cartesian product:

INSERT INTO Pivot

SELECT f1.i+f2.i+f3.i

FROM Foo f1, Foo F2, Foo f3

If you list the rows of Pivot table, you'll see that it has the desired number of elements and that they will be numbered from 0 through 999.

You can generate more rows by increasing the number of

joins. Join Foo four times, and you'll end up with 10,000

rows (10 * 10 * 10 * 10).

1.1.3 Discussion

As you'll see in recipes that follow in this book, the Pivot table is often used to add a sequencing property to a query. Some form of Pivot table is found in many SQL-based systems, though it is often hidden from the user and used primarily within predefined queries and procedures.

You've seen how the number of table joins (of the Foo table) controls the

number of rows that our INSERT statement generates for the Pivot table. The values from 0 through 999 are generated by concatenating strings. The digit values in Foo are character strings. Thus, when the plus (+) operator is used to concatenate them, we get results such as the following:

'0' + '0' + '0' = '000'

'0' + '0' + '1' = '001'

...

These results are inserted into the INTEGER column in the destination Pivot table. When you use an INSERT statement to insert strings into an INTEGER column, the database implicitly converts those strings into integers. The Cartesian product of the Foo instances ensures that all possible combinations are generated, and, therefore, that all possible values from 0 through 999 are generated.

It is worthwhile pointing out that this example uses rows from 0 to 999 and no negative numbers. You could easily generate negative numbers, if required, by repeating the INSERT statement with the "-" sign in front of the concatenated string and being a bit careful about the 0 row. There's no such thing as a -0, so you wouldn't want to insert the '000' row when generating negative Pivot numbers. If you did so, you'd end up with two 0 rows in your Pivot table. In our case, two 0 rows are not possible, because we define a primary key for our Pivot table.

The Pivot table is probably the most useful table in the SQL world. Once you get used to it, it is almost impossible to create a serious SQL application without it. As a demonstration, let us use the Pivot table to generate an ASCII chart quickly from the code 32 through 126:

SELECT i Ascii_Code, CHAR(i) Ascii_Char FROM Pivot

WHERE i BETWEEN 32 AND 126

Ascii_CodeAscii_Char

----------- ----------

32

33 !

34 "

35 #

36 $

37 %

38 &

39 '

40 (

41 )

42 *

43 +

44 ,

45 -

46 .

47 /

48 0

49 1

50 2

51 3

...

What's great about the use of the Pivot table in this particular instance is that you generated rows of output without having an equal number of rows of input. Without the Pivot table, this is a difficult, if not impossible, task. Simply by specifying a range and then selecting Pivot rows based on that range, we were able to generate data that doesn't exist

in any database table.

You must have enough Pivot table rows to accommodate the

range that you specify. Had we used BETWEEN 32 AND 2000,

our query would have failed, because our Pivot table has

only 1,000 rows, not the 2,001 that would be required

by such a large range.

As another example of the Pivot table's usefulness, we can use it easily to generate a calendar for the next seven days:

SELECT

CONVERT(CHAR(10),DATEADD(d,i,CURRENT_TIMESTAMP), 121) date,

DATENAME(dw,DATEADD(d,i,CURRENT_TIMESTAMP)) day FROM Pivot WHERE i BETWEEN 0 AND 6

date day

---------- ------------------------------

2001-11-05 Monday

2001-11-06 Tuesday

2001-11-07 Wednesday

2001-11-08 Thursday

2001-11-09 Friday

2001-11-10 Saturday

2001-11-11 Sunday

These two queries are just quick teasers, listed here to show you how a Pivot table can be used in SQL. As you'll see in other recipes, the Pivot table is often an indispensable tool for quick and efficient problem solving.

Chapter 2. Sets

SQL, as a language, was developed around the concept of a set. You may remember studying sets in elementary school, or perhaps you studied set algebra in high school or college. While SQL statements such as SELECT, UPDATE, and DELETE can be used to work on one row of data at a time, the statements were designed to operate on sets of data, and you gain the best advantage when using them that way. In spite of all this, we commonly see programs that use SQL to manipulate data one row at a time rather than take advantage of the SQL's powerful set-processing capabilities. We hope that, with this chapter, we can open your eyes to the power of set manipulation.

When you write SQL statements, try not to think in terms of procedures such as selecting a record, updating it, and then selecting another. Instead, think in terms of operating on a set of records all at once. If you're used to procedural thinking, set thinking can take some getting used to. To help you along, this chapter presents some recipes that demonstrate the power of a set-oriented approach to programming with SQL.

The recipes in this chapter are organized to demonstrate different types of operations that can be performed on sets. You'll see how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme. The operations don't necessarily conform to the mathematical definition of set operations. Rather, we extend those definitions and use algebraic terminology to solve real-world problems. In the real world, some deviations from tight mathematical definitions are necessary. For example, it's often necessary to order the elements in a set, an operation that is not possible with mathematically defined sets.

2.1 Introduction

Before diving into the recipes, we would like to step briefly through some basic set concepts and define the terminology used in this chapter. Although we are sure you are familiar with the mathematical concepts of sets, intersections, and unions, we would like to put each of these

set-algebra terms into the context of a real-world example.

2.1.1 Components

There are three types of components to be aware of when working with sets.

First is the set itself. A set is a collection of elements, and, for our purposes, an element is a row in a database table or a row returned by a query. Lastly, we have the universe, which is a term we use to refer to the set of all possible elements for a given set.

2.1.1.1 Sets

A set is a collection of elements. By definition, the elements must not be duplicated, and they are not ordered. Here, the mathematical definition of a set differs from its practical use in SQL. In the real world, it's often useful to sort the elements of a set into a specified order. Doing so allows you to find extremes such as the top five, or bottom five, records. Figure 2-1 shows an example of two sets. We'll be referring to these examples as we discuss various aspects of set terminology.

For our purposes, we will consider a set to be a collection of rows from a table identified by one common element. Consider, for example, the following table of order items. This table is a collection of sets, where each set is identified by a unique order-identification number.

CREATE TABLE OrderItems(

OrderId INTEGER,

ItemId INTEGER,

ProductId CHAR(10),

Qty INTEGER,

PRIMARY KEY(OrderId,ItemId)

)

Each set in this case represents an order and will have a number of elements that are not duplicated. The elements will be rows defining the products and the quantity of those products being ordered. The common element is the OrderId column.

Using SQL, it is easy to list all elements from a set. You simply issue a SELECT statement with a WHERE clause that identifies the specific set of interest. The following query returns all line-item records in the set identified by order #112:

SELECT * FROM OrderItems WHERE OrderId=112

In this chapter, we will work with sets that are always in one table. Many authors try to demonstrate set operations using two different tables. This approach has two problems. First, while advantageous from a demonstration perspective, you will seldom find a database with two tables that both have the same structure. Second, there are many hidden possibilities for writing queries that come to light when you think of different sets as different slices of the same table. By focusing our recipes on a single table, we hope to open your mind to these possibilities.

2.1.1.2 Elements

An element is a member of a set. In Figure 2-1, each individual letter is an element. For our purposes, when working with SQL, an element is a row of a table. In SQL, it is often useful not to think of elements as unified entities. In the pure mathematical sense of the term, it's not possible to divide an element of a set into two or more components. In

SQL, however, you can divide an element into components. A table is usually composed of many different columns, and you'll often write queries that operate on only a subset of those columns.

For example, let's say that you want to find the set of all orders that contain an explosive, regardless of the quantity. Your elements are the rows in the OrderItems table. You'll need to use the ProductId column to identify explosives, and you'll need to return the OrderId column to identify the orders, but you have no use for the other columns in the table. Here's the query:

SELECT OrderId

FROM OrderItems o

GROUP BY OrderId

HAVING EXISTS(

SELECT *

FROM OrderItems o1

WHERE o1.ProductId='Explosive' AND o.OrderId=o1.OrderId)

This query actually uses one of the set operations that you'll read about in this chapter. The operation is known as the contains operation, and it corresponds to the SQL keyword EXISTS.

2.1.1.3 Universes

A universe is the set of all possible elements that can be part of a given set. Consider Sets 1 and 2 from Figure 2-1. Each set is composed of letters of the alphabet. If we decided that only letters could be set elements, the universe for the two sets would be the set of all letters as shown in Figure 2-2.

For a more real-life example of a set universe, assume that a school offers 40 possible courses to its students. Each student selects a small number of those 40 courses to take during a given semester. The courses are the elements. The courses that a given student is taking constitute a set. Different students are taking different combinations and numbers of courses. The sets are not all the same, nor are they all the same size, yet they all contain elements from the same universe. Each student must

choose from among the same 40 possibilities.

In the student/course example just given, all elements of all sets come from the same universe. It's also possible for some sets in a table to have different universes than others. For example, assume that a table contains a list of finished case studies that students have presented. Further assume that the universe of possible case studies is different for each course. If you consider a set to be defined by a course and a student, the universe of elements that applies depends on the course that the student took. Each course will have a different universe.

2.1.2 Set Operations

Set operations allow you to take two sets and return some sort of meaningful result. The exact result depends on the operation being performed. For example, you can take two sets and return only those elements that appear in both sets. This operation is known as the intersection. Other operations include: contains, union, complement, and difference.

2.1.2.1 Contains

The contains operation tells you whether a specific element can be found within a set. Figure 2-3shows that Set 1 (from Figure 2-1) contains the letter "D."

Contains is one of the very basic set-algebra operations and can be implemented directly in SQL by combining a SELECT statement with an EXISTS clause. For example, in the following query, EXISTS is used for each student in the StudentMaster table to see if that student is also in the set of students who have taken the course numbered ACCN101:

SELECT * FROM StudentMastersm

WHERE EXISTS (SELECT * FROM Students s

WHERE sm.StudentName = s.StudentName

AND s.CourseId = 'ACCN101')

The use of EXISTS is so common that you might not even think much about the underlying set operation that it represents.

2.1.2.2 Intersection

An intersection is an operation where two or more sets are compared for common elements. For example, Figure 2-4shows the intersection between sets 1 and 2.

A typical question answered by an intersection is which students have taken ACCN101 who have also taken MGMT120. The SQL-92 standards specify the use of the keyword INTERSECT to implement the intersection operation. Thus, you should be able to write:

SELECT DISTINCT StudentName

FROM Students

WHERE CourseId='ACCN101'

INTERSECT

SELECT DISTINCT StudentName

FROM Students

WHERE CourseId='MGMT120'

Unfortunately, SQL Server does not implement the INTERSECT keyword. The intersection recipes in this chapter show some techniques for working around this limitation. In addition, this chapter shows you how to perform a partial intersection. A partial intersection allows you to find elements that belong to a specific number of sets, but not necessarily to all sets.

2.1.2.3 Union

A union is a way to combine two or more sets into one larger set, as shown in Figure 2-5. The resulting set contains all elements from both sets.

SQL (as a language) is well-equipped to work with unions and implements the union operation using the UNION keyword. This allows you to take the rows returned by two SELECT statements and blend them together into one result set. For example, the following query returns a list of students who have taken either ACCN101 or MGMT120:

SELECT * FROM Students

外文翻译-数据库管理系统—剖析

Database Management System Source：Database and Network Journal Author：David Anderson You know that a data is a collection of logically related data elements that may be structured in various ways to meet the multiple processing and retrieval needs of orga nizations and individuals. There’s nothing new about data base-early ones were chiseled in stone, penned on scrolls, and written on index cards. But now database are commonly recorded on magnetically media, and computer programs are required to perform the necessary storage and retrieval operations. The system software package that handles the difficult tasks associated with created, accessing, and maintaining database records is in a DBMS package establish an interface between the database itself and the users of the database. (These users may be applications programmers, managers and others with information needs, and various OS programmers.) A DBMS can organize, process, and present selected data elements from the database. This capability enables decision makers to search. Probe, and query data contents in order to extract answers to nonrecurring and unplanned questions that aren’t available in regular reports. These questions might initially be vague and/or poorly defined, but people can “browse” through the database until they have the needed information. In short, the DBMS will “manage” the stored data items and assemble the needed items from the common database in response to the queries of those who aren’t programmers. In a file-oriented system, users needing special information may communicate their needs to a programmers, who, when time permits, will information. The availability of a DBMS, however, offers users a much faster alternative communications patch (see figure). Special, direct, and other file processing approaches ate used to organize and structure data in single files. But a DBMS is able to integrate data elements from several files to answer specific user inquiries fir information. This means that the DBMS is able to structure and tie together the logically related data from several large files. Logical structures. Identifying these logical relationships is a job of the data administrator. A data definition language is used for this purpose. The DBMS may

外文文献翻译,好的外文文献这里找

香港科技大学图书馆Dspace https://www.sodocs.net/doc/4317818600.html,t.hk/dspace 包括香港科技大学的学术论文、学位论文、研究报告等内容，均可免费获取全文。 Openj-gate https://www.sodocs.net/doc/4317818600.html,/ 提供4350种开放获取的期刊的数百万期刊全文文献。 加利福尼亚大学国际和区域数字馆藏 https://www.sodocs.net/doc/4317818600.html,/escholarship/ 加利福尼亚大学国际和区域数字馆藏研究项目。eScholarshipRepository主要提供已出版的期刊论文、未出版的研究手稿、会议文献以及其他连接出版物上的文章1万多篇，均可免费阅读。 剑桥大学机构知识库 https://www.sodocs.net/doc/4317818600.html,/ 由Cambridge University Library和University Computing Service维护，提供剑桥大学相关的期刊、学术论文、学位论文等电子资源。 发展中国家联合期刊库 https://www.sodocs.net/doc/4317818600.html,.br/ 非营利的电子出版物服务机构，提供来自发展中国家（如巴西、古巴、印度、印尼、肯尼亚、南非、乌干达、津巴布韦等）的开放获取的多种期刊的全文。 美国密西根大学论文库 https://www.sodocs.net/doc/4317818600.html,/index.jsp 美国密西根大学论文库2万多篇期刊论文、技术报告、评论等文献全文。包含艺术学、生物学、社会科学、资源环境学等学科的相关论文，另还有博硕士论文。标识为OPEN的可以打开全文。 jfg CERN Document Server http://cdsweb.cern.ch/ 主要覆盖物理学（particle physics）及相关学科，提供360,000多篇全文文献，包括预印文献、期刊论文、图书、图片、学位论文等等。 kl ArXiv https://www.sodocs.net/doc/4317818600.html,/ ArXiv是属于Cornell University的非盈利教育机构，面向物理学、数学、非线性科学、计算机科学和定量生物学等学科提供16种免费电子期刊的访问。 NASA Technical Reports Server https://www.sodocs.net/doc/4317818600.html,/?method=browse 主要是关于航空航天领域研究的科技报告和会议论文。

管理信息系统外文翻译

管理信息系统外文翻译-标准化文件发布号：（9456-EUATWK-MWUB-WUNN-INNUL-DDQTY-KII

英文文献翻译 二〇年月日

科技文章摘译 Definition of a Management Information System There is no consensus of the definition of the term "management information system". Some writers prefer alternative terminology such as "information processing system", "information and decision system", "organizational information system", or simply "information system" to refer to the computer-based information processing system which supports the operations, management, and decision-making functions of an organization. This text uses “MIS” because it is descriptive and generally understood; it also frequently uses “information system” instead of “MIS” to refer to an organizational information system. A definition of a management information system, as the term is generally understood, is an integrated, user-machine system for providing information to support operations, management, and decision-making functions in an organization. The system utilizes computer hardware and software; manual procedures; models for analysis planning, control and decision making; and a database. The fact that it is an integrated system does not mean that it is a single, monolithic structure; rather, it means that the parts fit into an overall design. The elements of the definition are highlighted below. 1 Computer-based user-machine system Conceptually, management information can exist without computer, but it is the power of the computer which makes MIS feasible. The question is not whether computers should be used in management information system, but the extent to which information use should be computerized. The concept of a user-machine system implies that some tasks are best performed by humans, while others are best done by machine. The user of an MIS is any person responsible for entering input data, instructing the system, or utilizing the information output of the system. For many problems, the user and the computer form a combined system with results obtained through a set of interactions between the computer and the user. User-machine interaction is facilitated by operation in which the user’s input-output device (usually a visual display terminal) is connected to the computer. The computer can be a personal computer serving only one user or a large computer that

大数据文献综述

信息资源管理文献综述 题目：大数据背景下的信息资源管理 系别：信息与工程学院 班级：2015级信本1班 姓名： 学号：1506101015 任课教师： 2017年6月 大数据背景下的信息资源管理 摘要：随着网络信息化时代的日益普遍，我们正处在一个数据爆炸性增长的“大数据”时代，在我们的各个方面都产生了深远的影响。大数据是数据分析的前沿技术。简言之，从各种各样类型的数据中，快速获得有价值信息的能力就是大数据技术，这也是一个企业所需要必备的技术。“大数据”一词越来越地别提及与使用，我们用它来描述和定义信息爆炸时代产生的海量数据。就拿百度地图来说，我们在享受它带来的便利的同时，无偿的贡献了我们的“行踪”，比如说我们的上班地点，我们的家庭住址，甚至是我们的出行方式他们也可以知道，但我们不得不接受这个现实，我们每个人在互联网进入大数据时代，都将是透明性的存在。各种数据都在迅速膨胀并变大，所以我们需要对这些数据进行有效的管理并加以合理的运用。

关键词：大数据信息资源管理与利用 目录 大数据概念.......................................................... 大数据定义...................................................... 大数据来源...................................................... 传统数据库和大数据的比较........................................ 大数据技术.......................................................... 大数据的存储与管理.............................................. 大数据隐私与安全................................................ 大数据在信息管理层面的应用.......................................... 大数据在宏观信息管理层面的应用.................................. 大数据在中观信息管理层面的应用.................................. 大数据在微观信息管理层面的应用.................................. 大数据背景下我国信息资源管理现状分析................................ 前言：大数据泛指大规模、超大规模的数据集，因可从中挖掘出有价值 的信息而倍受关注，但传统方法无法进行有效分析和处理.《华尔街日

企业数据建模外文翻译文献

企业数据建模外文翻译文献 (文档含中英文对照即英文原文和中文翻译) 翻译： 信息系统开发和数据库开发 在许多组织中，数据库开发是从企业数据建模开始的，企业数据建模确定了组织数据库的范围和一般内容。这一步骤通常发生在一个组织进行信息系统规划的过程中，它的目的是为组织数据创建一个整体的描述或解释，而不是设计一个特定的数据库。一个特定的数据库为一个或多个信息系统提供数据，而企业数据模型（可能包含许多数据库）描述了由组织维护的数据的范围。在企业数据建模时，你审查当前的系统，分析需要支持的业务领域的本质，描述需要进一步抽象的数据，并且规划一个或多个数据库开发项目。图1显示松谷家具公司的企业数据模型的一个部分。 1.1 信息系统体系结构 如图1所示，高级的数据模型仅仅是总体信息系统体系结构(ISA)一个部分或一个组

织信息系统的蓝图。在信息系统规划期间，你可以建立一个企业数据模型作为整个信息系统体系结构的一部分。根据Zachman(1987)、Sowa和Zachman（1992）的观点，一个信息系统体系结构由以下6个关键部分组成: 数据（如图1所示，但是也有其他的表示方法）。 操纵数据的处理（着系可以用数据流图、带方法的对象模型或者其他符号表示）。 网络，它在组织内并在组织与它的主要业务伙伴之间传输数据（它可以通过网络连接和拓扑图来显示）。 人，人执行处理并且是数据和信息的来源和接收者（人在过程模型中显示为数据的发送者和接收者）。 执行过程的事件和时间点（它们可以用状态转换图和其他的方式来显示）。 事件的原因和数据处理的规则（经常以文本形式显示，但是也存在一些用于规划的图表工具，如决策表）。 1.2 信息工程 信息系统的规划者按照信息系统规划的特定方法开发出信息系统的体系结构。信息工程是一种正式的和流行的方法。信息工程是一种面向数据的创建和维护信息系统的方法。因为信息工程是面向数据的，所以当你开始理解数据库是怎样被标识和定义时，信息工程的一种简洁的解释是非常有帮助的。信息工程遵循自顶向下规划的方法，其中，特定的信息系统从对信息需求的广泛理解中推导出来（例如，我们需要关于顾客、产品、供应商、销售员和加工中心的数据），而不是合并许多详尽的信息请求（如一个订单输入屏幕或按照地域报告的销售汇总）。自顶向下规划可使开发人员更全面地规划信息系统，提供一种考虑系统组件集成的方法，增进对信息系统与业务目标的关系的理解，加深对信息系统在整个组织中的影响的理解。 信息工程包括四个步骤:规划、分析、设计和实现。信息工程的规划阶段产生信息系统体系结构，包括企业数据模型。 1.3 信息系统规划 信息系统规划的目标是使信息技术与组织的业务策略紧密结合，这种结合对于从信息系统和技术的投资中获取最大利益是非常重要的。正如表1所描述的那样，信息工程方法的规划阶段包括3个步骤，我们在后续的3个小节中讨论它们。 1.确定关键性的规划因素

数据库外文参考文献及翻译.

数据库外文参考文献及翻译 数据库外文参考文献及翻译数据库管理系统——实施数据完整性一个数据库，只有用户对它特别有信心的时候。这就是为什么服务器必须实施数据完整性规则和商业政策的原因。执行SQL Server的数据完整性的数据库本身，保证了复杂的业务政策得以遵循，以及强制性数据元素之间的关系得到遵守。因为SQL Server的客户机/服务器体系结构允许你使用各种不同的前端应用程序去操纵和从服务器上呈现同样的数据，这把一切必要的完整性约束，安全权限，业务规则编码成每个应用，是非常繁琐的。如果企业的所有政策都在前端应用程序中被编码，那么各种应用程序都将随着每一次业务的政策的改变而改变。即使您试图把业务规则编码为每个客户端应用程序，其应用程序失常的危险性也将依然存在。大多数应用程序都是不能完全信任的，只有当服务器可以作为最后仲裁者，并且服务器不能为一个很差的书面或恶意程序去破坏其完整性而提供一个后门。SQL Server使用了先进的数据完整性功能，如存储过程，声明引用完整性（DRI），数据类型，限制，规则，默认和触发器来执行数据的完整性。所有这些功能在数据库里都有各自的用途;通过这些完整性功能的结合，可以实现您的数据库的灵活性和易于管理，而且还安全。声明数据完整性声明数据完整原文请找腾讯3249114六,维-论'文.网 https://www.sodocs.net/doc/4317818600.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的值不做任何改变。以下两种方法可

企业人力资源管理系统分析与设计 外文翻译

Enterprise Human Resources Management System Design And Implementation Abstract: Human resource management system is the core content of modern enterprise management. With the rapid development of the computer information technology and unprecedented prevalence of electronic commerce mode，the competition between enterprises is turning from visible economic markets to the network. Developing the human resource management system supported by computer technology，network technology and information technology can not only improve the skill of human resource management and the efficiency of the enterprises but also make human resource management modern and decision sciencefic,Modern human resource management uses B/S mode to avoid C/S modes short coming of difficult in maintdning and reusing.According to the functional requirements of the actual project,this article specificly state the analysis of system,the general desigin of the system,the detail design of system and the practice of the system. The development of the system is the practice of MVC design ideas, maing using the Jsp+Servlet+JavaBean form of development.Jsp is the practice of MVC design ideas’view,in charge of receiving/responding the request of the customer.Servlet mainly responsible for the core business control of the whole system is the practice of the vontroller of MVC design idea to take charge of the statistics and rules of the whole system. In the practice of the system, somr open-source projrcts,such as the Ajax technique,JfreChart statements,fileupload technology,has been used. Using the modern human resource management theropy and analysising the actual situation, comparing the current situation of human resource management system, a huaman resource contents of management system basied on the Internet/Intranet has been designed. The main management,attendance management training more efficient statistics. Keywords:human resource management; B/S mode; Open-source projects; MVC mode. 摘要 人力资源管理系统是现代企业管理的核心内容。随着计算机信息技术的高速发展，电子商务模式的空前盛行，企业之间的竞争也从有形的经济市场转向了网络。开发以计算机技术、网络技术、信息技术支持的现代人力资源管理系统，既能提高企业人力资源管理的技术含量和企业的办事效率，也能使人力资源管理能够进入现代化、决策科学化的进程。现代人力资源管理系统采用了B/S模式，可以避免C/S模式的重用性差、维护难度高的缺点和

外文文献翻译 An Introduction to Database Management System

英文翻译 数据库管理系统的介绍 Raghu Ramakrishnan 数据库（database,有时被拼作data base）又称为电子数据库，是专门组织起来的一组数据或信息，其目的是为了便于计算机快速查询及检索。数据库的结构是专门设计的，在各种数据处理操作命令的支持下，可以简化数据的存储、检索、修改和删除。数据库可以存储在磁盘、磁带、光盘或其他辅助存储设备上。 数据库由一个或一套文件组成，其中的信息可以分解为记录，每一条记录又包含一个或多个字段（或称为域）。字段是数据存取的基本单位。数据库用于描述实体，其中的一个字段通常表示与实体的某一属性相关的信息。通过关键字以及各种分类（排序）命令，用户可以对多条记录的字段进行查询，重新整理，分组或选择，以实体对某一类数据的检索，也可以生成报表。 所有数据库（除最简单的）中都有复杂的数据关系及其链接。处理与创建，访问以及维护数据库记录有关的复杂任务的系统软件包叫做数据库管理系统（DBMS）。DBMS软件包中的程序在数据库与其用户间建立接口。（这些用户可以是应用程序员，管理员及其他需要信息的人员和各种操作系统程序）DBMS可组织、处理和表示从数据库中选出的数据元。该功能使决策者能搜索、探查和查询数据库的内容，从而对正规报告中没有的，不再出现的且无法预料的问题做出回答。这些问题最初可能是模糊的并且（或者）是定义不恰当的，但是人们可以浏览数据库直到获得所需的信息。简言之，DBMS将“管理”存储的数据项和从公共数据库中汇集所需的数据项用以回答非程序员的询问。 DBMS由3个主要部分组成：（1）存储子系统，用来存储和检索文件中的数据；（2）建模和操作子系统，提供组织数据以及添加、删除、维护、更新数据的方法；（3）用户和DBMS之间的接口。在提高数据库管理系统的价值和有效性方面正在展现以下一些重要发展趋势： 1.管理人员需要最新的信息以做出有效的决策。 2.客户需要越来越复杂的信息服务以及更多的有关其订单，发票和账号的当前信息。

信息系统和数据库中英文对照外文翻译文献

中英文对照翻译 信息系统开发和数据库开发 在许多组织中，数据库开发是从企业数据建模开始的，企业数据建模确定了组织数据库的范围和一般内容。这一步骤通常发生在一个组织进行信息系统规划的过程中，它的目的是为组织数据创建一个整体的描述或解释，而不是设计一个特定的数据库。一个特定的数据库为一个或多个信息系统提供数据，而企业数据模型（可能包含许多数据库）描述了由组织维护的数据的范围。在企业数据建模时，你审查当前的系统，分析需要支持的业务领域的本质，描述需要进一步抽象的数据，并且规划一个或多个数据库开发项目。图1显示松谷家具公司的企业数据模型的一个部分。 1.1 信息系统体系结构 如图1所示，高级的数据模型仅仅是总体信息系统体系结构(ISA)一个部分或一个组织信息系统的蓝图。在信息系统规划期间，你可以建立一个企业数据模型作为整个信息系统体系结构的一部分。根据Zachman(1987)、Sowa和Zachman （1992）的观点，一个信息系统体系结构由以下6个关键部分组成: 数据（如图1所示，但是也有其他的表示方法）。 操纵数据的处理（着系可以用数据流图、带方法的对象模型或者其他符号表示）。 网络，它在组织内并在组织与它的主要业务伙伴之间传输数据（它可以通过网络连接和拓扑图来显示）。 人，人执行处理并且是数据和信息的来源和接收者（人在过程模型中显示为数据的发送者和接收者）。 执行过程的事件和时间点（它们可以用状态转换图和其他的方式来显示）。 事件的原因和数据处理的规则（经常以文本形式显示，但是也存在一些用于规划的图表工具，如决策表）。 1.2 信息工程 信息系统的规划者按照信息系统规划的特定方法开发出信息系统的体系结构。信息工程是一种正式的和流行的方法。信息工程是一种面向数据的创建和维护信息系统的方法。因为信息工程是面向数据的，所以当你开始理解数据库是怎样被标识和定义时，信息工程的一种简洁的解释是非常有帮助的。信息工程遵循自顶向下规划的方法，其中，特定的信息系统从对信息需求的广泛理解中推导出来（例如，我们需要关于顾客、产品、供应商、销售员和加工中心的数据），而不是合并许多详尽的信息请求（如一个订单输入屏幕或按照地域报告的销售汇总）。自顶向下规划可使开发人员更全面地规划信息系统，提供一种考虑系统组件集成的方法，增进对信息系统与业务目标的关系的理解，加深对信息系统在整个组织中的影响的理解。 信息工程包括四个步骤:规划、分析、设计和实现。信息工程的规划阶段产

餐饮管理系统外文翻译文献

餐饮管理系统外文翻译文献(文档含中英文对照即英文原文和中文翻译) 英文： 1、China food industry development prospects analysis The catering industry in China as the tertiary industry is a traditional service industries, experienced reforming and opening starts, quantitative expansion, scale chain development and brand promotion strategy of 4phase, made make a spurt of progress in the development of. At present, the country has4 millions catering outlets. 2005/2006annual Chinese top 100 catering enterprises with total assets of about thirty-two billion yuan, total profit of about six billion yuan, employees about eight hundred thousand people, respectively, over the same period last year increased40.38%,28.84% and33.33% higher than that of the whole society, the catering industry average growth level. China's reform and opening up has gone through ups and downs in the30year, in the30 years of reforming and opening of China's catering industry along with the tide of reform has undergone three leap type development. In the past 30 years, China has experienced from fast food restaurants grabs beach China market to SARS impact, then to food safety ( tonyred event, apple events ), Chinese food and beverage industry in the impact, achieve sales growth.

大数据外文翻译参考文献综述

大数据外文翻译参考文献综述 (文档含中英文对照即英文原文和中文翻译) 原文： Data Mining and Data Publishing Data mining is the extraction of vast interesting patterns or knowledge from huge amount of data. The initial idea of privacy-preserving data mining PPDM was to extend traditional data mining techniques to work with the data modified to mask sensitive information. The key issues were how to modify the data and how to recover the data mining result from the modified data. Privacy-preserving data mining considers the problem of running data mining algorithms on confidential data that is not supposed to be revealed even to the party

running the algorithm. In contrast, privacy-preserving data publishing (PPDP) may not necessarily be tied to a specific data mining task, and the data mining task may be unknown at the time of data publishing. PPDP studies how to transform raw data into a version that is immunized against privacy attacks but that still supports effective data mining tasks. Privacy-preserving for both data mining (PPDM) and data publishing (PPDP) has become increasingly popular because it allows sharing of privacy sensitive data for analysis purposes. One well studied approach is the k-anonymity model [1] which in turn led to other models such as confidence bounding, l-diversity, t-closeness, (α,k)-anonymity, etc. In particular, all known mechanisms try to minimize information loss and such an attempt provides a loophole for attacks. The aim of this paper is to present a survey for most of the common attacks techniques for anonymization-based PPDM & PPDP and explain their effects on Data Privacy. Although data mining is potentially useful, many data holders are reluctant to provide their data for data mining for the fear of violating individual privacy. In recent years, study has been made to ensure that the sensitive information of individuals cannot be identified easily. Anonymity Models, k-anonymization techniques have been the focus of intense research in the last few years. In order to ensure anonymization of data while at the same time minimizing the information

数据库中英文对照外文翻译文献

中英文对照外文翻译 Database Management Systems A database (sometimes spelled data base) is also called an electronic database , referring to any collection of data, or information, that is specially organized for rapid search and retrieval by a computer. Databases are structured to facilitate the storage, retrieval , modification, and deletion of data in conjunction with various data-processing operations .Databases can be stored on magnetic disk or tape, optical disk, or some other secondary storage device. A database consists of a file or a set of files. The information in these files may be broken down into records, each of which consists of one or more fields. Fields are the basic units of data storage , and each field typically contains information pertaining to one aspect or attribute of the entity described by the database . Using keywords and various sorting commands, users can rapidly search , rearrange, group, and select the fields in many records to retrieve or create reports on particular aggregate of data. Complex data relationships and linkages may be found in all but the simplest databases .The system software package that handles the difficult tasks associated with creating ,accessing, and maintaining database records is called a database management system(DBMS).The programs in a DBMS package establish an interface between the database itself and the users of the database.. (These users may be applications programmers, managers and others with information needs, and various OS programs.) A DBMS can organize, process, and present selected data elements form the database. This capability enables decision makers to search, probe, and query database contents in order to extract answers to nonrecurring and unplanned questions that aren’t available in regular reports. These questions might initially be vague and/or poorly defined ,but people can “browse” through the database until they have the needed information. In short, the DBMS will “manage” the stored data items and assemble the needed items from the common database in response to the queries of those who aren’t programmers. A database management system (DBMS) is composed of three major parts:(1)a storage subsystem