SYSTEM, METHOD AND DATABASE PROXY SERVER FOR SEPARATING OPERATIONS OF READ AND WRITE_US20160232372A1_Alibaba.pdf
免费下载
III
III
0
IIOI
DID
III
OII
100
1101
DIII
I
DIII
III
0110
II
DI
II
U
S
20160232372A1
(
19)
United
States
(
12)
Patent
Application
Publication
(10)
Pub.
No.:
US
2016/0232372
Al
L
IN
(43)
Pub.
Date:
Aug.
11,
2016
(
54)
SYSTEM,
METHOD
AND
DATABASE
PROXY
S
ERVER
FOR
SEPARATING
OPERATIONS
O
F
READ
AND
WRITE
(
71)
Applicant:
Alibaba
Group
Holidng
Limited,
G
eorge
Town
(KY)
(
72)
Inventor:
Xiaobin
LIN,
Hangzhou
(CN)
(
21)
Appi.
No.:
15/015,911
(
22)
Filed:
Feb.
4,
2016
(
30)
Foreign
Application
Priority
Data
F
eb.5,2015
(CN)
...........................
20150062422.6
P
ublication
Classification
(
51)
Int.Cl.
G
06F
21/62
(2006.01)
H
04L
29/08
(2006.01)
D
ATABASE
SERVER
OBTAINS
AND
STORES
A
CLIENT
ID
A
FTER
ESTABLISHING
A
SLAVE
DATABASE
CONNECTION
W
ITH
A
SLAVE
DATABASE
CORRESPONDING
TO
A
CLIENT
D
ATABASE
SERVER
RECEIVES
AN
OPERATION
REQUEST
F
ROM
THE
CLIENT
I
F
THE
OPERATION
REQUEST
IS
A
WRITE
REQUEST,
THE
D
ATABASE
SERVER
ESTABLISHES
A
MASTER
DATABASE
C
ONNECTION
WITH
A
MASTER
DATABASE
BY
USE
OF
A
P
UBLIC
ID
AND
A
PUBLIC
PASS
CODE
AND
SENDS
THE
C
LIENT
ID
TO
THE
MASTER
DATABASE,
WHERE
UPON
R
ECEIVING
THE
CLIENT
ID,
THE
MASTER
DATABASE
U
PDATES
THE
PUBLIC
ID
WITH
THE
RECEIVED
CLIENT
ID,
A
ND
UPDATES
ACCESS
PERMISSIONS
ASSOCIATED
WITH
T
HE
PUBLIC
ID
WITH
ACCESS
PERMISSIONS
ASSOCIATED
W
ITH
THE
CLIENT
ID
T
HE
DATABASE
SERVER
SENDS
THE
WRITE
REQUEST
TO
T
HE
MASTER
DATABASE
BY
USE
OF
THE
MASTER
DATABASE
C
ONNECTION,
WHERE
THE
MASTER
DATABASE
EXECUTES
A
W
RITE
OPERATION
CORRESPONDING
TO
THE
WRITE
R
EQUEST
AND
TO
THE
ACCESS
PERMISSIONS
ASSOCIATED
W
ITH
CLIENT
ID
(
52)
U.S.
Cl.
C
PC
........G06F21/6218
(2013.01);
HO4L
67/2842
(
2013.01)
(
57)
ABSTRACT
A
method
of
separating
read
operations
from
write
operations
i
ncludes
obtaining
and
storing
a
client
ID
after
establishing
a
s
lave
database
connection
with
a
slave
database
correspond-
ing
to
a
client,
an
d
receiving
an
operation
request
from
the
c
lient.
If
the
operation
request
is
a
write
request,
the
method
a
lso
includes
establishing
a
master
database
connection
with
a
master
database
by
use
of
a
public
ID
and
a
public
passcode
a
nd
sending
the
client
ID
to
the
master
database,
where
upon
r
eceiving,
the
master
database
updates
the
public
ID
with
the
r
eceived
client
ID,
and
updates
access
permissions
associated
w
ith
the
public
ID
with
access
permissions
associated
with
t
he
client
ID.
The
method
further
includes
sending
the
write
r
equest
to
the
master
database
by
use
of
the
master
database
c
onnection,
where
a
write
operation
corresponding
to
the
w
rite
request
and
to
the
access
permissions
associated
with
c
lient
ID
is
executed.
100
101
1
02
1
03
1
04
Patent
Application
Publication
Aug.
11,2016
Sheet
1
of
9
US
2016/0232372
Al
1
00
D
ATABASE
SERVER
OBTAINS
AND
STORES
A
CLIENT
ID
I--
101
A
FTER
ESTABLISHING
A
SLAVE
DATABASE
CONNECTION
W
ITH
A
SLAVE
DATABASE
CORRESPONDING
TO
A
CLIENT
D
ATABASE
SERVER
RECEIVES
AN
OPERATION
REQUEST
--
102
F
ROMTHECLIENT
I
I
F
THE
OPERATION
REQUEST
IS
A
WRITE
REQUEST,
THE
--
103
D
ATABASE
SERVER
ESTABLISHES
A
MASTER
DATABASE
C
ONNECTION
WITH
A
MASTER
DATABASE
BY
USE
OF
A
P
UBLIC
ID
AND
A
PUBLIC
PASS
CODE
AND
SENDS
THE
C
LIENT
ID
TO
THE
MASTER
DATABASE,
WHERE
UPON
R
ECEIVING
THE
CLIENT
ID,
THE
MASTER
DATABASE
U
PDATES
THE
PUBLIC
ID
WITH
THE
RECEIVED
CLIENT
ID,
A
ND
UPDATES
ACCESS
PERMISSIONS
ASSOCIATED
WITH
T
HE
PUBLIC
ID
WITH
ACCESS
PERMISSIONS
ASSOCIATED
W
ITH
THE
CLIENT
ID
T
HE
DATABASE
SERVER
SENDS
THE
WRITE
REQUEST
TO
--
104
T
HE
MASTER
DATABASE
BY
USE
OF
THE
MASTER
DATABASE
C
ONNECTION,
WHERE
THE
MASTER
DATABASE
EXECUTES
A
W
RITE
OPERATION
CORRESPONDING
TO
THE
WRITE
R
EQUEST
AND
TO
THE
ACCESS
PERMISSIONS
ASSOCIATED
W
ITH
CLIENT
ID
F
IG.
I
of 19
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论