Sun Blueprint Adventure Builder Database design __ Database

Sun Blueprint Adventure Builder Database design

Catalogue

1 preface .... 1

1.1 Background ... 1

1.2 Writing motivation and style ... 2

1.3 Selection of database design methods ... 2

1.4 who is suitable to read this article. ... 2

1.5 Terminology and abbreviations ... 2

2 Adventure Builder Introduction .... 3

3 Adventure Builder Conceptual structure design .... 4

3.1 Adventure Builder Entities (entity) ... 4

3.2 Adventure Builder e-r model ... 4

3.3 Overall E-r model ... 5

4 Adventure builder Logical Structure design .... 5

4.1 Determining the table structure ... 6

4.2 Data structure Diagram ... 6

Some characteristics of the 4.3 property ... 6

5 Adventure Builder Database implementation .... 7

5.1 Defining the database and table structure ... 7

6 Summary .... 7

7 sentiment and future prospects .... 7

8 acknowledgements .... 7

9 Reference Resources .... 8

Revision History

Author	Contact	Change Time	Version	Description
Lanning	Thunder4393@gmail.com	2005-9-27	1.0	This is the original version.

1 Preface 1.1 Background

Java Adventure Builder Reference application is an example of a sun company EE application that shows how to design interactive and lightweight Web services on the Java EE 1.4 platform. He also demonstrated the effective use of the Java EE technology, including Jax-RPC, JAXP, Servlet 2.4, JSP 2.0, JSTL, EJB, and DB. The Adventure Builder database is part of the Pointbase database or MySQL database. Readers can choose one of the databases themselves.

1.1 Writing motivation and style

Sun did not provide the database related to the design structure of the article, and there is no online analysis of this article, this is my intention to write this article. This article is an analysis and design of the Blueprints Adventure Builder database section provided by Sun, based on version 1.0.3. This article is my original version, this article focuses on analysis and design, a large number of use of the chart, which is the innovation of this article, through the analysis will step by step to get the necessary table.

Adventure Builder Introduction Part of the Sun's architecture article I used the original text, I feel that translation is easy to lose its original intention, another reason I think that the English improvement also has a great help, now the general large point of the company are English materials, English mail, English communication, Comrades, English is a prerequisite.

1.1 Selection of database design methods

Because of the different ways of database design, there are differences in the partitioning of database design steps. The database analysis method used in this paper is the New Orleans method, which divides the database design into 4 stages: requirement analysis, conceptual structure design, logical structure design and physical structure design.

1.1 who is suitable to read this article.

Since this article is primarily an analysis of the Adventure Builder Database section, it is suitable for the following people to read:

(1) programmer who is analyzing adventure Builder source code.

(2) Database designers who are analyzing and designing their own project database applications.

(3) An elementary database developer who wants to learn how to analyze and design databases.

1.1 Terminology and abbreviations

The constituent elements of E-R model are: Entity, attribute, relation, e-r model is represented by E-r graph.

1. Entity: The thing that is involved in the user's working environment. It is equivalent to an entity set, a table, represented by a rectangle:

2. Attribute: is a description of the characteristics of the entity. Is the nature of the entity. Represented by an ellipse, connected with a line between the entities.