A personal and portable database server: The CQL card

  • Pierre Paradinas
  • Jean-Jacques Vandewalle
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 819)


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.


Personal Database Smart Card Database Interchange SQL ODBC 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [BP91]
    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. [Bro93]
    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. [Cri90]
    J. Mc Crindle. Smart cards, IFS Publications, Springer-Verlag, 1990.Google Scholar
  4. [Gem92]
    Gemplus. CQL Card and Language Reference Manual, Gemplus, 1992.Google Scholar
  5. [GG92]
    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. [GP91]
    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. [GQU92]
    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. [Inca92]
    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. [Iso1]
    ISO/IEC 7816-1. Identification cards — Integrated circuit(s) cards with contacts: Dimensions and locations of the contacts, ISO, 1987.Google Scholar
  10. [Iso2]
    ISO/IEC 7816-2. Identification cards — Integrated circuit(s) cards with contacts: Physical characteristics, ISO, 1988.Google Scholar
  11. [Iso3]
    ISO/IEC 7816-3. Identification cards — Integrated circuit(s) cards with contacts: Electronic signals and transmission protocols, ISO, 1989.Google Scholar
  12. [Iso4]
    ISO/IEC 7816-4. Identification cards — Integrated circuit(s) cards with contacts: Interindustry commands for interchange (CD), ISO, 1992.Google Scholar
  13. [Iso5]
    ISO/IEC 9075. Information Technology — Database — SQL, ISO, 1992.Google Scholar
  14. [Odbc92]
    Microsoft Corporation. Microsoft Open Database Connectivity Backgrounder, Microsoft, October 1992.Google Scholar
  15. [Par94]
    P. Paradinas. The CQL Database Smart Card, GMD, Smart Card Workshop, Darmstadt, Germany, February 1994.Google Scholar
  16. [Pat90]
    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. [Pey94]
    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. [PV94a]
    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

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Pierre Paradinas
    • 1
    • 3
  • Jean-Jacques Vandewalle
    • 1
    • 2
  1. 1.Rd2p, Recherche et Développement Dossier PortableCHRU CalmetteLille CédexFrance
  2. 2.Dép. d'InformatiqueUniversité LavalQuébecCanada
  3. 3.GemplusGémenosFrance

Personalised recommendations