KR20150045867A - Apparatus for generating navigation service database based on mobile DBMS and method thereof - Google Patents

Apparatus for generating navigation service database based on mobile DBMS and method thereof Download PDF

Info

Publication number
KR20150045867A
KR20150045867A KR20130133041A KR20130133041A KR20150045867A KR 20150045867 A KR20150045867 A KR 20150045867A KR 20130133041 A KR20130133041 A KR 20130133041A KR 20130133041 A KR20130133041 A KR 20130133041A KR 20150045867 A KR20150045867 A KR 20150045867A
Authority
KR
South Korea
Prior art keywords
imdbms
data
navigation
loading
database
Prior art date
Application number
KR20130133041A
Other languages
Korean (ko)
Inventor
김재광
한혁
진성일
김용호
Original Assignee
주식회사 리얼타임테크
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 주식회사 리얼타임테크 filed Critical 주식회사 리얼타임테크
Priority to PCT/KR2013/010928 priority Critical patent/WO2015060495A1/en
Publication of KR20150045867A publication Critical patent/KR20150045867A/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/11—File system administration, e.g. details of archiving or snapshots
    • G06F16/119—Details of migration of file systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/17—Details of further file system functions
    • G06F16/174—Redundancy elimination performed by the file system

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to an apparatus and method for constructing a mobile DBMS-based database required for a partial map update (incremental map update) service of navigation, and an apparatus for generating a mobile DBMS-based navigation service DB according to the present invention includes an IMDBMS Mobile DBMS; A loading unit for loading navigation data into a database based on an IMDBMS; A processing unit for processing an IMDBMS-based database using a script language provided by the IMDBMS; And a mapping unit for creating a schema for loading the processed IMDBMS-based database, fetching data from the processed IMDBMS-based database, and loading the database in a mobile DBMS-based database according to the created schema.

Description

[0001] The present invention relates to a mobile DBMS-based navigation service DB generating apparatus and a method thereof,

The present invention relates to an apparatus and method for generating a navigation DB based on a mobile DBMS (Data Base Management System), and more particularly, to an apparatus and method for generating a navigation DB DB based on a mobile DBMS And an apparatus and method for constructing a database.

Conventional navigation manages navigation data based on physical storage format (PSF) files, and therefore, it takes a long time to update by adopting a block update method in total. Further, in the conventional navigation, the process of converting the source data for navigation into the service file for navigation uses the application program directly created by the developer, so that schema dependency is strong. In other words, since it depends on the schema of the service file, it is very expensive to construct a new conversion program or to change the conversion program at the time of schema change or update

On the other hand, navigation for supporting partial map update on an object basis requires construction of a mobile DBMS-based database. In order to reduce the cost of establishing a database based on a mobile DBMS, there is a strong need to improve schema dependency.

Korean Patent Laid-Open No. 10-2009-0056061 (2009.06.03)

SUMMARY OF THE INVENTION The present invention has been made in order to solve the above problems, and it is an object of the present invention to improve the dependency of data by converting the navigation raw data into a database based on a mobile DBMS by using an in- memory DBMS (IMDBMS) A mobile DBMS-based navigation service DB generating apparatus and method which can reduce the cost of updating and changing data.

According to an aspect of the present invention, there is provided an apparatus for generating a mobile DBMS-based navigation service DB comprising: an IMDBMS; Mobile DBMS; A loading unit for loading navigation data into a database based on an IMDBMS; A processing unit for processing an IMDBMS-based database using a script language provided by the IMDBMS; And a mapping unit for creating a schema for loading the processed IMDBMS-based database, fetching data from the processed IMDBMS-based database, and loading the database in a mobile DBMS-based database according to the created schema.

In the mobile DBMS-based navigation service DB generation apparatus, when the navigation source data is the MDB source file data of a BLOB (Binary Large Object) type, the loading unit first creates a schema for loading data, To an IMDBMS-based database using SQL provided by the IMDBMS in accordance with the created schema.

In the mobile DBMS-based navigation service DB generation apparatus, the loading unit uses a data transmission program (DTS) when the navigation source data is not a BLOB (Binary Large Object) type but general MDB source file data .

Wherein the mapping unit uses SQL provided by the IMDBMS when fetching data from the processed IMDBMS-based database, and when the data is loaded into the mobile DBMS-based database, And use the provided SQL.

In order to achieve the above object, a mobile DBMS-based navigation service DB generation method according to the present invention comprises the steps of: (a) loading navigation raw data into an IMDBMS-based database; (b) processing an IMDBMS-based database using a script language provided by the IMDBMS; And (c) creating a schema to load the processed IMDBMS-based database, fetching data from the processed IMDBMS-based database, and loading the database in a mobile DBMS-based database according to the created schema.

In the navigation DB creation method of the mobile DBMS, if the source data for navigation is MDB source file data of a BLOB (Binary Large Object) format, a schema for loading data is created first, This is a step of loading raw data for an IMDBMS based on the created schema and using SQL provided by the IMDBMS.

The mobile DBMS-based navigation service DB generation method according to claim 1, wherein, in the step (a), when the source data for navigation is a general MDB source file data other than a BLOB (Binary Large Object) .

In the mobile DBMS-based navigation service DB generation method, in the step (c), SQL provided by the IMDBMS is used to import data from the processed IMDBMS-based database, and when loading data into the mobile DBMS- And a step of using SQL provided by the database.

As described above, according to the present invention, an IMDBMS is used in the process of converting native data for navigation into a database based on a mobile DBMS. Therefore, SQL statements and stored procedures provided by the IMDBMS can be used, You can reduce the cost of creating and modifying the conversion program, because you can improve the dependency of the schema and utilize the SQL statements or stored procedures of the IMDBMS when changing or updating the service schema.

FIG. 1 is a block diagram illustrating a mobile DBMS-based navigation service DB generating apparatus according to an embodiment of the present invention.
FIG. 2 is a diagram for explaining a process of loading navigation raw data into a database based on an IMDBMS,
FIG. 3 is a diagram for explaining a process of converting an IMDBMS-based database into a mobile DBMS-based database in an optimal state,
4 is a diagram illustrating a process of loading data of a processed IMDBMS-based database into a mobile DBMS-based database.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

1, a preferred embodiment of a mobile DBMS-based navigation service DB generating apparatus according to the present invention includes a loading unit 10, a processing unit 20, an in-memory DBMS (IMDBMS) 30, a mapping unit 40, And a mobile DBMS 50.

The IMDBMS-based database 32 and the mobile DBMS-based database 52 are respectively passive components. The IMDBMS-based database 32 is stored in the main memory and the mobile DBMS-based database 52 is stored in the main memory Are stored in a separate storage medium. The storage medium used in the present invention is preferably implemented as a flash memory, but is not limited thereto.

The loading unit 10, the processing unit 20, the in-memory DBMS (IMDBMS) 30, the mapping unit 40, and the mobile DBMS 50, which are components of the present invention, It is an active component that can be implemented as a complex of software, defined by the functional features that each component provides below.

The IMDBMS 30 is installed in a main memory and operated, and the mobile DBMS 50 is implemented in a mobile device such as a navigation system. The IMDBMS 30 used in the present invention is preferably a high performance commercial IMDBMS.

The loading unit 10 loads the navigation source data into the IMDBMS-based database 32. When the navigation data is MDB source file data in the form of a BLOB (Binary Large Object), the loading unit 10 first creates a schema for loading data, and then supplies navigation data to the IMDBMS 30 in accordance with the created schema And loads it into the IMDBMS-based database 32 using SQL. On the other hand, when the navigation source data is not the BLOB type but the general MDB source file data, the loading unit 10 is implemented using the data transfer program (DTS).

The processing unit 20 processes the IMDBMS-based database 32 into a mobile DBMS-based database 52 using a script language such as SQL and a stored procedure provided by the IMDBMS 30, do. Items processed by the processing unit 20 include integrated object ID assignment and ID matching, neighbor node removal and interpolation point realignment, upper and lower multilink matching, route guidance instruction information processing, and the like.

The mapping unit 40 creates a schema for loading the processed IMDBMS-based database 32, fetches data from the processed IMDBMS-based database 32, and loads the data in the mobile DBMS-based database 52 in accordance with the created schema . The mapping unit 40 uses the SQL provided by the IMDBMS 30 when fetching data from the processed IMDBMS-based database 32 and uses the SQL provided by the mobile DBMS 50 when loading data into the mobile DBMS- And the SQL that is provided by.

Hereinafter, a mobile DBMS-based navigation service DB generation process according to the present invention will be described in detail with reference to FIG. 2 to FIG.

First, FIG. 2 illustrates a process of loading navigation data into a database 32 based on an IMDBMS. In order to load the navigation data for raw data into the database 32 based on the IMDBMS, the method differs depending on the type of the source file.

A data transfer program (DTS) is used to load the data of the general MDB source file into the database 32 based on the IMDBMS. The data transfer program (DTS) creates the schema of each table of the original MDB file in the IMDBMS-based database 32 and loads the data. Therefore, a schema is created to load the data and a separate program You do not have to do.

On the other hand, in the case of the MDB source file data of the BLOB type, the data of the source file is loaded into the IMDBMS-based database 32 through the loading program. At this time, in order to load data, a schema is first created and data is loaded. That is, the loading unit 10 fetches data from the MDB source file, and loads the data into the IMDBMS-based database 32 according to the schema generated using the SQL statement provided by the IMDBMS 30.

FIG. 3 illustrates a process of processing an IMDBMS-based database 32 into an optimal state to convert it into a mobile DBMS-based database 52. FIG. In other words, a series of operations for processing the data of the IMDBMS-based database 32 into the state of the immediately preceding state is performed. Each processing procedure utilizes a script language such as an SQL statement and a stored procedure provided by the IMDBMS (30).

The processing procedure is as follows.

1. Integrated object ID assignment and ID matching

2. Remove adjacent nodes and rearrange interpolation points

3. Multi-link matching

4. Processing route guidance information

FIG. 4 illustrates a process of loading data of the processed IMDBMS-based database 32 into the mobile DBMS-based database 52. FIG.

In order to load data, a mapping program (mapping unit 40) must be used.

First, a schema for loading data is created through a mapping program, data is fetched from a processed IMDBMS-based database 32, and data is merged and converted according to the schema to be loaded and loaded.

In order to handle the data in the mapping program, SQL provided by the IMDBMS 30 is used to fetch data from the processed IMDBMS-based database 32 as described with reference to FIG. 3, and the data supplied to the mobile DBMS-based database 52 When loading data, SQL provided by the mobile DBMS 50 is used.

The present invention has been described with reference to the preferred embodiments. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims. Therefore, the disclosed embodiments should be considered in an illustrative rather than a restrictive sense. The scope of the present invention is defined by the appended claims rather than by the foregoing description, and all differences within the scope of equivalents thereof should be construed as being included in the present invention.

10: loading section 20: processing section
30: IMDBMS 32: Database based on IMDBMS
40: mapping unit 50: mobile DBMS
52: Mobile DBMS-based database

Claims (8)

IMDBMS;
Mobile DBMS;
A loading unit for loading navigation data into a database based on an IMDBMS;
A processing unit for processing an IMDBMS-based database using a script language provided by the IMDBMS; And
And a mapping unit for creating a schema for loading the processed IMDBMS-based database and for loading data from the processed IMDBMS-based database and loading the database in a mobile DBMS-based database according to the created schema. DB generation device. The apparatus of claim 1, wherein the loading unit
If the navigation source data is an MDB source file data of a BLOB (Binary Large Object) type, a schema to be loaded with data is created first, and then the navigation source data is matched to the created schema and an IMDBMS Based navigation service DB based on the mobile DBMS. The apparatus of claim 1, wherein the loading unit
Wherein the navigation data is generated using a data transfer program (DTS) when the navigation source data is a general MDB source file data that is not a BLOB (Binary Large Object) format. The apparatus of claim 1, wherein the mapping unit
Wherein the mobile DBMS-based navigation service uses SQL provided by the IMDBMS when fetching data from a processed IMDBMS-based database and uses SQL provided by the mobile DBMS when loading data into a mobile DBMS-based database DB generation device. (a) loading navigation data for raw data into an IMDBMS-based database;
(b) processing an IMDBMS-based database using a script language provided by the IMDBMS; And
(c) creating a schema to load the processed IMDBMS-based database, and retrieving data from the processed IMDBMS-based database and loading the database in a mobile DBMS-based database according to the created schema How to create a navigation service DB. 6. The method of claim 5, wherein step (a)
If the source data for navigation is MDB source file data of a BLOB (Binary Large Object) type, the schema for loading the data is first created, and then the source data for navigation is matched to the created schema and the IMDBMS Wherein the step of loading the mobile DBMS-based navigation service DB comprises: 6. The method of claim 5, wherein step (a)
Wherein the navigation data is generated by using a data transfer program (DTS) when the navigation source data is not a BLOB (Binary Large Object) format but general MDB source file data. 6. The method of claim 5, wherein step (c)
The mobile DBMS-based navigation service DB is characterized by using the SQL provided by the IMDBMS when fetching data from the processed IMDBMS-based database and using the SQL provided by the mobile DBMS when loading data into the mobile DBMS- Generation method.
KR20130133041A 2013-10-21 2013-11-04 Apparatus for generating navigation service database based on mobile DBMS and method thereof KR20150045867A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
PCT/KR2013/010928 WO2015060495A1 (en) 2013-10-21 2013-11-28 Apparatus for generating mobile dbms-based navigation service db and method for same

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
KR1020130125189 2013-10-21
KR20130125189 2013-10-21

Publications (1)

Publication Number Publication Date
KR20150045867A true KR20150045867A (en) 2015-04-29

Family

ID=53037696

Family Applications (1)

Application Number Title Priority Date Filing Date
KR20130133041A KR20150045867A (en) 2013-10-21 2013-11-04 Apparatus for generating navigation service database based on mobile DBMS and method thereof

Country Status (1)

Country Link
KR (1) KR20150045867A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2017115897A1 (en) * 2015-12-30 2017-07-06 ㈜리얼타임테크 System for building road information database and searching routes

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2017115897A1 (en) * 2015-12-30 2017-07-06 ㈜리얼타임테크 System for building road information database and searching routes

Similar Documents

Publication Publication Date Title
CN107918666B (en) Data synchronization method and system on block chain
US9646030B2 (en) Computer-readable medium storing program and version control method
Benelallam et al. Neo4EMF, a scalable persistence layer for EMF models
CN107526777B (en) Method and equipment for processing file based on version number
CN105550268B (en) Big data process modeling analysis engine
CN108369591B (en) System and method for caching and parameterizing IR
CN104423982B (en) The processing method and processing equipment of request
CN109408528A (en) A kind of database script generation method, device, computing device and storage medium
CN105808746A (en) Relational big data seamless access method and system based on Hadoop system
US20120078877A1 (en) Multi-source searching in a data driven application
CN115686850A (en) Spark-based target task processing method and device and electronic equipment
CN113468204A (en) Data query method, device, equipment and medium
CN103902565A (en) Method and device for determining data access relation
CN104572876A (en) Method and device for reading configuration file corresponding to software
KR20150045867A (en) Apparatus for generating navigation service database based on mobile DBMS and method thereof
JP6176389B2 (en) Source code generation apparatus, source code generation method, and recording medium
CN105302551B (en) A kind of method and system of the Orthogonal Decomposition construction and optimization of big data processing system
CN101908174A (en) Method, device and EAP (Enterprise Application Platform) system for processing part object information in drawing file
US20190087458A1 (en) Interception of database queries for delegation to an in memory data grid
Kolovos et al. Constructing and navigating non-invasive model decorations
WO2015105043A1 (en) Computing system, database management device and computing method
CN103207907B (en) A kind of index file merges method and device
JP5488792B2 (en) Database operation device, database operation method, and program
CN102385599A (en) Inquiring and updating method of distributed data source
CN109857380A (en) A kind of workflow file compiling method and device

Legal Events

Date Code Title Description
E601 Decision to refuse application