Need help with this Ilab for devry class DBM 449.attached is the document.

 ATTACHMENT PREVIEW Download attachmentLaboratory ProceduresDeVry UniversityCollege of Engineering and Information SciencesI.OBJECTIVES1.Understand and become familiar with current capabilities and limitations of the OpenGISimplementation in MySQL.2.Learn to create, update, and use spatial indices.3.Explore practical approaches to calculating distances between points on the Earth’s surface.4.Understand fundamentals of geotagging.5.Create stored procedures to determine real-world distances, and to process spatial queriesreturning result sets of data points within a bounding rectangle.6.Explore visualization of GIS data.II.PARTS LIST1.EDUPE-APP Omnymbus MySQL Environment (https://devry.edupe.net:8300/) and/or:2.MySQL (dev.mysql.com/downloads)III.PROCEDUREThe argument could be made that Business Intelligence (BI) and Data Analytics revolutionizedOnline Analytical Processing (OLAP) by making it simple for users to traverse, examine, andvisualize different aggregations of data over the dimension of time. Geographic InformationSystems, once an arcane, rare, expensive, and highly specialized type of information system,have brought about a similar revolution using the spatial dimension. As these systems havebecome affordable and entered the mainstream—indeed, they are now ubiquitous—they havealso become mainstream; or perhaps it would be more accurate to say that mainstream DBMSsystems have come to commonly adopt and integrate the specialized data structures andalgorithms required to implement spatially enabled, data-driven systems at will.In this laboratory exercise, you will create a GIS-enabled database by implementing a spatiallyindexed table, populating it with spatially encoded data, and creating stored procedures toprovide augmented functionality to determine distances between points, and to process queriesreturning results containing points within spatially defined boundaries. Finally, you will learn toexpress and explore spatial data in its most natural and intuitive form: visually displayed as mapsand plots.This lab may be completed using MySQL running on either your own computer, or the DeVryiLab. In either case, it is presumed that you will begin the initial lab step AFTER addressing anynecessary routine housekeeping chores, such as creating an appropriate schema (e.g.,DBM449LAB2), and creating any necessary user accounts, permissions, and so on.

View the AnswerNote:At the time this lab was written, the full OPENGIS standard was not implemented in thecurrent production release of MySQL, but new features were being added with each point releaseof MySQL. It is entirely possible—in fact, quite likely—that improved OPENGIS compliance,including functions for distance calculation for spherical projections (e.g., points on the Earth’ssurface) and circular proximities (e.g., “within radius of”) will become built-in to the MySQLdatabase. However, as the study of the underlying mathematical and topographical principlesneeded to implement non-planar distance calculations, and for determining envelope or boundingbox point results are a very worthwhile study, you should implement your own stored proceduresfor these functions, rather than substituting any built-in capabilities that become available. Youmay, however, repeat steps using such features as available, in order to compare and study thesimilarities and differences between your calculation methods and those later implemented aspart of the OPENGIS API.Important Further Note:At the time of this writing, spatial indices are supported ONLY in theMyISAM storage engine, and not in the InnoDB or other storage engines. BE SURE TOCREATE YOUR DATABASE TABLE FOR THIS LAB USING THE MyISAM STORAGEENGINE!Designing a Spatially-enabled Table, and Creating a Spatial Index1.Create the table indicated in the following ERD.Figure 12.Be sure you have first addressed the assigned research for this week’s unit involvingSpatial Indices, and then use the following DDL to create a spatial index on the table justcreated:CREATE SPATIAL INDEX `location` ON `Points` (`location` ASC);3.Paste the complete SQL Data Definition Language (DDL) you used to create this tableand index into your lab report.4.Choose a point of interest (e.g., your house, your local DeVry campus, etc.), and at leastthree additional points within 20 miles, and three additional points more than 40 milesfrom the first point. For example, I chose my house, and three favorite restaurants intown, and three favorite restaurants in a distant town where I used to live. Using GoogleMaps or other service capable of converting street addresses to geographical (longitude

Sho

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"