Thursday, February 23, 2012

Structured Design Dialog Process (SDDP)


Structured Design Dialog Process (SDDP), as defined by Schreibman and Christakis, is the new geometry of languaging and new technology of democracy, “designed to overcome the propensity toward Spreadthink, Groupthink, and the ‘Erroneous Priorities Effect’ and to facilitate meaningful group dialogue that enhances the pursuit of community wisdom and power” (Schreibman & Christakis).
The term ‘Spreadthink’, as coined by Dr. John N. Warfield, is to describe the outcome of group dialogue that is infected with inherent human constraints:  1) The lack of a common language that facilitates members ‘s engaging in genuine dialogue, thus as a result, members talk in parallel or talk past each other instead of conversing. 2) The limited short-term ability to process information upon the multiple dimensions of reality affecting any complex issue, thus as a result, lead to information overload and 3) Different value systems which are deeply socialized during childhood or in the place they live and work.  With Spreadthink situation, the views of individual members are literally all over the map.  ‘Groupthink’, another term coined by Dr. Warfield, is a majority view of a group consensus that is arrived under pressure from a strong minority. Groupthink is the result of the deterioration of mental efficiency, quality of reality testing, and quality of moral judgment that results from in-group pressures. It lacks individual support and, usually lacks substance.  ‘Erroneous Priorities Effect’ problem is the outcome where discrepancies between words and actions are found.

For the Aquaculture project SDDP is used to facilitate true, meaningful dialog that guides decision making process.  Researchers and community organizers will get together and each will generate a list of intentions.  The team then will choose a set of 12 intentions that received the most votes. A strategic method such as Delphi method can be utilized in order to explore the influences among the 12 chosen intentions.  The influences then will be arranged with the most influential ones at the base. This influence tree pattern is called a ‘tree of meaning’ by Dr. Christakis. The tree of meaning is the result of the co-laboratory of Democracy process. While working in the democracy process, always keep in mind the following 6 dialogue laws are used to promote meaning and wisdom in dialogue:

1. Appreciation of the diversity of perspectives of observers is essential to embrace the many dimensions of a complex situation.
2. Disciplined dialogue is required so that observers are not subjected to information overloaded.
3. The relative importance of an observer's ideas can be understood only when they are compared with others in the group.
4. Meaning and wisdom of an observer's ideas are produced in a dialogue only when they begin to understand the relationships such as similarity, priority, influence, etc., of different people's ideas.
5. Every person matters, so it is necessary to protect the autonomy and authenticity of each observer in drawing distinctions.
6. Evolutionary learning occurs in a dialogue as the observers learn how their ideas relate to one another.




Dr.  Warfield (1925 – November 17, 2009) was an Americansystems scientist, who was professor and director of the Institute for Advanced Study in the Integrative Sciences (IASIS) at George Mason University.

Dr. Christakis is the founder of the international non-profit Institute for 21st Century Agoras (GLOBAL AGORAS) and past-president of the International Society of Systems Sciences. You can find one of the newest interviews with him here:

Friday, February 17, 2012

Kevin Kelly on the next 5,000 days of the Web - Ted Talk

The World Wide Web as we know is only 5000 days old. What’s happening in the next 5000 days?  Kevin Kelly’s Ted Talk focuses on areas such as social media, the Internet Cloud and other forces such as personalization, transparency and transferring culture that are transforming the current internet into the ONE machine. The current internet, interconnecting into ONE single global machine is the most reliable machine anyone can ever imagine, with zero downtime, serving 100 billion clicks a day, 8 terrabytes per second traffic, 55 trillion internet links  and using up 5% of energy of the planet.
Kelly thinks we need to get better at believing in the impossible. Well, I think the advanced technologies are there – but I don’t have the same imagination of a global utopia.  And I am afraid that the high personal cost for the illusion of transparency and global culture is too high. Once I read about a lady who rented some movies at Block Buster and later found the details of her transactions on her Facebook wall. (Apparently, Facebook and Block Buster exchanged this information against the Video Privacy Protection Act). This scared me so I have made efforts to not expose myself too much on the Internet. However, googling my name, and I can find past and current addresses, complete with satellite pictures and map from google, home price and other stuff. Not that I think these info are particularly interesting, but the idea of having my personal information on the Internet always makes me feel uncomfortable.
The 8PM news today informs us about how US big brothers are planning to scan Facebook and monitor Twitter in a bid to thwart any sign of social disorder within the United States and to predict global events such as the current Arab Springs. It reminds us that the ONE machine is not really ours but it belongs to the governments. When the Chinese Communists can dictate what information Google search engine can serve up to Chinese, and when British Prime Minister advocates the power of the government to shut down Internet access during the times of public riots, we are also reminded that within the ONE machine, are many sub machines, and they are not owned by us. 
Perhaps it is possible that, as the world citizens are more educated and technologies are more advance,  the gap of digital divide will no longer be visible, resources will be plentiful, world peace will be achievable and people will be 'let go'. Until then, the governmental control of the Internet and the individual lost of control though personalization will remain the two biggest negative forces. 

Thursday, February 16, 2012

Animoto

Tuesday, January 31, 2012

Delphi Research Method - just a thought on Curing World Hunger with Aquaculture

Curing World Hunger with Aquaculture 2025
Aquaculture is defined as the rearing of aquatic organisms under controlled or semi-controlled conditions. Aquaculture is not new. Many ancient civilizations had used some form of aquaculture. In China, the aquaculture can be traced back to around 3500 B.C. with the culture of the common carp. In 475 B.C. The oldest document on fish culture was written by Fan Li, a politician and administrator, dated back to 475 B.C. His document described methods for pond construction, brood stock selection, stocking, managing ponds and fish harvesting. In ancient Egypt, aquaculture seems to have evolved in parallel with the development of irrigation. Even though there is no document exists, drawings in tombs, dated back to about 2000 B.C. showed the aquaculture of tilapia. Other cultures such as the ancient Rome, English and European all had some types of aquaculture dating back many thousand years.
One aspect of aquaculture is called aquaponics, or the combination of aquaculture and hydroponics. Many scientists and researchers believe aquaponics could be a key component to a more sustainable, resilient food system. I believe aquaponics is the solution to world hunger. Culturally speaking, it is something humans have done for thousands of years but in much smaller scales. With advance in science and technology, new approaches to aquaponics can be developed and taught to tribes, villages, towns, cities all over the world.

Let’s say that the goal for the project is “to solicit expert opinion for a set of standard turnkey aquaponic systems catering to different topographies, weathers and cultures”, I think the Delphi method of research is probably best suit for this project. The participants will be from different parts of the world. They can conduct their own onsite research including pilot studies; refine their views as they learn from their experiences and as they receive feedback from the research team.
In addition to the ‘cultural readiness’ for the project, the need for inland communities to have sea and fresh water products, the need to decrease pressure on wild fisheries, and the need to have products from green and clean sources are all positive environmental forces. Government grants and private donation will make the project possible, however, until the technology become cheaper, some of the systems are still too expensive to implement, one example is the RAS (Recirculating Aquaculture System). Local and international rules, regulations and restrictions may also impact the project. These governmental forces will need to be studied up front in the feasibility study.

Wednesday, January 25, 2012

Watching TED – Dr. Quyen Nguyen – Color coded surgery

http://www.ted.com/talks/quyen_nguyen_color_coded_surgery.html
In this presentation, Dr. Quyen Nguyen demonstrated and discussed how a molecular marker can make tumors light up in neon green, showing surgeons exactly where to cut.
In this fascinating conversation, Dr. Nguyen talked about the surgeons’ special relationship with light: They need lights in order to perform operations. In ancient time, skylight was important. In modern time, operating rooms have specialized lights which mimic natural lights.
This ‘relationship’ with lights brought the surgeons to other kinds of lights – lights that can allow them to see what they currently don’t see. Dr. Nguyen is talking about the magic of fluorescence light and how it can be used to color code organs, nerves and rumors in order to assist in surgery.
She has demonstrated several cases, from cancer tumors that turn florescent green, to nerves that turn florescent white. The tool for identifying cancer tumors is a protein molecule, developed by Dr. Roger Chen (who went on to win the Nobel Prize for chemistry in 2008) and his team, that when injected into the veins of someone who has cancer, the cancer parts will be lit up with green fluorescent color. With the help of Dr. Chen and his team, Dr. Nguyen discovered another protein molecule that turns nerves to florescent white. These molecules help guide surgeons in what to destroy and what to preserve.
The Cancer Journal for Clinicans statistics for 2011 put Cancer as one of the most major public health problems in the United States and many other parts of the world with one in 4 deaths in the United States is due to cancer. Many of us are either cancer patients or have family members or friends with cancer and we know how difficult or impossible it is to get rid of it even with multiple surgeries. This is because the surgeons never know what they have to remove and whether they have removed enough. In addition, the cost for chemotherapy, drugs and cosmetic surgeries post cancer surgeries can be horrendous. According to the U.S. Center for Disease Control and Prevention, one in five patients is not able to get necessary cancer treatment in time or at all because of the high cost. Imagine with this technology, the surgery will be so précised and much more affordable that more lives will be saved. Imagine with this technology, molecules can be used as a vehicle to deliver drugs directly to the cancer cells. That's even better than surgery! Imagine with improvement, they can invent different colors for different types of cancer so that treatment can be done even more precisely and more effectively!

In the final note, Dr. Nguyen leaves us with the following final thought:
“Successful Innovation is not a single break through. It’s not a sprint. It’s not an event for a solo performer. It’s a team sport, it’s a relay race. It requires one team for the breakthrough and another team to get the breakthrough accepted and adopted. And this takes the long term steady courage of the day in day out struggle to educate, to persuade and to win acceptance.”
In the comments section, one has left his final thought:
“This is presented in a very humble way.
But to me this is ground breaking.
It made me physically shake.”
And I concur!

Wednesday, January 18, 2012

Reading the Horizon Report

Reading the Horizon Report
The report highlights six of the fifty emerging technologies with considerable potential for teaching, learning and creative inquiry. For the near term, electronic books and mobiles are moving closer to mainstream adoption for educational purposes. Modern electronic readers support note taking, research activities, and social interaction while mobiles, which are the preferred tool for Internet access for most, are capable computing and learning devices. For the next two to three years, Horizon sees the emerging of augmented reality and game-based learning. These exist in popular culture, and have already made their appearances on a number of campuses. With the advance of hardware, software and network communication, these technologies are being integrated into course works and many institutions have already used the potential of ‘games for learning’ to foster collaboration, problem-solving, and procedural thinking. Looking to the far-term horizon, which is four to five years from now, it is speculated that gesture based computing and learning analytics are garnering significant interest and exposure.  Gesture-based computing moves the control of computers from a mouse and keyboard to the motions of the body via new input devices such as Kinect, SixthSense, and Tamper. With learning analytics, data of student engagement, performance and progress are gathered and analyzed in order to revise curricula, teaching and assessment in real time.
The technologies described are very interesting. During Christmas time, I got the firsthand experience with gesture-based computing via a Kinect/Xbox game called Dance Central, in which,the Kinect technology reads the player's moves as he dances according to the dance routine playing out for him and judges how well he does it compare to his competitor. It was one of the most fun times for our family gathering.  I think the combination of augmented reality technology and gesture-based computing can make classroom teaching and presentation fun and natural (as opposed to point and click). 

Thursday, June 9, 2011

Oracle 10g - Changing Character sets

Database Version: Oracle 10g-11g
Problem:
ORA-03106: fatal two-task communication protocol error
on insert
Root cause:
Problem with wrong charactersets.
Database was created with:

NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET UTF8

But required character sets are:

NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

*** To verify ***
sqlplus > SELECT * FROM NLS_DATABASE_PARAMMETERS

Solutions:


You basically have three options:
1. Drop the database and recreate with the right charactersets.
2. Drop the problematic schemas, change the charactersets, then reimport
3. Manually alter the charactersets as per Oracle's instructions
The option you choose  will depend on how severe is the problem.

In this cheatsheet, we dropped the problematic schemas, change the charactersets, then reimport.
The steps below are to change the charactersets. Note that you must change both  NLS_CHARACTERSET
and NLS_NCHAR_CHARACTERSET. Otherwise, it won't work.

Prepare:


1. Take a full backup
2. Take a backup copy of the spfile
3. Run csminst.sql
    from $ORACLE_HOME/rdbms/admin/csminst.sql
    You will be prompted for User CSMIG password CSMIG

4. Run a full database csscan from the command line:
    Make sure your library path points to the right library:
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    csscan sys/syspassword as sysdba  full=y tochar=WE8ISO8859P1

Enter new database character set name: > WE8ISO8859P1
Enter array fetch buffer size: 1024000 >
Enter number of scan processes to utilize(1..32): 1 > 8
Enumerating tables to scan...
 . process 1 scanning W2ADMIN.EXTERNAL_CLEANSED_SKU_HIST[AAAouzAATAAA++JAAA]
 . process 2 scanning W2ADMIN.EXTERNAL_CLEANSED_SKU_HIST[AAAouzAAQAAA9sJAAA   
Creating Database Scan Summary Report...
Creating Individual Exception Report...
Scanner terminated successfully.
Creating Database Scan Summary Report... 
Creating Individual Exception Report...
Database Scan Individual Exception Report


 [Database Scan Parameters]

Parameter                      Value
------------------------------ ------------------------------------------------
CSSCAN Version                 v2.1
Instance Name                  DEVDB2
Database Version               10.2.0.3.0
Scan type                      Full database
Scan CHAR data?                YES
Database character set         AL32UTF8
FROMCHAR                       AL32UTF8
TOCHAR                         WE8ISO8859P1
Scan NCHAR data?               NO
Array fetch buffer size        1024000
Number of processes            8
Capture convertible data?      NO
------------------------------ ------------------------------------------------

[Data Dictionary individual exceptions]


[Application data individual exceptions]
*** our DB is 300gb. Even    that, csscan still ran very fast.


Check the exception report from csscan. You must work on the exception report until there is no more exception before you can go on to the next step, thus, at this point, you should evaluate which strategy works for you.
In my case, since I had a lot of errors, I have decided to do the following steps
- Drop the schemas
- Rescan (rerun csscan)
- Alter the charactersets
- Recreate the schemas - by reimporting from production

Execute:



 *** You will need to change both default database characterset, or NLS characterset ***
sqlplus / as sysdba
STARTUP MOUNT exclusive RESTRICT
ALTER SYSTEM ENABLE RESTRICTED SESSION; 
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
ALTER DATABASE OPEN ;
SQL> @$ORACLE_HOME/rdbms/admin/csalter.plb;

0 rows created.



Function created.


Function created.


Procedure created.

This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?Y
old   6:     if (UPPER('&conf') <> 'Y') then
new   6:     if (UPPER('Y') <> 'Y') then
Checking data validility...
begin converting system objects
6 rows in table SYS.SQL$TEXT are converted
3114 rows in table SYS.WRI$_ADV_ACTIONS are converted
17 rows in table SYS.WRI$_DBU_HWM_METADATA are converted
748 rows in table SYS.WRH$_SQLTEXT are converted
4 rows in table SYS.RULE$ are converted
6704 rows in table SYS.WRH$_SQL_PLAN are converted
617 rows in table SYSTEM.SYS_IMPORT_FULL_04 are converted
3529 rows in table SYS.FGA_LOG$ are converted
79 rows in table SYS.WRI$_DBU_FEATURE_METADATA are converted
17322 rows in table SYS.WRI$_ADV_OBJECTS are converted
80 rows in table SYS.METASTYLESHEET are converted
2323 rows in table SYS.WRI$_ADV_RATIONALE are converted
426 rows in table SYSTEM.SYS_IMPORT_FULL_01 are converted
2 rows in table SYS.EXTERNAL_TAB$ are converted
28 rows in table SYS.WRI$_DBU_FEATURE_USAGE are converted

PL/SQL procedure successfully completed.

update props$ 
set value$='AL16UTF16' 
where name = 'NLS_NCHAR_CHARACTERSET'; 
commit;
SHUTDOWN IMMEDIATE;

can now restart the database and verify if the characterset changes have been applied. Additionally, you need to revert the ‘job_queue_processes’ and ‘aq_tm_processes’ initialization parameters to their original values.

 You should be able to check:

SELECT * FROM NLS_DATABASE_PARAMETERS

Shouldbe:
NLS_CHARACTERSET      WE8ISO8859P1
NLS_NCHAR_CHARACTERSET     AL16UTF16

FOR RAC ONLY:

If the database is a RAC database, you must be in a single instance/single user mode before running 'csalter.plb':
1) shutdown one node and open up the DB in a single instance and single user mode:
2) set cluster_database=false


SQL> alter system set cluster_database=false scope=spfile;

System altered.
Sql> shutdown immediate
Sql> startup restrict
Sql> @csalter.plb