Standard Relational and Network Database Languages


Book Description

For any type of software to become standard, whether a third genera tion language or an integrated project support environment (IPSE), it must undergo a series of modifications and updates which are a direct result of theoretical and empirical knowledge gained in the process. The database approach to the design of general purpose infonn ation systems has undergone a series of revisions during the last twenty years which have established it as a winner in many different spheres of infonnation processing, including expert systems and real time control. It is now widely recognised by academics and practitioners alike, that the use of a database management system (DBMS) as the under lying software tool for the development of infonnation/knowledge based systems can lead to environments which are: (a) flexible, (b) efficient, (c) user-friendly, (d) free from duplication, and (e) fully controllable. The concept of a DBMS is now mature and has produced the software necessary to design the actual database holding the data. The database languages proposed recently by the International Organisa tion for Standardisation (ISO) are thorough enough for the design of the necessary software compilers (i.e programs which translate the high level commands into machine language for fast execution by the computer hardware). The ISO languages adopt two basic models of data and therefore two different sets of commands: (a) the relational, implemented via the relational database language (RDL), and (b) the network, imple mented via the network database language (NDL).




Database Systems


Book Description

Covers the important requirements of teaching databases with a modular and progressive perspective. This book can be used for a full course (or pair of courses), but its first half can be profitably used for a shorter course.
















Text and Context


Book Description

Text and Context: Document Storage and Processing describes information processing techniques, including those which do not appear in conventional textbooks on database systems. It focuses on the input, storage, retrieval and presentation of primarily textual information, together with auxiliary material about graphic and video data. There are chapters on text analysis as a basis for lexicography, full-text databases and information retrieval, the use of optical storage for both ASCII text and scanned document images, hypertext and multi-media systems, abstract document definition, and document formatting and imaging. The material is treated in an informal way with an emphasis on real applications and software. There are, among others, case studies from Reuters, British Airways, St. Bartholomew's Hospital, Sony, and HMSO. Relevant industry standards are discussed including ISO 9660 for CD-ROM file storage, CCITT Group4 data compression, the Standard Generalised Markup Language and Office Document Architecture, and the Postscript language. Readers will benefit from the way Susan Jones has brought together this information, in a logical sequence, to highlight the connections between related topics. This book will be of interest to second and third year undergraduates and MSc students in computer science, to B/TEC HTD final year computing and information science students either specialising in IT or taking an IT option, and to students taking courses in IT and in business computing systems.







SQL: 1999


Book Description

SQL: 1999 is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database. - Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards. - Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages. - Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases. - Explores key issues for programmers linking applications to SQL databases. - Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL. - Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.




Handbook on Architectures of Information Systems


Book Description

An authoritative source about methods, languages, methodologies and supporting tools for constructing information systems that also provides examples for references models. Its strength is the careful selection of each of the above mentioned components, based on technical merit. The second edition completely revises all articles and features new material on the latest developments in XML & UML. The structure follows the definition of the major components of Enterprise Integration as defined by GERAM (Generalised Enterprise Reference Architecture and Methodology). 1st edition sold about 600 copies since January 2003.