US20080033977A1 - Script generating system and method - Google Patents
Script generating system and method Download PDFInfo
- Publication number
- US20080033977A1 US20080033977A1 US11/870,857 US87085707A US2008033977A1 US 20080033977 A1 US20080033977 A1 US 20080033977A1 US 87085707 A US87085707 A US 87085707A US 2008033977 A1 US2008033977 A1 US 2008033977A1
- Authority
- US
- United States
- Prior art keywords
- template
- procedure
- management system
- database management
- structure information
- 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.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
- G06F9/45508—Runtime interpretation or emulation, e g. emulator loops, bytecode interpretation
Definitions
- the present disclosure relates generally to a script generating system and method.
- a script language is a simple programming language with which a programmer can write scripts. Examples thereof include BASIC, C, C++, COBOL, FORTRAN, ADA, and PASCAL. Each language has a unique set of key words (words that it particularly understands) and a special syntax organizing program instructions.
- a script generator generates either a complete computer program written in a prescribed programming language or a portion thereof.
- a programmer would start a project by either reusing some previous code that was similar to the current project request or by going to a repository of standard templates. The programmer then proceeds with the time consuming task of replacing mirrored code with new variables. A single project may take a programmer hours or even days to complete, depending on how much rework must be done on the acquired code.
- the present invention provides a method for automating system administration operations for use as a script generator.
- the present invention also provides a system for implementing the script generator.
- a script generating system includes a data dictionary adapted to include table structure data.
- a database management system runs a script generator, which includes a plurality of user defined templates. Activation of the script generator utilizes built-in macros within the database management system and extracts the table structure data. Responsively, one of the templates manipulates the table structure data to generate a script.
- a method for generating a script includes running a built-in macro for RDBMS architecture dictionary retrieval, and extracting table structure data from a RDBMS architecture dictionary.
- the table structure data is then converted into an alternate programming language file layout and arranged within a predefined template.
- a script is generated from the predefined template.
- One advantage of the present invention is that it takes the manual effort of script building, maintenance of database structures and automates it.
- a further advantage is that the present invention allows programmers to build personalized collections of local templates. Additional advantages and features of the present invention will become apparent from the description that follows and may be realized by the instrumentalities and combinations particularly pointed out in the appended claims, taken in conjunction with the accompanying drawings.
- FIG. 1 is a schematic view of the script generator for automating system administration operations in accordance with one embodiment of the present invention.
- FIG. 2 is a logic flow diagram of a method for automating system administration operations in accordance with another embodiment of the present invention.
- the present invention is illustrated with respect to a script generator for automating system administration operations particularly suited to data management.
- the present invention is, however, applicable to various other uses that may require system administration operations, as will be understood by one skilled in the art.
- a system for automating system administration operations including a script generator 12 , is illustrated in accordance with one embodiment of the present invention.
- the system 10 also includes a host server 14 , a database 24 , a remote server 18 , and a database generator 26 , all of which are electrically coupled together.
- the host server 14 may include the database 16 , the script generator 12 , and the database generator 26 , or alternately the host server 14 may be a remote unit from any or all of the aforementioned components.
- the script generator 12 may be included within the server 14 or alternately included in a separate unit.
- the script generator 12 includes a number of templates 22 .
- the script generator 12 is designed such that the templates 22 may be edited, deleted, or stored in a different of permanent storage unit,
- the script generator 12 ideally runs on a relational database management system (RDBMS) or database management system (DBMS), and may incorporate data architectures, such as Teradata.
- RDBMS relational database management system
- DBMS database management system
- the script generator 12 includes Teradata in one embodiment of the present invention.
- Teradata is a database management system (DBMS) created by NCR Corporation. It includes both custom hardware and custom software.
- DBMS database management system
- a Teradata DBMS is useful because it can handle more than 1 terabyte of data, which is why it is used a lot in very large scale data warehousing applications.
- Teradata is a parallel architecture used to efficiently store, retrieve, and process large volumes of data.
- the script generator 12 may include a DBMS, which is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users.
- DBMS a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users.
- Typical examples of DBMS uses include: accounting, human resources, and customer support systems.
- An alternate embodiment of the present invention includes an RDB MS, which is a type of DBMS that stores data in the form of related tables.
- the templates 22 are stored within the script generator 12 .
- Examples of the templates 22 include an auto load feature to auto load a specific file, a create duplicate copy from a dictionary table layout to generate a backup copy for editing of either the original or the duplicate, a multi-load delete to include a delete that works off a separate file whereby a parallel connection between the two files can result in a parallel deletion of data within the files, a template for collecting statistics on columns and upfront optimizations, a template with a syntax that purges data from a table or other template thereby allowing two templates to link together, a template including the secondary index that allows storing of data on a table or removing data on a table for a separate fast load procedure then reincorporating the data, a template to replace or update the template with a new template, and a template to clean or filter out data.
- numerous other templates may be designed and incorporated in a system embodied herein.
- These templates 22 generate error-free scripts for an infinite number of table structures by incorporating and manipulating dictionary information from the dictionary 20 .
- the script generator 12 also allows users at remote servers 18 to download the templates 22 and generate new templates or user-defined templates using predefined variables, such as the ones used in the templates 22 .
- the templates 22 may also call other templates into the templates 22 as variables, thereby allowing the user to quickly assemble repetitive, complex script logic solely from dictionary information.
- the database dictionary 20 which may be a Teradata data dictionary, as most other RDBMS architectures are, holds information regarding table structures (i.e. column names, data types, formatting, default values, primary index, secondary index, column statistics, views, etc.). By utilizing built-in macros for dictionary retrieval, dictionary information can be obtained instantly on all table structures. Once retrieved, this dictionary information is then manipulated using the aforementioned predefined templates 22 to generate error-free scripts 16 .
- the remote server 18 receives information from the database 24 , and a user applies the database information to various programs, such as inventory reports.
- the user designs templates on the remote server 18 and extracts dictionary information for use in the templates.
- the remote server 18 may include an alternate script generator or may be linked to the script generator 12 .
- Logic starts in operation block 102 where a programmer creates templates 22 using information from the database dictionary 20 .
- either the programmer or a user at a remote server 18 chooses the database type with which to run one of the templates 22 .
- operation block 106 the desired procedure is selected, and various templates 22 for implementing the procedure are incorporated within the procedure script.
- the procedure is displayed in its entirety.
- the procedure is FTP (file transfer protocol) to various systems requiring the procedure or aspects of the procedure.
- the procedure is run on either the server 14 or a remote server 18 .
- the method for generating a script 16 includes running a built-in macro for RDBMS architecture dictionary retrieval, and extracting table structure data from a RDBMS architecture dictionary 20 .
- the table structure data is then converted into an alternate programming language file layout, such as COBOL, and arranged within a predefined template 22 .
- a script is generated from the predefined template 22 .
Abstract
A method includes receiving data from a user indicating a selection of a procedure, automatically selecting at least one template to implement the procedure, and extracting table structure information related to the procedure from a database management system dictionary. The method further includes manipulating the table structure information and automatically incorporating the manipulated table structure information into the at least one template to generate a modified template.
Description
- The present application is a continuation of and claims priority to U.S. patent application Ser. No. 10/458,466, filed Jun. 10, 2003, the contents of which are incorporated by reference in their entirety.
- The present disclosure relates generally to a script generating system and method.
- As is well known, computer scripts, also referred to as macros or batch files, are lists of commands that can be executed without user interaction. A script language is a simple programming language with which a programmer can write scripts. Examples thereof include BASIC, C, C++, COBOL, FORTRAN, ADA, and PASCAL. Each language has a unique set of key words (words that it particularly understands) and a special syntax organizing program instructions. A script generator generates either a complete computer program written in a prescribed programming language or a portion thereof.
- Previously, to avoid writing a complete program or a complete script, a programmer would start a project by either reusing some previous code that was similar to the current project request or by going to a repository of standard templates. The programmer then proceeds with the time consuming task of replacing mirrored code with new variables. A single project may take a programmer hours or even days to complete, depending on how much rework must be done on the acquired code.
- The disadvantages associated with current script generating techniques have made it apparent that a new technique to generate scripts in such a manner to reduce required user input or reworking of previously written code is desirable. The new technique should facilitate the writing of code by automatically updating old or previously used code.
- The present invention provides a method for automating system administration operations for use as a script generator. The present invention also provides a system for implementing the script generator.
- In accordance with one aspect of the present invention, a script generating system includes a data dictionary adapted to include table structure data. A database management system runs a script generator, which includes a plurality of user defined templates. Activation of the script generator utilizes built-in macros within the database management system and extracts the table structure data. Responsively, one of the templates manipulates the table structure data to generate a script.
- In accordance with another aspect of the present invention, a method for generating a script includes running a built-in macro for RDBMS architecture dictionary retrieval, and extracting table structure data from a RDBMS architecture dictionary. The table structure data is then converted into an alternate programming language file layout and arranged within a predefined template. Ultimately, a script is generated from the predefined template.
- One advantage of the present invention is that it takes the manual effort of script building, maintenance of database structures and automates it. A further advantage is that the present invention allows programmers to build personalized collections of local templates. Additional advantages and features of the present invention will become apparent from the description that follows and may be realized by the instrumentalities and combinations particularly pointed out in the appended claims, taken in conjunction with the accompanying drawings.
- For a more complete understanding of the present invention, reference will now be made to the embodiments illustrated in greater detail in the accompanying figures and described below by way of examples of the invention wherein:
-
FIG. 1 is a schematic view of the script generator for automating system administration operations in accordance with one embodiment of the present invention; and -
FIG. 2 is a logic flow diagram of a method for automating system administration operations in accordance with another embodiment of the present invention. - The present invention is illustrated with respect to a script generator for automating system administration operations particularly suited to data management. The present invention is, however, applicable to various other uses that may require system administration operations, as will be understood by one skilled in the art.
- Referring to
FIG. 1 , a system for automating system administration operations (script generating system 10), including ascript generator 12, is illustrated in accordance with one embodiment of the present invention. Thesystem 10 also includes ahost server 14, adatabase 24, aremote server 18, and adatabase generator 26, all of which are electrically coupled together. - The
host server 14 may include thedatabase 16, thescript generator 12, and thedatabase generator 26, or alternately thehost server 14 may be a remote unit from any or all of the aforementioned components. - The
script generator 12 may be included within theserver 14 or alternately included in a separate unit. Thescript generator 12 includes a number oftemplates 22. Thescript generator 12 is designed such that thetemplates 22 may be edited, deleted, or stored in a different of permanent storage unit, Thescript generator 12 ideally runs on a relational database management system (RDBMS) or database management system (DBMS), and may incorporate data architectures, such as Teradata. - The
script generator 12 includes Teradata in one embodiment of the present invention. Teradata is a database management system (DBMS) created by NCR Corporation. It includes both custom hardware and custom software. A Teradata DBMS is useful because it can handle more than 1 terabyte of data, which is why it is used a lot in very large scale data warehousing applications. Essentially, Teradata is a parallel architecture used to efficiently store, retrieve, and process large volumes of data. - The
script generator 12 may include a DBMS, which is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users. Typical examples of DBMS uses include: accounting, human resources, and customer support systems. An alternate embodiment of the present invention includes an RDB MS, which is a type of DBMS that stores data in the form of related tables. - The
templates 22 are stored within thescript generator 12. Examples of thetemplates 22 include an auto load feature to auto load a specific file, a create duplicate copy from a dictionary table layout to generate a backup copy for editing of either the original or the duplicate, a multi-load delete to include a delete that works off a separate file whereby a parallel connection between the two files can result in a parallel deletion of data within the files, a template for collecting statistics on columns and upfront optimizations, a template with a syntax that purges data from a table or other template thereby allowing two templates to link together, a template including the secondary index that allows storing of data on a table or removing data on a table for a separate fast load procedure then reincorporating the data, a template to replace or update the template with a new template, and a template to clean or filter out data. Important to note is that numerous other templates may be designed and incorporated in a system embodied herein. - These
templates 22 generate error-free scripts for an infinite number of table structures by incorporating and manipulating dictionary information from thedictionary 20. Thescript generator 12 also allows users atremote servers 18 to download thetemplates 22 and generate new templates or user-defined templates using predefined variables, such as the ones used in thetemplates 22. Thetemplates 22 may also call other templates into thetemplates 22 as variables, thereby allowing the user to quickly assemble repetitive, complex script logic solely from dictionary information. - The
database dictionary 20, which may be a Teradata data dictionary, as most other RDBMS architectures are, holds information regarding table structures (i.e. column names, data types, formatting, default values, primary index, secondary index, column statistics, views, etc.). By utilizing built-in macros for dictionary retrieval, dictionary information can be obtained instantly on all table structures. Once retrieved, this dictionary information is then manipulated using the aforementionedpredefined templates 22 to generate error-free scripts 16. - In one embodiment of the present invention, the
remote server 18 receives information from thedatabase 24, and a user applies the database information to various programs, such as inventory reports. In an alternate embodiment, the user designs templates on theremote server 18 and extracts dictionary information for use in the templates. Theremote server 18 may include an alternate script generator or may be linked to thescript generator 12. - Referring to
FIG. 2 , a logic flow diagram of amethod 100 for automating system administration operations is illustrated. Logic starts inoperation block 102 where a programmer createstemplates 22 using information from thedatabase dictionary 20. - In
operation block 104, either the programmer or a user at aremote server 18 chooses the database type with which to run one of thetemplates 22. Inoperation block 106, the desired procedure is selected, andvarious templates 22 for implementing the procedure are incorporated within the procedure script. - In
operation block 108, the procedure is displayed in its entirety. Inoperation block 110, the procedure is FTP (file transfer protocol) to various systems requiring the procedure or aspects of the procedure. Inoperation 112, the procedure is run on either theserver 14 or aremote server 18. - In operation, the method for generating a
script 16 includes running a built-in macro for RDBMS architecture dictionary retrieval, and extracting table structure data from aRDBMS architecture dictionary 20. The table structure data is then converted into an alternate programming language file layout, such as COBOL, and arranged within apredefined template 22. Ultimately, a script is generated from thepredefined template 22. - From the foregoing, it can be seen that there has been brought to the art a new
script generating system 10. It is to be understood that the preceding descriptions of various embodiments are merely illustrative of some of the many specific embodiments that represent applications of the principles of the present invention. Numerous and other arrangements would be evident to those skilled in the art without departing from the scope of the invention as defined by the following claims.
Claims (20)
1. A method comprising:
receiving data from a user indicating a selection of a procedure;
automatically selecting at least one template to implement the procedure;
extracting table structure information related to the procedure from a database management system dictionary;
manipulating the table structure information; and
automatically incorporating the manipulated table structure information into the at least one template to generate a modified template.
2. The method of claim 1 , further comprising creating the at least one template.
3. The method of claim 1 , further comprising selecting a database type that includes the database management system dictionary.
4. The method of claim 1 , wherein the table structure information is extracted from the database management system dictionary via at least one macro,
5. The system of claim 4 , wherein the at least one macro retrieves the database management system dictionary from a database management system (DBMS).
6. The system of claim 5 , wherein the database management system is a relational database management system (RDBMS).
7. The system of claim 5 , wherein the database management system is a Teradata database management system.
8. The method of claim 1 , further comprising automatically generating a script to implement the procedure, wherein the script calls a first template of the at least one template as a variable into a second template of the at least one template.
9. The method of claim 1 , wherein the database management system dictionary is associated with a database management system, and wherein the database management system has a parallel architecture.
10. The method of claim 1 , further comprising generating a procedure script to implement the procedure, wherein the procedure script includes the modified template.
11. The method of claim 10 , further comprising displaying the procedure script.
12. The method of claim 10 , further comprising transmitting the procedure script via a file transfer protocol (FTP) to a destination.
13. The method of claim 1 , further comprising converting the table structure information into an alternate programming language file layout prior to incorporating the manipulated table structure information into the at least one template.
14. The method of claim 13 , wherein the alternate programming language file layout is compatible with the Common Business Oriented Language (COBOL) programming language.
15. The method of claim 1 , wherein the at least one template comprises one of:
an auto load feature to auto load a specific file;
a create duplicate copy feature, the create duplicate copy feature to generate a backup copy from a dictionary table layout;
a multi-load delete feature;
a template for collecting statistics on columns and upfront optimizations;
a template with a syntax that purges data from a table or another template;
a template including a secondary index that allows storing of data at a particular table or removing data from the particular table;
a template to replace or update a particular template with a new template; and
a template to filter out data.
16. A script generating system comprising:
a server including logic adapted to receive data indicating a selection of a procedure;
wherein, in response to receiving the data, the logic is adapted to:
automatically select at least one template to implement the procedure;
extract table structure information related to the procedure from a database management system dictionary;
manipulate the table structure information; and
automatically incorporate the manipulated table structure information into the at least one template.
17. The system of claim 16 , wherein the logic is further adapted to automatically generate a script to implement the procedure using the at least one template.
18. The system of claim 16 , wherein the table structure information includes a column name, a data type, format data, a default value, a primary index, a secondary index, a column statistic, a view, or any combination thereof.
19. A computer-readable medium including instructions executable by a processor, which when executed cause the processor to:
receive data from a user indicating a selection of a procedure;
automatically select at least one template from a plurality of templates to implement the procedure;
extract table structure information related to the procedure from a database management system dictionary;
convert the table structure information into a file having an alternate language file layout; and
automatically incorporate the converted table structure information in the file into the at least one selected template.
20. The computer-readable medium of claim 19 , further comprising instructions executable by the processor to include a pre-defined template into the plurality of templates.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/870,857 US20080033977A1 (en) | 2003-06-10 | 2007-10-11 | Script generating system and method |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/458,466 US7403934B2 (en) | 2003-06-10 | 2003-06-10 | Script generator for automating system administration operations |
US11/870,857 US20080033977A1 (en) | 2003-06-10 | 2007-10-11 | Script generating system and method |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/458,466 Continuation US7403934B2 (en) | 2003-06-10 | 2003-06-10 | Script generator for automating system administration operations |
Publications (1)
Publication Number | Publication Date |
---|---|
US20080033977A1 true US20080033977A1 (en) | 2008-02-07 |
Family
ID=33510587
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/458,466 Expired - Fee Related US7403934B2 (en) | 2003-06-10 | 2003-06-10 | Script generator for automating system administration operations |
US11/870,857 Abandoned US20080033977A1 (en) | 2003-06-10 | 2007-10-11 | Script generating system and method |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/458,466 Expired - Fee Related US7403934B2 (en) | 2003-06-10 | 2003-06-10 | Script generator for automating system administration operations |
Country Status (1)
Country | Link |
---|---|
US (2) | US7403934B2 (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8060861B2 (en) | 2009-07-27 | 2011-11-15 | Charles Swires | Tool to generate active page interface instructions |
US20120124081A1 (en) * | 2010-11-17 | 2012-05-17 | Verizon Patent And Licensing Inc. | Method and system for providing data migration |
CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
WO2014074998A2 (en) * | 2012-11-12 | 2014-05-15 | EPI-USE Systems, Ltd. | Fast replication of an enterprise system to a remote computing environment |
CN108573015A (en) * | 2017-12-25 | 2018-09-25 | 北京金山云网络技术有限公司 | Change tabular method, apparatus, electronic equipment and readable storage medium storing program for executing |
US10824624B2 (en) | 2018-07-12 | 2020-11-03 | Bank Of America Corporation | System for analyzing, optimizing, and remediating a proposed data query prior to query implementation |
Families Citing this family (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7526557B2 (en) * | 2004-06-30 | 2009-04-28 | Signiant, Inc. | System and method for transferring data in high latency firewalled networks |
US20060291644A1 (en) * | 2005-06-14 | 2006-12-28 | Sbc Knowledge Ventures Lp | Method and apparatus for managing scripts across service centers according to business conditions |
US8051405B2 (en) * | 2006-01-11 | 2011-11-01 | Oracle International Corporation | System and method for build script generation in a software development environment |
US8886564B2 (en) * | 2008-09-16 | 2014-11-11 | Ca, Inc. | Program for resource security in a database management system |
KR101050476B1 (en) * | 2009-12-03 | 2011-07-20 | (주)한국아이오테크 | Storage management server-based script management method and a computer-readable recording medium recording a program for realizing the same |
CN102339219B (en) | 2010-07-20 | 2016-08-24 | 甲骨文国际公司 | For supporting the system and method for object-oriented wscript.exe |
US8930475B1 (en) | 2012-03-30 | 2015-01-06 | Signiant Inc. | Systems and methods for secure cloud-based media file sharing |
US9692799B2 (en) | 2012-07-30 | 2017-06-27 | Signiant Inc. | System and method for sending and/or receiving digital content based on a delivery specification |
CN105760168A (en) * | 2016-02-23 | 2016-07-13 | 深圳竹信科技有限公司 | Automatic code file generation method and system |
CN107688593A (en) * | 2017-04-13 | 2018-02-13 | 平安科技(深圳)有限公司 | Script file generation method and device |
CN108153877B (en) * | 2017-12-26 | 2021-03-12 | 平安科技(深圳)有限公司 | Data dictionary display method and device, terminal equipment and storage medium |
US10735516B1 (en) | 2019-02-15 | 2020-08-04 | Signiant Inc. | Cloud-based authority to enhance point-to-point data transfer with machine learning |
US11281638B2 (en) | 2020-04-22 | 2022-03-22 | Capital One Services, Llc | Consolidating multiple databases into a single or a smaller number of databases |
CN111597654B (en) * | 2020-05-13 | 2023-04-28 | 北京航空航天大学 | Aluminum alloy section vehicle-mounted water tank guardrail optimization design method with complex cross-section shape |
Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6151608A (en) * | 1998-04-07 | 2000-11-21 | Crystallize, Inc. | Method and system for migrating data |
US6421665B1 (en) * | 1998-10-02 | 2002-07-16 | Ncr Corporation | SQL-based data reduction techniques for delivering data to analytic tools |
US20020112094A1 (en) * | 2001-02-15 | 2002-08-15 | Pederson Donald R. | Optimized end transaction processing |
US20020147972A1 (en) * | 2001-01-31 | 2002-10-10 | Olmeda Hector M. | System and method for configuring an application environment on a computer platform |
US6496834B1 (en) * | 2000-12-22 | 2002-12-17 | Ncr Corporation | Method for performing clustering in very large databases |
US20030070119A1 (en) * | 2001-10-10 | 2003-04-10 | Dallin Michael Dean | Method and system for testing a software product |
US20030221162A1 (en) * | 2000-03-20 | 2003-11-27 | Sridhar Mandayam Andampillai | Meta-templates in website development and methods therefor |
US6714928B1 (en) * | 1999-03-19 | 2004-03-30 | Sybase, Inc. | Development system providing HTML database control object |
US6785673B1 (en) * | 2000-02-09 | 2004-08-31 | At&T Corp. | Method for converting relational data into XML |
US6795808B1 (en) * | 2000-10-30 | 2004-09-21 | Koninklijke Philips Electronics N.V. | User interface/entertainment device that simulates personal interaction and charges external database with relevant data |
-
2003
- 2003-06-10 US US10/458,466 patent/US7403934B2/en not_active Expired - Fee Related
-
2007
- 2007-10-11 US US11/870,857 patent/US20080033977A1/en not_active Abandoned
Patent Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6151608A (en) * | 1998-04-07 | 2000-11-21 | Crystallize, Inc. | Method and system for migrating data |
US6421665B1 (en) * | 1998-10-02 | 2002-07-16 | Ncr Corporation | SQL-based data reduction techniques for delivering data to analytic tools |
US6714928B1 (en) * | 1999-03-19 | 2004-03-30 | Sybase, Inc. | Development system providing HTML database control object |
US6785673B1 (en) * | 2000-02-09 | 2004-08-31 | At&T Corp. | Method for converting relational data into XML |
US20030221162A1 (en) * | 2000-03-20 | 2003-11-27 | Sridhar Mandayam Andampillai | Meta-templates in website development and methods therefor |
US6795808B1 (en) * | 2000-10-30 | 2004-09-21 | Koninklijke Philips Electronics N.V. | User interface/entertainment device that simulates personal interaction and charges external database with relevant data |
US6496834B1 (en) * | 2000-12-22 | 2002-12-17 | Ncr Corporation | Method for performing clustering in very large databases |
US20020147972A1 (en) * | 2001-01-31 | 2002-10-10 | Olmeda Hector M. | System and method for configuring an application environment on a computer platform |
US20020112094A1 (en) * | 2001-02-15 | 2002-08-15 | Pederson Donald R. | Optimized end transaction processing |
US20030070119A1 (en) * | 2001-10-10 | 2003-04-10 | Dallin Michael Dean | Method and system for testing a software product |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8060861B2 (en) | 2009-07-27 | 2011-11-15 | Charles Swires | Tool to generate active page interface instructions |
US20120124081A1 (en) * | 2010-11-17 | 2012-05-17 | Verizon Patent And Licensing Inc. | Method and system for providing data migration |
CN103135976A (en) * | 2011-11-30 | 2013-06-05 | 阿里巴巴集团控股有限公司 | Code automatic generation method and device |
WO2014074998A2 (en) * | 2012-11-12 | 2014-05-15 | EPI-USE Systems, Ltd. | Fast replication of an enterprise system to a remote computing environment |
WO2014074998A3 (en) * | 2012-11-12 | 2014-07-03 | EPI-USE Systems, Ltd. | Fast replication of an enterprise system |
CN108573015A (en) * | 2017-12-25 | 2018-09-25 | 北京金山云网络技术有限公司 | Change tabular method, apparatus, electronic equipment and readable storage medium storing program for executing |
US10824624B2 (en) | 2018-07-12 | 2020-11-03 | Bank Of America Corporation | System for analyzing, optimizing, and remediating a proposed data query prior to query implementation |
Also Published As
Publication number | Publication date |
---|---|
US20040254914A1 (en) | 2004-12-16 |
US7403934B2 (en) | 2008-07-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20080033977A1 (en) | Script generating system and method | |
US10970474B2 (en) | Method and system for editing text with a find and replace function leveraging derivations of the find and replace input | |
US6115704A (en) | Extended SQL change definition language for a computer database system | |
US5315709A (en) | Method and apparatus for transforming objects in data models | |
US5455945A (en) | System and method for dynamically displaying entering, and updating data from a database | |
US8676752B2 (en) | Techniques for the log-based replication of high-level procedures | |
US5734887A (en) | Method and apparatus for logical data access to a physical relational database | |
US5432930A (en) | System for accessing cobol data files by generating a dictionary of NF.sup.2 | |
US6185556B1 (en) | Method and apparatus for changing temporal database | |
US5737597A (en) | Method for cataloging datastore characteristics and defining and generating datastore persistent objects | |
US7668888B2 (en) | Converting object structures for search engines | |
CN111367893A (en) | Method and device for database version iteration | |
Hague et al. | Portability—prediction and correction | |
US7529764B2 (en) | GUI for data pipeline | |
KR101908556B1 (en) | A database update system based on spreadsheet interface by finding out updated records automatically | |
US6925630B1 (en) | Method for generating code for processing a database | |
US20040249792A1 (en) | Automated query file conversions upon switching database-access applications | |
Nordeen | Learn SQL in 24 Hours | |
Harrison et al. | Legacy 4GL application migration via knowledge-based software engineering technology: a case study | |
Bhargava et al. | Transition from a relation to object model implementation | |
KR920007947B1 (en) | Data base system realization method | |
Sinclair | From Access to SQL Server | |
Carter et al. | The software architecture of DBLEARN | |
Hutt | A compiler model for a relational data base management system | |
Brill | CodeNotes for Oracle 9i |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: SBC PROPERTIES, L.P., NEVADA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:POLIZZI, NICHOLAS P.;REEL/FRAME:019949/0900 Effective date: 20030603 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |