437 results about "Oracle database" patented technology

The invention relates to a storage and processing method and a system of rail transit monitoring data. The method comprises the steps that centralized monitoring systems are established in a station, an electric service section and a railway management department; a centralized monitoring system of the station acquires various monitoring data; the centralized monitoring system of the electric service section acquires the monitoring data acquired by the centralized monitoring system of the station; an HDFS (Hadoop Distributed File System), an Hbase database, an Oracle database and a MapReduce parallel processing framework are established on a comprehensive operation and maintenance platform to form a cloud computing platform; the monitoring data is stored, analyzed and mined to generate knowledge rule data and various statistical information; and the centralized monitoring system of the railway management department generates and feeds back a dispatch control command to the centralized monitoring system of the electric service section. According to the method and the system, a cloud storage technology and the parallel processing framework are adopted, the storage, analysis and processing efficiency of rail transit resources and data is improved, and the safety and high usability of the data are ensured.

The invention discloses a method for realizing online data migration based on Oracle database, comprising: prebuilt mv,trigger+procedure and trigger+sql*loader+ programs. The three modes comprise using operation log, total refreshment log and incremental refreshment log, and migration change to complete the data migration. By using the prebuilt mv and trigger+procedure programs according to the invention, the cross-platform, and cross-version data migration can be realized; by using the trigger+sql*loader+ program, the conversion among databases of different character sets can be realized by the text file or communication among process, in order to realize cross-character set migration.

The invention, which relates to the intelligent traffic industry, discloses a high efficient and real-time analytical method of vehicle fake license suspicion and an apparatus thereof. According to the invention, all data for fake license analyses are stored in a memory; it is maintained that each vehicle is corresponded to only one record during the processing process and the total amount of the data is controlled; and it is determined whether a vehicle a fake licensed one by calculating whether a time difference of the same vehicle between two checkposts is less than a time threshold between the two checkposts, so that it can be rapidly and accurately determined whether there is fake license suspicion. Because distance between checkposts are various and the speed limits are different, time for driving a distance between each two checkposts is different from others; therefore, the shortest time for passing through the two checkposts can be determined by calculating a time threshold between the two checkposts; and the determination result is more reasonable than an arranged unified global time threshold. Moreover, a memory analytical mode is used to replace a traditional Oracle database query analytical mode; therefore, efficiency is high and operability is strong; and an operation burden of the Oracle database is reduced.

The invention discloses a data consistency verification method based on an Oracle database. The data consistency verification method comprises the following steps: a) pausing the Oracle database copy progress, and enabling the Oracle database to submit all affaires; b) acquiring time stamp information SCN of a source end database; c) checking a target end database and acquiring present time stamp information SCN, restarting the paused Oracle database copy progress, and recovering Oracle database synchronization; and d) under the condition that the time stamp information SCN of the source end database and the target end database is consistent, performing data consistency verification on corresponding lists. By adopting the data consistency verification method based on the Oracle database, the data consistency verification is performed after matched time stamp information is acquired, so that relatively frequent recording can be successfully processed, no any service logic or major key is depended, the verification efficiency is high, the verification speed is high, and the configuration is simple and easy to use.

The invention discloses a database large data volume online migration method based on the oracle. A data pump expdp / impdp tool is utilized to achieve original data migration, and data migration is achieved by using the Oracle goldengate synchronous increment data and conducting data comparison through Oracle verdiata. By means of the method, cross-platform cross-version data migration and large data volume zero shutdown migration are achieved, and the problem of too long shutdown time in the large data migration process is solved. The method ensures data safety in the migration process, and achieves zero risk of data migration.

The invention provides a boiler water wall high-temperature corrosion on-line monitoring device and a method thereof. The device comprises a flue gas sampling pipe, a flue gas analyzer, an industrial computer, a high temperature thermocouple and a monitor. The method comprises the following steps: opening holes of the connection plate between the pipes on the membrane water wall; arranging 1 to 5 layers of measuring points in the height direction of a furnace; sucking flue gas by the flue gas sampling pipe; measuring the concentrations of CO, O2 and SO2 in the flue gas by the flue gas analyzer; and measuring the wall temperature of the wall of the water wall by combining the high temperature thermocouple; and transmitting the measured data to the industrial computer. Meanwhile, the industrial computer receives the data of the primary air speed, the secondary air speed and the air powder concentration of the Oracle database of the MIS system of a power plant, analyzes by modified intangible analytical hierarchy process, calculates the weight of the prior high-temperature corrosion influencing factor, carries out ordering on a real-time basis according to the weight, display the result on the picture of the monitor in a user-friendly manner, and gives a relevant diagnosis suggestion, and requires the line personnel to adjust timely.

The embodiment of the invention provides a source end Oracle database DDL synchronization method and device based on log analysis. The method comprises the following steps of: obtaining a sample; deploying a synchronization system in a source end Oracle database and a target end database. initializing an Oracle system dictionary table, constructing a data type mapping table from a source end Oracle database to a target end database, and reading an Oracle log from the source end Oracle database synchronization system by the source end Oracle database synchronization system; Obtaining DDL operation log information and a transaction number according to the operation code of the Oracle log, collecting a DML operation log according to the log information and the transaction number, and collecting the log; analyzing the collected DDL operation logs and the corresponding DML operation logs; according to the Oracle system dictionary table, restoring the DDL statements, and in combination witha data type mapping table from the source end Oracle database to the target end database, comverting the restored DDL statements into DDL statements suitable for being executed by the target end database to achieve target end database synchronization. According to the embodiment of the invention, the DDL operation can be synchronized between the source end Oracle database and the target end database.

As for the data transfer method based on MAP, adopts a MAP data structure during the data transferring process and configures it using SOID (Standard of Interface Department) syntax after encapsulation; the definition of MAP data structure; one system consists of many matching and individual source ends and target ends, one source end just accesses to its matching target end, and vice versa, all member methods of source and target end adopt MAP structure to transfer data, logic implementation steps are shown as below: data processing of database is the most basic and most featured part of BRS system which adopts SOID syntax, if a table is not simply imported into another Oracle database, it should be treated by another process, that is, generate a derived class directly, and then rewrite “Key process”; data transfer method based on MAP bring excellent compatibility. It nearly supports all kinds of existing platforms, protocols, businesses and manufacturers.

The invention discloses a multi-source heterogeneous spatial data flow method based on an Oracle database. The method comprises the steps of receiving a data request; determining a database node to be accessed through a spatial data index according to the request; reading multi-source heterogeneous data, and conducting spatial data model transformation according to a spatial data conversion module; conducting simple pretreatment on the conversed data; storing the data or storing the data after processing the data. According to the multi-source heterogeneous spatial data flow method based on the Oracle database, mature relational database spatial data storage and spatial database engine technologies are combined, and by building an integrative vector and raster data storage model, optimizing a spatial data retrieval mechanism and integrating spatial data which is distributed and stored in each spatial database, and the data flow of the heterogeneous spatial data is achieved. An Oracle database data driving engine NMSDE is developed based on the multi-source heterogeneous spatial data flow method, and the tests show that both the storage efficiency and inquiring efficiency of the Oracle database data driving engine NMSDE are superior to ArcSDE.

The invention discloses an automatic performance identification tuning system based on an Oracle database, belonging to the technical field of database management. The system comprises a performance acquisition module, a performance analysis module and a performance tuning module and is characterized in that: the performance tuning module comprises an SQL (structured query language) sentence-level tuning module, an instance-level tuning module, a logic object-level tuning module and a system-level tuning module, wherein the SQL sentence-level tuning module, the instance-level tuning module, the logic object-level tuning module and the system-level tuning module in the performance tuning module are connected with the performance analysis module respectively; and the performance analysis module is connected with the performance acquisition module. The system disclosed by the invention has the beneficial effects that: intelligent analysis and tuning on the Oracle database are realized, the traditional optimization method simply using manual and artificial judgment is changed, the DBA is released from the complicated operation and maintenance environment, the operational stability of the database is greatly improved, and the labor cost is saved.

The invention discloses a comprehensive portal management system of dragging type layout configuration. The comprehensive portal management system comprises a front-end portal presentation layer and a back-end module, wherein the front-end portal presentation layer comprises more than two framework units and module elements; the back-end module comprises a presentation layer, a business layer, a lasting layer and an Oracle database; each separated region of the framework unit only can be filled with the module elements; the module elements are arranged in the corresponding separated regions according to the sequence from top to bottom; each module element fully occupies the width of the corresponding separated region; the presentation layer is used for receiving and managing a request of the front-end portal presentation layer and responding the front-end portal presentation layer; the business layer is used for receiving and processing the request and response submitted by the presentation layer; and the comprehensive portal management system comprises processing of processing logic of the comprehensive portal management system and data checking, extraction, conversion and normalization of portal data, and comprehensive treatment of objects, and the Oracle database is used for storing the data of the front-end portal presentation layer.

The invention discloses a cross-platform migrating method and a system for an Oracle database. The method comprises the following steps: collecting source end platform information and database information at a source end, and collecting target end platform information at a target end; comparing the target end platform information with the source end platform information at the source end, and generating a platform difference analysis list between the source end and the target end; employing a migration algorithm to generate a migration guide based on the platform difference analysis list and the source end database information by the source end, and migrating data based on the migration guide; collecting database information recovered in the target end by the target end, comparing the source end database information with the database information recovered in the target end, generating a consistency checking list, determining that the source end database is in consistency with the target end database based on the consistency checking list, then finishing the migration. The cross-platform migrating method for the Oracle database can reduce the workload of the migration and reduce the difficulty of migration.

The invention relates to a method for keeping high availability of an Oracle database service, and discloses an implementation method for keeping the high availability of the Oracle database service. The method comprises the following steps of: distributing virtual Internet protocols (IP) for database nodes; and performing heartbeat detection on the database nodes, judging whether a master database node and a slave database node are alive, when the master database node cannot be accessed, automatically drifting the virtual IP to the slave database node, and switching the identity of the slave database node to be the identity of master database nodes. The invention also discloses a system for keeping the high availability of the Oracle database service. The method and the system are specifically suitable for the DATAGUARD characteristic of the Oracle database; due to combined matching with open source software DRBD and Keepalived, in switchover (planned switchover and lossless switchover) or failover (non-planned switchover and lossy switchover), on the premise that data are not lost, master to slave switching of the database can be realized; and the high availability of the database service can be kept.

The present invention discloses a method for automatically collecting Oracle statistical information, comprising the following steps: (a) designing a database table into a partition table, and dividing the partition table into different statistical collection types according to a service feature; (b) periodically scheduling, by an operating system, a database storage procedure, and an input database table owner, a table name, or a partition name, to perform statistical information collection of different granularities; and (c) in the database storage procedure, searching for a corresponding statistical collection type according to the input database table owner, the table name, or the partition name, and completing statistical information collection of a database table object. According to the method for automatically collecting Oracle statistical information, the database table is designed into a partition table, operations such as addition, modification, and deletion are merely for a current partition or some specific partitions, and query and statistics-collection are separately implemented according to different statistical collection types, so that it is convenient to perform statistical information collection based on a granularity of such as an owner, a table, or a partition, thereby improving running efficiency, stability and service continuity of an Oracle database.

The invention belongs to the technical field of the database, and particularly relates to a data synchronization method. The data synchronization method based on an oracle database comprises the following steps of: exporting business related data by a host, and sending the business related data to a standby machine importing database; scanning a database log on the host; recording data variation to a local log file; compressing and sending the local log file to the standby machine; and after the standby machine receives synchronized data, analyzing into the local log file which is consistent with the host data. When the host fails, the logic states of the host and the standby machine are revised by a control program, and the standby machine replaces the host to continue to work. If the host fails to cause host communication faults, the standby machine is directly operated by the control program to be forcedly switched into the host, so as to continuously support the system to operate. According to the data synchronization method based on the oracle database, which is disclosed by the invention, data synchronization service is independent from a service program, the service program design complexity is lowered, a transmission channel is uniformly managed, and the data synchronization method based on the oracle database is suitable for special requirements, such as the encryption and decryption processing of the data channel.

The invention discloses a medical health data analysis method. With medical service data as a basic data source and through building medical analysis indicators and a theme, corresponding medical health service data are designed and specified; based on an ORACLE database, a data warehouse and a market are designed and built; an SQL language is used to realize data ETL; in combination of a front-end visual presentation mode, theme analysis for all kinds of medical services is further realized; in view of partial sample data, a data analysis report is formed; interfaces and specifications for medical health data are unified, unified management on the medical health data is realized, analysis on main indicators such as outpatient, inpatient, basic drug supervision, basic level medical servicequality and basic level personnel configuration is completed, interconnection and interworking and sharing of information are realized, the medical service level is finally improved, and assistance is provided for relevant decisions.

The invention discloses an electricity customer consumption behavior analysis method and system. The method comprises the steps of periodically obtaining original user electricity related data through a real-time task scheduling technology; data cleaning and data burying point preprocessing are performed on the original user electricity related data through data sedimentation, and processed analysis data is obtained; according to the analysis data, original user electricity data corresponding to abnormal electricity consumption behavior suspicion existence is determined; the original user electricity related data corresponding to abnormal electricity consumption behavior suspicion existence and the analysis data are stored into an Oracle database. The relationships among the big data technology, the internet thinking and customer service, according to the service management requirement, starting from the big data, a data tool is adopted for analysis to obtain a datamation product, the user electricity consumption phenomenon is subjected to multi-dimensional, multi-layer and refined diagram display, the refined electricity marketing service is provided for the user in a personalized customization mode, and aid decision making is provided for consolidating the first-rate service.

The invention relates to uniformly integrated information management platform system. The system comprises uniform information management platform, platform database, central database and file server; the uniform information management platform comprises access layer, presentation layer, application layer, supporting layer and data layer; the access layer is connected with internal user; the presentation layer is connected with the uniform information management platform; the application layer comprises foreground platform and background platform; the supporting layer is connected with user interface, software interface, communication interface and internal interface; the data layer is connected with Oracle database. The advantages of the system: high stability, stable and reliable in system operation with ongoing service; high availability, web model client side, no need of special operation made by the user; high expansibility, distributed modular construction shall be adopted for the design in the system software to allow flexible in alteration setting, convenient to expansion, available to changes in the development of business; Security, the system is characterized by the perfect authority management strategy. Encryption of user name and password is made during the data transmission. Restriction is imposed on the user for the number of repeat operation.

The invention particularly relates to an Oracle database migration tool migrating from an AIX platform to a K-UX platform. According to the Oracle database migration tool migrating from the AIX platform to the K-UX platform, the software architecture of the migration tool based on a JAVA platform is divided into a source end and a target end, wherein the AIX platform is the source end while the K-UX platform is the target end, and the source end is communicated with the target end by virtue of the Ethernet. The Oracle database migration tool migrating from the AIX platform to the K-UX platform is simple and reasonable in structure and realizes migration of the Oracle database from the AIX platform to the K-UX platform, so that the database migration difficulty is extremely reduced, the workload is extremely reduced, the working time is extremely shortened and the work efficiency is extremely improved.

The invention discloses an Oracle database migration tool for carrying out migration from an HP-UX platform to a K-UX platform. The Oracle database migration tool is divided into two parts including a source end and a target end, wherein the source end is installed on the HP-UX server platform, the target end is installed on the K-UX platform, the source end and the target end are communicated through the Ethernet, and the tool can be operated on both the source end and the target end; the source end and the target end scan platform environments where the source end and the target end are independently positioned, and a migration evaluation report and a migration scheme proposal are generated according to a scanning result and a migration algorithm; according to a screening and generation algorithm of the migration scheme proposal by the user, migration wizard is generated, and the cross-platform cross-version semi-automatic migration of the data of the Oracle database from the HP-UX platform to the K-UX platform can be realized through the prompt and the guidance of the migration wizard on the user. Compared with the prior art, the Oracle database migration tool for carrying out the migration from the HP-UX platform to the K-UX platform greatly lowers migration difficulty and workload for migrating the Oracle database to the K-UX platform from the HP-UX platform, provides a guidance function on engineers who implement migration, and has the advantages of being high in practicality and easy in popularization.

The invention discloses a database auditing method and database auditing equipment. Through the technical scheme of the invention, database operating contents can be accurately identified, and a complete database operating action audit (comprising the audit of common structured query language (SQL) statements and the audit of access operation performed on an Oracle database by using an operating module) can be realized; and particularly, the contents of the operation of accessing a database can be identified by the operating module, corresponding database operating contents can be recovered according to corresponding operating modules and are audited, and each kind of operation performed on the database by each user is virtually recovered.

The invention relates to an interface method in the field of electric power system dispatching, in particular to a standard data exchange interface method of a parallel cooperative system. Data transmission between a database in the parallel cooperative system and an external data source is carried out through a data exchange interface; transmitted data adopt standard data formats; standard data adopt power grid data in E-language formats. The standard data exchange interface method comprises the following steps of (1) initializing an Oracle database; (2) reading a file in the E-language format to a memory; (3) copying in a list-to-list way; (4) writing the data to the Oracle database. According to the standard data exchange interface method disclosed by the invention, the problem of importing the data in different formats to the database is solved, and the defects such as manual data conversion and repeated operation which are caused by discrete of a daily traditional mainstream algorithm can be eliminated.

The invention discloses OCI 9-based database access middleware, which belongs to the field of computer application and can be particularly applied in distributed systems for database access. The middleware operating on a database server is developed based on the OCI technology with combination of the network technology and the multi-threading technology, and comprises a middleware operating side, a client side and a remaining record collecting side adopting the client side; wherein the operating side is deployed on a database server, the client side provides a dynamic library or a static library to a progress needing access to a database, and the remaining record collecting side operates in each host needing access to the database in a progress form. The invention can make hosts in the system except the server access the database without the basis of the OCI interface, thereby preventing the uncontrollable long-term blockage, and also solves the problems of the long-term blockage of the client side and the data loss caused by abnormal access to the ORACLE database, or the access of the operating system platform to the database without OCI.

The invention discloses a database synthetic backup and mounting recovery method. The method comprises the steps of describing a synthetic backup principle; performing login registration; performing a backup process; performing conventional recovery; and performing mounting recovery. In synthetic backup, all backups are incremental backups except first full backup, so that a daily backup window is greatly shortened, the space occupied by daily backup is greatly reduced, and the time of backing up all data is greatly shortened; instant recovery can shorten recovery time to a minute level; and the problem of Oracle database backup is solved from the aspects of time, space, efficiency and security.

The invention relates to an auction bidding system based on a distributed non-blocking asynchronous message processing mode and an operation method thereof. The auction bidding system comprises an nginx server, a node server, a Tomcat cluster, a message queue, a bidding logic processing module cluster, and an Oracle database. A user initiates a request through a user terminal, and sends the request to the Tomcat cluster through the nginx server. The Tomcat cluster converts the request into a message, saves the message to the message queue, and gives a feedback to the user for response, wherein the feedback is used to remind the user that the request has been received and is being processed. The bidding logic processing module cluster processes the message in the message queue, and notifies the user of the processing result through the node server.

The invention relates to a mixed storage method for distribution and utilization multi-source heterogeneous data. The method includes the steps that the data type of the distribution and utilization data in a target distribution and utilization data source is judged according to the target distribution and utilization data source; the data extraction mode and data storage mode of the distribution and utilization data in the target distribution and utilization data source are determined according to the data type; the distribution and utilization data in the target distribution and utilization data source are extracted from the target distribution and utilization data source according to the data extraction mode of the distribution and utilization data in the target distribution and utilization data source; the extracted distribution and utilization data are stored according to the data storage mode of the distribution and utilization data in the target distribution and utilization data source; data cleaning and conversion are carried out on the stored distribution and utilization data in various distribution and utilization data sources to obtain cleaning and conversion results, and the cleaning and conversion results are stored in the Oracle database. By adopting the scheme, convenience of reading calculation is ensured while achieving storage of mass distribution and utilization multi-source data.

The invention provides a method for realizing cross-gateway Oracle database synchronization based on CMSP, belonging to the technical field of cross-gateway data synchronization, The method is based on Oracle database and CMSP, including an intranet Oracle database, an outer-net Oracle databse, a first message queue, a second message queue and an network gate, and comprises the following steps: collecting the information of Oracle database in the external network and storing the information in the form of message to the first message queue; A first conversion module is added between the firstmessage queue and the gateway, and a second conversion module is added between the second message queue and the gateway. By utilizing the file exchange function of the gateway, the messages of the first message queue are transmitted to the second message queue through the first conversion module and the second conversion module in an orderly and real-time manner. The intranet Oracle database orderly obtains the collected information of the extranet Oracle database from the second message queue. The method realizes the cross-gateway synchronization of the Oracle database, and ensures the timeliness and efficiency of the Oracle database. The invention also protects a device for realizing cross-gateway Oracle database synchronization based on CMSP.

The invention discloses an oracle database access method applied to an operation and maintenance auditing system. The method comprises the following steps that 1) an administrator logs in the operation and maintenance auditing system to create database assets and generate a configuration file; 2) an operation and maintenance auditing system user logs in the operation and maintenance auditing system to download the configuration file to a configuration directory of an oracle database client; 3) the operation and maintenance auditing system user selects the database assets and logs in the oracle database client; 4) the operation and maintenance auditing system interacts with the oracle database client, and enters an auditing state after the authentication is successful; and 5) when the operation and maintenance auditing system user logs in the oracle database client again, the steps 3) and 4) are repeated. According to the method, the purpose of securely accessing an oracle database is achieved without changing a database access habit of the user; and the user do not need to log in the operation and maintenance auditing system after downloading the configuration file, and performs access directly through the client, so that the working efficiency can be improved.

The invention particularly relates to an Oracle database synchronization system and method based on an SCN mode. The Oracle database synchronization system based on the SCN mode comprises an extraction module, a conversion module and a storage module, the extraction module is arranged in an acquisition front-end processor and is used for extracting the original data of a source Oracle database, and the conversion module and the storage module are arranged in the synchronous server. The conversion module is used for converting the received original data into a standard format, and the storage module is used for writing the standard format data into a target Oracle database. According to the Oracle database synchronization system and method based on the SCN mode, the data synchronization ofthe table structure can be realized, the automatic table building at a destination end, the total data synchronization and the real-time incremental data synchronization are supported, messages are efficiently transmitted by the aid of the CMSP distributed message service, the data transmission efficiency is greatly improved, and the method and the system have a wide application prospect in business scenarios with higher data synchronization requirements.