AU2001236686A1 - Selectively auditing accesses to rows within a relational database at a database server - Google Patents
Selectively auditing accesses to rows within a relational database at a database serverInfo
- Publication number
- AU2001236686A1 AU2001236686A1 AU2001236686A AU2001236686A AU2001236686A1 AU 2001236686 A1 AU2001236686 A1 AU 2001236686A1 AU 2001236686 A AU2001236686 A AU 2001236686A AU 2001236686 A AU2001236686 A AU 2001236686A AU 2001236686 A1 AU2001236686 A1 AU 2001236686A1
- Authority
- AU
- Australia
- Prior art keywords
- query
- auditing
- audit record
- condition
- computer
- 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
Links
Description
SELECTIVELY AUDITING ACCESSES TO ROWS
WITHIN A RELATIONAL DATABASE AT A
DATABASE SERVER
Inventor(s): Daniel ManHung Wong, Chon Hei Lei and Patrick F. Sack
BACKGROUND
Field of the Invention
The present invention relates to providing security in computerized databases. More specifically, the present invention relates to a method and an apparatus for selectively auditing accesses to relational database tables based upon auditing conditions.
Related Art
Databases commonly store highly sensitive data, such as salaries, corporate financial data, and even classified military secrets. For security reasons it is essential to be able to audit accesses to this sensitive data. Conventional database systems typically provide a general auditing facility that records an audit trail containing general information about the user and the query issued.
However, conventional auditing facilities have a number of shortcomings. They do not record specific information about the application, the session environment or most importantly, the query results. Consequently, information gathered by a conventional auditing facility is frequently insufficient to reconstruct an event, or even to determine whether access rights have been violated.
In conventional relational database systems, auditing facilities only record information regarding which tables are accessed, not whether certain rows inside a given table are accessed. This table-level auditing tends to generate a large number of
false audit records because many accesses to a given table do not touch sensitive data.
What is needed is an auditing mechanism that can specify a finer granularity of audit conditions during accesses to relational tables in order to minimize the number of false audit records that are generated.
Another problem in auditing database accesses arises in distributed database architectures, in which an application located on an application server sends a query to a database located on a database server. In this type of distributed architecture, auditing is typically performed by embedding customized auditing mechanisms into the application on the applications server, not at the database server. Relying on the application to perform auditing can give rise to many problems because a large number of applications can potentially access the database. Consequently, it is almost impossible to ensure that each one of these applications is configured to perform the auditing properly. What is needed is an auditing mechanism for database accesses which does not rely on applications outside of the database server to perform auditing.
SUMMARY
One embodiment of the present invention provides a system that selectively audits accesses to a relational database system. This system starts by receiving a query from a client at a database server. The system processes this query at the database server to produce a query result. The system also creates an audit record for rows in relational tables that are accessed by the query, and that satisfy an auditing condition. Next, the system records the audit record in an audit record store and returns the query result to the client. Integrating the auditing facility into the relational database system in this manner ensures that auditing is performed in the same way regardless of which application generates the query. Furthermore, this auditing is transparent to applications and users.
In one embodiment of the present invention, the system additionally modifies the query so that processing the query causes the audit record to be created and recorded for rows in relational tables that are accessed by the query and that satisfy the
auditing condition. In a variation on this embodiment, the auditing condition is associated with a table in the relational database system.
In one embodiment of the present invention, the auditing condition includes a plurality of auditing conditions. In one embodiment of the present invention, the audit record includes a user name for a user making the query, a time stamp specifying a time of the query, and a text of the query.
In one embodiment of the present invention, the system determines if auditing is enabled, and if so, creates the audit record. In one embodiment of the present invention, auditing is enabled on a table by table basis.
In one embodiment of the present invention, the audit record is created while the query result is being generated.
In one embodiment of the present invention, the audit record is created after the query result is generated.
In one embodiment of the present invention, the auditing condition includes a condition for a field within the relational database system.
BRIEF DESCRIPTION OF THE FIGURES FIG. 1 illustrates a distributed computing system in accordance with an embodiment of the present invention.
FIG. 2 illustrates a table within a relational database in accordance with an embodiment of the present invention.
FIG. 3 is a flow chart illustrating the process of auditing a query in accordance with an embodiment of the present invention.
FIG. 4 is a flow chart illustrating the process of reforming a query for auditing purposes in accordance with an embodiment of the present invention.
DETAILED DESCRIPTION The following description is presented to enable any person skilled in the art to make and use the invention, and is provided in the context of a particular application and its requirements. Various modifications to the disclosed embodiments will be
readily apparent to those skilled in the art, and the general principles defined herein may be applied to other embodiments and applications without departing from the spirit and scope of the present invention. Thus, the present invention is not intended to be limited to the embodiments shown, but is to be accorded the widest scope consistent with the principles and features disclosed herein.
The data structures and code described in this detailed description are typically stored on a computer readable storage medium, which may be any device or medium that can store code and/or data for use by a computer system. This includes, but is not limited to, magnetic and optical storage devices such as disk drives, magnetic tape, CDs (compact discs) and DVDs (digital video discs), and computer instruction signals embodied in a transmission medium (with or without a carrier wave upon which the signals are modulated). For example, the transmission medium may include a communications network, such as the Internet.
Distributed Computing System
FIG. 1 illustrates a distributed computing system 100 in accordance with an embodiment of the present invention. Distributed computing system 100 includes a number of computer systems (nodes), including clients 102-104, application server 108 and database server 1 10. Computer systems 102-104, 108 and 1 10 can generally include any type of computer system, including, but not limited to, a computer system based on a microprocessor, a mainframe computer, a digital signal processor, a personal organizer, a device controller, and a computational engine within an appliance.
Computer systems 102-104, 108 and 110 are coupled together by a computer network (not shown). This computer network can include any type of wire or wireless communication channel capable of coupling together computing nodes. This includes, but is not limited to, a local area network, a wide area network, or a combination of networks. In one embodiment of the present invention, this network includes the Internet. Clients 102-104 can include any node on a network including computational capability and including a mechanism for communicating across the network. In the embodiment of the present invention illustrated in FIG. 1, clients 102-104
communicate with application 107 located on application server 108. Application 107 in turn communicates with relational database 109 on database server 110.
Application server 108 and database server 110 can include any node on a computer network including a mechanism for servicing requests from a client for computational and/or data storage resources. Note that application server 108 serves as a client for database server 110.
Database server 110 contains relational database 109. Relational database 109 can generally include any type of database system designed around relation tables.
Within relational database 109 there exist a number of mechanisms, including query processor 120 and auditing mechanism 122. Query processor 120 operates on a number of relational tables 113, including table 1 14 and table 116. Auditing mechanism 122 records audit records to audit record store 118.
Note that tables 113 and audit record store 113 reside on storage device 112, which is controlled by database server 110. Storage device 112 can include any type of non-volatile storage device, such as non- volatile storage devices based on magnetic, optical and/or magneto-optical storage devices. Storage device 1 12 can also include non-volatile semiconductor storage devices based on flash memory or battery-backed up random access memory. Note that copies of selected portions of tables 113 and audit record store 118 can also exist within memory in database server 110.
Table Structure
FIG. 2 illustrates the structure of table 114 within relational database 119 in accordance with an embodiment of the present invention. Table 114 has the same structure as a typical table in a relational database, including a number of rows containing various fields.
Table 114 also includes a row-level auditing flag 206 which indicates whether auditing is enabled for the table. In another embodiment of the present invention, the system includes a database-wide row-level auditing flag, which enables row-level auditing for the entire relational database 109.
Table 114 is additionally associated with a number of auditing conditions, including auditing condition 202 "salary > 1,000,000" and auditing condition 204
"title = 'CEO'". Auditing conditions 202 and 204 instruct relational database 109 to create an audit record for any rows that are accessed within table 114 that include a salary field with a value greater than 1,000,000, or that include a title field specifying a CEO. Accesses to other rows in table 1 14 that do not satisfy either of these auditing conditions do not cause an audit record to be generated.
Process of Auditing a Query
FIG. 3 is a flow chart illustrating the process of auditing a query in accordance with an embodiment of the present invention. The system starts by receiving a query 123 at relational database 109 within database server 110 from application 107 within application server 108 (step 302).
The system first determines if auditing is enabled by checking all tables referenced by the query to see if an auditing flag is set for the tables (step 303). If auditing is not enabled, the system processes query 123 as usual to produce a query result 124 (step 305), and then returns query result 124 (step 314).
If auditing is enabled, the system modifies the query by inserting monitoring logic into query 123 (step 304). This monitoring logic causes an audit record to be created and recorded for any rows that satisfy an auditing condition.
In one embodiment of the present invention, query 123 is modified by inserting statements into query 123 to make query 123 call a function that creates and records auditing records if a row in a table satisfies the auditing conditions.
In another embodiment of the present invention, modifying query 123 involves creating two separate queries. A first query additionally includes restrictions based on the auditing conditions. This query produces audit records only for rows that satisfy the auditing conditions. A second query is unmodified from the initial query and is used to produce the query result.
In one embodiment of the present invention, the auditing condition is specified for the entire relational database 109. In another embodiment, the auditing condition is specified on a table-by-table basis. Next, the optimization layer performs view merging (step 305), and the system processes query 123 to produce the query result 124 (step 306). In doing so, the system creates an audit record for rows that are accessed by query 123 and that satisfy
the auditing condition (step 310). Alternatively, the audit record can be produced by running a second query at a later time to produce the audit record.
Note that the audit record includes a user name for a user making the query, a time stamp specifying a time of the query, a text of the query and specific variable bindings for the query.
The system then records the audit record in audit record store 118 (step 312) and then returns the query result 124 to application 107 (step 314).
Process of Reforming a Query FIG. 4 is a flow chart illustrating the process of reforming a query for auditing purposes in accordance with an embodiment of the present invention. The system starts by receiving a query 123 at relational database 109 (step 402). The system next retrieves any auditing conditions that might exist for tables involved in query 123, such as auditing conditions 202 and 204 associated with table 1 14 (step 404). If query 123 includes a statement that modifies a table within relational database 109, such as a delete statement, an insert statement or an update statement, the system uses pre-existing triggers in the database system to create audit records for these statements (step 405). Note that a database system generally maintains a log of changes to database tables, so providing an auditing mechanism for these changes in addition to the log may be unnecessary. The system then processes query 123 to produce query result 124 (step 418).
If query 123 includes a select statement, the system appends a case statement to query 123 for each auditing condition using a view expansion mechanism (step 406). For example, suppose that the auditing condition is DEPT = 'SALES' and that query 123 is,
SELECT * FROM payroll WHERE salary> 150,000;
The system appends a case statement to the select statement as follows.
SELECT * FROM (
SELECT * FROM payroll
WHERE (CASE WHEN (dept= 'sales') THEN SYS_AUDIT()
ELSE NOT NULL END) IS NOT NULL;
) WHERE salary > 150,000
In this example, the case statement will cause the SYS_AUDIT() function to be called if the auditing condition is satisfied. This SYS_AUDIT() function causes an audit record to be created and recorded. Note that the function S YS_AUDIT() always returns NOT NULL (unless an error condition arises within SYS_AUDIT()). Therefore the predicate is always evaluated as TRUE. Hence, the predicate does not affect the logic of query 123, and the predicate can be safely applied to query 123.
Next, the query processor is allowed to allocate buffers for query 123 (step 408). After the buffers are allocated, the system removes the case statement from query 123 (step 410). In one embodiment of the present invention, this involves moving a query filter list data structure that refers to the predicate to a temporary location in the query block data structure that contains all the meta-information for query 123. Moving the predicate in this way prevents the optimizer from reorganizing the CASE clause and query plan layer to allocate row source for the CASE clause.
After optimization, the system generates a query plan for query 123 to specify an order in which the operations involved in query 123 are carried out (step 412).
After the query plan is generated (but before generating the execution plan for any "GROUP BY" clause that may exist) the system generates an execution plan for the case statement so that the case statement is evaluated only for rows that satisfy all the preceding conditions in query 123 (step 414). In this way, an audit record is created only for rows are accessed by query 123.
Next, the system processes query 123 to produce query result 124 (step 418). This causes an audit record to be created (step 420) and recorded (step 422) for each row that satisfies the conditions of query 123 as well as the auditing conditions.
Finally, the system returns query result 124 to the entity that issued query 123 (step 424).
The foregoing descriptions of embodiments of the invention have been presented for purposes of illustration and description only. They are not intended to be exhaustive or to limit the present invention to the forms disclosed. Accordingly, many modifications and variations will be apparent to practitioners skilled in the art. Additionally, the above disclosure is not intended to limit the present invention. The scope of the present invention is defined by the appended claims.
Claims
1. A method for selectively auditing accesses to a relational database system, comprising: receiving a query from a client at a database server that processes queries for the relational database system; processing the query at the database server to produce a query result; creating an audit record for rows in relational tables that are accessed by the query and that satisfy an auditing condition; recording the audit record in an audit record store; and returning the query result to the client.
2. The method of claim 1 , further comprising modifying the query prior to processing the query, so that processing the query causes the audit record to be created and recorded for rows in relational tables that are accessed by the query and that satisfy the auditing condition.
3. The method of claim 1, wherein the auditing condition is associated with a table in the relational database system.
4. The method of claim 1, wherein the auditing condition includes a plurality of auditing conditions.
5. The method of claim 1, wherein the audit record includes: a user name for a user making the query; a time stamp specifying a time of the query; and a text of the query.
6. The method of claim 1 , wherein creating the audit record includes: determining if auditing is enabled; and creating the audit record if auditing is enabled.
7. The method of claim 6, wherein auditing is enabled on a table by table basis.
8. The method of claim 1 , wherein the audit record is created while the query result is being generated.
9. The method of claim 1, wherein the audit record is created after the query result is generated.
10. The method of claim 1 , wherein the auditing condition includes a condition for a field within the relational database system.
11. A computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method for selectively auditing accesses to a relational database system, the method comprising: receiving a query from a client at a database server that processes queries for the relational database system; processing the query at the database server to produce a query result; creating an audit record for rows in relational tables that are accessed by the query and that satisfy an auditing condition; recording the audit record in an audit record store; and returning the query result to the client.
12. The computer-readable storage medium of claim 11, wherein the method further comprises modifying the query prior to processing the query, so that processing the query causes the audit record to be created and recorded for rows in relational tables that are accessed by the query and that satisfy the auditing condition.
13. The computer-readable storage medium of claim 11 , wherein the auditing condition is associated with a table in the relational database system.
14. The computer-readable storage medium of claim 11 , wherein the auditing condition includes a plurality of auditing conditions.
15. The computer-readable storage medium of claim 11 , wherein the audit record includes: a user name for a user making the query; a time stamp specifying a time of the query; and a text of the query.
16. The computer-readable storage medium of claim 11, wherein creating the audit record includes: determining if auditing is enabled; and creating the audit record if auditing is enabled.
17. The computer-readable storage medium of claim 16, wherein auditing is enabled on a table by table basis.
18. The computer-readable storage medium of claim 1 1 , wherein the audit record is created while the query result is being generated.
19. The computer-readable storage medium of claim 11 , wherein the audit record is created after the query result is generated.
20. The computer-readable storage medium of claim 11, wherein the auditing condition includes a condition for a field within the relational database system.
21. An apparatus that selectively audits accesses to a relational database system, comprising: a database server; a receiving mechanism, at the database server, that is configured to receive a query from a client; a query processor that is configured to process the query at the database server to produce a query result; an auditing mechanism that is configured to, create an audit record for rows in relational tables that are accessed by the query and that satisfy an auditing condition, and to record the audit record in an audit record store; and a returning mechanism that returns the query result to the client.
22. The apparatus of claim 21 , further comprising a query modification mechanism that is configured to modify the query prior to processing the query, so that processing the query causes the audit record to be created and recorded for rows in relational tables that are accessed by the query and that satisfy the auditing condition.
23. The apparatus of claim 21 , wherein the auditing condition is associated with a table in the relational database system.
24. The apparatus of claim 21 , wherein the auditing condition includes a plurality of auditing conditions.
25. The apparatus of claim 21, wherein the audit record includes: a user name for a user making the query; a time stamp specifying a time of the query; and a text of the query.
26. The apparatus of claim 21 , wherein the auditing mechanism is configured to: determine if auditing is enabled; and to create the audit record if auditing is enabled.
27. The apparatus of claim 26, wherein the auditing mechanism is configured to enable auditing on a table by table basis.
28. The apparatus of claim 21, wherein the auditing mechanism is configured to create the audit record while the query result is being generated.
29. The apparatus of claim 21, wherein the auditing mechanism is configured to create the audit record after the query result is generated.
30. The apparatus of claim 21, wherein the auditing condition includes a condition for a field within the relational database system.
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US09/559,171 US7117197B1 (en) | 2000-04-26 | 2000-04-26 | Selectively auditing accesses to rows within a relational database at a database server |
| US09/559,171 | 2000-04-26 | ||
| PCT/US2001/003750 WO2001082118A2 (en) | 2000-04-26 | 2001-02-05 | Selectively auditing accesses to rows within a relational database at a database server |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| AU2001236686A1 true AU2001236686A1 (en) | 2002-01-24 |
| AU2001236686B2 AU2001236686B2 (en) | 2005-12-08 |
Family
ID=24232561
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| AU3668601A Pending AU3668601A (en) | 2000-04-26 | 2001-02-05 | Selectively auditing accesses to rows within a relational database at a databaseserver |
| AU2001236686A Expired AU2001236686B2 (en) | 2000-04-26 | 2001-02-05 | Selectively auditing accesses to rows within a relational database at a database server |
Family Applications Before (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| AU3668601A Pending AU3668601A (en) | 2000-04-26 | 2001-02-05 | Selectively auditing accesses to rows within a relational database at a databaseserver |
Country Status (6)
| Country | Link |
|---|---|
| US (1) | US7117197B1 (en) |
| EP (1) | EP1421515B1 (en) |
| JP (1) | JP4716635B2 (en) |
| AU (2) | AU3668601A (en) |
| CA (1) | CA2406908C (en) |
| WO (1) | WO2001082118A2 (en) |
Families Citing this family (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7281003B2 (en) * | 1998-10-05 | 2007-10-09 | Oracle International Corporation | Database fine-grained access control |
| US7693541B1 (en) | 2001-07-20 | 2010-04-06 | Oracle International Corporation | Multimodal session support on distinct multi channel protocol |
| US7873660B1 (en) * | 2003-02-27 | 2011-01-18 | Oracle International Corporation | Enforcing data privacy aggregations |
| JP2004318288A (en) * | 2003-04-11 | 2004-11-11 | Hitachi Ltd | Data processing method and apparatus and processing program thereof |
| US7310647B2 (en) * | 2003-12-24 | 2007-12-18 | Oracle International Corporation | Column masking of tables |
| US7346617B2 (en) * | 2004-01-23 | 2008-03-18 | Oracle International Corporation | Multi-table access control |
| US8825702B2 (en) * | 2004-02-24 | 2014-09-02 | Oracle International Corporation | Sending control information with database statement |
| US7774305B2 (en) | 2004-03-15 | 2010-08-10 | Ramco Systems Limited | System and method for auditing enterprise data |
| US7373554B2 (en) * | 2004-09-24 | 2008-05-13 | Oracle International Corporation | Techniques for automatic software error diagnostics and correction |
| US7650367B2 (en) * | 2006-01-13 | 2010-01-19 | Tekelec | Methods, systems, and computer program products for detecting and restoring missing or corrupted data in a distributed, scalable, redundant measurement platform database |
| JP2008293153A (en) * | 2007-05-23 | 2008-12-04 | Hitachi Ltd | Audit trail management method and system, and processing program therefor |
| US20090024570A1 (en) * | 2007-07-20 | 2009-01-22 | Oracle Internatonal Corporation | User defined query rewrite mechanism |
| US8239396B2 (en) * | 2009-03-20 | 2012-08-07 | Oracle International Corporation | View mechanism for data security, privacy and utilization |
| US20120110011A1 (en) * | 2010-10-29 | 2012-05-03 | Ihc Intellectual Asset Management, Llc | Managing application access on a computing device |
| US10210175B2 (en) | 2012-09-28 | 2019-02-19 | Oracle International Corporation | Techniques for lifecycle state management and in-database archiving |
| US9405788B2 (en) | 2014-01-24 | 2016-08-02 | International Business Machines Corporation | Mass delete restriction in a database |
| US9959285B2 (en) | 2014-08-08 | 2018-05-01 | International Business Machines Corporation | Restricting sensitive query results in information management platforms |
| US9755925B2 (en) | 2014-09-15 | 2017-09-05 | Oracle International Corporation | Event driven metric data collection optimization |
| US10324819B1 (en) | 2018-01-22 | 2019-06-18 | Oracle International Corporation | Runtime performance introspection |
| KR102127522B1 (en) * | 2018-06-20 | 2020-06-26 | 주식회사 티맥스티베로 | Computer program stored in computer readable medium, database server and audit performing server |
| US11275669B2 (en) * | 2020-07-09 | 2022-03-15 | Pensando Systems, Inc. | Methods and systems for hardware-based statistics management using a general purpose memory |
| CN113010494B (en) * | 2021-03-18 | 2025-05-02 | 北京金山云网络技术有限公司 | A database audit method, device and database proxy server |
| CN113420007B (en) * | 2021-03-31 | 2023-09-26 | 阿里巴巴新加坡控股有限公司 | Audit processing method and device for database access and electronic equipment |
| CN115455154A (en) * | 2022-10-18 | 2022-12-09 | 北京人大金仓信息技术股份有限公司 | Database auditing method, machine-readable storage medium and computer equipment |
Family Cites Families (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5519859A (en) * | 1993-11-15 | 1996-05-21 | Grace; John A. | Method and apparatus for automatic table selection and generation of structured query language instructions |
| CA2167790A1 (en) * | 1995-01-23 | 1996-07-24 | Donald S. Maier | Relational database system and method with high data availability during table data restructuring |
| US5794252A (en) * | 1995-01-24 | 1998-08-11 | Tandem Computers, Inc. | Remote duplicate database facility featuring safe master audit trail (safeMAT) checkpointing |
| US5799323A (en) * | 1995-01-24 | 1998-08-25 | Tandem Computers, Inc. | Remote duplicate databased facility with triple contingency protection |
| JP2773682B2 (en) * | 1995-05-26 | 1998-07-09 | 日本電気株式会社 | Applicable feedback device |
| JPH0954714A (en) * | 1995-08-11 | 1997-02-25 | Omron Corp | Device and method for conversion of processing instruction |
| US6023509A (en) | 1996-09-30 | 2000-02-08 | Intel Corporation | Digital signature purpose encoding |
| US6041310A (en) * | 1996-12-12 | 2000-03-21 | Green Ford, Inc. | Method and system for automobile transactions |
| JP3709510B2 (en) * | 1997-02-27 | 2005-10-26 | 株式会社日立製作所 | Relational database management method and relational database system |
| AU742717B2 (en) | 1997-09-02 | 2002-01-10 | Cyber Sign Japan Inc. | Digital signature generating server and digital signature generating method |
| KR980004126A (en) * | 1997-12-16 | 1998-03-30 | 양승택 | Query Language Conversion Apparatus and Method for Searching Multilingual Web Documents |
| US6351753B1 (en) * | 1998-02-20 | 2002-02-26 | At&T Corp. | Method and apparatus for asynchronous version advancement in a three version database |
| US6151608A (en) * | 1998-04-07 | 2000-11-21 | Crystallize, Inc. | Method and system for migrating data |
| US6275824B1 (en) * | 1998-10-02 | 2001-08-14 | Ncr Corporation | System and method for managing data privacy in a database management system |
| US6553392B1 (en) * | 1999-02-04 | 2003-04-22 | Hewlett-Packard Development Company, L.P. | System and method for purging database update image files after completion of associated transactions |
| US6584477B1 (en) * | 1999-02-04 | 2003-06-24 | Hewlett Packard Development Company, L.P. | High speed system and method for replicating a large database at a remote location |
| US20030014394A1 (en) | 2001-03-22 | 2003-01-16 | Shinji Fujiwara | Cell-level data access control using user-defined functions |
| JP4772291B2 (en) * | 2004-04-09 | 2011-09-14 | 富士通株式会社 | Information processing device with security function |
-
2000
- 2000-04-26 US US09/559,171 patent/US7117197B1/en not_active Expired - Lifetime
-
2001
- 2001-02-05 WO PCT/US2001/003750 patent/WO2001082118A2/en not_active Ceased
- 2001-02-05 EP EP01908864.0A patent/EP1421515B1/en not_active Expired - Lifetime
- 2001-02-05 JP JP2001579137A patent/JP4716635B2/en not_active Expired - Lifetime
- 2001-02-05 AU AU3668601A patent/AU3668601A/en active Pending
- 2001-02-05 CA CA2406908A patent/CA2406908C/en not_active Expired - Lifetime
- 2001-02-05 AU AU2001236686A patent/AU2001236686B2/en not_active Expired
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2406908C (en) | Selectively auditing accesses to rows within a relational database at a database server | |
| AU2001236686A1 (en) | Selectively auditing accesses to rows within a relational database at a database server | |
| US6952692B1 (en) | Execution of requests in a parallel database system | |
| US6772155B1 (en) | Looking data in a database system | |
| US6370530B1 (en) | Computer program product for functional compensation in a heterogeneous, distributed database environment | |
| US5857182A (en) | Database management system, method and program for supporting the mutation of a composite object without read/write and write/write conflicts | |
| US6564215B1 (en) | Update support in database content management | |
| US5930793A (en) | Performance optimization in a heterogeneous, distributed database environment | |
| US6321235B1 (en) | Global caching and sharing of SQL statements in a heterogeneous application environment | |
| US6029160A (en) | Method and means for linking a database system with a system for filing data | |
| US7698253B2 (en) | Method and system for reducing host variable impact on access path selection | |
| US7188116B2 (en) | Method and apparatus for deleting data in a database | |
| US7480653B2 (en) | System and method for selective partition locking | |
| US6938044B1 (en) | Tracking usage of resources of a database system | |
| US7127448B1 (en) | Reforming queries to selectively audit accesses to rows within a relational database | |
| US6757690B2 (en) | Method and system for monitoring and securing data access in a database system | |
| US9747328B2 (en) | Method and apparatus for modifying a row in a database table to include meta-data | |
| US6768985B1 (en) | Method and apparatus for administration of database partitions | |
| US7139690B2 (en) | Object-level conflict detection in an object-relational database system | |
| US6704753B1 (en) | Method of storage management in document databases | |
| US20050246385A1 (en) | Database-rearranging program, database-rearranging method, and database-rearranging apparatus | |
| US7260849B1 (en) | Providing security in a database system | |
| US7904419B1 (en) | Managing allocation of temporary and permanent files in a database system | |
| CA2249066C (en) | Sharing of dynamic sql statements in a heterogeneous application environment | |
| Oftedal et al. | Data base design constrained by traffic load estimates |