如何实现类似脉脉网的二维人际关系
以下是简化的数据和场景
==========================数据========================
用户信息:
用户ID[ID] 、用户名[NAME]用户关系:
用户ID1[UID1] 、 用户ID2[UID2] 、 标签[LABEL]用户状态:
用户ID[UID] 、 内容[CONTENT]
==========================场景========================
假设存在3个用户。
ID|NAME
1|A
2|B
3|C相互的关系为:
UID1|UID2|LABEL
1|2|亲戚
2|3|同事场景:
A发布一个状态
UID|CONTENT
1|hello world!!
==========================结果=========================
C能看到A发布的状态,并且知道这个状态是同事B的亲戚A发布的
==========================问题=========================
求一个最简单 最容易理解 对系统压力最小 的方案????
=========================抛砖引玉=======================
我目前想到有2种方案
1.只记录一条状态,二维关注的用户都能通过关系查询到这条状态。
优点:逻辑简单
缺点:系统压力指数级增长
2.记录冗余状态,当用户发布状态时,所有二维关注的用户都会记录一条状态。
优点:系统压力较小
缺点:数据冗余很大
回复内容:
以下是简化的数据和场景
==========================数据========================
用户信息:
用户ID[ID] 、用户名[NAME]用户关系:
用户ID1[UID1] 、 用户ID2[UID2] 、 标签[LABEL]用户状态:
用户ID[UID] 、 内容[CONTENT]
==========================场景========================
假设存在3个用户。
ID|NAME
1|A
2|B
3|C相互的关系为:
UID1|UID2|LABEL
1|2|亲戚
2|3|同事场景:
A发布一个状态
UID|CONTENT
1|hello world!!
==========================结果=========================
C能看到A发布的状态,并且知道这个状态是同事B的亲戚A发布的
==========================问题=========================
求一个最简单 最容易理解 对系统压力最小 的方案????
=========================抛砖引玉=======================
我目前想到有2种方案
1.只记录一条状态,二维关注的用户都能通过关系查询到这条状态。
优点:逻辑简单
缺点:系统压力指数级增长
2.记录冗余状态,当用户发布状态时,所有二维关注的用户都会记录一条状态。
优点:系统压力较小
缺点:数据冗余很大
优选一,因为用户增长过程中,可以上memcache redis 和 第二种方案.
冗余一个ID 不就行了么。而且我觉得冗余本身可以容易一层关系,二层关系,一层关系内容ID,两层关系内容ID,当然你说的这个直接冗余内容也是可以的考虑的。
微信朋友圈做的阅读权限代码就是不冗余的,直接读取的时候现算。这个是因为它需要根据是否朋友动态调整的。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



The main reasons why you cannot log in to MySQL as root are permission problems, configuration file errors, password inconsistent, socket file problems, or firewall interception. The solution includes: check whether the bind-address parameter in the configuration file is configured correctly. Check whether the root user permissions have been modified or deleted and reset. Verify that the password is accurate, including case and special characters. Check socket file permission settings and paths. Check that the firewall blocks connections to the MySQL server.

When MySQL modifys table structure, metadata locks are usually used, which may cause the table to be locked. To reduce the impact of locks, the following measures can be taken: 1. Keep tables available with online DDL; 2. Perform complex modifications in batches; 3. Operate during small or off-peak periods; 4. Use PT-OSC tools to achieve finer control.

Data Integration Simplification: AmazonRDSMySQL and Redshift's zero ETL integration Efficient data integration is at the heart of a data-driven organization. Traditional ETL (extract, convert, load) processes are complex and time-consuming, especially when integrating databases (such as AmazonRDSMySQL) with data warehouses (such as Redshift). However, AWS provides zero ETL integration solutions that have completely changed this situation, providing a simplified, near-real-time solution for data migration from RDSMySQL to Redshift. This article will dive into RDSMySQL zero ETL integration with Redshift, explaining how it works and the advantages it brings to data engineers and developers.

1. Use the correct index to speed up data retrieval by reducing the amount of data scanned select*frommployeeswherelast_name='smith'; if you look up a column of a table multiple times, create an index for that column. If you or your app needs data from multiple columns according to the criteria, create a composite index 2. Avoid select * only those required columns, if you select all unwanted columns, this will only consume more server memory and cause the server to slow down at high load or frequency times For example, your table contains columns such as created_at and updated_at and timestamps, and then avoid selecting * because they do not require inefficient query se

In MySQL database, the relationship between the user and the database is defined by permissions and tables. The user has a username and password to access the database. Permissions are granted through the GRANT command, while the table is created by the CREATE TABLE command. To establish a relationship between a user and a database, you need to create a database, create a user, and then grant permissions.

MySQL has a free community version and a paid enterprise version. The community version can be used and modified for free, but the support is limited and is suitable for applications with low stability requirements and strong technical capabilities. The Enterprise Edition provides comprehensive commercial support for applications that require a stable, reliable, high-performance database and willing to pay for support. Factors considered when choosing a version include application criticality, budgeting, and technical skills. There is no perfect option, only the most suitable option, and you need to choose carefully according to the specific situation.

MySQL cannot run directly on Android, but it can be implemented indirectly by using the following methods: using the lightweight database SQLite, which is built on the Android system, does not require a separate server, and has a small resource usage, which is very suitable for mobile device applications. Remotely connect to the MySQL server and connect to the MySQL database on the remote server through the network for data reading and writing, but there are disadvantages such as strong network dependencies, security issues and server costs.

MySQL database performance optimization guide In resource-intensive applications, MySQL database plays a crucial role and is responsible for managing massive transactions. However, as the scale of application expands, database performance bottlenecks often become a constraint. This article will explore a series of effective MySQL performance optimization strategies to ensure that your application remains efficient and responsive under high loads. We will combine actual cases to explain in-depth key technologies such as indexing, query optimization, database design and caching. 1. Database architecture design and optimized database architecture is the cornerstone of MySQL performance optimization. Here are some core principles: Selecting the right data type and selecting the smallest data type that meets the needs can not only save storage space, but also improve data processing speed.
