NSF REU Research Prospectus

mobdescriptiveΛογισμικό & κατασκευή λογ/κού

28 Οκτ 2013 (πριν από 3 χρόνια και 9 μήνες)

56 εμφανίσεις





Department of
Computer Science

3
rd

Floor Math Building

Lakefront Campus

New Orleans, LA 70148

Telex 123 456 7890

Phone


Fax

(504) 280 6594

(504) 280 7228

NSF REU Research Prospectus

Geodatabase Web Manager










Mentors


Dr. Mahd
i Abdelguerfi

Fareed A Qaddoura

Student


Terrance M. Sanchez

Date

August 18, 2004




Introduction

Introduction


NSF REU Research Prospectus

Geodatabase Web Manager

Introduction

Data of spatial content is kept many times in relational databases. Relationa
l databases allow the
insertion or the linking of non
-
standard data types. For example, MS Access uses OLE (Object
Linking and embedding) and Long Binary Objects, and Oracle uses BLOB (Binary Large Objects)
to store non
-
standard data.


The main goal of th
is project is to allow the storage of spatial content data directly to the relational
database. This will eliminate the need to write scripts to export/import the data each time in a
custom fashion depending on the adapter/interface managing the spatial da
ta. In addition, the web
features of the Geodatabase Manager allow remote or mobile users to upload their data directly to
the online database virtually from anywhere. The only constraint that should be maintained in the
managed data is the data structures

and the data definitions.


The framework of the “Geodatabase web Manager” is flexible and allows the addition of many
other tasks as they are being developed to one centralized console.


























2

Project Goals

Project Goals

1


User Interfa
ce:

1)

To create a web based application that serves as the users Web Manager access point.

2)

To automatically load the user’s resources and accessible Oracle spatial database
instances and relational databases (Oracle and Access).

3)

To create a wizard to help th
e users in the process of uploading their data (spatial and non
spatial).

Database Tier / Web Server Tier:

1)

Validate the users input before upload.

2)

Upload users’ data.

3)

Populate the appropriate database and database tables.





















3

Methods

Methods

2


1)

Install Oracle.

2)

Create the SEC_USERS table for user authentication.

3)

Create the SEC_SREENS table for the web manager component.

4)

Create the JSP login.

5)

Create the JSP for the menu.

6)

Create a table and call it DATA_IMAGES. Users should be allowed to up
load their
images to Oracle and then download and preview them.

7)

Study all the changes that occur to a Geodatabase when adding a shape file or inserting a
new feature in an existing table.

8)

Install ArcGIS desktop and read the quick reference tutorials that c
ome with ArcGIS
installation.

9)

Based on the changes that occur in the Geodatabase when adding a shape file, create a
webpage that allows the insertion of a new shape file in a Geodatabase. The target
database is Oracle and MS Access. Use ESRI ArcGIS to ve
rify the insertion of the
shapefile.

10)

Based on the changes that occur in the Geodatabase when adding a new feature, create
a webpage that allows the insertion of new feature (point, line, and polygon).

11)

Use the same approach to allow the insertion of raster
data in the Geodatabase.

12)

Use ArcObjects/mapObjects to create a simple viewer to view the shapefiles, new
features added, and rasters.















4

Outcomes

Expected Outcomes

3


User Interface:

1)

To create a web based application that serves as the users We
b Manager access point.

2)

To automatically load the user’s resources and accessible Oracle spatial database
instances and relational databases (Oracle and Access).

3)

To create a wizard to help the users in the process of uploading their data (spatial and non
s
patial).

Database Tier / Web Server Tier:

4)

Validate the users input before upload.

5)

Upload users’ data.

6)

Populate the appropriate database and database tables.
































5

Timeframe

Timeframe

4


Jun. 28
-

Aug.

Accessing tutorials , read
ing and working examples in order to become
familiar with the various software and technology necessary to complete the
project. (JSP, Java Servlets, Oracle, MS Access, HTML, CSS, Tomcat,
ArcGIS desktop and ArcObjects/MapObjects) Presently, in the proc
ess of
installing Oracle, in order to create the SEC_USERS table for user
authentication, and create the SEC_SREENS table for the web manager
component. Create the JSP login and create the JSP for the menu.

Fall 2005

Store images to the database and displa
y them. Create a table and call it
DATA_IMAGES allowing users to upload their images to Oracle in order to
download and preview them.


Study all changes that occur to a Geodatabase when adding a shape file or
inserting a new feature in an existing table.

Install ArcGIS desktop and read the quick reference tutorials that come with
ArcGIS installation.

Based on the changes that occur in the Geodatabase when adding a
shapefile, create a webpage that allows the insertion of a new shape file in a
Geodatabase.

Use ESRI ArcGIS to verify the insertion of the shapefile.

Allow direct data upload to a target layer or shape file without going in the
DATA_IMAGES table.



Spring 2006

Based on the changes that occur in the Geodatabase when adding a new
feature, create a

webpage that allows the insertion of new features.


Use the same approach to allow the insertion of raster data in the
Geodatabase.


Use ArcObjects/MapObjects to create a simple viewer to view the shapefiles,
new features added, and rasters.


Testing and
Documentation.









6

Facilities

Facilities Required

5


Research and progress is to be carried out at the University of New Orleans Computer Center. Materials needed are
as follows:



Software and Technology


1)

Java Server pages

2)

Java Servlets

3)

Oracle

4)

MS Ac
cess

5)

HTML

6)

CSS

7)

Tomcat

8)

ArcGIS desktop

9)

ArcObjects/MapObjects

























7

Progress

Progress

6



The progress status is as follows:



Downloaded and studied JBuilder tutorial

Created Java Servlet using JBuilder 2005



Downloaded and studied Java tu
torial


Used Eclipse to create java and class files



Downloaded and studied Tomcat tutorial to set up servlets and html pages


Downloaded and studied CSS tutorial to use on web page



Created a web page using Notepad

Used Java to add password / login scr
ipt

Used CSS to enhance web page


Presently:

In the process of downloading Oracle9i, installing and learning the operation to create user tables, user
screens, create the JSP login and the JSP for the menu.




















8

References

References