martes, 10 de mayo de 2011

Promedio de numeros en C#

para explicarles en un ejemplo mas practico de como utilizar los eventos del textbox, vamos a hacerr una pequeña aplicacion la cual permita ingresar 3 notas entre 0 y 20 y al pulsar el boton Calcular nos va promediar las 3 notas ingresadas en un cuarto TextBox, el formulario es el siguiente:
para darle una mejor apariencia al cargar el formulario vamos a elegir en la Propiedad StartPosicion CenterScreen para que el formulario cargue en el centro de nuestra pantalla ya sea en cualquier resolucion, tambien se podria hacer por coordenadas pero esta propiedad lo hace mejor y mas rapido:



ahora en los 3 textbox vamos a la Propiedad MaxLenght y vamos a poner 2 para evitar que se escriban numeros como 100, 200 los cuales no son admitidos en esta aplicacion que solo va a permitir notas entre 0 y 20:
ahora dado que los 3 textbox van a validar numeros vamos a poner este codigo para que lo escriban en el evento KeyPress:
if (e.KeyChar >= 48 && e.KeyChar <= 57)//estos son los valores ASCII admitidos x ser numeros
{
}
else if (e.KeyChar == (char)(Keys.Enter))//aqui controlamos la pulsacion del Enter
{
    if (textBox1.Text == string.Empty || textBox1.Text == "")//aqui validamos si el textbox esta vacio
   {
      MessageBox.Show("No se permite campo vacio");
      e.Handled = true;
      this.ActiveControl = textBox1;//aqui forzamos a mantener el foco activo en el textbox
      return;
    }
   else
   {
     this.ActiveControl = textBox2;//si se ingreso los numeros, pasa el foco al textbox2
   }
}
else
{
    MessageBox.Show("Solo se permiten numeros");
    e.Handled = true;
    return;
}

este codigo lo vamos a escribir 3 veces para TextBox1_KeyPress, TextBox2_KeyPress y para TextBox3_KeyPress.
ojo fijense cuando lo copien de cambiar la propiedad ActiveControl la cual va a cambiar de acuerdo al textbox que lo pongan, por ejemplo para el textbox3 el segundo ActiveControl tendran que poner un button ya que al dar enter se espera que el boton se active.
Ahora para controlar el ingreso de numeros menores a 20 vamos a utilizar otro evento del Textbox, el cual va a ser TextChanged.

ahora en este evento vamos a escribir este codigo:

private void textBox1_TextChanged(object sender, EventArgs e)
{
  if (textBox1.Text.Length == textBox1.MaxLength)
  {
     if (Convert.ToInt32(textBox1.Text) > 20)//aqui validamos numeros mayores a 20
    {
MessageBox.Show("La Nota es entre 0 y 20", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information);
      this.textBox1.Clear();
      this.ActiveControl = this.textBox1;
    }
    else
   {
   }
}
else if (textBox1.Text.Length == 1)
{
    if (textBox1.Text[0] == '0')//aqui impedimos que se ingresen numeros con 0 a la izquierda
   {
      textBox1.Clear();
   }
}
}

ahora en el boton calcular solo ponen este codigo y listo...
int a, b, c;
double promedio;
a = int.Parse(textBox1.Text);
b = int.Parse(textBox2.Text);
c = int.Parse(textBox3.Text);
promedio= (a+b+c)/3;
textBox4.Text = promedio.ToString();
if (promedio > 10.5)
{
textBox4.ForeColor = Color.Blue;
}
else
{
textBox4.ForeColor = Color.Red;
}
 
con esto al escribir las notas les aparecera asi:
 
espero les haya servido..

Cerrar formulario de C# con boton

¿Que tal si para mejorar la apariencia de nuestro formulario creamos un boton Cerrar en lugar de utilizar la clasica X roja que aparece en la parte derecha superior de las ventanas?
Para esto arrastramos un boton de nuestro Cuadro de Herramientas.


Ahora con el boton en el formulario damos doble click, para escribir el siguiente codigo en el evento Click del Boton
private void button1_Click(object sender, EventArgs e)
{
Application.Exit();//solo copien y peguen este codigo el de arriba les aparecera al dar doble click en el boton
}
y cuando ejecuten su formulario, al pulsar este boton se cierra su aplicacion. Espero les sirva :)

Validacion de Textbox solo texto en C#

Aca les traigo un codigo que admite ingreso de caracteres de texto incluyendo la ñ.
Para esto en el evento KeyPress del TextBox escriben este codigo (el codigo hace validaciones ASCII de las teclas pulsadas):

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)

{
   if ((e.KeyChar >= 65 && e.KeyChar <= 90) || (e.KeyChar >= 97 && e.KeyChar <= 122) || e.KeyChar == 8 || e.KeyChar == 32 || e.KeyChar == 'ñ' || e.KeyChar == 'Ñ')
e.Handled = false;
else
  {
  MessageBox.Show("Solo se permite texto");
  this.ActiveControl = textBox1;
  e.Handled = true;
  }
}
 

Validacion de TextBox para ingresar numeros WinForm C#

hola aca les traigo un codigo muy util para que puedan validar sus Forms de C# para ingresar numeros por ejemplo notas, dinero o peso a un TextBox.
Para esto vamos a crear un nuevo proyecto:
Ahora vamos a poner un TextBox:
Ahora lo seleccionamos y lo arrastramos al area del Form y lo soltamos (Drag & Drop). Una vez soltado lucira algo asi:

Ahora vamos al evento KeyPress del Textbox (para esto damos click en el textbox y en propiedades buscamos el simbolo de rayito, ahi encontramos todos los eventos del Textbox, pero en este tuto explicare solo el KeyPress)
Ahora una vez aqui se situan a la derecha del KeyPress y dan doble click, les saldra una ventana de codigo asi:

una vez aqui entre los 2 corchetes proceden a escribir este codigo (la forma utilizada aca fue obteniendo el valor ASCII de la tecla pulsada):
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
  if (e.KeyChar >= 48 && e.KeyChar <= 57)
  {
  }
  else
  {
     MessageBox.Show("Solo se permiten numeros");
     e.Handled = true;
     return;
   }
}

ahora ejecutan(F5) y van a ver que al pulsar una letra les va a aparecer este mensaje:

espero les haya servido el codigo, hasta luego...

miércoles, 4 de mayo de 2011

INCOTERMS

Definición:
Los Incoterms son un conjunto de reglas internacionales, regidos por la Cámara de Comercio Internacional, que determinan el alcance de las cláusulas comerciales incluidas en el contrato de compraventa internacional.
Los Incoterms también se denominan cláusulas de precio, pues cada termino permite determinar los elementos que lo componen. La selección del Incoterm influye sobre el costo del contrato.
El propósito de los Incoterms es el de proveer un grupo de reglas internacionales para la interpretación de los términos mas usados en el Comercio internacional.
Los Incoterms determinan:
  • El alcance del precio. 
  • En que momento y donde se produce la transferencia de riesgos sobre la mercadería del vendedor hacia el comprador. 
  • El lugar de entrega de la mercadería. 
  • Quién contrata y paga el transporte.
  • Quién contrata y paga el seguro. 
  • Qué documentos tramita cada parte y su costo.
CFR (Cost and Freight) - Costo y Flete (puerto de destino convenido)
Para el vendedor los alcances son los mismos que la cotización FOB con la única diferencia de que la empresa debe encargarse de contratar la bodega del barco y pagar el flete hasta destino.
El riesgo de pérdida o daño de las mercaderías así como cualquier coste adicional debido a eventos ocurridos después del momento de la entrega, se transmiten del vendedor al comprador El término CFR exige al vendedor despachar las mercaderías para la exportación.
Este término puede ser utilizado sólo para el transporte por mar o por vías navegables interiores.
Obligaciones del Vendedor.
  • Entregar la mercadería y documentos necesarios 
  • Empaque Y Embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes) 
  • Flete (de lugar de exportación al lugar de importación)
Obligaciones del Comprador.
  • Pago de la Mercadería 
  • Gastos de importación (maniobras, almacenaje, agentes) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Flete y seguro (lugar de importación a planta) 
  • Demoras
CIF (Cost, Insurance and Freight) - Costo, Seguro y Flete (puerto de destino convenido)
Significa que el vendedor entrega la mercadería cuando esta sobrepasa la borda del buque en el puerto
de embarque convenido. El vendedor debe pagar los costos y el flete necesarios para conducir las mercaderías al puerto de destino convenido.
En condiciones CIF el vendedor debe también contratar un seguro y pagar la prima correspondiente, a fin de cubrir los riesgos de pérdida o daño que pueda sufrir la mercadería durante el transporte.
El comprador ha de observar que el vendedor está obligado a conseguir un seguro sólo con cobertura mínima. Si el comprador desea mayor cobertura necesitará acordarlo expresamente con el vendedor o bien concertar su propio seguro adicional. El término CIF exige al vendedor despachar las mercaderías para la exportación. Este término puede ser utilizado sólo para el transporte por mar o por vías navegables interiores.
Obligaciones del Vendedor
  • Entregar la mercadería y documentos necesarios
  • empaque y embalaje 
  • Flete (de fábrica al lugar de exportación)
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes ) 
  • Flete y seguro(de lugar de exportación al lugar de importación)
Obligaciones del Comprador.
  • Pago de la mercadería 
  • Gastos de importación (maniobras, almacenaje, agentes ) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Flete y seguro (lugar de importación a planta) 
  • Demoras
CIP (Carriage and Insurance Paid to) - Transporte y Seguro Pago Hasta (lugar de destino convenido)
El vendedor entrega las mercaderías al transportista designado por él pero, además, debe pagar los costos del transporte necesario para llevar las mercaderías al destino convenido. El vendedor también debe conseguir un seguro contra el riesgo, que soporta el comprador, de pérdida o daño de las mercaderías durante el transporte.
El comprador asume todos los riesgos y con cualquier otro coste ocurridos después de que las mercaderías hayan sido así entregadas.
El CPT exige que el vendedor despache las mercaderías para la exportación. Este término puede emplearse con independencia del modo de transporte, incluyendo el transporte multimodal.
Obligaciones del Vendedor
  • Entregar la mercadería y los documentos necesarios
  • Empaque y embalaje
  • Flete (de fábrica al lugar de exportación)
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Gastos de exportación (maniobras, almacenaje, agentes )
  • Flete y seguro (de lugar de exportación al lugar de importación)
  • Gastos de importación (maniobras, almacenaje, agentes ) "Parcial"
Obligaciones del Comprador
  • Pago de la mercadería 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Flete y Seguro (lugar de importación a planta) 
  • Gastos de importación (maniobras, almacenaje, agentes ) "Parcial" 
  • Demoras
CPT (Carriage Paid To) - Transporte Pagado Hasta (lugar de destino convenido)
El CPT exige que el vendedor despache las mercaderías para la exportación. Este término puede emplearse con independencia del modo de transporte, incluyendo el transporte multimodal.
El vendedor entrega las mercaderías al transportista designado por él pero, además, debe pagar los costos del transporte necesario para llevar las mercaderías al destino convenido. El comprador asume todos los riesgos y con cualquier otro coste ocurridos después de que las mercaderías hayan sido así entregadas.
Obligaciones del Vendedor
  • Entregar la mercadería y los documentos necesarios 
  • Empaque y embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes) 
  • Flete (de lugar de exportación al lugar de importación)
  • Gastos de importación (maniobras, almacenaje, agentes ) "Parcial"
Obligaciones del Comprador
  • Pago de la mercadería 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Flete y Seguro (lugar de importación a planta) 
  • Gastos de importación (maniobras, almacenaje, agentes ) "Parcial" 
  • Demoras
DAF (Delivered At Frontier) - Entregadas en Frontera (lugar convenido)
Significa que el vendedor ha cumplido su obligación de entregar cuando ha puesto la mercancía
despachada en la Aduana para la exportación en el punto y lugar convenidos de la frontera pero antes
de la aduana fronteriza del país comprador.
Este término puede emplearse con independencia del modo de transporte cuando las mercaderías deban
entregarse en una frontera terrestre.
Obligaciones del Vendedor
  • Entregar la mercadería y documentos necesarios
  • Empaque y embalaje
  • Flete (de fábrica al lugar de exportación)
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Gastos de exportación (maniobras, almacenaje, agentes )
  • Flete (de lugar de exportación al lugar de importación)(parcial)
  • Seguro (parcial)
Obligaciones del Comprador
  • Pagos de la Mercadería
  • Flete (de lugar de exportación al lugar de importación) (parcial)
  • Seguro (parcial)
  • Gastos de importación (maniobras, almacenaje, agentes )
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Flete y seguro (lugar de importación a planta)
  • Demora
DDP (Delivered Duty Paid) - Entregadas Derechos Pagados (lugar de destino convenido)
Significa que el vendedor entrega las mercaderías al comprador, despachadas para la importación, y no
descargadas de los medios de transporte utilizados en el lugar de destino acordado.
El vendedor debe asumir todos los costos y riesgos ocasionados al llevar las mercaderías hasta aquel
lugar, incluyendo los trámites aduaneros, y el pago de los trámites, derechos de aduanas, impuestos y
otras cargas para la importación al país de destino.
Obligaciones del vendedor
  • Entregar la mercadería y documentos necesarios
  • Empaque y embalaje
  • Acarreo (de fábrica al lugar de exportación)
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Gastos de exportación (maniobras, almacenaje, agentes )
  • Flete (de lugar de exportación al lugar de importación)
  • Seguro
  • Gastos de importación (maniobras, almacenaje, agentes )
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Acarreo y seguro (lugar de importación a planta)
  • Demoras
Obligación del comprador
  • Pagar la mercadería
DDU (Delivered Duty Unpaid) - Entregadas Derechos No Pagados (lugar de destino convenido)
Significa que el vendedor ha cumplido su obligación de entregar cuando ha puesto la mercancía a disposición del comprador en el lugar convenido del país de importación y el Vendedor ha de asumir todos los gastos y riesgos relacionados con llevar la mercancía, hasta aquel lugar (excluidos derechos, impuestos y otros cargos oficiales exigibles a la importación). Así como los gastos y riesgos de llevar a cabo las formalidades aduaneras.
Obligaciones del Vendedor
  • Entregar la mercadería y documentos necesarios 
  • Empaque y embalaje 
  • Flete (de fábrica al lugar de exportación)
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Gastos de exportación (maniobras, almacenaje, agentes )
  • Flete y seguro (de lugar de exportación al lugar de importación
Obligaciones del Comprador
  • Pago de la mercadería
  • Gastos de importación (maniobras, almacenaje, agentes )
  • Aduana (documentos, permisos, requisitos, impuestos)
  • Flete y seguro (lugar de importación a planta)
  • Demoras
DEQ (delivered Ex-Quay) - Entregadas en Muelle (puerto de destino convenido)
Significa que el vendedor entrega cuando se ponen las mercaderías a disposición del comprador, sin despachar para la importación, en el muelle (desembarcadero) en el puerto de destino acordado. El vendedor debe asumir los costos y riesgos ocasionados al conducir las mercaderías al puerto de destino
acordado y al descargar las mercaderías en el muelle (desembarcadero). El término DEQ exige que el
comprador despache las mercaderías para la importación y que pague todos los trámites, derechos,
impuestos y demás cargas de la importación.
Obligaciones del Vendedor
  • Entregar la mercadería y documentos necesarios 
  • Empaque y embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes) 
  • Flete y seguro (de lugar de exportación al lugar de importación) 
  • Aduana (documentos, permisos, requisitos, impuestos)
Obligaciones del Comprador
  • Pago de la mercadería 
  • Flete y seguro (lugar de importación a planta) 
  • Gastos de importación (maniobras, almacenaje, agentes) 
  • Demoras 
Este término puede usarse únicamente para el transporte por mar o por vías de navegación interior o para el transporte multimodal

DES (Delivered Ex Ship) - Entregadas Sobre Buque (puerto de destino convenido)
Significa que el vendedor entrega cuando se ponen las mercaderías a disposición del comprador a bordo del buque, no despachadas para la importación, en el puerto de destino acordado.
Obligaciones del Vendedor
  • Entregar la mercadería y documentos necesarios 
  • Empaque y embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes ) 
  • Flete y seguro (de lugar de exportación al lugar de importación)
Obligaciones del Comprador
  • Pago de la mercadería 
  • Gastos de importación (maniobras, almacenaje, agentes ) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Acarreo y seguro (lugar de importación a planta) 
  • Demoras
EXW (Ex-Works) - En Fábrica (lugar convenido)
Significa que el vendedor entrega cuando pone la mercadería a disposición del comprador en el establecimiento del vendedor o en otro lugar convenido (es decir, fábrica, almacén, etc.).
Este término representa, así, la menor obligación del vendedor, y el comprador debe asumir todos los costos y riesgos.
Obligaciones del Vendedor.
  • Entrega de la mercadería y documentos necesarios 
  • Empaque y embalaje
Obligaciones del Comprador.
  • Pago de la mercadería 
  • Flete interno (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes )
  • Flete internacional (de lugar de exportación al lugar de importación)  
  • Seguro 
  • Gastos de importación (maniobras, almacenaje, agentes ) 
  • Transporte y seguro (lugar de importación a planta)
FAS (Free Along Ship) - Libre al Costado del Buque (puerto de carga convenido)
Significa que la responsabilidad del vendedor finaliza una vez que la mercadería es colocada al costado del buque en el puerto de embarque convenido. Esto quiere decir que el comprador ha de asumir todos los costos y riesgos de pérdida o daño de las mercaderías desde aquel momento.
El término FAS exige al vendedor despachar las mercaderías para la exportación.
Obligaciones del Vendedor
  • Mercadería y Documentos Necesarios 
  • Empaque Y Embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos De Exportación (maniobras, almacenaje, agentes ) 
Obligaciones del Comprador
  • Pagos de la mercadería 
  • Flete y seguro (de lugar de exportación al lugar de importación) 
  • Gastos de importación (maniobras, almacenaje, agentes) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Seguro y flete (lugar de importación a planta) 
  • Demoras
FCA (Free Carrier) - Libre Transportista (lugar convenido)
Significa que el vendedor entrega la mercadería para la exportación al transportista propuesto por el comprador, en el lugar acordado.
El lugar de entrega elegido influye en las obligaciones de carga y descarga de las partes. Si la entrega tiene lugar en los locales del vendedor este es responsable de la carga. Si la entrega ocurre en cualquier otro lugar, el vendedor no es responsable de la descarga.
Este término puede emplearse en cualquier medio de transporte incluyendo el transporte multimodal.
Obligaciones del vendedor.
  • Entrega de la Mercadería y documentos necesarios 
  • Empaque y embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes)
Obligaciones del comprador
  • Pagos de la mercadería 
  • Flete (de lugar de exportación al lugar de importación) 
  • Seguro 
  • Gastos de importación (maniobras, almacenaje, agentes) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Flete y seguro (lugar de importación a planta) 
  • Demoras
FOB (Free On Board) - Libre a Bordo (puerto de carga convenido)
La responsabilidad del vendedor termina cuando las mercaderías sobrepasan la borda del buque en el puerto de embarque convenido. El comprador debe soportar todos los costos y riesgos de la pérdida y el daño de las mercaderías desde aquel punto.
El término FOB exige al vendedor despachar las mercaderías para la exportación.
Este término puede ser utilizado sólo para el transporte por mar o por vías navegables interiores.
Obligaciones del vendedor
  • Entregar la mercadería y documentos necesario 
  • Empaque y embalaje 
  • Flete (de fábrica al lugar de exportación) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Gastos de exportación (maniobras, almacenaje, agentes)
Obligaciones del Comprador
  • Pago de la mercadería 
  • Flete y seguro (de lugar de exportación al lugar de importación) 
  • Gastos de importación (maniobras, almacenaje, agentes) 
  • Aduana (documentos, permisos, requisitos, impuestos) 
  • Flete (lugar de importación a planta) 
  • Demoras

martes, 3 de mayo de 2011

Data Warehouse - The Source of Business Information

Abstract
Recently the role and importance of database application in supporting the decision making process has been still increasing. Data warehouse can be an answer for this challenge. Data collected in a warehouse deliver different information e.g. about market, demand, selling goods, trends, anomalies on market. The paper presents data warehouse as a potential source of business information.

Introduction
The economic activity in dynamically changing environment puts high demands in front of enterprise that may have decisive impact on its development as well as on its possibility to participate in a competitive market game. Permanently changing environment and increase of competition have been reflected in strategic, tactic and also operational activities. Due to this the enterprise tries to implement the newest technologies to be more competitive and gain a market success. There are many different databases in enterprise that are often not compatible and from which only some information are of important value. Sometimes carrying out complex analysis on data coming from different information systems is very difficult or impossible. The data warehouse concept helps to overcome these problems. The data warehouse is a set of key information that
can be used in enterprise management. This information can be of great value e.g. within carrying a promotion campaign or when deciding about the level of goods in a storehouse.
The enterprise value can be measured by the capacity of database collecting information about e.g. clients and the ability to use it. Along with the development of information technology, data gathered on different carriers have been one of the most important values in enterprise. Along with the enterprise development and its often reorganizations, data consolidation becomes a more and more complicated process. Usually business data are created and stored in many places that also may cause difficulties in the analysis creation. Oracle Warehouse Builder (OWB) is a tool that makes this process easier. It enables joining different data sources and transforming necessary to their unification. OWB manages the data store as well and integrates it with the analytic tools assuring that data are uniform and actual.

Business Information
There are some basic definitions met in the literature that mean more or less the same: economic information, managerial information, business information.
As “an economic information” we can understand (Czerniak, 1996):
  • Knowledge of the observer about the economic system and its environment,
  • Content: quantitative and qualitative characteristics of the economic system components,
  • The whole of the related components of the economic system,
  • Knowledge about the economic object necessary for the observer to solve a particular task, 
  • Knowledge decreasing the indefinite situation in economic system when solving a task.
The glossary of mathematics and economic cybernetics (Fiedorenko, 1985, p.194) defines the term economic information as “information about social processes of production, share and exchange as well as consumption of material goods”. This definition is not very precise. Other definition says that managerial information is information about economic sciences achievements and their implementations in economic practice. According to J. Olenski “economic information sensu stricte is any information that is the complex economic object or the economic category; features are the economic category gauges measured on these objects”(Olenski, 2001). For example, for the object enterprise, the economic information is a production value, profit, credits, etc.
The objects of business information are processes, events or any other economic phenomena. The subject of economic information (the user) is an economically active unit conducting economic activity covering decision undertaking and being an object of influences of other social and economic subjects. Economic information is formulated in economic language and it causes results of business nature. It is any information that is an integral component of the economic system (Januszko, 2003).
In economic systems where the exchange and partition of goods and services are the basic functions, technical and business information dominates in contacts between the economic objects. It is also basic information asset in commodity turnover and in financial sector. The higher level of management system, the more important is economic information in relation to the other sorts of information (e.g. technical information). Economic information dominates at the macroeconomic level. Economic and production process control has been realized by technical information. Business information is applied first of all to making social-economic analysis and is often of great importance when decision making. A concrete decision has been always expressed as business and technical-economical information.
Information and knowledge should be actual and of high quality because they are very important competitive factors. The enterprise has difficult task to overcome. It must collect information and knowledge and it must be able to use it properly to have the advantage over other enterprises and to survive on dynamically changing market.
The fast development of information systems covers as well the technologies that support management in enterprises. We can observe that nowadays the process from data to wisdom is getting more and more important. Within it the following are realized: acquirement, collecting, updating, sharing and operating of information assets. Knowledge that is a subject of this process usually possesses many sources. (See Figure 1.) The managers everyday undertake many decisions influencing the success (or its lack) of the enterprise.
The decision making process requires not only knowledge and information but also imagination and knowing the context due to the fact that it is a complex process joining the today enterprise activity with it past activity. Information has been collected in databases. The enterprise environment is being permanently changing, with high level of risk and uncertainty. In such a situation the decision making process requires from the manager possessing large knowledge,
wisdom and thinking. The information systems keep data and enable registration of all updates. The basic problems transactions and the speed of information searching. Applications of this type are called operational here are, among the others, maintenance of integrity of changed data (the integrity chains, ones and the databases – operational databases. Besides this type of applications, there are also analytical applications having as a main goal the drawing information from data about patterns, business trends that can support the decision making. Adequately processed (and situated in a context) data are becoming information. Modern technology and IT enable transformation of information into knowledge. Wisdom can be treated as a way of seeing the problem or phenomena from many different perspectives and manifest itself in even acceptance of knowledge and ignorance. Intelligent supporting decision making systems emphasis on modern methods and techniques of information processing (data warehouses, Data Mining, OLAP) that support the decision-maker in different areas e.g. in management.
Data Warehouse
As a data warehouse we understand a collection of data that is:
  • “subject-oriented, 
  • integrated, 
  • nonvolatile, 
  • time-variant”
and it supports the management’s decisions (Inmon, 2002, p.54). Data warehouses (DW) are not database systems in traditional understanding this term. They differ from databases among other things with e.g. data models, entering information methods, processing models, query optimization algorithms, visualization techniques (Grothe&Gentsch, 2000). Transformation from data to knowledge has been presented in Figure 2.
Systems and applications based on the Oracle databases are created for processing a very large amount of information and for supporting the decision making processes. A warehouse can be treated as a specific central database where many different types of databases as e.g. copies of operational databases with data from the past, aggregated data (with the possibility to divide them into different dimensions), metadata. DW integrates the enterprise data that are processed using analytical applications within the decision support systems. Data that have been gathered within the data warehouse ought to be specifically prepared for further use in data warehouse. Such a preparation process must be correctly designed. Oracle Warehouse Builder (OWB) is a tool that can be used to create and design a data warehouse. The ETL (Extraction, Transformation, Loading) tools are complex integrated environments enhanced by the functionality and different data type drivers. There are many methods of exchanging data between data sources and target data warehouse. Many producers of integration tools encourage potential users to implement their products,.especially in a situation where the data flow prepared in different formats and data are coming from different systems. Often it is impossible or difficult to see in a coherent way the context that data possess. (See Figure 3.)
The ETL process is responsible for the whole way of data from sources to the data warehouse environment. It covers such stages as capturing, transformation and move of data. Designing and implementation of this process are one of the most difficult stages within the warehouse life cycle.
The OWB structure is following. It consists of two main environments: the project environment and the realization one (Oracle Warehouse Builder, 2001). The processes connected with the logical architecture designing are realized within the project environment. The second environment enables the analysis realization required by the user. The project environment consists of metadata, project tools and repository that is the most important element of the data warehouse. Metadata are different information supporting the designing process, management, application and everyday usage of the DW as well as enabling control of supplying data. Metadata can be of different shape: databases list from which the DW is supplied, these database structures, data delivery rules between their sources and the DW, the data warehouse schema, query and report sets,indexes, rules of the data warehouse objects division into partitions, rules of taking, transforming
and correcting of the source data, etc.
OWB offers a special group of tools called validators that check data quality and completeness in repository. Within the DW one can distinguish the following (See Figure 4):
  • Extraction – that extracts data from one or more sources and moves them to the warehouse,
  • Transformation – meaning data transforming and converting into one common format,
  • Loading –moving data to warehouse,

The realization environment consists of databases on which the DW actually works and concrete source data delivered in the DW.
Data within the DW are organized in shape of the multidimentional data model that can be seen as a multidimensional OLAP (On-Line Analytical Processing) cube (Figure 5).

A set of numeric measures called facts is a subject of analysis. Facts represent information that is to be analyzed (as e.g. product sales, student average notes, gain, etc.) and are characterized by measures (as e.g. number of bought products). The value of each measure depends on dimensions establishing the context of the analyze. The basic logical structure of the data warehouse is a star schema. As an example a star schema has been shown in Figure 6.

The star consists of a central fact table and some dimension tables. The star structure is one of the most popular models useful when designing the conceptual schema of the data warehouse. There are two other models, more complicated when compare with the star one: so called snowflake and constellation. The star structure operates on facts and dimensions. A fact describes a single information stored in the data warehouse. For example, the sales results in previous years is the fact. These results can be seen from different points of view, in different dimensions as e.g.
goods, quarter, client (Nycz, Smok & Pondel, 2003). Facts are the quantitative measures and their value depends on the set of dimensions.
Usually the data warehouses use multidimensional data structures as a star or snowflake schemas. These structures describe quantitative information – so called measures (e.g. value of sales) using dimensions (e.g. town, product category, quarter, method of sales). Such a type of data processing has been called current analytical processing. Data warehouses are one of the basic technologies of integrated information system creation. The main goal of this integration is to make possible the multidimensional analysis and comparison of data for the decision making reasons. The OLAP model is to support the analyze processes by delivering tools that enable analyzing database in many dimensions defined by the user (as e.g. time, place, product). Facts and dimensions can be stored on the relational database server ROLAP (Relational OLAP) or on the multidimensional database server MOLAP (Multidimensional OLAP). ROLAP is usually used for collecting row and aggregated data; MOLAP stores in data marts data that are partly aggregated.
But having the database is not enough to carry on analysis: it is necessary to have any decision support system: a reporting system (like e.g. Oracle Reports Builder), an analytical processing system OLAP (e.g. Oracle Discoverer or Express), a data exploration system (e.g. Oracle Data Mining). The basic advantage of any data warehouse is the possibility of collecting information coming from different heterogeneous sources. The integrated data are stored in the structures that enable quick data analyze. Data in relational databases are organized in rows and columns. The solutions delivered by the multidimensional analyze (OLAP) can be seen as enhancement of the relational databases possibilities. The OLAP database possesses the multidimensional structure and the data cube is its basic element. The data cube enables realization of such operations as slice and dice as well as the data aggregation. The cube can have three dimensions, but it is possible to have more dimensions. As some examples of dimensions used in sales analyze can be given as follows: clients, vendors, budget (planning, comparing the real results with those planned), discounts (the analyze of the sales or gains depending on a given discount, or for a given the price category), the sales regions. To make a typical analyze of sales using a cube, it is enough when the cube consists of seven at the most dimensions. The multidimensional recording in a cube makes it possible to very quick survey the data in all possible arrangements. The changed of presented data rely only on rotation the cube without the necessity of calculation of all values. Thanks to the multidimensional analyze we can:
  • analyze huge amount of data having the answers generated very quickly,
  • use the slice and dice as well as drill up, drill down modes due to different dimensions defined in the data structure, and
  • quickly identify trends and recognize problems that could be impossible to diagnose without such analyzes.

The multidimensional data structure can be stored either in multidimensional databases and they are in this case a source of the OLAP tools or in enhanced relational databases – being a source of the ROLAP tools. Exact definition of information needs is required when using the functionality of these systems in decision making.
Multidimensional Approach to Information
Multidimensional approach means that information is stored in multidimensional tables (cubes). Such a cube is a set of data ordered by dimensions (Inmon, Welch, & Glassey, 1997). The dimension possesses an ordered hierarchy of the data aggregation levels. Due to this fact it is possible to see the dimension on different levels of details. Multidimensional data analyses are supported by special operators such as (Analizy, 2005, p.8): 
  • pivoting – it relies on showing the measure and defining the dimensions in which the measure will be presented,
  • rolling up – it enables the navigation up the given dimension hierarchy to calculate the more and more aggregated value,
  • drilling down – that enables to go deep into a hierarchy of the dimension to carry out the more detailed analysis, e.g. searching more detailed information about sales in each store, everyday for a particular category of products,
  • rotating – enabling the presentation of data in different axles of dimension,
  • slicing and dicing – that narrows the analyzed data to a chosen dimensions and in frame of each the narrowing the analysis to a concrete values,
  • ranking – enabling the ordering of information in a given dimension.
In Figure 5 we present an example of the multidimensional analysis (slice and dice). We can see in it the aggregated data depicting the scale of the car sales in three following categories (dimensions): store, period and product. On these data we can build a cube that is a multidimensional database and we are able to obtain some information on e.g. how high was the sale of the product named Fiat in the store in Wroclaw in 2003. It is possible due to the fact that such information has already existed in the multidimensional database and it is to read. In traditional database this operation requires a complex query to be realized that needs much more time then reading the data from the multidimensional database. The analysis “in deep” allows mining the aggregated data through lower levels to identify the details. This technique enables searching the answers on questions like e.g. “why the sales of shoes produced by the firm “Rylko” in northern part of the country was lower in two first quarters in the year 2001”. Decomposing the aggregated data from the whole country into regions we can observe whether this decline depicted all regions in the country or only selected ones. If we have the aggregated data of sales split into provinces, it is easy to notice the decline e.g. in the Poznan province. When using this analysis it is possible mining through information to the level of towns, communes, etc.
Summary
Managerial decision-making requires the permanent access to all necessary information depicting all managerial areas, among other things sales, personnel, production process management, finances or accountability. This information is collected mostly in many non-integrated information systems and databases. There are more and more tools offered by different producers enabling automatic analysis. Data warehouse also belongs to this group. It can treated as a set of the materialized perspectives being the answers no the questions directed to the sources databases. But it is not enough to collect data and to analyze them to find some regularity among data. This what decides about the success of the enterprise is the access in a short time to information and knowledge that enables to make right decisions.

lunes, 2 de mayo de 2011

The Tri-Dimensional Role of Information Security in E-Business: A Managerial Perspective

ABSTRACT
The effective management of information and its associated infrastructure is critical in electronic business. Failure to exercise due diligence in information assurance and security may lead to lost revenue or business opportunities, brand and reputation erosion, adverse media publicity, scrutiny from consumer advocates and even lawsuits.
Traditionally, information security was approached in terms of goals. Yet, the goals-oriented approach may be a flawed one. In this paper, we adopt a conceptual analytical approach and propose a tri-dimensional understanding of information security in electronic business. Our approach can help managers better understand and communicate the information security’s role in e-business and the inter-dependencies between business and legal requirements, for devising the goals, objectives and policies relevant to their organization.
INTRODUCTION

Rapid developments in information technology (IT) have affected all aspects of business (Shapiro, 2001). The growth in connectivity (Nugent and Raisinghani, 2002) has been remarkable and created for organizations possibilities to establish distinctive strategic positioning (Porter, 2001), to transact electronically and to gain entry to markets which were previously unattainable, to streamline operations and to reduce costs through electronic business (e-business) initiatives.
E-business refers to a business model that is heavily enabled by IT (Weill and Vitale, 2002). Information in electronic form is essential to these e-business initiatives, on both strategic and operational levels. Therefore, the effective management of information and its associated infrastructure is critical. One key subset of information management is information security.
As technology constantly evolves, and as the modern business world expands to take advantage of the new technology, organizations face new and more sophisticated information security challenges (Labuschagne and Eloff, 2000). The more complex the e-business system, the more security problems are raised. The difficulties involved in the management of distributed systems on a global level and the modularity of the system exacerbates the potential security weaknesses (Schneier, 2000).
Traditionally, security in computing was discussed in terms of goals: confidentiality, integrity and availability of information (Pipkin, 2000; Lichtenstein and Swatman, 1997; Pfleeger, 1997; Swanson and Guttman, 1996; Pernul, 1995; Neumann, 1995), and authentication and non-repudiation (Landwehr, 2001). Yet, the goals-oriented approach may be a flawed one (Bort, 2002). In this paper, we adopt a conceptual analytical research approach and discuss information security’s role in e-business on three high-level, organization-independent, interrelated dimensions:
  • Safeguarding organizations’ information; 
  • Complying with e-business legal requirements; and  
  • Enabling trusted and secure electronic transactions (e-transactions).



 THE ROLE OF INFORMATION SECURITY IN E-BUSINESS


In this section, we outline factors that we consider to have increased the information security problem. Next, we discuss the three high-level, inter-related dimensions of information security in e-business.

Preliminary considerations

Information has high economic value and has become a means by which competitive advantage might be established. Many factors can be considered to have increased the information security problem in modern computing environments—from within and from outside an organization. These factors include:

  • Greater globalisation;
  • Increased difficulties involved in computer security (Landwehr, 2001; Loscocco et al., 1998);
  • Insufficient information security awareness and education (Siponen, 2000);
  • Users’ attitudes and behaviours with regard to policies or practices (AusCERT et al., 2002; Schneier, 2000);
  • Availability of hacker information; and 
  • Unclear regulatory and law enforcement jurisdiction (Wardlaw, 1999).
Leveraging information can make the difference between organizations (Pipkin, 2000), therefore information security must be a very important management issue (Panko, 2002; Dutta and McCrohan, 2002; Swanson
and Guttman, 1996).

Safeguarding information
Numerous researchers have written on the need to protect the electronic assets of organizations (Landwehr, 2001; Pipkin, 2000; Parker, 1999; Straub and Welke, 1998; von Solms, 1998; Pernul, 1995; Neumann, 1995; Landwehr, 1993).
According to Ware (2001), most organizations’ critical business information is stored electronically. Information can be very sensitive (e.g. financial, payroll, marketing or customers’ personal information), therefore it is a natural target for compromise. As surveys show (e.g. AusCERT, 2002; Power, 2001), the hacker threat is very real, whatever the motivation of perpetrators (Pipkin, 2003; Schneier, 2000; Icove et al., 1995).
With an inreased understanding of computer systems, perpetrators can determine vulnerabilities in computer systems and exploit them to obtain privileges that will allow them to do anything on the system (Kumar, 1995). Furthermore, the crime can be automated (Schneier, 2000; Parker, 1999; Icove et al., 1995), and repeated testing under various circumstances can make it become the perfect crime.
Kumar (1995) argues that a good information security design starts with a threat model— what the system is designed to protect, from whom, and for how long. Threat modeling involves thinking about the system as a whole and imagining the vulnerability landscape (Schneier, 2000), and must take into account the information to be protected and the people who will use the system and how they will use it.
Whether external or internal, threats are opportunities that have the potential to cause harm or loss to organizations (Landwehr, 2001; Pfleeger, 1997; Castano et al., 1995; Neumann, 1995), and come in different forms. Threats must be well understood before effective information security measures are devised (Sanderson and Forcht, 1996).
Castano et al. (1995) classifies threats according to the way they can occur: non-fraudulent (accidental) and fraudulent (intentional). Buffam (2000) proposes a more elaborated classification of threats: fundamental—which represent what an attacker really wants to do: information disclosure, information tampering, denial of service, repudiation, and illegitimate use—, enabling (e.g. masquerade, malware or authorization violation), and underlying threats (e.g. eavesdropping or administrative error).
In safeguarding organizations’ information, information security also safeguards organizations’ capacity for doing business, reputation and market valuation.

Complying with e-business legal requirements
Managing the risk of exposure for electronic information assumes also legal importance— organizations that fail to show due diligence in protecting their information assets face a real risk of legal problems (Vijayan, 2002; Gamertsfelder et al., 2002). Protecting personal information privacy is a legal requirement (Vasiu et al., 2002) and adherence to a strict information security policy reduces the chance of legal exposures and liabilities due to negligent protection of personal or other information or due to damage caused to contractors, partners, customers or other entities.
A major e-business issue is the enforceability of e-transactions. According to Smedinghoff (2002), ensuring enforceability requires that the parties focus on the following questions:
  • Notice and consent: have the parties consented to conduct this transaction in electronic form and have the requisite notices been provided?
  • Signature: have the signature formalities required for the transaction (where applicable) been satisfied with a legally recognized form of electronic signature (esignature)?
  • Record accessibility: are copies of the electronic records comprising the transaction available to all parties?
  • Record keeping: will the electronic records of this transaction satisfy applicable legal record-keeping requirements?
Signing a document is a fundamental legal act—almost every commercial document of any importance is signed (Reed, 2000). Through information security means, an electronic document can meet the business and legal requirements of authenticity, integrity, nonrepudiation, signature, and confidentiality, imposed by a variety of statutes and regulations.
According to Smedinghoff (1996), for paper documents, security is achieved using letterheads, handwritten signatures, special inks, sealed envelopes, and couriers. For electronic documents, security can be achieved through the use of e-signatures, encryption, acknowledgment procedures and various access controls.
E-signatures can provide evidence of the identity of the signatory (UNCITRAL, 2001), their intention to sign, and their intention to adopt the contents of the document as his own (Reed, 2000). Moreover, since an e-signature is unique to its message, the integrity of the message can also be assured (Smedinghoff and Bro, 1999)—a prerequisite for its admissibility in court proceedings (Tenhunen, 1997). Although not free from problems (Jøsang et al., 2002; McCullagh et al., 2001; Gelbord, 2000), e-signatures are arguably the only technology currently available that satisfies the requirements of the e-transactions legislation (Gamertsfelder et al., 2002).
Where there is a requirement to keep a written record of information, it can be met electronically if the method of retention is reliable (Allen, 2002). Failure to implement and maintain a proper record retention can harm organizations, result in fines (Computer Fraud & Security, 2002), or in organizations’ inability to successfully prosecute or defend a legal claim. Even organizations that are not party to litigation can be compelled, by subpoena, to produce records to the courts, and failure to comply can render organizations liable for being in contempt of court (Allen, 2002).
Another important aspect of e-transactions is time (Hosmer, 2002). Secure and auditable time stamping to digital evidence eliminates the possibilities for fraud and unintended errors, and can provide evidence of
priority for financial records and other business documents.

Enabling trusted and secure electronic transactionsIn addition to assuring protection against threats and compliance with certain legal requirements, information security has evolved into a powerful tool for developing business solutions. Effective information security promotes business objectives and expands business opportunities, therefore information security can be viewed as a business enabler.
Information security can deliver a competitive edge by generating new markets and revenue streams and leveraging new distribution channels. The wider information is distributed—to suppliers and other trading partners—the more important the role information security plays.
Regarding the e-transactions, the Commission of the European Communities (1997:19) considers that


The first objective is to build trust and confidence… both consumers and businesses must be confident that their transaction will not be intercepted or modified, that the seller and the buyer are who they say they are, and that transaction mechanisms are available, legal, and secure… trust and confidence is the prerequisite to win over businesses and consumers.
 

Information security in e-business means first assuring that the system will be available for use and will deliver uncorrupted information (Landwehr, 2001)—this is critical to organizations’ ability to earn revenue (AusCERT, 2002). Trade practices statutes contain various non-excludable warranties, which potentially apply to e-transactions and may have implications for the availability of servers, security of transactions and the allocation of responsibility for loss from unsuccessful or incomplete transactions (Gamertsfelder et al., 2002). Further, if a security breach renders the commercial situation radically different (e.g. latency in transmissions or significant server downtimes), and the parties are incapable of discharging their contractual performance obligations with the applicable standard of duty, this may lead to the dissolution of the contract by frustration (Gamertsfelder et al., 2002).
Second, e-business might require authentication and authorization (Lampson et al., 1992), key aspects inherently linked to confidentiality and non-repudiation. Third, communications security is required: integrity, and confidentiality of the packet's payload data while over networks.

CONCLUSIONS AND FUTURE RESEARCH
To achieve the benefits offered by e-business, organizations must find ways to effectively address the associated information security implications (GAO, 1998). Traditionally, security in computing was approached in terms of goals. In this paper, we have adopted a conceptual analytical approach and discussed information security’s role in e-business on three highlevel, organization-independent, inter-related dimensions:
  • Safeguarding organizations’ information; 
  • Complying with e-business legal requirements; and
  • Enabling trusted and secure e-transactions.
The nature and degree of threats faced by organizations vary, therefore a risk assessment of the likelihood that security will be compromised is needed (Dutta and McCrohan, 2002). An acceptable level of information security can be introduced and maintained only if the set of security controls, procedural and technical, is correctly identified, implemented and maintained (von Solms, 1998). These activities must be seen as a never-ending process.
Information security must be approached as an integrated whole, and not viewed narrowly and incompletely, in terms of isolated component parts. A systemic (Schneier, 2000) or comprehensive and integrated approach (Swanson and Guttman, 1996), that takes into account the three dimensions of information security identified and discussed in this paper is needed for successful e-business initiatives.
Further, organizations should aim to gain an understanding of the specific characteristics of the emerging environment that may generate new threats. The consequences of failure to do so may severely impair their ability to carry out their business and may even lead to legal exposures and liabilities.
A sound information security strategy and implementation can also be an important differentiator in the marketplace leading to organizations gaining a competitive advantage and other business opportunities.
Future research suggestions include:
  • An analysis of the spillover effect of information security breaches in a supply chain environment; and
  • An analysis of information security’s role in leveraging new distribution channels.