A DBMS supporting multiple codesets and collations.

by Yen-Hui Hung.Thesis (M.Phil.)--Chinese University of Hong Kong, 1997.Includes bibliographical references (leaves 76-78).Abstract --- p.iAcknowledgments --- p.iiiChapter 1 --- Introduction --- p.1Chapter 2 --- Background ®Chapter 2.1 --- Multilingual Information Processing --- p.6Chapter 2.1.1 --- Codesets --- p.6Chapter 2.1.2 --- Converters --- p.8Chapter 2.1.3 --- Collations --- p.8Chapter 2.1.4 --- Internationalization and Localization --- p.9Chapter 2.2 --- OBST --- p.10Chapter 2.3 --- Related Work --- p.11Chapter 2.3.1 --- Sybase --- p.11Chapter 2.3.2 --- Oracle --- p.13Chapter 2.3.3 --- COBASE --- p.15Chapter 2.3.4 --- SQL92 Standard --- p.15Chapter 3 --- Defects of Existing Systems and Proposed Language Extensions --- p.21Chapter 3.1 --- Defects of Existing Methods - Locale Model --- p.22Chapter 3.2 --- Defects of SQL92 --- p.22Chapter 3.3 --- Proposed Language Extensions --- p.24Chapter 3.3.1 --- Inserting tuples --- p.24Chapter 3.3.2 --- Updating tuples --- p.25Chapter 3.3.3 --- Querying (Retrieving tuples) --- p.26Chapter 3.3.4 --- String matching --- p.26Chapter 3.3.5 --- Performing Joins --- p.28Chapter 3.3.6 --- Sorting and Indexing --- p.30Chapter 4 --- DBMS Design and Implementation --- p.32Chapter 4.1 --- System Architecture --- p.34Chapter 4.2 --- Lexical Analyzer and Parser --- p.36Chapter 4.3 --- Database Objects --- p.37Chapter 4.4 --- Data Dictionary --- p.39Chapter 4.5 --- Character Objects Related Facilities --- p.41Chapter 4.5.1 --- Codesets --- p.42Chapter 4.5.2 --- Collations --- p.46Chapter 4.5.3 --- Converters --- p.48Chapter 4.6 --- Indexing --- p.50Chapter 4.7 --- Query Processor --- p.52Chapter 4.7.1 --- Join --- p.54Chapter 4.7.2 --- Sorting tuples - the order by clause --- p.54Chapter 4.7.3 --- "Group Structure, Aggregate Functions and Projection" --- p.55Chapter 4.8 --- Scalar and Conditional Expressions --- p.56Chapter 4.8.1 --- Representation of Scalar and Condition Expressions --- p.57Chapter 4.8.2 --- Implementations --- p.58Chapter 4.9 --- User Interface --- p.59Chapter 5 --- Case Study - A Bookshop --- p.62Chapter 5.1 --- Creating tables and inserting tuples --- p.62Chapter 5.2 --- Updating Tuples --- p.65Chapter 5.3 --- Querying --- p.65Chapter 5.4 --- String Matching --- p.66Chapter 5.5 --- Performing Joins --- p.67Chapter 5.6 --- Ordering Display --- p.68Chapter 5.7 --- Indexing --- p.70Chapter 6 --- Conclusions and Future Work --- p.73Bibliography --- p.76Chapter A --- Grammer Rules --- p.79Chapter A.1 --- Data Definition Language --- p.79Chapter A.2 --- Data Manipulation Language --- p.82Chapter A.3 --- Condition Expressions --- p.83Chapter A.4 --- Scalar Expressions --- p.84Chapter A.5 --- Data Type --- p.85Chapter A.6 --- Names and Identifiers --- p.87Chapter A.7 --- Lexical Element --- p.88Chapter B --- Programmers' Guide --- p.90Chapter B.l --- Charset.obst --- p.92Chapter B.2 --- Table.obst --- p.95Chapter B.3 --- dbSchema.obst --- p.101Chapter B.4 --- dbEnv.obst --- p.103Chapter B.5 --- Query.obst --- p.104Chapter B.6 --- Misc.obst and External.obst --- p.117Chapter B.7 --- Main --- p.118Chapter B.8 --- RPC interfaces --- p.120Chapter C --- Installation Manual --- p.122Chapter C.l --- Steps to install the DBMS server --- p.123Chapter C.2 --- Steps to install the WWW client --- p.124Chapter D --- User Manual --- p.125Chapter D.l --- User Interface Layout --- p.125Chapter D.2 --- Steps in Performing Database Operations --- p.128Chapter D.2.1 --- Creating new tables --- p.129Chapter D.2.2 --- Browsing existing tables --- p.131Chapter D.2.3 --- Inserting new records --- p.131Chapter D.2.4 --- Deleting records --- p.132Chapter D.2.5 --- Creating indexes --- p.132Chapter D.2.6 --- Showing existing schemas and tables --- p.13