US20030131215A1 - Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database - Google Patents

Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database Download PDF

Info

Publication number
US20030131215A1
US20030131215A1 US10/043,949 US4394902A US2003131215A1 US 20030131215 A1 US20030131215 A1 US 20030131215A1 US 4394902 A US4394902 A US 4394902A US 2003131215 A1 US2003131215 A1 US 2003131215A1
Authority
US
United States
Prior art keywords
fields
field
looked
grouped
statement
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.)
Granted
Application number
US10/043,949
Other versions
US7076482B2 (en
Inventor
Matthew Bellew
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.)
Oracle International Corp
Original Assignee
WESTSIDE Corp
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
Priority claimed from US10/038,412 external-priority patent/US6988094B2/en
Assigned to WESTSIDE CORPORATION reassignment WESTSIDE CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: BELLEW, MATTHEW A.
Priority to US10/043,949 priority Critical patent/US7076482B2/en
Application filed by WESTSIDE Corp filed Critical WESTSIDE Corp
Priority to JP2003538938A priority patent/JP2005507121A/en
Priority to PCT/US2002/033859 priority patent/WO2003036519A1/en
Publication of US20030131215A1 publication Critical patent/US20030131215A1/en
Assigned to BEA SYSTEMS, INC. reassignment BEA SYSTEMS, INC. ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: WESTSIDE.COM, INC.
Publication of US7076482B2 publication Critical patent/US7076482B2/en
Application granted granted Critical
Assigned to ORACLE INTERNATIONAL CORPORATION reassignment ORACLE INTERNATIONAL CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: BEA SYSTEMS, INC.
Adjusted expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2423Interactive query statement specification based on a database schema
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99932Access augmentation or optimizing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • Y10S707/99934Query formulation, input preparation, or translation
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • Y10S707/99935Query augmenting and refining, e.g. inexact access
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99943Generating database or data structure, e.g. via user interface

Definitions

  • the present invention relates to the field of data processing. More specifically, the present invention relates to data processing techniques associated with data processing operations involving multiple tables of a relational database.
  • relational database has arguably become the most widely used database model in database management.
  • SQL Structured Query Language
  • SQL Structured Query Language
  • a software component is equipped to identify non-looked-up table fields and looked-up table fields with their rows to be grouped, and table fields having aggregate functions to be performed in their row values in a data processing statement, and in response, automatically includes with a SQL statement a subquery to create a grouped derivative table comprising the non-looked-up fields with their rows grouped and the aggregated fields with their row values aggregated, and one or more appropriate JOIN clauses joining one or more target tables from which the looked-up table fields are to be looked up with the grouped derivative table, effectively grouping the rows of the looked-up fields also.
  • the SQL statement may e.g. be an INSERT, a SELECT, an UPDATE and a DELETE statement.
  • the looked-up table fields are expressed in a multi-part form comprising a first part corresponding to a look-up table field, and a second part corresponding to a looked-up table field, concatenated to the first part using a predetermined special character.
  • a software component is equipped to automatically expand table fields available for inclusion in a data processing operation to include table fields of a target table of a look-up table field, in response to the selection of the look-up table field, and to facilitate selection of aggregate function.
  • the second aspect is practiced in conjunction with the automatic inclusion of subquery and appropriate JOIN clauses to a SQL statement of the first aspect.
  • FIG. 1 illustrates an overview of the present invention on the context of an application generator, in accordance with one embodiment
  • FIG. 2 illustrates the concepts of look-up field and looked-up field, with the looked-up field referenced using the multi-part form of the present invention
  • FIG. 3 illustrates the operational flow of the relevant aspects of the SQL generator of FIG. 1, incorporated with the support for the multi-part looked-up field of the present invention, in accordance with one embodiment
  • FIGS. 4 a - 4 c illustrate an example user interface of an example data processing operation, utilizing the multi-part looked-up field of the present invention, in accordance with one example application;
  • FIG. 5 illustrates the operational flow of the relevant aspects of the input component of FIG. 1 in support of the user input interface of FIGS. 4 a - 4 b , in accordance with one embodiment
  • FIG. 6 illustrates an internal component view of a computer system suitable for use to practice the present invention, in accordance with one embodiment.
  • the present invention includes a multi-part format for specifying a looked-up table field, and software components equipped with logic in support of the looked-up table field, making it easier for a less skillful user to access and process, or generate applications to access and process data dispersed in multiple tables of a relational database, including performance of data grouping operations.
  • the present invention will be primarily described in the context of an application generator, referencing the SQL SELECT statement.
  • the present invention is not so limited, and may be practiced with a number of other SQL statements, such as the INSERT, UPDATE or DELETE statement, and in a variety of other contexts, e.g. a database query facility.
  • various aspects of the present invention will be described, specific numbers, materials and configurations will be set forth. However, the present invention may be practiced with only some or all aspects, and/or without some of these specific details. In other instances, well-known features are omitted or simplified in order not to obscure the present invention.
  • processor includes microprocessors, micro-controllers, digital signal processors, and the like, that are standalone, adjunct or embedded.
  • application generator 102 includes in particular input component 104 associated with a data processing operation, and SQL statement generator 106 .
  • application generator 102 In accordance with inputs received from an application developer user, application generator 102 generates applications 108 . Included among applications 108 are SQL statements 110 . SQL statements 110 include Create statements for use by applications 108 to create various tables 116 having a plurality of table fields (or simply fields) to store data, inside relational database 114 , through relational database management system 112 .
  • SQL statements 110 also include SELECT statements for use by applications 108 to access created tables 116 for the stored data of the various fields (through relational database management system 112 ), including data grouping operations if applicable. As needed, SQL statements 110 may also include INSERT, UPDATE, DELETE and other statements.
  • SQL statement generator 106 is advantageously equipped to support looked-up table fields, expressed in the multi-part form of the present invention.
  • the support includes in particular the automatic generation of the appropriate subquery to create a grouped derivative table comprising non-looked-up table fields with their rows grouped and aggregated fields with their row values aggregated, and the appropriate JOIN clauses joining target tables (from which fields are to be looked up) to the basis table or the grouped derivative table (effectively grouping the looked-up table fields).
  • input component 104 of the data processing operation is advantageously equipped to present fields of a table for selection by an application developer user for inclusion in the data processing operation. Further, input component 104 is advantageously equipped to expand the list of fields available for selection to include fields of a target table, if a selected field has been previously defined to be a look-up field with the aforementioned target table. Moreover, in one embodiment, input component 104 is advantageously equipped to facilitate selection of an aggregation operation for performance on row values of a selected field.
  • the aggregation operation may be any one of a count function (COUNT), a minimum value identification function (MIN), a maximum value identification function (MAX), an average computation function (AVG), and a value summation function (SUM).
  • Data processing operation may be any data processing operation known in art.
  • An example of a data processing operation is report generation.
  • Another example of a data processing operation is execution of a series of processing operations in the form of a script file.
  • input component 104 may be a component of a report generator, a component of a script editor, or other software components of the like.
  • the second aspect is practiced in conjunction with the earlier described first aspect. That is, upon assisted an application developer user in selecting the fields, including looked-up fields and/or aggregation operations, for use in a data processing operation, SQL statements, such as SELECT, INSERT, UPDATE and DELETE statements, with appropriate subquery and JOIN clauses are generated.
  • SQL statements such as SELECT, INSERT, UPDATE and DELETE statements
  • the SQL knowledge required of an application developer user of application generator 102 is advantageously reduced, thereby enhancing the usability of generator 102 , as well as the productivity and experience of the application developer user.
  • application generator 102 represents a broad range of application generators known in the art, including in particular, known web application generators, e.g. the web application development facilities offered by Westside, Inc. of Seattle, Wash., assignee of the present invention.
  • relational database management system 112 may e.g. be the SQL Server offered by Microsoft, Inc. of Redmond, Wash., Oracle Database Management System offered by Oracle Inc of Redwood City, Calif., Database2 (DB2) offered by IBM of Armonk, N.Y. or other relational database management systems (RDBMS) of the like.
  • the multi-part looked-up table field of the present invention is expressed in two parts, a first part 222 corresponding to the look-up field in a basis table (also referred to as a foreign key of the table), and a second part corresponding to the looked-up field 224 in a target table (also referred to as a primary key of the table), concatenated to first part 222 using a special character 226 (e.g. “:”).
  • a special character 226 e.g. “:”.
  • a “customer description” field (to be looked up) may be expressed under the present invention in the form of customer_id:customer_description,
  • a “product description” field (to be looked up) may be expressed under the present invention in the form of product_id:product_description, or
  • an “employee name” field may be expressed under the present invention in the form of employee_id:employee_name.
  • the corresponding look-up field 204 (or foreign key) is a member of a “basis” table 202
  • the corresponding looked-up field 214 is a member of a “target” table 204 .
  • each table 202 or 204 may comprise other fields 206 and 216 .
  • multiple conjunctions are employed, with one conjunction, such as “:” denoting an Outer JOIN, and another conjunction such as “::” denoting an Inner JOIN.
  • additional conjunction denoting other types of joins such as a Union JOIN may also be practiced.
  • the multi-part looked-up table field of the present invention may be expressed in more than two parts, e.g. three parts, with a first part corresponding to the look-up field in a basis table, a second part corresponding to a first looked-up field in a first target table (which in turn is used as look-up field), and a third part corresponding to a second looked-up field in a second target table.
  • the different parts are concatenated to each other using a special character (e.g. “:”).
  • product_id:category_id:category_name specifying the looked-up field “category_name”, to be looked up using a look-up field “category_id”, which itself is looked up using a look-up field “product_id”.
  • FIG. 3 illustrates the operation flow of the relevant aspects of SQL statement generator 106 of FIG. 1, in the context of a data access request, in accordance with one embodiment.
  • the embodiment assumes SQL statement generator 106 receives a data access request statement in a non-SQL form as input.
  • the data access request statement has the syntax of
  • field name may be a conventional field name (e.g. user_id) or
  • a multi-part looked_up field name of the present invention e.g. user_id:username
  • an aggregation operation enumerated to be performed on row values of the field.
  • the present invention is not so limited, in other embodiments, the present invention may also be practiced with other SQL statements, such as an INSERT, an UPDATE and a DELETE statement, as well as other “request” statement syntaxes may also be practiced.
  • the substance of the request may also be communicated to SQL statement generator 106 in a non-statement form, e.g. through a function call or other techniques of parameter passing.
  • the relevant operation flow starts at operation 302 , where generator 106 parses the input statement, e.g. to tokenize the elements in the input statement. Thereafter, for the embodiment, generator 106 identifies table field or fields in the input statement, operation 304 . Further, generator 106 identifies whether the fields are “standard” (i.e. non-looked-up) table field or fields or the fields are looked-up fields, operation 306 . In one embodiment, the determination is made based on a predetermined syntax of the multi-part looked-up field. For the embodiment, generator 106 also identifies whether aggregation operations are to be performed on row values of the enumerated fields, operation 307 .
  • generator 106 parses the input statement, e.g. to tokenize the elements in the input statement. Thereafter, for the embodiment, generator 106 identifies table field or fields in the input statement, operation 304 . Further, generator 106 identifies whether the fields are “standard” (i.e. non-looked-up)
  • the remaining non-looked-up and looked-up fields are considered to be grouped, with the grouping of the non-looked-up fields differentiated from the grouping of the looked-up fields.
  • generator 106 identifies the table (also referred to earlier as the basis table) of which the “standard” or non-looked-up field or fields are members, and the tables (also referred to earlier as the target tables) from which the specified looked-up fields are to be looked up.
  • generator 106 identifies the table membership by accessing a data dictionary (not shown). In some of these embodiments, generator 106 maintains at least a work copy of the data dictionary.
  • generator 106 automatically generates a functional equivalent SQL SELECT statement, enumerating the fields to be selected, a From clause, the basis table, and where applicable, the JOIN clauses and the target tables, as well as the associated ON clauses including the condition governing the joining of the rows of the joined tables, block 312 .
  • generator 106 further automatically generates a subquery to create a grouped derivative table comprising the grouped ones of the non-looked up fields with their row values grouped and the aggregated fields with their row values aggregated.
  • the subquery itself is a SELECT statement enumerating the non-looked-up fields to be selected from the basis table, including the specified aggregation functions, for those fields to their row values aggregated, a FROM clause enumerating the basis table, and a GROUP BY clause enumerating the non-looked-up fields not specified to have aggregation operations perform on their row values.
  • the subquery together with an AS clause enumerating an identifier of the grouped derivative table replaces the basis table in the earlier mentioned FROM clause of the SQL statement. That is, instead of joining the target tables to the basis table, the JOIN clauses join the target tables to the grouped derivative table, thereby also effectively grouping the looked-up table fields.
  • FIGS. 4 a - 4 c illustrate an example user interface for selecting fields and aggregation functions for a data processing operation, including usage of the multi-part looked-up field of the present invention, in accordance with one embodiment.
  • the embodiment assumes in the course of table definition, a field may be designated as a look-up field, and each look-up field has a target table designated. Any one of a number of user interfaces and supporting logic may be practiced to facilitate such definition. The subject matter is beyond the scope of the present invention, and since it is well within the ability of those skilled in the art, such definitional facilities will not be described.
  • FIG. 4 a illustrates a first state 402 a of this user interface, wherein for a list 404 a of eligible table fields 406 a is first initially presented for an application developer user to select for inclusion in a data processing operation, which as earlier described, may e.g. be a report generation operation.
  • Fields 406 a may include in particular fields that are pre-defined look-up field 408 a .
  • selected fields 416 a are “echoed” and displayed in area 414 a.
  • FIG. 4 b illustrates a second state 402 b of this user interface, wherein upon selection of one of the look-up field 408 a , the list 404 b of eligible table fields 406 b is expanded to include table fields of the designated target table of the selected look-up field.
  • the added table fields to be looked up are advantageously displayed using the multi-part looked-up field name of the present invention, e.g. look-up_field:lookedup_field.
  • selected fields 416 b remained “echoed” and displayed in area 414 b.
  • FIG. 4 c illustrates a third state 402 c of this user interface, wherein upon denoting a desire to select an aggregation function on row values of a selected field (e.g. by right clicking on the selected field), a pop-up window 422 c enumerating a number of aggregation operations is presented for user selection to have the selected aggregation operation performed on row values of the selected field.
  • the aggregation functions include the earlier mentioned COUNT, MIN, MAX, SUM and AVE functions.
  • FIG. 5 illustrates the operational flow of the relevant aspect of input component 104 , in accordance with one embodiment.
  • input component 104 presents a first list of fields for selection by an application developer user for inclusion in a data processing operation. Then input component 104 awaits for either a user selection of one of the listed fields, a user request to select an aggregation function for a selected field or an indication of termination of operation, blocks 504 , 511 and 512 .
  • input component 104 determines if the selected field is a defined look-up field, block 506 . If the selected field is determined to be a defined look-up field, input component 104 retrieves the fields of the pre-designated target table, add the retrieved fields to the list of fields available for user selection, block 510 . Otherwise, input component 104 simply notes the field selected, and the table of which the selected field is member, block 508 .
  • input component 104 Upon receipt of a user request to specify an aggregation function for a selected field, input component 104 presents a pop-up window enumerated with a number of aggregation functions for selection by the user to specify an aggregation operation to be performed on the row values of the selected field, block 513 .
  • the collected information is subsequent provided to SQL generator 106 to automatically generate a functional equivalent SQL SELECT statement, including in particular, the appropriate subqueries, as well as JOIN and ON clauses.
  • the collected information is provided to SQL generator 106 in the syntax of the earlier described Table Select statement. In another embodiment, the collected information is provided to SQL generator 106 through a function call.
  • FIG. 6 illustrates an example computer system suitable for use to practice the present invention in accordance with one embodiment.
  • computer system 600 includes one or more processors 602 and system memory 604 .
  • computer system 600 includes mass storage devices 606 (such as diskette, hard drive, CDROM and so forth), input/output devices 608 (such as keyboard, cursor control and so forth) and communication interfaces 610 (such as network interface cards, modems and so forth).
  • the elements are coupled to each other via system bus 612 , which represents one or more buses. In the case of multiple buses, they are bridged by one or more bus bridges (not shown). Each of these elements performs its conventional functions known in the art.
  • system memory 604 and mass storage 606 are employed to store a working copy and a permanent copy of the programming instructions implementing the software components (e.g. input component 104 and/or SQL statement generator 106 ) incorporated with the teachings of the present invention.
  • the permanent copy of the programming instructions may be loaded into mass storage 606 in the factory, or in the field, as described earlier, through a distribution medium (not shown) or through communication interface 610 (from a distribution server (not shown).
  • the constitution of these elements 602 - 612 are known, and accordingly will not be further described.

Abstract

In accordance with a first aspect, a software component is equipped to identify non-looked-up table fields and looked-up table fields to be grouped, and table fields having aggregate functions to be performed in their row values in a data processing statement, and automatic inclusion with a SQL statement a subquery to generate a grouped derivative table comprising grouped non-looked-up table fields and aggregated table fields, and one or more appropriate JOIN clauses joining one or more target tables from which the table fields are to be looked up with the grouped derivative table. In one embodiment, the looked-up table fields are expressed in a multi-part form. In accordance with a second aspect, a software component is equipped to automatically expand table fields available for inclusion in a data processing operation to include table fields of a target table of a look-up table field, and selection of aggregation function.

Description

    RELATED APPLICATION
  • The present application is a continuation-in-part application of U.S. patent application Ser. No. ______, filed on Oct. 25, 2001, and entitled “Multi-Part Looked-Up Table Fields and Its Use in Data Processing Operations involving Multiple Tables of a Relational Database”.[0001]
  • BACKGROUND OF THE INVENTION
  • 1. Field of the Invention [0002]
  • The present invention relates to the field of data processing. More specifically, the present invention relates to data processing techniques associated with data processing operations involving multiple tables of a relational database. [0003]
  • 2. Background Information [0004]
  • In the course of the last two to three decades, relational database has arguably become the most widely used database model in database management. Along with the growing popularity of relational databases, the Structured Query Language (SQL) has become an indispensable tool for accessing data stored in tables of relational databases. [0005]
  • However, as those skilled in the art would appreciate, virtually all data accesses of any meaningful application would require access and processing of data resided in multiple tables. Such accesses and processing require the employment of the JOIN clause in a SQL statement (such as a SELECT, an INSERT, an UPDATE and a DELETE statement), joining tables of interest together. At times, in addition the employment of the JOIN clause, employment of a subquery is necessary for certain data grouping operations to be performed. Experience has shown that except for professional programmers experienced with SQL, few users fully understand or are totally comfortable with joining tables and/or employment of subquery. Unfortunately, the number of users having a need to access and process data dispersed in multiple tables in an unplanned manner far out number those who are skilled to comfortably do so. [0006]
  • Recently, advances in integrated circuit, microprocessor, networking and communication technologies, have resulted in the popularization of the World Wide Web (WWW) and Web based applications, making available even a greater reservoir of data for access. In turn, the knowledge or skill gap problem discussed earlier is further magnified. [0007]
  • Accordingly, an improved approach to accessing and processing data dispersed in multiple tables of relational databases, requiring lower data processing skill, is desired. [0008]
  • SUMMARY OF THE INVENTION
  • In accordance with a first aspect, a software component is equipped to identify non-looked-up table fields and looked-up table fields with their rows to be grouped, and table fields having aggregate functions to be performed in their row values in a data processing statement, and in response, automatically includes with a SQL statement a subquery to create a grouped derivative table comprising the non-looked-up fields with their rows grouped and the aggregated fields with their row values aggregated, and one or more appropriate JOIN clauses joining one or more target tables from which the looked-up table fields are to be looked up with the grouped derivative table, effectively grouping the rows of the looked-up fields also. The SQL statement may e.g. be an INSERT, a SELECT, an UPDATE and a DELETE statement. [0009]
  • In one embodiment, the looked-up table fields are expressed in a multi-part form comprising a first part corresponding to a look-up table field, and a second part corresponding to a looked-up table field, concatenated to the first part using a predetermined special character. [0010]
  • In accordance with a second aspect, a software component is equipped to automatically expand table fields available for inclusion in a data processing operation to include table fields of a target table of a look-up table field, in response to the selection of the look-up table field, and to facilitate selection of aggregate function. [0011]
  • In one embodiment, the second aspect is practiced in conjunction with the automatic inclusion of subquery and appropriate JOIN clauses to a SQL statement of the first aspect. [0012]
  • BRIEF DESCRIPTION OF DRAWINGS
  • The present invention will be described by way of exemplary embodiments, but not limitations, illustrated in the accompanying drawings in which like references denote similar elements, and in which: [0013]
  • FIG. 1 illustrates an overview of the present invention on the context of an application generator, in accordance with one embodiment; [0014]
  • FIG. 2 illustrates the concepts of look-up field and looked-up field, with the looked-up field referenced using the multi-part form of the present invention; [0015]
  • FIG. 3 illustrates the operational flow of the relevant aspects of the SQL generator of FIG. 1, incorporated with the support for the multi-part looked-up field of the present invention, in accordance with one embodiment; [0016]
  • FIGS. 4[0017] a-4 c illustrate an example user interface of an example data processing operation, utilizing the multi-part looked-up field of the present invention, in accordance with one example application;
  • FIG. 5 illustrates the operational flow of the relevant aspects of the input component of FIG. 1 in support of the user input interface of FIGS. 4[0018] a-4 b, in accordance with one embodiment; and
  • FIG. 6 illustrates an internal component view of a computer system suitable for use to practice the present invention, in accordance with one embodiment. [0019]
  • DETAILED DESCRIPTION OF THE INVENTION
  • The present invention includes a multi-part format for specifying a looked-up table field, and software components equipped with logic in support of the looked-up table field, making it easier for a less skillful user to access and process, or generate applications to access and process data dispersed in multiple tables of a relational database, including performance of data grouping operations. [0020]
  • For ease of understanding, the present invention will be primarily described in the context of an application generator, referencing the SQL SELECT statement. However, the present invention is not so limited, and may be practiced with a number of other SQL statements, such as the INSERT, UPDATE or DELETE statement, and in a variety of other contexts, e.g. a database query facility. Further, in the description to follow, various aspects of the present invention will be described, specific numbers, materials and configurations will be set forth. However, the present invention may be practiced with only some or all aspects, and/or without some of these specific details. In other instances, well-known features are omitted or simplified in order not to obscure the present invention. [0021]
  • The description will be presented in terms of operations performed by a processor based device, using terms such as statements, tables, fields, determining, identifying, generating, and the like, consistent with the manner commonly employed by those skilled in the art to convey the substance of their work to others skilled in the art. As well understood by those skilled in the art, the quantities take the form of electrical, magnetic, or optical signals capable of being stored, transferred, combined, and otherwise manipulated through mechanical, electrical and/or optical components of the processor based device. Moreover, the term processor includes microprocessors, micro-controllers, digital signal processors, and the like, that are standalone, adjunct or embedded. [0022]
  • Various operations will be described as multiple discrete steps in turn, in a manner that is most helpful in understanding the present invention, however, the order of description should not be construed as to imply that these operations are necessarily order dependent. In particular, these operations need not be performed in the order of presentation. [0023]
  • The description repeatedly uses the phrase “in one embodiment”, which ordinarily does not refer to the same embodiment, although it may. The terms “comprising”, “including”, “having”, and the like, as used in the present application, are synonymous. [0024]
  • Overview
  • Referring now to FIG. 1, wherein a block diagram illustrating an overview of the present invention in the context of an application generator incorporated with the teachings of the present invention, in accordance with one embodiment, is shown. As illustrated, [0025] application generator 102 includes in particular input component 104 associated with a data processing operation, and SQL statement generator 106. In accordance with inputs received from an application developer user, application generator 102 generates applications 108. Included among applications 108 are SQL statements 110. SQL statements 110 include Create statements for use by applications 108 to create various tables 116 having a plurality of table fields (or simply fields) to store data, inside relational database 114, through relational database management system 112. SQL statements 110 also include SELECT statements for use by applications 108 to access created tables 116 for the stored data of the various fields (through relational database management system 112), including data grouping operations if applicable. As needed, SQL statements 110 may also include INSERT, UPDATE, DELETE and other statements.
  • As will be described in more details below, in accordance with a first aspect of the present invention, SQL [0026] statement generator 106 is advantageously equipped to support looked-up table fields, expressed in the multi-part form of the present invention. The support includes in particular the automatic generation of the appropriate subquery to create a grouped derivative table comprising non-looked-up table fields with their rows grouped and aggregated fields with their row values aggregated, and the appropriate JOIN clauses joining target tables (from which fields are to be looked up) to the basis table or the grouped derivative table (effectively grouping the looked-up table fields).
  • As will be also described in more details below, in accordance with a second aspect of the present invention, input component [0027] 104 of the data processing operation is advantageously equipped to present fields of a table for selection by an application developer user for inclusion in the data processing operation. Further, input component 104 is advantageously equipped to expand the list of fields available for selection to include fields of a target table, if a selected field has been previously defined to be a look-up field with the aforementioned target table. Moreover, in one embodiment, input component 104 is advantageously equipped to facilitate selection of an aggregation operation for performance on row values of a selected field. The aggregation operation may be any one of a count function (COUNT), a minimum value identification function (MIN), a maximum value identification function (MAX), an average computation function (AVG), and a value summation function (SUM).
  • Data processing operation may be any data processing operation known in art. An example of a data processing operation is report generation. Another example of a data processing operation is execution of a series of processing operations in the form of a script file. Accordingly, input component [0028] 104, may be a component of a report generator, a component of a script editor, or other software components of the like.
  • Further, in one embodiment, the second aspect is practiced in conjunction with the earlier described first aspect. That is, upon assisted an application developer user in selecting the fields, including looked-up fields and/or aggregation operations, for use in a data processing operation, SQL statements, such as SELECT, INSERT, UPDATE and DELETE statements, with appropriate subquery and JOIN clauses are generated. [0029]
  • Accordingly, the SQL knowledge required of an application developer user of [0030] application generator 102, in particular, in the topic areas of data grouping and table joining, is advantageously reduced, thereby enhancing the usability of generator 102, as well as the productivity and experience of the application developer user.
  • Except for the teachings of the present invention incorporated with input generator [0031] 104 and SQL statement generator 106, application generator 102 represents a broad range of application generators known in the art, including in particular, known web application generators, e.g. the web application development facilities offered by Westside, Inc. of Seattle, Wash., assignee of the present invention.
  • Similarly, except of the fact that [0032] applications 108 being the beneficiary of the present invention, i.e. having selected ones of their SQL statements with their appropriate subqueries and JOIN clauses automatically generated, applications 108, relational database management system 112 and relational databases 114 all represent a wide range of these elements known in the art. In particular, relational database management system 112 may e.g. be the SQL Server offered by Microsoft, Inc. of Redmond, Wash., Oracle Database Management System offered by Oracle Inc of Redwood City, Calif., Database2 (DB2) offered by IBM of Armonk, N.Y. or other relational database management systems (RDBMS) of the like.
  • Multi-Part Looked-Up Field
  • Turning now to FIG. 2, wherein the multi-part looked-up table field of the present invention, and the relationship between the various parts to the basis and target tables, in accordance with one embodiment, is illustrated. As shown, for the embodiment, the multi-part looked-up table field of the present invention is expressed in two parts, a first part [0033] 222 corresponding to the look-up field in a basis table (also referred to as a foreign key of the table), and a second part corresponding to the looked-up field 224 in a target table (also referred to as a primary key of the table), concatenated to first part 222 using a special character 226 (e.g. “:”). For examples,
  • 1) a “customer description” field (to be looked up) may be expressed under the present invention in the form of customer_id:customer_description, [0034]
  • 2) a “product description” field (to be looked up) may be expressed under the present invention in the form of product_id:product_description, or [0035]
  • an “employee name” field (to be looked up) may be expressed under the present invention in the form of employee_id:employee_name. As alluded to earlier and illustrated, the corresponding look-up field [0036] 204 (or foreign key) is a member of a “basis” table 202, whereas the corresponding looked-up field 214 (or primary key) is a member of a “target” table 204. Of course, each table 202 or 204 may comprise other fields 206 and 216.
  • In alternate embodiments, other conventions, such as a convention involving more than two parts, may be practiced. Further, the “conjunction” may be other special characters, such as “˜”, “!”, “@”, “#”, “$”, “%”, “{circumflex over ( )}”, “&”, “*”, “|”, “<”, “>”, or “.”, using selected combinations of multiple ones of these special characters, e.g. “<>”, or even non-special characters. [0037]
  • In one embodiment, multiple conjunctions are employed, with one conjunction, such as “:” denoting an Outer JOIN, and another conjunction such as “::” denoting an Inner JOIN. In other embodiments, additional conjunction denoting other types of joins, such as a Union JOIN may also be practiced. [0038]
  • Further, in other embodiments, the multi-part looked-up table field of the present invention may be expressed in more than two parts, e.g. three parts, with a first part corresponding to the look-up field in a basis table, a second part corresponding to a first looked-up field in a first target table (which in turn is used as look-up field), and a third part corresponding to a second looked-up field in a second target table. As before, the different parts are concatenated to each other using a special character (e.g. “:”). For example, product_id:category_id:category_name, specifying the looked-up field “category_name”, to be looked up using a look-up field “category_id”, which itself is looked up using a look-up field “product_id”. [0039]
  • SQL Statement Generation
  • FIG. 3 illustrates the operation flow of the relevant aspects of [0040] SQL statement generator 106 of FIG. 1, in the context of a data access request, in accordance with one embodiment. The embodiment assumes SQL statement generator 106 receives a data access request statement in a non-SQL form as input. In one embodiment, the data access request statement has the syntax of
  • Table Select {field name [, field name [ . . . ]]}[0041]
  • where field name may be a conventional field name (e.g. user_id) or [0042]
  • a multi-part looked_up field name of the present invention (e.g. user_id:username), with or without an aggregation operation enumerated to be performed on row values of the field. [0043]
  • However, as alluded to earlier, the present invention is not so limited, in other embodiments, the present invention may also be practiced with other SQL statements, such as an INSERT, an UPDATE and a DELETE statement, as well as other “request” statement syntaxes may also be practiced. In yet other embodiments, the substance of the request may also be communicated to [0044] SQL statement generator 106 in a non-statement form, e.g. through a function call or other techniques of parameter passing.
  • As illustrated in FIG. 3, for the embodiment, the relevant operation flow starts at [0045] operation 302, where generator 106 parses the input statement, e.g. to tokenize the elements in the input statement. Thereafter, for the embodiment, generator 106 identifies table field or fields in the input statement, operation 304. Further, generator 106 identifies whether the fields are “standard” (i.e. non-looked-up) table field or fields or the fields are looked-up fields, operation 306. In one embodiment, the determination is made based on a predetermined syntax of the multi-part looked-up field. For the embodiment, generator 106 also identifies whether aggregation operations are to be performed on row values of the enumerated fields, operation 307. If at least one or more of the enumerated fields are to have their row values aggregated, the remaining non-looked-up and looked-up fields are considered to be grouped, with the grouping of the non-looked-up fields differentiated from the grouping of the looked-up fields.
  • At [0046] blocks 308 and 310, generator 106 identifies the table (also referred to earlier as the basis table) of which the “standard” or non-looked-up field or fields are members, and the tables (also referred to earlier as the target tables) from which the specified looked-up fields are to be looked up. In various embodiments, generator 106 identifies the table membership by accessing a data dictionary (not shown). In some of these embodiments, generator 106 maintains at least a work copy of the data dictionary.
  • Thereafter, upon identifying the respective tables of which the standard (non-looked-up) and looked-up fields are members, as described earlier, [0047] generator 106 automatically generates a functional equivalent SQL SELECT statement, enumerating the fields to be selected, a From clause, the basis table, and where applicable, the JOIN clauses and the target tables, as well as the associated ON clauses including the condition governing the joining of the rows of the joined tables, block 312. However, if one or more aggregation functions are specified for one or more corresponding fields, generator 106 further automatically generates a subquery to create a grouped derivative table comprising the grouped ones of the non-looked up fields with their row values grouped and the aggregated fields with their row values aggregated. The subquery itself is a SELECT statement enumerating the non-looked-up fields to be selected from the basis table, including the specified aggregation functions, for those fields to their row values aggregated, a FROM clause enumerating the basis table, and a GROUP BY clause enumerating the non-looked-up fields not specified to have aggregation operations perform on their row values. The subquery together with an AS clause enumerating an identifier of the grouped derivative table replaces the basis table in the earlier mentioned FROM clause of the SQL statement. That is, instead of joining the target tables to the basis table, the JOIN clauses join the target tables to the grouped derivative table, thereby also effectively grouping the looked-up table fields.
  • For examples, [0048]
  • (a) for the input statement Table Select {student_id, class_id:class_name, teacher_id:teacher_name,}, [0049] generator 106 generates SELECT enrollment.student_id, class.class_name, teacher.teacher_name FROM enrollment LEFT OUTER JOIN class ON enrollment.class_id=class.class_id LEFT OUTER JOIN teacher ON enrollment.teacher_id=teacher.teacher_id;
  • (b) for the input statement Table Select {order_no, product_id:product_name, product_id:category_id:category_name}, [0050] generator 106 generates SELECT order_items.order_no, products.product_name, categories.category_name FROM (order_items LEFT OUTER JOIN products ON order_items.product_id=products.product_id) LEFT OUTER JOIN categories ON products.category_id=categories.category_id (“order_items”, “products” and “categories” are the table names);
  • (c) for the input statement Table Select {task_name, assignedto:user_name, openedby:user_name} [0051] generator 106 generates SELECT tasks.task_name, users1.user_name, users2.user_name FROM tasks LEFT OUTER JOIN users users 1 ON tasks.assignedto=users1.user_id LEFT OUTER JOIN users users2 ON tasks.openedby=users2.user_id; and
  • (d) for the input statement Table Select {cust_id:cust_name, custid:cust_info, cust_id, sum(order_value)} [0052] generator 106 generates SELECT customer.cust_name, customer.cust_info, grouped_table.cust_id, grouped_table.sum_value FROM (SELECT order.cust_id, SUM(order.order_value) sum_value FROM order GROUP BY order.cust_id) AS grouped_table LEFT OUTER JOIN customer ON group_table.cust_id=customer.cust_id.
  • Field Selection
  • FIGS. 4[0053] a-4 c illustrate an example user interface for selecting fields and aggregation functions for a data processing operation, including usage of the multi-part looked-up field of the present invention, in accordance with one embodiment. The embodiment assumes in the course of table definition, a field may be designated as a look-up field, and each look-up field has a target table designated. Any one of a number of user interfaces and supporting logic may be practiced to facilitate such definition. The subject matter is beyond the scope of the present invention, and since it is well within the ability of those skilled in the art, such definitional facilities will not be described.
  • FIG. 4[0054] a illustrates a first state 402 a of this user interface, wherein for a list 404 a of eligible table fields 406 a is first initially presented for an application developer user to select for inclusion in a data processing operation, which as earlier described, may e.g. be a report generation operation. Fields 406 a may include in particular fields that are pre-defined look-up field 408 a. For the embodiments, selected fields 416 a are “echoed” and displayed in area 414 a.
  • FIG. 4[0055] b illustrates a second state 402 b of this user interface, wherein upon selection of one of the look-up field 408 a, the list 404 b of eligible table fields 406 b is expanded to include table fields of the designated target table of the selected look-up field. For the embodiment, the added table fields to be looked up are advantageously displayed using the multi-part looked-up field name of the present invention, e.g. look-up_field:lookedup_field. For the embodiment, selected fields 416 b remained “echoed” and displayed in area 414 b.
  • FIG. 4[0056] c illustrates a third state 402 c of this user interface, wherein upon denoting a desire to select an aggregation function on row values of a selected field (e.g. by right clicking on the selected field), a pop-up window 422 c enumerating a number of aggregation operations is presented for user selection to have the selected aggregation operation performed on row values of the selected field. As illustrated, for the embodiment, the aggregation functions include the earlier mentioned COUNT, MIN, MAX, SUM and AVE functions.
  • FIG. 5 illustrates the operational flow of the relevant aspect of input component [0057] 104, in accordance with one embodiment. As illustrated and alluded to earlier, initially at block 502, input component 104 presents a first list of fields for selection by an application developer user for inclusion in a data processing operation. Then input component 104 awaits for either a user selection of one of the listed fields, a user request to select an aggregation function for a selected field or an indication of termination of operation, blocks 504, 511 and 512.
  • Upon receipt of a user selection, yes branch of [0058] block 504, input component 104 determines if the selected field is a defined look-up field, block 506. If the selected field is determined to be a defined look-up field, input component 104 retrieves the fields of the pre-designated target table, add the retrieved fields to the list of fields available for user selection, block 510. Otherwise, input component 104 simply notes the field selected, and the table of which the selected field is member, block 508.
  • Upon receipt of a user request to specify an aggregation function for a selected field, input component [0059] 104 presents a pop-up window enumerated with a number of aggregation functions for selection by the user to specify an aggregation operation to be performed on the row values of the selected field, block 513.
  • In one embodiment, the collected information is subsequent provided to [0060] SQL generator 106 to automatically generate a functional equivalent SQL SELECT statement, including in particular, the appropriate subqueries, as well as JOIN and ON clauses.
  • In one embodiment, the collected information is provided to [0061] SQL generator 106 in the syntax of the earlier described Table Select statement. In another embodiment, the collected information is provided to SQL generator 106 through a function call.
  • Example Computer System
  • FIG. 6 illustrates an example computer system suitable for use to practice the present invention in accordance with one embodiment. As shown, computer system [0062] 600 includes one or more processors 602 and system memory 604. Additionally, computer system 600 includes mass storage devices 606 (such as diskette, hard drive, CDROM and so forth), input/output devices 608 (such as keyboard, cursor control and so forth) and communication interfaces 610 (such as network interface cards, modems and so forth). The elements are coupled to each other via system bus 612, which represents one or more buses. In the case of multiple buses, they are bridged by one or more bus bridges (not shown). Each of these elements performs its conventional functions known in the art. In particular, system memory 604 and mass storage 606 are employed to store a working copy and a permanent copy of the programming instructions implementing the software components (e.g. input component 104 and/or SQL statement generator 106) incorporated with the teachings of the present invention. The permanent copy of the programming instructions may be loaded into mass storage 606 in the factory, or in the field, as described earlier, through a distribution medium (not shown) or through communication interface 610 (from a distribution server (not shown). The constitution of these elements 602-612 are known, and accordingly will not be further described.
  • Conclusion and Epilog
  • Thus, an improved method and apparatus for accessing and processing data disposed in multiple tables of a relational database has been described. While the present invention has been described in terms of the above illustrated embodiments, those skilled in the art will recognize that the invention is not limited to the embodiments described. The present invention can be practiced with modification and alteration within the spirit and scope of the appended claims. For example, the multi-part looked-up field name of the present invention may be used to improve the ease of use of other SQL statements and/or clauses, such as in addition to the aforementioned INSERT, UPDATE and DELETE statements, the WHERE, GROUP BY and SORT clauses. Thus, the description is to be regarded as illustrative instead of restrictive on the present invention. [0063]

Claims (38)

What is claimed is:
1. A method comprising:
parsing a data processing statement;
identifying table field or fields referenced in said data processing statement, including whether an aggregation operation is to be performed on row values of each of the identified table fields;
for each identified table field, determining whether the table field is a looked-up field;
identifying a basis table of which non-looked up ones of said identified table field or fields are members;
identifying one or more target tables from which said looked-up one or ones of said identified table field or fields are to be looked up; and
generating a SQL statement, including with said generated SQL statement a FROM clause having a subquery creating a grouped derivative table comprising grouped non-looked-up table fields and aggregated table fields, and one or more JOIN clauses joining the corresponding one or more target tables to the grouped derivative table, if the data processing statement is determined to contain first one or more table fields to have aggregation operations performed on their row values.
2. The method of claim 1, wherein said determining of whether a table field is a looked-up field comprises determining whether the table field is a multi-part table field including at least a first part corresponding to a look-up field, and a second part corresponding to a field to be looked up, concatenated with said first part in a predetermined manner.
3. The method of claim 2, wherein said determining of whether a table field is a looked-up field further comprises upon determining that the table field is a multi-part table field, determining whether the second part is a look-up field, with a third part corresponding to a looked up field concatenated with said second part in a predetermined manner.
4. The method of claim 2, wherein said second part corresponding to a field to be looked up, is concatenated with said first part corresponding to a look-up field, employing one or more predetermined special characters.
5. The method of claim 4, wherein said conditional generating of a SQL statement, when performed, comprises generating said subquery in a form of a SELECT statement enumerating identified table fields of said basis table, including the aggegration functions to be performed on applicable ones of the identified table fields, including with said SELECT statement a first FROM clause enumerating said basis table, and a GROUP BY clause enumerating again said enumerated table field or fields of the basis table that have not been identified as having aggregation functions to be performed.
6. The method of claim 5, wherein said conditional generating of a SQL statement, when performed, further comprises enumerating field or fields to be selected from said grouped derivative table and said one or more target tables, a second FROM clause enumerating said subquery, an AS clause enumerating an identifier of the grouped derivative table, and said one or more JOIN clauses respectively joining said grouped derivative table and said one or more target tables.
7. The method of claim 1, wherein said aggregation function is a selected one of a counting function (COUNT), a minimum value identification function (MIN), a maximum value identification function (MAX), an average value computing function (AVG) and a value summation function (SUM).
8. The method of claim 1, wherein said SQL statement is a selected one of a SELECT, an INSERT, an UPDATE and a DELETE statement.
9. A method comprising:
presenting a first plurality of fields of a first table for selection for use in a data processing operation;
receiving a selection of a first field that is a member of said first fields;
determining whether said selected first field is a first designated look-up field for looking up first one or more of a second plurality of fields of a second table;
presenting said second plurality of fields for selection for use in said data processing operation, if it is determined that that said selected first field is a first designated look-up field for looking up first one or more of said second plurality of fields of said second table;
receiving a request to perform an aggregation function on a selected one of said first and second plurality of fields; and
presenting a plurality of aggregation functions for selection.
10. The method of claim 9, wherein each of said second plurality of fields is presented in a multi-part form, including a first part, said first look-up field, and a second part, a corresponding one of the second one or more fields to be looked up, concatenated with said first part in a predetermined manner.
11. The method of claim 9, wherein said method further comprises
receiving a selection of a second field that is a member of said second fields;
determining whether said selected second field is a second designated look-up field for looking up second one or more of a third plurality of fields of a third table; and
presenting said third plurality of fields for selection if it is determined that said selected second field is a second designated look-up field for looking up second one or more of said third plurality of fields of said third table.
12. The method of claim 11, wherein
each of said second plurality of fields is presented in a multi-part form, including a first part, said first look-up field, and a second part, a corresponding one of said first one or more fields to be looked up, concatenated with said first part in a predetermined manner; and
each of said third plurality of fields is presented in a multi-part form, including said first and second parts, and a third part, a corresponding one of said second one or more fields to be looked up, concatenated with said second part in a predetermined manner.
13. The method of claim 10, wherein said second part, a corresponding one of said first one or more fields to be looked up, is concatenated with said first part, said first look-up field, employing one or more predetermined special characters.
14. The method of claim 9, wherein the method further comprises generating a SQL statement, including with said generated SQL statement a FROM clause having a subquery creating a grouped derivative table comprising grouped non-looked-up fields and aggregated fields, and one or more JOIN clauses joining corresponding one or more target tables of one or more looked-up fields to the grouped derivative table, if one or more selected fields are to have aggregation operations performed on their row values.
15. The method of claim 14, wherein said conditional generating of a SQL statement, when performed, comprises generating said subquery in a form of a SELECT statement enumerating selected fields of said basis table, including the aggegration functions to be performed on applicable ones of the selected fields, including with said SELECT statement a first FROM clause enumerating said basis table, and a GROUP BY clause enumerating again said enumerated selected field or fields of the basis table that have not have aggregation functions selected for performance on their row values.
16. The method of claim 15, wherein said conditional generating of a SQL statement, when performed, further comprises enumerating selected field or fields to be selected from said grouped derivative table and said one or more target tables, a second FROM clause enumerating said subquery, an AS clause enumerating an identifier of the grouped derivative table, and said one or more JOIN clauses respectively joining said grouped derivative table and said one or more target tables.
17. The method of claim 15, wherein said aggregation function is a selected one of a counting function (COUNT), a minimum value identification function (MIN), a maximum value identification function (MAX), an average value computing function (AVG) and a value summation function (SUM).
18. The method of claim 15, wherein said SQL statement is a selected one of a SELECT, an INSERT, an UPDATE and a DELETE statement.
19. The method of claim 9, wherein the method further comprises
specifying said first plurality of fields of said first table; and
designating one or more of said specified first fields as look-up fields; and
specifying target tables for said designated look-up fields.
20. An apparatus comprising:
storage medium having stored therein programming instructions, when executed, operate the apparatus to
parse a data processing statement,
identify table field or fields referenced in said data processing statement, including whether an aggregation operation is to be performed on row values of each of the identified table fields,
determine, for each identified table field, whether the table field is a looked-up field,
identify a basis table of which non-looked up ones of said identified table field or fields are members,
identify one or more target tables from which said looked-up one or ones of said identified table field or fields are to be looked up, and
generate a SQL statement, including with said generated SQL statement a FROM clause having a subquery creating a grouped derivative table comprising grouped table fields and aggregated table fields, and one or more JOIN clauses joining the corresponding one or more target tables to the grouped derivative table, if the data processing statement is determined to contain first one or more table fields to have aggregation operations performed on their row values; and
one or more processors coupled to the storage medium to execute the programming instructions.
21. The apparatus of claim 20, wherein said programming instructions, when executed, enable the apparatus to determine whether a table field is a looked-up field by determining whether the table field is a multi-part table field including at least a first part corresponding to a look-up field, and a second part corresponding to a field to be looked up, concatenated with said first part in a predetermined manner.
22. The apparatus of claim 21, wherein said programming instructions, when executed, enable the apparatus to, upon determining that the table field is a multi-part table field, determine whether the second part is also a look-up field, with a third part corresponding to a looked up field concatenated with said second part in a predetermined manner.
23. The apparatus of claim 22, wherein said second part corresponding to a field to be looked up, is concatenated with said first part corresponding to a look-up field, employing one or more predetermined special characters.
24. The apparatus of claim 20, wherein said programming instructions, when executed, enable the apparatus to perform said conditional generating of a SQL statement by generating said subquery in a form of a SELECT statement enumerating identified table fields of said basis table, including the aggegration functions to be performed on applicable ones of the identified table fields, including with said SELECT statement a first FROM clause enumerating said basis table, and a GROUP BY clause enumerating again said enumerated table field or fields of the basis table that have not been identified as having aggregation functions to be performed.
25. The apparatus of claim 24, wherein said programming instructions, when executed, further enable the apparatus to enumerate field or fields to be selected from said grouped derivative table and said one or more target tables, a second FROM clause enumerating said subquery, an AS clause enumerating an identifier of the grouped derivative table, and said one or more JOIN clauses respectively joining said grouped derivative table and said one or more target tables, to conditionally generate said SQL statement.
26. The apparatus of claim 20, wherein said aggregation function is a selected one of a counting function (COUNT), a minimum value identification function (MIN), a maximum value identification function (MAX), an average value computing function (AVG) and a value summation function (SUM).
27. The apparatus of claim 20, wherein said SQL statement is a selected one of a SELECT, an INSERT, an UPDATE and a DELETE statement.
28. An apparatus comprising:
storage medium having stored therein a plurality of programming instructions, when executed, operate the apparatus to
present a first plurality of fields of a first table for selection for use in a data processing operation,
receive a selection of a first field that is a member of said first fields,
determine whether said selected first field is a first designated look-up field for looking up first one or more of a second plurality of fields of a second table,
present said second plurality of fields for selection for use in said data processing operation, if it is determined that that said selected first field is a first designated look-up field for looking up first one or more of said second plurality of fields of said second table,
receive a request to perform an aggregation function on a selected one of said first and second plurality of fields, and
present a plurality of aggregation functions for selection; and
at least one processor coupled to the storage medium to execute the programming instructions.
29. The apparatus of claim 28, wherein said programming instructions, when executed, operate the apparatus to present each of said second plurality of fields in a multi-part form, including a first part, said first look-up field, and a second part, a corresponding one of said first one or more fields to be looked up, concatenated with said first part in a predetermined manner.
30. The apparatus of claim 29, wherein said programming instructions, when executed, further operate the apparatus to
receive a selection of a second field that is a member of said second fields;
determine whether said selected second field is a second designated look-up field for looking up second one or more of a third plurality of fields of a third table; and
present said third plurality of fields for selection if it is determined that said selected second field is a second designated look-up field for looking up second one or more of said third plurality of fields of said third table.
31. The apparatus of claim 30, wherein said programming instructions, when executed, operate the apparatus to present
each of said second plurality of fields is presented in a multi-part form, including a first part, said first look-up field, and a second part, a corresponding one of said first one or more fields to be looked up, concatenated with said first part in a predetermined manner; and
each of said third plurality of fields is presented in a multi-part form, including said first and second parts, and a third part, a corresponding one of said second one or more fields to be looked up, concatenated with said second part in a predetermined manner.
32. The apparatus of claim 29, wherein said second part, a corresponding one of said first one or more fields to be looked up, is concatenated with said first part, said look-up field, employing one or more predetermined special characters.
33. The apparatus of claim 28, wherein said programming instructions, when executed, further enable the apparatus to generating a SQL statement, including with said generated SQL statement a FROM clause having a subquery creating a grouped derivative table comprising grouped non-looked-up fields and aggregated fields, and one or more JOIN clauses joining corresponding one or more target tables of one or more looked-up fields to the grouped derivative table, if one or more selected fields are to have aggregation operations performed on their row values
34. The apparatus of claim 33, wherein the programming instructions, when executed, enable the apparatus to perform said conditional generation of a SQL statement by generating said subquery in a form of a SELECT statement enumerating selected fields of said basis table, including the aggegration functions to be performed on applicable ones of the selected fields, including with said SELECT statement a first FROM clause enumerating said basis table, and a GROUP BY clause enumerating again said enumerated selected field or fields of the basis table that have not have aggregation functions selected for performance on their row values.
35. The apparatus of claim 34, wherein the programming instructions, when executed, enable the apparatus to enumerate selected field or fields to be selected from said grouped derivative table and said one or more target tables, a second FROM clause enumerating said subquery, an AS clause enumerating an identifier of the grouped derivative table, and said one or more JOIN clauses respectively joining said grouped derivative table and said one or more target tables.
36. The apparatus of claim 28, wherein said aggregation function is a selected one of a counting function (COUNT), a minimum value identification function (MIN), a maximum value identification function (MAX), an average value computing function (AVG) and a value summation function (SUM).
37. The apparatus of claim 28, wherein said SQL statement is a selected one of a SELECT, an INSERT, an UPDATE and a DELETE statement.
38. The apparatus of claim 28, wherein the programming instructions, when executed, further operate the apparatus to
specify said first plurality of fields of said first table,
designate one or more of said specified first fields as look-up fields, and
specify target tables for said designated look-up fields.
US10/043,949 2001-10-25 2002-01-10 Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database Expired - Lifetime US7076482B2 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
US10/043,949 US7076482B2 (en) 2001-10-25 2002-01-10 Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database
JP2003538938A JP2005507121A (en) 2001-10-25 2002-10-22 Multipart lookup table fields and their use in data processing operations involving multiple tables in relational databases
PCT/US2002/033859 WO2003036519A1 (en) 2001-10-25 2002-10-22 Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/038,412 US6988094B2 (en) 2001-10-25 2001-10-25 Multi-part looked-up table field and its use to in data processing operations involving multiple tables of a relational database
US10/043,949 US7076482B2 (en) 2001-10-25 2002-01-10 Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
US10/038,412 Continuation-In-Part US6988094B2 (en) 2001-10-25 2001-10-25 Multi-part looked-up table field and its use to in data processing operations involving multiple tables of a relational database

Publications (2)

Publication Number Publication Date
US20030131215A1 true US20030131215A1 (en) 2003-07-10
US7076482B2 US7076482B2 (en) 2006-07-11

Family

ID=26715172

Family Applications (1)

Application Number Title Priority Date Filing Date
US10/043,949 Expired - Lifetime US7076482B2 (en) 2001-10-25 2002-01-10 Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database

Country Status (3)

Country Link
US (1) US7076482B2 (en)
JP (1) JP2005507121A (en)
WO (1) WO2003036519A1 (en)

Cited By (21)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040010507A1 (en) * 2001-10-25 2004-01-15 Bellew Matthew A. Multi-part looked-up table fields and its use to in data processing operations involving multiple tables of a relational database
US20050076029A1 (en) * 2003-10-01 2005-04-07 Boaz Ben-Zvi Non-blocking distinct grouping of database entries with overflow
WO2006117626A1 (en) * 2005-04-29 2006-11-09 Springboard Retail Networks Licensing Srl Systems and methods for managing a hierarchical structure
US20060254861A1 (en) * 2005-04-29 2006-11-16 Sprn Licensing Srl Electronic shopping cart handle
US20070168875A1 (en) * 2006-01-13 2007-07-19 Kowitz Braden F Folded scrolling
US7706050B2 (en) 2004-03-05 2010-04-27 Qualcomm Mems Technologies, Inc. Integrated modulator illumination
US20110320433A1 (en) * 2010-06-25 2011-12-29 Microsoft Corporation Automated Joining of Disparate Data for Database Queries
US20120011121A1 (en) * 2010-07-07 2012-01-12 Alibaba Group Holding Limited Data analysis using multiple systems
US20150088856A1 (en) * 2013-09-20 2015-03-26 Oracle International Corporation Inferring dimensional metadata from content of a query
US9122985B2 (en) 2011-10-28 2015-09-01 Microsoft Technology Licensing, Llc Programmatic access to terminologies expressed in hierarchical form
US20160246495A1 (en) * 2012-09-07 2016-08-25 Splunk Inc. Graphically Selectable Aggregate Functions for Field Data in a Set of Machine Data
US9582585B2 (en) 2012-09-07 2017-02-28 Splunk Inc. Discovering fields to filter data returned in response to a search
US9589012B2 (en) 2012-09-07 2017-03-07 Splunk Inc. Generation of a data model applied to object queries
US9740718B2 (en) 2013-09-20 2017-08-22 Oracle International Corporation Aggregating dimensional data using dense containers
US9836519B2 (en) 2013-09-20 2017-12-05 Oracle International Corporation Densely grouping dimensional data
CN109254977A (en) * 2018-07-18 2019-01-22 深圳市买买提信息科技有限公司 Data creation method, big data air control platform and computer storage medium
CN109408541A (en) * 2018-09-03 2019-03-01 平安科技(深圳)有限公司 Report decomposes statistical method, system, computer equipment and storage medium
US10642831B2 (en) 2015-10-23 2020-05-05 Oracle International Corporation Static data caching for queries with a clause that requires multiple iterations to execute
US11086876B2 (en) 2017-09-29 2021-08-10 Oracle International Corporation Storing derived summaries on persistent memory of a storage device
CN113656430A (en) * 2021-08-12 2021-11-16 上海二三四五网络科技有限公司 Control method and device for automatic expansion of batch table data
US11222018B2 (en) 2019-09-09 2022-01-11 Oracle International Corporation Cache conscious techniques for generation of quasi-dense grouping codes of compressed columnar data in relational database systems

Families Citing this family (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8154093B2 (en) 2002-01-16 2012-04-10 Nanomix, Inc. Nano-electronic sensors for chemical and biological analytes, including capacitance and bio-membrane devices
US7522040B2 (en) 2004-04-20 2009-04-21 Nanomix, Inc. Remotely communicating, battery-powered nanostructure sensor devices
US7547931B2 (en) 2003-09-05 2009-06-16 Nanomix, Inc. Nanoelectronic capnometer adaptor including a nanoelectric sensor selectively sensitive to at least one gaseous constituent of exhaled breath
US7948041B2 (en) 2005-05-19 2011-05-24 Nanomix, Inc. Sensor having a thin-film inhibition layer
US20060129590A1 (en) * 2004-12-10 2006-06-15 Aoki-Rice Companies Method and medium for managing data
JP4632056B2 (en) * 2007-01-15 2011-02-16 日本電気株式会社 Mapping system, mapping method and program
US8131729B2 (en) * 2008-06-12 2012-03-06 International Business Machines Corporation System and method for best-fit lookup of multi-field key
US8993346B2 (en) 2009-08-07 2015-03-31 Nanomix, Inc. Magnetic carbon nanotube based biodetection

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5706494A (en) * 1995-02-10 1998-01-06 International Business Machines Corporation System and method for constraint checking bulk data in a database
US5724600A (en) * 1994-12-06 1998-03-03 Fujitsu Limited Parallel processor system
US5875447A (en) * 1996-05-30 1999-02-23 International Business Machines Corporation Reordering of complex SQL queries involving GROUPBYs, joins, outer joins and full outer joins
US6032144A (en) * 1996-05-29 2000-02-29 Lucent Technologies Inc. Optimization of queries using relational algebraic theta-semijoin operator
US6327587B1 (en) * 1998-10-05 2001-12-04 Digital Archaeology, Inc. Caching optimization with disk and/or memory cache management
US6477534B1 (en) * 1998-05-20 2002-11-05 Lucent Technologies, Inc. Method and system for generating a statistical summary of a database using a join synopsis
US6748374B1 (en) * 1998-12-07 2004-06-08 Oracle International Corporation Method for generating a relational database query statement using one or more templates corresponding to search conditions in an expression tree

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5724600A (en) * 1994-12-06 1998-03-03 Fujitsu Limited Parallel processor system
US5706494A (en) * 1995-02-10 1998-01-06 International Business Machines Corporation System and method for constraint checking bulk data in a database
US6032144A (en) * 1996-05-29 2000-02-29 Lucent Technologies Inc. Optimization of queries using relational algebraic theta-semijoin operator
US5875447A (en) * 1996-05-30 1999-02-23 International Business Machines Corporation Reordering of complex SQL queries involving GROUPBYs, joins, outer joins and full outer joins
US6477534B1 (en) * 1998-05-20 2002-11-05 Lucent Technologies, Inc. Method and system for generating a statistical summary of a database using a join synopsis
US6327587B1 (en) * 1998-10-05 2001-12-04 Digital Archaeology, Inc. Caching optimization with disk and/or memory cache management
US6748374B1 (en) * 1998-12-07 2004-06-08 Oracle International Corporation Method for generating a relational database query statement using one or more templates corresponding to search conditions in an expression tree

Cited By (48)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040010507A1 (en) * 2001-10-25 2004-01-15 Bellew Matthew A. Multi-part looked-up table fields and its use to in data processing operations involving multiple tables of a relational database
US7392359B2 (en) * 2003-10-01 2008-06-24 Hewlett-Packard Development Company, L.P. Non-blocking distinct grouping of database entries with overflow
US20050076029A1 (en) * 2003-10-01 2005-04-07 Boaz Ben-Zvi Non-blocking distinct grouping of database entries with overflow
US7706050B2 (en) 2004-03-05 2010-04-27 Qualcomm Mems Technologies, Inc. Integrated modulator illumination
US20060259373A1 (en) * 2005-04-29 2006-11-16 Sprn Licensing Srl Systems and methods for enabling and managing ordering information within a network
US8152062B2 (en) 2005-04-29 2012-04-10 Mercatus Technologies Inc. Portable information terminal mountable on shopping cart and removable memory device usable with same
US20060264120A1 (en) * 2005-04-29 2006-11-23 Sprn Licensing Srl Portable information terminal mountable on shopping cart and removable memory device usable with same
US20060265238A1 (en) * 2005-04-29 2006-11-23 Sprn Licensing Srl Systems and methods for enabling information management incorporating a personal computing device
US20060265290A1 (en) * 2005-04-29 2006-11-23 Sprn Licensing Srl Systems and methods for managing user information over a network
WO2006117626A1 (en) * 2005-04-29 2006-11-09 Springboard Retail Networks Licensing Srl Systems and methods for managing a hierarchical structure
US20060259371A1 (en) * 2005-04-29 2006-11-16 Sprn Licensing Srl Systems and methods for managing and displaying dynamic and static content
US20060254861A1 (en) * 2005-04-29 2006-11-16 Sprn Licensing Srl Electronic shopping cart handle
US7873543B2 (en) 2005-04-29 2011-01-18 Mercatus Technologies Inc. Systems and methods for managing product purchase information over a network
US7966228B2 (en) 2005-04-29 2011-06-21 Mercatus Technologies Inc. Systems and methods for enabling information management incorporating a personal computing device
US8001015B2 (en) 2005-04-29 2011-08-16 Mercatus Technologies Inc. Systems and methods for managing and displaying dynamic and static content
US8571941B2 (en) 2005-04-29 2013-10-29 Mercatus Technologies Inc. Systems and methods for managing user information over a network
US11017429B2 (en) 2005-04-29 2021-05-25 Mercatus Technologies Inc. Systems and methods for managing user information over a network
US9424589B2 (en) 2005-04-29 2016-08-23 Mercatus Technologies Inc. Systems and methods for enabling and managing ordering information within a network
US8732597B2 (en) * 2006-01-13 2014-05-20 Oracle America, Inc. Folded scrolling
US20070168875A1 (en) * 2006-01-13 2007-07-19 Kowitz Braden F Folded scrolling
US20110320433A1 (en) * 2010-06-25 2011-12-29 Microsoft Corporation Automated Joining of Disparate Data for Database Queries
US9442979B2 (en) * 2010-07-07 2016-09-13 Alibaba Group Holding Limited Data analysis using multiple systems
US20170039214A1 (en) * 2010-07-07 2017-02-09 Alibaba Group Holding Limited Data analysis using multiple systems
US20120011121A1 (en) * 2010-07-07 2012-01-12 Alibaba Group Holding Limited Data analysis using multiple systems
US9122985B2 (en) 2011-10-28 2015-09-01 Microsoft Technology Licensing, Llc Programmatic access to terminologies expressed in hierarchical form
US20170139983A1 (en) * 2012-09-07 2017-05-18 Splunk Inc. Data Model Selection and Application Based on Data Sources
US10977286B2 (en) * 2012-09-07 2021-04-13 Splunk Inc. Graphical controls for selecting criteria based on fields present in event data
US9589012B2 (en) 2012-09-07 2017-03-07 Splunk Inc. Generation of a data model applied to object queries
US11386133B1 (en) * 2012-09-07 2022-07-12 Splunk Inc. Graphical display of field values extracted from machine data
US20170140039A1 (en) * 2012-09-07 2017-05-18 Splunk Inc. Graphical display of field values extracted from machine data
US11321311B2 (en) * 2012-09-07 2022-05-03 Splunk Inc. Data model selection and application based on data sources
US9582585B2 (en) 2012-09-07 2017-02-28 Splunk Inc. Discovering fields to filter data returned in response to a search
US20160246495A1 (en) * 2012-09-07 2016-08-25 Splunk Inc. Graphically Selectable Aggregate Functions for Field Data in a Set of Machine Data
US20180322190A1 (en) * 2012-09-07 2018-11-08 Splunk Inc. Graphical controls for selecting criteria based on fields present in event data
US10169405B2 (en) * 2012-09-07 2019-01-01 Splunk Inc. Data model selection and application based on data sources
US11893010B1 (en) 2012-09-07 2024-02-06 Splunk Inc. Data model selection and application based on data sources
US11755634B2 (en) 2012-09-07 2023-09-12 Splunk Inc. Generating reports from unstructured data
US10331720B2 (en) * 2012-09-07 2019-06-25 Splunk Inc. Graphical display of field values extracted from machine data
US9740718B2 (en) 2013-09-20 2017-08-22 Oracle International Corporation Aggregating dimensional data using dense containers
US9990398B2 (en) * 2013-09-20 2018-06-05 Oracle International Corporation Inferring dimensional metadata from content of a query
US9836519B2 (en) 2013-09-20 2017-12-05 Oracle International Corporation Densely grouping dimensional data
US20150088856A1 (en) * 2013-09-20 2015-03-26 Oracle International Corporation Inferring dimensional metadata from content of a query
US10642831B2 (en) 2015-10-23 2020-05-05 Oracle International Corporation Static data caching for queries with a clause that requires multiple iterations to execute
US11086876B2 (en) 2017-09-29 2021-08-10 Oracle International Corporation Storing derived summaries on persistent memory of a storage device
CN109254977A (en) * 2018-07-18 2019-01-22 深圳市买买提信息科技有限公司 Data creation method, big data air control platform and computer storage medium
CN109408541A (en) * 2018-09-03 2019-03-01 平安科技(深圳)有限公司 Report decomposes statistical method, system, computer equipment and storage medium
US11222018B2 (en) 2019-09-09 2022-01-11 Oracle International Corporation Cache conscious techniques for generation of quasi-dense grouping codes of compressed columnar data in relational database systems
CN113656430A (en) * 2021-08-12 2021-11-16 上海二三四五网络科技有限公司 Control method and device for automatic expansion of batch table data

Also Published As

Publication number Publication date
US7076482B2 (en) 2006-07-11
WO2003036519A1 (en) 2003-05-01
JP2005507121A (en) 2005-03-10

Similar Documents

Publication Publication Date Title
US7076482B2 (en) Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database
US7451138B2 (en) Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database
US6915290B2 (en) Database query optimization apparatus and method that represents queries as graphs
US6374252B1 (en) Modeling of object-oriented database structures, translation to relational database structures, and dynamic searches thereon
US6418450B2 (en) Data warehouse programs architecture
US20060116999A1 (en) Sequential stepwise query condition building
US6996567B2 (en) Automatic generation of join graphs for relational database queries
US5761657A (en) Global optimization of correlated subqueries and exists predicates
US20040015488A1 (en) Containment hierarchy in a database system
US20040215612A1 (en) Semi-boolean arrangement, method, and system for specifying and selecting data objects to be retrieved from a collection
US7409387B2 (en) Materialized query table matching with query expansion
Stonebraker Object management in POSTGRES using procedures
US20060235867A1 (en) Map and data location provider
US20080319968A1 (en) Processing query conditions having filtered fields within a data abstraction environment
Nevarez Inside the SQL Server Query Optimizer
Fitzgerald et al. Modularizing the formal description of a database system
US7693845B2 (en) Database systems, methods and computer program products using type based selective foreign key association to represent multiple but exclusive relationships in relational databases
Stephens et al. Sams teach yourself SQL in 21 days
US20050278306A1 (en) Linked logical fields
Henrich P-OQL: an OQL-oriented query language for PCTE
US8037092B2 (en) System and method for merging manual parameters with predefined parameters
CN114443699A (en) Information query method and device, computer equipment and computer readable storage medium
US8332373B1 (en) Representing user-defined routines with defined data structures
CN112905627B (en) Data processing method, data processing device, computer equipment and storage medium
Heintz Object-oriented databases and their impact on future business database applications

Legal Events

Date Code Title Description
AS Assignment

Owner name: WESTSIDE CORPORATION, WASHINGTON

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:BELLEW, MATTHEW A.;REEL/FRAME:012470/0134

Effective date: 20020109

AS Assignment

Owner name: BEA SYSTEMS, INC., CALIFORNIA

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:WESTSIDE.COM, INC.;REEL/FRAME:015977/0731

Effective date: 20041028

STCF Information on status: patent grant

Free format text: PATENTED CASE

FEPP Fee payment procedure

Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

FPAY Fee payment

Year of fee payment: 4

AS Assignment

Owner name: ORACLE INTERNATIONAL CORPORATION, CALIFORNIA

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:BEA SYSTEMS, INC.;REEL/FRAME:025084/0470

Effective date: 20100929

FPAY Fee payment

Year of fee payment: 8

MAFP Maintenance fee payment

Free format text: PAYMENT OF MAINTENANCE FEE, 12TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1553)

Year of fee payment: 12