AMOS II对象关系数据库实验报告.docVIP

AMOS II对象关系数据库实验报告 实验目的 学习现代数据库系统的基本概念、原理。基于对象关系型DBMS：AMOSII，完成对象关系型数据库的基本使用方法和开发应用程序的基本方法。 实验内容及要求 (1)学习基本的新一代数据库系统的概念，主要针对新一代对象关系数据库AMOS II。AMOS II是必威体育精装版的一代对象关系数据库，具有强大的面向对象的功能。它提供了众多的下一代数据库技术所应具有的特征和功能。我们将熟悉这一数据库，并注意AMOS II和传统的关系数据库各个方面的不同。 (2)熟悉实验环境 (3)熟悉AMOS II的操作，体会AMOS II提供的强大的功能。详细指导资料参见《第一部分》。 (4)熟悉图形界面的JavaAmos。JavaAmos是用Java编写的具有图形界面的Amos。将利用JavaAmos的可是化管理功能进行一系列操作。详细资料参见《第二部分》 (5)使用AMOS II提供的Java函数的接口。在AMOS II中调用用户自定义的Java函数。这样AMOS II具有强大的可扩充功能。 实验过程及结果 第一部分：《AMOS II实验指导》中所附作业。 1、How many spectators did the match :m1 have? select spectators(:m1); 2、What was the name of the referee in the match :m1? select name(refereed_by(:m1)); 3、Make a derived function ref_name(match)-charstring that, given a certain match, returns the name of the referee that refereed the match. Then use the derived function to answer query 2. create function ref_name(match m)-charstring n as select name(r) from referee r where refereed_by(m)=r; select ref_name(:m1); 4、Which years were World Cup tournaments played? select year(t) from tournament t; 5、A team is trained by a trainer. A trainer has a name and a salary. Create the types and functions needed to model this. Create a trainer object too. Store name and salary for the created trainer. Specify thereafter an AMOSQL command showing the name and salary for all trainers. create type trainer under person; create function salary(trainer)-real as stored; create trainer(name,salary) instances :t1 (hh,5600),:t2 (shirly,7800),:t3 (alfred,9900); select name(t),salary(t) from trainer t; 6、Who were the referees in the games where Tomas Brolin played? select name(refereed_by(m)) from match m where name(participating_players(m))=Tomas Brolin; 7、Create a derived function referees(charstring)-charstring that, given the name of a certain player, returns the names of the referees that refereed games where that player participated. Then use the derived function to answer query 6. create function referees(charstring pn)-c