Data warehouse

Data warehousing emphasizes capturing data from various sources for useful analysis and access, but not generally emanate from the point of view of the end user who may have access to specialized and sometimes require local databases. This last idea is known as the data mart.

There are two ways of data warehousing, top-down and bottom-up. The top-down approach spins off data marts for specific groups of users after the entire data warehouse was created. The bottom-up approach to building data marts and then combines them into a single, comprehensive data warehouse.

Typically, a data warehouse housed on a mainframe enterprise server or increasingly, in the cloud. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted for use by analytical applications and the user queries.

The data warehouse term was coined by William H. Inmon, known as the Father of Data Warehousing. Inmon described a data warehouse as a subject-oriented, integrated, time-variant and non-volatile collection of data that supports the decision-making of management.

Online References

http://www.tutorialspoint.com/dwh

https://docs.oracle.com/cd/B10500_01/server.920/a96520/concept.htm

E Books

Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals

DATA WAREHOUSING: Concepts, Techniques, Products and Applications

Data Warehouses and OLAP: Concepts, Architectures, and Solutions

Office Automation Systems(OAS)

Office automation systems (OAS) are configurations of networked computer hardware and software. A variety of office automation systems are now applied to business and communication functions that used to be performed manually or in multiple locations of a company, such as preparing written communications and strategic planning. In addition, functions that once required coordinating the expertise of outside specialists in typesetting, printing, or electronic recording can now be integrated into the everyday work of an organization, saving both time and money.

Types of functions integrated by office automation systems include (1) electronic publishing; (2) electronic communication; (3) electronic collaboration; (4) image processing; and (5) office management. At the heart of these systems is often a local area network (LAN) . The LAN allows users to transmit data, voice, mail, and images across the network to any destination, whether that destination is in the local office on the LAN, or in another country or continent, through a connecting network. An OAS makes office work more efficient and increases productivity.

Source from:-www.encyclopedia.com

Learn more... 

 

WebGL

WebGL (Web Graphics Library) is a JavaScript API for rendering interactive 3D computer graphics and 2D graphics within any compatible web browser without the use of plug-ins.WebGL is integrated completely into all the web standards of the browser allowing GPU accelerated usage of physics and image processing and effects as part of the web page canvas.

WebGL elements can be mixed with other HTML elements and composited with other parts of the page or page background.[3] WebGL programs consist of control code written in JavaScript and shader code that is executed on a computer's Graphics Processing Unit (GPU). WebGL is designed and maintained by the non-profit Khronos Group.Learn more...

From wiki 

WebGL Official Website

WebGL Books

WebGL Tutorials

• webglfundamentals.org
• tutorialspoint.com 
• html5rocks.com

C# Validation Codes

Email Validation Code

private void button1_Click(object sender, EventArgs e)
        {
            String ID = txtID.Text;

            if ((ID.Count(char.IsDigit) == 9) && (ID.EndsWith("X") || ID.EndsWith("V")) && (ID[2] != '4' && ID[2] != '9'))
            {
                MessageBox.Show("Valid ID");
            }
            else
            {
                MessageBox.Show("Invalid ID");
            }
      }

NIC Validation Code

private void button1_Click(object sender, EventArgs e)
{
string pattern = null;pattern = "^([0-9a-zA-Z]([-\\.\\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\\w]*[0-9a-zA-Z]\\.)+[a-zA-Z]{2,9})$";

            if (Regex.IsMatch(txtEmail.Text, pattern))
            {
                MessageBox.Show("Valid Email address ");
            }
            else
            {
                MessageBox.Show("Not a valid Email address ");
            }
}

BCS Management Information Systems(MIS) Recommended Book Download Here

Download Link:- Terry Lucey, Management Information Systems, Ninth Edition, 2005, Thompson.

Creating Database Driven Login Form Using C# & MySQL

Codes


namespace MyProject

{
    public partial class frmMyLogin : Form
    {
        public frmMyLogin()
        {
            InitializeComponent();
        }

        MySqlConnection con = new MySqlConnection(@"server=localhost;user id=root;database=employee");
        MySqlDataAdapter da = new MySqlDataAdapter();
        MySqlCommand cmd = new MySqlCommand();

        private void btnLogin_Click(object sender, EventArgs e)
        {
            con.Open();
            string Username = txtUsername.Text;
            string Password = txtPassword.Text;

            MySqlCommand cmd = new MySqlCommand("Select UserName,Password from login where UserName='"+txtUsername.Text+"'and Password='"+txtPassword.Text+"'",con);

            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                MessageBox.Show("Login Sucessfull");
                frmMain mymain = new frmMain();
                mymain.Show();
                this.Hide();
            }

            else
            {
                MessageBox.Show("Invalid UserName or Password");
            }
            con.Close();
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            DialogResult s = MessageBox.Show("Are you sure do you want to exit", "Exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (s == DialogResult.Yes)
            {
                Application.Exit();
            }
        }

        private void btnNewUser_Click(object sender, EventArgs e)
        {       
            string cmdText = "INSERT INTO login(UserName,Password) VALUES (@UserName, @Password)";
            con.Open();
            MySqlCommand cmd = new MySqlCommand(cmdText, con);
            cmd.Parameters.AddWithValue("@UserName", txtUsername.Text);
            cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
           cmd.ExecuteNonQuery();
            MessageBox.Show("Create new user is successful");
            con.Close();
        }
    }
}
 

------------

By Thissa 

----------------

M# - The .NET Language

M# ("M sharp") is an implementation of the M programming language based on Microsoft's Dynamic Language Runtime (DLR). Other M implementations include Matlab, Octave and SciLab. Extreme Numerical Optimization .NET libraries used as underlying computational kernel.

Because M # is a .NET language, the direct use of the extensive collection of species and libraries can make available for the .NET framework. In particular, in contrast to other implementations of the M language, M # can advanced numerical types such as arbitrary precision integers, using rational numbers and floating-point numbers.

For more see this article:- extremeoptimization.com

Performance

M # uses the same technology as Microsoft two dynamic language Iron Python and Iron Ruby, to measure the best balance of flexibility and speed. The numerical horsepower provided by the Extreme Optimization Numerical Libraries for .NET. This M # can compete around the fastest implementations and significantly outperforms open source implementations.

Official Web site:- msharp.co.uk

References

Why M#? 

Undestanding M#

Web application framework (WAF)

A web application framework (WAF) is a software framework that is designed to support the development of dynamic websites, web applications, web services and web resources. The framework is intended to alleviate the overhead associated with common activities carried out in web development. For example, many libraries provide frameworks to access the database, templating frameworks and session management, and they often promote code reuse.

Types of framework architectures

Model–view–controller (MVC)

Many frames will follow the MVC architectural pattern to separate the data model with business rules from the user interface. This is generally considered good practice modularizes code promotes code reuse and multiple interfaces can be used. In Web applications, this makes presented different views, such as web pages for humans, and web service interfaces for external applications.

Push-based vs. pull-based

Most MVC frameworks follows a push -based architecture also called " action -based " . These frameworks use actions do the required processing , and then "push" the data to the display layer to the results. Django Ruby on Rails, Symfony , Spring MVC, Stripes , CodeIgniter are good examples of this architecture An alternative is pull - based architecture , sometimes called " component-based " these cadres layers begin with vision, who can then " pull "the results of multiple controllers as needed In this architecture , multiple controllers can be involved in one view Elevator , Tapestry , JBoss Seam, Java Server Faces ( μ ) Micro and Wicket are examples of pull - . based architectures Play . Struts, RIFE and ZK have support for both push and pull -based application controller calls.

Three-tier organization

In three -tier organization, applications are structured around three physical layers. Client application and database The database is normally a RDBMS. The application contains the business logic that runs on a server and communicates with the client using HTTP. [11] The client web applications is a Web browser that supports HTML is generated by the application layer. The term should not be confused with MVC , which , unlike the three - tier architecture , it is regarded as a good practice to keep business logic of the controller , the " middle layer " .

Books

Java Frameworks and Components: Accelerate Your Web Application Development

By Michael Nash

Python Web Application Frameworks: Cherrypy, Django (Web Framework), Flask (Programming), Grok (Web Framework), Nagare (Web Framework), Nevow, Pylons

 
Developing Application Frameworks in .NET