7.5 Database building, maintaining, and tuning.6.1 External, conceptual, and internal views.2.1 General-purpose and special-purpose DBMSs.A database is not generally portable across different DBMS, but different DBMSs can inter-operate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database. Well-known DBMSs include MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Microsoft Access, Oracle, Sybase, FoxPro, and IBM DB2. Personal, desktop-based database systems have less complexity. The complexity of a client-server or transactional DBMS arises because of the need to maintain high performance, availability and security when many users are querying and updating the database at the same time. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).Ī general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases, which are often large and complex. A database is an organized collection of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |