abclearn-blog

[abclearn-blog]

What is CRM?

      Customer relationship management (CRM) is an approach to manage a company's interaction with current and future It analyzes below and helps organizations to drive Sales growth.

About customers' history with a company,

How to improve business relationships with customers,

Specifically focusing on customer retention.

[abclearn-blog]

Creating the Package in Cognos

Now the main part is to select the tables from the data source for creating the package

[abclearn-blog]

Types of Virtualization:

Server virtualization

Desktop virtualization

Application virtualization

Network virtualization

Storage virtualization

Although there is a variety of virtualization as listed above, we will focus more on server & Desktop virtualizations only.

[abclearn-blog]

cipal switch for a small storage area network (SAN) and continue to use it as a building block as the SAN grows.

[abclearn-blog]

Introducing Visual Studio

About Visual Studio:

Visual Studio is nothing but the Visual IDE (Integrated Development Environment), which is needed to development applications with .NET Framework.

.NET Framework is execution environment of .Net Programs where as VS.NET is just an editor tool used to write .Net code or develop applications using .net framework.

[abclearn-blog]

What is Multi-tier Architecture?

Multi-tier architecture means application is separated into multiple or n number of tiers. It is a client–server architecture in which presentation, application processing, and data management functions are physically separated.

Applications are most commonly broken into three different tiers,

Presentation Tier

Business/Application Tier

Data Tier

Above three layers works together as single application and they also can operate independently.

One of the examples of 3-tier architecture is online shopping cart (Amazon/Flipkart) where we are having User Interface which will have products (Presentation Layer), business logic to handle orders/search/update operations and database (data tier) to store user and order information. Business logic and Database implementations are hidden to user.

Presentation tier:

This is topmost level of the application and provides services that display data to end users, allowing users to process and manipulate the presentation.

For example, online shopping cart user interface(UI). These are web pages that the customer uses to browse the store, place orders, register on the site, view order information, and update the user profile/order information.

Business service tier:

This is the second tier which controls application functionality and holds business logic. It provides back-end services that typically retrieve data from the data tier to provide to other services within the presentation or business service tiers.

For example, online shopping cart business logic to handle placed orders/existing order/user information. When we submit new order using UI, following sequence will occur to complete order.

UI writes order to DB and new order event will be triggered.

Order process service will receive this event and start processing the order which includes verification of user information, credit card details, purchase amount for authorization/approval and product.

Once order is approved, order information will be sent to suppliers to obtain bid. Once bid is received, business rule chooses supplier with lower bid and authorize for fulfillment.

Once order is fulfilled, business logic sets order status to complete and notification (SMS/Email) will be sent to customer with order details.

Data tier:

Provides database services accessed by services within business service tier. Data tier includes the data persistence mechanisms and the data access layer that encapsulates the persistence mechanisms and exposes the data.

For example, online shopping cart database which is used to store order information, status, user, credit card, suppliers details.

Benefits of n-tier Architecture:

Improved Security: n-tier architecture let us enforce security differently for each tier. For example business logic and data tier requires more security than presentation tier. Multi-tier architecture gives us full control of security on each layer.

Scalability: Multitier architecture let us to scale individual tier as needed. For example, we can scale up data tier with database clustering without touching other two tiers.

Simple Maintenance: It’s easier to maintain. Different people can manage single tier without the risk of touching other tiers. For example, we want web designer to work on presentation layer but we don’t want him to touch business or data layer.

Easy Enhancement: Multitier architecture let us easily upgrade and modify applications. We can do it on individual layer separately without touching the other layers. For example, we can add additional DB to data layer or we can add additional buiness rules to business logic tier.

Reusability: It helps us to reuse services with common functionality. For example, web services.

Web/Presentation Tier: The Web tier consists of components like WebCache and Oracle HTTP Server which protect resources and control access to applications.

Mid/Business Logic Tier: The Middle tier runs Oracle WebLogic Server, which hosts the security Service Provider Interfaces (SPIs) and APIs. Oracle Fusion Middleware components such as Oracle SOA Suite, Oracle WebCenter, and Oracle Web Services Manager operate in the middle tier.

Data Tier: The data tier is the repository for LDAP directories and databases, such as Oracle Internet Directory, Oracle Virtual Directory, and Oracle Database.

[abclearn-blog]

What is Autosys?

In simple terms,

Autosys is an automated job control system for scheduling,monitoring and reporting jobs.

The jobs can reside on an Autosys configured machine attached to a network.

Before getting more details about autosys, let's try to understand some basics terms of it.

Let’s understand, What is meant by Job on a system?

The job is nothing but a particular activity on a system.

For Example, I want to copy a particular file on Unix/Windows machine from one directory to another one. This is considered as activity/task. It involves a manual process of executing a command on that machine. But using (cron job or Windows-AT) we can automate it based on time.

What is Cron tab & Windows-AT? Explain about them?

One may have a question why we require a third party software when this can be achieved through cron Utility in Unix. Cron indeed a feature available in Unix but still it lacks some of the functionalities like job dependencies, run window,calendar features(You will learn about these in coming sessions)

Why do we need Autosys?

As we have discussed above, most basic job scheduling is done using Unix - cron (or windows - AT), which is time-based. It will fire the job based on the clock.

However, in real business, you need to fire jobs not just based on scheduled time, but also based on events (like an arrival of a file), and, based on the success or failure of other jobs.

Autosys is a total job scheduling solution that allows you to define these events, dependencies, time schedules, alerts, etc, making it a complete data center automation tool.

A reliable, easy to use the system that enables the user to completely manage their entire Job Processing requirements.

This is a product from Computer Associates.

What is an Autosys-job?

An autosys job can be,

A single command executed on a validated machine, (command, in turn, could have multiple tasks).

Autosys-jobs can be defined using Graphical User interface (GUI) or Job Information Language (JIL).

Any single command, executable script or NT batch file. It includes a set of qualifying attributes ,conditions specifying when and where an autosys-job should be run.

[abclearn-blog]

Getting started with Cognos Framework Manager

Framework Manager is a metadata modeling tool that drives query generation for IBM Cognos software. A model is a collection of metadata that includes physical information and business information for one or more data sources.

Whenever we start creating a model, we need to understand the requirement first and then we can choose whether to go for star schema or snowflake schema or just a relational schema.

While creating a framework manager metadata model we will come across the below terms:

Project: A project contains a model, namespaces, packages, data sources, and related information for maintaining and sharing model information. The project will be saved as a .cpf file and an XML file which defines the project.

Different terms associated with Framework Manager:

Models: Model contains your dimension tables, fact tables, and the related join information.

A framework manager model is a metadata layer between your database and the reporting applications. Using Model, we can create dimension tables, fact tables and even create filters.

Namespace: A namespace uniquely identifies query items, dimensions, query subjects, and other objects. You import different databases into separate namespaces to avoid duplicate names.

Packages: A package is a subset of the dimensions, query subjects, and other objects defined in the project. A package is what is actually published to the IBM Cognos BI server, and it is used to create reports, analyses, and ad hoc queries.

Dimensions: A dimension is a broad grouping of data about a major aspect of a business, such as products, dates, or markets.

Query Subjects: A query subject is a set of query items that have an inherent relationship. In most cases, query subjects behave like tables. Query subjects produce the same set of rows regardless of which columns were queried. There are different types of query subjects which we can learn going further.

Query Items: A query item is the smallest piece of the model that can be placed in a report. It represents a single characteristic of something, such as the date that a product was introduced. Query items are contained in query subjects or dimensions. For example, a query subject that references an entire table contains query items that represent each column in the table.

[abclearn-blog]

Desktop Virtualization software

VMware Workstation: -

1999, the first product launched by VMware.

This software suite allows users to run multiple instances of x86 or x86-64 -compatible operating systems on a single physical PC.

Latest version is Vmware Workstation Pro v12 as of 2016.

VMware Fusion: -

It provides similar functionality for users of the Intel Mac platform, along with full compatibility with virtual machines created by other VMware products.

VMware Player: -

It was a freeware for non-commercial use.  It doesn’t require any license purchase just like VMware Workstation or VMware Fusion.

If needed Vmware player also available for commercial use with permission.

Note:

Vmware player doesn’t have full-fledged functionality that of VMware workstation.

Vmware player and Vmware workstation version are never the same.

Player 7 coexisted with Workstation 11.

After version 7.10, VMware Player was replaced by VMware Workstation Player version 12.  It is falling short of some of the features of full Workstation Pro.

Server virtualization software

VMware has produced two virtualization products for servers:

VMware vSphere (also called "ESXi")

An enterprise-level product, can deliver greater performance than the freeware VMware Server, due to lower system overhead.

VMware ESXi, as a "bare-metal" product, runs directly on the server hardware. It allows virtual servers also to use hardware more or less directly.

In addition, VMware ESXi integrates into VMware vCenter, which offers extra services

VMware Server (formerly called "GSX Server"; obsolete as of 2011)

It was also provided free of charge for non-commercial use, like VMware Player, and can also set up virtual machines.

As a "hosted" application, VMware Server runs within an existing Linux or Windows operating system.

Cloud management software

VMware vRealize Suite - a cloud management platform purpose-built for the hybrid cloud.

VMware EVO SDDC - EVO SDDC provides an easy way to deploy and operate a private cloud on an integrated SDDC system.

VMware Go - was a web-based service to guide users of any expertise level through the installation and configuration of VMware vSphere Hypervisor. Its end of life was in early 2014.

Public cloud platform

VMware vCloud Air

Virtual desktop infrastructure

VMware Horizon View, a virtual desktop infrastructure (VDI) solution.

Application management

VMware Workspace Portal - a self-service app store for workspace management

Storage solutions

VMware VSAN (Virtual Storage Area Network), version 6.2 released in early 2016

Backup software

In April 2011, EMC transferred control of Mozy to VMware. Mozy produced MozyHome and MozyPro.

MozyHome is the consumer version of the Mozy backup service. It is available to buy on a monthly subscription.

MozyPro is the business version of the Mozy backup service. MozyPro requires a separate license for each computer that is being backed up, as well as a server license for any server that is being backed up.

Customers then pay per gigabyte of data they have in the data center.

Networking and security products

vCloud Networking and Security - a software-defined networking and security solution, as of 18 April 2014 was superseded by VMware NSX, VMware's product for the software-defined data center (SDDC).

[abclearn-blog]

SQL Stands for Structured Query Language

SQL is a language to perform actions on databases like MYSQL, OracleDB, MongoDB, SQL Server etc.,

SQL is an ANSI Standard.

All Database use SQL as the standard database language.

Note: SQL is just a language, not a database where most people get confused by it as a database.

[abclearn-blog]

Types of Virtualization:

Server virtualization

Desktop virtualization

Application virtualization

Network virtualization

Storage virtualization

Although there is a variety of virtualization as listed above, we will focus more on server & Desktop virtualizations only.

[abclearn-blog]

Issue Description:

When I tried to rebuild one of the indexes I received the following error:

SQL> alter index I_WRI$_OPTSTAT_H_ST rebuild;

alter index I_WRI$_OPTSTAT_H_ST rebuild

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-01502: index 'SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST' or partition of such index is in unusable state.

[abclearn-blog]

Middleware is a software that provides a facility to integrate several discrete services/systems into an end to end flow and help to eliminate the pain of integration. In simple words, it’s a software glue that holds applications together and helps to make seamless communication.

[abclearn-blog]

What is Multi-tier Architecture?

Multi-tier architecture means application is separated into multiple or n number of tiers. It is a client–server architecture in which presentation, application processing, and data management functions are physically separated.

[abclearn-blog]

Issue Description:

          While taking the RMAN Backup, its get failed since the database is not registered in the catalog.

[abclearn-blog]

MQMD generally stands for "Message Queuing Message Descriptor". It explains the characteristics of application message placed in the queue.

Every message in the queue should have MQMD property associated with it.

MQMD is set of attributes describing the characteristic of the message. These properties/attributes won't change, irrespective of the type of application which is putting messages.

MQMD properties are filled up by either application team or generated by queue manager automatically.

[abclearn-blog]

Oracle database are logically divided into one or more tablespaces. An oracle tablespace is a logical entity that contains the physical datafiles. Tablespaces are store in all the usable data of the database and the data in the tablespace are stored in one or more datafiles. Datafiles are Oracle-formatted operating system files. Oracle creates a datafile for a tablespace when you specify the keyword DATAFILE during tablespace creation