22-06-2012, 12:19 PM
CONVERSION FROM XML TO SQL AND FROM SQL TO XML
Abstract
The purpose of this project is to produce a tool that can generate relational tables in Structured Query Language (SQL) from a given model in Extensible Markup Language (XML) Metadata Interchange (XMI). Database design using modeling techniques is complicated by the time and effort it takes to convert from a given database model to its relational tables. To address problem, a tool called XMI2SQL will be developed. As its input format, an XML format called XMI will be used. XMI is the standard data interchange representation for models in Unified Modeling Language (UML). As its output format, XMI2SQL will employ SQL, which is the de facto standard for data definition.
FEASIBILITY STUDY
The feasibility of the project is analyzed in this phase and business proposal is put forth with a very general plan for the project and some cost estimates. During system analysis the feasibility study of the proposed system is to be carried out. This is to ensure that the proposed system is not a burden to the company. For feasibility analysis, some understanding of the major requirements for the system is essential.
ECONOMICAL FEASIBILITY
This study is carried out to check the economic impact that the system will have on the organization. The amount of fund that the company can pour into the research and development of the system is limited. The expenditures must be justified. Thus the developed system as well within the budget and this was achieved because most of the technologies used are freely available. Only the customized products had to be purchased.
About Servlets
Servlets provide a Java-based solution used to address the problems currently associated with doing server-side programming, including inextensible scripting solutions, platform-specific APIs, and incomplete interfaces.Servlets are objects that conform to a specific interface that can be plugged into a Java-based server. Servlets are to the server-side what applets are to the client-side - object byte codes that can be dynamically loaded off the net. They differ from applets in that they are faceless objects (without graphics or a GUI component). They serve as platform independent, dynamically loadable, plugable helper byte code objects on the server side that can be used to dynamically extend server-side functionality.
Hyper Text Markup Language
Hypertext Markup Language (HTML), the languages of the World Wide Web (WWW), allows users to produces Web pages that include text, graphics and pointer to other Web pages (Hyperlinks).
HTML is not a programming language but it is an application of ISO Standard 8879, SGML (Standard Generalized Markup Language), but specialized to hypertext and adapted to the Web. The idea behind Hypertext is that instead of reading text in rigid linear structure, we can easily jump from one point to another point. We can navigate through the information based on our interest and preference. A markup language is simply a series of elements, each delimited with special characters that define how text or other items enclosed within the elements should be displayed. Hyperlinks are underlined or emphasized works that load to other documents or some portions of the same document.HTML can be used to display any type of document on the host computer, which can be geographically at a different location. It is a versatile language and can be used on any platform or desktop.
CONCLUSION:
The purpose of this project is to produce a tool that can generate relational tables in Structured Query Language (SQL) from a given model in Extensible Markup Language (XML) Metadata Interchange (XMI).
To address problem, a tool called XMI2SQL will be developed. As its input format, an XML format called XMI will be used. XMI is the standard data interchange representation for models in Unified Modeling Language (UML).