Oracle Oracle is relational database management system which uses relational data model. In the relational data model, data is seen by the users in the form of tables. Oracle Server Oracle server consist of an oracle instance and a oracle database. Oracle Instance Oracle instance consist of memory and process. Physical and Logical Database Structures...
Category: 7th Semester
Post
December 27, 2021June 23, 20267th Semester, B.Sc. CSIT, Data Warehousing and Data Mining
Why do we need Data Mart? Types of Data Mart
What is Data Mart? Data mart is subset of data warehouse oriented to particular business subject line. The data mart contains repository of summarized data collected for analysis for specific section or unit within organizations. It is controlled by only single department in organization. Data Mart usually draws a data from only few sources compared...
Post
December 27, 2021June 23, 20267th Semester, B.Sc. CSIT
Database Architecture and Types
A database architecture is a representation of DBMS design. It helps to design, develop, implement, and maintain the database management system. A DBMS architecture allows dividing the database system into individual components that can be independently modified. Two-Tier Client Server Architecture The 2-tier architecture is same as basic client-server. In the two-tier architecture, applications on...
Post
December 24, 2021June 23, 20267th Semester, B.Sc. CSIT
Understanding DBA and ROLES and Responsibilities of DBA
What is DBA? DBA stands for database administration. Database administration refers to the whole set of activities performed by a database administrator to ensure that a database is always available as needed. Roles and Responsibilities of Database Administrator Installation and configuration: The DBA must install and customize the database software and any other programs/tools that...
Post
December 23, 2021June 23, 20267th Semester, B.Sc. CSIT, Principle of Management
What is Business Environment ?Concept, Characteristics & Types
Concept of business environment. The phrase “business environment” refers to all aspects of a company’s surroundings that affect and influence its operations and determine its effectiveness. The totality of all conditions, events, and forces that surround and affect the business environment is referred to as the business environment. Institutions or influences that influence an organization’s...
Post
December 22, 2021June 23, 20267th Semester, B.Sc. CSIT
How to secure the Computer Network?
Introduction Prior to the extensive usage of data processing technology, an organisation’s information was protected largely through physical and administrative measures. The necessity for automated solutions to secure files and other information kept on computers became apparent with the emergence of the computer. The emergence of distributed systems and the usage of networks and communications...
Post
December 20, 2021June 23, 20267th Semester, B.Sc. CSIT, Data Warehousing and Data Mining
Challenges of Data Mining
In several sectors, data mining and knowledge discovery is becoming a critical technology for businesses and researchers. While data mining is becoming a well-established and reputable subject, there are still numerous difficulties to overcome. Some of the challenges are: Mining methodology and user interaction issues It refers to the following kinds of issues Mining different...
Post
December 20, 2021June 23, 20267th Semester, B.Sc. CSIT, Data Warehousing and Data Mining
Study about Data Object and Attribute Types
Data sets are made up of data objects. A data object represents an entity. Examples: – sales database: customers, store items, sales – medical database: patients, treatments – university database: students, professors, courses . Also called samples , examples, instances, data points, objects, tuples. Data objects are described by attributes. Database rows -> data objects;...
Post
December 19, 2021June 23, 20267th Semester, B.Sc. CSIT, Data Warehousing and Data Mining
Knowledge Discovery in Database(KDD)
Knowledge Discovery in Databases (KDD) Knowledge Discovery in a database is the process of discovering useful knowledge from a collection of data .This widely used data mining technique is a process that includes data preparation and selection, data cleansing incorporating prior knowledge on data sets and interpreting accurate solutions from the observed results. Knowledge discovery...
Post
December 19, 2021June 23, 20267th Semester, B.Sc. CSIT, Data Warehousing and Data Mining
Data Mining functionalities
Data mining functions are used to define the kind of patterns that will be discovered during data mining jobs. Some of the major data mining functionalities are as follows: Class/ concept descriptions: Characterization and Discrimination Class/concept descriptions are the definitions of a class or idea. Data features should be generalised, summarised, and contrasted. For example,...