首页>
外国专利>
METHOD AND SYSTEM FOR IDENTIFYING AND ANALYZING HIDDEN DATA RELATIONSHIPS IN DATABASES
METHOD AND SYSTEM FOR IDENTIFYING AND ANALYZING HIDDEN DATA RELATIONSHIPS IN DATABASES
展开▼
机译:数据库中隐藏数据关系的识别和分析方法及系统
展开▼
页面导航
摘要
著录项
相似文献
摘要
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.
展开▼