XML vs JSON {Comments Off on XML vs JSON}

by Claudia J
The article that I read about was a peer review article called “Improving Data transmission in Web applications via the Translation between XML and JSON.” The article talks about the analysis of the form of two data serializing approaches used in the development of web applications using XML and JSON. The author remarks that both XML and JSON are used widely because of their high efficiency in transmitting data but still they cause certain application development problems. read more...

A Vulnerability in Microsoft XML {3}

by Sam T
This article discusses about a flaw in Microsoft XML that can allow attackers to gain access to a system. The vulnerability is known to all versions of Microsoft OS, and other popular supported programs such as Microsoft Office 2003 and 2007. This vulnerability can be exploited just by simply loading a malicious web page but most users have been taught not to click on any suspicious links. One way attackers are getting around this is to take over a well known site that many users are already going to. Experts say one European Medical Site was hijacked and implanted with a corrupted code, exploiting the XML flaw. Although Microsoft gave advice on how to reduce the risk of the flaw, Microsoft has not released an update to cover this exploit. The author goes on and discusses how to protect yourself such as making sure your security software is up to date with it’s definitions and also to use the Fix-it tool from Microsoft which will implement measures to block the site the vulnerability is at. read more...

Dealing with Heterogeneous Database Environments {Comments Off on Dealing with Heterogeneous Database Environments}

by Katheryn T
I read an article about how to retain data integrity and the structure of a database with heterogeneous data. Heterogeneous data is data that comes from various sources with many different formats. This is a problem because SQL databases are relational and use a table system to organize data with very similar formats. For a solution, the article states that using HTTP over XML can help maintain the structure of a database better. The first step is to send the query to a SQL query capture and transfer module. The next step is to send that query to the target database system. While all the queries are being processed, there is a time stamp on all of them to ensure they are processed correctly. The last step is to receive and process the query. The request is then labeled “received” and is filed. Time stamps are very important because the queries need to be executed sequentially. In the second step, there is an error handling process. Some requests may be in DML or DDL and some may be MS SQL or Oracle. There are procedures for handling these issues. In one case, there is no discrepancies and the query is processed. In another case, there are substitutes for adapting data. The last case is that there is no alternative. read more...

BioGRID Updates Database {2}

by Alexander H
The Biological General Repository for Interaction Datasets (BioGRID) offers a public database of information that breaks down genetic and protein findings from humans and organisms.  After the recent update, a total of over 500,000 genetic and protein interactions complete the database.  The recent update has brought enhancements to their web interface and allows for rapid queries across multiple data types and sources.  The database is designed to forward engineer advancements in any applicable area of science and share information across the platform.  In addition, the entire data collection of the database can be downloaded in multiple file formats to be used for any purpose. read more...

Uses of DBs in Space! {4}

by Kaushal S
This journal is about James Webb Space Telescope (JWST) and how it uses database out in space. JWST is an infrared-optimized space telescope designed to study stars and galaxies. This journal also talks about how their concept uses Extensible Markup language (XML) to communicate with the database. By using XML it allows the freedom for JWST to work independently from its ground system counterparts and still be compatible with the structure. JWST database works simultaneously with 24 different labs which are regionally spread across nation and are equipped with XML structured databases. XML allows changing of information between databases and makes the process very easy to perform without affecting other systems on the ground. National Aeronautics and Space Administration (NASA) has considered this route in better assisting their projects which meets 90% of their needs compared to other “Commercial-off-the-shelf (COTS)” and also it has helped cut down cost in that department. read more...

More efficient XML for mobile devices {Comments Off on More efficient XML for mobile devices}

by Ricardo C
The number of mobile devices have increased in the last decade, and at this rate it is inevitable that this is the future of computing. However there are constraints that hinder the deployment, especially the limited communication bandwidth and storage space available. Since mobile devices do not have the computing power to run complex business applications typically thin online client-server applications are used to solve this barrier; however, XML is used which compromise bandwidth since XML is often for data exchange. Compressing XML files appears to be a promising solution since compressed files require less bandwidth and storage resources. One of the approaches to fix this problem would be what this article describes as Efficient XML Data Exchange Manager (EXEM) that combines context-dependent lossy and lossless compression mechanism used to support lightweight  exchange of objects in XML format between server and client applications. The main contribution of the EXEM approach is that it provides improved efficiency for XML data exchange through a semantic reduction of the XML content transferred between servers and clients. The reduction of data transfers is achieved by using known information about the application on the client side. read more...

AJAX Web Attacks, Futility of Anti-Virus {1}

by Vincent S
AJAX is an acronym for Asynchronous Javascript and XML.  It is a technology meant to combine various other web development technologies such as HTML and CSS in order to give greater options to developers.  This week in class, we introduced the concepts of Javascript and AJAX and are implementing them in project 2.  For that reason, I decided to report on an article this week I found in PCWorld magazine warning of the dangers associated with AJAX websites.  Like with most technologies, hackers have found ways to inject AJAX with malicious code in order to exploit backdoor vulnerabilities.  In recent cases, security experts have discovered a server in China that injects normal websites that contain AJAX code with malicious javascript code.  The point in performing the attack in this manner is so the malicious code will be disguised with typical AJAX code found on any website containing AJAX.  In attempts to further hide the malicious code, the AJAX attack disrupts the workload of a host PC as it interacts with scripts in the website.  Malicious Code is segmented into pieces and is reassembled before being executed by the client. read more...

XML’s History {5}

by Antonio M
I found this article to be very informative on the history of eXtensible Markup Language (XML)
and its purpose and function to the World Wide Web. XML has served as an essential part of the
World Wide Web because of its capability to effectively transform and exchange data. XML can
allow people to create, manage, and process data as well as share information in a meaningful
manner. Prior to XMLs existence the World Wide Web was built to support HTML but because HTML
can mix textual data with presentation it would not be convenient to transmit data using HTML
on a variety of devices.It was Jon Bosak who realized this inconvenience and he therefore
drafted the standard for XML in 1996. XML’s focused specifically in structured data which could
then be parsed and exchanged by various clients. Bosak required that XML allow users to specify
their own attributes in order to qualify there data. XML also allows for applications to check
the data being used in XML for “structural validity on importation.” The author concludes his
article by stating that XML has proven to manage structured data on the World Wide Web and is
very flexible, extensible and has a sound hierarchical structure making XML very popular. XML
continues to remain an important in application and will play a large role in the World Wide Web. read more...

Using XQuery to Retrieve Data {3}

by Penny P
XML is widely used in the web because it could be used to store all types of data. XQuery has become a language used to perform XML queries as it has the ability process XML data. Before the queries can happen, an XQuery Implementation needs to be applied. The XQuery Implementation must meet the following requirements: 1) be based on the XQuery standard, 2) be capable of access web requests, and 3) be able to write XML documents as webpages. The result of XQuery Implementation creates XHTML documents. Before it could be used to perform web searches, two more steps are needed: 1) build an application environment in a web server so it could execute the XQuery scripts and 2) process and answer the requests that are being made. read more...

How to apply Database Tech based on XML {Comments Off on How to apply Database Tech based on XML}

by Davina V
This article shows an example of an application of Database Technology based on XML used for nuclear fuel calculation. Originally the nuclear fuel calculation software was based on the “ancient” FORTRAN language. It compares the old file system with the database system which gives it a few advantages. Such as Data sharing and low redundancy. Then introduces XML’s Characteristics and the Document’s applications. The article talks about the technique used to implement such a program. And the Authors conclude that XML databases based on  can make full use of existing relational database resources and has the upper-hand of free exchange of data. read more...