HOME   Cart(0)   Quotation   About-Us Policy PDFs Standard-List
www.ChineseStandard.net Database: 189760 (18 Oct 2025)

HJ 719-2014 English PDF

US$579.00 ยท In stock
Delivery: <= 4 days. True-PDF full-copy in English will be manually translated and delivered via email.
HJ 719-2014: Specification for database access interface of environment information system
Status: Valid
Standard IDContents [version]USDSTEP2[PDF] delivered inStandard Title (Description)StatusPDF
HJ 719-2014English579 Add to Cart 4 days [Need to translate] Specification for database access interface of environment information system Valid HJ 719-2014

Standard similar to HJ 719-2014

HJ 511   HJ 945.3   HJ 943   

Basic data

Standard ID HJ 719-2014 (HJ719-2014)
Description (Translated English) Specification for database access interface of environment information system
Sector / Industry Environmental Protection Industry Standard
Word Count Estimation 22,231
Date of Issue 12/25/2014
Date of Implementation 3/1/2015
Regulation (derived from) Ministry of Environmental Protection notice 2014 No. 87
Issuing agency(ies) Ministry of Ecology and Environment

HJ 719-2014: Specification for database access interface of environment information system

---This is a DRAFT version for illustration, not a final translation. Full copy of true-PDF in English version (including equations, symbols, images, flow-chart, tables, and figures etc.) will be manually/carefully translated upon your order.
Specification for database access interface of environment information system National Environmental Protection Standard of the People 's Republic of China Environmental Information System Database Access Interface Specification 2014-12-25 release 2015-03-01 Implementation Ministry of Environmental Protection Directory Preface ..II 1 Scope of application 1 2 Terms and definitions 1 3 database access interface framework 1 4 database access interface mode 2 5 environment information system database access interface recommended access 6 6 database access conditions 7 Appendix A (informative) Trigger mode Database interface SQL script (MICROSOFT SQL SERVER) 8 Appendix B (Informative Appendix) Trigger Mode Database Interface SQL Script (ORACLE) .13 Appendix C (informative) Timestamp mode Database interface SQL script (MICROSOFT SQL SERVER) .17 Appendix D (informative) Timestamp mode Database interface SQL script (ORACLE) 18 Appendix E (informative) Environmental Information System Database Access Example 19

Foreword

In order to carry out the "Environmental Protection Law of the People's Republic of China", to promote environmental information work, clear relationship database access Interface, to promote the construction of environmental information resources, the development of this standard. This standard specifies the access interface of the relational database in the environment information system, and determines the basic of the database access interface Architecture and database access interface, database access workflow. Appendix A, Appendix B, Appendix C, Appendix D, Appendix E of this standard is an informative appendix. This standard is the first release. This standard is organized by the Ministry of Environmental Protection Science and Technology Standards Division. The main drafting of this standard. the Ministry of Environmental Protection Information Center, Shenzhen Environmental Protection Education and Education Information Center. This standard is approved by the Ministry of Environmental Protection on December 25,.2014. This standard is implemented on March 1,.2015. This standard is explained by the Ministry of Environmental Protection. Environmental Information System Database Access Interface Specification

1 Scope of application

This standard specifies the access interface of the relational database in the environment information system, and determines the basic of the database access interface Architecture and database access interface, database access workflow. This standard applies to the same local area network within the database access, and environmental information system relational database access interface Of the building.

2 terms and definitions

The following terms and definitions apply to this standard. 2.1 environmental information environment information Environmental management, environmental science, environmental technology, environmental protection industry and other environmental protection-related data, instructions and signals Etc., as well as related dynamic change information; including text, numbers, symbols, graphics, images, images and sound and other tables Up to form. 2.2 database database According to the concept of the structure of the organization of the data collection, which describes the characteristics of these data and data corresponding to the relationship between the entities, And support one or more applications. 2.3 database adapter database adapter According to the specified requirements and standard specifications for database access to the functional components, through the configuration file analysis and processing, finished Into a database access, to achieve data collection and exchange. 2.4 database access interface database access interface Embedded in the environmental business database, specifically for external application access to the configuration. Database Access Interface and Adaptation Adapt to the external application of environmental protection services to the contents of the database access. 2.5 stored procedure stored procedure A set of SQL (Structured Query Language) statements to complete a particular function is compiled and compiled In the database. 2.6 trigger trigger Special stored procedures, its implementation is only triggered by the event, such as a database table to insert, delete, update the operation (Insert, delete, update) when it is activated. 2.7 timestamp timestamp Specify the time relative to the general time scale, accurate to the second time of a point in the data item.

3 database access interface framework

In the environment information system data management, the database access interface is used to obtain the database of each business application in the same domain content. On the various business systems to provide a unified database access interface, to facilitate other business applications for data transmission Input or data integration purposes for database access. The environment information system database access interface framework is shown in Fig. Figure 1 environment information system database access interface framework The environmental information system database visitor accesses the different environmental information system databases through the database access interface. data The database visitor interacts with the database access interface embedded in the environmental information system database to obtain the number of environmental service applications The contents of the library.

4 database access interface mode

4.1 Database view mode In the actual business, access to the environmental information system database, the need to customize the data related to its access needs Content, and to ensure the security of the original business data being accessed. A database view is a virtual table that is made from one or several basic tables based on user needs and can provide data for one The logical content of the logic, the data content can be updated with the base table update. At the same time, the user can not change the view And delete, you can guarantee the security of the data. Therefore, the environment information system database for the whole library access, you can use the database view of the access interface. 4.1.1 Interface description According to the visitor's access needs, in the environmental information system database, respectively, create a database view, and the view given Corresponding access. 4.1.2 Interface Configuration Mode Create a view statement using the Environmental Information System database standard. 4.1.3 Workflow The database view works as shown in Figure 2. Figure 2 How the database view works A) the data content of the environmental information system data sheet according to the needs of the visitors, through the database view to create a command to create a phase Should be the database view; B) Visitors access the database view as needed to obtain the required environmental information system data. 4.2 Trigger mode 4.2.1 Description of interface mode Trigger refers to the source database in the business application data table to add a trigger to monitor the data table to add, modify, Delete operation. When the operation is successful, trigger the corresponding trigger to record the primary key and other information into the specified access interface And then the database visitor obtains the change of the business data content from the access interface middle table so as to reach the real When the database is incrementally accessed. 4.2.2 Interface Configuration A) establish an access interface intermediate table in the accessed environmental information system database for storing related triggers And temporary exchange records. The temporary exchange records of different environmental information systems adopt a unified middle table format, including. B) create a stored procedure for accessing the interface intermediate table for performing the associated triggering operations, including. C) for the real-time access to the data table to create new and modify, delete the trigger for triggering operations, including. As the trigger mode is only on the business application data table for operation monitoring, and only access the interface to operate the middle of the table, And therefore will not have any impact on the monitored application data tables. The format of the intermediate table and the stored procedure are described in Appendix A, Appendix B. 4.2.3 Workflow Real-time access to the environmental information system database refers to when the business application data content changes (including new, updated, Delete and other operations), real-time trigger database visitors, the business application database content to access, real-time access to industry Changes in the data. Real-time access to the environment information system database using the trigger mode database access interface, the specific process shown in Figure 3. Figure 3 Database Trigger Access Flow A) Content of the information system data table When the relevant operation is performed, the affected record is pushed directly by the trigger To the middle of the database access interface. If the number of affected records does not exceed the number of fields in the middle table, All information of the affected record is pushed; B) the database visitor obtains the change of the business data content from the access interface intermediate table; C) When the number of recorded fields exceeds the number of fields in the middle table, only the primary key of the affected record is uniquely identified The information is pushed to the middle table. Database visitors can also access services directly based on the data content in the middle table Application data table, access to business application data content. 4.3 Timestamp mode 4.3.1 Interface description Timestamp mode is to configure the time field in the data table, the timing of the database whether the occurrence of new or updated operation, To achieve the role of incremental data synchronization. Use the timestamp of the database visitor to perform the last time with the current data Table in the time field to compare, identify the last time period occurred in the new or update the operation of the database records, from And to achieve the purpose of access to data. 4.3.2 Interface Configuration A) Create a timestamp field for comparison in the accessed environmental information system data table. Create_Time, Update_Time; B) Each accessed environmental information system data table must have two time fields for polling as a timestamp. One for recording creation time and the other for recording modification time. Create_Time, Update_Time. The data type of the timestamp field is the time type of the business application database, and the format must be. (For example..2009-8-20 12.00.00). Each query data table, the table of all the data by time traversal query, remove the latest records. such, If there is too much data in the source database, polling will affect the performance of the exchange. Fill in the timestamp in a variety of ways, such as through the database structure of the query statement (Structure Query Language) Fill in the value, the trigger method automatically fill in the value and so on. It is recommended to establish a trigger mode, automatically get the current operating time and fill Into the corresponding field. Refer to Appendix C, Appendix D for how timestamp triggers are written. 4.3.3 Workflow The regular access of the environmental information system database refers to the database accesses who regularly access the environment according to a predetermined period of time Information system database, and according to the system data table timestamp, access to the last time period of the environmental information system database (Including new, updated, deleted, etc.). Timing access to the environment information system database is usually a timestamped database access interface. The specific process shown in Figure 4. Figure 4 Database Timestamp Timing Access Flow A) service application data table in the new, updated at the same time, update the contents of the timestamp field; B) database visitors regularly access the business application data table, according to the timestamp field recorded by the new and update time Poke, access to the last time period in the business application database changes. 4.4 Application service interface mode Dedicated to the application level database access, it is recommended to use online application service (webservice) interface. 4.4.1 Interface description Through the online application service interface to the environment information database to access the data, in order to obtain the required information. 4.4.2 Interface Configuration Mode The accessed environmental information system, based on the needs of the visitor, specifically develops a set of information that is accessible only to the current environmental information system Online application service software. Developed application service software is installed in the operating environment accessible to the visitor. 4.4.3 Workflow Application service interface shown in Figure 5. Figure 5 Application service interface work A) the visitor invokes the online application service interface when accessing the data in the environmental information system database; B) The application service interface accesses the information system data according to the user's request and feeds the access result to the visitor.

5 environment information system database access interface recommended access

Environmental Information System Database Access According to the access to the environment information data content can be divided into all data access and incremental data access. All environmental information Data access is recommended using the database view of the interface, incremental environmental information data access recommendations Trigger and timestamp interface. See Appendix E for database access. In the application level database access, it is recommended to use the application service interface. Different environmental information systems to take a different database system, the specification for some of the major environmental information system relationship type Database access to explain. Specific recommendations in Table 1. Table 1 Environmental information system recommended database access No. Type of environmental information system recommended access Real - time data triggers river water quality automatic monitoring history data timestamp Real-time Data Trigger Air Quality Automatically monitors historical data timestamps Real-time data triggers Drinking water sources automatically monitor historical data timestamps Real-time Data Trigger Pollution Source Online Monitoring History Data Timestamp Real-time data triggers Motor vehicle tail gas automatically detects historical data timestamps Real - time data trigger radiation environment monitoring history data timestamp Real-time data triggers

1 automatic monitoring class

Hazardous waste online monitoring history data timestamp other Construction Project Management Application Service Interface Sewage license management timestamp Sewage Charge Management Timestamp Environmental Mobile Law Enforcement Management Timestamp Environmental petition complaint management application service interface Administrative penalty management application service interface Document file management trigger

2 business management class

other Environment statistics database view Comprehensive Database of National Comprehensive Environmental Assessment Database Pollution Source Census Database View 3 Statistical Assessment other

6 database access conditions

When accessing a database, in the case of network connectivity, the following conditions are required. A) access to the database management system (DBMS) type; B) obtain the network address of the server where the database being accessed; C) get the instance name of the accessed database; D) Get the user name and password of the database.

Appendix A

(Informative) Trigger Mode Database Interface SQL Script (Microsoft SQL Server) A.1 Trigger Mode The database interface's middle table creation script CREATE TABLE [dbo]. [T_Oth_Msg] ( [PK_MsgId] [numeric] (28, 0) IDENTITY (1,1) NOT NULL, [MsgQueuedAt] [datetime] NOT NULL, [MsgStatus] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL, [MsgDeliveredAt] [datetime] NULL, [MsgFailedText] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [OperationType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam1] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam2] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam3] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam4] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam5] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam6] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam7] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam8] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam9] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, [MsgParam10] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL, ) ON [PRIMARY] GO Table A.1 shows the table field. Table A.1 Field Descriptions Table Field name field Chinese name application meaning PK_MsgId temporary record id primary key of the middle table MsgQueuedAt Temporarily record the time of pushing the time to temporarily record the time from the middle of the table MsgStatus The status of the temporary record identifies whether the temporary record is the information to be pushed MsgDeliveredAt Temporarily record the time to push to the destination Temporarily record the time to push to the destination MsgFailedText Temporarily Record Prompt for Push Failure Message Temporarily Record Details of Push Failure OperationType Temporary record of the operation type of temporary records in the business data table to perform the operation (new, update, delete) MsgParam1 temporary record information temporary records of specific information, from the stored procedure Of the parameter values MsgParam2 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam3 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam4 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam5 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam6 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam7 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam8 temporary record information specific information on temporary records, derived from the stored procedure parameters MsgParam9 temporary record information temporary records of specific information, derived from the stored procedure parameters MsgParam10 temporary record information specific information on temporary records, derived from the stored procedure parameters A.2 Trigger Mode The stored procedure script for the database interface Create proc [dbo]. [P_Trigger_ business application data table name] @OperationType varchar (10), @ MsgParam1 varchar (255) = NULL, @ MsgParam2 varchar (255) = NULL, @ MsgParam3 varchar (255) = NULL, @ MsgParam4 varchar (255) = NULL, @ MsgParam5 varchar (255) = NULL, @ MsgParam6 varchar (255) = NULL, @ MsgParam7 varchar (255) = NULL, @ MsgParam8 varchar (255) = NULL, @ MsgParam9 varchar (255) = NULL, @ MsgParam10 varchar (255) = NULL As BEGIN Declare @ErrorCode int, @ErrorMessage varchar (255), @NumRows int Select @ErrorCode = 0 Insert T_Oth_Msg (MsgQueuedAt, MsgStatus, MsgDeliveredAt, MsgFailedText, OperationType, MsgParam1, MsgParam2, MsgParam3, MsgParam4, MsgParam5, MsgParam6, MsgParam7, MsgParam8, MsgParam9, MsgParam10) select getdate (), 'NEW', NULL, NULL, @ OperationType, @ MsgParam1, @ MsgParam2, @ MsgParam3, @ MsgParam4, @ MsgParam5, @ MsgParam6, @ MsgParam7, @ MsgParam8, @ MsgParam9, @ MsgParam10 Select @ErrorCode = @@ error, @NumRows = @@ rowcount return @ErrorCode END GO See Table A.2 for the description of stored procedure parameters. Table A.2 Stored Procedure Parameters Table Parameter name parameter meaning MsgQueuedAt Temporarily records the time pushed from the middle table MsgStatus identifies whether the temporary record is the information to be pushed MsgDeliveredAt Temporarily records the time to push to the destination MsgFailedText Temporarily records the details of the push failure OperationType temporarily records the operations performed in the business data table (new, update, delete) MsgParam1 specific information about the affected records in the business data sheet MsgParam2 business data table for the affected records of the specific information MsgParam3 specific information about the affected records in the business data sheet MsgParam4 specific information about the affected records in the business data sheet MsgParam5 specific information about the affected records in the business data sheet MsgParam6 specific information about the affected records in the business data sheet MsgParam7 specific information about the affected records in the business data sheet MsgParam8 specific information about the affected records in the business data sheet MsgParam9 specific information about the affected records in the business data sheet MsgParam10 sp...

Tips & Frequently Asked Questions:

Question 1: How long will the true-PDF of HJ 719-2014_English be delivered?

Answer: Upon your order, we will start to translate HJ 719-2014_English as soon as possible, and keep you informed of the progress. The lead time is typically 2 ~ 4 working days. The lengthier the document the longer the lead time.

Question 2: Can I share the purchased PDF of HJ 719-2014_English with my colleagues?

Answer: Yes. The purchased PDF of HJ 719-2014_English will be deemed to be sold to your employer/organization who actually pays for it, including your colleagues and your employer's intranet.

Question 3: Does the price include tax/VAT?

Answer: Yes. Our tax invoice, downloaded/delivered in 9 seconds, includes all tax/VAT and complies with 100+ countries' tax regulations (tax exempted in 100+ countries) -- See Avoidance of Double Taxation Agreements (DTAs): List of DTAs signed between Singapore and 100+ countries

Question 4: Do you accept my currency other than USD?

Answer: Yes. If you need your currency to be printed on the invoice, please write an email to [email protected]. In 2 working-hours, we will create a special link for you to pay in any currencies. Otherwise, follow the normal steps: Add to Cart -- Checkout -- Select your currency to pay.