Stored procedure interface language and tools

• US 7,318,215 B1
• Filed: 02/26/2003
• Issued: 01/08/2008
• Est. Priority Date: 02/26/2003
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Huang, Tao, Krishnan, Murali R.
• Primary Examiner(s): Zhen; Wei
• Assistant Examiner(s): CHOW, CHIH CHING
• Application Number:
  US10/375,851
• Time in Patent Office: 1,777 Days
• Field of Search: 717/106
• US Class Current: 717/106
• CPC Class Codes: G06F 8/20 Software design
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

The present invention relates to systems and methods to generate stored procedure calling code. The invention includes system and methods that utilize annotation(s) included in a stored procedure. The annotations comprise attributes that indicate the intent to have stored procedure calling code generated. After the annotated stored procedure becomes available, the code is compiled and, optionally, checked for errors, and an intermediate definition with metadata is created. The definition is a stored procedure interface language (SPIL) file. The SPIL definition is then utilized to generate high-level, stored procedure calling code, or class libraries. The high level code can then be employed within an application to invoke the stored procedure.

Claims

1. A stored procedure interface language compiler and code generator system comprising:

an annotation extractor that extracts an annotation from an annotated database management system stored procedure, the stored procedure includes at least one annotation;

a stored procedure interface language definition constructor that utilizes the extracted annotation to construct a stored procedure interface language definition of the annotated database management system stored procedure;

a code generator that generates code to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition; and

a library generator that creates a library to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition.

2. The system of claim 1, the annotation comprises an attribute name.

3. The system of claim 2, the annotation further comprises an attribute parameter associated with the attribute name.

4. The system of claim 2, the attribute name is at least one of a method attribute, a class attribute, a rights attribute, a PartitionBy attribute, a PartitionAll attribute, a PartitionAny attribute and a call by identification attribute.

5. The system of claim 1, further comprising a stored procedure interface language definition store that stores the stored procedure interface language definition of the annotated database management system stored procedure.

6. The system of claim 1, further comprising a compile-time checker that performs compile-time error checking of the annotated database management system stored procedure.

7. The system of claim 1, the stored procedure interface language definition declaratively identifies a set of annotated database management system stored procedures.

8. The system of claim 1, the stored procedure interface language definition declaratively identifies a logical grouping of a set of annotated database management system stored procedures.

9. The system of claim 1, the stored procedure interface language definition is XML-based.

10. A stored procedure interface language compiler and code generator system comprising:

an annotation extractor that extracts at least one annotation included in an annotated database management system stored procedure;

a stored procedure interface language definition constructor that utilizes the extracted annotation to create a stored procedure interface language definition of the annotated database management system stored procedure;

a code generator that receives the stored procedure interface language definition, and produces code associated with the stored procedure interface language definition to call the annotated database management system stored procedure; and

a library generator that receives the stored procedure interface language definition, and produces a library associated with the stored procedure interface language definition to call the annotated database management system stored procedure.

11. The system of claim 10, the code generator stores the produced code in a stored procedure generated code store.

12. The system of claim 10, the library generator stores the library in a stored procedure library, the library is a runtime library facilitating calling of the annotated database management system stored procedure.

13. The system of claim 10, the library is associated with at least one of C, C++, C#, Jscript.net, VB.net and Perl.net programming language.

14. The system of claim 10, a plurality of annotated database management system stored procedures are grouped in a class.

15. A stored procedure code generation system comprising:

a computer implemented stored procedure interface language compiler system comprising an annotation extractor that extracts an annotation from an annotated database management system stored procedure, the stored procedure comprises annotated code, and a stored procedure interface language definition constructor that utilizes the extracted annotation to construct a stored procedure interface language definition of the annotated database management system stored procedure; and

a stored procedure interface language generator system comprising a code generator that receives the stored procedure interface language definition of the annotated database management system stored procedure, the stored procedure interface language generator system produces code associated with the stored procedure interface language definition to call the annotated database management system stored procedure; and

a library generator that receives the stored procedure interface language definition of the annotated database management system stored procedure and produces a library associated with the stored procedure interface language definition to call the annotated database management system stored procedure.

16. The system of claim 15, further comprising a server having an annotated database management system stored procedure store that stores the annotated database management system stored procedure.

17. The system of claim 16, the server further comprising a call interface employed to call the annotated database management system stored procedure based, at least in part, upon the produced code associated with the stored procedure interface language definition.

18. A method of providing a stored procedure interface language compilation of an annotated database management system stored procedure comprising:

extracting an annotation from the annotated database management system stored procedure;

utilizing the extracted annotation to construct a stored procedure interface language definition of the annotated database management system stored procedure;

generating code associated with the stored procedure interface language definition to call the annotated database management system stored procedure; and

creating a library associated with the stored procedure interface language definition to call the annotated database management system stored procedure.

19. The method of claim 18, the annotation comprises an attribute name.

20. The method of claim 19, the attribute name is at least one of a method attribute, a class attribute, a rights attribute, a PartitionBy attribute, a PartitionAll attribute, a PartitionAny attribute and a call by identification attribute.

21. The method of claim 18, further comprising at least one of the following acts:

storing the stored procedure interface language definition;

storing the stored procedure interface language definition in a stored procedure interface language definition file; and

performing compile-time error checking of the annotated database management system stored procedure.

22. The method of claim 18, the stored procedure interface language definition declaratively identifies a set of annotated database management system stored procedures.

23. The method of claim 18, the stored procedure interface language definition declaratively identifies a logical grouping of a set of annotated database management system stored procedures.

24. The method of claim 18, the stored procedure interface language definition is XML-based.

25. A method of producing code to call an annotated stored procedure comprising:

extracting an annotation included in an annotated database management system stored procedure;

utilizing the extracted annotation to construct a stored procedure interface language definition of the annotated database management system stored procedure;

producing code to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition of the annotated database management system stored procedure; and

generating a library to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition.

26. The method of claim 25, further comprising at least one of the following acts:

storing the produced code in a stored procedure generated code store; and

storing the library in a database management system stored procedure library.

27. The method of claim 25, the library is associated with at least one of C, C++, C#, Jscript.net, VB.net and Perl.net programming languages.

28. A computer readable medium storing computer executable components of a stored procedure interface language tool set, comprising:

a stored procedure interface language compiler component that comprises an annotation extractor component that extracts an annotation from an annotated database management system stored procedure;

a stored procedure interface language definition constructor component that utilizes the extracted annotation to construct a stored procedure interface language definition of the annotated database management system stored procedure; and

a stored procedure interface language generator component that comprises a code generator component that receives the stored procedure interface language definition of the annotated database management system stored procedure, the stored procedure interface language generator component produces code associated with the stored procedure interface language definition to call the annotated database management system stored procedure; and

a library generator component that receives the stored procedure interface language definition of the annotated database management system stored procedure and produces a library associated with the stored procedure interface language definition to call the annotated database management system stored procedure.

29. A stored procedure interface language tool set comprising:

means for extracting an annotation from an annotated database management system stored procedure;

means for constructing a stored procedure interface language definition utilizing the extracted annotation;

means for generating code to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition; and

means for generating a library to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition.

30. A stored procedure interface invocation system comprising:

a stored procedure interface language compiler system that comprises;

an annotation extractor that extracts an annotation included in an annotated database management system stored procedure; and

a stored procedure interface language definition constructor that utilizes the extracted annotation to construct a stored procedure interface language definition of the annotated database management system stored procedure;

a stored procedure interface language generator that comprises;

a code generator that generates stored procedure calling function code to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition; and

a library generator that generates a library to call the annotated database management system stored procedure based, at least in part, upon the stored procedure interface language definition of the annotated database management system stored procedure interface language definition;

a stored procedure generated code store that saves the generated store procedure calling function code for calling the annotated database management system stored procedure; and

an interface component that facilitates connection management between an application code invoking a generated stored procedure calling function from the stored procedure generated code store and a database management system stored procedure.

31. The system of claim 30, the connection management comprising of at least one of providing a physical connection between the calling function and the database management system stored procedure, providing an enumeration of the physical connection, and executing the database management system stored procedure.

32. The system of claim 31, the enumeration of the physical connection employing one or more enumeration keys that can be accessible to a called database management system stored procedure that is tagged with a physical calling attribute.

33. The system of claim 30, the connection management comprises mitigating the application code from having to obtain knowledge regarding the physical connection.

34. The system of claim 30, the connection management comprises providing a security layer by shielding the application code from access to the actual physical identifier.

35. The system of claim 30, the connection management employs at least one of an off-the-shelf model and a proprietary model to connect to one or more database servers with one or more partitions on the one or more database servers.

36. The system of claim 30, the connection management establishes a connection based at least in part on a supplied parameter combination.