Types of tables in oracle

There are seven types of tables:

1. Heap organized tables:

A heap-organized table is a table with rows stored in no particular order. This is a standard Oracle table; the term "heap" is used to differentiate it from an index-organized table or external table.If a row is moved within a heap-organized table, the row's ROWID will also change.

Ex.
CREATE TABLE t1 (c1 NUMBER PRIMARY KEY, c2 VARCHAR2(30)) organization heap;

2.Index organized tables:

Index Organized Tables are tables that, unlike heap tables, are organized like B*Tree indexes. Besides storing the primary key values of an Oracle indexed-organized tables row, each index entry in the B-tree also stores the non-key column values.

Index clustered tables

Hash clustered tables

Nested tables

Global temporary tables

Object tables

Apriori Algorithm and It's improvement

A small description about apriori algorithm in Frequent pattern Mining in Data mining it is actually a problem solving technique for the existing algorithm

Encapsulation in Detail

What is Encapsulation:
Standard definitions says that it a process of wrapping up of data members and methods inside a class with the help of some access specifiers..

private,public and protected.

Private is a type of an access specifier which can be applied to a class, data member,method.
If given to a class then the data members,methods in that class can only access the class which is given as private.

public is type of an access specifier which can again be applied to a class, data members, methods and can be accessed from anywhere in the program.

protected is an other type of access specifier which can again be applied to a class,data members and methods and only the derived classes of that base class can be accessed to the base class which is protected.

Solid Nutrition ,Education & Health for 40 poor kids at Chinchwad ,Pune-33

Solid Nutrition ,Education & Health for 40 poor kids at Chinchwad ,Pune-33: 15000 kids (2-6 years age) from the poor families are suffering from malnutrition and poor hygiene in chinchwad,Pune-33They dont get convent education , good nutritional diet and proper care.For this govt is also trying but could not get success in last so many decades.Our aim is to provide toppings to them so that we can prepare them for the future.One healthy n good educated girl can change the generation,society n the nation.

Encapsultaion in General

What is Encapsulation:

Standard definitions says that it a process of wrapping up of data members and methods inside a class with the help of some access specifiers..

private,public and protected.

Private is a type of an access specifier which can be applied to a class, data member,method.

If given to a class then the data members,methods in that class can only access the class which is given as private.

public is type of an access specifier which can again be applied to a class, data members, methods and can be accessed from anywhere in the program.

protected is an other type of access specifier which can again be applied to a class,data members and methods and only the derived classes of that base class can be accessed to the base class which is protected.

Bussiness Intelligence definition

Business Intellignece:

Its nothing but building an "Information Delivery system for the customer to provide him right information at right time".

Here customers are any business bodies who want to know and mine the knowledge about their own business and go deep into the business.

Business Intelligence

"Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making."

Business intelligence (BI) refers to computer-based techniques used in identifying, extracting and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes.

BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, business performance management, benchmarking, text mining and predictive analytics.

Business intelligence aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS).

Though the term business intelligence is sometimes used as a synonym for competitive intelligence, because they both support decision making, BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors. Business intelligence understood broadly can include the subset of competitive intelligence.

BI applications use data gathered from a data warehouse or a data mart. However, not all data warehouses are used for business intelligence, nor do all business intelligence applications require a data warehouse.

Business intelligence also includes technologies such as data integration, data quality, data warehousing, master data management, text and content analytics, and many others that the market sometimes lumps into the Information Management segment.

Business Intelligence can be applied to the following business purposes (MARCKM), in order to drive business value:

1. Measurement – program that creates a hierarchy of Performance Metrics and Benchmarking that informs business leaders about progress towards business goals.
2. Analytics – program that builds quantitative processes for a business to arrive at optimal decisions and to perform Business Knowledge Discovery. Frequently involves: data mining, Statistical Analysis, Predictive Analytics, Predictive Modeling, Business Process Modeling
   
3. Reporting/Enterprise Reporting – program that builds infrastructure for Strategic Reporting to serve the Strategic management of a business, NOT Operational Reporting. Frequently involves: Data visualization, Executive information system, OLAP
4. Collaboration/Collaboration platform – program that gets different areas (both inside and outside the business) to work together through Data sharing and Electronic Data interchange.
5. Knowledge Management – program to make the company data driven through strategies and practices to identify, create, represent, distribute, and enable adoption of insights and experiences that are true business knowledge. Knowledge Management leads to Learning Management and Regulatory Compliance/Compliance.

In the next tutorial, we will go through the architecture....