Unlock instant, AI-driven research and patent intelligence for your innovation.

Multi-database caption display method and device based on SQL (structured query language) sentence

A database and statement technology, applied in the database field, can solve problems such as error-prone, complicated code modification process, increased workload, etc., to achieve the effect of reducing workload, saving workload, and improving performance

Inactive Publication Date: 2011-08-10
CHINA DIGITAL VIDEO BEIJING
View PDF2 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

According to the above method, the workload is increased, and because the code modification process is complicated and needs to be tested, it is easy to make mistakes

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Multi-database caption display method and device based on SQL (structured query language) sentence
  • Multi-database caption display method and device based on SQL (structured query language) sentence
  • Multi-database caption display method and device based on SQL (structured query language) sentence

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0035] refer to figure 1 , showing a flow chart of Embodiment 1 of a multi-database subtitle broadcasting method based on SQL statements in the present invention, including:

[0036] Step 101, receiving user access settings to multiple databases, and simultaneously connecting multiple databases through the ADODB component according to the access settings;

[0037] Wherein, the access settings include: database type, access mode, database name, user name, password, IP address and / or local path.

[0038] The embodiment of the present invention can access various types of databases, including Access, SQL Server, dBase, Oracle, Excel, Text and so on. It should be noted that in the present invention, the Text file can also be used as...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a multi-database caption display method and device based on the SQL (structured query language) sentence. The method comprises the following steps: receiving access settings of users to multiple databases and connecting multiple databases simultaneously through an ADODB (active data objects data based) assembly according to the access settings; receiving the SQL sentences input into the databases by users and carrying out data query in corresponding databases according to the SQL sentences; and displaying the data resulting from the data query as the content of image-text captions. The method and device in the invention can help reduce workload and maximally achieve easy access to databases and unified data query.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a multi-database subtitle broadcasting method and device based on SQL statements. Background technique [0002] At present, TV stations, mobile media and other broadcasters have a wide range of broadcasting needs for information videos, and they are different. The broadcasting content is generally obtained from the database. For different forms of subtitle broadcasting, the data storage methods are also different. Same, that is, broadcast content comes from various databases. [0003] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It is also defined as: a database is a collection of data organized according to a certain data model and stored in secondary storage. This kind of data collection has the following characteristics: it is not repeated as much as possible, and serves multiple applications of a specific organ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30H04N5/278
Inventor 王征
Owner CHINA DIGITAL VIDEO BEIJING
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More