DESC:FIELD
The present disclosure relates to systems for data switching.
BACKGROUND
Conventionally, for transferring activities and events occurring at a source database to a destination database, it is required that both, the source database and the destination database must have a same format. For example, if the source database is working on SQL format, the destination database should also run on the SQL format, so that the compatibility between the source database and the destination database is not compromised. In case where the source database and the destination database have different formats, complicated systems, especially configured to make the events of the source database format compatible with that of the destination database, are employed. These systems are cost-intensive. Moreover, such systems are application specific and are rendered obsolete if the formats of the source database and the destination database are changed.
Hence, in order to limit the aforementioned drawbacks, there is need for a data switching system for switching data from a source database to a destination database that has a simple configuration.
OBJECTS
Some of the objects of the present disclosure, which at least one embodiment herein satisfies, are as follows:
An object of the present disclosure is to provide a data switching system that can switch data between various formats.
Another object of the present disclosure is to provide a data switching system that has a simple configuration.
Other objects and advantages of the present disclosure will be more apparent from the following description, which is not intended to limit the scope of the present disclosure.
SUMMARY
The present disclosure envisages a computer implemented data switching system that comprises a memory configured to store a set of pre-determined rules, trigger event information, and a look up table having a predefined mapping between each of a plurality of sources with each of a plurality of destinations. A processor is configured to co-operate with the memory to receive the set of pre-determined rules to generate a set of command signals based on the set of pre-determined rules and the predefined mapping. A switching unit is coupled with the processor and is configured to receive the set of command signals. The switching unit is further configured to transfer at least one activity from the plurality of sources to the plurality of destinations based on the trigger event information and the predefined mapping defined in the lookup table.
In an embodiment, the switching unit is also configured to transform a first format of the at least one activity associated with each of the plurality of sources to a second format compatible with each of the plurality of destinations based on the predefined mapping, when the first format is different from the second format.
In another embodiment, the switching unit is configured to transfer the at least one activity associated with each of the plurality of sources to each of the plurality of destinations based on the predefined mapping, when the first format is the same as the second format.
In another embodiment, the plurality of sources is selected from a group consisting of SQL database, real time database, and OPC database. Similarly, the plurality of destinations is selected from a group consisting of SQL database, real time database, OPC database. In yet another embodiment, the plurality of sources and the plurality of destinations are electronic devices.
The present disclosure envisages a method for switching data from one format to another format.
BRIEF DESCRIPTION OF THE ACCOMPANYING DRAWING
A data switching system of the present disclosure will now be described with the help of the accompanying drawing, in which:
Fig. 1 illustrates a block diagram, depicting a data switching system, in accordance with an embodiment of the present disclosure.
LIST OF REFERENCE NUMERALS USED IN THE DRAWING AND DESCRIPTION
100 – computer implemented data switching system
102 – switching unit
104A, 104B,…, 104N – plurality of sources
106A, 106B,…, 106N – plurality of destinations
108 – processor
110 – memory

DETAILED DESCRIPTION
The transfer of data (events and activities), occurring at a source database, to a destination database generally requires that both the databases have same formats. In case where the format of the source database is different than that of the destination database, complicated and costly systems are employed to make the data at the source database compatible with the destination database. Furthermore, these systems are application specific and are rendered obsolete if the formats of the source database and the destination database are changed.
The present disclosure envisages a data switching system that has a simple configuration and that is not rendered obsolete even if the formats of the source and destination databases are changed.
Fig. 1 illustrates a block diagram, depicting a computer implemented data switching system 100 (hereinafter referred to as system 100). The system 100 comprises a switching unit 102 that has multiple input ports and multiple output ports. The system 100 further comprises a plurality of sources 104A, 104B,…, 104N that is coupled with the switching unit 102 via the multiple input ports. In an embodiment, the plurality of sources 104A, 104B,…, 104N may be different databases, which include but are not limited to, SQL database, real time database, and OPC database. In another embodiment, the plurality of sources 104A, 104B,…, 104N may be different devices, which include but are not limited to batch controller, electronic devices, and real time devices. Similarly, a plurality of destinations 106A, 106B,…, 106N is coupled with the switching unit 102 via the multiple output ports. In an embodiment, the plurality of destinations 106A, 106B,…, 106N may be different databases, which include but are not limited to, SQL database, real time database, and OPC database. In another embodiment, the plurality of destinations 106A, 106B,…, 106N may be different devices, which include but are not limited to batch controller, electronic devices, and real time devices. The system 100 also includes a processor 108 that is coupled with a memory 110 and the switching unit 102. Furthermore, the processor 108 is configured to cooperate with the plurality of sources 104A, 104B,…, 104N and the plurality of destinations 106A, 106B,…, 106N.
In an embodiment, the memory 110 is configured to store a set of pre-determined rules, trigger event information, and a look up table having a predefined mapping between each of a plurality of sources104A, 104B,…, 104N with each of a plurality of destinations 106A, 106B,…, 106N. The processor 108 is configured to co-operate with the memory 110 to receive the set of pre-determined rules to generate a set of command signals based on the set of pre-determined rules and the predefined mapping. The switching unit 102 is coupled with the processor 108 and is configured to receive the set of command signals. The switching unit 102 is further configured to transfer at least one activity from the plurality of sources 104A, 104B,… 104N to the plurality of destinations 106A, 106B,… 106N based on the trigger event information and the predefined mapping defined in the lookup table.
In an embodiment, the switching unit 102 is also configured to transform a first format of the at least one activity associated with each of the plurality of sources 104A, 104B,… 104N to a second format compatible with each of the plurality of destinations 106A, 106B,… 106N based on the predefined mapping, when the first format is different from the second format.
In another embodiment, the switching unit 102 is configured to transfer the at least one activity associated with each of the plurality of sources 104A, 104B,… 104N to each of the plurality of destinations 106A, 106B,… 106N based on the predefined mapping, when the first format is the same as the second format.
The present disclosure also envisages a method 200 for switching data from one format to another format. Figure 2 illustrates a block diagrams for a method 200 of financial transaction and customer tracking, in accordance with an embodiment of the present disclosure. The method 200 may be described in the general context of computer executable instructions. Generally, computer executable instructions may include routines, programs, objects, components and modules. The method 200 may be implemented in any suitable hardware, software, firmware, or any combination thereof.
At block 202, the method 200 includes the step of storing a set of pre-determined rules, trigger event information, and a look up table having a predefined mapping between each of a plurality of sources with each of a plurality of destinations.
At block 204, the method 200 includes the step of receiving the set of pre-determined rules to generate a set of command signals based on the set of pre-determined rules and the predefined mapping.
At block 206, the method 200 includes the step of receiving the set of command signals and transferring at least one activity from the plurality of sources to the plurality of destinations based on the trigger event information and the predefined mapping defined in the lookup table.
In an embodiment, the method includes the step of transforming a first format of the at least one activity associated with each of the plurality of sources to a second format compatible with each of the plurality of destinations based on the predefined mapping, when the first format is different from the second format.
In an embodiment, the method includes the step includes transferring the at least one activity associated with each of the plurality of sources to each of the plurality of destinations based on the predefined mapping, when the first format is the same as the second format.
The operational configuration of the system 100 is now described with reference to Fig. 1. The system 100 facilitates the transfer of an event or an activity from a source database/device (plurality of sources 104A, 104B,…, 104N) to a destination database/device (plurality of destinations 106A, 106B,…, 106N) based upon a trigger event. Any event, activity, operation, or query occurring at the source database or device of any one of the sources from the plurality of sources 104A, 104B,…, 104N is monitored by the processor 108. The memory 110 includes a pre-defined set of rules defined by a user. The set of rules includes a table having the type of the source database/device, the type of the destination database/device, a trigger event, and rules defining the link between the source device/database and the destination device/database based on the trigger event. In one embodiment, the table depicting the link between the source device/database and the destination device/database based on the trigger event is as follows:
TABLE 1
Sr. No. Trigger Source Destination
1 RealTime RealTime SQL
2 RealTime RealTime OPC
3 RealTime SQL OPC
4 RealTime OPC SQL
5 SQL SQL RealTime
6 SQL SQL OPC
7 SQL OPC RealTime
8 SQL RealTime OPC
9 OPC OPC SQL
10 OPC OPC RealTime
11 OPC RealTime SQL
12 OPC SQL RealTime
13 Timer RealTime SQL
14 Timer RealTime OPC
15 Timer SQL RealTime
16 Timer SQL OPC
17 Timer OPC RealTime
18 Timer OPC SQL

In another embodiment, the link between the source device/database and the destination device/database based on the trigger event may be configurable. In still another embodiment, validation condition for trigger, source, and destination may be configurable. This provides the additional advantage of scalability and configurability, as only one switch can work for various similar conditions.
Based upon the monitored event, query, activity, or operation for a particular source database/device, the processor 108 fetches an appropriate destination from the memory 110. Further, the processor 108 provides a trigger signal to the switching unit 102 so as to connect the particular source database/device with the appropriate destination database/device. Further, the switching unit 102 is configured to convert event, query, activity, data, or operation occurring at the source database/device of the plurality of sources 104A, 104B,…, 104N into a format which is compatible with the appropriate destination database/device of the plurality of destinations 106A, 106B,…, 106N.
Thus, the system 100 facilitates the connection of a particular source database/device from the plurality of sources 104A, 104B,…,104N to a particular destination database/device form the plurality of destinations 106A, 106B,…, 106N, wherein the source database/device and the destination database/device may have different formats. The system 100 of the present disclosure has a very simple configuration and has a capability to connect databases to devices and vice versa.
The present disclosure is further illustrated herein below with the help of the following examples. The examples used herein are intended merely to facilitate an understanding of the ways in which the embodiments herein may be practiced and to further enable those skilled in the art to practice the embodiments herein. Accordingly, the examples should not be construed as limiting the scope of the disclosure.
In one working example, the card reader is coupled with a source 104A that is an SQL database. When a user swipes his/her card in the card reader, the card reader reads the details associated with the card. The details associated with the card should be validated in the SQL database. The processor 108 monitors the card swiping event and generates a trigger signal which is sent to the switching unit 102, thereby facilitating a connection of source, i.e., the SQL database to a destination which is OPC database. Further, the switching unit 102 is configured to convert the data at the source, which is in SQL format, into OPC format which is compatible with OPC database of the destination. When the switching unit 102 is triggered, SQL query pre-defined in the SQL source gets executed to perform the validation. After the execution of the query, the results are stored in defined tags of OPC database.
In another working example, a biometric scanning device is coupled with a source 104B that is an SQL database. When a user interfaces with the biometric scanning device, the details associated with the user should be validated in the SQL database of the biometric scanning device. The processor 108 monitors the event of the user interfacing with the biometric scanning device and generates a trigger signal which is sent to the switching unit 102, thereby facilitating a connection of source, i.e., the SQL database to a destination which is OPC database. Further, the switching unit 102 is configured to convert the data at the source, which is in SQL format, into OPC format which is compatible with OPC database of the destination. When the switching unit 102 is triggered, SQL query pre-defined in the SQL source gets executed to perform the validation. After the execution of the query, the results are stored in defined tags of OPC database.
In yet another working example, the source 104B is an OPC database. The OPC tag specified in the OPC database changes in response to a pre-determined input. The processor 108 is configured to monitor the changes in the OPC database and further configured to fetch the appropriate destination from the memory 110 based on the monitored source and generates a trigger signal which is sent to the switching unit 102, thereby connecting the source, i.e., OPC database to the destination which is a real time device such as a batch controller and facilitating the passing of source OPC parameters to the respective real time parameters defined in the destination. Further, the switching unit 102 is configured to convert the data at the source, which is in OPC format, into the format which is compatible with the real time device such as a batch controller.
TECHNICAL ADVANCEMENTS
The present disclosure described herein above has several technical advantages including, but not limited to, the realization of a data switching system:
• that can switch data between various formats; and
• that has a simple configuration.
The embodiments herein and the various features and advantageous details thereof are explained with reference to the non-limiting embodiments in the following description. Descriptions of well-known components and processing techniques are omitted so as to not unnecessarily obscure the embodiments herein. The examples used herein are intended merely to facilitate an understanding of ways in which the embodiments herein may be practiced and to further enable those of skill in the art to practice the embodiments herein. Accordingly, the examples should not be construed as limiting the scope of the embodiments herein.
The foregoing description of the specific embodiments will so fully reveal the general nature of the embodiments herein that others can, by applying current knowledge, readily modify and/or adapt for various applications such specific embodiments without departing from the generic concept, and, therefore, such adaptations and modifications should and are intended to be comprehended within the meaning and range of equivalents of the disclosed embodiments. It is to be understood that the phraseology or terminology employed herein is for the purpose of description and not of limitation. Therefore, while the embodiments herein have been described in terms of preferred embodiments, those skilled in the art will recognize that the embodiments herein can be practiced with modification within the spirit and scope of the embodiments as described herein.
Throughout this specification the word “comprise”, or variations such as “comprises” or “comprising”, will be understood to imply the inclusion of a stated element, integer or step, or group of elements, integers or steps, but not the exclusion of any other element, integer or step, or group of elements, integers or steps.
The use of the expression “at least” or “at least one” suggests the use of one or more elements or ingredients or quantities, as the use may be in the embodiment of the disclosure to achieve one or more of the desired objects or results.
Any discussion of documents, acts, materials, devices, articles or the like that has been included in this specification is solely for the purpose of providing a context for the disclosure. It is not to be taken as an admission that any or all of these matters form a part of the prior art base or were common general knowledge in the field relevant to the disclosure as it existed anywhere before the priority date of this application.
While considerable emphasis has been placed herein on the components and component parts of the preferred embodiments, it will be appreciated that many embodiments can be made and that many changes can be made in the preferred embodiments without departing from the principles of the disclosure. These and other changes in the preferred embodiment as well as other embodiments of the disclosure will be apparent to those skilled in the art from the disclosure herein, whereby it is to be distinctly understood that the foregoing descriptive matter is to be interpreted merely as illustrative of the disclosure and not as a limitation.

,CLAIMS:1. A computer implemented data switching system (100) comprising:
a memory (110) configured to store a set of pre-determined rules, trigger event information, and a look up table having a predefined mapping between each of a plurality of sources with each of a plurality of destinations;
a processor (108) configured to co-operate with said memory (110) to receive said set of pre-determined rules to generate a set of command signals based on said set of pre-determined rules and said predefined mapping; and
a switching unit (102) coupled with said processor (108) and configured to receive said set of command signals, said switching unit (102) further configured to transfer at least one activity from said plurality of sources (104A, 104B,… 104N) to said plurality of destinations (106A, 106B,… 106N) based on said trigger event information and said predefined mapping defined in said lookup table.
2. The system (100) as claimed in claim 1, wherein said switching unit (102) is configured to transform a first format of said at least one activity associated with each of said plurality of sources (104A, 104B,… 104N) to a second format compatible with each of said plurality of destinations (106A, 106B,… 106N) based on said predefined mapping, when said first format is different from said second format.
3. The system as claimed in claim 2, wherein said switching unit (102) is configured to transfer said at least one activity associated with each of said plurality of sources (104A, 104B,… 104N) to each of said plurality of destinations (106A, 106B,… 106N) based on said predefined mapping , when said first format is the same as said second format.
4. The system as claimed in claim 1, wherein said plurality of sources (104A, 104B,… 104N) is selected from a group consisting of SQL database, real time database, and OPC database,
5. The system as claimed in claim 1, wherein said plurality of destinations (106A, 106B,… 106N) is selected from a group consisting of SQL database, real time database, and OPC database
6. The system as claimed in claim 1, wherein said plurality of sources (104A, 104B,… 104N) and said plurality of destinations (106A, 106B,… 106N) are electronic devices.
7. A method for switching data from one format to another format, said method comprising the following steps:
storing a set of pre-determined rules, trigger event information, and a look up table having a predefined mapping between each of a plurality of sources (104A, 104B,… 104N) with each of a plurality of destinations (106A, 106B,… 106N);
receiving said set of pre-determined rules to generate a set of command signals based on said set of pre-determined rules and said predefined mapping; and
receiving said set of command signals and transferring at least one activity from said plurality of sources (104A, 104B,… 104N) to said plurality of destinations (106A, 106B,… 106N) based on said trigger event information and said predefined mapping defined in said lookup table.
8. The method as claimed in claim 7, which includes transforming a first format of said at least one activity associated with each of said plurality of sources (104A, 104B,… 104N) to a second format compatible with each of said plurality of destinations (106A, 106B,… 106N) based on said predefined mapping, when said first format is different from said second format.
9. The method as claimed in claim 7, which includes transferring said at least one activity associated with each of said plurality of sources (104A, 104B,… 104N) to each of said plurality of destinations (106A, 106B,… 106N) based on said predefined mapping, when said first format is the same as said second format.