OLTP- and OLAP- technologies We can divide IT

OLTP- and OLAP- technologies We can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP systems provide source data to data warehouses, whereas OLAP systems help to analyze it.

OLTP- and OLAP- technologies

OLTP- and OLAP- technologies OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (сущность-связь)(usually 3 NF).

OLTP- and OLAP- technologies OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multidimensional schemas

OLTP- and OLAP- technologies OLTP System Online Transaction Processing(Operational System) Source of data Operational data; OLTPs are the original source of the data. Purpose To control and run of data fundamental business tasks OLAP System Online Analytical Processing (Data Warehouse) Consolidation data; OLAP data comes from the various OLTP Databases To help with planning, problem solving, and decision support What the Reveals a snapshot of Multi-dimensional views of various data ongoing business processes kinds of business activities Inserts and Updates Short and fast inserts and updates initiated by end users Periodic long-running batch jobs refresh the data

OLTP- and OLAP- technologies OLTP System Online Transaction Processing(Operational System) OLAP System Online Analytical Processing (Data Warehouse) Processing Speed Typically very fast Depends on the amount of data involved; batch data refreshes and complex queries may take many hours; query speed can be improved by creating indexes Space Requirements Can be relatively small if Larger due to the existence of historical data is archived aggregation structures and history data; requires more indexes than OLTP

OLTP System Online Transaction Processing(Operational System) OLAP System Online Analytical Processing (Data Warehouse) Database Design Highly normalized with many tables Backup and Recovery Queries Typically de-normalized with fewer tables; use of star and/or snowflake schemas Backup religiously; operational Instead of regular backups, data is critical to run the some environments may business, data loss is likely to consider simply reloading entail significant monetary loss the OLTP data as a and legal liability recovery method Relatively Often complex queries standardized and simple queries involving aggregations Returning relatively few records

Web - technologies • XHTML 2. 0 [ http: //en. wikipedia. org/wiki/XHTML#XHTML_2. 0 ] • CSS 3 [ http: //www. css 3. info/ ] • HTML 5 [ http: //www. w 3 schools. com/html 5_reference. asp ] • Java. Script [ http: //www. w 3 schools. com/js/default. asp ] • Adobe Flash CS 4 [ http: //labs. adobe. com/technologies/flashcs 5/ ] • Action. Script 3 [ http: //www. adobe. com/devnet/actionscript/articles/actionscript 3_overview. html ] • AJAX [ http: //www. w 3 schools. com/Ajax/Default. Asp ] • PHP 5 [ http: //www. php. net/ ] • My. SQL 5 [ http: //www. mysql. com/ ] • Apache [ http: //www. apache. org/ ] • Linux [ http: //www. linux. org/ ]

Web - technologies Syndication (синдикация, одновременная публикация контента на нескольких веб-узлах) • XML [ http: //en. wikipedia. org/wiki/XML ] • RSS [ http: //en. wikipedia. org/wiki/RSS ] • RDF [ http: //en. wikipedia. org/wiki/Resource_Description_Framework ] • JSON [ http: //www. json. org/ ]

API Application Programming Interface • Twitter API [ http: //apiwiki. twitter. com/ ] • Facebook API [ http: //wiki. developers. facebook. com/index. php/API ] • Google Gadgets [ http: //code. google. com/apis/gadgets/ ] • Google Maps [ http: //code. google. com/apis/maps/ ] • Google Chart [ http: //code. google. com/apis/chart/image_charts. html ] • Google Analytics [ http: //code. google. com/apis/analytics/docs/ ]

Facebook Apps • RESTful [ http: //wiki. developers. facebook. com/index. php/API ] • FBJS [ http: //wiki. developers. facebook. com/index. php/FBJS ] • FQL [ http: //wiki. developers. facebook. com/index. php/FQL ] • FBML [ http: //wiki. developers. facebook. com/index. php/FBML ] • XFBML [ http: //wiki. developers. facebook. com/index. php/XFBML ] • Connect [ http: //developers. facebook. com/docs/? u=facebook. jslib. FB. Con nect ]

Ad Tracking • Motif [ http: //www. doubleclick. com/products/richmedia/index. aspx ] • Atlas [ http: //www. atlasrichmedia. com/ ] • Point. Roll [ http: //www. pointroll. com/ ] • Eye. Blaster [ http: //www. eyeblaster. com/ ]

Mobile • Android [ http: //www. android. com/ ] • i. Phone [ http: //developer. apple. com/iphone/index. action ]

Cloud computing

http: //www. youtube. com/watch? v=TTNg. V 0 O_o. Tg What is cloud computing in the simplest words? Cloud computing is the provision of all computing resources through the medium of the Internet. Cloud computing is about taking the client server architecture of a computer networking system to an extreme, in terms of scaling and resource sharing. A computer or any mobile device connected to a cloud computing network will have all its data, along with all the processing programs hosted on a remote server farm

http: //www. youtube. com/watch? v=NCXo. P-11 Eq. Q A user will access data and use the resources on the cloud computing servers from any terminal connected to them. Just like power is supplied to any region in a power grid, according to demand, so are the resources allocated to terminals in a cloud computing network, based on demand. The 'cloud' in cloud computing essentially stands for the Internet

Instead of installing programs on your own computer, you can access the same programs as web service applications that are made accessible via a web browser. So, any user can access and save his work or data on the cloud computing server. This provides users with the freedom to access their work from any terminal they choose to work on, which can make a remote connection with the cloud computing server network.

Cloud computing has been made possible because of the increasing high speed connectivity provided by the Internet to remote locations. The power of Internet connectivity has been harnessed to share resources on a cloud computing network. Google is one of the main players in the cloud computing business and it is aggressively promoting this concept across the globe through introduction of its own cloud computing resources.

What is Cloud Computing Used For There are several applications of cloud computing. Private cloud computing is the creation of a cloud computing network with limited access to a private network of computers. There are cloud computing companies like Amazon and Google who set up cloud computing services for private use. The reason for the popularity of cloud computing network is the economies of it. Instead of purchasing proprietary software and bearing the cost of maintenance, companies can save the cost involved by opting for a cloud computing service instead.

Cloud computing is the latest trend in information technology. It is a model, just like the model of the electricity grid, in which end-users can avail power without understanding of the technical devices in the grid. It is a structure that enables easy and on-demand access to networks, storage, servers, applications and services, all that constitute a shared pool of configured computer resources. The computing is said to be in the 'cloud' and therefore, the processing and the data is not in a specific static location

Is Cloud Computing Safe and Secure? Getting off to a slow start, cloud computing seems to be all the rage today. But as far as computers and networking is concerned, there will always be problems it will face.

The Future of Cloud Computing and Internet All the Internet technologies that are being developed, try to come up with the cliché slogan 'user-friendly'. Among those technologies, cloud computing plays a significant role in future computing business. Steve Jobs http: //www. youtube. com/watch? v=O_C 1 TZIT-q. Q&feature=fvst

How Cloud Computing Helps in Business Improvement? Let's say you have a company and a website for your organization. In few years, the number of users of your website increases. You are successful, but with success, problems can come. Your equipment can't keep up with the demand your service automatically slows down, which ultimately puts you into trouble. What could be the reason behind this? A few years ago, you would have put your website on computer and bought servers to set them up. Hundreds of companies do this, which costs them a lot of money and consumes a lot of time too. This is called 'hosting'.

You pay for these servers when you are using them, and you pay for them when you are not using them! By buying these servers, you hope for success in your business, but instead, you lose your customers and end up without any profit in your business. Is there any solution for this? Yes, the answer is cloud computing. Connect your computer to a cloud server and see what happens. You just have to pay for what you use and manage the demand by varying your utilization of the cloud resources. Cloud computing lets customers, enterprises and businesses, to use the application services without any requirement for software and hardware installation.

Applications in Cloud Computing Cloud computing software used to manage all your projects in one place as well as customer relationship management (CRM) in human resource (HR) application. A number of online office applications are also available, which include Google docs, Blist and Slide rocket, etc. This allows any user to work in these applications with any computing device with Internet connection. There are more cloud applications such as Facebook, webbased email from Yahoo or Hotmail and Google's online spreadsheets, which are easily accessible to customers. Applications like Facebook make it user-friendly too. Salesforce. com is one of the most important and successful applications in cloud computing. What companies do is that, they log on to salesforce. com and purchase the services for automating sales team and structure.

Reasons Why Cloud Computing is Popular • Scalability: The cloud servers can be utilized or released back, according to the demand of the user. • Instantaneous Availability: The resources are straightaway available in the cloud and it can be taken by just switching it on. • Saving on Money: You have to pay for only what you use in the same way like how you pay for your electricity and gas consumption.

Enterprise Cloud Markets and its potentials Cloud Computing is a technology architecture evolution which is exposed to business models, can revolutionize business. There is no need for organizations to make heavy investment in order to make available these resources but only make usage charges. This is a paradigm shift from fixed capital expenditure to Operating expense and huge funds locked up in technology spending can be diverted to address our immediate and urgent needs thereby optimal utilization of funds makes it productive. This strategic shift from investments in servers and data management, which shoot up expenses, the funds can be better utilized in human capital, purchasing advanced technology products, diversifying to new areas, research, services, marketing, etc. wherein the direct use of these funds might prove beneficial.

http: //www. youtube. com/watch? v=hpl. Xn. FUl. Pmg http: //www. youtube. com/watch? v=Sguja. Izkwr. E&feature=related

Early Adopters and their Experiences The major concern for software industry using services over the internet is Data Management. The R&D team of software majors like Amazon's Elastic Computing Cloud (EC 2) use Infrastructure-as-a-service offerings for optimal utilization of their resources. GE is treading the cloud path cautiously and prefers to hold it as it not satisfied with the legal and computer security implications of storing email attachments and data from business applications that users pull into spreadsheets on another company's servers.

Small firms and start-ups rely on cloud services to cut costs and help them focus on their core services and products. It helps smaller firms to leverage the cloud with huge investment outlays. Cloud computing is easier and quick to adopt, cheaper cost to company with minimum upfront capital investment, lower staff resource requirements, flexibility, scalability and, last but the least, risk reduction.

• • • cost http: //www. youtube. com/watch? v=bn 40 Ki. Bk 88 U&feature=related http: //www. youtube. com/watch? v=Q 3 X 7 mm. Kf. GQY http: //www. youtube. com/watch? v=kvmega 8 om 2 U&feature=related

• e-learnig • http: //www. youtube. com/watch? v=bm. ZL-5 h 5 ze. E&feature=related

http: //www. youtube. com/watch? v=2 -nt. LGOy. Hw 4 • SJ