How would you build TinyURL?

Focus on the core functionalities of a URL shortening service, including generating a unique short link, redirecting users from the short link to the original URL, and handling potential scalability issues. Discuss the database design for storing original URLs and their corresponding short links, considering how to ensure uniqueness and manage collisions. Address how you would implement tracking for analytics, such as click counts and user demographics, and think about security measures to prevent abuse of the service. Finally, consider the user experience, including how users would create and share links easily.