Alex Onsman has Published 207 Articles

Cache Management

Alex Onsman

Alex Onsman

Updated on 21-Jun-2020 16:59:02

2K+ Views

Cache is a type of memory that is used to increase the speed of data access. Normally, the data required for any process resides in the main memory. However, it is transferred to the cache memory temporarily if it is used frequently enough.A diagram to better understand the data transfer ... Read More

Single Processor Systems

Alex Onsman

Alex Onsman

Updated on 21-Jun-2020 12:36:31

12K+ Views

A single processor system contains only one processor. So only one process can be executed at a time and then the process is selected from the ready queue. Most general purpose computers contain the single processor systems as they are commonly in use.A single processor system can be further described ... Read More

Computer Storage Definitions and Notations

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 16:11:08

650 Views

Computer storage contains many components that are used to store computer data. Some information about the various storage devices is given below.Computer Storage DefinitionsThe computer storage devices include Primary and Secondary Storage devices. These are explained in detail as follows −Primary Storage DevicesPrimary storage is also known as the main ... Read More

Centralized Database Management System

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 09:53:33

15K+ Views

A centralized database is stored at a single location such as a mainframe computer. It is maintained and modified from that location only and usually accessed using an internet connection such as a LAN or WAN. The centralized database is used by organisations such as colleges, companies, banks etc.As can ... Read More

Overview of Packages in Oracle

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 08:46:22

646 Views

Packages are SQL procedures, functions, variables, statements etc. that are grouped into a single unit. Many different applications can share the contents of a package, as it is stored in the database.Parts of a PackageThe following are the parts of a package in Oracle −Package SpecificationThe package specifications contains information ... Read More

Open Source Databases

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 08:17:31

913 Views

Open source databases are those databases who have an open source code i.e anyone may view the code, study it or even modify it. Open source databases could be relational (SQL) or non relational (NoSQL).Why use Open Source Databases?It is quite expensive to create and maintain a database for any ... Read More

Multimedia Databases

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 08:16:05

11K+ Views

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 DatabaseThe multimedia database stored the multimedia data and information related to it. ... Read More

Mobile Databases

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 08:14:28

6K+ Views

Mobile databases are separate from the main database and can easily be transported to various places. Even though they are not connected to the main database, they can still communicate with the database to share and exchange data.The mobile database includes the following components −The main system database that stores ... Read More

Multidimensional Databases

Alex Onsman

Alex Onsman

Updated on 20-Jun-2020 08:11:30

6K+ Views

Multidimensional databases are used mostly for OLAP (online analytical processing) and data warehousing. They can be used to show multiple dimensions of data to users .A multidimensional database is created from multiple relational databases. While relational databases allow users to access data in the form of queries, the multidimensional databases ... Read More

Object based Data Models

Alex Onsman

Alex Onsman

Updated on 19-Jun-2020 09:52:17

10K+ Views

In object based data models, the focus is on how data is represented. The data is divided into multiple entities each of which have some defining characteristics. Moreover, these data entities are connected with each other through some relationships.So, in object based data models the entities are based on real ... Read More

Advertisements