Thursday, December 10, 2009

ASSIGN_02 current trends

1. SQL Azure with ASP Dot Net

SQL Azure (SSDS - SQL Server Data Services) is a cloud database system offered by Microsoft. We interact with the SQL Azure services by either issuing statements to it though a command prompt or developing Dot Net applications. This article will introduce and demonstrate development of SQL Azure ASP Dot Net applications.

2. IDMS
Automated Migration for the IDMS Database

The IDMS database life cycle is coming to the end. Many enterprises are making the decision to migrate their IDMS databases to relational ones: DB2, SQL Server or Oracle. Our database migration solution: a highly automated and efficient tool for IDMS conversion to the industry standard databases - DB2, SQL and Oracle. This solution gives you the benefits of automated migration, while allowing you to control the entire process.

Our solution is for IDMS running on z\OS, z\VSE and VME
Business Benefits

* Dramatically reduces license and maintenance costs
* Makes application enhancement easier
* Provides cost effective migration
* Eliminates the IT resources problem
* Uses proven automated tools, thereby mitigating many of the project risks
* Provides a complete solution for language, database, and platform modernization
* Utilizes BluePhoenix’s extensive experience with modernization projects (over 20 years)

Wednesday, November 18, 2009

ASSIGN_1

A hierarchical data model is a data model in which the data is organized into a tree-like structure. The structure allows repeating information using parent/child relationships: each parent can have many children but each child only has one parent. All attributes of a specific record are listed under an entity type.
In a database, an entity type is the equivalent of a table; each individual record is represented as a row and an attribute as a column. Entity types are related to each other using 1: N mapping, also known as one-to-many relationships.

A relational database matches data by using common characteristics found within the data set. The resulting groups of data are organized and are much easier for people to understand.
For example, a data set containing all the real-estate transactions in a town can be grouped by the year the transaction occurred; or it can be grouped by the sale price of the transaction; or it can be grouped by the buyer's last name; and so on.
Such a grouping uses the relational model (a technical term for this is schema). Hence, such a database is called a "relational database."
The software used to do this grouping is called a relational database management system. The term "relational database" often refers to this type of software.