排行
数据库百科
核心案例
行业报告
月度解读
大事记
产业图谱
中国数据库
向量数据库
时序数据库
实时数据库
搜索引擎
空间数据库
图数据库
数据仓库
大调查
2021年报告
2022年报告
年度数据库
2020年openGauss
2021年TiDB
2022年PolarDB
2023年OceanBase
首页
资讯
活动
大会
学习
课程中心
推荐优质内容、热门课程
学习路径
预设学习计划、达成学习目标
知识图谱
综合了解技术体系知识点
课程库
快速筛选、搜索相关课程
视频学习
专业视频分享技术知识
电子文档
快速搜索阅览技术文档
文档
问答
服务
智能助手小墨
关于数据库相关的问题,您都可以问我
数据库巡检平台
脚本采集百余项,在线智能分析总结
SQLRUN
在线数据库即时SQL运行平台
数据库实训平台
实操环境、开箱即用、一键连接
数据库管理服务
汇聚顶级数据库专家,具备多数据库运维能力
数据库百科
核心案例
行业报告
月度解读
大事记
产业图谱
我的订单
登录后可立即获得以下权益
免费培训课程
收藏优质文章
疑难问题解答
下载专业文档
签到免费抽奖
提升成长等级
立即登录
登录
注册
登录
注册
首页
资讯
活动
大会
课程
文档
排行
问答
我的订单
首页
专家团队
智能助手
在线工具
SQLRUN
在线数据库即时SQL运行平台
数据库在线实训平台
实操环境、开箱即用、一键连接
AWR分析
上传AWR报告,查看分析结果
SQL格式化
快速格式化绝大多数SQL语句
SQL审核
审核编写规范,提升执行效率
PLSQL解密
解密超4000字符的PL/SQL语句
OraC函数
查询Oracle C 函数的详细描述
智能助手小墨
关于数据库相关的问题,您都可以问我
精选案例
新闻资讯
云市场
登录后可立即获得以下权益
免费培训课程
收藏优质文章
疑难问题解答
下载专业文档
签到免费抽奖
提升成长等级
立即登录
登录
注册
登录
注册
首页
专家团队
智能助手
精选案例
新闻资讯
云市场
微信扫码
复制链接
新浪微博
分享数说
采集到收藏夹
分享到数说
举报
文档
/
System and Method for Compressing Data in a Database_US9442949.pdf
System and Method for Compressing Data in a Database_US9442949.pdf
onboard
67
18页
0次
2021-11-25
免费下载
(12)
United
States
Patent
Velury
et
al.
USOO9442949B2
US
9.442,949
B2
Sep.
13,
2016
(10)
Patent
No.:
(45)
Date
of
Patent:
(54)
(71)
(72)
(73)
(*)
(21)
(22)
(65)
(51)
(52)
(58)
(56)
7,630,996
B1
7,647,291
B2
SYSTEMAND
METHOD
FOR
COMPRESSING
DATA
IN
ADATABASE
Applicant:
FutureWei
Technologies,
Inc.,
Plano,
TX
(US)
Inventors:
Ramabrahmam
Velury,
San
Jose,
CA
(US);
Jihui
Tan,
Shenzhen
(CN);
Guangcheng
Zhou,
Shenzhen
(CN)
Assignee:
Futurewei
Technologies,
Inc.,
Plano,
TX
(US)
Notice:
Subject
to
any
disclaimer,
the
term
of
this
patent
is
extended
or
adjusted
under
35
U.S.C.
154(b)
by
260
days.
Appl.
No.:
13/804,321
Filed:
Mar.
14,
2013
Prior
Publication
Data
US
2014/0279964
A1
Sep.
18,
2014
Int.
C.
G06F
7/30
(2006.01)
H03M
7/30
(2006.01)
GO6F
15/16
(2006.01)
U.S.
C.
CPC.
G06F
17/30153
(2013.01);
G06F
17/30592
(2013.01);
H03M
7/30
(2013.01);
H03M
7/3084
(2013.01)
Field
of
Classification
Search
CPC
combination
set(s)
only.
See
application
file
for
complete
search
history.
References
Cited
U.S.
PATENT
DOCUMENTS
12/2009
Hershkovich
1/2010
Mosescu
TRANSFEROBINARY
Bris)
7,739,445
B1*
6/2010
Venkatachary
...............
T11
108
8.255,398
B2
8/2012
Bhattacharjee
et
al.
2003,0191740
A1*
10,
2003
Stark
.................
G06F
17,30864
2003/0208503
A1*
11/2003
Roccaforte
.......
GO6F
17,30592
2005/0237.938
A1*
10,
2005
Corlet
al.
....................
370,235
2008/0222136
A1
9,
2008
Yates
et
al.
2010/0223237
A1
9/2010
Mishra
et
al.
2010/0287160
A1*
11/2010
Pendar
..........................
707f737
2012/0136889
A1*
5/2012
Jagannathan
et
al.
........
707/769
OTHER
PUBLICATIONS
Dehne,
Frank,
et
al.,
“Compressing
Data
Cube
in
Parallel
Olap
Systems.”
Data
Science
Journal,
Mar.
2007,
18
pages.
Goldstein,
Jonathan,
et
al.,
“Compressing
Relations
and
Indexes.”
ICDE
'98
Proceedings
of
the
Fourteenth
International
Conference
on
Data
Engineering,
Feb.
23-27,
1998,
10
pages.
International
Search
Report
for
Application
No.
PCT/CN2014/
073404
mailed
Jun.
18,
2014.
*
cited
by
examiner
Primary
Examiner
—
Alex
Gofman
(74)
Attorney,
Agent,
or
Firm
—
Slater
Matsil,
LLP
(57)
ABSTRACT
A
method
of
compressing
a
plurality
of
multi-dimensional
keys
includes
receiving,
by
a
computer,
the
plurality
of
multi-dimensional
keys,
where
the
plurality
of
multi-dimen
sional
keys
have
a
first
length
and
determining
a
first
plurality
of
bit
slots
that
are
common
among
the
plurality
of
multi-dimensional
keys,
wherein
the
first
plurality
of
bit
slots
are
not
a
prefix.
Also,
the
method
includes
forming
a
mask
indicating
the
first
plurality
of
bit
slots
and
forming
a
pattern
indicating
values
of
the
first
plurality
of
bit
slots.
Additionally,
the
method
includes
determining
a
second
plurality
of
bit
slots
that
vary
among
the
plurality
of
multi
dimensional
keys
and
forming
a
plurality
of
compressed
multi-dimensional
keys
indicating
values
of
the
second
plurality
of
bit
slots.
Further,
the
method
includes
storing
the
mask,
the
pattern,
and
the
plurality
of
compressed
multi
dimensional
keys.
17
Claims,
11
Drawing
Sheets
\
NCOMPRESSEDPAGE
210
19999999999999.
00:01.000:1.0001001000
U.S.
Patent
Sep.
13,
2016
Sheet
1
of
11
US
9,442,949
B2
100
102
A)-HOC
SPREAD
DASHBOARDS
REPORS
ANAYSIS
SHEES
SOURCE
DATA
ERPICRM
EGACY
DAA
RDBMSIOLAP
OTHER
FA
FILETEXCE
APPLICATIONS
LOCAL
DATA
FIG.
1
(12)
United
States
Patent
Velury
et
al.
USOO9442949B2
US
9.442,949
B2
Sep.
13,
2016
(10)
Patent
No.:
(45)
Date
of
Patent:
(54)
(71)
(72)
(73)
(*)
(21)
(22)
(65)
(51)
(52)
(58)
(56)
7,630,996
B1
7,647,291
B2
SYSTEMAND
METHOD
FOR
COMPRESSING
DATA
IN
ADATABASE
Applicant:
FutureWei
Technologies,
Inc.,
Plano,
TX
(US)
Inventors:
Ramabrahmam
Velury,
San
Jose,
CA
(US);
Jihui
Tan,
Shenzhen
(CN);
Guangcheng
Zhou,
Shenzhen
(CN)
Assignee:
Futurewei
Technologies,
Inc.,
Plano,
TX
(US)
Notice:
Subject
to
any
disclaimer,
the
term
of
this
patent
is
extended
or
adjusted
under
35
U.S.C.
154(b)
by
260
days.
Appl.
No.:
13/804,321
Filed:
Mar.
14,
2013
Prior
Publication
Data
US
2014/0279964
A1
Sep.
18,
2014
Int.
C.
G06F
7/30
(2006.01)
H03M
7/30
(2006.01)
GO6F
15/16
(2006.01)
U.S.
C.
CPC.
G06F
17/30153
(2013.01);
G06F
17/30592
(2013.01);
H03M
7/30
(2013.01);
H03M
7/3084
(2013.01)
Field
of
Classification
Search
CPC
combination
set(s)
only.
See
application
file
for
complete
search
history.
References
Cited
U.S.
PATENT
DOCUMENTS
12/2009
Hershkovich
1/2010
Mosescu
TRANSFEROBINARY
Bris)
7,739,445
B1*
6/2010
Venkatachary
...............
T11
108
8.255,398
B2
8/2012
Bhattacharjee
et
al.
2003,0191740
A1*
10,
2003
Stark
.................
G06F
17,30864
2003/0208503
A1*
11/2003
Roccaforte
.......
GO6F
17,30592
2005/0237.938
A1*
10,
2005
Corlet
al.
....................
370,235
2008/0222136
A1
9,
2008
Yates
et
al.
2010/0223237
A1
9/2010
Mishra
et
al.
2010/0287160
A1*
11/2010
Pendar
..........................
707f737
2012/0136889
A1*
5/2012
Jagannathan
et
al.
........
707/769
OTHER
PUBLICATIONS
Dehne,
Frank,
et
al.,
“Compressing
Data
Cube
in
Parallel
Olap
Systems.”
Data
Science
Journal,
Mar.
2007,
18
pages.
Goldstein,
Jonathan,
et
al.,
“Compressing
Relations
and
Indexes.”
ICDE
'98
Proceedings
of
the
Fourteenth
International
Conference
on
Data
Engineering,
Feb.
23-27,
1998,
10
pages.
International
Search
Report
for
Application
No.
PCT/CN2014/
073404
mailed
Jun.
18,
2014.
*
cited
by
examiner
Primary
Examiner
—
Alex
Gofman
(74)
Attorney,
Agent,
or
Firm
—
Slater
Matsil,
LLP
(57)
ABSTRACT
A
method
of
compressing
a
plurality
of
multi-dimensional
keys
includes
receiving,
by
a
computer,
the
plurality
of
multi-dimensional
keys,
where
the
plurality
of
multi-dimen
sional
keys
have
a
first
length
and
determining
a
first
plurality
of
bit
slots
that
are
common
among
the
plurality
of
multi-dimensional
keys,
wherein
the
first
plurality
of
bit
slots
are
not
a
prefix.
Also,
the
method
includes
forming
a
mask
indicating
the
first
plurality
of
bit
slots
and
forming
a
pattern
indicating
values
of
the
first
plurality
of
bit
slots.
Additionally,
the
method
includes
determining
a
second
plurality
of
bit
slots
that
vary
among
the
plurality
of
multi
dimensional
keys
and
forming
a
plurality
of
compressed
multi-dimensional
keys
indicating
values
of
the
second
plurality
of
bit
slots.
Further,
the
method
includes
storing
the
mask,
the
pattern,
and
the
plurality
of
compressed
multi
dimensional
keys.
17
Claims,
11
Drawing
Sheets
\
NCOMPRESSEDPAGE
210
19999999999999.
00:01.000:1.0001001000
U.S.
Patent
Sep.
13,
2016
Sheet
1
of
11
US
9,442,949
B2
100
102
A)-HOC
SPREAD
DASHBOARDS
REPORS
ANAYSIS
SHEES
SOURCE
DATA
ERPICRM
EGACY
DAA
RDBMSIOLAP
OTHER
FA
FILETEXCE
APPLICATIONS
LOCAL
DATA
FIG.
1
登录查看全部内容
of 18
免费下载
gaussdb
opengauss
patent
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250
周榜
月榜
有奖问卷
意见反馈
客服小墨
评论