Code Bluff

Search This Blog

Get notes of any subject for free

on December 12, 2019

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Centralized and Client-Server Architectures | Advanced Database Systems | BE - IT Part(1)

Centralized and Client-Server Architectures: Centralized Architectures: - In a centralized database, there is a single database file at one location in the network - Multiple users can access this single database, it is called a centralized database - This kind of database provides multiple advantages - As there is an only single database file, it is easier to get a complete view of data Here we have installed our server on Site3, other sites can remotely access to the database. For e.g.: If Site5 needs any data then they can request it to site3 and retrieve data easily Advantages of Centralized Database: - The data integrity is maximized as the whole database is stored at a single physical location. This means that it is easier to coordinate the data and it is as accurate and consistent as possible - The data redundancy is minimal in the centralized database - Since all the data is in one place, there can be stro

OLAP Operations | Hackerrank Solutions

1. This OLAP operation involves computing all of the data relationships for one or more dimensions. A. Dice B. Slice C. Pivot D. Roll Up Answer. D. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing. Consolidation involves the aggregation of data that can be accumulated and computed in one or more dimensions. ... By contrast, the drill-down is a technique that allows users to navigate through the details. 2. This OLAP Operation rotates the data and delivers an alternative to the original presentation. A. Pivot B. Slice C. Roll-Up D. Dice Answer. Pivot

Basic Question on Advanced Database Systems

1. What are server systems? It is an operating system which is designed for servers, and their functionality. They are specially designed for client-server communication Examples of server systems: 1. Windows Server 2008 2. Windows Server 2003 3. Red Hat Enterprise Linus(RHEL) 2. What are distributed systems? A distributed system maintains multiple nodes which are at different locations but linked together using a network. Each of these is installed a smaller version of a server system which helps them in sharing data. Both client and server communicate using the Internet/Networks. 3. What are distributed databases in Database System architectures? Distributed Database System architectures manage multiple, interconnected and interrelated database systems over a network. A DDBMS(Distributed Database Management System) is a software which manages the DDB and provides an access mechanism that makes his distribution transparent to the users. 4. What are homogeneou

Powered by Blogger

Get notes of any subject for free

Comments

Post a Comment