Method And System For Identifying And Analyzing Hidden Data Relationships In Databases

Cognizant Technology Solutions India Pvt. Ltd.
Granted App No 7032/CHE/2015 Patent 411949 Computer Science

Patent information

IP India · live record
Application number
7032/CHE/2015
Filing date
29 December 2015
Status
Granted
Legal status
Inforce
Publication number
26/2017
Publication type
INA
Invention field
Computer Science
Patent number
411949
Grant date
21 November 2022
Next renewal due
29 December 2029

Abstract

Method and system for identifying and analysing hidden relationships in application databases is provided. During a database session database query language statements (DQLS) are retrieved from log tables in application databases to analyze and identify join indicators. Join indicators represent data fields from two or more tables which are joined using values common to each data field. Based on identified join indicators, data definition language (DDL) file is generated including relationship between two or more tables. Above steps are repeated until all DQLS in log tables are analyzed. Thereafter it is ascertained if content of created DDL file is defined in database schema (DS). DS is represented in physical data models of application databases. If it is not defined in the database schema, a logical data definition language file is generated based on generated DDL file to update logical data model, which represents hidden relationships between tables in application databases.

Applicants

1
India
Cognizant Technology Solutions India Pvt. Ltd. Techno Complex, No. 5/535, Old Mahabalipuram Road, Okkiyam Thoraipakkam, Chennai 600 097, Tamil Nadu, India

Inventors

3
India
Gopinath MandalaFlat 4164, TVH Ouranya Bay, Kazhipattur, OMR, Chennai 603 103, Tamil Nadu, India
India
Prasad Chand UppuletiDNo 54-20/9-8D/1, Ambedkar Nagar, Srinagar Colony, Vijayawada 520 008, Andhra Pradesh, India
India
Bezawada HarshavardhanDR NO: 7-15-2, Bala Sisu Mandir, VIP Road, Ongole 523 001, Andhra Pradesh, India

Specification

Show full textCollapse

Claims:As uploaded , Description:As uploaded

Documents

Sign in to open
Orders
Section
Application documents
1 Form 3 [29-12-2015(online)].pdf 29 Dec 2015
2 Drawing [29-12-2015(online)].pdf 29 Dec 2015
3 Description(Complete) [29-12-2015(online)].pdf 29 Dec 2015
4 REQUEST FOR CERTIFIED COPY [08-01-2016(online)].pdf 08 Jan 2016
5 7032-CHE-2015-Power of Attorney-110116.pdf 23 Jun 2016
6 7032-CHE-2015-Form 1-110116.pdf 23 Jun 2016
7 7032-CHE-2015-Correspondence-F1-PA-110116.pdf 23 Jun 2016
8 7032-CHE-2015-Form 3-050516.pdf 15 Jul 2016
9 7032-CHE-2015-Correspondence-F3-050516.pdf 15 Jul 2016
10 7032-CHE-2015-FER.pdf 15 Jan 2020
11 7032-CHE-2015-PETITION UNDER RULE 137 [26-05-2020(online)].pdf 26 May 2020
12 7032-CHE-2015-Information under section 8(2) [26-05-2020(online)].pdf 26 May 2020
13 7032-CHE-2015-FORM 3 [26-05-2020(online)].pdf 26 May 2020
14 7032-CHE-2015-FER_SER_REPLY [26-05-2020(online)].pdf 26 May 2020
15 7032-CHE-2015-COMPLETE SPECIFICATION [26-05-2020(online)].pdf 26 May 2020
16 7032-CHE-2015-CLAIMS [26-05-2020(online)].pdf 26 May 2020
17 7032-CHE-2015-ABSTRACT [26-05-2020(online)].pdf 26 May 2020
18 7032-CHE-2015-US(14)-HearingNotice-(HearingDate-08-12-2021).pdf 28 Oct 2021
19 7032-CHE-2015-US(14)-HearingNotice-(HearingDate-17-01-2022).pdf 08 Dec 2021
20 7032-CHE-2015-FORM-26 [14-01-2022(online)].pdf 14 Jan 2022
21 7032-CHE-2015-Correspondence to notify the Controller [14-01-2022(online)].pdf 14 Jan 2022
22 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-11-02-2022).pdf 24 Jan 2022
23 7032-CHE-2015-Correspondence to notify the Controller [10-02-2022(online)].pdf 10 Feb 2022
24 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-23-02-2022).pdf 11 Feb 2022
25 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-25-05-2022).pdf 13 May 2022
26 7032-CHE-2015-REQUEST FOR ADJOURNMENT OF HEARING UNDER RULE 129A [24-08-2022(online)].pdf 24 Aug 2022
27 7032-CHE-2015-PETITION UNDER RULE 138 [24-08-2022(online)].pdf 24 Aug 2022
28 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-28-10-2022).pdf 06 Oct 2022
29 7032-CHE-2015-Correspondence to notify the Controller [25-10-2022(online)].pdf 25 Oct 2022
30 7032-CHE-2015-Written submissions and relevant documents [11-11-2022(online)].pdf 11 Nov 2022
31 7032-CHE-2015-PatentCertificate21-11-2022.pdf 21 Nov 2022
32 7032-CHE-2015-IntimationOfGrant21-11-2022.pdf 21 Nov 2022
Search strategy
17032CHE2015_09-01-2020.pdf

ERegister / renewals

Inforce
3rd Renewed 16 Feb 2023 Period 29 Dec 2017 – 29 Dec 2018 · CBR 6995 · Certificate 12112 ₹4,000
4th Renewed 16 Feb 2023 Period 29 Dec 2018 – 29 Dec 2019 · CBR 6995 · Certificate 12113 ₹4,000
5th Renewed 16 Feb 2023 Period 29 Dec 2019 – 29 Dec 2020 · CBR 6995 · Certificate 12114 ₹4,000
6th Renewed 16 Feb 2023 Period 29 Dec 2020 – 29 Dec 2021 · CBR 6995 · Certificate 12115 ₹4,000
7th Renewed 16 Feb 2023 Period 29 Dec 2021 – 29 Dec 2022 · CBR 6995 · Certificate 12116 ₹12,000
8th Renewed 16 Feb 2023 Period 29 Dec 2022 – 29 Dec 2023 · CBR 6995 · Certificate 12117 ₹12,000
9th Renewed 24 Nov 2023 Period 29 Dec 2023 – 29 Dec 2024 · CBR 54412 · Certificate 107204 ₹12,000
10th Renewed 24 Nov 2023 Period 29 Dec 2024 – 29 Dec 2025 · CBR 54412 · Certificate 107205 ₹12,000
11th Renewed 24 Nov 2023 Period 29 Dec 2025 – 29 Dec 2026 · CBR 54412 · Certificate 107206 ₹24,000
12th Renewed 24 Nov 2023 Period 29 Dec 2026 – 29 Dec 2027 · CBR 54412 · Certificate 107207 ₹24,000
13th Renewed 24 Nov 2023 Period 29 Dec 2027 – 29 Dec 2028 · CBR 54412 · Certificate 107208 ₹24,000
14th Renewed 24 Nov 2023 Period 29 Dec 2028 – 29 Dec 2029 · CBR 54412 · Certificate 107209 ₹24,000