ADVERTICEMENT

Tuesday, 31 March 2015

D>W>H

About Data Warehouse(D.W.H):
Reference Wikipedia:
In computing, a data warehouse (DW, DWH), or an enterprise data warehouse (EDW), is a database used for reporting (1) and data analysis (2). Integrating data from one or more disparate sources creates a central repository of data, a data warehouse (DW). Data warehouses store current and historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.
The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.

star schemas

Star Schema:
Reference Wikipedia:
In computing, the Star Schema (also called star-join schema) is the simplest style of data mart schema. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.[1]
The star schema gets its name from the physical model's[2] resemblance to a star with a fact table at its center and the dimension tables surrounding it representing the star's points.

type of data where house

Types of Data Warehouse
There are mainly three type of Data Warehouse.................
1). Enterprise Data Warehouse.
2). Operational data store.
3). Data Mart.
Enterprise Data Warehouse provide a control Data Base for decision support through out the enterprise.
Operational data store has a broad enterprise under scope but unlike a real enterprise DW. Data is refreshed in rare real time and used for routine business activity.
Data Mart is a sub part of Data Warehouse. It support a particular reason or it is design for particular lines of business such as sells, marketing or finance, or in any organization documents of a particular department will be data mart
Data Marts:

DATA MARTS?

Data Mart:
Reference wikipedia:
A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts are small slices of the data warehouse. Whereas data warehouses have an enterprise-wide depth, the information in data marts pertains to a single department. In some deployments, each department or business unit is considered the owner of its data mart including all the hardware, software and data.[1] This enables each department to use, manipulate and develop their data any way they see fit; without altering information inside other data marts or the data warehouse. In other deployments where conformed dimensions are used, this business unit ownership will not hold true for shared dimensions like customer, product, etc.

finite automata

deterministic finite automata
Web definitions
In automata theory, a branch of theoretical computer science, a deterministic finite automaton —also known as deterministic finite state machine—is a finite state machine that accepts/rejects finite strings of symbols and only produces a unique computation of the automaton for each input string. ...

RAM?

RAM - random access memory:
RAM (pronounced ramm) is an acronym for random access memory, a type of computer memory that can be accessed randomly; that is, any byte of memory can be accessed without touching the preceding bytes. RAM is the most common type of memory found in computers and other devices, such as printers.
Types of RAM
There are two different types of RAM:
DRAM (Dynamic Random Access Memory)
SRAM (Static Random Access Memory).
The two types of RAM differ in the technology they use to hold data, with DRAM being the more common type. In terms of speed, SRAM is faster. DRAM needs to be refreshed thousands of times per second while SRAM does not need to be refreshed, which is what makes it faster than DRAM.
Example of writable volatile random-access memory: Synchronous Dynamic RAM modules, primarily used as main memory in personal computers, workstations, and servers.

whats ram

RAM:(Random Access Memory:
why it's called random did any body think about this word.Means by it's name we are understanding than any time it will by accessed by processor b/c the closest to the processor Memory is Registers which is short memory but the fastest memory than others it's used for ALU,(additions,subtraction,Boolean operations).but when the processor did not find it's required data to access it's then goes to "CACHE" "Memory"
Cache is also a type of fast and small memory after the registers .different levels are there (L1,L2 and L3).If the processor find it's data in L1 it's call L1 hit memory else L1 miss memory.And in this condition the processor access it's required data or Write from the memory.If the processor not find in L1 and L2 than it access from the RAM.
That's why we call it Random Access Memory any time the processor will access the RAM.when it not find it's data OR required information in the Memories Above the RAM.

whats semiconductors do

semiconductor:
A material that is neither a good conductor of electricity (like copper) nor a good insulator (like rubber). The most common semiconductor materials are silicon and germanium. These materials are then doped to create an excess or lack of electrons.
Computer chips, both for CPU and memory, are composed of semiconductor materials. Semiconductors make it possible to miniaturize electronic components, such as transistors. Not only does miniaturization mean that the components take up less space, it also means that they are faster and require less energy.

Translators?

Transister:
A device composed of semiconductor material that amplifies a signal or opens or closes a circuit. Invented in 1947 at Bell Labs, transistors have become the key ingredient of all digital circuits, including computers. Today's microprocessors contains tens of millions of microscopic transistors.
Prior to the invention of transistors, digital circuits were composed of vacuum tubes, which had many disadvantages. They were much larger, required more energy, dissipated more heat, and were more prone to failures. It's safe to say that without the invention of transistors, computing as we know it today would not be possible.

CRAY C90(Super Computer:)

CRAY C90(Super Computer:):
Cray makes computers that aren't just good -- they're super. Its massively parallel and vector supercomputers provide the firepower behind research ranging from weather forecasting and scientific research to design engineering and classified government projects. The company also provides maintenance and support services, and it sells its own and third-party data storage products primarily from NetApp and DataDirect Networks. Cray's largest customer is the US government, which accounts for about two-thirds of sales. Cray also targets academic institutions and industrial companies. Around 80% of sales come from customers in the US.

What Is 3 Tier Architecture?

What Is 3 Tier Architecture?
3 tier architecture is a client server architecture where the user interface, computer data storage and data access are created and maintained as independent modules. It is mean to allow any of the three tiers to be replaced or developed independently. For example, a change in the operating system of a presentation tier will only affect the user interface code.

real sime system?

Real -Time-System:
The system which process and give the response at a given specific period of time are called real time system.
examples are:
aircraft control,ticket reservation system at airport,mobile phone,temperature controller,Doppler blood flow -Monitor/

whats datawere house?

Concept of Data warehouse in the light of Databases:
before the data warehouse the database was based upon the operational transaction purpose using OLTP(online Transaction processing).But in the mid of 1980's the databases developer's realized that there is need of warehouse for the Manager's decision making.there fore the concept of data warehouse concept developed.And the Online Analytic Processing (OLAP) used to analyzing the data from the warehouse.which is the heart of Data warehouse.

decition suppurt system

DSS & EIS
DSS:Decision Support System:
The dss were designed for decision purpose,it's functions are prepared,separated,staged the data that was specially needed for decision purpose.
1;easy to access the needed data.
2:improve the system performace
3:having integrity and security.
EIS:This type of systems are used at upper level for managers to solved the problems.B/C the dss are not handle by the manager's autonomously the EIS are based upon the graphical based system.they are easy to access ,provide timely delivery,data can be better understood.
Disadvantagies are:
1:Security less
2:High implementation cost
3:limited functions
The EIS don't have capability of Dsss .both are used conjunctionally the EIS find the problem.and DSS find the alternativ solution to solve that particular problem.

Monday, 30 March 2015

olap tools

OLAP Cubes:
The olap cube is the business intelligence tool in order to analyzing the purpose date in the warehouse for the BI.In order to make the decision,We analyze the data in many dimensions such in 0 dimension or more,The example is that :A company wants to make it's decision through the time,product,region,city etc above techniques are know as multiple dimensions.the Olap is stand for (Online analytical Processing)

olap

OLAP Cube:It's consider the three dimension cube means we can analyze the date through any of the cube but some time the more than three dimensions are used known as Hypercube.The cube is shortcut for the Multi-dimensional datasets.The data can have the arbitrary dimensions.
Slicer is a term for a dimension which is held constant for all cells so that multidimensional information can be shown in a two dimensional physical space of a spreadsheet or pivot table.
Each cell of the cube holds a number that represents some measure of the business, such as sales, profits, expenses, budget and forecast.
OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.

physical architechture

Physical Architecture of Data Warehouse:
The physical architecture define the internal components of the ware house and describe the physical infrastructure on which the ware house major components resides.
the architecture define the function of each components for the particular application.and the infrastructure define the hardware and software use to implement these components.
Through the above achievements we can easily transfer the data,Analyze ,make query on the data and most important to make the decision upon the present data.

Whats registers

What are Registers in side the Micro-chip:
Registers are type of memory which are inside the micro-processor,they are used when the processor needs more than one operations inside the it.in term of memory they have highest priority.but small .Registers are consider the fastest memory because they are connect to the processor with internal buses instead of the external.They are so closet to the processor .Different types of registers are there in processor.
such as,Program counter,Accumulator,Memory address register etc.
There are 14 registers in the intel advance processor extended 88(iAPX88) architecture.

animation

Animation:the moving of an object in different angles is called animation.By the biological perspective when human being see any picture the it's save in retina of the eye.So that perspective we can see the motion of the pictures.There are different types of animation one of them is give below
1:Cel Animation:The figurative animation of the picture frame by frame is called the cel animation .it's concept arrived in 1915.Firs it's frame are created then those are copyied on acetate sheet after their background will be color

requarnment engnearing

Requirement Engineering:
The services of the system to analyze for the customers requirement ,constraints of the system under which the system have to be handle,functionalities of the system,for the response of the customer and other related entities is called Requirement Engineering

basic requarnmrnt

What is Requirement:The requirement for a system may be high level abstraction services OR it may may the mathematical deep description of the system functionalities.The requirement is dependent upon the organization how much requirement they need from the system for their then the system requirements are analyzed according to the abstract level
OR completely Mathematical description of the requirements of the system

whats developer

A software developer is a person concerned with facets of the software development process. Their work includes researching, designing, implementing, and testing software. A software developer may take part in design, computer programming, or software project management. They may contribute to the overview of the project on the application level rather than compone

functional and non functional requarnment

Functional and Non- Functional Requirements Of the System:
Functional requirements:it's mean how the system will work what will be the functionalities of the system for the customer requirements,manager other external entities related to the system;
Non-Functional requirements:it's concerned with constraint of the system,what will be the constraint of the system under which it give access to the authorized user.what will be the system response time,storage requirements,the non-functional requirements are more critical than the function because if these requirements are not meet >the system will be useless

phases of sofware engnearing

whats software engnearing & phases?
software engnearing is not just programe it concerned with the all aspect of sofware development proceses of the production it concerned the programme, data and documentation so on.
phases:
vision = focus on why
defination=focus on what
development= focus on how
maintanance=focus on change

whats modelings

System Modeling:
the system modeling is the process of development of the abstract level of the system modeling;Each model of the system should be used in different perspective according to use:
The models which are involved in any system model are:
1:Context model,Integration model,Structural model,Behavioral model and the Model driven Engineering:

only for funn

INTERESTING FUN 
This Blogs is created for education and knowledge purpose. Post those things which are related to computer field.If something are more knowledge full he/she may post.We believe to Provide IT Awareness to all the Learners ,We will Appreciate You to join us grin emoticon
We want to Make a Better Environment where you feel to share and learn.
*Rule & Regulations*
1▬▬►Don't Post Any Adult Content.
2▬▬►Comment According To Topic.
3▬▬►Post Should Have Proper Discretion.
4▬▬►No Hate Speech.
5▬▬►No Chatting.