CN112434005A - Browsing list generation device and implementation method - Google Patents

Browsing list generation device and implementation method Download PDF

Info

Publication number
CN112434005A
CN112434005A CN202011188599.8A CN202011188599A CN112434005A CN 112434005 A CN112434005 A CN 112434005A CN 202011188599 A CN202011188599 A CN 202011188599A CN 112434005 A CN112434005 A CN 112434005A
Authority
CN
China
Prior art keywords
list
browsing
module
query command
view
Prior art date
Legal status (The legal status 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 status listed.)
Pending
Application number
CN202011188599.8A
Other languages
Chinese (zh)
Inventor
刘科
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Huizhou Foryou General Electronics Co Ltd
Original Assignee
Huizhou Foryou General Electronics Co Ltd
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 Huizhou Foryou General Electronics Co Ltd filed Critical Huizhou Foryou General Electronics Co Ltd
Priority to CN202011188599.8A priority Critical patent/CN112434005A/en
Publication of CN112434005A publication Critical patent/CN112434005A/en
Pending legal-status Critical Current

Links

Images

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/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • 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/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • 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/242Query formulation
    • G06F16/2433Query languages
    • 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/248Presentation of query results
    • 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/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • G06F16/285Clustering or classification
    • G06F16/287Visualization; Browsing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a browsing list generating device and an implementation method, wherein the method comprises the following steps: step 1, creating a media file database; step 2, creating a browsing list type, judging whether the browsing list type exists, if so, entering a step 6, otherwise, entering the next step; step 3, creating an empty browsing list and a corresponding empty storage queue list, and establishing a communication link between the empty browsing list and the empty storage queue list to realize synchronous refreshing; step 4, generating a browsing list query command statement according to the browsing list type; step 5, creating a browsing list view; step 6, acquiring data in the browsing list view; and 7, refreshing and displaying the data in the browsing list view. The invention realizes the quick generation of the browsing list.

Description

Browsing list generation device and implementation method
Technical Field
The invention relates to the technical field of multimedia, in particular to a browsing list generation device and an implementation method.
Background
The music player list, which is distinguished from the functional attributes, may be divided into a browsing list and a play list. The browsing list is mainly presented to the user for watching, selecting songs, while the play list is used for player play. The current browsing list types mainly include a folder list (a list formed by enumerating all folders containing music files), a song list (a list formed by searching all music files in a media device), an album list (a list formed by acquiring albums to which all music files in the list belong), and the like. These types of browsing lists are mainly determined by the keywords input by the user, for example, the browsing list of songs under the corresponding album by artist is determined by three keywords of artist, album and song.
The main problems of browsing list generation currently are:
1. list generation is inefficient. Because the browsing list types are many, the user operation is not fixed, and new list types need to be continuously generated, but the prior art adopts a mode of directly querying a database, so that delay of different programs can be generated when a list is obtained every time, and particularly, when more list data relate to multiple types, query performance is very obvious at the same time, and unfriendly experience is brought to the user;
2. the resource occupation is large. In order to solve the above problems, a plurality of browsing list types are preset in the memory for storing the data of the browsing list acquired each time, and this way can reduce the delay caused by the query in a certain program, but the memory overhead is increased accordingly.
Therefore, a browsing list generation method for balancing memory occupancy and controlling delay is needed.
Disclosure of Invention
The invention provides a browsing list generation device and an implementation method, aiming at overcoming the defects in the prior art and realizing the rapid generation of a browsing list.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
one aspect of the present invention provides a browsing list generating apparatus, including:
the system comprises a media database generation module, a media database module, a database operation module, a statement assembly module, a list management module and a UI module;
the list management module is connected with the UI module, the media database generation module and the database operation module are also connected with the database operation module, and the database operation module is also connected with the statement assembly module;
the media database generation module is used for scanning media files in the peripheral equipment to generate media database files;
the media database module is used for storing media database files;
the database operation module is used for receiving the command sentences sent by the sentence assembly module, executing the operation on the media database files and acquiring the executed data;
the statement assembly module is used for combining the characteristic fields contained in the browsing list type to generate a corresponding query command statement;
the list management module is used for creating and managing a storage queue and a database view name and acquiring list data in a corresponding view;
and the UI module is used for receiving a browsing list type creation or query request and displaying the browsing list data acquired by the synchronous list management module.
Specifically, the data operation module includes: the system comprises a logic level acquisition unit, a logic level splitting unit, a view matching unit, a matching judgment unit and a view generation unit which are sequentially connected, wherein the matching judgment unit is also connected with the logic level splitting unit;
the logic level acquisition unit is used for acquiring the logic level number of each keyword in the query command statement;
the logic level splitting unit is configured to split the query command statement into two sub-query command statements corresponding to a first logic level number and a second logic level number;
the view matching unit is used for matching the views corresponding to the sub-query command statements of the first logic layer number and the second logic layer number;
the matching judgment unit is used for judging whether the views corresponding to the sub-query command statements of the first logic layer number and the second logic layer number exist or not, if so, the view generation unit is informed to generate the corresponding views, and if not, the logic level splitting unit is informed to adjust the number of the splitting logic layers;
and the view generating unit is used for generating a view according to the logic layer number of each keyword in the query command statement.
Specifically, the data assembly module is an SQL data assembly module.
Specifically, the media database module is a QDB database.
Another aspect of the present invention provides a browsing list generating method, including:
step 1, creating a media file database;
step 2, creating a browsing list type, judging whether the browsing list type exists, if so, entering a step 6, otherwise, entering the next step;
step 3, creating an empty browsing list and a corresponding empty storage queue list, and establishing a communication link between the empty browsing list and the empty storage queue list to realize synchronous refreshing;
step 4, generating a browsing list query command statement according to the browsing list type;
step 5, creating a browsing list view;
step 6, acquiring data in the browsing list view;
and 7, refreshing and displaying the data in the browsing list view.
Specifically, the step 4 includes:
step 401, receiving and extracting keywords contained in the browsing list type;
step 402, judging whether the keywords have subsets, if so, entering the next step;
step 403, calling an aggregation function to obtain values of all subsets;
and step 404, assembling the keywords and the values of the subsets thereof to generate a query command statement.
Specifically, the step 5 includes:
501, acquiring the logic layer number of each keyword in the query command statement;
step 502, splitting the query command statement into two sub-query command statements corresponding to a first logic layer number and a second logic layer number;
step 503, matching and judging whether the views corresponding to the first logical layer number and the second logical layer number sub-query command statement exist, if so, merging the views corresponding to the first logical layer number and the second logical layer number sub-query command statement according to a preset logical relationship to obtain a final view, otherwise, decreasing the first logical layer number according to a preset step length, returning to the previous step until the whole cycle is completed, and entering the next step;
and step 504, generating a view according to the logic layer number of each keyword in the query command statement.
Specifically, the query command statement is an SQL statement.
The invention has the beneficial effects that: according to the method and the device, the browsing list type is created, the empty browsing list and the corresponding empty storage queue list are created, the browsing list query command statement is generated according to the browsing list type, the browsing list view is further created, the data in the browsing list view are obtained, the data in the browsing list view are displayed in a refreshing mode, and therefore the browsing list is generated rapidly.
Drawings
FIG. 1 is a schematic structural diagram of a browsing list generating apparatus according to the present invention;
FIG. 2 is a schematic diagram of the structure of a data manipulation module according to the present invention;
fig. 3 is a flowchart illustrating a browsing list generation method according to the present invention.
Detailed Description
The embodiments of the present invention will be described in detail with reference to the accompanying drawings, which are for reference and illustrative purposes only and are not intended to limit the scope of the invention.
Example 1
As shown in fig. 1, the present embodiment provides a browsing list generation apparatus, including: the system comprises a media database generation module, a media database module, a database operation module, a statement assembly module, a list management module and a UI module;
the list management module is connected with the UI module, the media database generation module and the database operation module are also connected with the database operation module, and the database operation module is also connected with the statement assembly module;
the media database generation module is used for scanning media files in the peripheral equipment to generate media database files;
the media database module is used for storing media database files;
the database operation module is used for receiving the command sentences sent by the sentence assembly module, executing the operation on the media database files and acquiring the executed data;
the statement assembly module is used for combining the characteristic fields contained in the browsing list type to generate a corresponding query command statement;
the list management module is used for creating and managing a storage queue and a database view name and acquiring list data in a corresponding view;
and the UI module is used for receiving a browsing list type creation or query request and displaying the browsing list data acquired by the synchronous list management module.
In this embodiment, the data assembling module is an SQL data assembling module.
In this embodiment, the media database module is a QDB database.
Example 2
As shown in fig. 2, the data operation module of this embodiment includes: the system comprises a logic level acquisition unit, a logic level splitting unit, a view matching unit, a matching judgment unit and a view generation unit which are sequentially connected, wherein the matching judgment unit is also connected with the logic level splitting unit;
the logic level acquisition unit is used for acquiring the logic level number of each keyword in the query command statement;
the logic level splitting unit is configured to split the query command statement into two sub-query command statements corresponding to a first logic level number and a second logic level number;
the view matching unit is used for matching the views corresponding to the sub-query command statements of the first logic layer number and the second logic layer number;
the matching judgment unit is used for judging whether the views corresponding to the sub-query command statements of the first logic layer number and the second logic layer number exist or not, if so, the view generation unit is informed to generate the corresponding views, and if not, the logic level splitting unit is informed to adjust the number of the splitting logic layers;
and the view generating unit is used for generating a view according to the logic layer number of each keyword in the query command statement.
Example 3
As shown in fig. 3, the present embodiment provides a browsing list generation method, including:
step 1, creating a media file database.
The media file DataBase (e.g., QNX DataBase, QDB DataBase) is generated by the media DataBase generation module scanning the system peripherals and notifying the list management module and UI module that the preparation work for creating a browsing list is completed.
In this proposal, the media file database need only be created once.
For example, the media database generation module scans a usb disk or an SD card inserted into the car device, and stores directory structure information and media file attributes (including information such as song name, artist, genre, and album) in each directory into the media database file.
And 2, creating a browsing list type, judging whether the browsing list type exists, if so, entering the step 6, and otherwise, entering the next step.
For example, the user via the UI module asks to create a browse list of all rock-and-roll songs under album B by artist A.
And 3, creating an empty browsing list and a corresponding empty storage queue list, and establishing a communication link between the empty browsing list and the empty storage queue list to realize synchronous refreshing.
In this embodiment, the empty browsing list is created by the UI module, and the empty storage queue list is generated by the list generation module.
In this embodiment, the empty browsing list and the empty storage queue list establish a communication link through a callback message to implement synchronous refreshing.
And 4, generating a browsing list query command statement according to the browsing list type.
In specific implementation, a query command statement for operating the database may be preset in the data assembly module in advance, and then the query command statement is transmitted to the list type of the data assembly module through the list management module, and a keyword included in the list type is assembled to generate a corresponding query command statement, which is sent to the database operation module.
In this embodiment, the step 4 includes:
step 401, receiving and extracting keywords contained in the browsing list type;
step 402, judging whether the keywords have subsets, if so, entering the next step;
step 403, calling an aggregation function to obtain values of all subsets;
and step 404, assembling the keywords and the values of the subsets thereof to generate a query command statement.
In this embodiment, the query command statement is an SQL statement.
And 5, creating a browsing list view.
The database operation module creates a required browsing list view in the media database file through the acquired query command statement and a database operation service process (such as a QDB component of a QNX system).
In this embodiment, the view may update data formed by some fields in the query data table into the virtual table, so that it is not necessary to establish a large number of lists in the memory for storing the contents of the queried database. When one query operation needs to be frequently operated and used, the view can simplify the codes, the contents in the virtual table are directly queried and obtained instead of repeatedly querying the contents in the database every time, and the time consumed by querying the database for multiple times can be effectively reduced.
And 6, acquiring data in the browsing list view.
And the database operation module reads the list data in the browsing list view through the acquired query command statement and a database operation service process (such as a QDB component of a QNX system).
And 7, refreshing and displaying the data in the browsing list view.
And the list management module informs the UI module that the browsing list is updated and refreshes the data into the UI list.
Example 4
Unlike embodiment 3, in this embodiment, the step 5 includes:
501, acquiring the logic layer number n of each keyword in the query command statement;
step 502, splitting the query command statement into two sub-query command statements corresponding to a first logical layer number i (i is n-1, n-2, and browsing list generation 1) and a second logical layer number (n-i);
step 503, matching and judging whether the views corresponding to the first logical layer number and the second logical layer number sub-query command statement exist, if so, merging the views corresponding to the first logical layer number and the second logical layer number sub-query command statement according to a preset logical relationship to obtain a final view, otherwise, decreasing the first logical layer number according to a preset step length, returning to the previous step until the whole cycle is completed (i is 1), and entering the next step;
and step 504, generating a view according to the logic layer number of each keyword in the query command statement.
For example, if the number of logical layers of each keyword in the query command statement is 5, the query command statement is split into two sub-query command statements corresponding to a first logical layer number 4 and a second logical layer number 1, and if a view corresponding to the first logical layer number 4 exists, the view corresponding to the second logical layer number 1 and the view corresponding to the first logical layer number 4 are merged according to a preset logical relationship (e.g., union) to obtain a final view; if the view corresponding to the first logic layer number 4 does not exist, splitting the query command statement into two sub-query command statements corresponding to the first logic layer number 3 and the second logic layer number 2, and sequentially circulating until the first logic layer number is 1.
Through the logic layer number splitting mode, the existing view can be fully utilized, and the generation speed of the view is accelerated.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention and should not be taken as limiting the scope of the present invention.

Claims (8)

1. A browsing-list generating apparatus, comprising:
the system comprises a media database generation module, a media database module, a database operation module, a statement assembly module, a list management module and a UI module;
the list management module is connected with the UI module, the media database generation module and the database operation module are also connected with the database operation module, and the database operation module is also connected with the statement assembly module;
the media database generation module is used for scanning media files in the peripheral equipment to generate media database files;
the media database module is used for storing media database files;
the database operation module is used for receiving the command sentences sent by the sentence assembly module, executing the operation on the media database files and acquiring the executed data;
the statement assembly module is used for combining the characteristic fields contained in the browsing list type to generate a corresponding query command statement;
the list management module is used for creating and managing a storage queue and a database view name and acquiring list data in a corresponding view;
and the UI module is used for receiving a browsing list type creation or query request and displaying the browsing list data acquired by the synchronous list management module.
2. The browsing-list generating apparatus of claim 1, wherein the data operation module comprises: the system comprises a logic level acquisition unit, a logic level splitting unit, a view matching unit, a matching judgment unit and a view generation unit which are sequentially connected, wherein the matching judgment unit is also connected with the logic level splitting unit;
the logic level acquisition unit is used for acquiring the logic level number of each keyword in the query command statement;
the logic level splitting unit is configured to split the query command statement into two sub-query command statements corresponding to a first logic level number and a second logic level number;
the view matching unit is used for matching the views corresponding to the sub-query command statements of the first logic layer number and the second logic layer number;
the matching judgment unit is used for judging whether the views corresponding to the sub-query command statements of the first logic layer number and the second logic layer number exist or not, if so, the view generation unit is informed to generate the corresponding views, and if not, the logic level splitting unit is informed to adjust the number of the splitting logic layers;
and the view generating unit is used for generating a view according to the logic layer number of each keyword in the query command statement.
3. The browsing-list generation apparatus according to claim 1, wherein the data assembly module is an SQL data assembly module.
4. The browsing-list generation apparatus of claim 1, wherein the media database module is a QDB database.
5. A browsing list generation method is characterized by comprising the following steps:
step 1, creating a media file database;
step 2, creating a browsing list type, judging whether the browsing list type exists, if so, entering a step 6, otherwise, entering the next step;
step 3, creating an empty browsing list and a corresponding empty storage queue list, and establishing a communication link between the empty browsing list and the empty storage queue list to realize synchronous refreshing;
step 4, generating a browsing list query command statement according to the browsing list type;
step 5, creating a browsing list view;
step 6, acquiring data in the browsing list view;
and 7, refreshing and displaying the data in the browsing list view.
6. The browsing-list generating method of claim 5, wherein the step 4 comprises:
step 401, receiving and extracting keywords contained in the browsing list type;
step 402, judging whether the keywords have subsets, if so, entering the next step;
step 403, calling an aggregation function to obtain values of all subsets;
and step 404, assembling the keywords and the values of the subsets thereof to generate a query command statement.
7. The browsing-list generating method of claim 6, wherein said step 5 comprises:
501, acquiring the logic layer number of each keyword in the query command statement;
step 502, splitting the query command statement into two sub-query command statements corresponding to a first logic layer number and a second logic layer number;
step 503, matching and judging whether the views corresponding to the first logical layer number and the second logical layer number sub-query command statement exist, if so, merging the views corresponding to the first logical layer number and the second logical layer number sub-query command statement according to a preset logical relationship to obtain a final view, otherwise, decreasing the first logical layer number according to a preset step length, returning to the previous step until the whole cycle is completed, and entering the next step;
and step 504, generating a view according to the logic layer number of each keyword in the query command statement.
8. The browsing-list generating method of claim 5, wherein the query command statement is an SQL statement.
CN202011188599.8A 2020-10-30 2020-10-30 Browsing list generation device and implementation method Pending CN112434005A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011188599.8A CN112434005A (en) 2020-10-30 2020-10-30 Browsing list generation device and implementation method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011188599.8A CN112434005A (en) 2020-10-30 2020-10-30 Browsing list generation device and implementation method

Publications (1)

Publication Number Publication Date
CN112434005A true CN112434005A (en) 2021-03-02

Family

ID=74694811

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011188599.8A Pending CN112434005A (en) 2020-10-30 2020-10-30 Browsing list generation device and implementation method

Country Status (1)

Country Link
CN (1) CN112434005A (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101231872A (en) * 2007-01-22 2008-07-30 索尼株式会社 Information processing apparatus, information processing method, and information processing program
CN102239492A (en) * 2008-12-04 2011-11-09 微软公司 Relaxed filter set
US20150234557A1 (en) * 2014-02-20 2015-08-20 Siemens Aktiengesellschaft System for managing and processing data from a medical facility
KR20180005088A (en) * 2016-07-05 2018-01-15 한다시스템 주식회사 Method and computer program for designing a query
CN111240672A (en) * 2020-01-02 2020-06-05 广州虎牙科技有限公司 List implementation method and device, electronic equipment and readable storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101231872A (en) * 2007-01-22 2008-07-30 索尼株式会社 Information processing apparatus, information processing method, and information processing program
CN102239492A (en) * 2008-12-04 2011-11-09 微软公司 Relaxed filter set
US20150234557A1 (en) * 2014-02-20 2015-08-20 Siemens Aktiengesellschaft System for managing and processing data from a medical facility
KR20180005088A (en) * 2016-07-05 2018-01-15 한다시스템 주식회사 Method and computer program for designing a query
CN111240672A (en) * 2020-01-02 2020-06-05 广州虎牙科技有限公司 List implementation method and device, electronic equipment and readable storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
EUSTACE, K: "Expanded List View Condensed List View", 《SCULPTURE JOURNAL》 *
刘杰: "基于Web的用户数据库资源管理系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Similar Documents

Publication Publication Date Title
US8910044B1 (en) Playlist incorporating tags
US7143102B2 (en) Autogenerated play lists from search criteria
KR100466143B1 (en) File management method, contents recording apparatus, contents reproducing apparatus and contents recording medium
KR101183312B1 (en) Dispersing search engine results by using page category information
US8645349B2 (en) Indexing structures using synthetic document summaries
KR101137147B1 (en) Query forced indexing
US20070038647A1 (en) Management of media sources in memory constrained devices
CN101276361B (en) Method and system for displaying related key words
CN101167075B (en) Characteristic expression extracting device, method, and program
US7769752B1 (en) Method and system for updating display of a hierarchy of categories for a document repository
US20020099685A1 (en) Document retrieval system; method of document retrieval; and search server
US20060236847A1 (en) Using images as an efficient means to select and filter records in a database
US10430448B2 (en) Computer-implemented method of and system for searching an inverted index having a plurality of posting lists
US20220083618A1 (en) Method And System For Scalable Search Using MicroService And Cloud Based Search With Records Indexes
US7624122B2 (en) Method and system for querying a database
US20130268554A1 (en) Structured document management apparatus and structured document search method
CN103701875A (en) Multimedia file pushing method and device
EP2889788A1 (en) Accessing information content in a database platform using metadata
CN105653697A (en) Recommended word retrieval method and system
KR102516212B1 (en) Method and Apparatus for Generating Recommended Playlists
CN104252537B (en) Index sharding method based on mail features
CN115543994A (en) Metadata retrieval method, server, retrieval method and terminal equipment
JP4225384B2 (en) Data distribution system and method
CN112784073A (en) Method for integrating external multimedia resources of vehicle machine and computer storage medium
CN112434005A (en) Browsing list generation device and implementation method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination