DE102008059098A1 - Infotainment system and computer program product - Google Patents

Abstract

Infotainment system comprising infotainment data stored in a relational database (RDB) as records of first and second record types. Each record of the first record type comprises a unique first identifier (PK1), property values (a1-c1) of a first property (A1-C1) and a child identifier (PID). Each record of the second record type comprises a unique second identifier (PK2) and property values (d2, e2) of a second property (D2, E2). The first identifier (PK1), the first property (A1-C1) and the associated sub-identifier (PID) are assigned to a first main table (MR1). The second identifier (PK2) and the second characteristic (D2, E2) are assigned to a second main table (MR2). In this case, a property value in the case of only a second property or a combination of the property values (d2, e2) is only stored once in the second main table (MR2) in the case of a plurality of second properties. The sub-identifier (PID) and the second identifier (PK2) are stored in at least one subtable (PR).

Description

The The invention relates to an infotainment system and a computer program product for operating the infotainment system.

infotainment systems For example, they are installed in modern motor vehicles and link them Mediation of information, such. B. navigation data, and from Entertainment data, such. B. TV or music data. The storage and administration of this so-called infotainment data is preferably carried out by means of a database system.

One modern database system regularly includes a database and a Database management system. The data is stored in the database. The database management system is provided for managing the Data in the database. For example, managing the database can be Searching, reading and / or writing data in the database include. In particular, you can outdated data is updated by an update command, which comprises a combination of search, read and / or write commands.

task The invention is an infotainment system and a computer program product for Operating the infotainment system to create an efficient Storage of infotainment data allows.

The The object of the invention is achieved by the characteristics of the independent Claims. Advantageous embodiments of the invention are specified in the subclaims.

The Invention is characterized with respect a first aspect by an infotainment system, which is a relational Database stored on a storage medium, and a Database management system includes. The database management system is trained to access infotainment data stored in the relational database as records of a first record type and as records of a second record type are stored. Each record of the first Record type has an identifier value of a unique first Identifier, a respective property value of at least a first one Property and one sub-identifier of at least one Subkey on. Each record of the second record type points an identifier value of a unique second identifier and a respective one Property value of at least one second property. The unique first identifier, the at least one first property and the at least an associated sub-identifier is associated with a first main table. The unique second identifier and the at least one second property are assigned to a second main table. Tuple of property values the second property associated with the second main table, are only stored once each in the second main table. The sub-identification values of the at least one sub-identifier and the associated identifier values of the unique second identifier stored in at least one subtable. This contributes to it in that redundancy of property values in the second main table, associated with a respective record of the second record type are to be reduced.

The First and second main tables preferably have at least one unique identifier and at least one property. The at least one Subtable has the at least one subrecognition and the unique one second identifier on. The first and second main table and the at least a subtable has columns and rows. A column is each a property or a unique identifier or associated with a sub-identifier and represents the respective line a respective data record of the respective table. The sub-IDs the at least one subrecognition is under with the help of the at least one sub-table a reference of the respective line the first main table to the associated respective row of second main table.

there a tuple refers to a combination of property values that associated with a row of the second main table. Tuple the Property values can includes one or more property values corresponding to one row of the are assigned to the second main table. Is the second main table assigned only one property, so is the respective property value property stored only once in the second main table. If, on the other hand, several properties are assigned to the second main table, such is a combination of the assigned property values, the is associated with a row of the second record type, only one at a time once stored in the second main table.

Preferably the first and second main tables are a plurality of first and second Attributes assigned. The first properties are functional independently from each other and the second properties are functionally independent. D. H. the first and second main tables are each according to the third Normalized normal.

As a result, the data sets can be stored on the storage medium of the relational database in a particularly efficient and low-memory manner. The greater the number of columns allocated to the second main table and the smaller the number of rows of this second main table, the greater the memory space savings is. However, a redundancy of property values associated with a property may still exist.

The For example, the relational database and the database management system as a functional unit in the infotainment system of a motor vehicle be integrated, the infotainment system in the motor vehicle preferably designed as an embedded system is. in principle but it is also possible that the relational database and the database management system as separate functional units formed in the infotainment system are.

In According to an advantageous embodiment of the first aspect, the database management system is designed with the help of at least one subtable a record of the first or second record type, that of a record of the second or first record type is assigned. This contributes to it in that the corresponding data records by means of at least one Subtable are quickly referenced and at the same time the property values efficiently stored on the storage medium of the relational database can be.

In a further advantageous embodiment of the first aspect is the given instruction is formed as an SQL statement. This allows one especially fast reading and / or Write access to the infotainment data in the relational database.

The Invention is characterized with respect a second aspect by a computer program product. The Computer program product includes a computer readable medium Program instructions. The program instructions are by a computer executable. Furthermore, the program instructions are designed to operate the Infotainment system according to the first Aspect of the invention.

The The invention is described below with reference to schematic drawings explained in more detail. It demonstrate:

1 a database system,

2 several original tables,

3a two main and one subtable,

3b an alternative subtable,

4 two main and two subtables.

elements same construction or function are cross-figurative with the same Reference number marked.

An infotainment system ( 1 ) comprises an infotainment unit INFO, a database management system RDBMS and a relational database RDB. The infotainment system can for example comprise a navigation unit and thus serves to find a predefined route and / or to calculate a predefined route and / or to find a predefined location and / or to determine further information. The infotainment system may additionally or alternatively but also include a music system and be designed to find, for example, predetermined pieces of music and play.

The Infotainment unit INFO, the relational database RDB and the Database management system RDBMS can also be used as software functional units be formed in the infotainment system. The infotainment system For example, an on-board computer of a motor vehicle and / or be a computer, such as a portable computer, such. B. be a laptop. The infotainment system preferably has beside at least one output unit at least one input unit, which serves information, such as a route and / or a piece of music, which are to be determined, and / or information on the basis of which Infotainment data changed, in particular, to be updated. The can Infotainment unit INFO, the relational database RDB and the database management system RDBMS integrated as a functional unit in the infotainment system or as distributed functional units.

The Infotainment unit INFO communicates with the database management system RDBMS. The database management system RDBMS comprises an instruction interface SQL_IF, an instruction calculation unit SQL_CMD_PRO, a pager PAGER, a directory ID_LIB of index structures and an operating system interface OS_IF.

The Database management system RDBMS communicates with the relational Database RDB. In the relational database RDB are the infotainment data, so z. As navigation data and / or music data stored.

The infotainment unit INFO preferably communicates with the database management system RDBMS in such a way that the infotainment unit INFO sends an instruction SQL_CMD to the database management system RDBMS. Alternatively, the statement SQL_CMD can also be represented by suitable signals, which are then translated in the database management system RDBMS into the corresponding statement SQL_CMD. virtue For example, the SQL_CMD statement is designed as an SQL statement.

The Statement Interface SQL_IF is used to verify that the SQL_CMD statement is syntactical correct is. If the SQL_CMD statement is syntactically correct, It is transferred from the statement interface SQL_IF to the statement calculation unit SQL_CMD_PRO passed.

The Statement calculation unit SQL_CMD_PRO determines depending on the statement SQL_CMD and preferably depending on at least one available index structure, which is stored in the directory ID_LIB of the index structures, preferably a software execution plan. The software execution plan is a section of the program that serves to access the infotainment data preferably efficient.

Of the Software Implementation Plan is passed from the statement calculation unit SQL_CMD_PRO to the pager PAGER. The pager Pager serves to be dependent from the software execution plan, preferably a hardware execution plan to investigate. The hardware execution plan is representative for this, as a hardware, such as a CD-ROM drive and / or a Hard disk and / or other disks containing the relational database Can include RDB, need to be controlled around the software execution plan work off.

Of the Hardware Implementation Plan is passed to the operating system interface OS_IF, which is the hardware execution plan in corresponding control signals for the technical device translates to the infotainment data are stored, and / or the storage medium includes on which the infotainment data is stored.

The Infotainment data is in the relational database RDB as records in tables stored.

In 2 a first, a second and a third original table R1, R2, R3 is shown. By means of these three tables R1, R2, R3, n to m relationships between data sets are made possible. The first original table R1 has ten data records, each data record being represented by a respective identifier value of a unique first identifier PK1. The second original table R2 has four data records which are each represented by an identifier value of a unique second identifier PK2. For example, the first record of the first original table R1 is associated with the first and second records of the second original table R2. The assignment takes place by means of the third original table R3, in which the identifier values of the unique first identifier PK1 and the associated identifier values of the unique second identifier PK2 are stored.

The first original Table R1 has the first properties A1, B1, C1, which are functionally independent voneinan are. The second original Table R2 has the second properties D2, E2, which also functionally independent from each other. The first and second original tables R1, R2 are preferably according to the third Normal form of database theory normalized.

According to a first embodiment ( 3a and 3b ) are stored in a first main table MR1 records a first record type. Each record of the first record type has the unique first identifier PK1, the first properties A1, B1, C1 and additionally a subrecognition PID. Each data record of the first data type is represented by the respective identifier value of the unique first identifier PK1. In a second main table MR2, records of a second record type are stored. Each record of the second record type has the unique second identifier PK2 and the second properties D2, E2. Each data record of the second data type is represented by the respective identifier value of the unique second identifier PK2.

The Properties of the respective records are in capital letters while property values the properties are marked in lowercase letters. one Property is associated with one column and one record each one line is assigned to the respective table.

The first properties A1, B1, C1 of the first main table MR1 functionally independent of each other and the second characteristics D2, E2 of the second main table MR2 are functionally independent from each other. Tuple of property values, each one record of the second record type and thus the second main table MR2 are each assigned only once in the second main table MR2 saved.

Furthermore, in 3a a subtable PR is shown. The sub-table PR are the sub-identifier PID and assigned to this Un recognition PID unique second identifier PK2 of the second main table MR2. By means of the sub-table PR, the assignment of the respective data record of the first record type to the respective record of the second record type and vice versa. In the sub-table PR, the unique second identifier PK2 is based on multiple assignments of identifier values of the second identifier PK2, designed as a complex data type. However, complex data types with multiple assignments are not accessible by any training of a database management system RDBMS.

Alternative to the sub table PR in 3a is also the subtable PR according to 3b usable. The latter assigns exactly one identification value of the unique second identifier PK2 to each sub-identifier value of the sub-identifier PID in one line and is therefore accessible with each configuration of a database management system RDBMS.

The sub-tag values of the additional sub-tag PID in the first main table MR1 and the sub-tag values and the tag values shown in the sub-table PR according to the 3a or according to the 3b are stored, substitute the tag values of the third original table R3 in FIG 2 , This results in the following memory space savings. The original table R3 in 2 For 17 entries with two identification values each, a memory requirement of 2 × 17 = 34 memory units is required. The additional subcode PID with 10 subrecognizable values requires a memory requirement of 10 memory units. The subtable PR according to the 3b For 6 entries with one subkey value and one tag value each, a storage requirement of 2 × 6 = 12 storage units is required. This results in a total memory requirement of 10 + 12 = 22 memory units. It is assumed that the sub-identifier PID and the unique first and second identifier PK1, PK2 as the same data types, such. B. INTEGER defined. Thus, according to the data structuring, in 3a and 3b at least a memory space saving of 10 memory units compared to the memory requirement, the data structuring according to the 2 would require.

According to a second embodiment ( 4 ), the first main table MR1 is assigned the unique first identifier PK1, the first properties A1, C1, the sub-identifier PID and an additional identifier SID. The second main table MR2 is assigned the unique second identifier PK2 and the second properties D2, E2. A respective combination of the property values, which are each assigned to a data record of the second data record type, is stored only once in the second main table MR2.

Furthermore, the subtable PR and another table SR are shown. The subtable PR is analogous to the subtable 3b educated. The further table SR comprises the property values b of the first property B1 and is thus assigned to the first main table MR1. In this case, a property value b of the first property B is only stored once in the further table SR. As a result, the property values which are assigned to the further table SR and which are assigned to the second main table MR2 can be stored particularly efficiently in the relational database RDB.

There are many examples in the field of infotainment systems to which the use of subtables can be applied. For example, the following original tables (with their respective properties in brackets)

POI (POI_ID, name, address, longitude, latitude, ...)
Category (CAT_ID, icon, parent_category, ...)
POI2Category (POI_ID, CAT_ID)

be provided from the field of navigation systems. The original table POI contains data on "places of interest", such as "places of interest". Restaurants, hotels, tourist attractions, etc.

For example, the records of the original tables may be the following main tables POI, Category and the sub-table PR

POI (POI_ID, name, address, longitude, latitude, ..., PID)
Category (CAT_ID, icon, parent_category, ...)
PR (PID, CAT_ID)

be assigned, the sub-identifier PID the two main tables referenced to each other.

a1-c1, d2, e2

property values

A1-E1

first properties

D2, E2

second properties

DC

storage medium

ID_LIB

directory Index structures

INFO

infotainment unit

MR1

first main table

MR2

second main table

OS_IF

Operating system interface

PAGER

pager

PID

under point

PK1

clear first identifier

PK2

clear second identifier

PR

under table

R1-R3

original tables

RDB

relational Database

RDBMS

Database management system

SID

additional identification

SQL_CMD

instructions

SQL_CMD_PRO

Instruction processing unit

SQL_IF

SQL interface

SR

Further table

Claims (4)

Infotainment system, which includes a relational Database (RDB) stored on a storage medium (DC), and a database management system (RDBMS) and adapted thereto is to access infotainment data stored in the relational database (RDB) as records a first record type and records of a second record type are stored, each record of the first record type an identifier value of a unique first identifier (PK1), a respective property value (a1-c1) at least one first property (A1-C1) and in each case a sub-identifier value at least one sub-identifier (PID), each record of the second record type has a sub-tag value of a unique second Identifier (PK2) and each one property value (d2, e2) at least a second property (D2, E2), wherein - one associated with the first main table (MR1), the unique first one Identifier (PK1), the at least one first property (A1-C1) and the at least one associated sub-identifier (PID), - one second main table (MR2) are assigned, the unique second Identifier (PK2) and the at least one second property (D2, E2), where tuples of property values of the second property that the are assigned to the second main table, only once each in the second main table (MR2) are stored, - in at least a sub-table (PR) are stored, the sub-tag values the at least one sub-identifier (PID) and the associated identifier value the unique second identifier (PK2). Infotainment system according to claim 1, wherein the database management system (RDBMS) is formed, with the help of at least one subtable (PR) to determine a record of the first or second record type, associated with a record of the second or first record type is. Infotainment system according to claim 1 or 2, wherein the default statement (SQL_CMD) is designed as an SQL statement is. Computer program product that is a computer readable Medium with program instructions that includes a computer executable are and which are adapted to operate an infotainment system according to one of the claims 1 to 3.