1/ Want to reboot your iphone/ipad? Connect to terminal (or SSH) and issue command: reboot
2/ Want to restart SpringBoard? Connect to terminal (or SSH) and issue command: killall SpringBoard
TBC
3/ Want to start/stop service in iPhone, speeding up your iPhone?
Start vsftpd (daemon/background service)
launchctl load /System/Library/LaunchDaemons/com.bigboss.vsftpd.Startup.plist
Stop vsftpd daemon
launchctl unload /System/Library/LaunchDaemons/com.bigboss.vsftpd.Startup.plist
Start sshd
launchctl load /Library/LaunchDaemons/com.openssh.sshd.plist
Stop sshd
launchctl unload /Library/LaunchDaemons/com.openssh.sshd.plist
View all working processes
ps -ax
View working processes, and its status
top
View disk free on your iphone
df -h
View used command in terminal
history
View your iPhone information: Kernel, Hardware, iPhone name, etc.
hostinfo
Or
uname -a
View network connections to/from your iphone
netstat -s
Configure your iphone network interface
ifconfig -a
Manipulate packages: install, list, remove, etc.
dpkg -l
View help system
help
Saturday, August 18, 2012
Some sources for your free/cracked iPhone/iPad app:
1/ Cydia (in this application you can add many application sources/repositories, you can google it)
2/ Installous (this can be installed from Cydia)
3/ HipStore (this can be installed from Cydia; source: store.heaveniphone.com)
4/ AppStoreVN (this can be installed from Cydia)
5/ Installer (this can be installed from Cydia)
Friday, August 3, 2012
Want to study - flash cards is smart choice
I'm reviewing PMP course, and I soon or later want to get this certificate so I'm thinking of creating my own flash cards, I google around tools for my iphone, ipad, and I saw these interesting websites, especially for knowledge, flash cards exchange
http://www.cobocards.com/pool/en/cardset/67qae0711/online-karteikarten-pmp-processes/
http://www.flashcardexchange.com/iphone-flash-cards
https://quizlet.com/upgrade/?signup&redir=http%3A%2F%2Fquizlet.com%2F
And tools:
CoboCards
FlashCard+
Btw, I will use these tools for creating, maintaining and sharing our project knowledge also
And I got an idea to create a soft (called 'Social Flash Cards') to integrate into Facebook, Twitter, and sharing feature between users; taking a photo with notes for studying and share instantly to friends
And I learnt from the guy - Christian Kienle - who made and published flash cards tool an interesting term "Prototyping driven developer" that sounds cool. He created hundred applications based on his own idea and publish, few of them, acquired by firm, company to make commercial
http://www.cobocards.com/pool/en/cardset/67qae0711/online-karteikarten-pmp-processes/
http://www.flashcardexchange.com/iphone-flash-cards
https://quizlet.com/upgrade/?signup&redir=http%3A%2F%2Fquizlet.com%2F
And tools:
CoboCards
FlashCard+
Btw, I will use these tools for creating, maintaining and sharing our project knowledge also
And I got an idea to create a soft (called 'Social Flash Cards') to integrate into Facebook, Twitter, and sharing feature between users; taking a photo with notes for studying and share instantly to friends
And I learnt from the guy - Christian Kienle - who made and published flash cards tool an interesting term "Prototyping driven developer" that sounds cool. He created hundred applications based on his own idea and publish, few of them, acquired by firm, company to make commercial
Wednesday, August 1, 2012
Speed up your iphone by stopping daemons
Your iPhone basically is a Unix (MacOSX) power-based phone, that sounds cool!?
So to speed up your iPhone, you just simply stop un-used, or rarely use services (call daemon in Unix)
Here are 4 steps:
1/ Get access to your iPhone terminal (ssh, MobileTerminal)
2/ Learn launchctl command (with parameter: start, stop, list, load, unload)
3/ Using launchctl with parameter "list" to see un-used, rarely used daemons, and "stop" it, or "unload" it from startup
4/ Move (do not delete - in case you want to get back those services) those .plist file away from /System/Library/LaunchDaemons/
These are links for your reference:
1/ Related to command line: http://www.ifans.com/forums/threads/ssh-daemon-wont-start.87039/
This shows you how to load, unload daemon from startup also
2/ Related to daemons: http://www.ijailbreak.com/how-to/how-to-remove-launch-daemons-to-increase-speed-battery-life-disk-space-part-two/
3/ This week, when I reviewed my post, and after working around I found this very detail and interesting article. It explains very detail which Daemon you can stop & in which situation
http://forums.macrumors.com/showthread.php?t=1371126
Finally, use it at your own risk, but warranty there is no damage to you iPhone, iPad
Here are 4 steps:
1/ Get access to your iPhone terminal (ssh, MobileTerminal)
2/ Learn launchctl command (with parameter: start, stop, list, load, unload)
3/ Using launchctl with parameter "list" to see un-used, rarely used daemons, and "stop" it, or "unload" it from startup
4/ Move (do not delete - in case you want to get back those services) those .plist file away from /System/Library/LaunchDaemons/
These are links for your reference:
1/ Related to command line: http://www.ifans.com/forums/threads/ssh-daemon-wont-start.87039/
This shows you how to load, unload daemon from startup also
2/ Related to daemons: http://www.ijailbreak.com/how-to/how-to-remove-launch-daemons-to-increase-speed-battery-life-disk-space-part-two/
3/ This week, when I reviewed my post, and after working around I found this very detail and interesting article. It explains very detail which Daemon you can stop & in which situation
http://forums.macrumors.com/showthread.php?t=1371126
Finally, use it at your own risk, but warranty there is no damage to you iPhone, iPad
Tuesday, May 29, 2012
Wednesday, May 16, 2012
Myself study on BI - Business Intelligence (TBC)
Business
Intelligence Research
I.
ETL Testing
A.
As Informatica Product Specification
1.
Source and Destination Loading one-one (no
transformation)
2.
Source and Destination Loading with
transformation
·
Using pre-built operators in Informatica Product
to build transformation, there is no need of programming skill
3.
Production Validation: validate if the source
data loaded into Production environment correctly
B.
As GeekInterview.com
Testing covers:
1.
Data validation within Staging to check all
·
Mapping Rules
·
Transformation Rules
2.
Data validation within Destination to check if
·
Data is present in required format
·
There is no data loss from Source to Destination
C.
Data-centric Testing
Applied specific to
ETL processes where data movement happens
1.
Technical
Testing: Technical testing ensures that the data copied, moved or loaded
from the source system to target system correctly and completely. Technical
testing is performed by comparing the target data against the source data. List
of testing techniques:
a.
Checksum
Comparison: to check if quantitative information of both source and
destination database is the same using Checksum technique. For example: number
of records from source database compared to destination; ACCUMULATED
information on source database compared to CALCULATED information on
destination database, eg: summarized annual data for monthly salaries in the
source database (total salaries of months
of all employees) causes new column in destination database to contain sum
of monthly salaries paid within a year for each year (total salaries of years of all employees). These two values should
be equal
b.
Domain
Comparison: Compare list of unique entries (field-unique of records) in
source database to unique entries in destination database. For example: List of
Employee Name in the Salary table of source database to List of Employee Name
in the destination database; like Dictionary List
c.
Multi-value
Comparison: Similar to Domain/Dictionary/List comparison, multi-value
comparison compares the WHOLE record or the CRITICAL columns between source and
destination database, and MATCHING between these columns. For example: Domain
comparison reports correctness of Employee List between source, destination
database; Checksum comparison reports correctness of Salary entries between
source and destination database; but these comparisons not guarantee the
correctness of assigning Salary entry to Employee entry (MATCHING between
columns). Multi-value comparison discovers such issues by comparing the key
columns/attributes of each record between source and destination database
2.
Business
Testing: To validate business common senses, eg: Salary/Commission cannot
be less than zero. There is a list of
exhaustive rules to test against, and it depends on domain knowledge, industry.
Need
research list of best practices
3.
Reconciliation:
Ensures that the data in the destination database is in agreement with the
overall system requirements. Examples of how the reconciliation helps in
achieving high quality data:
a.
Internal reconciliation: the data within the destination
database gets compared against each other (mostly in business constraint
terms), eg: number of shipments always less than or equal to number of orders,
otherwise it’s invalid
b.
External reconciliation: the data within the
destination database gets compared to other (external) system, eg: Number of
Employees in the destination database cannot be larger than Number of Employees
in the HR Employee Master System
Source: http://etlguru.com/blog/?p=172
II.
ETL Implementation Strategy
A.
Suggested Strategy by ETLGuru.com
1.
Theory
·
Every time there is a movement of data, there is
a need of data validation
·
There are various of test conditions during
migration from DEV to QA, QA to PRODUCTION
2.
Practice
·
A better ETL strategy is to store all the
BUSINESS RULES into centralized tables, even in source for target system, these
rules can be in SQL text.
·
This is a kind of repository that can be called
from any ETL processes, auditors at any phase of project life cycle. There is NO
need to re-think, re-write the rules
·
Any or all of these rules can be made OPTIONAL,
TOLERANCE can be defined, CALLED immediately after process runs or data can be
audited at leisure
·
This data validation/auditing system basically
contains:
a. The
tables contain the rules
b.The process to call
dynamically
c. The
tables to store results from the execution of the rules
·
Benefits
a. Rules
can be added dynamically with no change to ETL code
b.Rules are stored dynamically
c. Tolerance
level can be changed with ever changing to ETL code
d.Business Rules can be added
or validated by Business Expert without worrying about ETL code
·
This practice can be applied to ETL tools,
Databases: Informatica, DataStage, SyncSort DMExpress, Sunopsis, Oracle,
Sybase, SQL Server Integration (SSIS)/DTS,
Source: http://etlguru.com/blog/?p=22
III.
ETL Architecture Design
A.
Study shows:
There are 3 proposed layers:
1.
Layer 1: Data relational: extract, transform,
load from source to destination
2.
Layer 2: Control, Log, Security and
Authorization of ETL processes, organize and call sub-processes
3.
Layer 3: Manage and Schedule ETL processes,
Recovery from Failure, Load Balancing, etc.
B.
Incremental Loading Design
1.
Change Data Capture: there are 3 main approaches
·
Log-based CDC
·
Audit columns
·
Calculation of snapshot differentials
2.
F
IV.
Advanced (mostly for Large Scalable
Database/Volume)
A.
MapReduce
B.
Hadoop
C.
A Highly Scalable Dimensional ETL Framework
based on MapReduce
Tuesday, May 1, 2012
Websites/tools supporting Regular Expression check & generate
During working with .htaccess file (RewriteRule) I found these tools useful for checking & generating RegExpression
http://martinmelin.se/rewrite-rule-tester/
http://htaccess.madewithlove.be/
http://regexpal.com/
http://txt2re.com/index.php3?s=http://localhost:8282/images/dvd/index.php&-8&-16
http://gskinner.com/RegExr/
Subscribe to:
Posts (Atom)