Resolution to the record count increasing of the file exported from DB when ‘0A’ is included in it...

解决数据导出记录数异常
最新推荐文章于 2025-12-03 18:58:29 发布
转载 最新推荐文章于 2025-12-03 18:58:29 发布 · 127 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：https://my.oschina.net/qzhlove/blog/333400
文章标签：

#数据库 #java

本文介绍使用DBQueryAnalyzer3.02处理从数据库导出文件时遇到的数据记录数异常增加的问题。当文件中包含ASCII值为10的字符时，可能会导致Excel打开时记录数异常增加，通过配置双引号作为字段限定符可以有效解决该问题。

 

     Resolution to the record count increasing of the file exported from DB when ‘0A’ is included in it 

 

     DB Query Analyzer 3.02 is up for presented after Chinese Spring Festival. I have been doing software test on it for about a month.

      DB Query Analyzer 3.02 mainly has two new functions below:

 

    3.02 version two new characteristics

      First, DB Query Analyzer allows users to define the restrict character among single quotation marks, double quotation marks and none. If you reset it in the config window, the query result will take effect right now. However, If you reset the separator between SQL, it will take effect in the new opened SQL edit window.

      Second, Some Bug in the process that Stored Procedures and Key Words input by users will be drew different color in DB Query Analyzer is rectified.

 

 

     DB Query Analyzer  3.02 can help you

As a database application software engineer, I’m good at huge data process including not only the huge data file but huge records database system. Analysis to Billions of records is very normal in my daily job.

In some case, I found it very difficult to get know the reason why the data records became much more than the query result when you open the exported file by MS EXCEL. Also error message was seen when you import the file to some Database System.

After a long time analysis, I know it’s just because character which ASCII value is ten is in it.

This case will never been seen if you define double quotation marks to the character fields in DB Query Analyzer 3.02. After doing this step, you will get the correct record count for the exported file.


 

 

 

 

DB Query Analyzer 5.03 download URL:
http://xiazai.zol.com.cn/detail/43/420901.shtml
http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_503.rar
 

 

DB Query Analyzer Simplified Chinese version 5.03  download URL:
http://xiazai.zol.com.cn/detail/27/264455.shtml
 
 

 

   

转载于:https://my.oschina.net/qzhlove/blog/333400

chuyin3742
关注
Foster, S. The One Girl in Ten: A Self-portrait of the Teen Age Mother. Claremont, CA.: Arbor Press, 1981, 159 pp. [dollar]55.00 (paper)
06-29
The One Girl in Ten: A Self-portrait of the Teen Age Mother. Claremont, CA.: Arbor Press, 1981, 159 pp. [dollar]55.00 (paper) Psychology in rhe Schools Volume 1 9 . Ocrober. 1982 B O O K R E V I...
Resolution to the record count increasing of the file exported from DB when ‘0A’ is included in it
《万能数据库查询分析器》创作人
01-18 1479
Resolution to the record count increasing of the file exported from DB when ‘0A’ is included in it         DB Query Analyzer 3.02 is up for presented after Chinese Spring Festival. I have been d
This is the Manual for Quagga 1.2.0. Quagga is a fork of GNU Zebra
张同光 (Tongguang Zhang)：Hello everyone !
06-04 3408
This is the Manual for Quagga 1.2.0. Quagga is a fork of GNU Zebra
Oracle Database Server Messages(四) . . .
mengxiangfeiyang的专栏
02-24 1万+
Skip Headers Oracle9i Database Error Messages Release 2 (9.2) Part Number A96525-01 Home Book List Contents Index Master Index Feedback
NTSTATUS Values
zhanghaiyang9999的专栏
09-12 3429
By combining the NTSTATUS into a single 32-bit numbering space, the following NTSTATUS values are defined. Most values also have a defined default message that can be used to map the value to a human-...
12C ORA-错误汇总12 ORA-24280 to ORA-28709
badman250的专栏
03-02 4万+
ORA-24280: invalid input value for parameter string Cause: The parameter has been provided a negative, out of range, or NULL input value. Action: Correct the input value such that it is valid, and
12C ORA-错误汇总15 ORA-32800 to ORA-39965
badman250的专栏
03-02 3万+
ORA-32800: internal error string Cause: An unexpected error occurred. Action: Contact Oracle Support Services. ORA-32801: invalid value string for string Cause: An invalid value was specified for
System Error Codes
snail8384的专栏
08-13 9万+
From: http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382%28v=vs.85%29.aspx Applies to: desktop apps only Note   The information on this page is intended to be used by programm
drupal7翻译
热门推荐
Tech My Life
09-11 9万+
drupal7英汉对照   "Home"   "首页"   "User interface"   "用户界面"   "Title"   "标题"   "Body"   "正文"   "Next"   "下一个"   "user"   "用户"   "Pages"   "页面"   "Save configuration"   "保存设置"   "Reset to
12C ORA-错误汇总14 ORA-29250 to ORA-32799
badman250的专栏
03-02 3万+
ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Act
OFDM.zip_802.11a_Adopted_OFDM 802.11g_arena_ofdm lte matlab
09-22
Orthogonal Frequency Division Multiplex or OFDM is a modulation format that is finding increasing levels of use in today s radio communications scene. OFDM has been adopted in the Wi-Fi arena where ...
精选资源
MMATrans.rar_Grid map_The First_z map_z-map
07-13
These are the rows of Z values of the grid, organized in row ...following values correspond to the increasing X positions along the bottom row of the grid file. This file has a total of 4096 Z values.
Redis服务安装自启动(Windows版)
2509_94199043的博客
11-29 875
一般来说，一些中大型企业都会去采用 Linux 服务器来部署 Redis，而且 Redis 官方并没有提供 [Windows 版本](https://gitcode.com/gh_mirrors/wi/windows/overviewutm_source=highlight_word_gitcode&word=windows&isLogin=1 "Windows 版本")的安装包。
MySQL数据库的数据文件保存在哪？MySQL数据存在哪里
2509_94083514的博客
11-30 766
在安装好MySQL数据库使用一段时间后，会产生许多的数据库和数据。那这些数据库的数据文件存放在本地文件夹的什么位置呢一、默认位置MySQL创建的数据库实际上存储在文件系统的一个特定目录中，该目录通常为MySQL的数据目录。这个目录的默认位置依据操作系统和MySQL的安装方式不同而有所差异。、这个目录通常位于，它可能位于是个隐藏文件夹）**其中“X.X”是MySQL的版本号。目录（每个数据库都有一个与其同名的文件夹，而这个文件夹中包含了该数据库的所有表的文件，而其中的文件代表了数据库中的表。
【免费云平台部署指南】按场景选型+全维度对比（附直达地址）
分享技术干货，聚焦AI前沿科技
12-03 538
免费云平台已能覆盖从静态网站到AI模型部署的大部分场景，核心是根据项目类型（静态/后端/AI）、访问地区（国内/国外）和功能需求（数据库/容器/GPU）选择适配平台。新手建议从简单场景入手（如GitHub Pages部署博客、Hugging Face Spaces部署AI Demo），熟悉后再尝试全栈或容器化部署。
redis基本类型 5种基本类型
yeshihouhou的博客
11-30 256
List的另一个应用就是消息队列，可以利用List的 PUSH 操作，将任务存放在List中，然后工作线程再用 POP 操作将任务取出进行执行。我们在谈基础数据结构时，讨论的是存储值的数据类型，主要包括常见的5种数据类型，分别是：String、List、Set、Zset、Hash。Redis hash 是一个 string 类型的 field（字段） 和 value（值） 的映射表，hash 特别适合用于存储对象。Redis 中集合是通过哈希表实现的，所以添加，删除，查找的复杂度都是 O(1)。
我们来学mysql -- undo log系列归档
一起学Coding
12-01 174
undo log系列归档
【开题答辩全过程】以 基于Javaweb的电动汽车充电桩管理系统为例，包含答辩的问题和答案
最新发布
shiji9932的博客
12-03 320
本文介绍了一位14年经验的技术专家可提供的毕设支持服务，包括Java、Python等多语言项目开发与答辩指导。重点展示了一个"电动汽车充电桩管理系统"的答辩案例，详细说明了系统功能（预约管理、费用计算等）、技术实现（SpringBoot+Vue+MySQL）及关键问题解决方案（如预约冲突处理、断电检测机制）。文中提供了答辩问答实录，展现了从选题背景到技术细节的完整答辩过程，并附有评委的正面评价。最后建议学生可参考往届真实开题报告，提供选题指导、源码参考等服务，强调独立完成的重要性，同时表
NumericalWarning: A not p.d., added jitter of 1.0e-04 to the diagonal
07-22
### Cause of the Numerical Warning The warning message `NumericalWarning: A not positive definite, added jitter of 1.0e-04 to diagonal` typically occurs in numerical computations when a matrix that is expected to be **positive definite** is found to be **not positive definite**. This situation arises frequently in applications such as Gaussian processes, covariance matrix computations, and optimization problems where matrix inversion or decomposition is required. A symmetric matrix $ A \in \mathbb{R}^{n \times n} $ is positive definite if for any non-zero vector $ x \in \mathbb{R}^n $, the quadratic form $ x^T A x > 0 $. In practical terms, this ensures that the matrix has all positive eigenvalues, which is necessary for operations like Cholesky decomposition or computing the inverse. When the matrix is close to being singular or has eigenvalues that are very close to zero or negative due to numerical precision errors, the computation may fail or become unstable. To mitigate this issue, a small positive value (referred to as **jitter**) is added to the diagonal elements of the matrix, effectively increasing the smallest eigenvalues and making the matrix numerically positive definite. This diagonal jittering technique is commonly applied in libraries like GPyTorch and scikit-learn to stabilize matrix operations without significantly altering the underlying problem[^1]. ### Solution: Adding Diagonal Jitter The standard solution is to add a small constant value to the diagonal entries of the matrix $ A $ before performing the operation that requires positive definiteness. Mathematically, this can be expressed as: $$ A_{\text{new}} = A + \epsilon I $$ where $ \epsilon $ is a small positive number (e.g., $ 10^{-4} $) and $ I $ is the identity matrix of the same size as $ A $. This adjustment ensures that all eigenvalues of $ A_{\text{new}} $ are increased by $ \epsilon $, which typically makes the matrix positive definite. Here is a Python example using NumPy to demonstrate this technique: ```python import numpy as np # Original matrix that may not be positive definite A = np.array([[2, -1, 0], [-1, 2, -1], [0, -1, 2]]) # Check if A is positive definite try: np.linalg.cholesky(A) except np.linalg.LinAlgError: print("Matrix is not positive definite.") # Add diagonal jitter epsilon = 1e-4 A_jittered = A + epsilon * np.eye(A.shape[0]) # Check again try: np.linalg.cholesky(A_jittered) print("Matrix is now positive definite after adding jitter.") except np.linalg.LinAlgError: print("Matrix is still not positive definite.") ``` In practice, choosing an appropriate value for $ \epsilon $ is crucial. Too small a value may not resolve the issue, while too large a value can distort the results significantly. Common choices for $ \epsilon $ range from $ 10^{-6} $ to $ 10^{-3} $ depending on the scale of the matrix entries and the specific application. ###
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值