EP1399856A1 - Procede pour regrouper des banques de donnees reparties - Google Patents

Procede pour regrouper des banques de donnees reparties

Info

Publication number
EP1399856A1
EP1399856A1 EP02743233A EP02743233A EP1399856A1 EP 1399856 A1 EP1399856 A1 EP 1399856A1 EP 02743233 A EP02743233 A EP 02743233A EP 02743233 A EP02743233 A EP 02743233A EP 1399856 A1 EP1399856 A1 EP 1399856A1
Authority
EP
European Patent Office
Prior art keywords
databases
data
exchanges
dbv2
data banks
Prior art date
Legal status (The legal status 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 status listed.)
Withdrawn
Application number
EP02743233A
Other languages
German (de)
English (en)
Inventor
Manfred Treichel
Alfred Schneider
Hermine Schmid
Karel Engelsmann
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Siemens AG
Original Assignee
Siemens AG
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 Siemens AG filed Critical Siemens AG
Priority to EP02743233A priority Critical patent/EP1399856A1/fr
Publication of EP1399856A1 publication Critical patent/EP1399856A1/fr
Withdrawn legal-status Critical Current

Links

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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Definitions

  • remote switching units RSU Remote Switching Unit
  • RSU Remote Switching Unit
  • These remote switching units RSU are not independently operating switching centers.
  • These switching units are therefore assigned to central host switching centers and controlled by them. Accordingly, databases must be present in the central host switching center, the functionality of which includes that of the databases of the previously separate switching centers.
  • This problem occurs not only when merging exchanges' databases, but also when merging databases of any real-time systems.
  • a method by which databases from real-time systems can be merged can also be used in other - non-real-time - data processing systems.
  • the object on which the present invention is based is to specify a method for merging distributed databases, which in particular solves the problems mentioned.
  • a major advantage of the method according to the invention is that the merging of distributed databases takes place automatically outside the data processing system while the normal operation of the data processing system continues. Changes to the old databases can still be made during the runtime of the merge and will be imported into the new database using a log file created during the changes.
  • This third step of the method assumes that the databases of the data processing system are locked for changes during this step. However, due to the comparatively small amount of data to be processed, the third step takes place without great time delays. During this time, the data processing system can continue to be operated on the basis of the - now frozen - old databases.
  • the operation of the data processing system remains largely undisturbed while the databases are being merged.
  • the old databases of the data processing system which is still working are only read-only during the merging of the databases - second step of the method according to the invention - so that regular operation with the old databases can continue without restrictions if the merging of the databases fails.
  • Another important advantage is that several databases can be merged by repeatedly using the method according to the invention.
  • a test run of the automatic merging can first be carried out.
  • the identifiers that are automatically assigned to name conflicts in this test run can be viewed and changed.
  • the resulting assignment list is then included in the actual merge.
  • FIG. 1 shows a schematic representation of the sequence of the method according to the invention
  • Figure 2 is a schematic representation of the possible processes when merging several databases DB V ⁇ , DB V2 into a new database DB v
  • new / Figure 3 is a schematic representation of a network configuration with two switching centers VI and V2
  • Figure 4 is a schematic representation of a network configuration with remote switching unit RSU and host switching center V.
  • the merging - migration - of two databases DB V ⁇ , DB V2 takes place with the help of an existing data extraction tool, which extracts the data from the databases DB V ⁇ , DB V2 in the form of so-called command files, and a data migration and upgrade tool DM according to the invention that from the
  • the resulting set of commands contains all relevant data from the switching centers VI, V2.
  • a list with proposed solutions is generated and, together with the results list of a planning tool, is taken into account when merging the databases DB V ⁇ , DB V2 using the data migration and upgrade tool DM according to the invention.
  • the data of the switching centers VI, V2 are changed according to certain rules if the same names or designations occur in both databases DB V ⁇ , DB V2 .
  • the same name BERLIN remains unchanged in the database DB V ⁇ of the switching center VI and is inserted from the database DB V of the switching center V2 as BERLIN% 1 into the new database DB v , aeu.
  • the changes must be made in all commands that contain the changed names or designations as parameters.
  • the routing data is changed in the following steps:
  • code points are - Exchange VI or exchange V2 - to be distinguished.
  • the merged database DB, n e is optimized, for example code points with the same code and different ORIGl values are merged to the same destination DEST.
  • the result of merging the databases DB V ⁇ , DB V2 of the switching centers VI, V2 is a uniform database DB v , new for a host switching center V with a remote switching unit RSU - FIG. 4.

Abstract

Lors du changement de génération de centraux téléphoniques, les centraux téléphoniques (V2) plus petits, plus âgés, fonctionnant jusqu'alors de manière indépendante sur la base de leur propres banques de données (DBV2) sont remplacés par des unités distantes de commutation RSU (Remote Switching Unit). Ces dernières, qui ne fonctionnent pas de manière indépendante, sont affectés à des centraux téléphoniques principaux centralisés (V), qui les gèrent et qui doivent disposer de banques de données (DBV, nouvelle) dont la fonctionnalité comprend celle des banques de données (DBV1, DBV2) des centraux téléphoniques (V1, V2) jusqu'alors séparés. Selon l'invention, les banques de données (DBV1, DBV2) sont d'abord extraites des centraux téléphoniques (V1, V2), puis regroupées à l'extérieur de ces derniers et complétées ultérieurement par de nombreuses modifications des banques de données initiales (DBV1, DBV2). Ce procédé, qui se déroule automatiquement, permet d'intégrer par ex. des données de planification, l'avantage étant que, pendant le regroupement des banques de données (DBV1, DBV2), le fonctionnement reste en grande partie intact, seule la lecture des anciennes banques de données (DBV1, DBV2) restant possible. Plusieurs banques de données peuvent être regroupées par l'application répétée dudit procédé, qui peut également être utilisé pour d'autres systèmes de traitement de données, notamment les systèmes en temps réel.
EP02743233A 2001-06-28 2002-06-19 Procede pour regrouper des banques de donnees reparties Withdrawn EP1399856A1 (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
EP02743233A EP1399856A1 (fr) 2001-06-28 2002-06-19 Procede pour regrouper des banques de donnees reparties

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
EP01115830 2001-06-28
EP01115830A EP1271349A1 (fr) 2001-06-28 2001-06-28 Méthode pour fusionner des bases de données distribuées
PCT/EP2002/006802 WO2003003246A1 (fr) 2001-06-28 2002-06-19 Procede pour regrouper des banques de donnees reparties
EP02743233A EP1399856A1 (fr) 2001-06-28 2002-06-19 Procede pour regrouper des banques de donnees reparties

Publications (1)

Publication Number Publication Date
EP1399856A1 true EP1399856A1 (fr) 2004-03-24

Family

ID=8177879

Family Applications (2)

Application Number Title Priority Date Filing Date
EP01115830A Withdrawn EP1271349A1 (fr) 2001-06-28 2001-06-28 Méthode pour fusionner des bases de données distribuées
EP02743233A Withdrawn EP1399856A1 (fr) 2001-06-28 2002-06-19 Procede pour regrouper des banques de donnees reparties

Family Applications Before (1)

Application Number Title Priority Date Filing Date
EP01115830A Withdrawn EP1271349A1 (fr) 2001-06-28 2001-06-28 Méthode pour fusionner des bases de données distribuées

Country Status (3)

Country Link
US (1) US20040143610A1 (fr)
EP (2) EP1271349A1 (fr)
WO (1) WO2003003246A1 (fr)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7283994B2 (en) * 2003-09-15 2007-10-16 Sap Ag Merging of products into a database
US7912860B2 (en) * 2007-06-25 2011-03-22 Microsoft Corporation Strongly typed tags
CN105573805A (zh) * 2015-12-28 2016-05-11 上海电信工程有限公司 一种模块数据创建方法及系统

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2167790A1 (fr) * 1995-01-23 1996-07-24 Donald S. Maier Systeme informatique a base de donnees relationnelles a grande disponibilite des donnees durant la restructuration des donnees des tables
JP2002511164A (ja) * 1997-02-26 2002-04-09 シーベル システムズ，インコーポレイティド 単純化された可視度ルールに用いるための複数のデータベース・トランザクションのリモート・データベース・クライアントの可視度決定方法
US6240441B1 (en) * 1997-03-31 2001-05-29 Sun Microsystems, Inc. Secure event-driven EDI transaction processing using the internet
JP2001297026A (ja) * 2000-04-11 2001-10-26 Hitachi Ltd 複数のデータベースマネージメントシステムを有する計算機システム

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See references of WO03003246A1 *

Also Published As

Publication number Publication date
US20040143610A1 (en) 2004-07-22
WO2003003246A1 (fr) 2003-01-09
EP1271349A1 (fr) 2003-01-02

Similar Documents

Publication Publication Date Title
EP1309920B1 (fr) Procede d'adressage pour au moins un dispositif de bus nouvellement raccorde a un systeme de bus
EP1430369B1 (fr) Acces dynamique a des ressources d'automatisation
DE69821243T2 (de) Rekonfigurierung eines zellularen telefonnetzes
EP1638028A2 (fr) Génération assistée par ordinateur et gestion de changement pour interfaces utilisateur
DE3111555C2 (de) Verfahren und Vorrichtung zur Informationsspeicherung unter Anwendung früherer Aufzeichnung
DE19818823A1 (de) Verfahren zum Komprimieren eines Rufnummern-Datenbestands einer Telekommunikationsanlage und entsprechende Telekommunikationsanlage
EP0642067A1 (fr) Système de programmation orientée dialogue pour une machine-outil à CNC
WO2003003246A1 (fr) Procede pour regrouper des banques de donnees reparties
DE102018128696A1 (de) Programmvergleichsvorrichtung und Programmvergleichsverfahren
EP1402353A2 (fr) Outil logiciel permettant la formulation d'une tache d'automatisation a resoudre
EP0770946B1 (fr) Procédé pour concevoir automatiquement la redondance optimale pour des mesures dans le système de controle des centrales électriques
EP1248430B1 (fr) Méthode et dispositif de génération de masques filtrants pour vérifier l'importance de caractéristiques
EP1480092A2 (fr) Procédé pour la conception d'un système d'automatisation
DE4427913C2 (de) Verfahren zum Versenden eines Datensatzes in einem Terminalnetz
DE60011341T2 (de) Verfahren und System zur Übertragung von Informationen in einem Fernsprechvermittlungssystem
DE60202858T2 (de) Installation von softwareanwendungen in einem endgerät
DE19957107B4 (de) Verfahren zur Gewährleistung des Datenaustauschs zwischen mehreren Einrichtungen
DE4230178B4 (de) Verfahren zum automatischen Bestimmen der Reihenfolge der Signalbearbeitung in einem sequentiell arbeitenden Bausteinsystem
DE10313589A1 (de) Verfahren und Vorrichtung zum Modifizieren von modular aufgebauten Nachrichten
DE10202851A1 (de) Verfahren zur Adresszuweisung in einem Netzwerk und Komponenten dafür
DE19525423A1 (de) Anordnung mit Automatisierungsgeräten
EP1271348A1 (fr) Procédé pour la transformation online de données de masse
EP1785798A2 (fr) Procédé et dispositif destinés à la mise en réseau d'une installation de production
WO2005045539A1 (fr) Plateforme de donnees servant a construire des installations de production
WO2007137531A1 (fr) Procédé permettant de faire fonctionner un appareil d'automatisation, et programme informatique correspondant, programme informatique et appareil d'automatisation associé

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20031114

AK Designated contracting states

Kind code of ref document: A1

Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LI LU MC NL PT SE TR

17Q First examination report despatched

Effective date: 20041119

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION IS DEEMED TO BE WITHDRAWN

18D Application deemed to be withdrawn

Effective date: 20070103