Abstract: A system and method for identifying potential member and guest contacts while protecting member data privacy at a social networking system are disclosed. A system stores contact information for a plurality of members of a social networking system. The system receives a list of contacts of the first member. For a contact, the system accesses contact information of the contact, compares the contact information in the contact to contact information for the plurality of members, and in accordance with a determination that the contact information in the contact matches the contact information of a member of the social networking system, generates a score that the contact is not associated with malicious activity. In accordance with a determination that the generated score exceeds a predetermined score threshold, the system categorizes the contact as a suggested member connection. The system transmits member referral data to the client device for presentation.

Abstract: In an example embodiment, confidential data submitted by a user and one or more attributes of the user are obtained from one or more submission tables in a confidential information database. It is then determined that the one or more attributes of the user correspond to a first slice. In response to the determining, a count associated with the first slice is incremented. The count associated with the first slice is compared with a first threshold. In response to a determination that the count associated with the first slice transgresses the first threshold, the confidential data and the one or more attributes are added to a backend queue. Then, extraction, transformation, and loading (ETL) of the confidential data in the backend queue is performed and the confidential data is placed in an ETL table, in the confidential information database corresponding to the first slice.