Floss in Cadastre and Land Registration


From MS Access to PostgreSQL



Download 1,04 Mb.
Pdf ko'rish
bet73/96
Sana29.06.2021
Hajmi1,04 Mb.
#104118
1   ...   69   70   71   72   73   74   75   76   ...   96
Bog'liq
i1447e

From MS Access to PostgreSQL

Up to now, Cambodian land register data has been kept in MS Access data bases 

with the expectation that the data could be migrated to more powerful  database 

software as the data volume grows. One of the useful functions of MS Access is 

that it can link to databases in other formats through ODBC (Open Database Con-

nectivity). In that way, the ease of the MS Access interface can be combined with 

the reliability of server-based database software to form an efficient database sys-

tem. PostgreSQL, which is considered the most advanced open-source database 

software, has grown in sophistication and reliability and is now used by many large 

companies for mission critical operations. The maximum amount of data that can 

be stored in PostgreSQL databases is as yet unknown, but databases that store mul-

tiple terabytes of data are not uncommon. With the spatial extension PostGIS, 

which is also open-source, also geographic datasets can be stored in PostgreSQL. 

The powerful database capacities combined with spatial functions make Post-

greSQL especially suitable for land registration projects such as LASSP.

Migrating from MS Access to PostgreSQL may seem a daunting task, but is in 

reality rather easy. There are not many conversion tools for PostgreSQL available, 

but most of the conversion work can be done simply by copying data from the 

 Access tables into the linked PostgreSQL tables. For the Cambodian Land Register 

36

  Contracting skilled IT experts to the civil service is subject to the government’s public sector recruitment 



policies and cannot be directly influenced by MLMUPC alone.

37

  The credit agreement between the World Bank and the Government of Cambodia was ended on 4 Sep-



tember 2009 and all procurement has been postponed. Alternative financing options for the hardware 

 procurement are currently being studied.




71

 databases, the following procedure is followed. To begin with, a table structure 

was created in PostgreSQL. This can be done through the PgAdmin interface that 

lets users create database tables with columns, restrictions and indices. The table 

structure created for the Cambodian Land Register was almost identical to the 

 tables in MS Access, with a few differences in data types. Once the data structure 

was created, the tables were linked to the MS Access application. Then, data from 

the MS Access tables was copied into the linked PostgreSQL tables through ap-

pend queries. After appending the data, the MS Access tables were deleted from 

Figure 4.6: Printing land title certificates.




72

the application. Apart from setting the connection parameters, only a few modifi-

cations were needed to make the application work with the PostgreSQL database. 

The result is a database system that still uses the familiar MS Access interface, but 

with a more reliable database back-end that can store millions of land records. Re-

training of database users will not be needed, since the interface still looks the 

same and none of the database functions have changed.


Download 1,04 Mb.

Do'stlaringiz bilan baham:
1   ...   69   70   71   72   73   74   75   76   ...   96




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish