From SQL Server to MongoDB - Aleks Drozdov, Enterprise Architect, The National Archives
MongoUK 2011
How The National Archives migrated its data store from SQL Server to Mongo DB and built Service-Oriented Platform to make available over 11m of historical... records.
http://discovery.nationalarchives.gov.uk
About The National Archives • The
Na-onal
Archives
is
a
department
of
the
U.K.
government
and
an
execu-ve
agency
of
the
Ministry
of
Jus-ce.
It’s
the
official
archives
of
the
United
Kingdom
and
cares
for,
makes
available
and
‘brings
alive’
a
vast
collec-on
of
more
than
1,000
years
of
historical
records,
including
the
treasured
Domesday
Book.
• The
Na-onal
Archives
is
one
of
the
world’s
largest
records
repositories,
holding
more
than
11
million
records,
spanning
the
Magna
Carta
to
modern
government
papers.
The
organiza-on
not
only
keeps
its
collec-on
secure
and
available
to
the
public,
it
also
conducts
significant
research
ensuring
government
records
remain
accessible
for
decades
to
come.
• The
Na-onal
Archives
safeguards
historical
informa-on
and
manages
current
digital
informa-on,
devising
new
technological
solu-ons
for
keeping
government
records
readable
now
and
in
the
future.
As
a
leading
advocate
for
the
archive
sector,
The
Na-onal
Archives
provides
world
class
research
facili-es
and
expert
advice.
It
also
publishes
all
U.K.
legisla-on
and
official
publica-ons.
THE
CATALOGUE
The
Na-onal
Archives
launched
an
online
catalogue
of
its
collec-on
in
1998.
Since
then,
the
catalogue
has
more
than
doubled
in
size
and
the
organiza-on
has
designed
and
implemented
a
number
of
home-‐grown
systems
to
improve
the
accessibility
and
maintenance
of
its
growing
collec-on.
• The Catalogue • Cabinet Papers • DocumentsOnline • ERO • Library Catalogue • Taxation Records • Trafalgar Ancestors database • UK Government Web Archive • Census records • Merchant seamen registers • More…
SOA
FRAMEWORK:
SERVICES
AND
OBJECTS
In
2010,
The
Na-onal
Archives
decided
to
move
to
a
standardized
Service
Oriented
Architecture
framework
to
reduce
maintenance
costs
and
provide
the
flexibility
to
add
new
services
in
the
future.
CREATING
INFORMATION
ASSET:
EAV
13 Entity-attribute-value model (EAV) is a data model to describe entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest.
mongodb
yoshiitaka
yoshidashingo
nayuts
dahatake
yokawasa
keiko713
niftycorp
oracle4engineer
sugawani
hokaccha
yuya4
you
addyosmani
caitiem20
sonatard
morganepeng
revolveconf
jonyablonski
rasmusluckow
chriscoyier
maltzj
holman
erikaheidi