What constitutes a good DBMS application design?



A DBMS makes it possible for end users t create read,update and delete data in a database. The DBMS essentially server as an interface between the database and end users or application programs ensuring that data is consistently organized and remains easily accessible.The DBMS manages three importants things the data the database engine that allows data to be accessed,locked and modified and the database schema which defines the databases logical structure.These three foundational elements help provide concurrency,security,data integrity and uniform administration procedures.Typical database administration basks supported by the DBMS include change management,performance monitoring/tuning and backup and recovery.Many database management systems are also responsible for automated rallbacks,restarts and recovery as well as the logging and auditing of activity. Using a DBMS to store and manage data comes with advantages,but also overhead.One of the biggest advantages of using a DBMS is that it lets and users and application programmers access and use the same data while managing data integrity. Data is better protected and maintained when it can be shared using a DBMS instead of creating new iterations of the same data stored in new files for every new application.The DBMS provides a central store of data that can be accessed by multiple users in a controlled manner central storage and management of data within the DBMS provides.

Data abstractions and independence;Datasecurity;A locking mechanism for current access;An efficient handler to balance the needs of multiple applications using the same data;The ability to swittly recover from crashes and errors including restartability and recoverability;Robust data integrity capabilities;Logging and auditing of activity;simple access using a standard application programming interface uniform administrations procedures for data.

 

What is software? How is software categorized?

Software-programs that consists of the instructions that ball the computer have to carry out a specific task.The concept of software categories is a challenging topic,and with the continuous development of new software it is becoming increasingly difficult to categorize new software.There is no universally agreed upon set of categories and different classification schemes consider different uspects.Computer software can be put into categories based on common function,type,or field of use.There are three broad classifications:

-Application software is the general designation of computer programs for performing tasks.Application software may be general purpose (word processing web browsers) or have a specific purpose(accounting truck scheduling). Application software contrast with system software;

-System software is a generic term rettering to the computer programs used to start and run computer systems including diverse application software and networks;

-Computer programming tools,such as computer and linker,are used to translate and combine computer program source code and libraries into excutableRAMs (programs that will belong to one of the three said). The GNU project categorizes software by copyright status:freesoftware,open source software,public domain software,copyleftedsoftware,noncopylefted free software lax permissive licencedsoftware,BPL covered software,the GNU operating system,GNUprograms,GNUsoftware,FSF-copyrighted GNU software,nonfreesoftware,proprietary software freeware,shareware,private software and commercial software.

 

What are the most popular types of application software? Why is it called application software?

There are many types of application software:

1. Information worker software

2. Entertainment software

3. Educational software

4. Enterprise infrastructure software

5. Simulation software

6. Media development software

7. Product engineering software

An application program (app or application for short) is a computer program designed to perform a group of coordinated functions, tasks, or activities for the benefit of the user. Examples of an application include a word processor, a spreadsheet, an accounting application, a web browser, a media player, an aeronautical flight simulator, a console game or a photo editor. The collective noun application software refers to all applications collectively. This contrasts with system software, which is mainly involved with running the computer.

Applications may be bundled with the computer and its system software or published separately, and may be coded as proprietary, open-source or university projects.[2] Apps built for mobile platforms are called mobile apps.

 


Дата добавления: 2018-06-01; просмотров: 417; Мы поможем в написании вашей работы!

Поделиться с друзьями:






Мы поможем в написании ваших работ!