Showing posts with label Computer Science. Show all posts
Showing posts with label Computer Science. Show all posts
[youtube]http://www.youtube.com/watch?v=3diKzwj7UKA[/youtube]
Part 1:
Today's database professionals face several options when considering architectures in which to employ to address the various needs of their employers and/or clients. The following text will provide an overview of three main categories of database architectures and their sub-categories, as well as offer some insight into the benefits of each.
Two-Tier Client-Server Architecture
Web-Based, Two-Tier Client-Server Architecture
Part 2:
Application Logic:The presentation logic component is responsible for formatting and presenting data on the user's screen The processing logic component handles data processing logic, business rules logic, and data management logic. Finally, the storage logic component is responsible for the storage and retrieval from actual devices such as a hard drive or RAM.Database architectures can be distinguished by examining the way application logic is distributed throughout the system. Application logic consists of three components: Presentation Logic, Processing Logic, and Storage Logic.
By determining which tier(s) these components are processed on we can get a good idea of what type of architecture and subtype we are dealing with.
[youtube]http://www.youtube.com/watch?v=phDieohAODI[/youtube]
The advantages in the database approach are as follows:
The advantages in the database approach are as follows:
- All the three managers are using the same database; hence, any report using the information will not be inconsistent.
- All the three managers can view the database as per their needs.
- The application systems can be developed independent of the database.
- The data validation and updating will be once and same for all.
- The data is shared by all users.
- The data security and privacy can be managed and ensured because the data entry in the database occurs once only and is protected by the security measures.
- Since the database is storage of the structured information, the queries can be answered fast by using the logic of the data structures.
[youtube]http://www.youtube.com/watch?v=qOzb0dmJ-Oc[/youtube]
Introduction:

A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
Introduction:
A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.
Subscribe to:
Posts (Atom)