Author: Sunny Singh

Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 3

Control of Data Redundancy Ideally, the database approach stores each piece of data in a place in the database. In certain cases, there is still data redundancy to increase system performance. However, this redundancy is controlled as well as minimized through application programming by introducing the least amount of redundancy as much as possible in the database design. Data sharing…...

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

Prior to DBMS, Database Approach, Data Model — Part 1

Prior to Introduction of Database Management Systems (DBMS) The way computers manage data has changed dramatically in the last few decades. Today’s end users take the many advantages of a database system for granted. Not so long ago, computers used a less elegant as well as expensive approach to data management called a file-based system. File-Based System One way 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

Concepts of Network Model and Hierarchical Data Structure – Part 4

Properties of a Hierarchical Schema The hierarchical schema of record types as well as Parent Child Relationship (PCR) types should have the subsequent properties: A record type, known as a root of the hierarchical schema, do not take part in any type of Parent Child Relationship (PCR) as a child record type. Each and every single record type excluding the…...

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

Concepts of Network Model and Hierarchical Data Structure – Part 3

Currency Indicators The network’s Data Manipulation Language (DML) restores as well as updates by moving or searching database records. Therefore, it is important to keep an eye on the search. Currency indicators allow an individual to keep track of the records that an individual has accessed last as well as find set occurrences in the DATABASE MANAGEMENT SYSTEM (DBMS). They…...

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

Concepts of Network Model and Hierarchical Data Structure – Part 2

Representation of M : N Relationships by Sets The set type represents a 1 : N (one : many) relationship among two (2) types of records, which indicates that a record of the member record type can be displayed in a single specified set instance. The DATABASE MANAGEMENT SYSTEM (DBMS) automatically applies this restriction in the network model. To represent…...

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

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