WO2012119431A1 - 一种基于多值属性的排序方法和设备 - Google Patents

一种基于多值属性的排序方法和设备 Download PDF

Info

Publication number
WO2012119431A1
WO2012119431A1 PCT/CN2011/079190 CN2011079190W WO2012119431A1 WO 2012119431 A1 WO2012119431 A1 WO 2012119431A1 CN 2011079190 W CN2011079190 W CN 2011079190W WO 2012119431 A1 WO2012119431 A1 WO 2012119431A1
Authority
WO
WIPO (PCT)
Prior art keywords
sorting
attribute
value
entity
valued
Prior art date
Application number
PCT/CN2011/079190
Other languages
English (en)
French (fr)
Inventor
曹俊亮
刘晓
Original Assignee
华为技术有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 华为技术有限公司 filed Critical 华为技术有限公司
Priority to CN201180001361.2A priority Critical patent/CN102369528B/zh
Priority to PCT/CN2011/079190 priority patent/WO2012119431A1/zh
Publication of WO2012119431A1 publication Critical patent/WO2012119431A1/zh

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • G06F16/24578Query processing with adaptation to user needs using ranking

Definitions

  • the present invention relates to the field of communications technologies, and in particular, to a method and a device for sorting based on multi-valued attributes. Background technique
  • a video in a description of a video may have multiple categories of information; a user's address book may have multiple
  • the embodiment of the invention provides a sorting method and device based on multi-valued attributes, which can intuitively display the sorting attribute values of the entity in the result set, so as to know the reason why the entity appears in a certain position, and meet the requirements of the application.
  • An embodiment of the present invention provides a method for sorting based on a multi-valued attribute, including: obtaining an indication of a multi-value attribute sorting manner of an entity, where the entity has a multi-valued attribute; Determining, according to the multi-value attribute sorting manner, the ordered multi-value attribute sorting manner to determine an sorting attribute value of the entity, and sorting the entity according to the sorting attribute value to obtain a sorting result;
  • An embodiment of the present invention provides a sorting device based on a multi-valued attribute, including: an obtaining unit, configured to obtain an indication of a multi-valued attribute sorting manner of the entity, where the entity has a multi-valued attribute;
  • a sorting unit according to the multi-valued attribute sorting manner, indicating the multi-valued attribute sorting manner to determine an sorting attribute value of the entity, and sorting the entity according to the sorting attribute value to obtain a sorting result;
  • a receiving unit configured to receive a query request for sorting an entity, where the query request carries a multi-value attribute sorting manner indication and a return sorting attribute value indication;
  • a sending unit configured to return a sorting result carrying the sorting attribute value according to the received query request for sorting the entity.
  • the multi-value attribute-based sorting method and device obtaineds an entity multi-value attribute sorting manner indication; and determines the sorting of the entity according to the multi-valued attribute sorting manner indicating the indicated multi-valued attribute sorting manner. Attribute value, and sorting the entity according to the sorting attribute value to obtain a sorting result, the entity having a multi-valued attribute; returning a sorting result carrying the sorting attribute value according to the received query request for sorting the entity,
  • the query request carries a multi-valued attribute ordering indication and a returning sorting attribute value indication. Therefore, the sorting attribute value of the entity can be visually displayed in the result set, so that the reason why the entity appears in a certain position can be known, the application requirement is satisfied, and the application can be further processed by the application.
  • FIG. 1 is a flowchart of a method for sorting based on multi-valued attributes according to an embodiment of the present invention
  • FIG. 2 is a flowchart of another method for sorting based on multi-valued attributes according to an embodiment of the present invention
  • FIG. 4 is a flowchart of another multi-value attribute-based sorting method according to an embodiment of the present invention
  • FIG. 5 is a flowchart of another embodiment of the present invention
  • FIG. 6 is a structural diagram of another sorting device based on multi-valued attributes according to an embodiment of the present invention
  • FIG. 7 is another multi-valued based on the embodiment of the present invention.
  • a structure diagram of the sorting device of the attribute detailed description
  • the data of the database supporting multi-valued attributes is organized in a domain.
  • the fields are similar to the tables in the relational database.
  • the data items contained in the domain are called entities (different databases supporting multi-valued attributes may have different names, such as entries). , items, etc., collectively referred to herein as entities).
  • Entities within a domain have the same type, each entity has a unique identifier within the domain, which is similar to the identity of the rows in the relational database; and an entity has one or more attributes, the attribute name and the relational database column name are similar, one
  • a multivalued attribute can have one or more attribute values, which are similar to the values of columns in a relational database.
  • Attributes in a database that support multi-valued attributes allow multiple values to exist, and data filtering can be based on these multiple values.
  • An attribute that can have multiple attribute values is called a multi-valued attribute, and correspondingly, the value of a multi-valued attribute can be referred to as a multi-valued attribute value.
  • Table 1 shows the data of a domain supporting a multi-valued attribute.
  • the serial numbers 1 and 2 are the identifiers of the entities;
  • Name, Sex, and Email are the attributes of the entity.
  • the attribute of the entity Email allows an entity There are multiple emails, then the attribute Email is a multi-valued attribute.
  • the attribute value of the Name attribute of the entity 1 is Zhang San
  • the attribute value of the Name attribute of the entity 2 is Li Si
  • the attribute value of the Sex attribute of the entity 1 is male
  • the attribute value of the Sex attribute of the entity 2 is male
  • Zhangsan@yahoo.com the multi-valued attribute values for the Email attribute of Entity 2 are lisi@yahoo.com and lisi@ 163.com.
  • an embodiment of the present invention provides a method for sorting based on a multi-valued attribute, including: S101: Obtain an indication of a multi-valued attribute sorting manner of an entity, where the entity has a multi-valued attribute; wherein, the multi-valued attribute is sorted.
  • the mode indication can be pre-configured or externally obtained, such as from a query request.
  • the multi-valued attribute sorting manner includes Any of the following: : All multi-valued attribute values of the entity participate in sorting as the sorted attribute value; the average of the multi-valued attribute values of the entity participates in sorting as the sorted attribute value; the sum of the multi-valued attribute values of the entity participates as the sorted attribute value Sorting; The maximum value of the entity's multi-valued attribute value is used as the sorting attribute value to participate in the sorting; the minimum value of the entity's multi-valued attribute value is used as the sorting attribute value to participate in the sorting; script mode.
  • the multi-valued attribute value of the entity may be calculated according to the multi-value attribute sorting manner, and the sorting attribute value of the entity is determined.
  • the multi-value attribute-based sorting method provided by the embodiment refers to the multi-value attribute sorting method.
  • the multi-value attribute sorting manner indicated by the indication determines the sorting attribute value, and the sorting attribute value of the entity can be visually displayed in the result set, so that the reason why the entity appears in a certain position can be known, the application requirement is satisfied, and the sorting result is conveniently applied.
  • the sort attribute value that causes the entity to appear in this position is highlighted and bolded on the web page, and so on.
  • an embodiment of the present invention provides another sorting method based on multi-valued attributes.
  • the sorting method in this embodiment is explained by taking the extension of the Structured Query Language (SQL) as an example.
  • SQL Structured Query Language
  • the server receives a query request that is sent by the application to sort the entity, and the query request carries a multi-value attribute sorting manner indication and a return sort attribute value indication. Wherein the entity has a multi-valued attribute.
  • the server (which can be a database) stores a domain named "films" as shown in Table 2.
  • the attribute Category is a multi-valued attribute
  • the attributes Category of the entities C1 and C2 respectively have two multi-valued attribute values, wherein the multi-valued attribute value of C1 is category 1 and category 3, and the multi-valued attribute value of C2 is another class 2 And category 4.
  • the specific query request is: Select *, SORT_ATTR from films order by Category ALL asc, where SORT_ATTR is the return sort attribute value indication, and ALL is the multi-value attribute ordering mode indication.
  • the multi-value attribute sorting manner indication in this embodiment takes ALL as an example.
  • the multi-value attribute ordering indication may also be any of the following, but is not limited to these types:
  • AVG The average of the multi-valued attribute values of the entity is used as the sorting attribute value to participate in the sorting.
  • the order mode is valid for numeric multivalued attribute values.
  • SUM The sum of the entity's multi-valued attribute values is used as the sorting attribute value to participate in the sorting. This sorting method is valid for numeric multi-valued attribute values.
  • MAX The maximum value of the multi-valued attribute value of the entity is used as the sorting attribute value to participate in sorting. This sorting method is effective for multi-valued attributes that support comparison, such as the value of a multi-valued attribute or a string.
  • MIN The minimum value of the entity's multi-valued attribute value is the most sorted attribute value to participate in the sorting. This sorting method is valid for multi-valued attributes that support comparison, such as the value of a multi-valued attribute or a string.
  • the multi-valued attribute value is calculated by the script (SCRIPT) (which can include combination) to obtain one or more values to participate in the sorting as the sorting attribute value.
  • S203 The server calculates the multi-valued attribute value of the entity according to all the value sorting manners indicated by the multi-value attribute sorting manner, and determines the sorting attribute value of the entity.
  • the sorting attribute value is used as the sorting attribute value to participate in the sorting.
  • the sort attribute values are: Category 1, Category 2, Category 3, and Category 4.
  • the server sorts the entities in ascending order according to the sorting attribute value, and obtains a sorting result.
  • the server returns a sort result carrying the value of the sort attribute.
  • the sorted results returned are shown in Table 3.
  • the query request may further include a filter condition
  • the query request is: Select *, SORT_ATTR from films where Category is not null order by Category ALL asc o where where Category is not null Filtering conditions
  • the method further comprises: the server filtering out the entity that satisfies the filtering condition, and then executing S203.
  • S203 correspondingly: The server calculates the multi-valued attribute value of the entity that satisfies the filtering condition according to all the value sorting manners indicated by the multi-value attribute sorting manner, and determines the sorting attribute value of the entity.
  • the multi-value attribute-based sorting method determines the sorting attribute value according to the multi-valued attribute sorting manner indicating all the sorting manners indicated, and includes the sorting attribute value in the returned sorting result, so the sorting attribute value may be
  • the returned sorting result knows the reason why the entity C1 or C2 appears in a certain position in the sorting result, thereby satisfying the requirements of the application, and is convenient for the application to further process the sorting result, for example, the sorting attribute that causes the entity to appear at this position.
  • the value is highlighted and bolded on the web page and so on.
  • by carrying a multi-value attribute ordering indication in the query request it is also possible to meet the flexible ordering requirements of the application.
  • the embodiment of the present invention provides another sorting method based on multi-valued attributes, and the scripting mode is taken as an example.
  • the attribute Email is a multi-valued attribute
  • the attribute Email of entity 1 has a multi-valued attribute value XiaoMing@ 163.com
  • the attribute of the entity 2 Email has two multi-valued attribute values HuaHua@sina.com and HuaHua @ 163. Com.
  • the server receives a query request that is sent by the application to sort the entity, where the query request carries a multi-value attribute sorting manner indication and a return sorting attribute value indication.
  • the specific query request is: Select * , SORT_ATTR from person order by Email SCRIPT "$VALUE.SubString ($VALUE.fmd (' @,) +1, $VALUE.length()-l)" asc, where, "$ VALUE.SubString ($VALUE.fmd (' @,) +1, $VALUE.length()-l)" means to take the domain name of Email as the sort attribute value.
  • the script can be carried in the query request; it can also be pre-configured in the server, and then the location of the script is specified in the query request. Scripting languages can be JAVA, Python, Shell or custom languages.
  • the multi-value attribute sorting manner in this embodiment indicates that SCRIPT is taken as an example.
  • the multi-valued attribute ordering indication can also be ALL, SUM, AVG, MIN or MAX, but it is not limited to these.
  • the server calculates a multi-value attribute value of the entity according to a script sorting manner indicated by the multi-value attribute sorting manner, and determines an sorting attribute value of the entity.
  • the sort attribute values are: 163.com, sina.com, 163.com.
  • the server sorts the entities according to the sorted attribute values, and obtains the sorting result.
  • the server returns a sort result carrying the value of the sort attribute.
  • the sorted results returned are shown in Table 5.
  • the query request may further include a filter condition
  • the query request is: Select *, SORT_ATTR from person where Email is not null order by Email SCRIPT "$VALUE.SubString ($VALUE.fmd (' @,) +1, $VALUE.length()-l)" asc.
  • Email is not null is a filtering condition
  • the method further includes: before the S303, the server filters out the entity that meets the filtering condition, and then executes S303.
  • S303 is correspondingly: the server calculates the multi-valued attribute value of the entity that satisfies the filtering condition according to all the value sorting manners indicated by the multi-value attribute sorting manner, and determines the sorting attribute value of the entity.
  • 2 HuaHua Femal HuaHua @sina. com 163.com
  • the multi-value attribute-based sorting method provided by the embodiment determines the sorting attribute value according to the multi-valued attribute sorting manner, and includes the sorting attribute value in the returned sorting result, so that the sorting result may be included in the returned sorting result.
  • the sorting attribute value the reason why the entity 1 or 2 appears in a certain position in the sorting result is obtained, thereby satisfying the application requirement, and the application is further processed by the application, for example, the sorting attribute value that causes the entity to appear at the position. Highlight bold and display on the web page, etc.
  • an embodiment of the present invention provides another sorting method based on multi-valued attributes.
  • the server pre-configures a multi-valued attribute ordering indication.
  • the server pre-configures the multi-value attribute sorting mode indication of the entity, and performs multi-value attribute sorting manner according to the multi-valued attribute sorting manner to calculate the multi-valued attribute value of the entity, and determines the sorting attribute value of the entity.
  • the entity has a multi-valued attribute.
  • multi-value attribute ordering indications may be pre-configured.
  • the multi-value attribute ordering indication in this embodiment may be ALL, SUM, AVG, MIN, MAX or SCRIPT, but is not limited to these.
  • the server since a large amount of data is stored on the server, it is inevitable to update the data (that is, the multi-valued attribute value of the entity) (for example, adding data, deleting data, or modifying data, etc.). Therefore, when the data is updated, it is determined whether the update of the data affects the sort attribute value, and if it is affected, the multi-value attribute value of the entity update is calculated according to the multi-value attribute sorting manner indicated by the multi-value attribute sorting manner, thereby determining The new sort attribute value.
  • the data that is, the multi-valued attribute value of the entity
  • the multi-value attribute value of the entity update is calculated according to the multi-value attribute sorting manner indicated by the multi-value attribute sorting manner, thereby determining The new sort attribute value.
  • the server sorts the entities according to the sorting attribute values, and obtains the sorting result. Specifically, all the entities in the domain may be reordered according to the sorted attribute value, or only the updated entities may be sorted (ie, the location of the updated entity is modified).
  • the server receives a query request for sorting the entity sent by the application, and the query request carries a multi-value attribute sorting manner indication and a return sort attribute value indication.
  • the server determines the entity ranking result according to the sorting manner indicated by the sorting attribute and the multi-value attribute sorting manner, and returns a sorting result carrying the sorting attribute value to the application according to the order of the entity.
  • the filtering condition may be pre-configured on the server, and before the determining the multi-value attribute sorting manner of the multi-valued attribute sorting manner to determine the sorting attribute value of the entity, the method further includes: filtering The entity that satisfies the filtering condition is calculated, and then the multi-valued attribute value of the entity that satisfies the filtering condition is calculated according to the multi-valued attribute sorting manner indicated by the multi-valued attribute sorting manner, and the sorting attribute value of the entity is determined.
  • the multi-value attribute-based sorting method determines the sorting attribute value according to the indicated sorting manner according to the multi-valued attribute sorting manner, and includes the sorting attribute value in the returned sorting result, so that it can be based on the returned sorting result. Sorting the attribute value to know the reason why the entity appears in a certain position in the sorting result, so that the application needs are satisfied, and the application can further process the sorting result, for example, the sorting attribute value that causes the entity to appear at this position is highlighted and bolded. Display on the web page, etc. Moreover, by carrying the multi-value attribute ordering indication in the query request, it is also possible to meet the flexible ordering requirements of the application.
  • the sorting manner is pre-configured, and the sorting result is determined, so that after receiving the sorted query request, the query result can be returned, thereby reducing the query time and improving the query effect.
  • the present invention provides a sorting device based on multi-valued attributes, comprising: an obtaining unit 51, a sorting unit 53, a receiving unit 55 and a transmitting unit 57.
  • the obtaining unit 51 is configured to obtain an indication of a multi-valued attribute ordering manner of the entity, and the sorting unit 53 is configured according to The multi-valued attribute sorting manner indicates the indicated multi-valued attribute sorting manner to determine an sorting attribute value of the entity, and sorts the entity according to the sorting attribute value to obtain a sorting result, and the entity has a multi-valued attribute;
  • the receiving unit 55 For receiving a query request for sorting the entity, the query request carries a multi-value attribute sorting manner indication and a return sorting attribute value indication;
  • the sending unit 57 is configured to: return and carry according to the received query request for sorting the entity There is a sort result of the sort attribute value.
  • the embodiment of the present invention provides another sorting device based on multi-valued attributes.
  • the receiving unit 55 is configured to receive a query request for sorting the entity before the obtaining unit 51 obtains the multi-value attribute sorting manner indication, where the query request carries a multi-value attribute sorting manner indication and a return sorting attribute value indication.
  • the multi-value attribute ordering indication obtained by the obtaining unit 51 is obtained from the query request.
  • the query request received by the receiving unit 55 further includes a filtering condition
  • the multi-value attribute-based sorting device further includes a first filtering unit 61, configured to sort according to the multi-valued attribute in the sorting unit 53.
  • An entity that satisfies the filter condition is filtered before indicating the multi-value attribute ordering manner indicated to determine the sort attribute value of the entity.
  • the embodiment of the present invention provides another sorting device based on multi-valued attributes.
  • the sorting device based on the multi-value attribute includes, in addition to the unit shown in FIG. 5, a configuration unit 71 for indicating a multi-value attribute sorting manner indication of the entity.
  • the multi-value attribute sorting manner indication obtained by the acquiring unit is obtained from the configuration unit.
  • the receiving unit 55 is configured to: after the sorting unit 53 sorts the entity according to the sorting attribute value, receive a query request for sorting the entity, where the query request carries a multi-value attribute sorting manner indication and a return sorting attribute. Value indication.
  • the query request received by the receiving unit 57 further includes a filtering condition
  • the multi-value attribute-based sorting device further includes a second filtering unit 73, configured to indicate, according to the multi-value attribute sorting manner indication Before the multi-valued attribute is sorted to determine the sorted attribute value of the entity, the entity that satisfies the filter condition is filtered out.
  • the multi-value attribute-based sorting device provided by the embodiment of the present invention displays the sorting attribute value of the entity in the returned sorting result, so that the reason that the entity appears in a certain position in the sorting result can be obtained according to the sorting attribute value, thereby satisfying the application.
  • by carrying a multi-value attribute ordering indication in the query request it is also possible to meet the flexible ordering requirements of the application.
  • the storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本发明实施例提供了一种基于多值属性的排序方法。该包括包括:获取实体的多值属性排序方式指示,所述实体具有多值属性;根据所述多值属性排序方式指示所指示的多值属性排序方式来确定实体的排序属性值,并根据排序属性值对所述实体进行排序得到排序结果;根据接收到的对实体进行排序的查询请求,返回携带有所述排序属性值的排序结果,所述查询请求携带多值属性排序方式指示和返回排序属性值指示。本发明实施例可以在结果集中直观的显示实体的排序属性值,从而可以获知实体出现在某个位置的原因,满足应用的需求,方便应用对排序结果进行进一步的处理。

Description

一种基于多值属性的排序方法和设备
技术领域 本发明涉及通信技术领域, 尤其涉及一种基于多值属性的排序方法和设 备。 背景技术
随着互联网技术和数据库技术的发展, 传统的关系数据库的一个列只能具 有一个值的限制对应用的数据建模和数据过滤带来了不便。 例如, 视频的描述 信息中一个视频可能具有多个类别信息; 一个用户的通信录中可以具有多个
Email地址等。 现在, 业界出现了目录服务器等支持多值属性的数据库。 支持 多值属性的数据库中的实体可以具有多值属性, 这里的多值属性就是指可以有 多个属性值的属性。 支持多值属性的数据库中的实体相当于关系数据库中的 行, 实体的属性相当于关系数据库中的列。
现有的支持多值属性的数据库, 由于实体具有多值属性, 因此有的数据库 支持按照多值属性排序, 在排序的过程中每个实体所有满足条件的多值属性的 值(即多值属性值)都可以决定该实体在排序结果集中的位置。 由于多值属性 有多个属性值, 一个实体对应的数据可能在结果集中多个位置出现, 导致应用 无法从返回的结果集中获知实体出现在某个位置的原因。 发明内容
本发明实施例提供一种基于多值属性的排序方法和设备, 可以在结果集中 直观的显示实体的排序属性值, 从而可以获知实体出现在某个位置的原因, 满 足应用的需求。
本发明实施例一方面提供了一种基于多值属性的排序方法, 包括: 获取实体的多值属性排序方式指示, 所述实体具有多值属性; 根据所述多值属性排序方式指示所指示的多值属性排序方式来确定实体的 排序属性值, 并根据排序属性值对所述实体进行排序得到排序结果;
根据接收到的对实体进行排序的查询请求, 返回携带有所述排序属性值的 排序结果, 所述查询请求携带多值属性排序方式指示和返回排序属性值指示。
本发明实施例另一方面提供了一种基于多值属性的排序设备, 包括: 获取单元, 用于获取实体的多值属性排序方式指示, 所述实体具有多值属 性;
排序单元, 根据所述多值属性排序方式指示所指示的多值属性排序方式来 确定实体的排序属性值, 并根据排序属性值对所述实体进行排序得到排序结 果;
接收单元, 用于接收对实体进行排序的查询请求, 所述查询请求携带多值 属性排序方式指示和返回排序属性值指示;
发送单元, 用于根据接收到的对实体进行排序的查询请求, 返回携带有所 述排序属性值的排序结果。
本发明实施例提供的基于多值属性的排序方法和设备, 获取实体的多值属 性排序方式指示; 才艮据所述多值属性排序方式指示所指示的多值属性排序方式 来确定实体的排序属性值, 并根据排序属性值对所述实体进行排序得到排序结 果, 所述实体具有多值属性; 根据接收到的对实体进行排序的查询请求, 返回 携带有所述排序属性值的排序结果, 所述查询请求携带多值属性排序方式指示 和返回排序属性值指示。 因此, 可以在结果集中直观的显示实体的排序属性 值, 从而可以获知实体出现在某个位置的原因, 满足了应用的需求, 方便应用 对排序结果进行进一步的处理。 附图说明
为了更清楚地说明本发明实施例的技术方案, 下面将对实施例描述中所需 要使用的附图作一筒单地介绍, 显而易见地, 下面描述中的附图仅仅是本发明 的一些实施例, 对于本领域普通技术人员来讲, 在不付出创造性劳动的前提 下, 还可以根据这些附图获得其他的附图。
图 1为本发明实施例提供的一种基于多值属性的排序方法流程图; 图 2为本发明实施例提供的另一种基于多值属性的排序方法的流程图; 图 3为本发明实施例提供的另一种基于多值属性的排序方法的流程图; 图 4为本发明实施例提供的另一种基于多值属性的排序方法的流程图; 图 5为本发明实施例提供的一种基于多值属性的排序设备的结构图; 图 6为本发明实施例提供的另一种基于多值属性的排序设备的结构图; 图 7为本发明实施例提供的另一种基于多值属性的排序设备的结构图。 具体实施方式
下面将结合本发明实施例中的附图, 对本发明实施例中的技术方案进行清 楚、 完整地描述, 显然, 所描述的实施例仅仅是本发明一部分实施例, 而不是 全部的实施例。 基于本发明中的实施例, 本领域普通技术人员在没有做出创造 性劳动前提下所获得的所有其他实施例, 都属于本发明保护的范围。
支持多值属性的数据库的数据按域的方式进行组织, 域和关系数据库中的 表类似, 域内包含的数据项称为实体(不同的支持多值属性的数据库中可能有 不同的名称, 例如条目、 项等, 这里统称为实体) 。 一个域内的实体具有相同 的类型, 每个实体在域内具有一个唯一的标识, 该标识和关系数据库中行的标 识类似; 而且一个实体具有一个或者多个属性, 属性名称和关系数据库列名类 似, 一个多值属性可以具有一个或者多个属性值, 属性值和关系数据库中的列 的值类似。 支持多值属性的数据库中的属性允许存在多个值, 而且可以根据这 多个值进行数据过滤。 可以具有多个属性值的属性称为多值属性, 相应的, 多 值属性的值可以称为多值属性值。
如表 1所示为支持多值属性的数据库一个域的数据。 其中, 序号 1和 2为实 体的标识; Name, Sex, Email为实体的属性。 实体的属性 Email允许一个实体 有多个 Email, 那么属性 Email就是多值属性。 具体的, 实体 1的 Name属性的属 性值为张三, 实体 2的 Name属性的属性值为李四; 实体 1的 Sex属性的属性值为 男, 实体 2的 Sex属性的属性值为男; 实体 1的 Email属性的多值属性值为
Zhangsan@yahoo.com, 实体 2的 Email属性的多值属性值为 lisi@yahoo.com和 lisi@ 163.com。
Figure imgf000005_0002
Figure imgf000005_0001
如图 1所示, 本发明实施例提供了一种基于多值属性的排序方法, 包括: S101 , 获取实体的多值属性排序方式指示, 所述实体具有多值属性; 其中, 多值属性排序方式指示可以是预先配置的, 也可以是从外部获取 的, 例如从查询请求中获取的。
S103 , 根据所述多值属性排序方式指示所指示的多值属性排序方式来确定 实体的排序属性值, 并根据排序属性值对所述实体进行排序得到排序结果; 其中, 多值属性排序方式包括下面任意一种: : 实体的所有多值属性值都 作为排序属性值参与排序; 实体的多值属性值的平均值作为排序属性值参与排 序; 实体的多值属性值的总和作为排序属性值参与排序; 实体的多值属性值的 最大值作为排序属性值参与排序; 实体的多值属性值的最小值作为排序属性值 参与排序; 脚本方式。
可选的, 可以按照多值属性排序方式, 对实体的多值属性值进行计算, 确 定实体的排序属性值。
S105 , 根据接收到的对实体进行排序的查询请求, 返回携带有所述排序属 性值的排序结果, 所述查询请求携带多值属性排序方式指示和返回排序属性值 指示。
通过该实施例提供的基于多值属性的排序方法, 根据多值属性排序方式指 示所指示的多值属性排序方式确定排序属性值, 可以在结果集中直观的显示实 体的排序属性值, 从而可以获知实体出现在某个位置的原因, 满足了应用的需 求, 方便应用对排序结果进行进一步的处理, 比如需将导致实体出现在此位置 的排序属性值加亮加粗在网页上显示等。 而且, 通过在查询请求中携带多值属 性排序方式指示, 还可以满足应用灵活的排序需求。
如图 2所示, 本发明实施例提供了另一种基于多值属性的排序方法。 这里 以结构化查询语言 (SQL, Structured Query Language )扩展为例来说明本实施 例中的排序方法。
S201 , 服务器接收应用发送的对实体进行排序的查询请求, 查询请求中携 带多值属性排序方式指示和返回排序属性值指示。 其中, 所述实体具有多值属 性。
假设服务器 (可以为数据库) 中存储有如表二所示的名称为 "films" 的 域。 其中, 属性 Category为多值属性, 实体 C1和 C2的属性 Category分别有两个 多值属性值, 其中, C1的多值属性值为类别 1和类别 3 , C2的多值属性值为类 另 2和类别 4。
Figure imgf000006_0002
Figure imgf000006_0001
具体的查询请求为: Select *, SORT_ATTR from films order by Category ALL asc, 其中, SORT_ATTR为返回排序属性值指示, ALL为多值属性排序方 式指示。
本实施例中的多值属性排序方式指示以 ALL为例。 可选的, 多值属性排序 方式指示还可以是下面任意一种, 但也不限于这几种:
1 ) AVG: 实体的多值属性值的平均值作为排序属性值参与排序, 这种排 序方式对于数值型的多值属性值有效。
2 ) SUM: 实体的多值属性值的总和作为排序属性值参与排序, 这种排序 方式对于数值型的多值属性值有效。
3 ) MAX: 实体的多值属性值的最大值作为排序属性值参与排序, 这种排 序方式对于支持比较的多值属性有效, 比如多值属性的值为数值或字符串等。
4 ) MIN: 实体的多值属性值的最小值最为排序属性值参与排序, 这种排 序方式对于支持比较的多值属性有效, 比如多值属性的值为数值或字符串等。
5 )脚本方式: 通过脚本(SCRIPT ) 的方式, 将多值属性值进行计算(可 以包括组合)得出一个或者多个值作为排序属性值参与排序。
S203 , 服务器根据多值属性排序方式指示的所有值排序方式对实体的多值 属性值进行计算, 确定实体的排序属性值。
由于排序方式为 ALL , 因此多值属性的所有值都作为排序属性值参与排 序, 具体到本例中, 就是每个电影的 Category属性值都作为排序属性值参与排 序。 按照 ALL排序方式计算后, 排序属性值分别为: 类别 1 , 类别 2, 类别 3和 类别 4。
S205 , 服务器根据排序属性值对实体进行升序排列, 得到排序结果。
S207 , 服务器返回携带有排序属性值的排序结果。 返回的排序结果如表三 所示。
在本实施例中, 可选的, 查询请求还可以包括过滤条件, 例如查询请求 为: Select *, SORT—ATTR from films where Category is not null order by Category ALL asc o 其中, where Category is not null为过滤条件, 那么在 S203之前还包 括: 服务器过滤出满足所述过滤条件的实体, 然后执行 S203。 S203相应的为: 服务器根据多值属性排序方式指示的所有值排序方式对满足过滤条件的实体的 多值属性值进行计算, 确定实体的排序属性值。
Title Language Category SORT—ALL
C1 阿凡达 英文 类别 1 类别 1 类别 3
C2 英雄 中文 类别 2 类别 2 类别 4
CI 阿凡达 英文 类别 1 类别 3 类别 3
C2 英雄 中文 类别 2 类别 4 类别 4
Figure imgf000008_0001
该实施例提供的基于多值属性的排序方法, 根据多值属性排序方式指示所 指示的所有值排序方式确定排序属性值, 在返回的排序结果中包括排序属性 值, 因此可以根据排序属性值在返回的排序结果中获知实体 C1或 C2出现在排 序结果中某个位置的原因, 从而满足了应用的需求, 方便应用对排序结果进行 进一步的处理, 比如需将导致实体出现在此位置的排序属性值加亮加粗在网页 上显示等。 而且, 通过在查询请求中携带多值属性排序方式指示, 还可以满足 应用灵活的排序需求。
如图 3所示, 本发明实施例提供了另一种基于多值属性的排序方法, 以排 序方式为脚本方式为例。
假设服务器中存储有如表四所示的名称为 "person" 的域。
Figure imgf000008_0002
表四 其中, 属性 Email为多值属性, 实体 1的属性 Email有一个多值属性值 XiaoMing@ 163.com, 实体 2的属性 Email有两个多值属性值 HuaHua@sina.com和 HuaHua @ 163.com。
S301 , 服务器接收应用发送的对实体进行排序的查询请求, 查询请求中携 带多值属性排序方式指示和返回排序属性值指示。 具体的查询请求为: Select * , SORT_ATTR from person order by Email SCRIPT "$VALUE.SubString ($VALUE.fmd (' @,) +1, $VALUE.length()-l)" asc, 其中, "$VALUE.SubString ($VALUE.fmd (' @,) +1, $VALUE.length()-l)"的含 义为取 Email的域名作为排序属性值。 其中, 脚本可以在查询请求中携带; 也 可以预先配置在服务器中, 然后在查询请求中指定脚本的位置。 脚本语言可以 采用 JAVA, Python, Shell或者自定义语言等。
本实施例中的多值属性排序方式指示以 SCRIPT为例。 可选的, 多值属性 排序方式指示还可以是 ALL、 SUM , AVG、 MIN或 MAX , 但也不限于这几 种。
S303 , 服务器根据多值属性排序方式指示的脚本排序方式对实体的多值属 性值进行计算, 确定实体的排序属性值。
按照脚本排序方式计算后, 排序属性值分别为: 163.com, sina.com, 163.com。
S305 , 服务器根据排序属性值对实体进行排序, 得到排序结果。
S307, 服务器返回携带有排序属性值的排序结果。 返回的排序结果如表五 所示。
在本实施例中, 可选的, 查询请求还可以包括过滤条件, 例如查询请求 为: Select * , SORT—ATTR from person where Email is not null order by Email SCRIPT "$VALUE.SubString ($VALUE.fmd (' @,) +1, $VALUE.length()-l)" asc。 其中, where Email is not null为过滤条件, 那么在 S303之前还包括: 服务器过 滤出满足所述过滤条件的实体, 然后执行 S303。 S303相应的为: 服务器根据多 值属性排序方式指示的所有值排序方式对满足过滤条件的实体的多值属性值进 行计算, 确定实体的排序属性值。
Figure imgf000009_0001
2 HuaHua Femal HuaHua @sina. com 163.com
HuaHua @ 163. com
2 HuaHua Femal HuaHua @sina. com sina.com
HuaHua® 163.com
表五
该实施例提供的基于多值属性的排序方法, 根据多值属性排序方式指示所 指示的脚本排序方式确定排序属性值, 在返回的排序结果中包括排序属性值, 因此可以在返回的排序结果中根据排序属性值获知实体 1或 2出现在排序结果中 某个位置的原因, 从而满足了应用的需求, 方便应用对排序结果进行进一步的 处理, 比如需将导致实体出现在此位置的排序属性值加亮加粗在网页上显示 等。 而且, 通过在查询请求中携带多值属性排序方式指示, 还可以满足应用灵 活的排序需求。
如图 4所示, 本发明实施例提供了另一种基于多值属性的排序方法。 在该 实施例中, 服务器预先配置多值属性排序方式指示。
S401 , 服务器预先配置实体的多值属性排序方式指示, 根据多值属性排序 方式指示所指示的多值属性排序方式对实体的多值属性值进行计算, 确定实体 的排序属性值。 其中, 所述实体具有多值属性。
其中, 可以预先配置一种或多种多值属性排序方式指示。 本实施例中的多 值属性排序方式指示可以是 ALL、 SUM , AVG、 MIN、 MAX或 SCRIPT, 但也 不限于这几种。
可选的, 由于服务器上存储了大量的数据, 不可避免的需要对数据(即实 体的多值属性值)进行更新操作 (例如增加数据、 删除数据或修改数据等) 。 因而, 可以在数据进行更新时, 判断数据的更新是否影响排序属性值, 如果影 响, 则根据多值属性排序方式指示的多值属性排序方式对实体更新后的多值属 性值进行计算, 从而确定新的排序属性值。
S403 , 服务器根据排序属性值对实体进行排序, 得到排序结果。 具体的, 可以根据排序属性值对域内所有实体进行重新排序, 也可以只对 更新的实体进行排序 (即: 修改被更新了的实体的位置) 。
S405 , 服务器接收应用发送的对实体进行排序的查询请求, 查询请求中携 带多值属性排序方式指示和返回排序属性值指示。
S407 , 服务器根据排序属性和多值属性排序方式指示所指示的排序方式确 定实体排序结果, 并按照此实体的次序向应用返回携带有排序属性值的排序结 果。
可选的, 该实施例中, 还可以在服务器上预先配置过滤条件, 则根据所述 多值属性排序方式指示所指示的多值属性排序方式来确定实体的排序属性值之 前, 还包括: 过滤出满足所述过滤条件的实体, 然后根据多值属性排序方式指 示的多值属性排序方式对满足过滤条件的实体的多值属性值进行计算, 确定实 体的排序属性值。
该实施例提供的基于多值属性的排序方法, 根据多值属性排序方式指示所 指示的排序方式确定排序属性值, 在返回的排序结果中包括排序属性值, 因此 可以在返回的排序结果中根据排序属性值获知实体出现在排序结果中某个位置 的原因, 从而满足了应用的需求, 方便应用对排序结果进行进一步的处理, 比 如需将导致实体出现在此位置的排序属性值加亮加粗在网页上显示等。 而且, 通过在查询请求中携带多值属性排序方式指示, 还可以满足应用灵活的排序需 求。
而且, 本实施例中, 预先配置排序方式, 确定排序结果, 这样在接收到排 序的查询请求后, 就可以返回查询结果, 从而减少了查询时间, 提高了查询效 如图 5所示, 本发明实施例提供了一种基于多值属性的排序设备, 包括: 获取单元 51 , 排序单元 53、 接收单元 55和发送单元 57。
获取单元 51 , 用于获取实体的多值属性排序方式指示; 排序单元 53 , 根据 所述多值属性排序方式指示所指示的多值属性排序方式来确定实体的排序属性 值, 并根据排序属性值对所述实体进行排序得到排序结果, 所述实体具有多值 属性; 接收单元 55 , 用于接收对实体进行排序的查询请求, 所述查询请求携带 多值属性排序方式指示和返回排序属性值指示; 发送单元 57, 用于根据接收到 的对实体进行排序的查询请求, 返回携带有所述排序属性值的排序结果。
如图 6所示, 本发明实施例提供了另一种基于多值属性的排序设备。 接收 单元 55 , 具体用于在获取单元 51获取多值属性排序方式指示之前接收对实体进 行排序的查询请求, 所述查询请求携带多值属性排序方式指示和返回排序属性 值指示。 相应的, 获取单元 51所获取的多值属性排序方式指示是从查询请求中 获取的。
可选的, 接收单元 55接收的查询请求中还包括过滤条件, 则相应的, 基于 多值属性的排序设备还包括第一过滤单元 61 , 用于在排序单元 53根据所述多值 属性排序方式指示所指示的多值属性排序方式来确定实体的排序属性值之前, 过滤出满足所述过滤条件的实体。
如图 7所示, 本发明实施例提供了另一种基于多值属性的排序设备。 该基 于多值属性的排序设备在包括图 5所示的单元之外, 还包括: 配置单元 71 , 用 于配置实体的多值属性排序方式指示。 相应的, 所述获取单元所获取的多值属 性排序方式指示是从配置单元中获取的。 可选的, 接收单元 55 , 具体用于在排 序单元 53根据排序属性值对所述实体进行排序之后接收对实体进行排序的查询 请求, 所述查询请求携带多值属性排序方式指示和返回排序属性值指示。
可选的, 接收单元 57接收的查询请求中还包括过滤条件, 则相应的, 基于 多值属性的排序设备还包括第二过滤单元 73 , 用于在根据所述多值属性排序方 式指示所指示的多值属性排序方式来确定实体的排序属性值之前, 过滤出满足 所述过滤条件的实体。
具体的实现方法可以参照方法实施例中所述的方法, 这里不再赘述。 本发明实施例提供的基于多值属性的排序设备, 在返回的排序结果中显示 实体的排序属性值, 因而可以根据排序属性值获知实体出现在排序结果中某个 位置的原因, 从而满足了应用的需求, 方便应用对排序结果进行进一步的处 理, 比如需将导致实体出现在此位置的排序属性值加亮加粗在网页上显示等。 而且, 通过在查询请求中携带多值属性排序方式指示, 还可以满足应用灵活的 排序需求。
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程, 是可以通过计算机程序来指令相关的硬件来完成, 所述的程序可存储于一计算 机可读取存储介质中, 该程序在执行时, 可包括如上述各方法的实施例的流 程。 其中, 所述的存储介质可为磁碟、 光盘、 只读存储记忆体 (Read-Only Memory, ROM )或随机存储记忆体 ( Random Access Memory, RAM )等。
以上所述, 仅为本发明的具体实施方式, 但本发明的保护范围并不局限于 此, 任何熟悉本技术领域的技术人员在本发明揭露的技术范围内, 可轻易想到 变化或替换, 都应涵盖在本发明的保护范围之内。 因此, 本发明的保护范围应 以所述权利要求的保护范围为准。

Claims

权利要求
1、 一种基于多值属性的排序方法, 其特征在于, 包括:
获取实体的多值属性排序方式指示, 所述实体具有多值属性;
根据所述多值属性排序方式指示所指示的多值属性排序方式来确定实体的 排序属性值, 并根据排序属性值对所述实体进行排序得到排序结果;
根据接收到的对实体进行排序的查询请求, 返回携带有所述排序属性值的 排序结果, 所述查询请求携带多值属性排序方式指示和返回排序属性值指示。
2、 如权利要求 1所述的排序方法, 其特征在于, 根据所述多值属性排序方 式指示所指示的多值属性排序方式来确定实体的排序属性值包括:
按照所述多值属性排序方式对所述实体的多值属性值进行计算, 确定实体 的排序属性值。
3、 如权利要求 1或 2所述的排序方法, 其特征在于, 所述查询请求是在获 取实体的多值属性排序方式指示之前接收的。
4、 如权利要求 3所述的排序方法, 其特征在于, 所述查询请求还包括过滤 条件, 则根据所述多值属性排序方式指示所指示的多值属性排序方式来确定实 体的排序属性值之前还包括: 过滤出满足所述过滤条件的实体。
5、 如权利要求 1或 2所述的排序方法, 其特征在于, 还包括: 预先配置实 体的多值属性排序方式指示, 相应的, 所述查询请求是在根据排序属性值对所 述实体进行排序之后接收的。
6、 如权利要求 5所述的排序方法, 其特征在于, 还包括: 当实体的多值属 性值更新时, 如果更新的多值属性值影响排序属性值, 那么才艮据多值属性排序 方式指示的多值属性排序方式对更新后的多值属性值进行计算, 确定新的排序 属性值。
7、 如权利要求 5所述的排序方法, 其特征在于, 还包括: 预先配置过滤条 件, 则根据所述多值属性排序方式指示所指示的多值属性排序方式来确定实体 的排序属性值之前, 还包括: 过滤出满足所述过滤条件的实体。
8、 如权利要求 1至 7任一所述的排序方法, 其特征在于, 所述多值属性排 序方式包括下面任意一种: 实体的所有多值属性值参与排序; 实体的多值属性 值的平均值作为排序属性值参与排序; 实体的多值属性值的总和作为排序属性 值参与排序; 实体的多值属性值的最大值作为排序属性值参与排序; 实体的多 值属性值的最小值作为排序属性值参与排序; 脚本方式排序。
9、 一种基于多值属性的排序设备, 其特征在于, 包括:
获取单元, 用于获取实体的多值属性排序方式指示, 所述实体具有多值属 性;
排序单元, 根据所述多值属性排序方式指示所指示的多值属性排序方式来 确定实体的排序属性值, 并根据排序属性值对所述实体进行排序得到排序结 果;
接收单元, 用于接收对实体进行排序的查询请求, 所述查询请求携带多值 属性排序方式指示和返回排序属性值指示;
发送单元, 用于根据接收到的对实体进行排序的查询请求, 返回携带有所 述排序属性值的排序结果。
10、 如权利要求 9所述的排序设备, 其特征在于,
所述排序单元, 具体用于按照所述多值属性排序方式对所述实体的多值属 性值进行计算, 确定实体的排序属性值, 并根据排序属性值对所述实体进行排 序得到排序结果, 所述实体具有多值属性。
11、 如权利要求 9或 10所述的排序设备, 其特征在于,
接收单元, 具体用于在获取多值属性排序方式指示之前接收对实体进行排 序的所述查询请求, 所述查询请求携带多值属性排序方式指示和返回排序属性 值指示;
相应的, 所述获取单元所获取的多值属性排序方式指示是从所述查询请求 中袭取的。
12、 如权利要求 11所述的排序设备, 其特征在于, 所述查询请求中还包括 过滤条件, 相应的, 所述排序设备还包括:
第一过滤单元, 用于在所述排序单元根据所述多值属性排序方式指示所指 示的多值属性排序方式来确定实体的排序属性值之前, 过滤出满足所述过滤条 件的实体。
13、 如权利要求 9或 10所述的排序设备, 其特征在于, 还包括:
配置单元, 用于配置实体的多值属性排序方式指示;
相应的, 所述获取单元所获取的多值属性排序方式指示是从配置单元中获 取的。
14、 如权利要求 13所述的排序设备, 其特征在于,
接收单元, 具体用于在排序单元根据排序属性值对所述实体进行排序之后 接收对实体进行排序的查询请求, 所述查询请求携带多值属性排序方式指示和 返回排序属性值指示。
15、 如权利要求 14所述的排序设备, 其特征在于, 所述查询请求中还包括 过滤条件, 相应的, 所述排序设备还包括:
第二过滤单元, 用于在所述排序单元根据所述多值属性排序方式指示所指 示的多值属性排序方式来确定实体的排序属性值之前, 过滤出满足所述过滤条 件的实体。
PCT/CN2011/079190 2011-08-31 2011-08-31 一种基于多值属性的排序方法和设备 WO2012119431A1 (zh)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201180001361.2A CN102369528B (zh) 2011-08-31 2011-08-31 一种基于多值属性的排序方法和设备
PCT/CN2011/079190 WO2012119431A1 (zh) 2011-08-31 2011-08-31 一种基于多值属性的排序方法和设备

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CN2011/079190 WO2012119431A1 (zh) 2011-08-31 2011-08-31 一种基于多值属性的排序方法和设备

Publications (1)

Publication Number Publication Date
WO2012119431A1 true WO2012119431A1 (zh) 2012-09-13

Family

ID=45761454

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2011/079190 WO2012119431A1 (zh) 2011-08-31 2011-08-31 一种基于多值属性的排序方法和设备

Country Status (2)

Country Link
CN (1) CN102369528B (zh)
WO (1) WO2012119431A1 (zh)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9679083B2 (en) * 2012-12-28 2017-06-13 Intel Corporation Displaying sort results on a mobile computing device
CN105740264A (zh) * 2014-12-10 2016-07-06 北大方正集团有限公司 一种分布式xml数据库的排序方法及装置
CN107958081B (zh) * 2017-12-14 2021-11-30 泰康保险集团股份有限公司 信息处理方法与装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030004938A1 (en) * 2001-05-15 2003-01-02 Lawder Jonathan Keir Method of storing and retrieving multi-dimensional data using the hilbert curve
CN101136035A (zh) * 2007-10-15 2008-03-05 金蝶软件(中国)有限公司 不同属性字段的排序方法及系统
CN101465752A (zh) * 2009-01-09 2009-06-24 腾讯科技(深圳)有限公司 一种联系人排序方法及系统
CN102045339A (zh) * 2010-10-14 2011-05-04 深圳市五巨科技有限公司 一种实现字段个性化排序的方法、装置和系统

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101145164B (zh) * 2007-10-30 2010-06-02 金蝶软件(中国)有限公司 一种序时簿的查询方法及一种序时簿的查询装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030004938A1 (en) * 2001-05-15 2003-01-02 Lawder Jonathan Keir Method of storing and retrieving multi-dimensional data using the hilbert curve
CN101136035A (zh) * 2007-10-15 2008-03-05 金蝶软件(中国)有限公司 不同属性字段的排序方法及系统
CN101465752A (zh) * 2009-01-09 2009-06-24 腾讯科技(深圳)有限公司 一种联系人排序方法及系统
CN102045339A (zh) * 2010-10-14 2011-05-04 深圳市五巨科技有限公司 一种实现字段个性化排序的方法、装置和系统

Also Published As

Publication number Publication date
CN102369528A (zh) 2012-03-07
CN102369528B (zh) 2014-06-04

Similar Documents

Publication Publication Date Title
US10019536B2 (en) Snapshot-consistent, in-memory graph instances in a multi-user database
TWI479331B (zh) 聚集及搜尋來自多重服務之設定檔資料
US9135658B2 (en) Generating data clusters
US9684713B2 (en) Methods and systems for retrieval of experts based on user customizable search and ranking parameters
JP5106045B2 (ja) 検索エンジン連携ファイル共有システム
WO2019047346A1 (zh) 网站漏洞扫描方法、装置、计算机设备及存储介质
US10776373B2 (en) Facilitating elastic allocation of organization-specific queue resources in an on-demand services environment
US20130097140A1 (en) Presenting social network connections on a search engine results page
EP3236365A1 (en) Data query method and device
US11966384B2 (en) Generating external identifiers for data entities using a data catalog system
US20140025673A1 (en) Techniques for estimating distance between members of a social network service
US9852183B2 (en) Information providing method and system
WO2015066591A1 (en) Ranking information providers
US20130013408A1 (en) Method and Arrangement for Network Searching
US11157492B2 (en) Generic scheduling
JP6608972B2 (ja) ソーシャルネットワークに基づいてグループを探索する方法、デバイス、サーバ及び記憶媒体
JP2017535842A (ja) データソースからデータターゲットにデータを転送するためのインポート手順の呼出しの単純化
WO2021047323A1 (zh) 一种数据操作方法、装置及系统
US9418106B1 (en) Joining operations in document oriented databases
CN111723161A (zh) 一种数据处理方法、装置及设备
WO2012119431A1 (zh) 一种基于多值属性的排序方法和设备
US10802670B2 (en) User interface for polymorphic lookup
CN110765158A (zh) 分页查询方法、系统和装置
JP5597623B2 (ja) データベース処理方法
US20060230020A1 (en) Improving Efficiency in processing queries directed to static data sets

Legal Events

Date Code Title Description
WWE Wipo information: entry into national phase

Ref document number: 201180001361.2

Country of ref document: CN

121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 11860482

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 11860482

Country of ref document: EP

Kind code of ref document: A1