Assignment 1. 1) Differentiate between database management system and information retrieval system by focusing on their functionalities. There are many functions of database management system and information retrieval system. But, there are differences when focusing on their functionalities. Database management system is a software package that allows data to be effectively stored, retrieved and manipulated, and the data stored in a DBMS package can be accessed by multiple users and by multiple application programs like(Oracle) .For an information retrieval system, according to Harter, it is a device interposed between a potential user of information and information collection itself that given information problem, the purpose of the
Q.29: What is the use of temporary tablespaces? Ans: Temporary tablespaces work for specific processes like SQL hash joins and table data sorting. In SQL, if data size is large and comprise upon millions of returned rows, then the temporary memory of computer (RAM) becomes insufficient. As a result, the sort job takes place on disk by using temporary tablespaces. Q.30: Briefly explain the importance of temporary tablespace?
It is also known as a software development life cycle. Most development processes can be described as agile, waterfall, prototyping, iterative, incremental, spiral development, rapid application development, and extreme programming. Some people consider a life-cycle model a more general term for a category of methodologies and a software development process a more specific term to refer to a specific process chosen by a specific organization. For example, there are many specific software development processes that fit the spiral life-cycle model. Adaptive software development Is a software development process that grew out of rapid application development (RAD).
Database designers design database diagram, System analysts and programmers design and implement the application program and lastly End users who use application program for organization`s using. D. Procedures This refers to sets of regulation and instruction used to govern the design and uses of the database that written and enforce by Database administrators. Example, procedures are like owner`s manual how to operate and use DBMS properly and efficiently. E. Data Data covers the collection of facts stored in the database. Since data are building blocks of information, it is important to know what data needed into database and how to organize data properly is vital part of database designer`s
File based Systems Approach Disadvantage of a database management system is that they generally don't do well in Binary Large Object storage (BLObs, or binary files like images), but that's easy enough to get around by using references to the file system or a different database. Also, some DBMSs are designed for this. The advantage of using a DBMS is that not reinventing the wheel and everything is done and tested by outside parties, so long as trust the developer. Some of Comparison between Database Management Systems Approach and File based System Approach Database Management Systems approach File Based Systems Approached Data base management system provide multiple user interfaces file system data is isolated Data base management system provide backup and recovery Data lost in file system it is not possible. Unauthorized access is restricted in DBMS n the file system it is not restricted Redundancy is control in Data base management system in file system it is not available A DBMS is designed to allow flexible access to data (i.e.
As a result, employees are engaged with the handling of data and information via the internet. It seriously saves time in data transferring from one place to another. Besides, using the E-HR tools, employees can ensure the proper reaching of the data to the right person. At one point, data security is ensured. On the other hand, this process saves much more time and administrative costs.
HDFS store these both separately. HDFS stores its metadata and edit log at namenode and application data on datanode. In traditional data management systems or filesystems when we store data and process it , we have to traverse whole data which is costly and time consuming and all data was stored on single physical machine, if machine crashes all the data will get lost. So overcome these limitations HDFS was designed. HDFS has the following advantages over traditional systems: • Commodity Hardware: HDFS does not require expensive and highly reliable hardware because it can run on clusters of common available hardware that can be obtained from multiple vendors.
C) A discussion of client and server interaction within web applications, discussing both client and server technology: The client and server interaction withing Web Applications means structure that partitions tasks between the providers of a resources or services, called ( web ) servers, and ( browsers ) service requesters ( data requesters ) - the clients. Usually clients and server communicates via different hardware, but they are over computer network which means that both of them are in the same system. The main meaning: The main meaning ( more complicated
Introduction A transaction process system (TPS) is an information processing system used in business transactions that involves the collection, retrieval and modification of the entire transaction data. The characteristics of a TPS include rapid processing, reliability, standardization and control access. TPS is also known as transaction processing or real-time processing. A transaction process system is often distinguished with a batch processing that most requests are accomplish at one time. The former require the interaction of a user or needs the user to be in attendance.
The other databases give the users a major access of their data or storage therefore there is a possibility of bugs entrance or making the data corrupt. The RDBMS however consumes a lot of physical memory and the problem on the other hand is not present in the object oriented programming database management systems. This system uses the objects of classes to manipulate data and therefore the data with similar data types consumes the same classes making it possible for the database consume less storage. But in order to take the advantages of both the databases there is a combination of the two databases i.e. object relational database management system.