107969
Research, Consultancy and Academic Activities
[NEW] [DELETE] [Edit]
Research
[NEW] [DELETE] [Edit]
1994-present
- Database re-engineering and interoperability, data warehousing, data mining and XML database.
- A research grant of HK$159,000 has been approved for a research project on "Methodology for Relational Database Systems Conversion", sponsored by CPHK, starting 1992 for two years.
- A research grant of HK$279,485 has been approved for a research project on "Methodology for Converting from Relational to Object-Oriented Database Systems: A Re-engineering Approach", sponsored by CPHK, starting 1995 for two years.
- A research grant of HK$282,860 for a research project on "Methodology for the Interoperability and Integration of Relational and Object-Oriented Databases", sponsored by CityU, starting 1995 for two years.
- A research grant of HK$500,000 for a research project of "Sybase Adaptive Server" sponsored by Sybase Hong Kong Ltd, starting July 1997 to June 1998 for 1 year.
- Received HK$200,000 to support for a patent application by the Industry Department of the Hong Kong SAR Government Patent Application Grant.
- Received HK$270,000 grant for a research project on "Translating Hierarchical or Network Database Programs to Relational: A Reverse Engineering Approach", sponsored by CityU Strategy Research Grant, starting 1999 for one and half year.
- Received HK$225,400 grant for a research project on "Architecture of Open Object Database Connectivity Through Internet", sponsored by CityU Strategy Research Grant, starting 2000 for one and half year.
- An Innovation and Technology Fund of HK$1,120,000 on "Non-stop Internet Computing with Replicate Relational XML Databases for Information Highway", starting August, 2004 for two years.
- Received Strategic Research Grant for fundable CERG HK$182,114 on “The XML tree model – toward a unified view of XML schemas DTD and XSD for constraints-preserving transformation”, starting July 2005 for one year.
- Received Strategic Research Grant HK$180,000 on “XSD – Builder: an XML Schema Definition generator with Component and Constraints Declarative Language”, starting July 2006 for two years.
- Received Strategic Research Grant HK$180,000 on “An XML-enabled Data Warehouse for Aggregation with XQuery”, starting March 2007 for two years.
12/1999-Present
- Chairman, Hong Kong Web Society
1/2005-6/2005
- Teaching consultant at University of Macau
6/97-present
- Chairman of Sybase Hong Kong User Group
3/94-6/95
- Guest Consultant to Sybase Hong Kong Limited
6/89-6/1990(part time)
- Aeronautical Radio, Inc, Annapolis, MD
Contractor
Generate N-S Charts for 150,000 lines of production Cobol programs. Feasibility study of converting from unstructured Cobol programs to structured Cobol programs.
8/87-10/87
- Fireman's Fund Insurance Company, San Rafael, CA
Contractor
Successfully installed a IMS DC tool, Application Development Shell version 3, written in Cobol and DL/I. This tool was the system architecture for other IMS DC transactions.
- External Assessor for the validation of the franchise of the B.Sc. Honor Business Information Systems
Programme; and the Joint Honors Programme in Computing & Multimedia Technology of Middlesex University to the Research Institute of Technology University at Shenzen (RITS), China
- External examiner for M.Phil student Wan Po Many Polly's thesis on "Feature Extraction and
Pattern Matching in Time Series Data" at the Chinese University of Hong Kong, 2001.
- External module assessor for Open University of Hong Kong MT800 Information Technology &
Software Development from 2000 to 2001.
- External course assessor for Open University of Hong Kong MT258 Programming and Databases
from 1999 to present.
- External Examiner and External module assessor for Open University of Hong Kong MT268
Commercial Information Processing from 1996 to1999.
- Course Leader of MSc in Software Engineering/Information System Management of Staffordshire
University, UK. Since 1996.
- Regional Coordinator of Very Large Data Base International Conference in 1996.
- Program committee member for the 14th International Conference on Object-Oriented and Entity-
Relationship Modeling
- Presented two papers on "Methodology for Scheme Translation from Hierarchical or Network to
Relational Database" and "A Re-engineering Approach for Object-Oriented Database Design" to staff
and graduated students at Beijing Polytechnic University, 5 January, 1995.
- Regional Coordinator, the 4th International Conference on Extending Database Technology, 28-31
March 1991, December 1992 and February 1994.
- Provided training to Oracle users on Two Phase Commit, Snapshot, and PL/SQL.
- Presented a paper on "Methodology for system conversion to relational database", for the Hong Kong
Oracle Users Group, 1993.
- Provided a seminar on "Survey on CASE tools in Database Design Methodology", for the Hong Kong
Institution of Engineers, 1992.
- Referee for reviewing papers submitted to Information and Software Technology, a UK computer
journal, 1992.
- Chairman of annual International Database Conference since 1989 to present:
- 1st International Database Workshop on Conversion to Database System in 1989.
- 2nd International Database Workshop on Data Modelling Techniques in 1990.
- 3rd International Database Workshop on Distributed Database Systems in 1991.
- 4th International Database Workshop on Database Management Horizon in 1992.
- 5th International Database Workshop on Next Generation Database Systems in 1994.
- 6th International Database Workshop on Database Reengineering and Interoperability in 1995.
- 7th International Database Workshop on Multimedia, Knowledge-Based & Object-Oriented Databases in 1996.
- 8th International Database Workshop on Data Mining, Data Warehousing & Client/Server Databases in 1997.
- 9th International Database Conference on Heterogeneous and Internet Databases in 1999.
- 10th International Database Symposium on Mobile, XML and Post-relational Databases in 2000.
- 9th IFIP 2.6 Working Conference on database semantics (DS-9) semantic issues in e-commerce systems, 2001.
- 1st International Web-based Learning in 2002
- 2nd International Web-based Learning in 2003
- 3rd International Web-based Learning in 2004.
- 4th International Web-based Learning in 2005.
- 5th International Web-based Learning in 2006.
- Web-based Project Competition in 2003.
- Hong Kong Web Society
- Eta Kappa Nu
- Tau Beta Pi
- California Instructor Credential in Computer and related Technologies