Interesting Technologies

Globe - [Mini Revolver Maps]

noreply@blogger.com (Ken Moeckli) — Sat, 16 Apr 2011 18:58:00 +0000

Band Competition

noreply@blogger.com (Ken Moeckli) — Sat, 29 Jan 2011 22:05:00 +0000

Competiton can bring out the best worst of all of us if we let it. The trick is not to let it.

Published with Blogger-droid v1.6.6

Posting From Android

noreply@blogger.com (Ken Moeckli) — Sat, 22 Jan 2011 20:40:00 +0000

Picture of tree in Pittsburg

Published with Blogger-droid v1.6.5

noreply@blogger.com (Ken Moeckli) — Fri, 05 Mar 2010 01:43:00 +0000

Online GUID Generator's

http://www.guidgenerator.com/online-guid-generator.aspx
http://www.somacon.com/p113.php
http://www.hoskinson.net/GuidGenerator/default.asp
http://www.fileformat.info/tool/guid.htm
https://developer.mozilla.org/en/Generating_GUIDs

Oracle's GUID

SYS_GUID generates and returns a globally unique identifier (RAW value) made up of 16 bytes. On most platforms, the generated identifier consists of a host identifier, a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.

Examples

The following example adds a column to the sample table hr.locations, inserts unique identifiers into each row, and returns the 32-character hexadecimal representation of the 16-byte RAW value of the global unique identifier:

Example 1:

ALTER TABLE locations ADD (uid_col RAW(16));

UPDATE locations SET uid_col = SYS_GUID();

SELECT location_id, uid_col FROM locations
ORDER BY location_id, uid_col;

LOCATION_ID UID_COL
----------- ----------------------------------------------------------------
1000 09F686761827CF8AE040578CB20B7491
1100 09F686761828CF8AE040578CB20B7491
1200 09F686761829CF8AE040578CB20B7491
1300 09F68676182ACF8AE040578CB20B7491
1400 09F68676182BCF8AE040578CB20B7491
1500 09F68676182CCF8AE040578CB20B7491

Example 2:

create table test (ID raw(16) default sys_guid(), name varchar2(10));

insert into test(name) values ('DAS');

insert into test(name) values ('DDAS');

select * from test;

ID NAME
-------------------------------- ----------
CF874CB4F32A47C19859DA2BB0D71AB4 DAS
2B768E600A484391B6B8D5C4924D2785 DDAS

Facts and Dimensions

noreply@blogger.com (Ken Moeckli) — Wed, 03 Mar 2010 01:50:00 +0000

The data in a data warehouse is divided into "facts" and "dimensions". Facts are tangible events which also carry inherent characteristics. Dimensions are any data elements that may affect the behavior of these facts.

- At the center of the star are the facts. Facts are tangible events. In this case, the facts are individual sales transactions.
- Around the facts are five dimensions:
1) Customer Loyalty Dimension
2) Geographic Dimension
3) Product Dimension
4) HR Dimension
5) Time Dimension

- Further defining the Geographic dimension are two sub-dimensions, also known as “snowflake” dimensions because of the shape they give to the star:
1) Tax Snowflake Dimension, which depends on the geographic location and the time when the fact occurred
2) Weather Snowflake Dimension, which also depends on the geographic location and the time when the fact occurred

Having divided the data into facts and dimensions, one can mine the data for trends. In a retail environment, one could look for questions such as:
• What distance will the average loyalty card holding customer travel from their home to one of the company retail stores?
• Is there a correlation between the distance and the frequency of the visits?
• If a promotion flyer was distributed by mail to a given postal code, what was the loyalty card holder response?
• In the spring season, at what average temperature do customers purchase more cold drinks, like fruit juices than hot drinks, like coffee?
• If a customer bought a product in the “salty snack” category, what is the probability that they would also buy one or more cold drinks?
• Is there a typical “basket of goods” purchased on certain weekdays?
• What is the profile of the employees with the best sales?
• If a sales education course was provided for employees of a given territory, can the results be measured?

Beyond having answers to questions that the marketers may be curious about, the secondary aim of the data warehouse star schema is to enable “data mining”. Effectively, data mining is the use of software to uncover hitherto unknown trends, or trends not easily visible otherwise.

Data Warehouse verses Data Mart

noreply@blogger.com (Ken Moeckli) — Wed, 03 Mar 2010 01:49:00 +0000

Definitely spend time upfront thinking about what you're trying to achieve, not just today's requirements.

A traditional data warehouse is all-about providing a vehicle for reporting from summary and aggregate information (using de-normalized tables, summarized tables and materialized views). Most data warehouse designers replicate the data warehouse summary data onto another instance to avoid contention with the OLTP database, but this depends on the traffic on your system and the ability of your server to handle additional load.

A data warehouse pre-summarizes and pre-aggregates the OLTP data so that the queries can fetch the result sets with only a few data block touches. Make sure that your OLTP server has enough CPU resources to support Oracle parallel query, as you will need it to roll-up your summaries and aggregates

If your existing summary tables do not require joins into other OLTP tables, then you will not benefit from a star transformation approach.

The bottom-up approach to data warehouse design. In this approach, data marts, or "mini data warehouse" data storage facilities are first created to provide reporting and analytical capabilities for specific business processes. Like bricks forming a wall, the data contained within these data marts can eventually be combined to create a more comprehensive data warehouse.

The top-down design method, as it involves a lot of up-front end-in-mind planning before any results can be extracted.

Initialization Parameters in the DBCA

noreply@blogger.com (Ken Moeckli) — Wed, 03 Mar 2010 00:52:00 +0000

Here are the initialization parameters that are set in the DBCA for a data warehouse. These are not correct for everyone, and you need to customize all data warehouse instances to match your specific processing needs.

Name	Value
aq_tm_processes	1
db_block_size	8,192
db_cache_size	16m
db_file_multiblock_read_count	32
fast_start_mttr_target	300
hash_area_size	1m
hash_join_enabled	TRUE
java_pool_size	33m
job_queue_processes	10
large_pool_size	8m
open_cursors	300
pga_aggregate_target	33m
processes	150
query_rewrite_enabled	TRUE
remote_login_passwordfile	EXCLUSIVE
shared_pool_size	50m
sort_area_size	1m
star_transformation_enabled	TRUE
timed_statistics	TRUE
undo_management	AUTO
undo_retention	10,800

Planning for a Data Warehouse

noreply@blogger.com (Ken Moeckli) — Wed, 03 Mar 2010 00:50:00 +0000

Data Warehousing comes in all shapes and sizes, which bear a direct relationship to cost and time involved. The approach to starting a Data Warehousing project will vary and the steps listed below are summary of some of the points to consider.

1) Get Professional Advice

Data Warehousing makes a great difference is the lead has been there and done that. It will save a huge bundle to get professional advice upfront. Endless meeting times can be saved and the risk of an abandon data warehousing project can be reduced.

2) Plan the Data

Know what metrics you want to measure in the Data Warehouse and ensure that there is the appropriate data to provide for the analysis. If you wish to obtain periodic Key Performance Index (KPI) data for shipping logistics, make sure that the appropriate data is piped into the data warehouse.

3) Who will use the Data Warehouse

The power Data Warehouse consumers are business and financial managers. Data Warehouses are meant to deliver clear indications on how the business is performing. Plot out the expected users for the Data Warehouse in the enterprise. Gauge that they will have the appropriate reports in a format which is quickly understandable. Ensure that planning exercises are conducted in advance to accumulate scenarios on how the Data Warehouse will be used. Always remember that data has to be presented attractively and in a format business managers will feel comfortable. Text files with lines of numbers will not suffice!

4) Intergration to External Applications

Most Data Warehousing projects sink or swim by their ability to extract data from external applications. Enterprises have a slew of applications either developed inhouse or obtain from a vendor. Conceptually, your Data Warehouse will act as the heart to diverse applications running in the enterprise. All important data will flow in or out of the Data Warehouse.

5) Technology, What Technology?

At the bits and bytes level, a Data Warehouse is a souped up database. It will be built from one of the major Relational Database Management System (DBMS) vendors like Oracle, IBM, Microsoft. Open source databases, like mySQL, can also support Data Warehousing with the right support in place.

HTML to PDF Converter

noreply@blogger.com (Ken Moeckli) — Mon, 09 Mar 2009 20:05:00 +0000

This is a pretty neat utility to use when you need to grab all the content on a site and consolidate it into one document.

clipped from html-pdf-converter.com

HTML to PDF Converter

It's a simple service to convert the web pages to PDF files. No need to install applications on your computer.
It's free and without registration!

Input URL (web page)

Free Linux eBook

noreply@blogger.com (Ken Moeckli) — Sat, 21 Feb 2009 04:51:00 +0000

clipped from slickdeals.net

Free Download of Linux 101 Hacks eBook

TheGeekStuff.com offers a Free Download of Linux 101 Hacks eBook. Click Here and enter password linuxrocks (case sensitive) and click "Submit". Thanks InfectiouSoul and Selma.

Post a Text Message to Iridium Phones

noreply@blogger.com (Ken Moeckli) — Thu, 12 Feb 2009 09:23:00 +0000

Using this link to post messages to a Iridium phone.

clipped from www.iridium.com

Iridium

17 People Who Changed the Internet Forever

noreply@blogger.com (Ken Moeckli) — Fri, 28 Nov 2008 15:35:00 +0000

clipped from www.skidzopedia.com

17 People Who Changed the Internet Forever!

Gold Disk Downloads

noreply@blogger.com (Ken Moeckli) — Fri, 14 Nov 2008 13:02:00 +0000

clipped from iase.disa.mil

Security Readiness Review Evaluation Scripts

Windows Gold Disk Version 2 (scan only) - Updated! posted Sep. 22, 2008
Windows Gold Disk User Guide for Version 2 - Updated! posted Sep. 22, 2008
Windows Gold Disk Version 2 (entire set) (.mil only) DoD CAC or ECA req'd
Gold Disk Version 2 Known Issues - Updated! posted Oct. 20, 2008

UNIX SRR - Updated!posted Sep. 22, 2008

Nice Free Word Translator

noreply@blogger.com (Ken Moeckli) — Tue, 11 Nov 2008 20:57:00 +0000

Someone spent some time on this translator.

clipped from www.lingoes.net

Lingoes is an easy and intuitive dictionary and text translation software, It offers lookup dictionaries, full text translation, cursor translation, zoned word translation and pronunciation of words in over 80
languages. These language are English, French, German, Italian, Spanish, Portuguese, Russian, Greek, Swedish, Turkish, Chinese, Japanese, Korean, Polish, Arabic, Hebrew, Vietnamese, Thai and more...

It is Free & only
3.9 mb

Download

no spyware, no malware

Sweet Little Computer

noreply@blogger.com (Ken Moeckli) — Sat, 08 Nov 2008 02:18:00 +0000

clipped from www.linuxjournal.com

The BeagleBoard: $149 Linux System

The beagleboard is low cost fanless development board with Linux support.
And it is low cost, you can get one for $149 from digikey.
And it is low power, it uses less than 2 Watts and can run via USB power (although it does have a secondary power input).

Lots of Free Software

noreply@blogger.com (Ken Moeckli) — Sat, 08 Nov 2008 02:13:00 +0000

clipped from www.freeziq.com

TOP 400 Freeware software!

Crack Passwords

noreply@blogger.com (Ken Moeckli) — Sat, 08 Nov 2008 01:52:00 +0000

Check out this free windows password cracker.

clipped from ophcrack.sourceforge.net

Ophcrack is a free Windows password cracker based on rainbow
tables. It is a very efficient implementation of rainbow tables
done by the inventors of the method. It comes with a
Graphical User Interface and runs on multiple platforms.

» Runs on Windows, Linux/Unix, Mac OS X, ...

» Cracks LM and NTLM hashes.

» Free tables available for Windows XP and Vista.

» Brute-force module for simple passwords.

» LiveCD available to simplify the cracking.

» Loads hashes from encrypted SAM recovered from a Windows partition, Vista included.

» Free and open source software (GPL).

Download

ophcrack

All platforms

Download

ophcrack LiveCD

No installation

Source Code Search Engines

noreply@blogger.com (Ken Moeckli) — Fri, 07 Nov 2008 23:15:00 +0000

This is a pretty good list of source code search engines.

clipped from www.cavdar.net

My Top 10 Source Code Search Engines

Joongel Search Site

noreply@blogger.com (Ken Moeckli) — Fri, 17 Oct 2008 19:13:00 +0000

This is a really sweet site to do searches from.

clipped from www.joongel.com

Free Classes Online

noreply@blogger.com (Ken Moeckli) — Thu, 16 Oct 2008 16:46:00 +0000

If time permits maybe it would be worth your while to view a few Stanford Level Engineering courses online. They are free!

clipped from see.stanford.edu

Stanford Engineering Everywhere

This fall, SEE launches its programming by offering one of Stanford’s most popular engineering sequences: the three-course Introduction to Computer Science taken by the majority of Stanford undergraduates, and seven more advanced courses in artificial intelligence and electrical engineering.

Free Solar Wind Products

noreply@blogger.com (Ken Moeckli) — Sat, 27 Sep 2008 13:57:00 +0000

Here is a great set of Solar Wind Products:

Real Time Net Flow Analyzer -- http://tinyurl.com/4cs7d9
Exchange Monitor A -- http://tinyurl.com/4ljbrn
TFTP Server -- http://tinyurl.com/5ynfja
Subnet Calculator -- http://tinyurl.com/3fp8d9
Wake on LAN -- http://tinyurl.com/4thymx

clipped from mail.atlanticbb.net

Build Web-based Forms using Wufoo

noreply@blogger.com (Ken Moeckli) — Sat, 23 Aug 2008 00:41:00 +0000

This looks really interesting.

clipped from wufoo.com

Wufoo : Form Builder

clipped from wufoo.com

What is Wufoo?

Our HTML form builder helps anyone create contact forms, web surveys, and invitations
so they can collect the data, registrations and online payments they need without
writing a single line of code.

Free Online Magazines

noreply@blogger.com (Ken Moeckli) — Tue, 19 Aug 2008 19:29:00 +0000

This is a really neat site if you want to read your favorite magazines online.

clipped from www.mygazines.com

Open Source Custom Tag Library for OLAP Tables

noreply@blogger.com (Ken Moeckli) — Thu, 31 Jul 2008 14:57:00 +0000

This looks promising as well, it leverages Mondrian.

clipped from jpivot.sourceforge.net

JPivot

JPivot is a JSP custom tag library that renders an OLAP table and let users
perform typical OLAP navigations like slice and dice, drill down and roll up.
It uses Mondrian as its OLAP Server.

Open Source Business Intelligence and Analysis Services

noreply@blogger.com (Ken Moeckli) — Thu, 31 Jul 2008 14:52:00 +0000

This looks really promising, I will have to try it out tonight.

clipped from mondrian.pentaho.org

Mondrian is an OLAP server written in Java. It enables
you to interactively analyze very large datasets stored in SQL databases without writing SQL.

Mondrian 3.0 includes olap4j 0.9.6 along with significant improvements to security and additional function support. Highlights of this release include:

olap4j API — an Open Java API for OLAP

Rollup policy enhancements

Aggregate role support

Support for aggregation of distinct-count measures

Improved dimension sharing

Over 50 new scalar functions

JNDI support

Interesting Technologies

Globe - [Mini Revolver Maps]

Band Competition

Posting From Android

Facts and Dimensions

Data Warehouse verses Data Mart

Initialization Parameters in the DBCA

Planning for a Data Warehouse

HTML to PDF Converter

HTML to PDF Converter

It's a simple service to convert the web pages to PDF files. No need to install applications on your computer.It's free and without registration!

Free Linux eBook

Post a Text Message to Iridium Phones

Iridium

17 People Who Changed the Internet Forever

17 People Who Changed the Internet Forever!

Gold Disk Downloads

Nice Free Word Translator

Sweet Little Computer

The BeagleBoard: $149 Linux System

Lots of Free Software

TOP 400 Freeware software!

Crack Passwords

Source Code Search Engines

My Top 10 Source Code Search Engines

Joongel Search Site

Free Classes Online

Free Solar Wind Products

Build Web-based Forms using Wufoo

What is Wufoo?

Free Online Magazines

Open Source Custom Tag Library for OLAP Tables

Open Source Business Intelligence and Analysis Services

It's a simple service to convert the web pages to PDF files. No need to install applications on your computer.
It's free and without registration!