Sign In to Follow Application
View All Documents & Correspondence
View All Documents & Correspondence
Method And System For Identifying And Analyzing Hidden Data Relationships In Databases
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.
Get Free WhatsApp Updates!
Notices, Deadlines & Correspondence
Notices, Deadlines & Correspondence
Patent Information
Application #
Filing Date
29 December 2015
Publication Number
26/2017
Publication Type
INA
Invention Field
COMPUTER SCIENCE
Status
Email
Parent Application
Patent Number
Legal Status
Grant Date
2022-11-21
Renewal Date
Applicants
Cognizant Technology Solutions India Pvt. Ltd.
Techno Complex,
No. 5/535, Old Mahabalipuram Road,
Okkiyam Thoraipakkam,
Chennai 600 097, Tamil Nadu,
India
Inventors
1. Gopinath Mandala
Flat 4164, TVH Ouranya Bay,
Kazhipattur, OMR,
Chennai 603 103, Tamil Nadu,
India
2. Prasad Chand Uppuleti
DNo 54-20/9-8D/1,
Ambedkar Nagar, Srinagar Colony,
Vijayawada 520 008, Andhra Pradesh,
India
3. Bezawada Harshavardhan
DR NO: 7-15-2,
Bala Sisu Mandir, VIP Road,
Ongole 523 001, Andhra Pradesh,
India
Specification
Claims:As uploaded , Description:As uploaded
Documents
Orders
| Section | Controller | Decision Date |
|---|---|---|
Application Documents
| # | Name | Date |
|---|---|---|
| 1 | 7032-CHE-2015-IntimationOfGrant21-11-2022.pdf | 2022-11-21 |
| 1 | Form 3 [29-12-2015(online)].pdf | 2015-12-29 |
| 2 | 7032-CHE-2015-PatentCertificate21-11-2022.pdf | 2022-11-21 |
| 2 | Drawing [29-12-2015(online)].pdf | 2015-12-29 |
| 3 | Description(Complete) [29-12-2015(online)].pdf | 2015-12-29 |
| 3 | 7032-CHE-2015-Written submissions and relevant documents [11-11-2022(online)].pdf | 2022-11-11 |
| 4 | REQUEST FOR CERTIFIED COPY [08-01-2016(online)].pdf | 2016-01-08 |
| 4 | 7032-CHE-2015-Correspondence to notify the Controller [25-10-2022(online)].pdf | 2022-10-25 |
| 5 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-28-10-2022).pdf | 2022-10-06 |
| 5 | 7032-CHE-2015-Power of Attorney-110116.pdf | 2016-06-23 |
| 6 | 7032-CHE-2015-PETITION UNDER RULE 138 [24-08-2022(online)].pdf | 2022-08-24 |
| 6 | 7032-CHE-2015-Form 1-110116.pdf | 2016-06-23 |
| 7 | 7032-CHE-2015-REQUEST FOR ADJOURNMENT OF HEARING UNDER RULE 129A [24-08-2022(online)].pdf | 2022-08-24 |
| 7 | 7032-CHE-2015-Correspondence-F1-PA-110116.pdf | 2016-06-23 |
| 8 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-25-05-2022).pdf | 2022-05-13 |
| 8 | 7032-CHE-2015-Form 3-050516.pdf | 2016-07-15 |
| 9 | 7032-CHE-2015-Correspondence-F3-050516.pdf | 2016-07-15 |
| 9 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-23-02-2022).pdf | 2022-02-11 |
| 10 | 7032-CHE-2015-Correspondence to notify the Controller [10-02-2022(online)].pdf | 2022-02-10 |
| 10 | 7032-CHE-2015-FER.pdf | 2020-01-15 |
| 11 | 7032-CHE-2015-PETITION UNDER RULE 137 [26-05-2020(online)].pdf | 2020-05-26 |
| 11 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-11-02-2022).pdf | 2022-01-24 |
| 12 | 7032-CHE-2015-Correspondence to notify the Controller [14-01-2022(online)].pdf | 2022-01-14 |
| 12 | 7032-CHE-2015-Information under section 8(2) [26-05-2020(online)].pdf | 2020-05-26 |
| 13 | 7032-CHE-2015-FORM 3 [26-05-2020(online)].pdf | 2020-05-26 |
| 13 | 7032-CHE-2015-FORM-26 [14-01-2022(online)].pdf | 2022-01-14 |
| 14 | 7032-CHE-2015-FER_SER_REPLY [26-05-2020(online)].pdf | 2020-05-26 |
| 14 | 7032-CHE-2015-US(14)-HearingNotice-(HearingDate-17-01-2022).pdf | 2021-12-08 |
| 15 | 7032-CHE-2015-COMPLETE SPECIFICATION [26-05-2020(online)].pdf | 2020-05-26 |
| 15 | 7032-CHE-2015-US(14)-HearingNotice-(HearingDate-08-12-2021).pdf | 2021-10-28 |
| 16 | 7032-CHE-2015-ABSTRACT [26-05-2020(online)].pdf | 2020-05-26 |
| 16 | 7032-CHE-2015-CLAIMS [26-05-2020(online)].pdf | 2020-05-26 |
| 17 | 7032-CHE-2015-CLAIMS [26-05-2020(online)].pdf | 2020-05-26 |
| 17 | 7032-CHE-2015-ABSTRACT [26-05-2020(online)].pdf | 2020-05-26 |
| 18 | 7032-CHE-2015-COMPLETE SPECIFICATION [26-05-2020(online)].pdf | 2020-05-26 |
| 18 | 7032-CHE-2015-US(14)-HearingNotice-(HearingDate-08-12-2021).pdf | 2021-10-28 |
| 19 | 7032-CHE-2015-FER_SER_REPLY [26-05-2020(online)].pdf | 2020-05-26 |
| 19 | 7032-CHE-2015-US(14)-HearingNotice-(HearingDate-17-01-2022).pdf | 2021-12-08 |
| 20 | 7032-CHE-2015-FORM 3 [26-05-2020(online)].pdf | 2020-05-26 |
| 20 | 7032-CHE-2015-FORM-26 [14-01-2022(online)].pdf | 2022-01-14 |
| 21 | 7032-CHE-2015-Correspondence to notify the Controller [14-01-2022(online)].pdf | 2022-01-14 |
| 21 | 7032-CHE-2015-Information under section 8(2) [26-05-2020(online)].pdf | 2020-05-26 |
| 22 | 7032-CHE-2015-PETITION UNDER RULE 137 [26-05-2020(online)].pdf | 2020-05-26 |
| 22 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-11-02-2022).pdf | 2022-01-24 |
| 23 | 7032-CHE-2015-Correspondence to notify the Controller [10-02-2022(online)].pdf | 2022-02-10 |
| 23 | 7032-CHE-2015-FER.pdf | 2020-01-15 |
| 24 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-23-02-2022).pdf | 2022-02-11 |
| 24 | 7032-CHE-2015-Correspondence-F3-050516.pdf | 2016-07-15 |
| 25 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-25-05-2022).pdf | 2022-05-13 |
| 25 | 7032-CHE-2015-Form 3-050516.pdf | 2016-07-15 |
| 26 | 7032-CHE-2015-REQUEST FOR ADJOURNMENT OF HEARING UNDER RULE 129A [24-08-2022(online)].pdf | 2022-08-24 |
| 26 | 7032-CHE-2015-Correspondence-F1-PA-110116.pdf | 2016-06-23 |
| 27 | 7032-CHE-2015-PETITION UNDER RULE 138 [24-08-2022(online)].pdf | 2022-08-24 |
| 27 | 7032-CHE-2015-Form 1-110116.pdf | 2016-06-23 |
| 28 | 7032-CHE-2015-US(14)-ExtendedHearingNotice-(HearingDate-28-10-2022).pdf | 2022-10-06 |
| 28 | 7032-CHE-2015-Power of Attorney-110116.pdf | 2016-06-23 |
| 29 | REQUEST FOR CERTIFIED COPY [08-01-2016(online)].pdf | 2016-01-08 |
| 29 | 7032-CHE-2015-Correspondence to notify the Controller [25-10-2022(online)].pdf | 2022-10-25 |
| 30 | Description(Complete) [29-12-2015(online)].pdf | 2015-12-29 |
| 30 | 7032-CHE-2015-Written submissions and relevant documents [11-11-2022(online)].pdf | 2022-11-11 |
| 31 | 7032-CHE-2015-PatentCertificate21-11-2022.pdf | 2022-11-21 |
| 31 | Drawing [29-12-2015(online)].pdf | 2015-12-29 |
| 32 | 7032-CHE-2015-IntimationOfGrant21-11-2022.pdf | 2022-11-21 |
| 32 | Form 3 [29-12-2015(online)].pdf | 2015-12-29 |
Search Strategy
| 1 | 7032CHE2015_09-01-2020.pdf |