Author: Sunny Singh

Pro Members SQL Server Standard Members

Concepts of Network Model and Hierarchical Data Structure – Part 1

Introduction This article delivers an overview of the network data model as well as the hierarchical data model. The network model as well as the original language were presented in the report of the CONFERENCE/COMMITTEE ON DATA SYSTEMS LANGUAGES (CODASYL) database work group of 1971. That is why it is sometimes called the DBTG model. The revised reports of 1978…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 7

Functions of Data Mining Data mining classifies facts or suggests conclusions based on the selection of data to discover patterns or anomalies. Data mining have five key functions: Classification: It defines the characteristics that describe a particular group for example, students who have failed in a particular subject. Clustering – It identifies sets of items that share a specific feature…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 6

THE ETL (EXTRACT TRANSFORMATION LOAD) PROCESS This section explains the 4 main processes of the data warehouse. They are extract (data from operating systems as well as transferred to the data warehouse), transform (data in internal format as well as organization of the data warehouse) as well as cleanse (to ensure quality of use sufficient for decision making) as well…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 5

Benefits of Data Warehousing Includes the use of the data warehouse, Find the right information Presentation of information. Hypothesis test Information discovery Transmit the analysis Tangible benefits (quantified / measurable) it includes: Improved product inventory. Lower production costs. Improved selection of target markets. Improved management of assets as well as liabilities. Intangible benefits (difficult to quantify) it includes: Increase productivity…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 4

Administration and Management of Data Warehouse The data warehouse management includes: Security as well as precedence management. Screening updates from multiple sources Checking data quality. Manage as well as updating the metadata. Reviewing as well as report on the use of the data warehouse as well as its status. Data cleaning Replication, sub-configuration as well as distribution of data. Backup…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 3

Distributed Vs Parallel Database: The parallel database system attempts to enhance performance by parallelizing multiple operations, such as loading data, creating indexes, as well as evaluating queries. Although the data of such a system can be warehoused in a distributed manner, the distribution is strictly performance-based. In the distributed database system, data is physically kept in multiple locations, as well…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 2

Architecture of Distributed Database A distributed database system permits systems to access data from local as well as remote databases. In a homogeneous distributed database system, every single database is an Oracle database. In a heterogeneous distributed database system, at least a single databases is not an Oracle database. Distributed databases make use of a client / server architecture to…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Data Warehousing with ORDBMS, Parallel and Distributed System – Part 1

Object Relational Database Management System (ORDBMS) Relational Database Management System (DBMS) is currently the leading database technology. Object Oriented Database Management System (OODBMS) has also become the preferred system for financial as well as telecommunications systems. Although the Object Oriented Database Management System (OODBMS) market remains the same. The Object Oriented Database Management System (OODBMS) continues to find new uses,…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 6

Object Oriented Database (OODB) The object oriented database (OODB) delivers all the functions related with the object oriented paradigm. In this way, we can organize objects, create classes, structure an inheritance hierarchy, as well as call methods from other classes. In addition, the functions associated with the standard database systems are provided. On the other hand, object oriented database systems…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Transaction Using ACID Properties Timestamp Protocol and Security Procedures – Part 5

Database Administrator (DBA) The database administrator is accountable for guaranteeing that the database keeps its integrity as well as is responsible for confirming that the database is under no circumstances compromised. This person has the maximum power over the scheme implemented by the organization. Any modification or addition to this schema must be approved by the database administrator. Eligibility to…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register