Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for eliminating differences between hollow character strings and invalid character strings in database

A technology of empty strings and invalid characters, applied in the direction of electronic digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problems of wrong results, inconvenient post-processing, and inability to guarantee consistent running results, etc., to eliminate differences , the effect of consistent running results

Active Publication Date: 2020-05-01
DAREWAY SOFTWARE
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This difference will make it impossible to guarantee that the translated sql will run on the oracle database in the same way as other databases, resulting in wrong results and bringing a lot of inconvenience to post-processing

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
  • Method and device for eliminating differences between hollow character strings and invalid character strings in database
  • Method and device for eliminating differences between hollow character strings and invalid character strings in database
  • Method and device for eliminating differences between hollow character strings and invalid character strings in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The present disclosure will be further described below in conjunction with the accompanying drawings and embodiments.

[0037] It should be noted that the following detailed description is exemplary and intended to provide further explanation of the present disclosure. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs.

[0038] It should be noted that the terminology used herein is only for describing specific embodiments, and is not intended to limit the exemplary embodiments according to the present disclosure. As used herein, unless the context clearly dictates otherwise, the singular is intended to include the plural, and it should also be understood that when the terms "comprising" and / or "comprising" are used in this specification, they mean There are features, steps, operations, means, components and / or combinations thereof.

...

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 method and device for eliminating differences between hollow character strings and invalid character strings in a database. The method comprises the steps of obtaining all character type columns in a service table from a data dictionary of the database; verifying whether all character type columns in the service table are provided with credible marks or not according to the credible mark record table, If yes, ending the step; if not, performing full-table scanning on the character type column data without the credible mark, and detecting whether an empty character string exists or not; if the empty character string exists, updating the empty character string into an invalid character string, otherwise, setting credible marks of the character type columns in the service table and the related views, and recording the credible marks into a credible mark recording table; and obtaining a credible mark of the character type column of the service table from the credible mark record table, and recompiling the standard database statement according to the credible mark of the character type column to obtain a database native structured query language.

Description

technical field [0001] The disclosure belongs to the technical field of database data processing, and relates to a method and a device for eliminating the difference between an empty character string and an invalid character string in a database. Background technique [0002] The statements in this section merely provide background information related to the present disclosure and do not necessarily constitute prior art. [0003] At present, there are various types of databases, and various applications have more choices for using databases, but there are differences between different databases, including database functions and keywords. If you define and use standard database syntax, and then translate standard database statements into the native structured query language (sql) of each database for execution, you can get rid of the dilemma of having to learn a database syntax to use a database. [0004] However, the different handling of empty strings (ie ") and invalid st...

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
IPC IPC(8): G06F16/2452
CPCG06F16/24522Y02D10/00
Inventor 赵永光朱晓洪于秋波宋喆闫中敏钱进王可可
Owner DAREWAY SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com