Online Analysis Processing (OLAP) April 26, 2007
Posted by essamabdelaziz in JAVA.1 comment so far
OLAP (On-Line Analytical Processing) is a technology that uses multidimensional structures to provide rapid access to data for analysis.
OLAP enables analysts, managers, and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information. OLAP transforms raw data so that it reflects the real dimensionality of the enterprise as understood by the user.
Multidimensional views are inherently representative of an actual business model. Rarely is a business model limited to fewer than three dimensions. Managers typically look at financial data by scenario (for example, actual vs. budget), organization, line items, and time; and at sales data by product, geography, channel, and time.
How does OLAP organize its data?
OLAP organizes data into cubes, dimensions, and measures. A cube is a set of data that is organized and summarized into a multidimensional structure defined by a set of dimensions and measures.
A dimension is an organized hierarchy of categories (levels) that describe data in the cube. These categories typically describe a similar set of members upon which the user wants to base an analysis. (You can often recognize a dimension by the use of the word “by”—”sales by city” or “sales by year.”). For example, a geography dimension might include levels for Country, Region, State or Province, and City. A time dimension may contain the levels Year, Month, and Day.
A measure is a summation of values in the cube and is usually numeric. Measures are the central values that are aggregated and analyzed.
How does OLAP store its data?
The source data for OLAP is commonly stored in an OLAP database. An OLAP database is a database specifically structured for query and analysis. An OLAP database typically contains information that answers “who?” and “what?” questions about past events. A typical query submitted to an OLAP database is: “What was the total revenue for the eastern region in the third quarter?”
ecm Help
how I read a Microsoft Excel file from Java?… April 25, 2007
Posted by essamabdelaziz in DataBase.add a comment
Although I’m a java developer from along time but I didn’t try to deal with excel
But last weekend I was give session to a person who want to learn java and I was doing some hello world examples for him
I wanted to let him see A much dynamic example
Mainly my DB is Oracle and sometimes mysql but I was unable to make installation Fro oracle client on his machine because
His laptop configuration
So I had to use excel
So how I read a Microsoft Excel file from Java?…
be quiet it is easy
Assume you have an Excel file named c:\qa.xls (to download, see Resources).
Also suppose that the data is in a worksheet named qas and takes the following format:
Microsoft’s ODBC driver treats the first row in a spreadsheet as the column names and the worksheet name as the database name.
To access a spreadsheet with JDBC, you need to create a new ODBC data source. To create one in Windows 2000:
1. Go to “Control Panel”
2. Go to “Administrative Tools”
3. Go to “Data Sources”
4. Select “Add”
5. Choose “Microsoft Excel Driver” and “Finish,”
6. Then give the “Data Source Name” qa-list and select the workbook
7. When you are done you should see your new qa-list data source name:
Now the spreadsheet is available as an ODBC source.
Say that you would like to pull out all March 2000 entries. You will need to hit the data source with the following SQL query
select URL from [qas$] where Month=’March’ and Year=2000;
Note that the table name is the name of the worksheet with a $ appended to the end. You have to append the $ in order for the query to work. Why? Because. The brackets are there because $ is a reserved character in SQL. Life is never easy.
Now try ExcelReader on for size:
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class ExcelReader
{
public static void main( String [] args )
{
Connection c = null;
Statement stmnt = null;
try
{
Class.forName( “sun.jdbc.odbc.JdbcOdbcDriver” );
c = DriverManager.getConnection( “jdbc:odbc:qa-list”, “”, “” );
stmnt = c.createStatement();
String query = “select URL from [qas$] where Month=’March’ and Year=2000;”;
ResultSet rs = stmnt.executeQuery( query );
System.out.println( “Found the following URLs for March 2000:” );
while( rs.next() )
{
System.out.println( rs.getString( “URL” ) );
}
}
catch( Exception e )
{
System.err.println( e );
}
finally
{
try
{
stmnt.close();
c.close();
}
catch( Exception e )
{
System.err.println( e );
}
}
}
}
In ExcelReader, the main() gets a connection to the spreadsheet, then pulls out all of the entries for March 2000.
http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html
BIRT Step by Step April 22, 2007
Posted by essamabdelaziz in JAVA.add a comment
from along while i was trying to do some effort in Reporting coz
it is very important issue for an project mostly all projects should have Reporting Module to provide the end users with statistical reports.
i started with jasper report and Ireport but it was booing for me.
during R&D i found Birt (Business Intelligence and Reporting Tools)
how to use birt?
1-download BIRT designernow you can Design your first report the designer is easy to learn the above link provide a flash movie to show you how to build HelloWorld Report
2-Doenload Birt runtime To Show your Report in your J2EE Application
3-delopy WebViewerExample put this folder under webApps
Now you build your first report and show the report in your j2ee Application
let’s move to another another important issue how to pass a parameter to the Report
· In your report design add a new Report Parameter ( RP_param ) · In your data set Query create your query with something like “WHERE ID = ?” or some other criteria using a ? for the value
. · In your data set add a Parameter ( DS_param ) then set the default value of this parameter to the Report Parameter you created earlier (RP_param) to do this click on the default value field then the … button
. In the resulting dialog choose Category ‘Report Parameters’, sub category ‘All’ then double click your Report Parameter to add it and click OK.
First about J2ME April 20, 2007
Posted by essamabdelaziz in JAVA.add a comment
Al salam Alykom,
That will be isA the first article about J2Me, just to introduce this technology.
J2ME stands for java microedition technology, it is a technology for microcomputers like PDAs, mobiles….etc.
It is mostly used in mobile applications. On using in mobile applications it needs WTK “Wireless tool kit” instead of JDK with desktop applications, which contains the required APIs to deal with mobile applications.
That was just an overview about J2ME and it will be followed isA by more detailed and useful information about J2ME
MyEclipse 5.5 M2 is Now Available! April 19, 2007
Posted by essamabdelaziz in Eclipse.add a comment
MyEclipse 5.5 M2 is Now Available!
The release of MyEclipse 5.5 M2 with Java EE 5 support is now available for immediate installation. Windows, Linux, and Mac OSX support is available
for download
http://www.myeclipseide.com/modules.php?op=modload&name=Downloads&file=dl_options
Features
The MyEclipse 5.5 M2 release includes enhancements and bug fixes for the MyEclipse environment over the previous 5.1 release series, including:
- Greater platform support
- Microsoft Vista support
- Eclipse 3.2.2 compatible
- Upgraded MyEclipse-WebTools, an enhanced and professionally supported version of Eclipse WTP 1.5.3 with many MyEclipse improvements and bug fixes
- SNAPs Non-Eclipse Integration and Improvements
- Java EE 5 Projects
- Create Java EE 5 Web, EJB and Enterprise (EAR) projects with integrated library support
- EJB Projects include persistence.xml generation and synchronization
- Much more
- EJB3 – Enterprise Java Beans
- Create Stateless, Stateful, Entity and Message enterprise beans
- Wizards for creating all
- Code-assist and validation of Java annotations
- Reverse-engineer Stateless Session Bean facades from MyEclipse Database Explorer
- MyEclipse Java Persistence Tools (including JPA, Toplink, Hibernate)
- Add JPA Capabilities to any Java project
- Integrates with MyEclipse Database Explorer for database connections and metadata access
- Persistence perspective
- Much more
- Visual JSF Page Designer
- All new JSF Visual Page Designer for WYSIWYG editing of advanced JSF components
- Supports Drag-and-Drop style editing of all standard JSF components
- Preview mode of JSF design page
- JSF and faces.config creation wizards
- Much more
- Matisse4MyEclipse Swing Visual Designer upgrades
- MyUML improvements
- Improved internationalization
- New Application Server Connectors (Geronimo 2, Oracle 10, Weblogic 10)
- All-in-One Installer reduced download volume by 50%
- Much more!
What is the difference between exception and error? April 18, 2007
Posted by essamabdelaziz in DataBase.add a comment
The exception class defines mild error conditions that your program encounters. Exceptions can occur when trying to open the file, which does not exist, the network connection is disrupted, operands being manipulated are out of prescribed ranges, the class file you are interested in loading is missing. The error class defines serious error conditions that you should not attempt to recover from. In most cases it is advisable to let the program terminate when such an error is encountered.
What is Domain Naming Service(DNS)? April 18, 2007
Posted by essamabdelaziz in JAVA.add a comment
It is very difficult to remember a set of numbers(IP address) to connect to the Internet. The Domain Naming Service(DNS) is used to overcome this problem. It maps one particular IP address to a string of characters. For example, www. mascom. com implies com is the domain name reserved for US commercial sites, moscom is the name of the company and www is the name of the
What is URL?- April 18, 2007
Posted by essamabdelaziz in JAVA.add a comment
URL stands for Uniform Resource Locator and it points to resource files on the Internet. URL has four components: http://www. address. com:80/index.html, where http – protocol name, address – IP address or host name, 80 – port number and index.html – file path.
What is Inet address? April 18, 2007
Posted by essamabdelaziz in JAVA.add a comment
Every computer connected to a network has an IP address. An IP address is a number that uniquely identifies each computer on the Net. An IP address is a 32-bit number.
What is the difference between an argument and a parameter?- April 18, 2007
Posted by essamabdelaziz in DataBase.add a comment
[
While defining method, variables passed in the method are called parameters. While using those methods, v
alues passed to those variables are called arguments.