SQL Built-In Functions And Stored Procedures

Feng Shui practice has become an important reference for the planning and design of buildings, monuments and even entire cities. In fact Feng Shui is an evolved study of the natural and built environm

Benny Chia’s memoir of life on the fringe is a vivacious slice of Hong Kong’s life and cultural development at a time of minimal institutional support. His colourful and anecdotal story will interest culture practitioners as well as the general reader curious about the Fringe Club and its role as a seedbed for local artists and as a venue for international ones, both functions championed by Benny at the helm of this small but important institution housed in a distinctive former ice house in Central. general reader curious about the Fringe Club and its role as a seedbed for local artists and as a venue for international ones, both functions championed by Benny at the helm of this small but important institution housed in a distinctive former ice house in Central.

Tobias Klein explores applications of 3D printing in architecture, art, design and interactive media installations in order to create a fusion of contemporary CAD/CAM technologies built from natural m

How do public markets, as ordinary as they seem, carry the weight of a city’s history? How do sucheveryday buildings reflect a city’s changing political, social, and economic needs, through their yearslong transformations in forms, functions, and management? Integrating architecture and history, this book invites readers to go through the growth and governance of colonial Hong Kong by tracing the past and present of public markets as a study of extensive firsthand historical materials. As the readers witness the changes in Hong Kong markets from hawker pitches to classical market halls to clean modernist municipal complexes, the book offers a new perspective of understanding the familiar everyday markets with historical contexts possibly unfamiliar to most, studying markets as a microcosm of the city and a capsule of its history. -------------- This book is a robust and in-depth study of the market building history of Hong Kong since the 1840s and contributes to a holistic un

Adaptive reuse refers to reusing an old building for a purpose other than which it was originally built or designed. This conservation approach has become increasingly popular around the world. Howeve

Modern architecture has become increasingly concerned about the integration and harmony between the natural and built environments. Terms like environmental protection and management, energy conservat

The inspiring, haunting story of Chinese migrant workers rejected by the USA who built a new community in Mexico.From the 1850s, as the United States pushed west, Chinese migrants met ordinary Americans for the first time. Alienation and xenophobia lost the US this chance for cultural and economic enrichment—but America gave the Chinese new perspectives, connections, and dreams of their own. As teenagers, Hugo Wong’s great-grandfathers fled poverty in Guangdong for California. A decade later, excluded from the US, they helped establish a Chinese settlement across the border in Mexico, led by a world-famous dissident-in-exile with visions of a New China overseas. They would be among the Americas’ first Chinese magnates, meeting with presidents, generals, and missionaries, living through astonishing victories and humiliating defeats. The bitterest of all would be the colony’s tragic demise amid a violent Mexican revolution, leading to the largest massacre and deportation of Chinese in Am

Revitalization in Asia: Adaptive Reuse in Macao, Mumbai, and Penang offers a clear understanding of the value of sustainable adaptive reuse within an Asian context. Three highly urbanized places (Macao, Mumbai, and Penang) are considered in detail from conservation and planning perspectives (with essays and timelines for each). For each place, five case studies offer a comparative framework for understanding similarities and differences in adaptive reuse projects. Six essays examine adaptive reuse in terms of its connection to the three dimensions of sustainability, with reference to the United Nations’ Sustainable Development Goals. This book is envisioned as a continuation of Asian Revitalization: Adaptive Reuse in Hong Kong, Shanghai, and Singapore.

In Christianity and Education in Modern China, Wong Man Kong, George Kam Wah Mak, and other contributors demonstrate how Christianity served as a driving force in the development of modern education in China. Each of the chapters offers new insights into Christian involvement in different issues concerning education in modern China. The contributors examine how Christian missionaries and Chinese Christian educators interacted with China’s social, cultural, and political contexts. Also explored are the Christian legacies of higher education in mainland China and Taiwan, as well as how the spirit of Christian higher education in modern China has been carried on in Asia. This volume suggests that Western missionary and Chinese Christian perspectives of higher education were complementary with each other in modern China.

Psychosis and Schizophrenia in Hong Kong covers some of the most serious mental health conditions that top the global disease burden and affect 3 per cent of the general population. However, most research on psychotic disorders is undertaken in the West, and few studies have been systematically carried out in Asia despite global interest in regional differences. This work offers a unique and coherent account of these disorders and their treatment in Hong Kong over the last thirty years.Chen and his research programme’s pioneering work has ranged from the impact of early intervention on outcomes and relapse prevention, to the renaming of psychosis to reduce stigma. The studies have contributed to wider international debates on the optimal management of the condition. Their investigations in semantics and cognition, as well as cognition-enhancing exercise interventions, have provided novel insights into deficits encountered in psychotic disorders and how they might be ameliorated. The re

Population ageing is a challenge to societies worldwide in terms of healthcare, social support, community infrastructure, and more. With one of the longest life expectancies in the world, Hong Kong will soon see a dramatic increase in the number of older residents together with a decrease in the old age dependency ratio. This book provides a timely examination of the current status and services available for Hong Kong’s ageing population in four key areas: general healthcare needs, such as health promotion and lifestyle modifications; specific healthcare needs, including care of chronic conditions and hip fractures; psychosocial needs for older people with intellectual disabilities and impairments, as well as the needs of their caregivers; and environmental and technological needs in relation to universal design, information and communication technology, and telehealth.Drawing from a wide range of experience in local professional settings combined with international best practices, the

An analysis of the lessons learned from tuberculosis control in Shanghai. Tuberculosis Control and Institutional Change in Shanghai, 1911-2011 is the first book on the most widespread and deadly infectious disease in China, both historically and today. Weaving together interviews with data from periodicals and local archives in Shanghai, Rachel Core examines the rise and fall of tuberculosis control in China from the 1950s to the 1990s. Under the socialist work unit system, the vast majority of people had guaranteed employment, a host of benefits tied to their workplace, and there was little mobility--factors that made the delivery of medical and public health services possible in both urban and rural areas. The dismantling of work units amid wider market reforms in the 1980s and 1990s led to the rise of temporary and casual employment and a huge migrant worker population, with little access to health care, creating new challenges in TB control. This study of Shanghai will provide valu

This book, the first of its kind in Hong Kong, offers insights from experts in healthcare and higher education both locally and further afield. Key learnings and recommendations are presented in three sections: disaster management and reconstruction, including what we can learn from past earthquakes; the importance of healthcare and emergency medicine in disasters and community events; and the way forward, in particular how technology and systems thinking can be used for disaster mitigation.

Studies in Colloquial Chinese and Its History: Dialect and Text presents cutting-edge research into issues regarding prestige colloquial languages in China in their spoken forms and as well as their relationship to written forms and the colloquial literary language. These include the standard regional languages and prestige dialects of the past, the influence of historical forms of spoken Chinese on written Chinese, the history of guānhuà and the history of báihuà, proto-dialects and supra-regional common languages (koines), and their relationship to spoken dialects. The various studies in this collection focus on the dialect groups with the most substantial written tradition, including Mandarin, Wu, Min, and Cantonese, in north, central and eastern coastal, and southern China respectively. The contributors explore the histories of these dialects in their written and spoken forms, presenting a variegated view of the history and development of the regional forms, including their evoluti

Masculinity, fast-changing and regularly declared to be in the throes of crisis, is attracting more popular and scholarly debate in China than ever before. At the same time, Chinese literature since 1989 has been characterized as brimming with countercultural ‘attitude’. This book probes the link between literary rebellion and manhood in China, showing how male writers, as they critique the outcomes of decades of market reform, also ask the same question: how best to be a man in the new postsocialist order?In this first full-length discussion of masculinity in post-1989 Chinese literature, Pamela Hunt offers a detailed analysis of four contemporary authors in particular: Zhu Wen, Feng Tang, Xu Zechen, and Han Han. In a series of insightful readings, she explores how all four writers show the same preoccupation with the figure of the man on the edges of society. Drawing on longstanding Chinese and global models of maverick and marginal masculinity, and responding to a desire to retain a

The present volume is a collection of selected papers of the international conference on “Translation and Modernization in East Asia in the 19th and Early 20th Centuries,” organized by the Research Ce

From ancient times, China's remote and exotic South—a shifting and expanding region beyond the Yangtze River—has been an enduring theme in Chinese literature. For poets and scholar-officials in mediev

As a Cultural construct, gender is fictional and imagined, yet its ideological and representational effects on the formation of self and identity are quite real. The fiction behind the fictional, which many accepts as truth, is at the core of what is most intriguing about the problem of gender. Critiquing this narrative, Gender, Discourse, and the Self in Literature unravels the strategies that writers and filmmakers adopt in their (de)construction of the gendered self in three Chinese communities: mainland China, Taiwan, and Hong Kong. Writing from the vantage points of film, literature, and gender studies, contributors make an innovative marriage to Western gender discourse and the construction and representation of self and identity in contemporary China.

In traditional China, upper-class literati were inevitably strongly influenced by Confucian doctrine and rarely touched upon such topics as love and women in their writings. It was not until the mid-T

Buildings create an environment where people work and live, thus affecting their quality of life. In Hong Kong, as in other major metropolitan cities, buildings define its city image and are the hub o

The first half of the 20th century was a time of great change in China. After the 1911 Revolution, leaders like Sun Yat-sen and Chiang Kai-shek tried to modernize the government, education, defense, and more. With the onset of the Second Sino-Japanese War and later occupation of Hong Kong, the focus of both the Kuomintang and the Chinese Communist Party shifted to resistance efforts in order to survive. And who did they turn to for help?To his children, Lee Sik-pang (李錫彭) was just an artist and antiques dealer in Hong Kong until the family immigrated to the United States in the late 1950s. So why did several of his watercolor paintings depict possible Allied bombing targets? And how did he know so many famous people, including Sun Fo (Sun Yat-sen’s son), Admiral Henry Hsu of the Republic of China Navy, and the British High Commissioner-General for Southeast Asia Malcolm MacDonald?By answering these questions and many more, this book argues that Lee Sik-pang was not only an accomplished

Escaping the End of Times is a book where history meets psychology. It invites readers to explore the intricate relationships between dreams, politics, and the Chinese writing system in early modern China.Thoroughly researched and written in an accessible manner, this book presents a series of historical encounters that reveal how Ming scholars countered instability by compiling and editing dream texts. Readers learn how these scholars translated their dreams into action, used the past to bolster their status, reaffirmed their preferred societal order, merged myth and history, and interpreted their dreams and the dreams of others through creative techniques grounded in scholarly tradition.By combining detailed research with captivating storytelling, this book not only brings the world of late Ming dream analysis to life but also demonstrates the relevance of the past to the stories we tell now about ourselves and our own dreams.

In The New Politics of Beijing–Hong Kong Relations, Sonny Shiu-Hing Lo looks at the diverging changes to the ideologies from both Beijing and Hong Kong, and the ideological conflicts as taken in the form of factional political struggles between 2012 and the present. This book examines the paternalistic authoritarianism that can be seen in Beijing’s policy toward Hong Kong since the promulgation of the national security law in late June 2020. Lo analyzes the ideological shift from liberal nationalism to conservative nationalism in mainland China, which has taken place since late 2012. The increasingly radical localism in Hong Kong after 2014 transformed Beijing–Hong Kong relations into a conflict-ridden situation characterized by factional struggles. While the imposition of the national security law into Hong Kong since late June 2020 has stabilized the city politically, Beijing’s policy toward Hong Kong is now guided by the principles of protecting its national security and maintaining

In Gentle Voices, Bold Strides, Professor Fanny Cheung shares her inspiring journey as a psychologist, academic leader, and champion of gender equality. Growing up in a traditional Hong Kong family, she recognized early injustices against women and dedicated her life to change.Pioneering gender studies in Asia and leading the Equal Opportunities Commission, she fought discrimination, domestic violence, and gender bias in policy and research. Her leadership reshaped academia and public policy through consensus-building and quiet determination, leaving a legacy of empowerment.By blending personal narratives with social history, this memoir serves as a testament to the power of advocacy and the quiet strength of those who strive to make a difference.

The third edition has undergone significant revisions from the second edition, which was published in 2011. Significant enhancements include coverage of　advancements in electronic commerce and financialtechnology (fintech), particularly the adoption of blockchain-based letters of credit and internet of things. Readers will gain valuable knowledge about trade developments in fintech, blockchain, and important trade promotion institutions in the Greater Bay Area.This book offers comprehensive and well-structured content, making it an excellent resource for training professionals such as bankers, import/export managers, and lawyers.It is particularly beneficial for students enrolled in the Finance of International Trade module of the Professional Diploma for Certified Banker offered by the Hong Kong Institute of Bankers, helping them prepare effectively for their examinations.

Written in Stone by Polo Bourieau is an extraordinary exploration of how monumental sculpture transforms urban spaces into places of meaning and connection. From the ancient marble quarries of Carrara to the skyscrapers of Hong Kong or the bustling lanes of Chengdu, this richly illustrated book charts Polo’s creative journey, offering profound insights into the dialogue between sculpture, architecture, and community.Structured as an epic narrative inspired by Joseph Campbell’s monomyth theory, Polo’s sculptures become the protagonists of our common narrative of adventure, transformation, and identity. With reflections on the creative process and a conversation with urban planner and design writer Catherine Shaw, the book delves into the challenges and realities of creating public art in the dynamic landscapes of 21st-century China.Written in Stone offers a philosophical meditation on the power of art to shape our cities and ourselves. It invites readers—whether city planners,

‘We must have a procedure – if we are going to hang anyone – that is just,’ said Chief Justice Sir Francis Piggott in 1909, on discovering that Chinese accused of murder were being denied interpretation in Hong Kong’s courts. Due process, no matter how costly or inconvenient, was ‘one of the penalties of empire,’ he declared.Penalties of Empire explores how judges, juries, and lawyers strove to deliver justice during the 150 years when the death penalty was in force in Hong Kong. Nine main chapters focus on key capital trials in the first century of British rule. Among the cases are piracies, assassinations, and crimes of passion and desperation. These chapters describe the proceedings in court and the participants involved. They also explore the debates surrounding each case and the exercise or denial of mercy by governors. Two final chapters discuss the decline of the death penalty after World War II, its suspension after 1966, and the controversies leading to its formal abolition in

Asian Celebrity Cultures in the Digital Age represents the first comprehensive study on the transformations of celebrity cultures in increasingly globalised and digitalised Asian societies. It discusses relations between Asian celebrities and digital media across emerging phenomena in celebrity practices, cultures, politics, fandom, and economies. Highlighting original case studies from prominent Asian societies, including India, China, Hong Kong, the Philippines, Singapore, Vietnam, Indonesia, Thailand, South Korea, and Japan, this book sheds much-needed light on the de-Westernisation and internationalisation of celebrity studies and is essential reading for scholars and students in celebrity, fandom, digital media and communication, and cultural studies.

In A New Documentary History of Hong Kong, 1945–1997, Florence Mok, Fung Chi Keung Charles, and other contributors analyse newly released archival records from the National Archives in London, the Government Records Service in Hong Kong, and other sources across the world. This documentary collection provides an updated and improved understanding of basic aspects of the city such as governance, economy, society, and culture. It also aims at investigating topics that are under-exploited in previous sourcebooks, such as race and diasporas, gender and familial relations, medicine and healthcare, and environment and natural disasters. Overall, this book offers an innovative and comprehensive long-term perspective of Hong Kong’s colonial history.

In an epic historical story that talks directly to our times, Cross and Dragon dramatizes the life of one of the most famous Western figures in China: Italian Jesuit Matteo Ricci. Sent by the Pope in the late 16th century to convert the Chinese Emperor, Ricci was faced with a “mission impossible” as China in the Ming Dynasty did not allow foreigners to enter the country.

In Lu Xun and World Literature, Xiaolu Ma, Carlos Rojas, and other contributors examine various aspects of Lu Xun, who is known as the father of modern Chinese literature. Essays in this book focus on Lu Xun’s works in relation to the notions of world literature and processes of literary worlding. The contributors offer detailed analyses of Lu Xun’s own literary oeuvre and of foreign works that engage with his writings. This volume also focuses on many facets of the publication and dissemination of Lu Xun’s works’, from printing and binding to the discussions and debates that followed their release in China and abroad. This book not only makes an important contribution to the field of Lu Xun studies, but also proposes a reexamination of the category of world literature.

In Socializing Medicine, Pao-chen Tang, Yuqian Yan, and Ling Zhang explore the intersections of medicine, health, and East Asian media. Interweaving archival research, audiovisual analyses, and theoretical insights from the emerging field of health humanities, the book reveals the multifaceted ways in which the mass media—from photography and film to television and live streaming—has been deployed as a tool for controlling medicine and health, privileging those with power and authority from the early twentieth century to the present. Adopting anti-colonial and anti-capitalist perspectives, the contributors in this volume challenge the dominant mediations of health against the backdrop of imperialism, Cold War geopolitical tensions, and neoliberal capitalism. Collectively, they advocate for alternative understandings of medical culture through media productions that envision accessible and equitable healthcare practices.

This volume is a translated and edited collection of studies on the Shi ji (Records of the historian) by SimaQian, authored by the prestigious Japanese sinologist Miyazaki Ichisada. Providing a pathbreaking analysis of the structure and formation of the Shi ji, it serves not only as an excellent introduction to Sima Qian’s masterpiece but also offers historiographical and methodological insights that will stimulate further debate and research.In this volume, Miyazaki presents fascinating evidence of the influence of narrative fiction and drama in Sima Qian’s recreation of the entire length and breadth of Chinese history right up to his own time. By establishing a foundational model for writing comprehensive histories in China, Sima Qian’s work is essential for understanding the subsequent tradition of historical writing. This volume offers readers valuable insights into how Sima Qian constructed his seminal work.A monument of Japanese scholarship on the Shi ji, Prof. Miyazaki Ichisada’

Wisdom means learning to live with ambivalence and to embrace uncertaintyHelga Nowotny’s memoir provides a detailed account of her life, highlighting the challenges and triumphs of a woman who defied convention in the male-dominated field of science. From her early days in science and technology studies, where she faced bureaucratic hurdles, to her influential role in shaping the European Research Council, Nowotny offers a candid look at her career. She shares personal stories of navigating the complexities of academia and policy, revealing the uncertainties and contingencies that shaped her life and work. This memoir resonates with anyone who has pursued a path less traveled, and offers a glimpse into the resilience and ambition required to succeed in challenging environments.Future Needs Wisdom is not really a memoir, nor is it an intellectual history, nor is it entirely a personalreflection or a summative philosophy. It is, in fact, all of these things fused together: her life, her

Most histories of Hong Kong begin with the arrival of the British, and only incidentally mention the precolonial eras. In this book, Patrick Hase, one of the leaders in the field, provides an important addition to the history of Hong Kong and the Pearl River Delta region, covering topics such as Chinese ethnicity, commerce, port-towns, and squatting. It is a truly excellent work that will interest historians, anthropologists, and social scientists.—James L. WatsonFairbank Professor of Chinese Society and Anthropology Emeritus,Harvard UniversityThis book, an historical and archaeological portrayal of Hong Kong market villages across the territory, depicts how Hong Kong evolved not through chronicles of emperors and governors but through the ups and downs of different centres of rural life over the centuries. It belongs beyond the bookshelves of historians and archaeologists—anyone wandering the streets of Hong Kong neighbourhoods today wondering “how did this place get to be here?” wil

This book examines the British cultural engagement with Hong Kong in the second half of the twentieth century. It shows how the territory fit unusually within Britain’s decolonisation narratives and served as an occasional foil for examining Britain’s own culture during a period of perceived stagnation and decline. Drawing on a wide range of archival and published primary sources, Hong Kong and British Culture, 1945–97 investigates such themes as Hong Kong as a site of unrestrained capitalism, modernisation, and good government, as well as an arena of male social and sexual opportunity. It also examines the ways in which Hong Kong Chinese embraced British culture, and the competing predictions that British observers made concerning the colony’s return to Chinese sovereignty. An epilogue considers the enduring legacy of British colonialism.

With an increasing concern of personal data privacy in Hong Kong and around the world, the Office of the Privacy Commissioner for Personal Data (PCPD), Hong Kong publishes this third edition of Personal Data (Privacy) Law in Hong Kong: A Practical Guide on Compliance to provide practical guidance on the law of privacy, and the ways to protect personal data in everyday life.This third edition will guide readers through the recent developments of personal data privacy in the local, regional and global contexts with updates on recent Administrative Appeals Board and Court decisions, and investigation reports and materials from the PCPD. In addition, some most-concerned issues are discussed, such as ethical development and use of AI, the collection and use of personal data by employers during COVID-19, data protection under work-from-home arrangements, data security measures for ICT systems, guidelines on doxxing offences and data breach handling. This book will certainly provide readers a

This book tells the truly unique life story of Dr. John Maeda, a visionary leader in multiple fields and recipient of a City University of Hong Kong Honorary Doctorate. The book discusses Dr. Maeda’s most interesting experiences, from his childhood at his parents’ tofu factory in Seattle to his days as an MIT professor, a pioneering digital artist, Silicon Valley venture capitalist, and more. It is suitable for readers interested in art, design, technology, artificial intelligence, and theAsian immigrant family experience in the United States.

How did lay people in old China save their lives when dealing with acute or chronic health issues? Conventional medicine was costly and might not have been an option for many. Instead, people in villages and towns relied on remedies drawn from a woodblock-printed illustrated booklet called the Seventy-Two Therapies, first published in 1847. The goal of this book is to foster an appreciation of China’s long tradition of folk remedies. Each folk remedy is illustrated by a page from the circa 1860s woodblock edition of the Seventy-Two Therapies which the author used for translation. He also added a historical and interpretive analysis to expand on each therapy and to place it in the context of contemporary thinking, aiming at academics and readers interested in the everyday lives of common people in pre-1950 China, and in the folk medicine wisdom inherited from the past. ------------------------------------------------------------------------------- “The 72 specific disease

From humble beginnings in Hong Kong, Yuen Kwok-Yung rose to international prominence as an academic, physician, and microbiologist. As an advisor to governments, he and colleagues made discoveries that helped the world cope in often controversial ways with unprecedented threats to public health, including the COVID-19 pandemic. In this compelling memoir, Dr. Yuen weaves personal stories with those from his extraordinary medical careers to take readers on an inspiring journey about perseverance, courage, faith, and the ongoing peril of infectious diseases. threats to public health, including the COVID-19 pandemic. In this compelling memoir, Dr. Yuen weaves personal stories with those from his extraordinary medical careers to take readers on an inspiring journey about perseverance, courage, faith, and the ongoing peril of infectious diseases.