Database Management System
A DBMS is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications:
· computerized library systems
· automated teller machines
· flight reservation systems
SQL: Sql stands for Structured Query Language. It helps you access and manipulate databases. It is an ANSI standard. Its scope includes data delete, update, insert, retrieve, create new databases, create new tables in databases, set permission on tables, procedures and views etc.
Ms-Sql: Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an environment used to generate databases that can be accessed from workstations, the Internet, or other media such as a personal digital assistant (PDA).
Ms-Access: Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access can help you overcome the limitations found when trying to manage large amounts of information in Microsoft Excel or other spreadsheet applications. It even provides the benefit of performing Sql queries on the databases just by few clicks as it is already embedded in the Ms- Access.
My-Sql: My-SQL is the world's most popular open source database software because of its fast performance, high reliability, ease of use, and dramatic cost savings. My-SQL is a key part of LAMP (Linux, Apache, My-SQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.
Oracle: The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation. Oracle is very advanced database, it comes with its own programming language called PL-SQL and also a lot of sophisticated features.
Sybase: Sybase also offer a RDBMS (Relational Database Management System) for Windows, UNIX and Linux. Sybase Company is currently acquired by SAP.
Visual FoxPro: Visual FoxPro 9.0 provides the tools you need to create and manage high-performance, 32-bit database applications and components.Visual FoxPro is a data-centric, object-oriented and procedural programming language produced by Microsoft. 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.