TAILIEUCHUNG - Consular Consolidated Database (CCD) Privacy Impact Assessment (PIA)

The DBMS field has always focused on capturing, organizing, storing, analyzing, and retrieving structured data. Until recently, there was limited interest in extending a DBMS to also manage text, temporal, spatial, sound, image, or video data. However, the Web has clearly demonstrated the importance of these more sophisticated data types. The general problem is that as systems add capabilities, it is hard to make these additions “cleanly.” Rather, there is a tendency to do the minimum necessary to. | Consular Consolidated Database CCD Privacy Impact Assessment PIA 1. Contact Information Department of State Privacy Coordinator Margaret P. Grafeld Bureau of Administration Information Sharing Services Office of Information Programs and Services 2. System Information a. Date PIA was completed March 22 2010 b. Name of system Consular Consolidated Database c. System acronym CCD d. IT Asset Baseline ITAB number 9 e. System description scope purpose and major functions The Consular Consolidated Database CCD is one of the largest Oracle based data warehouses in the world that holds current and archived data from the Consular Affairs CA domestic and post databases around the world. As of December 2009 it contains over 100 million visa cases and 75 million photographs utilizing billions of rows of data and has a current growth rate of approximately 35 thousand visa cases every day. It was created to provide CA a near real-time aggregate of the consular transaction activity collected domestically and at post databases worldwide. The CCD is the IT implementation that provides for a set of centralized visa and American citizen services supporting consular posts and back office functions. Three chief functions among the many performed by CCD are to support data delivery to approved applications via industry-standard Web Service queries provide users with easy-to-use data entry interfaces to CCD and allow emergency recovery of post databases. Authenticated Department of State and other authorized government agency users utilize the CCD Portal to view the centralized data through a rich set of reports as well as to gain access to other applications. The CCD serves as a gateway to IDENT and IAFIS fingerprint checking databases the Department of State Facial Recognition system and the NameCheck system. During the course of consular processing activities at posts applications generate requests for information to CCD which are handled as queries and routed by the CCD system to the

• Cơ sở dữ liệu
• avoiding business
• interruption threats
• Complete data
• macroeconomic and financial
• restore confidence
• confidence
• complete systems
• minutes
• ensuring high