Thursday, July 10, 2008

As i see it 006

Differentiate all basic data models and alternative data models:

1).Hierarchical Models-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. The most recognized example of hierarchical model database is an IMS designed by IBM.
2.)Network Model-is a data modelsconceived as a flexible way of representing objects and their relationships. Its original inventor was charles,Becham and it was developed into a standard specification published in 1969 by the CODASYL Consortium. Where the hiererchical model structures data as a tree of records, with each record having one parent record and many children, the network model allows each record to have multiple parent and child records, forming a lattice structure.

The chief argument in favour of the network model, in comparison to the hierarchic model, was that it allowed a more natural modeling of relationships between entities. Although the model was widely implemented and used, it failed to become dominant for two main reasons. Firstly, IBM chose to stick to the hierarchical model with semi-network extensions in their established products such asnd DL/I. Secondly, it was eventually displaced by relational model the which offered a higher-level, more declarative interface. Until the early 1980s the performance benefits of the low-level navigational interfaces offered by hierarchical and network databases were persuasive for many large-scale applications, but as hardware became faster, the extra productivity and flexibility of the relational model led to the gradual obsolescence of the network model in corporate enterprise usage.

3.)Relational Models-is the easiest models to use and understand. Instead of creating files,records,owners,members,parents,or children, you create a table containing rows and columns.You design each table to eliminate redundancy and link them toghether using foreign keys.

4.)Entity-relationship model-is an abstract conceptual representation of structured data. Entity-relationship modeling is a relational schema database modeling method, used in software engineering to produce a type of conceptual data model (or semantic data model) of a system, often a relational database, and its requirements in a top-down fashion. Diagrams created using this process are called entity-relationship diagrams, or ER diagrams or ERDs for short. Originally proposed in 1976 by Dr. Pin-Shan (Peter) Chen (陳品山), many variants of the process have subsequently been devised.

5.)Object-relational Model-similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, it supports extension of the data model with custom data-types and methods.

One aim for this type of system is to bridge the gap between conceptual data modeling techniques such as Entity-relationship diagram (ERD) and object-relational mapping (ORM), which often use classes and inheritance, and relational databases, which do not directly support them.

Thursday, July 3, 2008

As i see it 005

♦Identify at least 10 BDMS software with their corresponding developer.

10 BDMS Software - Developers

1.) Jet Database Engine- Microsoft
2.) SQL Server - Microsoft
3.) Visual FoxPro - Microsoft
4.) IBM DB2 Express-C - IBM
5.) Virtuoso Universal Server - OpenLink Software
6.) FileMaker - Nashoba Systems of Concord
7.) Firebird - InterBase/Firebird product line
8.) SQL Server Express - Microsoft
9.) Access - Microsoft
10.) Dataphor - Alphora,

Visual FoxPro



Visual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro (originally known as FoxBASE) which was developed by Fox Software beginning in 1984. Fox Technologies merged with Microsoft in 1992, after which the software acquired further features and the prefix "Visual". The last version of FoxPro (2.6) worked under Mac OS, DOS, Windows, and Unix: Visual FoxPro 3.0, the first "Visual" version, dropped the platform support to only Mac and Windows, and later versions were Windows-only. The current version of Visual FoxPro is COM-based and Microsoft has stated that they do not intend to create a Microsoft .NET version.

FoxPro originated as a member of the class of languages commonly referred to as "xBase" languages, which have syntax based on the dBase programming language. Other members of the xBase language family include Clipper and Recital. (A history of the early years of xBase can be found in the dBASE entry.)

Visual FoxPro, commonly abbreviated as VFP, is tightly integrated with its own relational database engine, which extends FoxPro's xBase capabilities to support SQL query and data manipulation. Unlike most database management systems, Visual FoxPro is a full-featured, dynamic programming language that does not require the use of an additional general-purpose programming environment. It can be used to write not just traditional "fat client" applications, but also middleware and web applications.

As i see it 004

CORRELATE:
DATA WITH DATABASE
MANAGEMENT WITH SYSTEM

DATA with DATABASE:

Data is stored information in the computer created by a user.It is stored as files in the computer.
Database is a structured collection of datas or records.The relation between data and database is that when you store a data in the computer it will be called as database,because it is already structured as files.


MANAGEMENT with SYSTEM:

Management in simple terms is the act of getting together to accomplish desired goals.
System is a set of interacting or interdependent entities, real or abstract, forming an integrated whole.
The relation between management and system is when there is no management there is no system.In computers there is relationship between hardware and software,manages all devices,so thats what we called system.No management no system.