INFORMATION MANAGEMENT 1

XML, JSON, AND AJAX By: Gonzales, Brian Gabriel E. What is XML? - Extensible Markup Language is known as XML. It is a markup language made specifically to convey and store structured data. In order to encode documents in a way that is both machine- and human-readable, XML requires a set of rules. Similar to HTML, XML stores data in a hierarchical format. However, XML is concentrated on describing the structure and substance of data, in contrast to HTML, which is largely used for displaying and formatting web content. It offers a method for creating unique tags and elements to represent data in a particular domain or application. Elements, attributes, and text content are all parts of an XML document. Start and end tags are used to enclose elements, and they are capable of having child elements. The start tag of an element contains the attributes that are used to describe the element in more detail. The data that is present in an element is represented by text content. Many different ap

SQL: Structured Query Language By: Gonzales, Brian Gabriel E. What is SQL? - Structured Query Language, or SQL (pronounced "ess-que-el"), is a query language. A database can be communicated with using SQL. It is the preferred language for relational database management systems, claims ANSI (the American National Standards Institute). To update data in a database or to get data from a database, SQL statements are employed. Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and other popular relational database management systems are only a few examples.     SQL Commands SELECT  - extracts data from a database UPDATE  - updates data in a database DELETE  - deletes data from a database INSERT INTO  - inserts new data into a database CREATE DATABASE  - creates a new database ALTER DATABASE  - modifies a database CREATE TABLE  - creates a new table ALTER TABLE  - modifies a table DROP TABLE  - deletes a table CREATE INDEX  - creates an index (search key) DROP INDEX  - deletes a