data base management system
Data Base Management System Types of DBMS are Enterprise DBMS and Desktop DBMS. ... Designed for enterprises of all types, Oracle Database offers small and medium businesses fast, simple installation and extensive self-management. ... Business Intelligence Oracle Database enables you to simplify your business intelligence infrastructure by eliminating fragmented data sources with a consolidated data warehouse. ... Content Management You trust Oracle for your enterprise transaction processing and data warehousing applications. Why not manage all your valuable enterprise data with reliability and security? ... Manageability Oracle Database lowers the cost of management, with fast installation and a wide range of self-management capabilities 2- SQL : 3- Informix DataBase: IBM Informix® DataBlade® modules extend the database so that complex objects can now be stored in a relational database. ... Informix has different features that make it powerful and one of the famous database management systems around the world there are: • Excellent performance - A cost-based query optimizer combined with flexible indexing options allows Informix® SE to maintain excellent performance even for complex queries. ... • Ease of Administration - Informix SE takes advantage of native UNIX operating system and file management, making backing up databases and tables as simple as backing up any other UNIX. Informix SE includes easy-to-use utilities that allow users to migrate Informix SE data to another Informix SE database--or to the Informix Dynamic Server™, providing an upgrade path to a high-performance, parallel-processing database server. ... • Data Integrity - The transaction logging feature of Informix SE supplies an audit trail of data changes, ensuring fundamental data integrity and allowing fast and reliable restoration of databases when a system failure occurs. During a transaction, changed data is locked to prevent another user from altering that data at the same time. ... • Data Consistency - Informix SE integrity constraints, stored procedures and triggers allow data validation rules to be defined centrally in the database. ... • Data Security - Informix SE provides security controls at the database, table, column and stored procedure levels. Stored procedure permissions can be used to restrict user access to business functions rather than underlying data, allowing extreme flexibility in determining user rights. ... There are features to protect data and to define relationships between data. ... For example, constraints enable you to protect data and to define relationships between data values. Here are some key DB2 features: • Constraints • User-Defined Types (UDTs) and Large Objects (LOBs) • User-Defined Functions (UDFs) • Triggers • Stored Procedures To decide whether or not to use DB2 features, consider the following points: Application independence You can make your application independent of the data it processes.