1 / 9

SQL Forms Engine

SQL Forms Engine. Koifman Eran Egri Ozi Supervisor: Ilana David. Context. Creating a system which will enable generic form creation. Embedding dynamic data into the generic forms. Allowing the forms to be saved and updated using a foreign and local database. Forms creation model.

urbana
Download Presentation

SQL Forms Engine

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Forms Engine Koifman Eran Egri Ozi Supervisor: Ilana David

  2. Context • Creating a system which will enable generic form creation. • Embedding dynamic data into the generic forms. • Allowing the forms to be saved and updated using a foreign and local database.

  3. Forms creation model. Not familiar with database schema. Developed independently. Receives data from the web service. Web service that will use HTTP get / set and SOAP. Generic SQL generation. Easy to use. Supports multi databases and servers. Two model concept

  4. The Problem • Querying foreign database with unknown schema. • Transporting query results through the web. • Translating plain English into standard SQL.

  5. Project Goals • Creating a mechanism that will let the user query data using plain English. • Creating a mechanism that will let the user insert data using plain English. • Creating a mechanism that will let the user update data using plain English. • Transporting the data to the user through the web in a generic form.

  6. Solution Overview • Create a web service that will convey the users requests to the foreign server. • Creating a base infrastructure which will provide a metadata for the service. • Creating an engine that will open connections to foreign servers based on the metadata. • Creating a module within the above engine that will translate the users request into the SQL query recognized by the foreign server using the metadata.

  7. Solution Overview • Implementing the user interface as a web service. • Sending the data back to the user using standard SOAP, HTTP get, HTTP put in order to create a generic system.

  8. Easy to use user interface. User defined names instead of foreign schema. English instead of SQL. Update method. Insert method. Select Method. All fields Method. Easy User Interface

  9. Future Development • Generic implementation enables generic form creation using “custom made queries”. • Creating a key generation feature to enable joins through databases. • Query results encryption. • Permission enabled queries.

More Related