Sunday, July 6, 2008

CSC As I See it 005

10 DBMS Software with their Developer:

1) Easy Base (Company: Easy Software Ltd)

2) CompareData (Company: Zidsoft )

3) Visual SQL-Designer (Company: VisualSoft )

4) SQL Diagrams (Company: Skilled Software )

6) Job-Costing (Company: Easy Software Ltd )

7) Alventis (Company: Alventis Corporation )

8) Database Web Explorer (Company: Anatoly A. Sadovsky )

9) WebCab Delphi (Company: WebCab Components )

10) WebCab .NET (Company: WebCab Components )

SQL Diagrams- is a database computer languagedesigned for the retrieval and management of data in management systems (RDBMS), database schema creation and modification, and database object access control management.It is a standard interactive and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. The core of SQL is formed by a command language that allows the retrieval, insertion, updating, and deletion of data, and performing management and administrative functions. SQL also includes a Call Level Interface (SQL/CLI) for accessing and managing data and databases remotely.

DBMS has many objectives some of them are as follows.

  1. DBMS give multiuser access
  2. Give good security to database.
  3. Give full control to Data
  4. gives better hope of porting the code toother DBMS products. (good compatibility).
  5. Platform independent.
  6. Support online documentation
  7. Keep and maintain proper backups.
  8. concurrency control.
  9. crash recovery
  10. Complex query support

No comments: