Advanced database system, Study Guides, Projects, Research of Computer Security

Advanced database system documentation

Typology: Study Guides, Projects, Research

2017/2018

Uploaded on 09/12/2021

robel-guta
robel-guta 🇬🇧

5

(1)

8 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
RIFT VALLEY UNIVERSITY-BISHOFTU CAMPUS
DEPARTMENT OF COMPUTER SCIENCE
ADVANCED DATABASE SYSTEM ASSIGNMENT-II
FOR 2ND AND 3RD YEAR COMPUTER SCIENCE STUDENTS
Date of Submission: june(sene) 5 ,2012 E.C. Mark load:20%
Submit your assignment to office no:14(cs Dept.head office)
pf3
pf4
pf5

Partial preview of the text

Download Advanced database system and more Study Guides, Projects, Research Computer Security in PDF only on Docsity!

RIFT VALLEY UNIVERSITY-BISHOFTU CAMPUS

DEPARTMENT OF COMPUTER SCIENCE

ADVANCED DATABASE SYSTEM ASSIGNMENT-II

FOR 2ND AND 3RD YEAR COMPUTER SCIENCE STUDENTS

Date of Submission : june(sene) 5 ,2012 E.C. Mark load:20% Submit your assignment to office no:14(cs Dept.head office) or Email:[email protected]

Briefly Discuss the Following Topics 1.What is multimedia Database? give atleast 3 examples of multimedia database. Explain the difference between multimedia Databases with other types of databases.

  1. Explain in detail the following database related issues 2.1.Active database 2.2.Deductive databases 2.3.Security and Integrity multimedia databases The multimedia databases are used to store multimedia data such as images, animation, audio, video along with text. This data is stored in the form of multiple file types like .txt(text), .jpg(images), .swf(videos), .mp3(audio) etc. Contents of the Multimedia Database The multimedia database stored the multimedia data and information related to it. This is given in detail as follows −

Graph database. Let us explain all of them:

  1. Centralised Database The information(data) is stored at a centralized location and the users from different locations can access this data. This type of database contains application procedures that help the users to access the data even from a remote location. Various kinds of authentication procedures are applied for the verification and validation of end users, likewise, a registration number is provided by the application procedures which keeps a track and record of data usage. The local area office handles this thing. 2.Distributed Database Just opposite of the centralized database concept, the distributed database has contributions from the common database as well as the information captured by local computers also. The data is not at one place and is distributed at various sites of an organization. These sites are connected to each other with the help of communication links which helps them to access the distributed data easily. You can imagine a distributed database as a one in which various portions of a database are stored in multiple different locations(physical) along with the application procedures which are replicated and distributed among various points in a network. There are two kinds of distributed database, viz. homogenous and heterogeneous. The databases which have same underlying hardware and run over same operating systems and application procedures are known as homogeneous DDB, for eg. All physical locations in a DDB. Whereas, the operating systems, underlying hardware as well as application procedures can be different at various sites of a DDB which is known as heterogeneous DDB.

3.Personal Database Data is collected and stored on personal computers which is small and easily manageable. The data is generally used by the same department of an organization and is accessed by a small group of people. 4.End User Database The end user is usually not concerned about the transaction or operations done at various levels and is only aware of the product which may be a software or an application. Therefore, this is a shared database which is specifically designed for the end user, just like different levels’ managers. Summary of whole information is collected in this database. 5.Commercial Database These are the paid versions of the huge databases designed uniquely for the users who want to access the information for help. These databases are subject specific, and one cannot afford to maintain such a huge information. Access to such databases is provided through commercial links. 6.NoSQL Database These are used for large sets of distributed data. There are some big data performance issues which are effectively handled by relational databases, such kind of issues are easily managed by NoSQL databases. There are very efficient in analyzing large size unstructured data that may be stored at multiple virtual servers of the cloud. 7.Operational Database Information related to operations of an enterprise is stored inside this database. Functional lines like marketing, employee relations, customer service etc. require such kind of databases. 8.Relational Databases These databases are categorized by a set of tables where data gets fit into a pre-defined category. The table consists of rows and columns where the column has an entry for data for a specific category and rows

11.Graph Databases The graph is a collection of nodes and edges where each node is used to represent an entity and each edge describes the relationship between entities. A graph-oriented database, or graph database, is a type of NoSQL database that uses graph theory to store, map and query relationships. Graph databases are basically used for analyzing interconnections. For example, companies might use a graph database to mine data about customers from social media.