Skip to main content

A personal and portable database server: The CQL card

  • Conference paper
  • First Online:
Applications of Databases (ADB 1994)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 819))

Included in the following conference series:

Abstract

Database applications and technologies are of central importance in many information systems a person may encounter. To obtain services, the end-users are required a smart card (plastic card containing a microcomputer), which is a device providing information about the user's identity and some related personal data. It can be updated and loaded with new data that will be used during further sessions. Moreover the data contained into the smart card can be used by other information systems, the data are carried away from a site to another. The individual mobility increases the need for a person to carry information about himself anywhere and at any time. For services providers, such as health professionals, it is essential to access to this information stored on several information systems. In many applicative areas, to provide different information systems linked and networked is a real challenge. Based on personal information about the bearer, the smart card is a key to access to different information systems and a mean to share and interchange data. The smart cards are evolving towards personal database functions. We briefly present the technology of smart cards, then we introduce a new approach: the CQL card (for Card Query Language). This card integrates the concepts of the Database Management Systems. Database engine is carried out by the card microcomputer, the card is a new database machine. It manages “users” entities which handle different “objects” according to their “privileges”. CQL, a subset of SQL, is used to communicate with the card. Views enable sharing data among information systems. Access rights and privileges guarantee the data privacy. To ease the integration of this portable database we have implemented an ODBC driver enabling smart card connectivity with many applications and DBMS's. The smart card as a personal and mobile data server is a new support for databases, it involves new applications, such as health care cards or administrative document cards, and new ways of carrying and interchanging information.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. R. Beuscart and P. Paradinas. Smart Cards for Health Care, in Telematics in Medicine, Elsevier Science Publishers B.V., North-Holland, 1991.

    Google Scholar 

  2. M.L. Brodie. The promise of distributed computing and the challenges of legacy information systems, in IFIP Transactions A-25, Interoperable Database Systems (DS-5), Elsevier Science Publishers B.V., North-Holland, 1993.

    Google Scholar 

  3. J. Mc Crindle. Smart cards, IFS Publications, Springer-Verlag, 1990.

    Google Scholar 

  4. Gemplus. CQL Card and Language Reference Manual, Gemplus, 1992.

    Google Scholar 

  5. E. Gordons and G. Grimonprez. A card as element of a distributed database, IFIP WG 8.4 Workshop, P. Paradinas and G. White: The portable office. Microprocessor cards as elements of distributed offices, Ottawa, Canada, 1992.

    Google Scholar 

  6. G. Grimonprez, and P. Paradinas. A new approach in code development: C_Card and Cossack, in proceedings of CardTech'91, Washington D.C., U.S.A., 1991.

    Google Scholar 

  7. L. Guillou, J-J. Quisquater, and M. Ugon. The Smart Card: A standardised Security Device Dedicated to Public Cryptology, Ed G. Simmons: Contemporary Cryptology, IEEE-Press, 1992.

    Google Scholar 

  8. European Nervous System (ENS). The INCA project (Information network and card for the adaptated management of European road transport), number E20003, EEC Documentation, 1992.

    Google Scholar 

  9. ISO/IEC 7816-1. Identification cards — Integrated circuit(s) cards with contacts: Dimensions and locations of the contacts, ISO, 1987.

    Google Scholar 

  10. ISO/IEC 7816-2. Identification cards — Integrated circuit(s) cards with contacts: Physical characteristics, ISO, 1988.

    Google Scholar 

  11. ISO/IEC 7816-3. Identification cards — Integrated circuit(s) cards with contacts: Electronic signals and transmission protocols, ISO, 1989.

    Google Scholar 

  12. ISO/IEC 7816-4. Identification cards — Integrated circuit(s) cards with contacts: Interindustry commands for interchange (CD), ISO, 1992.

    Google Scholar 

  13. ISO/IEC 9075. Information Technology — Database — SQL, ISO, 1992.

    Google Scholar 

  14. Microsoft Corporation. Microsoft Open Database Connectivity Backgrounder, Microsoft, October 1992.

    Google Scholar 

  15. P. Paradinas. The CQL Database Smart Card, GMD, Smart Card Workshop, Darmstadt, Germany, February 1994.

    Google Scholar 

  16. M. Paterson. “Memories are made of this...” ...a look at memory considerations for Smart Card applications, Semiconductor engineering bulletin, Motorola Ltd, 1990.

    Google Scholar 

  17. P. Peyret. RISC-Based, Next-Generation Smart Card Microcontroller Chips, in proceedings of CardTech'94, Washington D.C., U.S.A., April 1994.

    Google Scholar 

  18. P. Paradinas and J.J. Vandewalle. How to integrate Smart Cards in Standard Software without writing specific code?, in proceedings of CardTech'94, Washington D.C., U.S.A., April 1994.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Witold Litwin Tore Risch

Rights and permissions

Reprints and permissions

Copyright information

© 1994 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Paradinas, P., Vandewalle, JJ. (1994). A personal and portable database server: The CQL card. In: Litwin, W., Risch, T. (eds) Applications of Databases. ADB 1994. Lecture Notes in Computer Science, vol 819. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58183-9_65

Download citation

  • DOI: https://doi.org/10.1007/3-540-58183-9_65

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-58183-3

  • Online ISBN: 978-3-540-48473-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics