摘要:
The present invention discloses a data access method, apparatus, and system, to resolve a technical problem that relatively good storage cannot be implemented in a current database. The method includes: receiving a data access request; determining an access type of a data table that is to be accessed according to the data access request, where the access type of the data table includes a physical data table type and an object data table type that is stored in a database in a form of metadata; and obtaining to-be-accessed data from the to-be-accessed data table according to the determined access type of the data table.
摘要:
Method and apparatus for performing a database query using a bitmap index in a data-base having a plurality of bitmap vectors, the method comprising the steps of: upon receipt of a query containing a selection condition, creating a filter bitmap based on the query input; performing a bitmap scan for the filter bitmap in order to determine at least one value of an existing matching data-base entry; determining a bitmap of the determined at least one value; creating a filtered bitmap by combining the filter bitmap with the bitmap of the determined at least one value; determining all entries in the database matching the filtered bitmap; sub-tracting the filtered bitmap from the filter bitmap, thus creating a new filter bitmap; repeating the steps, starting with the step of performing a bitmap scan based on the new filter bitmap, until the step of sub-tracting results in an empty bitmap.
摘要:
Methods and system are disclosed that optimize attribute vectors to search for data. In one aspect, a reordering optimization model is executed to reorder the attribute vectors. The attribute vectors may include value identifiers associated with data. The attribute vectors are assigned priorities, sequence score corresponding to each attribute vector is computed and the attribute vectors are reordered based on the computed sequence score. The reordered attribute vectors are logically partitioned into attribute vector blocks by executing a partitioning optimization model. The attribute vector blocks may be generated upon executing the partitioning optimization model. The value identifiers in the attribute vector blocks may be rearranged to optimize the attribute vectors to search for data.
摘要:
A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query.
摘要:
Advertisers are permitted to put targeted ads on page on the web (or some other document of any media type). The present invention may do so by (i) obtaining content that includes available spots for ads, (ii) determining ads relevant to content, and/or (iii) combining content with ads determined to be relevant to the content.
摘要:
A database system includes a storage that contains plural tables as well as a predefined data structure. The database system is able to, in response to a join query, perform a join of two or more tables. The database system also is able to determine, based on values contained in the predefined data structure, whether a group-by operation can be skipped.
摘要:
In one embodiment, a method includes accessing a social graph that includes a plurality of nodes and edges, receiving from a user a structured query comprising references to selected nodes and selected edges, parsing the structure query to identify a first query constraint and one or more second query constraints, identifying a inverse constraint associated with the first query constraint, and generating a query command based on the structured query, where the query command includes the inverse constraint and the one or more second query constraints.
摘要:
Advertisers are permitted to put targeted ads on page on the web (or some other document of any media type). The present invention may do so by (i) obtaining content that includes available spots for ads, (ii) determining ads relevant to content, and/or (iii) combining content with ads determined to be relevant to the content.